MerchantTradeSummaryService.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266
  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("TradeAmount"); //订单金额
  90. fields.Add("InFactAmount"); //实收金额
  91. fields.Add("WeChatInFactAmount"); //微信实收金额
  92. fields.Add("AliPayInFactAmount"); //支付宝实收金额
  93. fields.Add("TradeDate"); //日期
  94. fields.Add("TradeMonth"); //月份
  95. fields.Add("MerchantId"); //商户Id
  96. Dictionary<string, object> obj = new DbService(AppConfig.Base.statTables, AppConfig.Base.StatConnRds).IndexData("MerchantTradeSummaryList" + TradeTime, relationData, orderBy, page, limit, condition, fields);
  97. List<Dictionary<string, object>> diclist = obj["data"] as List<Dictionary<string, object>>;
  98. return diclist;
  99. }
  100. /// <summary>
  101. /// 查询一条记录
  102. /// </summary>
  103. /// <param name="Id">主键Id</param>
  104. /// <returns></returns>
  105. public static MerchantTradeSummary Query(int Id, string TradeTime)
  106. {
  107. WebCMSEntities db = new WebCMSEntities();
  108. MerchantTradeSummary editData = db.MerchantTradeSummary.FirstOrDefault(m => m.Id == Id) ?? new MerchantTradeSummary();
  109. db.Dispose();
  110. return editData;
  111. }
  112. public static MerchantTradeSummary Query(string condition, string TradeTime, string fields = "*")
  113. {
  114. var merchantTradeSummary = new DbService(AppConfig.Base.mainTables, _conn).Query(fields, "MerchantTradeSummary" + TradeTime, condition);
  115. if (merchantTradeSummary.Count > 0)
  116. {
  117. return Newtonsoft.Json.JsonConvert.DeserializeObject<MerchantTradeSummary>(Newtonsoft.Json.JsonConvert.SerializeObject(merchantTradeSummary));
  118. }
  119. return new MerchantTradeSummary();
  120. }
  121. public static decimal Sum(string condition, string TradeTime, string field)
  122. {
  123. var dt = new DbService(AppConfig.Base.mainTables, _conn).Query("Sum(" + field + ") " + field, "MerchantTradeSummary" + TradeTime, condition);
  124. decimal amount = 0;
  125. if (dt.Count > 0)
  126. {
  127. amount = decimal.Parse(dt[field].ToString());
  128. }
  129. return amount;
  130. }
  131. /// <summary>
  132. /// 查询记录数
  133. /// </summary>
  134. /// <param name="Id">主键Id</param>
  135. /// <returns></returns>
  136. public static int Count(string TradeTime, string condition = "", string field = "Id")
  137. {
  138. var dt = new DbService(AppConfig.Base.mainTables, _conn).Query("Count(" + field + ") " + field, "MerchantTradeSummary" + TradeTime, condition);
  139. int result = 0;
  140. if (dt.Count > 0)
  141. {
  142. result = int.Parse(dt[field].ToString());
  143. }
  144. return result;
  145. }
  146. /// <summary>
  147. /// 查询是否存在
  148. /// </summary>
  149. /// <param name="Id">主键Id</param>
  150. /// <returns></returns>
  151. public static bool Exist(int Id, string TradeTime)
  152. {
  153. WebCMSEntities db = new WebCMSEntities();
  154. bool check = db.MerchantTradeSummary.Any(m => m.Id == Id);
  155. db.Dispose();
  156. return check;
  157. }
  158. /// <summary>
  159. /// 添加数据
  160. /// </summary>
  161. /// <param name="Fields">要设置的字段</param>
  162. /// <returns></returns>
  163. public static AppResultJson Add(Dictionary<string, object> fields, bool check = true)
  164. {
  165. if (check)
  166. {
  167. }
  168. int Id = new DbService(AppConfig.Base.mainTables, _conn).Add("MerchantTradeSummary", fields, 0);
  169. return new AppResultJson() { Status = "1", Data = Id };
  170. }
  171. /// <summary>
  172. /// 修改数据
  173. /// </summary>
  174. /// <param name="Fields">要设置的字段</param>
  175. /// <param name="Id">主键Id</param>
  176. public static AppResultJson Edit(Dictionary<string, object> fields, int Id, bool check = true)
  177. {
  178. if (check)
  179. {
  180. if (string.IsNullOrEmpty(fields["NickName"].ToString()))
  181. {
  182. return new AppResultJson() { Status = "-1", Info = "请填写昵称" };
  183. }
  184. }
  185. new DbService(AppConfig.Base.mainTables, _conn).Edit("MerchantTradeSummary", fields, Id);
  186. return new AppResultJson() { Status = "1", Data = Id };
  187. }
  188. /// <summary>
  189. /// 逻辑删除
  190. /// </summary>
  191. /// <param name="Id">主键Id</param>
  192. public static void Remove(int Id)
  193. {
  194. Dictionary<string, object> fields = new Dictionary<string, object>();
  195. fields.Add("Status", -1);
  196. new DbService(AppConfig.Base.mainTables, _conn).Edit("MerchantTradeSummary", fields, Id);
  197. }
  198. /// <summary>
  199. /// 删除数据
  200. /// </summary>
  201. /// <param name="Id">主键Id</param>
  202. public static void Delete(int Id)
  203. {
  204. new DbService(AppConfig.Base.mainTables, _conn).Delete("MerchantTradeSummary", Id);
  205. }
  206. /// <summary>
  207. /// 排序
  208. /// </summary>
  209. /// <param name="Id">主键Id</param>
  210. /// <param name="Sort">排序序号</param>
  211. public static void Sort(int Id, int Sort)
  212. {
  213. new DbService(AppConfig.Base.mainTables, _conn).Sort("MerchantTradeSummary", Sort, Id);
  214. }
  215. /// <summary>
  216. /// 导入数据
  217. /// </summary>
  218. /// <param name="ExcelData">json数据</param>
  219. public static void Import(string ExcelData)
  220. {
  221. WebCMSEntities db = new WebCMSEntities();
  222. JsonData list = JsonMapper.ToObject(ExcelData);
  223. for (int i = 1; i < list.Count; i++)
  224. {
  225. JsonData dr = list[i];
  226. db.MerchantTradeSummary.Add(new MerchantTradeSummary()
  227. {
  228. CreateDate = DateTime.Now,
  229. UpdateDate = DateTime.Now,
  230. });
  231. db.SaveChanges();
  232. }
  233. db.Dispose();
  234. }
  235. /// <summary>
  236. /// 导出excel表格
  237. /// </summary>
  238. /// <param name="fields">查询条件(单个字段)</param>
  239. /// <param name="condition">查询条件(sql语句)</param>
  240. /// <returns></returns>
  241. // public static void ExportExcel(List<RelationData> relationData, string condition)
  242. // {
  243. // }
  244. }
  245. }