MerchantTradeSummaryService.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267
  1. /*
  2. * 商户交易统计
  3. */
  4. using System;
  5. using System.Collections.Generic;
  6. using System.Linq;
  7. using System.Data;
  8. using MySystem.Models.Main;
  9. using Library;
  10. using LitJson;
  11. namespace MySystem.Service.Main
  12. {
  13. public class MerchantTradeSummaryService
  14. {
  15. static string _conn = ConfigurationManager.AppSettings["SqlConnStr"].ToString();
  16. /// <summary>
  17. /// 查询列表
  18. /// </summary>
  19. /// <param name="relationData">关联表</param>
  20. /// <param name="condition">查询条件(sql语句)</param>
  21. /// <param name="count">总数(输出)</param>
  22. /// <param name="page">页码</param>
  23. /// <param name="limit">每页条数</param>
  24. /// <returns></returns>
  25. public static List<Dictionary<string, object>> List(List<RelationData> relationData, string condition, string TradeTime, out int count, int page = 1, int limit = 30, string orderBy = "Sort desc,Id desc")
  26. {
  27. List<string> fields = new List<string>(); //要显示的列
  28. fields.Add("Id");
  29. fields.Add("Sort");
  30. fields.Add("QueryCount");
  31. fields.Add("Status");
  32. fields.Add("CreateDate");
  33. fields.Add("UpdateDate");
  34. fields.Add("SeoTitle");
  35. fields.Add("SeoKeyword");
  36. fields.Add("SeoDescription");
  37. fields.Add("OderCount"); // 订单数
  38. fields.Add("PayMode"); //支付方式
  39. fields.Add("TradeAmount"); //订单金额
  40. fields.Add("InFactAmount"); //实收金额
  41. fields.Add("WeChatInFactAmount"); //微信实收金额
  42. fields.Add("AliPayInFactAmount"); //支付宝实收金额
  43. fields.Add("TradeDate"); //日期
  44. fields.Add("TradeMonth"); //月份
  45. fields.Add("MerchantId"); //商户Id
  46. Dictionary<string, object> obj = new DbService(AppConfig.Base.mainTables, _conn).IndexData("MerchantTradeSummary" + TradeTime, relationData, orderBy, page, limit, condition, fields);
  47. List<Dictionary<string, object>> diclist = obj["data"] as List<Dictionary<string, object>>;
  48. count = int.Parse(obj["count"].ToString());
  49. return diclist;
  50. }
  51. public static List<Dictionary<string, object>> List(List<RelationData> relationData, string condition, string TradeTime, int page = 1, int limit = 30, string orderBy = "Sort desc,Id desc")
  52. {
  53. List<string> fields = new List<string>(); //要显示的列
  54. fields.Add("Id");
  55. fields.Add("Sort");
  56. fields.Add("QueryCount");
  57. fields.Add("Status");
  58. fields.Add("CreateDate");
  59. fields.Add("UpdateDate");
  60. fields.Add("SeoTitle");
  61. fields.Add("SeoKeyword");
  62. fields.Add("SeoDescription");
  63. fields.Add("OderCount"); // 订单数
  64. fields.Add("PayMode"); //支付方式
  65. fields.Add("TradeAmount"); //订单金额
  66. fields.Add("InFactAmount"); //实收金额
  67. fields.Add("WeChatInFactAmount"); //微信实收金额
  68. fields.Add("AliPayInFactAmount"); //支付宝实收金额
  69. fields.Add("TradeDate"); //日期
  70. fields.Add("TradeMonth"); //月份
  71. fields.Add("MerchantId"); //商户Id
  72. Dictionary<string, object> obj = new DbService(AppConfig.Base.mainTables, _conn).IndexData("MerchantTradeSummary" + TradeTime, relationData, orderBy, page, limit, condition, fields);
  73. List<Dictionary<string, object>> diclist = obj["data"] as List<Dictionary<string, object>>;
  74. return diclist;
  75. }
  76. public static List<Dictionary<string, object>> List2(List<RelationData> relationData, string condition, string TradeTime, int page = 1, int limit = 30, string orderBy = "Sort desc,Id desc")
  77. {
  78. List<string> fields = new List<string>(); //要显示的列
  79. fields.Add("Id");
  80. fields.Add("Sort");
  81. fields.Add("QueryCount");
  82. fields.Add("Status");
  83. fields.Add("CreateDate");
  84. fields.Add("UpdateDate");
  85. fields.Add("SeoTitle");
  86. fields.Add("SeoKeyword");
  87. fields.Add("SeoDescription");
  88. fields.Add("OderCount"); // 订单数
  89. fields.Add("PayMode"); //支付方式
  90. fields.Add("TradeAmount"); //订单金额
  91. fields.Add("InFactAmount"); //实收金额
  92. fields.Add("WeChatInFactAmount"); //微信实收金额
  93. fields.Add("AliPayInFactAmount"); //支付宝实收金额
  94. fields.Add("TradeDate"); //日期
  95. fields.Add("TradeMonth"); //月份
  96. fields.Add("MerchantId"); //商户Id
  97. Dictionary<string, object> obj = new DbService(AppConfig.Base.statTables, AppConfig.Base.StatConnRds).IndexData("MerchantTradeSummaryList" + TradeTime, relationData, orderBy, page, limit, condition, fields);
  98. List<Dictionary<string, object>> diclist = obj["data"] as List<Dictionary<string, object>>;
  99. return diclist;
  100. }
  101. /// <summary>
  102. /// 查询一条记录
  103. /// </summary>
  104. /// <param name="Id">主键Id</param>
  105. /// <returns></returns>
  106. public static MerchantTradeSummary Query(int Id, string TradeTime)
  107. {
  108. WebCMSEntities db = new WebCMSEntities();
  109. MerchantTradeSummary editData = db.MerchantTradeSummary.FirstOrDefault(m => m.Id == Id) ?? new MerchantTradeSummary();
  110. db.Dispose();
  111. return editData;
  112. }
  113. public static MerchantTradeSummary Query(string condition, string TradeTime, string fields = "*")
  114. {
  115. var merchantTradeSummary = new DbService(AppConfig.Base.mainTables, _conn).Query(fields, "MerchantTradeSummary" + TradeTime, condition);
  116. if (merchantTradeSummary.Count > 0)
  117. {
  118. return Newtonsoft.Json.JsonConvert.DeserializeObject<MerchantTradeSummary>(Newtonsoft.Json.JsonConvert.SerializeObject(merchantTradeSummary));
  119. }
  120. return new MerchantTradeSummary();
  121. }
  122. public static decimal Sum(string condition, string TradeTime, string field)
  123. {
  124. var dt = new DbService(AppConfig.Base.mainTables, _conn).Query("Sum(" + field + ") " + field, "MerchantTradeSummary" + TradeTime, condition);
  125. decimal amount = 0;
  126. if (dt.Count > 0)
  127. {
  128. amount = decimal.Parse(dt[field].ToString());
  129. }
  130. return amount;
  131. }
  132. /// <summary>
  133. /// 查询记录数
  134. /// </summary>
  135. /// <param name="Id">主键Id</param>
  136. /// <returns></returns>
  137. public static int Count(string TradeTime, string condition = "", string field = "Id")
  138. {
  139. var dt = new DbService(AppConfig.Base.mainTables, _conn).Query("Count(" + field + ") " + field, "MerchantTradeSummary" + TradeTime, condition);
  140. int result = 0;
  141. if (dt.Count > 0)
  142. {
  143. result = int.Parse(dt[field].ToString());
  144. }
  145. return result;
  146. }
  147. /// <summary>
  148. /// 查询是否存在
  149. /// </summary>
  150. /// <param name="Id">主键Id</param>
  151. /// <returns></returns>
  152. public static bool Exist(int Id, string TradeTime)
  153. {
  154. WebCMSEntities db = new WebCMSEntities();
  155. bool check = db.MerchantTradeSummary.Any(m => m.Id == Id);
  156. db.Dispose();
  157. return check;
  158. }
  159. /// <summary>
  160. /// 添加数据
  161. /// </summary>
  162. /// <param name="Fields">要设置的字段</param>
  163. /// <returns></returns>
  164. public static AppResultJson Add(Dictionary<string, object> fields, bool check = true)
  165. {
  166. if (check)
  167. {
  168. }
  169. int Id = new DbService(AppConfig.Base.mainTables, _conn).Add("MerchantTradeSummary", fields, 0);
  170. return new AppResultJson() { Status = "1", Data = Id };
  171. }
  172. /// <summary>
  173. /// 修改数据
  174. /// </summary>
  175. /// <param name="Fields">要设置的字段</param>
  176. /// <param name="Id">主键Id</param>
  177. public static AppResultJson Edit(Dictionary<string, object> fields, int Id, bool check = true)
  178. {
  179. if (check)
  180. {
  181. if (string.IsNullOrEmpty(fields["NickName"].ToString()))
  182. {
  183. return new AppResultJson() { Status = "-1", Info = "请填写昵称" };
  184. }
  185. }
  186. new DbService(AppConfig.Base.mainTables, _conn).Edit("MerchantTradeSummary", fields, Id);
  187. return new AppResultJson() { Status = "1", Data = Id };
  188. }
  189. /// <summary>
  190. /// 逻辑删除
  191. /// </summary>
  192. /// <param name="Id">主键Id</param>
  193. public static void Remove(int Id)
  194. {
  195. Dictionary<string, object> fields = new Dictionary<string, object>();
  196. fields.Add("Status", -1);
  197. new DbService(AppConfig.Base.mainTables, _conn).Edit("MerchantTradeSummary", fields, Id);
  198. }
  199. /// <summary>
  200. /// 删除数据
  201. /// </summary>
  202. /// <param name="Id">主键Id</param>
  203. public static void Delete(int Id)
  204. {
  205. new DbService(AppConfig.Base.mainTables, _conn).Delete("MerchantTradeSummary", Id);
  206. }
  207. /// <summary>
  208. /// 排序
  209. /// </summary>
  210. /// <param name="Id">主键Id</param>
  211. /// <param name="Sort">排序序号</param>
  212. public static void Sort(int Id, int Sort)
  213. {
  214. new DbService(AppConfig.Base.mainTables, _conn).Sort("MerchantTradeSummary", Sort, Id);
  215. }
  216. /// <summary>
  217. /// 导入数据
  218. /// </summary>
  219. /// <param name="ExcelData">json数据</param>
  220. public static void Import(string ExcelData)
  221. {
  222. WebCMSEntities db = new WebCMSEntities();
  223. JsonData list = JsonMapper.ToObject(ExcelData);
  224. for (int i = 1; i < list.Count; i++)
  225. {
  226. JsonData dr = list[i];
  227. db.MerchantTradeSummary.Add(new MerchantTradeSummary()
  228. {
  229. CreateDate = DateTime.Now,
  230. UpdateDate = DateTime.Now,
  231. });
  232. db.SaveChanges();
  233. }
  234. db.Dispose();
  235. }
  236. /// <summary>
  237. /// 导出excel表格
  238. /// </summary>
  239. /// <param name="fields">查询条件(单个字段)</param>
  240. /// <param name="condition">查询条件(sql语句)</param>
  241. /// <returns></returns>
  242. // public static void ExportExcel(List<RelationData> relationData, string condition)
  243. // {
  244. // }
  245. }
  246. }