摘要:
Mpxj组件已打包,请在本人百度网盘下载 链接:https://pan.baidu.com/s/1qV2ZgzwsPfY4kH-xPkvRzw 提取码:g9ri 原创文章,转载请注明 阅读全文
摘要:
# deb cdrom:[Ubuntu 22.04.4 LTS _Jammy Jellyfish_ - Release amd64 (20240220)]/ jammy main restricted # See http://help.ubuntu.com/community/UpgradeNot 阅读全文
摘要:
<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 阅读全文