
代码积累
oopts
咦,这里有好多程序猿
展开
-
bootgrid插件+knockout.JS列表展示
var mpf = mpf || {}; mpf.viewModel = mpf.viewModel || {}; var myChartByProject;mpf.viewModel.search = function (data) { var self = this; self.idField = data.idField || “FID”; self.urls原创 2017-09-09 14:36:14 · 635 阅读 · 0 评论 -
字符串输出Xml
public virtual void ExportXml() { StringBuilder sb = new StringBuilder(); StringWriter stringWrite = new StringWriter(sb); var xmlWrite = new XmlTextWri原创 2017-11-01 17:54:18 · 349 阅读 · 0 评论 -
SystemHelper类(IP操作)
public class SystemHelper { /// <summary> /// 获取客户端IP地址 /// </summary> /// <returns>若失败则返回回送地址</returns> public static string GetHostAddre...原创 2018-03-14 15:46:34 · 1975 阅读 · 0 评论 -
MySQL中order by 和 group by 一起使用
select * from (select * from crm_followup order by CreateTime desc) a GROUP BY a.CDID原创 2018-10-15 17:09:24 · 5403 阅读 · 0 评论 -
常用正则表达式
整型和小数正则:^([1-9]\d*(\.\d*[1-9])?)|(0\.\d*[1-9])$时间格式: 2018/10/12 12:01:00([0-9]{3}[1-9]|[0-9]{2}[1-9][0-9]{1}|[0-9]{1}[1-9][0-9]{2}|[1-9][0-9]{3})/(((0[13578]|1[02])/(0[1-9]|[12][0-9]|3[01]))|((0...原创 2018-12-10 17:33:31 · 131 阅读 · 0 评论 -
TimeHelper.cs 取某月每一周的起始日期
/// <summary> /// 计算日期 ,格式化日期 /// </summary> public static class TimeHelper { /// <summary> /// 计算两个日期的时间间隔 /// </summary> ...原创 2019-01-15 11:54:30 · 280 阅读 · 0 评论 -
批量更新脏数据-SQL
-- 处理旧数据Update (SELECT tr.`Status` TStatus ,cc.*,fl.NextFollowDate,fl.Remark FROM( SELECT cu.ID,cu.Name,MAX(fl.CreateTime) NewFollowDate,MAX(fl.ID) FID,MAX(tr.ID) TID,COUNT(DISTINCT(fl.ID))...原创 2019-03-18 15:43:38 · 303 阅读 · 0 评论