博客园 - 枫叶轻翔
uuid:24b78886-0ed1-41c2-8670-e3f31dcf42c4;id=81391
2022-07-19T09:09:26Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
feed.cnblogs.com
https://www.cnblogs.com/fengyeqingxiang/p/16494811.html
SQL利用ROW_NUMBER()进行分页 - 枫叶轻翔
<XmlCommand Name="fy_MobileExpenseMng_GetMobileExpenses"> <Parameters> <Parameter Name="@StartNum" Type="Int32" /> <Parameter Name="@EndNum" Type="Int
2022-07-19T09:06:00Z
2022-07-19T09:06:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】<XmlCommand Name="fy_MobileExpenseMng_GetMobileExpenses"> <Parameters> <Parameter Name="@StartNum" Type="Int32" /> <Parameter Name="@EndNum" Type="Int <a href="https://www.cnblogs.com/fengyeqingxiang/p/16494811.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/16494587.html
SQL WITH TEMP AS通过递归形式进行批量更新 - 枫叶轻翔
-- --开始执行,递归查出该末级科目及所有上级科目 WITH TEMP AS ( SELECT fy_cost.CostGUID,fy_cost.ParentGUID FROM fy_cost WITH (NOLOCK) WHERE CostGUID IN ('dff10db2-de87-4b5a
2022-07-19T08:31:00Z
2022-07-19T08:31:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】-- --开始执行,递归查出该末级科目及所有上级科目 WITH TEMP AS ( SELECT fy_cost.CostGUID,fy_cost.ParentGUID FROM fy_cost WITH (NOLOCK) WHERE CostGUID IN ('dff10db2-de87-4b5a <a href="https://www.cnblogs.com/fengyeqingxiang/p/16494587.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/16494577.html
SQL 多库链接进行更新数据 - 枫叶轻翔
--开始更新 UPDATE a SET a.ProviderTypeNames=b.ProviderTypeNameList FROM fy_Provider a INNER JOIN [IP2].[数据库名].dbo.p_Provider b ON a.ProviderGUID=b.Provide
2022-07-19T08:28:00Z
2022-07-19T08:28:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】--开始更新 UPDATE a SET a.ProviderTypeNames=b.ProviderTypeNameList FROM fy_Provider a INNER JOIN [IP2].[数据库名].dbo.p_Provider b ON a.ProviderGUID=b.Provide <a href="https://www.cnblogs.com/fengyeqingxiang/p/16494577.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/16494544.html
SQL常用备份更新操作 - 枫叶轻翔
--备份报销推送记录表 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
2022-07-19T08:21:00Z
2022-07-19T08:21:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】--备份报销推送记录表 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 <a href="https://www.cnblogs.com/fengyeqingxiang/p/16494544.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/16494500.html
SQL CASE WHEN用法 - 枫叶轻翔
CASE WHEN fy_Contract.IsForeignCurrencyEnabled=1 THEN '是' ELSE '否' end IsForeignCurrencyEnabled,--as 是否外币CASE x_fy_Income.x_ApproveMode WHEN 1 THEN '线
2022-07-19T08:14:00Z
2022-07-19T08:14:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】CASE WHEN fy_Contract.IsForeignCurrencyEnabled=1 THEN '是' ELSE '否' end IsForeignCurrencyEnabled,--as 是否外币CASE x_fy_Income.x_ApproveMode WHEN 1 THEN '线 <a href="https://www.cnblogs.com/fengyeqingxiang/p/16494500.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/16494477.html
C#接口调用前数据有效性所有字段校验 - 枫叶轻翔
using System.ComponentModel.DataAnnotations; /// <summary> /// 自定义实体类 /// </summary> public class DATAINFO { /// <summary> /// 员工号 入职年月(YYYYMM)+4位流水 /
2022-07-19T08:10:00Z
2022-07-19T08:10:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】using System.ComponentModel.DataAnnotations; /// <summary> /// 自定义实体类 /// </summary> public class DATAINFO { /// <summary> /// 员工号 入职年月(YYYYMM)+4位流水 / <a href="https://www.cnblogs.com/fengyeqingxiang/p/16494477.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/16494461.html
SQL同一张表找出相同数据源中按指定字段分组后最大的一条数据 - 枫叶轻翔
select A.*,B.x_UserGuid from ( select count(CreatedGUID) ss ,max(CreatedTime) maxdate,CreatedGUID from x_myUserExt group by CreatedGUID) Aleft join x_
2022-07-19T08:07:00Z
2022-07-19T08:07:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】select A.*,B.x_UserGuid from ( select count(CreatedGUID) ss ,max(CreatedTime) maxdate,CreatedGUID from x_myUserExt group by CreatedGUID) Aleft join x_ <a href="https://www.cnblogs.com/fengyeqingxiang/p/16494461.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/16494437.html
SQL查询结果行转字符串,并以逗号分割 - 枫叶轻翔
SELECT STUFF((SELECT ','+x_SourceType FROM x_fy_ContractSource WHERE x_fy_ContractSource.x_ContractGUID='20f5a958-a79a-4d90-fe8d-08d948d27530' for xml
2022-07-19T08:02:00Z
2022-07-19T08:02:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】SELECT STUFF((SELECT ','+x_SourceType FROM x_fy_ContractSource WHERE x_fy_ContractSource.x_ContractGUID='20f5a958-a79a-4d90-fe8d-08d948d27530' for xml <a href="https://www.cnblogs.com/fengyeqingxiang/p/16494437.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/16494426.html
补0拼接,进行新编号拼接 - 枫叶轻翔
/// <summary> /// 补0拼接,进行新编号拼接 /// </summary> /// <param name="contractCodePrefix">前缀</param> /// <param name="padZero">补零位(最大值的长度)</param> /// <param
2022-07-19T08:00:00Z
2022-07-19T08:00:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】/// <summary> /// 补0拼接,进行新编号拼接 /// </summary> /// <param name="contractCodePrefix">前缀</param> /// <param name="padZero">补零位(最大值的长度)</param> /// <param <a href="https://www.cnblogs.com/fengyeqingxiang/p/16494426.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/16494191.html
C#对集合进行多个字段排序 - 枫叶轻翔
//倒序list.OrderByDescending(i => i.a).ThenByDescending(i => i.b);//顺序list.OrderBy(i => i.a).ThenBy(i => i.b);
2022-07-19T07:21:00Z
2022-07-19T07:21:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】//倒序list.OrderByDescending(i => i.a).ThenByDescending(i => i.b);//顺序list.OrderBy(i => i.a).ThenBy(i => i.b); <a href="https://www.cnblogs.com/fengyeqingxiang/p/16494191.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/16494169.html
校验是否为日期格式 - 枫叶轻翔
/// <summary>/// 是不是日期类型/// </summary>/// <param name="value"></param>/// <returns></returns>public static bool IsDatetime(string value){ DateTime res
2022-07-19T07:16:00Z
2022-07-19T07:16:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】/// <summary>/// 是不是日期类型/// </summary>/// <param name="value"></param>/// <returns></returns>public static bool IsDatetime(string value){ DateTime res <a href="https://www.cnblogs.com/fengyeqingxiang/p/16494169.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/16494164.html
校验是否为数字 - 枫叶轻翔
/// <summary>/// 判断是否为数字/// </summary>/// <param name="value"></param>/// <returns></returns>public virtual bool IsNumber(object value){ int nubmerVal
2022-07-19T07:15:00Z
2022-07-19T07:15:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】/// <summary>/// 判断是否为数字/// </summary>/// <param name="value"></param>/// <returns></returns>public virtual bool IsNumber(object value){ int nubmerVal <a href="https://www.cnblogs.com/fengyeqingxiang/p/16494164.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/14317885.html
前端以字节流形式下载文件 - 枫叶轻翔
前端代码: <script type="text/javascript"> function downLoad(){ var blob = this.dataURLtoBlob("这里放字节流字符串"); var downloadUrl = window.URL.createObjectURL(bl
2021-01-23T07:58:00Z
2021-01-23T07:58:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】前端代码: <script type="text/javascript"> function downLoad(){ var blob = this.dataURLtoBlob("这里放字节流字符串"); var downloadUrl = window.URL.createObjectURL(bl <a href="https://www.cnblogs.com/fengyeqingxiang/p/14317885.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/14107177.html
将list转换成DataTable - 枫叶轻翔
/// <summary> /// 将list转换成DataTable /// </summary> /// <typeparam name="T"></typeparam> /// <param name="list"></param> /// <param name="propertyName"
2020-12-09T02:25:00Z
2020-12-09T02:25:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】/// <summary> /// 将list转换成DataTable /// </summary> /// <typeparam name="T"></typeparam> /// <param name="list"></param> /// <param name="propertyName" <a href="https://www.cnblogs.com/fengyeqingxiang/p/14107177.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/11692202.html
json时间格式化 - 枫叶轻翔
//格式化日期字符串 String.prototype.jsonDateFormat = function (format) { var date, timestamp, dtObj timestamp = parseInt(this.toString().replace('/Date(', '').replace(')/', '').replace(/\+\d+/, ''), 10)// jso
2019-10-17T07:12:00Z
2019-10-17T07:12:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】//格式化日期字符串 String.prototype.jsonDateFormat = function (format) { var date, timestamp, dtObj timestamp = parseInt(this.toString().replace('/Date(', '').replace(')/', '').replace(/\+\d+/, ''), 10)// jso <a href="https://www.cnblogs.com/fengyeqingxiang/p/11692202.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/11669755.html
C# DES加密解密 - 枫叶轻翔
/// <summary> /// DES 加解密 /// </summary> public class DES { /// <summary> /// DES加密,对接其他语言使用同一规则用 /// </summary> /// <param name="pToEncrypt"></param> /// <param name="key"></param> /// <param name="I
2019-10-14T01:49:00Z
2019-10-14T01:49:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】/// <summary> /// DES 加解密 /// </summary> public class DES { /// <summary> /// DES加密,对接其他语言使用同一规则用 /// </summary> /// <param name="pToEncrypt"></param> /// <param name="key"></param> /// <param name="I <a href="https://www.cnblogs.com/fengyeqingxiang/p/11669755.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/11169235.html
asp.net mvc ViewBag常用操作 - 枫叶轻翔
1.视图获取json类型数据
2019-07-11T04:31:00Z
2019-07-11T04:31:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】1.视图获取json类型数据 <a href="https://www.cnblogs.com/fengyeqingxiang/p/11169235.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/11169218.html
Jquery ajax与asp.net MVC前后端各种交互 - 枫叶轻翔
1.Jquery通过ajaxSubmit提交表单 2.Jquery通过get方式获取后台Json数据 3.Jquery通过Ajax方式请求接口并返回Json数据结果 4.Jquery通过post方式处获取后台数据 5.Jquery通过get方式获取后台Json列表数据
2019-07-11T04:20:00Z
2019-07-11T04:20:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】1.Jquery通过ajaxSubmit提交表单 2.Jquery通过get方式获取后台Json数据 3.Jquery通过Ajax方式请求接口并返回Json数据结果 4.Jquery通过post方式处获取后台数据 5.Jquery通过get方式获取后台Json列表数据 <a href="https://www.cnblogs.com/fengyeqingxiang/p/11169218.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/11150064.html
存储过程实现树形目录外联其他表实现每个节点的统计 - 枫叶轻翔
树结构表 外键表 存储过程
2019-07-08T03:22:00Z
2019-07-08T03:22:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】树结构表 外键表 存储过程 <a href="https://www.cnblogs.com/fengyeqingxiang/p/11150064.html" target="_blank">阅读全文</a>
https://www.cnblogs.com/fengyeqingxiang/p/11046179.html
CSS自定义右键菜单 - 枫叶轻翔
document.body.scrollTop + event.clientY - 60 }).show();
2019-06-18T08:54:00Z
2019-06-18T08:54:00Z
枫叶轻翔
https://www.cnblogs.com/fengyeqingxiang/
【摘要】document.body.scrollTop + event.clientY - 60 }).show(); <a href="https://www.cnblogs.com/fengyeqingxiang/p/11046179.html" target="_blank">阅读全文</a>