F_MST_0211.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404
  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. //xuwei modify 2022-05-07 允许员工重复,有一个人干2个工种的事
  107. //if (NowStaffID == ForStaffID)
  108. //{
  109. // this.dgvDataJobs.Rows.RemoveAt(e.RowIndex);
  110. // //仅限当前页面,工号间的待修改
  111. // MessageBox.Show("员工信息不可重复配置!", this.Text,
  112. // MessageBoxButtons.OK, MessageBoxIcon.Warning);
  113. // return;
  114. //}
  115. }
  116. }
  117. }
  118. else if (columnItem.Name == "UserJobsCode")
  119. {
  120. string JobsCode = this.dgvDataJobs.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
  121. if (JobsCode != string.Empty && JobsCode != null)
  122. {
  123. DataTable TableCopy = _userJobsTable.Copy();
  124. TableCopy.DefaultView.RowFilter = "UserJobsId='" + JobsCode + "'";
  125. DataTable EndTable = TableCopy.DefaultView.ToTable();
  126. if (EndTable.Rows.Count != 0)
  127. {
  128. this.dgvDataJobs.Rows[e.RowIndex].Cells["UserJobsName"].Value = EndTable.Rows[0]["UserJobsName"].ToString();
  129. this.dgvDataJobs.Rows[e.RowIndex].Cells["UserJobsID"].Value = EndTable.Rows[0]["UserJobsID"].ToString();
  130. }
  131. else
  132. {
  133. ((DataTable)this.dgvDataJobs.DataSource).Rows[e.RowIndex].Delete();
  134. }
  135. }
  136. }
  137. if ((rowItem.Cells["StaffCode"].Value == null || rowItem.Cells["StaffCode"].Value == DBNull.Value)
  138. && (rowItem.Cells["UserJobsCode"].Value == null || rowItem.Cells["UserJobsCode"].Value == DBNull.Value))
  139. {
  140. this.dgvDataJobs.Rows.Remove(rowItem);
  141. }
  142. }
  143. }
  144. catch (Exception ex)
  145. {
  146. this._showFromFlag = true;
  147. // 对异常进行共通处理
  148. ExceptionManager.HandleEventException(this.ToString(),
  149. System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  150. }
  151. }
  152. /// <summary>
  153. /// 工号值改变事件
  154. /// </summary>
  155. /// <param name="sender"></param>
  156. /// <param name="e"></param>
  157. private void scbUser_SearchedItemChanged(object sender, EventArgs e)
  158. {
  159. try
  160. {
  161. BindUserJobs();
  162. this.scbUser.Enabled = false;
  163. this.dgvDataJobs.Enabled = true;
  164. this.dgvDataJobs.IsSetInputColumnsColor = true;
  165. }
  166. catch (Exception ex)
  167. {
  168. // 对异常进行共通处理
  169. ExceptionManager.HandleEventException(this.ToString(),
  170. System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  171. }
  172. }
  173. /// <summary>
  174. /// 单元格开始编辑事件
  175. /// </summary>
  176. /// <param name="sender"></param>
  177. /// <param name="e"></param>
  178. private void dgvDataJobs_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
  179. {
  180. try
  181. {
  182. if (e.RowIndex != -Constant.INT_IS_ONE)
  183. {
  184. DataGridViewColumn columnItem = this.dgvDataJobs.Columns[e.ColumnIndex];
  185. if ("StaffCode".Equals(columnItem.Name))
  186. {
  187. this._staffCode = this.dgvDataJobs.Rows[e.RowIndex].Cells[columnItem.Name].Value + "";
  188. }
  189. }
  190. }
  191. catch (Exception ex)
  192. {
  193. // 对异常进行共通处理
  194. ExceptionManager.HandleEventException(this.ToString(),
  195. System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  196. }
  197. }
  198. /// <summary>
  199. /// 窗体加载事件
  200. /// </summary>
  201. /// <param name="sender"></param>
  202. /// <param name="e"></param>
  203. private void F_MST_0211_Load(object sender, EventArgs e)
  204. {
  205. try
  206. {
  207. this.dgvDataJobs.AutoGenerateColumns = false;
  208. if (this._userId != null)
  209. {
  210. this.scbUser.SearchedPKMember = Convert.ToInt32(this._userId);
  211. scbUser.InitValue(_userCode, _userCode);
  212. BindUserJobs();
  213. this.scbUser.Enabled = false;
  214. this.dgvDataJobs.Enabled = true;
  215. }
  216. this.dgvDataJobs.IsSetInputColumnsColor = true;
  217. }
  218. catch (Exception ex)
  219. {
  220. throw ex;
  221. }
  222. }
  223. /// <summary>
  224. /// 工号值改变事件
  225. /// </summary>
  226. /// <param name="sender"></param>
  227. /// <param name="e"></param>
  228. private void dkUser_UserValueChanged(object sender, Controls.SearchTextBox.dkUserInfoSearchBox.TextChangeEventArgs e)
  229. {
  230. //try
  231. //{
  232. // BindUserJobs();
  233. // this.scbUser.Enabled = false;
  234. // this.dgvDataJobs.Enabled = true;
  235. // this.dgvDataJobs.IsSetInputColumnsColor = true;
  236. //}
  237. //catch (Exception ex)
  238. //{
  239. // // 对异常进行共通处理
  240. // ExceptionManager.HandleEventException(this.ToString(),
  241. // System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  242. //}
  243. }
  244. /// <summary>
  245. /// 保存按钮事件
  246. /// </summary>
  247. /// <param name="sender"></param>
  248. /// <param name="e"></param>
  249. private void btnSave_Click(object sender, EventArgs e)
  250. {
  251. try
  252. {
  253. if (this.dgvDataJobs.Rows.Count == Constant.INT_IS_ZERO || this.scbUser.SearchedPKMember == 0)
  254. {
  255. return;
  256. }
  257. //信息必填
  258. foreach (DataGridViewRow gvrFor in this.dgvDataJobs.Rows)
  259. {
  260. if (gvrFor.IsNewRow != true)
  261. {
  262. if (gvrFor.Cells["UserJobsID"].Value == null || gvrFor.Cells["UserJobsID"].Value == DBNull.Value)
  263. {
  264. MessageBox.Show("请为所有员工配置工种!",
  265. this.Text,
  266. MessageBoxButtons.OK,
  267. MessageBoxIcon.Information,
  268. MessageBoxDefaultButton.Button1);
  269. return;
  270. }
  271. if (gvrFor.Cells["StaffID"].Value == null || gvrFor.Cells["StaffID"].Value == DBNull.Value)
  272. {
  273. MessageBox.Show("请为已选择工种配置员工!",
  274. this.Text,
  275. MessageBoxButtons.OK,
  276. MessageBoxIcon.Information,
  277. MessageBoxDefaultButton.Button1);
  278. return;
  279. }
  280. }
  281. }
  282. int ReturnRows = SystemModuleProxy.Service.AddUserStaff(scbUser.SearchedPKMember, (DataTable)this.dgvDataJobs.DataSource);
  283. if (ReturnRows > Constant.INT_IS_ZERO)
  284. {
  285. MessageBox.Show(string.Format(Messages.MSG_CMN_I001, "员工关联", "保存"),
  286. this.Text,
  287. MessageBoxButtons.OK,
  288. MessageBoxIcon.Information,
  289. MessageBoxDefaultButton.Button1);
  290. this.DialogResult = DialogResult.OK;
  291. }
  292. else
  293. {
  294. MessageBox.Show(string.Format(Messages.MSG_CMN_W001, "员工关联", "保存"),
  295. this.Text,
  296. MessageBoxButtons.OK,
  297. MessageBoxIcon.Information,
  298. MessageBoxDefaultButton.Button1);
  299. }
  300. }
  301. catch (Exception ex)
  302. {
  303. throw ex;
  304. }
  305. }
  306. /// <summary>
  307. /// 取消按钮事件
  308. /// </summary>
  309. /// <param name="sender"></param>
  310. /// <param name="e"></param>
  311. private void btnCancel_Click(object sender, EventArgs e)
  312. {
  313. this.Close();
  314. }
  315. /// <summary>
  316. /// 添加行事件
  317. /// </summary>
  318. /// <param name="sender"></param>
  319. /// <param name="e"></param>
  320. private void dgvDataJobs_UserAddedRow(object sender, DataGridViewRowEventArgs e)
  321. {
  322. this.dgvDataJobs.IsSetInputColumnsColor = true;
  323. }
  324. #endregion
  325. #region 私有方法
  326. /// <summary>
  327. /// 根据工号ID获取该工号的工种关联
  328. /// </summary>
  329. /// <returns></returns>
  330. private DataSet GetUserRowData()
  331. {
  332. try
  333. {
  334. return SystemModuleProxy.Service.GetJobByUserId(scbUser.SearchedPKMember);
  335. }
  336. catch (Exception ex)
  337. {
  338. throw ex;
  339. }
  340. }
  341. /// <summary>
  342. /// 绑定工种
  343. /// </summary>
  344. private void BindUserJobs()
  345. {
  346. try
  347. {
  348. //获取可选择的工种数据源
  349. DataSet userJobsData = (DataSet)DoAsync(new BaseAsyncMethod(GetUserRowData));
  350. foreach (DataRow dr in userJobsData.Tables[0].Rows)
  351. {
  352. dr["UserJobsCode"] = dr["UserJobsCode"].ToString() + "-" + dr["UserJobsName"].ToString();
  353. }
  354. this.UserJobsCode.DisplayMember = "UserJobsCode";
  355. this.UserJobsCode.ValueMember = "UserJobsId";
  356. this.UserJobsCode.DataSource = userJobsData.Tables[0];
  357. this._userJobsTable = userJobsData.Tables[0];
  358. //获取用户当前关联的员工关系数据源
  359. DataSet userStaffData = (DataSet)DoAsync(new BaseAsyncMethod(GetUserStaffData));
  360. this.dgvDataJobs.DataSource = userStaffData.Tables[0];
  361. }
  362. catch (Exception ex)
  363. {
  364. throw ex;
  365. }
  366. }
  367. /// <summary>
  368. /// 获取工号下的员工
  369. /// </summary>
  370. /// <returns></returns>
  371. private DataSet GetUserStaffData()
  372. {
  373. return SystemModuleProxy.Service.GetUserStaffByUserId(scbUser.SearchedPKMember);
  374. }
  375. #endregion
  376. }
  377. }