摘要：
<XmlCommand Name="fy_MobileExpenseMng_GetMobileExpenses"> <Parameters> <Parameter Name="@StartNum" Type="Int32" /> <Parameter Name="@EndNum" Type="Int 阅读全文
摘要：
-- --开始执行，递归查出该末级科目及所有上级科目 WITH TEMP AS ( SELECT fy_cost.CostGUID,fy_cost.ParentGUID FROM fy_cost WITH (NOLOCK) WHERE CostGUID IN ('dff10db2-de87-4b5a 阅读全文
摘要：
--开始更新 UPDATE a SET a.ProviderTypeNames=b.ProviderTypeNameList FROM fy_Provider a INNER JOIN [IP2].[数据库名].dbo.p_Provider b ON a.ProviderGUID=b.Provide 阅读全文
摘要：
--备份报销推送记录表 DECLARE @ctime NVARCHAR(36) = '2022-06-13 00:42:26' IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[p_Provider2B 阅读全文
摘要：
CASE WHEN fy_Contract.IsForeignCurrencyEnabled=1 THEN '是' ELSE '否' end IsForeignCurrencyEnabled,--as 是否外币CASE x_fy_Income.x_ApproveMode WHEN 1 THEN '线 阅读全文
摘要：
using System.ComponentModel.DataAnnotations; /// <summary> /// 自定义实体类 /// </summary> public class DATAINFO { /// <summary> /// 员工号 入职年月（YYYYMM）+4位流水 / 阅读全文
摘要：
select A.*,B.x_UserGuid from ( select count(CreatedGUID) ss ,max(CreatedTime) maxdate,CreatedGUID from x_myUserExt group by CreatedGUID) Aleft join x_ 阅读全文
摘要：
SELECT STUFF((SELECT ','+x_SourceType FROM x_fy_ContractSource WHERE x_fy_ContractSource.x_ContractGUID='20f5a958-a79a-4d90-fe8d-08d948d27530' for xml 阅读全文
摘要：
/// <summary> /// 补0拼接，进行新编号拼接 /// </summary> /// <param name="contractCodePrefix">前缀</param> /// <param name="padZero">补零位(最大值的长度)</param> /// <param 阅读全文
摘要：
//倒序list.OrderByDescending(i => i.a).ThenByDescending(i => i.b);//顺序list.OrderBy(i => i.a).ThenBy(i => i.b); 阅读全文
摘要：
/// <summary>/// 是不是日期类型/// </summary>/// <param name="value"></param>/// <returns></returns>public static bool IsDatetime(string value){ DateTime res 阅读全文
摘要：
/// <summary>/// 判断是否为数字/// </summary>/// <param name="value"></param>/// <returns></returns>public virtual bool IsNumber(object value){ int nubmerVal 阅读全文