开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Windows编程 > .net编程 > 查看源码
MrDep.cs
资源名称：ASP[1].NET.rar　[点击查看]
上传用户：autodoor
上传日期：2022-08-04
资源大小：9973k
文件大小：8k
源码类别：

.net编程

开发平台：

Others

MrDep.cs：源码内容
  1. using System;
  2. using System.Data.SqlClient;
  3. using System.Data;
  5. using qminoa.Common.Data;
  7. namespace qminoa.DA
  8. {
  9. public class MrDep :IDisposable
  10. {
  11. private string conStr ;
  12. private SqlConnection con ;
  13. private SqlDataAdapter commandAdp ;
  15. private string paramChg(string str)
  16. {
  17. str = "@"+str;
  18. return str;
  19. }
  21. public bool InsertMrBranch(string branchName,string simpleCode)
  22. {
  23. SqlCommand command = new SqlCommand();
  25. command.CommandText = "InsertMrBranch";
  26. command.Connection = con;
  27. command.CommandType = CommandType.StoredProcedure;
  29. command.Parameters.Add(paramChg(DepData.BRANCHNAME_FIELD),SqlDbType.VarChar);
  30. command.Parameters.Add(paramChg(DepData.SIMPLECODE_FIELD),SqlDbType.VarChar);
  31. command.Parameters[paramChg(DepData.BRANCHNAME_FIELD)].Value = branchName;
  32. command.Parameters[paramChg(DepData.SIMPLECODE_FIELD)].Value = simpleCode;
  34. con.Open();
  35. int result = command.ExecuteNonQuery();
  36. if(result>0)
  37. {
  38. return true;
  39. }
  40. else
  41. {
  42. return false;
  43. }
  44. }
  46. public bool UpdateMrBranch(int braID,string branchName,string simpleCode)
  47. {
  48. SqlCommand command = new SqlCommand();
  50. command.CommandText = "UpdateMrBranch";
  51. command.Connection = con;
  52. command.CommandType = CommandType.StoredProcedure;
  54. command.Parameters.Add(paramChg(DepData.BRANCHID_FIELD),SqlDbType.Int);
  55. command.Parameters.Add(paramChg(DepData.BRANCHNAME_FIELD),SqlDbType.VarChar);
  56. command.Parameters.Add(paramChg(DepData.SIMPLECODE_FIELD),SqlDbType.VarChar);
  57. //
  58. command.Parameters[paramChg(DepData.BRANCHID_FIELD)].Value = braID; 
  59. command.Parameters[paramChg(DepData.BRANCHNAME_FIELD)].Value = branchName;
  60. command.Parameters[paramChg(DepData.SIMPLECODE_FIELD)].Value = simpleCode;
  62. con.Open();
  63. int result = command.ExecuteNonQuery();
  64. if(result>0)
  65. {
  66. return true;
  67. }
  68. else
  69. {
  70. return false;
  71. }
  73. }
  75. public bool DeleteMrBranch(int braID)
  76. {
  77. SqlCommand command = new SqlCommand();
  79. command.CommandText = "DeleteMrBranch";
  80. command.Connection = con;
  81. command.CommandType = CommandType.StoredProcedure;
  83. SqlParameter param = new SqlParameter(paramChg(DepData.BRANCHID_FIELD),SqlDbType.Int);
  84. param.Value = braID;
  85. command.Parameters.Add(param);
  87. con.Open();
  88. int result = command.ExecuteNonQuery();
  89. if(result>0)
  90. {
  91. return true;
  92. }
  93. else
  94. {
  95. return false;
  96. }
  97. }
  99. public DataSet GetDepData_By_BranchID(int branchID)
  100. {
  101. SqlCommand command = new SqlCommand();
  103. command.CommandText = "GetDepInfByBranchID";
  104. command.Connection = con;
  105. command.CommandType = CommandType.StoredProcedure;
  107. SqlParameter param = new SqlParameter(paramChg(DepData.BRANCHID_FIELD),SqlDbType.Int);
  108. param.Value = branchID;
  109. command.Parameters.Add(param);
  111. commandAdp.SelectCommand = command;
  113. DataSet data = new DataSet();
  114. commandAdp.Fill(data);
  116. return data;
  118. }
  120. public DataSet GetDepData_By_DepID(int depID)
  121. {
  122. SqlCommand command = new SqlCommand();
  123. command.CommandText = "GetDepInfByDepID";
  124. command.Connection = con;
  125. command.CommandType = CommandType.StoredProcedure;
  126. SqlParameter param = new SqlParameter(paramChg(DepData.DEPID_FIELD),SqlDbType.Int);
  127. param.Value = depID;
  128. command.Parameters.Add(param);
  129. commandAdp.SelectCommand = command;
  130. DataSet data = new DataSet();
  131. commandAdp.Fill(data);
  132. return data;
  133. }
  135. public DataSet GetDepData()
  136. {
  137. SqlCommand  command = new SqlCommand();
  139. command.CommandText = "GetDepInf";
  140. command.Connection = con;
  141. command.CommandType = CommandType.StoredProcedure;
  142. commandAdp.SelectCommand = command;
  143. DataSet data = new DataSet();
  144. commandAdp.Fill(data);
  145. return data;
  146. }
  148. public DataSet GetBraData()
  149. {
  150. SqlCommand  command = new SqlCommand();
  152. command.CommandText = "GetBraInf";
  153. command.Connection = con;
  154. command.CommandType = CommandType.StoredProcedure;
  155. commandAdp.SelectCommand = command;
  156. DataSet data = new DataSet();
  157. commandAdp.Fill(data);
  158. return data;
  159. }
  161. public bool DeleteMrDep(int depID)
  162. {
  163. SqlCommand command = new SqlCommand();
  164. command.CommandText = "DeleteMrDep";
  165. command.CommandType = CommandType.StoredProcedure;
  166. SqlParameter param = new SqlParameter(paramChg(DepData.DEPID_FIELD),SqlDbType.Int);
  167. param.Value = depID;
  168. command.Parameters.Add(param);
  169. command.Connection = con;
  170. con.Open();
  171. int i = command.ExecuteNonQuery();
  172. con.Close();
  173. if(i==0)
  174. return false;
  175. else
  176. return true;
  177. }
  179. public bool InsertMrDep(DepData depData)
  180. {
  181. commandAdp.InsertCommand = GetCommand();
  182. commandAdp.InsertCommand.CommandText = "InsertMrDep";
  183. int result = commandAdp.Update(depData,DepData.DEP_TABLE_NAME);
  184. if(result>0)
  185. return true;
  186. else
  187. return false;
  188. }
  190. public bool UpdateMrDep(DepData depData)
  191. {
  192. commandAdp.UpdateCommand = GetCommand();
  193. commandAdp.UpdateCommand.CommandText = "UpdateMrDep";
  194. commandAdp.UpdateCommand.Parameters.Add(new SqlParameter(paramChg(DepData.DEPID_FIELD),SqlDbType.Int));
  195. commandAdp.UpdateCommand.Parameters[paramChg(DepData.DEPID_FIELD)].SourceColumn = DepData.DEPID_FIELD;
  196. int result = commandAdp.Update(depData,DepData.DEP_TABLE_NAME);
  197. if(result>0)
  198. return true;
  199. else
  200. return false;
  201. }
  203. private SqlCommand GetCommand()
  204. {
  205. SqlCommand command = new SqlCommand();
  207. command.Connection = con;
  208. command.CommandType = CommandType.StoredProcedure;
  210. SqlParameterCollection param = command.Parameters;
  212. param.Add(new SqlParameter(paramChg(DepData.BRANCHID_FIELD),SqlDbType.Int));
  213. param.Add(new SqlParameter(paramChg(DepData.DEPNAME_FIELD),SqlDbType.VarChar));
  214. param.Add(new SqlParameter(paramChg(DepData.MANAGER_FIELD),SqlDbType.VarChar));
  215. param.Add(new SqlParameter(paramChg(DepData.TEL1_FIELD),SqlDbType.VarChar));
  216. param.Add(new SqlParameter(paramChg(DepData.TEL2_FIELD),SqlDbType.VarChar));
  217. param.Add(new SqlParameter(paramChg(DepData.FAX_FIELD),SqlDbType.VarChar));
  218. param.Add(new SqlParameter(paramChg(DepData.PROVINCE_FIELD),SqlDbType.VarChar));
  219. param.Add(new SqlParameter(paramChg(DepData.CITY_FIELD),SqlDbType.VarChar));
  220. param.Add(new SqlParameter(paramChg(DepData.DISTRICT_FIELD),SqlDbType.VarChar));
  221. param.Add(new SqlParameter(paramChg(DepData.STREET_FIELD),SqlDbType.VarChar));
  222. param.Add(new SqlParameter(paramChg(DepData.POSTCODE_FIELD),SqlDbType.VarChar));
  224. param[paramChg(DepData.BRANCHID_FIELD)].SourceColumn = DepData.BRANCHID_FIELD;
  225. param[paramChg(DepData.DEPNAME_FIELD)].SourceColumn = DepData.DEPNAME_FIELD;
  226. param[paramChg(DepData.MANAGER_FIELD)].SourceColumn = DepData.MANAGER_FIELD;
  227. param[paramChg(DepData.TEL1_FIELD)].SourceColumn = DepData.TEL1_FIELD;
  228. param[paramChg(DepData.TEL2_FIELD)].SourceColumn = DepData.TEL2_FIELD;
  229. param[paramChg(DepData.FAX_FIELD)].SourceColumn = DepData.FAX_FIELD;
  230. param[paramChg(DepData.PROVINCE_FIELD)].SourceColumn = DepData.PROVINCE_FIELD;
  231. param[paramChg(DepData.CITY_FIELD)].SourceColumn = DepData.CITY_FIELD;
  232. param[paramChg(DepData.DISTRICT_FIELD)].SourceColumn = DepData.DISTRICT_FIELD;
  233. param[paramChg(DepData.STREET_FIELD)].SourceColumn = DepData.STREET_FIELD;
  234. param[paramChg(DepData.POSTCODE_FIELD)].SourceColumn = DepData.POSTCODE_FIELD;
  236. return command;
  237. }
  239. public void Dispose()
  240. {
  241. Dispose(true);
  242. GC.SuppressFinalize(true);
  243. }
  245. protected virtual void Dispose(bool disposing)
  246. {
  248. }
  250. public MrDep()
  251. {
  252. conStr = System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString");
  253. con = new SqlConnection(conStr);
  254. commandAdp = new SqlDataAdapter();
  255. }
  256. }
  257. }