Account.cs 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392
  1. /** 版本信息模板在安装目录下,可自行修改。
  2. * account.cs
  3. *
  4. * 功 能: N/A
  5. * 类 名: account
  6. *
  7. * Ver 变更日期 负责人 变更内容
  8. * ───────────────────────────────────
  9. * V0.01 2024-07-27 10:51:14 N/A 初版
  10. *
  11. * Copyright (c) 2012 Maticsoft Corporation. All rights reserved.
  12. *┌──────────────────────────────────┐
  13. *│ 此技术信息为本公司机密信息,未经本公司书面同意禁止向第三方披露. │
  14. *│ 版权所有:动软卓越(北京)科技有限公司              │
  15. *└──────────────────────────────────┘
  16. */
  17. using System;
  18. using System.Data;
  19. using System.Text;
  20. using MySql.Data.MySqlClient;
  21. using Maticsoft.DBUtility;//Please add references
  22. namespace Jpsoft.DAL
  23. {
  24. /// <summary>
  25. /// 数据访问类:account
  26. /// </summary>
  27. public partial class Account
  28. {
  29. public Account()
  30. {}
  31. #region BasicMethod
  32. /// <summary>
  33. /// 是否存在该记录
  34. /// </summary>
  35. public bool Exists(string id_)
  36. {
  37. StringBuilder strSql=new StringBuilder();
  38. strSql.Append("select count(1) from base_account");
  39. strSql.Append(" where id_=@id_ ");
  40. MySqlParameter[] parameters = {
  41. new MySqlParameter("@id_", MySqlDbType.VarChar,36) };
  42. parameters[0].Value = id_;
  43. return DbHelperMySQL.Exists(strSql.ToString(),parameters);
  44. }
  45. /// <summary>
  46. /// 增加一条数据
  47. /// </summary>
  48. public bool Add(Jpsoft.Model.Account model)
  49. {
  50. StringBuilder strSql=new StringBuilder();
  51. strSql.Append("insert into base_account(");
  52. strSql.Append("id_,customer_id,work_id,type_,plan_number,actual_amount,cloth_amount,roll_amount,total_amount,del_flag,create_by,create_time,update_by,update_time)");
  53. strSql.Append(" values (");
  54. strSql.Append("@id_,@customer_id,@work_id,@type_,@plan_number,@actual_amount,@cloth_amount,@roll_amount,@total_amount,@del_flag,@create_by,@create_time,@update_by,@update_time)");
  55. MySqlParameter[] parameters = {
  56. new MySqlParameter("@id_", MySqlDbType.VarChar,36),
  57. new MySqlParameter("@customer_id", MySqlDbType.VarChar,36),
  58. new MySqlParameter("@work_id", MySqlDbType.VarChar,36),
  59. new MySqlParameter("@type_", MySqlDbType.Int32,1),
  60. new MySqlParameter("@plan_number", MySqlDbType.VarChar,255),
  61. new MySqlParameter("@actual_amount", MySqlDbType.Decimal,10),
  62. new MySqlParameter("@cloth_amount", MySqlDbType.Decimal,10),
  63. new MySqlParameter("@roll_amount", MySqlDbType.Decimal,10),
  64. new MySqlParameter("@total_amount", MySqlDbType.Decimal,10),
  65. new MySqlParameter("@del_flag", MySqlDbType.Bit),
  66. new MySqlParameter("@create_by", MySqlDbType.VarChar,36),
  67. new MySqlParameter("@create_time", MySqlDbType.Timestamp),
  68. new MySqlParameter("@update_by", MySqlDbType.VarChar,36),
  69. new MySqlParameter("@update_time", MySqlDbType.Timestamp)};
  70. parameters[0].Value = model.id_;
  71. parameters[1].Value = model.customer_id;
  72. parameters[2].Value = model.work_id;
  73. parameters[3].Value = model.type_;
  74. parameters[4].Value = model.plan_number;
  75. parameters[5].Value = model.actual_amount;
  76. parameters[6].Value = model.cloth_amount;
  77. parameters[7].Value = model.roll_amount;
  78. parameters[8].Value = model.total_amount;
  79. parameters[9].Value = model.del_flag;
  80. parameters[10].Value = model.create_by;
  81. parameters[11].Value = model.create_time;
  82. parameters[12].Value = model.update_by;
  83. parameters[13].Value = model.update_time;
  84. int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
  85. if (rows > 0)
  86. {
  87. return true;
  88. }
  89. else
  90. {
  91. return false;
  92. }
  93. }
  94. /// <summary>
  95. /// 更新一条数据
  96. /// </summary>
  97. public bool Update(Jpsoft.Model.Account model)
  98. {
  99. StringBuilder strSql=new StringBuilder();
  100. strSql.Append("update base_account set ");
  101. strSql.Append("customer_id=@customer_id,");
  102. strSql.Append("work_id=@work_id,");
  103. strSql.Append("type_=@type_,");
  104. strSql.Append("plan_number=@plan_number,");
  105. strSql.Append("actual_amount=@actual_amount,");
  106. strSql.Append("cloth_amount=@cloth_amount,");
  107. strSql.Append("roll_amount=@roll_amount,");
  108. strSql.Append("total_amount=@total_amount,");
  109. strSql.Append("del_flag=@del_flag,");
  110. strSql.Append("create_by=@create_by,");
  111. strSql.Append("update_by=@update_by");
  112. strSql.Append(" where id_=@id_ ");
  113. MySqlParameter[] parameters = {
  114. new MySqlParameter("@customer_id", MySqlDbType.VarChar,36),
  115. new MySqlParameter("@work_id", MySqlDbType.VarChar,36),
  116. new MySqlParameter("@type_", MySqlDbType.Int32,1),
  117. new MySqlParameter("@plan_number", MySqlDbType.VarChar,255),
  118. new MySqlParameter("@actual_amount", MySqlDbType.Decimal,10),
  119. new MySqlParameter("@cloth_amount", MySqlDbType.Decimal,10),
  120. new MySqlParameter("@roll_amount", MySqlDbType.Decimal,10),
  121. new MySqlParameter("@total_amount", MySqlDbType.Decimal,10),
  122. new MySqlParameter("@del_flag", MySqlDbType.Bit),
  123. new MySqlParameter("@create_by", MySqlDbType.VarChar,36),
  124. new MySqlParameter("@update_by", MySqlDbType.VarChar,36),
  125. new MySqlParameter("@id_", MySqlDbType.VarChar,36)};
  126. parameters[0].Value = model.customer_id;
  127. parameters[1].Value = model.work_id;
  128. parameters[2].Value = model.type_;
  129. parameters[3].Value = model.plan_number;
  130. parameters[4].Value = model.actual_amount;
  131. parameters[5].Value = model.cloth_amount;
  132. parameters[6].Value = model.roll_amount;
  133. parameters[7].Value = model.total_amount;
  134. parameters[8].Value = model.del_flag;
  135. parameters[9].Value = model.create_by;
  136. parameters[10].Value = model.update_by;
  137. parameters[11].Value = model.id_;
  138. int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
  139. if (rows > 0)
  140. {
  141. return true;
  142. }
  143. else
  144. {
  145. return false;
  146. }
  147. }
  148. /// <summary>
  149. /// 删除一条数据
  150. /// </summary>
  151. public bool Delete(string id_)
  152. {
  153. StringBuilder strSql=new StringBuilder();
  154. strSql.Append("delete from base_account ");
  155. strSql.Append(" where id_=@id_ ");
  156. MySqlParameter[] parameters = {
  157. new MySqlParameter("@id_", MySqlDbType.VarChar,36) };
  158. parameters[0].Value = id_;
  159. int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
  160. if (rows > 0)
  161. {
  162. return true;
  163. }
  164. else
  165. {
  166. return false;
  167. }
  168. }
  169. /// <summary>
  170. /// 批量删除数据
  171. /// </summary>
  172. public bool DeleteList(string id_list )
  173. {
  174. StringBuilder strSql=new StringBuilder();
  175. strSql.Append("delete from base_account ");
  176. strSql.Append(" where id_ in ("+id_list + ") ");
  177. int rows=DbHelperMySQL.ExecuteSql(strSql.ToString());
  178. if (rows > 0)
  179. {
  180. return true;
  181. }
  182. else
  183. {
  184. return false;
  185. }
  186. }
  187. /// <summary>
  188. /// 得到一个对象实体
  189. /// </summary>
  190. public Jpsoft.Model.Account GetModel(string id_)
  191. {
  192. StringBuilder strSql=new StringBuilder();
  193. strSql.Append("select id_,customer_id,work_id,type_,plan_number,actual_amount,cloth_amount,roll_amount,total_amount,del_flag,create_by,create_time,update_by,update_time from base_account ");
  194. strSql.Append(" where id_=@id_ ");
  195. MySqlParameter[] parameters = {
  196. new MySqlParameter("@id_", MySqlDbType.VarChar,36) };
  197. parameters[0].Value = id_;
  198. Jpsoft.Model.Account model=new Jpsoft.Model.Account();
  199. DataSet ds=DbHelperMySQL.Query(strSql.ToString(),parameters);
  200. if(ds.Tables[0].Rows.Count>0)
  201. {
  202. return DataRowToModel(ds.Tables[0].Rows[0]);
  203. }
  204. else
  205. {
  206. return null;
  207. }
  208. }
  209. /// <summary>
  210. /// 得到一个对象实体
  211. /// </summary>
  212. public Jpsoft.Model.Account DataRowToModel(DataRow row)
  213. {
  214. Jpsoft.Model.Account model=new Jpsoft.Model.Account();
  215. if (row != null)
  216. {
  217. if(row["id_"]!=null)
  218. {
  219. model.id_=row["id_"].ToString();
  220. }
  221. if(row["customer_id"]!=null)
  222. {
  223. model.customer_id=row["customer_id"].ToString();
  224. }
  225. if(row["work_id"]!=null)
  226. {
  227. model.work_id=row["work_id"].ToString();
  228. }
  229. if(row["type_"]!=null && row["type_"].ToString()!="")
  230. {
  231. model.type_=int.Parse(row["type_"].ToString());
  232. }
  233. if(row["plan_number"]!=null)
  234. {
  235. model.plan_number=row["plan_number"].ToString();
  236. }
  237. if(row["actual_amount"]!=null && row["actual_amount"].ToString()!="")
  238. {
  239. model.actual_amount=decimal.Parse(row["actual_amount"].ToString());
  240. }
  241. if(row["cloth_amount"]!=null && row["cloth_amount"].ToString()!="")
  242. {
  243. model.cloth_amount=decimal.Parse(row["cloth_amount"].ToString());
  244. }
  245. if(row["roll_amount"]!=null && row["roll_amount"].ToString()!="")
  246. {
  247. model.roll_amount=decimal.Parse(row["roll_amount"].ToString());
  248. }
  249. if(row["total_amount"]!=null && row["total_amount"].ToString()!="")
  250. {
  251. model.total_amount=decimal.Parse(row["total_amount"].ToString());
  252. }
  253. if(row["del_flag"]!=null && row["del_flag"].ToString()!="")
  254. {
  255. if((row["del_flag"].ToString()=="1")||(row["del_flag"].ToString().ToLower()=="true"))
  256. {
  257. model.del_flag=true;
  258. }
  259. else
  260. {
  261. model.del_flag=false;
  262. }
  263. }
  264. if(row["create_by"]!=null)
  265. {
  266. model.create_by=row["create_by"].ToString();
  267. }
  268. if(row["create_time"]!=null && row["create_time"].ToString()!="")
  269. {
  270. model.create_time=DateTime.Parse(row["create_time"].ToString());
  271. }
  272. if(row["update_by"]!=null)
  273. {
  274. model.update_by=row["update_by"].ToString();
  275. }
  276. if(row["update_time"]!=null && row["update_time"].ToString()!="")
  277. {
  278. model.update_time=DateTime.Parse(row["update_time"].ToString());
  279. }
  280. }
  281. return model;
  282. }
  283. /// <summary>
  284. /// 获得数据列表
  285. /// </summary>
  286. public DataSet GetList(string strWhere)
  287. {
  288. StringBuilder strSql=new StringBuilder();
  289. strSql.Append("select id_,customer_id,work_id,type_,plan_number,actual_amount,cloth_amount,roll_amount,total_amount,del_flag,create_by,create_time,update_by,update_time ");
  290. strSql.Append(" FROM base_account ");
  291. if(strWhere.Trim()!="")
  292. {
  293. strSql.Append(" where "+strWhere);
  294. }
  295. return DbHelperMySQL.Query(strSql.ToString());
  296. }
  297. /// <summary>
  298. /// 获取记录总数
  299. /// </summary>
  300. public int GetRecordCount(string strWhere)
  301. {
  302. StringBuilder strSql=new StringBuilder();
  303. strSql.Append("select count(1) FROM base_account ");
  304. if(strWhere.Trim()!="")
  305. {
  306. strSql.Append(" where "+strWhere);
  307. }
  308. object obj = DbHelperMySQL.GetSingle(strSql.ToString());
  309. if (obj == null)
  310. {
  311. return 0;
  312. }
  313. else
  314. {
  315. return Convert.ToInt32(obj);
  316. }
  317. }
  318. /// <summary>
  319. /// 分页获取数据列表
  320. /// </summary>
  321. public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
  322. {
  323. StringBuilder strSql=new StringBuilder();
  324. strSql.Append("SELECT * FROM ( ");
  325. strSql.Append(" SELECT ROW_NUMBER() OVER (");
  326. if (!string.IsNullOrEmpty(orderby.Trim()))
  327. {
  328. strSql.Append("order by T." + orderby );
  329. }
  330. else
  331. {
  332. strSql.Append("order by T.id_ desc");
  333. }
  334. strSql.Append(")AS Row, T.* from base_account T ");
  335. if (!string.IsNullOrEmpty(strWhere.Trim()))
  336. {
  337. strSql.Append(" WHERE " + strWhere);
  338. }
  339. strSql.Append(" ) TT");
  340. strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
  341. return DbHelperMySQL.Query(strSql.ToString());
  342. }
  343. /*
  344. /// <summary>
  345. /// 分页获取数据列表
  346. /// </summary>
  347. public DataSet GetList(int PageSize,int PageIndex,string strWhere)
  348. {
  349. MySqlParameter[] parameters = {
  350. new MySqlParameter("@tblName", MySqlDbType.VarChar, 255),
  351. new MySqlParameter("@fldName", MySqlDbType.VarChar, 255),
  352. new MySqlParameter("@PageSize", MySqlDbType.Int32),
  353. new MySqlParameter("@PageIndex", MySqlDbType.Int32),
  354. new MySqlParameter("@IsReCount", MySqlDbType.Bit),
  355. new MySqlParameter("@OrderType", MySqlDbType.Bit),
  356. new MySqlParameter("@strWhere", MySqlDbType.VarChar,1000),
  357. };
  358. parameters[0].Value = "base_account";
  359. parameters[1].Value = "id_";
  360. parameters[2].Value = PageSize;
  361. parameters[3].Value = PageIndex;
  362. parameters[4].Value = 0;
  363. parameters[5].Value = 0;
  364. parameters[6].Value = strWhere;
  365. return DbHelperMySQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
  366. }*/
  367. #endregion BasicMethod
  368. #region ExtensionMethod
  369. #endregion ExtensionMethod
  370. }
  371. }