F_MST_0211.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403
  1. /*******************************************************************************
  2. * Copyright(c) 2014 DongkeSoft All rights reserved. / Confidential
  3. * 类的信息:
  4. * 1.程序名称:F_MST_0211.cs
  5. * 2.功能描述:新增/编辑员工关联
  6. * 编辑履历:
  7. * 作者 日期 版本 修改内容
  8. * 王鑫 2014/09/12 1.00 新建
  9. *******************************************************************************/
  10. using System;
  11. using System.Data;
  12. using System.Windows.Forms;
  13. using Dongke.IBOSS.PRD.WCF.Proxys;
  14. using Dongke.IBOSS.PRD.WCF.Proxys.SystemModuleService;
  15. using Dongke.IBOSS.PRD.Basics.BaseControls;
  16. using Dongke.IBOSS.PRD.Client.CommonModule;
  17. using Dongke.IBOSS.PRD.Client.Controls;
  18. using Dongke.IBOSS.PRD.Basics.BaseResources;
  19. using Dongke.IBOSS.PRD.WCF.DataModels;
  20. namespace Dongke.IBOSS.PRD.Client.SystemModule
  21. {
  22. /// <summary>
  23. /// 新增/编辑员工关联
  24. /// </summary>
  25. public partial class F_MST_0211 : FormBase
  26. {
  27. #region 成员变量
  28. // 打开选择窗体的标识
  29. private bool _showFromFlag = true;
  30. // 选中的员工编码
  31. private string _staffCode;
  32. // 选中的工号ID
  33. private int? _userId;
  34. // 选中的工号编码
  35. private string _userCode;
  36. // 页面数据源
  37. private DataTable _dtSourse = new DataTable();
  38. // 当前选择工号
  39. private SUserEntity _selectUser = new SUserEntity();
  40. // 当前工号的工种集合
  41. private DataTable _userJobsTable = new DataTable();
  42. #endregion
  43. #region 构造函数
  44. public F_MST_0211(int? UserId, string UserCode)
  45. {
  46. InitializeComponent();
  47. if (UserId == null)
  48. {
  49. this.Text = FormTitles.F_MST_0211_ADD;
  50. }
  51. else
  52. {
  53. this.Text = FormTitles.F_MST_0211_EDIT;
  54. }
  55. this.btnSave.Text = ButtonText.BTN_SAVE;
  56. this.btnCancel.Text = ButtonText.BTN_CLOSE;
  57. this._userId = UserId;
  58. this._userCode = UserCode;
  59. }
  60. #endregion
  61. #region 事件
  62. /// <summary>
  63. /// 单元格值改变事件
  64. /// </summary>
  65. /// <param name="sender"></param>
  66. /// <param name="e"></param>
  67. private void dgvDataJobs_CellValueChanged(object sender, DataGridViewCellEventArgs e)
  68. {
  69. try
  70. {
  71. if (e.RowIndex != -Constant.INT_IS_ONE)
  72. {
  73. if (!_showFromFlag)
  74. {
  75. return;
  76. }
  77. DataGridViewRow rowItem = this.dgvDataJobs.Rows[e.RowIndex];
  78. DataGridViewColumn columnItem = this.dgvDataJobs.Columns[e.ColumnIndex];
  79. // 用编号获取员工信息
  80. if (columnItem.Name == "StaffCode"
  81. && !string.IsNullOrEmpty(this.dgvDataJobs.Rows[e.RowIndex].Cells[columnItem.Name].Value + ""))
  82. {
  83. _showFromFlag = false;
  84. FormUtility.BindStaffRowDataSource(this.dgvDataJobs,
  85. e.RowIndex, columnItem.Name, this._staffCode, scbUser.SearchedPKMember, true);
  86. _showFromFlag = true;
  87. for (int i = 0; i < this.dgvDataJobs.Rows.Count; i++)
  88. {
  89. if (i != e.RowIndex)
  90. {
  91. if (this.dgvDataJobs.Rows[i].IsNewRow == true)
  92. {
  93. return;
  94. }
  95. String NowStaffID = this.dgvDataJobs.Rows[e.RowIndex].Cells["StaffID"].Value.ToString();
  96. if (NowStaffID == "")
  97. {
  98. this.dgvDataJobs.Rows.RemoveAt(e.RowIndex);
  99. return;
  100. }
  101. String ForStaffID = "";
  102. if (this.dgvDataJobs.Rows[i].Cells["StaffID"].Value != null)
  103. {
  104. ForStaffID = this.dgvDataJobs.Rows[i].Cells["StaffID"].Value.ToString();
  105. }
  106. if (NowStaffID == ForStaffID)
  107. {
  108. this.dgvDataJobs.Rows.RemoveAt(e.RowIndex);
  109. //仅限当前页面,工号间的待修改
  110. MessageBox.Show("员工信息不可重复配置!", this.Text,
  111. MessageBoxButtons.OK, MessageBoxIcon.Warning);
  112. return;
  113. }
  114. }
  115. }
  116. }
  117. else if (columnItem.Name == "UserJobsCode")
  118. {
  119. string JobsCode = this.dgvDataJobs.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
  120. if (JobsCode != string.Empty && JobsCode != null)
  121. {
  122. DataTable TableCopy = _userJobsTable.Copy();
  123. TableCopy.DefaultView.RowFilter = "UserJobsId='" + JobsCode + "'";
  124. DataTable EndTable = TableCopy.DefaultView.ToTable();
  125. if (EndTable.Rows.Count != 0)
  126. {
  127. this.dgvDataJobs.Rows[e.RowIndex].Cells["UserJobsName"].Value = EndTable.Rows[0]["UserJobsName"].ToString();
  128. this.dgvDataJobs.Rows[e.RowIndex].Cells["UserJobsID"].Value = EndTable.Rows[0]["UserJobsID"].ToString();
  129. }
  130. else
  131. {
  132. ((DataTable)this.dgvDataJobs.DataSource).Rows[e.RowIndex].Delete();
  133. }
  134. }
  135. }
  136. if ((rowItem.Cells["StaffCode"].Value == null || rowItem.Cells["StaffCode"].Value == DBNull.Value)
  137. && (rowItem.Cells["UserJobsCode"].Value == null || rowItem.Cells["UserJobsCode"].Value == DBNull.Value))
  138. {
  139. this.dgvDataJobs.Rows.Remove(rowItem);
  140. }
  141. }
  142. }
  143. catch (Exception ex)
  144. {
  145. this._showFromFlag = true;
  146. // 对异常进行共通处理
  147. ExceptionManager.HandleEventException(this.ToString(),
  148. System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  149. }
  150. }
  151. /// <summary>
  152. /// 工号值改变事件
  153. /// </summary>
  154. /// <param name="sender"></param>
  155. /// <param name="e"></param>
  156. private void scbUser_SearchedItemChanged(object sender, EventArgs e)
  157. {
  158. try
  159. {
  160. BindUserJobs();
  161. this.scbUser.Enabled = false;
  162. this.dgvDataJobs.Enabled = true;
  163. this.dgvDataJobs.IsSetInputColumnsColor = true;
  164. }
  165. catch (Exception ex)
  166. {
  167. // 对异常进行共通处理
  168. ExceptionManager.HandleEventException(this.ToString(),
  169. System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  170. }
  171. }
  172. /// <summary>
  173. /// 单元格开始编辑事件
  174. /// </summary>
  175. /// <param name="sender"></param>
  176. /// <param name="e"></param>
  177. private void dgvDataJobs_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
  178. {
  179. try
  180. {
  181. if (e.RowIndex != -Constant.INT_IS_ONE)
  182. {
  183. DataGridViewColumn columnItem = this.dgvDataJobs.Columns[e.ColumnIndex];
  184. if ("StaffCode".Equals(columnItem.Name))
  185. {
  186. this._staffCode = this.dgvDataJobs.Rows[e.RowIndex].Cells[columnItem.Name].Value + "";
  187. }
  188. }
  189. }
  190. catch (Exception ex)
  191. {
  192. // 对异常进行共通处理
  193. ExceptionManager.HandleEventException(this.ToString(),
  194. System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  195. }
  196. }
  197. /// <summary>
  198. /// 窗体加载事件
  199. /// </summary>
  200. /// <param name="sender"></param>
  201. /// <param name="e"></param>
  202. private void F_MST_0211_Load(object sender, EventArgs e)
  203. {
  204. try
  205. {
  206. this.dgvDataJobs.AutoGenerateColumns = false;
  207. if (this._userId != null)
  208. {
  209. this.scbUser.SearchedPKMember = Convert.ToInt32(this._userId);
  210. scbUser.InitValue(_userCode, _userCode);
  211. BindUserJobs();
  212. this.scbUser.Enabled = false;
  213. this.dgvDataJobs.Enabled = true;
  214. }
  215. this.dgvDataJobs.IsSetInputColumnsColor = true;
  216. }
  217. catch (Exception ex)
  218. {
  219. throw ex;
  220. }
  221. }
  222. /// <summary>
  223. /// 工号值改变事件
  224. /// </summary>
  225. /// <param name="sender"></param>
  226. /// <param name="e"></param>
  227. private void dkUser_UserValueChanged(object sender, Controls.SearchTextBox.dkUserInfoSearchBox.TextChangeEventArgs e)
  228. {
  229. //try
  230. //{
  231. // BindUserJobs();
  232. // this.scbUser.Enabled = false;
  233. // this.dgvDataJobs.Enabled = true;
  234. // this.dgvDataJobs.IsSetInputColumnsColor = true;
  235. //}
  236. //catch (Exception ex)
  237. //{
  238. // // 对异常进行共通处理
  239. // ExceptionManager.HandleEventException(this.ToString(),
  240. // System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  241. //}
  242. }
  243. /// <summary>
  244. /// 保存按钮事件
  245. /// </summary>
  246. /// <param name="sender"></param>
  247. /// <param name="e"></param>
  248. private void btnSave_Click(object sender, EventArgs e)
  249. {
  250. try
  251. {
  252. if (this.dgvDataJobs.Rows.Count == Constant.INT_IS_ZERO || this.scbUser.SearchedPKMember == 0)
  253. {
  254. return;
  255. }
  256. //信息必填
  257. foreach (DataGridViewRow gvrFor in this.dgvDataJobs.Rows)
  258. {
  259. if (gvrFor.IsNewRow != true)
  260. {
  261. if (gvrFor.Cells["UserJobsID"].Value == null || gvrFor.Cells["UserJobsID"].Value == DBNull.Value)
  262. {
  263. MessageBox.Show("请为所有员工配置工种!",
  264. this.Text,
  265. MessageBoxButtons.OK,
  266. MessageBoxIcon.Information,
  267. MessageBoxDefaultButton.Button1);
  268. return;
  269. }
  270. if (gvrFor.Cells["StaffID"].Value == null || gvrFor.Cells["StaffID"].Value == DBNull.Value)
  271. {
  272. MessageBox.Show("请为已选择工种配置员工!",
  273. this.Text,
  274. MessageBoxButtons.OK,
  275. MessageBoxIcon.Information,
  276. MessageBoxDefaultButton.Button1);
  277. return;
  278. }
  279. }
  280. }
  281. int ReturnRows = SystemModuleProxy.Service.AddUserStaff(scbUser.SearchedPKMember, (DataTable)this.dgvDataJobs.DataSource);
  282. if (ReturnRows > Constant.INT_IS_ZERO)
  283. {
  284. MessageBox.Show(string.Format(Messages.MSG_CMN_I001, "员工关联", "保存"),
  285. this.Text,
  286. MessageBoxButtons.OK,
  287. MessageBoxIcon.Information,
  288. MessageBoxDefaultButton.Button1);
  289. this.DialogResult = DialogResult.OK;
  290. }
  291. else
  292. {
  293. MessageBox.Show(string.Format(Messages.MSG_CMN_W001, "员工关联", "保存"),
  294. this.Text,
  295. MessageBoxButtons.OK,
  296. MessageBoxIcon.Information,
  297. MessageBoxDefaultButton.Button1);
  298. }
  299. }
  300. catch (Exception ex)
  301. {
  302. throw ex;
  303. }
  304. }
  305. /// <summary>
  306. /// 取消按钮事件
  307. /// </summary>
  308. /// <param name="sender"></param>
  309. /// <param name="e"></param>
  310. private void btnCancel_Click(object sender, EventArgs e)
  311. {
  312. this.Close();
  313. }
  314. /// <summary>
  315. /// 添加行事件
  316. /// </summary>
  317. /// <param name="sender"></param>
  318. /// <param name="e"></param>
  319. private void dgvDataJobs_UserAddedRow(object sender, DataGridViewRowEventArgs e)
  320. {
  321. this.dgvDataJobs.IsSetInputColumnsColor = true;
  322. }
  323. #endregion
  324. #region 私有方法
  325. /// <summary>
  326. /// 根据工号ID获取该工号的工种关联
  327. /// </summary>
  328. /// <returns></returns>
  329. private DataSet GetUserRowData()
  330. {
  331. try
  332. {
  333. return SystemModuleProxy.Service.GetJobByUserId(scbUser.SearchedPKMember);
  334. }
  335. catch (Exception ex)
  336. {
  337. throw ex;
  338. }
  339. }
  340. /// <summary>
  341. /// 绑定工种
  342. /// </summary>
  343. private void BindUserJobs()
  344. {
  345. try
  346. {
  347. //获取可选择的工种数据源
  348. DataSet userJobsData = (DataSet)DoAsync(new BaseAsyncMethod(GetUserRowData));
  349. foreach (DataRow dr in userJobsData.Tables[0].Rows)
  350. {
  351. dr["UserJobsCode"] = dr["UserJobsCode"].ToString() + "-" + dr["UserJobsName"].ToString();
  352. }
  353. this.UserJobsCode.DisplayMember = "UserJobsCode";
  354. this.UserJobsCode.ValueMember = "UserJobsId";
  355. this.UserJobsCode.DataSource = userJobsData.Tables[0];
  356. this._userJobsTable = userJobsData.Tables[0];
  357. //获取用户当前关联的员工关系数据源
  358. DataSet userStaffData = (DataSet)DoAsync(new BaseAsyncMethod(GetUserStaffData));
  359. this.dgvDataJobs.DataSource = userStaffData.Tables[0];
  360. }
  361. catch (Exception ex)
  362. {
  363. throw ex;
  364. }
  365. }
  366. /// <summary>
  367. /// 获取工号下的员工
  368. /// </summary>
  369. /// <returns></returns>
  370. private DataSet GetUserStaffData()
  371. {
  372. return SystemModuleProxy.Service.GetUserStaffByUserId(scbUser.SearchedPKMember);
  373. }
  374. #endregion
  375. }
  376. }