F_PC_0402.cs 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556
  1. /*******************************************************************************
  2. * Copyright(c) 2014 dongke All rights reserved. / Confidential
  3. * 类的信息:
  4. * 1.程序名称:F_PC_0402.cs
  5. * 2.功能描述:班次配置新建\编辑
  6. * 编辑履历:
  7. * 作者 日期 版本 修改内容
  8. * 冯雪 2014/09/22 1.00 新建
  9. *******************************************************************************/
  10. using System;
  11. using System.Data;
  12. using System.Windows.Forms;
  13. using Dongke.IBOSS.PRD.Basics.BaseControls;
  14. using Dongke.IBOSS.PRD.Basics.BaseResources;
  15. using Dongke.IBOSS.PRD.Client.CommonModule;
  16. using Dongke.IBOSS.PRD.Client.Controls;
  17. using Dongke.IBOSS.PRD.WCF.DataModels.ConfigModule;
  18. using Dongke.IBOSS.PRD.WCF.DataModels.PCModule;
  19. using Dongke.IBOSS.PRD.WCF.Proxys;
  20. using Dongke.IBOSS.PRD.WCF.Proxys.PCModuleService;
  21. namespace Dongke.IBOSS.PRD.Client.PCModule
  22. {
  23. /// <summary>
  24. /// 班次配置新建\编辑窗体
  25. /// </summary>
  26. public partial class F_PC_0402 : FormBase
  27. {
  28. #region 成员变量
  29. // 班次配置ID
  30. private int _classesSettingID;
  31. // 窗体状态的枚举 新建/编辑
  32. private Constant.FormMode _editStatus;
  33. // 选中的员工编码
  34. private string _staffCode;
  35. // 工号ID
  36. private int _userId;
  37. // 工号名称
  38. private string _userName;
  39. // 工号编号
  40. private string _userCode;
  41. // 备注
  42. private string _remark;
  43. //保存影响行
  44. private int _returnRow = Constant.INT_IS_ZERO;
  45. // 打开选择窗体的标识
  46. private bool _showFromFlag = true;
  47. // 当前工号的工种集合
  48. private DataTable _userJobsTable = new DataTable();
  49. #endregion
  50. #region 属性
  51. /// <summary>
  52. /// 备注
  53. /// </summary>
  54. public string Remark
  55. {
  56. get { return _remark; }
  57. set { _remark = value; }
  58. }
  59. /// <summary>
  60. /// 工号名称
  61. /// </summary>
  62. public string UserName1
  63. {
  64. get { return _userName; }
  65. set { _userName = value; }
  66. }
  67. /// <summary>
  68. /// 班次配置ID
  69. /// </summary>
  70. public int ClassesSettingID
  71. {
  72. get { return _classesSettingID; }
  73. set { _classesSettingID = value; }
  74. }
  75. /// <summary>
  76. /// 工号ID
  77. /// </summary>
  78. public int UserId
  79. {
  80. get { return _userId; }
  81. set { _userId = value; }
  82. }
  83. /// <summary>
  84. /// 工号编号
  85. /// </summary>
  86. public string UserCode
  87. {
  88. get { return _userCode; }
  89. set { _userCode = value; }
  90. }
  91. /// <summary>
  92. /// 编辑时账务日期
  93. /// </summary>
  94. public DateTime? AccountDate
  95. {
  96. get;
  97. set;
  98. }
  99. #endregion
  100. #region 构造函数
  101. /// <summary>
  102. /// 构造函数
  103. /// </summary>
  104. /// <param name="editStatus">新建/编辑</param>
  105. /// <param name="pUserId">要编辑的员工编号</param>
  106. public F_PC_0402(Constant.FormMode editStatus)
  107. {
  108. InitializeComponent();
  109. this._editStatus = editStatus;
  110. this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE;
  111. this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE;
  112. this.btnSave.Text = ButtonText.BTN_SAVE;
  113. this.btnCancel.Text = ButtonText.BTN_CANCEL;
  114. if (this._editStatus == Constant.FormMode.Add)
  115. {
  116. this.Text = FormTitles.F_PC_0402_ADD;
  117. }
  118. else
  119. {
  120. this.Text = FormTitles.F_PC_0402_EDIT;
  121. // wangx 2016-06-20
  122. this.dkUserInfo.Enabled = false;
  123. this.dtpAccountDate.Enabled = false;
  124. this.txtRemarks.Enabled = false;
  125. // wangx 2016-06-20 end
  126. }
  127. }
  128. #endregion
  129. #region 事件
  130. /// <summary>
  131. /// 页面加载事件
  132. /// </summary>
  133. /// <param name="sender"></param>
  134. /// <param name="e"></param>
  135. private void F_PC_0402_Load(object sender, EventArgs e)
  136. {
  137. try
  138. {
  139. if (this._editStatus == Constant.FormMode.Edit)
  140. {
  141. this.dkUserInfo.UserID = this._userId;
  142. this.dkUserInfo.UserName = this._userName;
  143. this.dkUserInfo.UserCode = this._userCode;
  144. BindUserJobs();
  145. if (this.AccountDate.HasValue)
  146. {
  147. this.dtpAccountDate.Value = this.AccountDate.Value;
  148. }
  149. DataSet result = (DataSet)DoAsync(() =>
  150. {
  151. return PCModuleProxy.Service.SearchClassesDetail(this._classesSettingID);
  152. });
  153. this.dgvClassesDetail.AutoGenerateColumns = false;
  154. this.dgvClassesDetail.IsSetInputColumnsColor = true;
  155. // 绑定明细数据
  156. this.dgvClassesDetail.DataSource = result.Tables[0];
  157. // 允许编辑行
  158. this.dgvClassesDetail.AllowUserToAddRows = true;
  159. this.dgvClassesDetail.IsSetInputColumnsColor = true;
  160. }
  161. }
  162. catch (Exception ex)
  163. {
  164. // 对异常进行共通处理
  165. ExceptionManager.HandleEventException(this.ToString(),
  166. System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  167. }
  168. }
  169. /// <summary>
  170. /// 自动适应列宽
  171. /// </summary>
  172. /// <param name="sender"></param>
  173. /// <param name="e"></param>
  174. private void tsbtnAdaptive_Click(object sender, EventArgs e)
  175. {
  176. this.dgvClassesDetail.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
  177. }
  178. /// <summary>
  179. /// 关闭按钮事件
  180. /// </summary>
  181. /// <param name="sender"></param>
  182. /// <param name="e"></param>
  183. private void tsbtnClose_Click(object sender, EventArgs e)
  184. {
  185. this.Close();
  186. }
  187. /// <summary>
  188. /// 工号ValueChanged事件
  189. /// </summary>
  190. /// <param name="sender"></param>
  191. /// <param name="e"></param>
  192. private void dkUserInfo_UserValueChanged(object sender, Controls.SearchTextBox.dkUserInfoSearchBox.TextChangeEventArgs e)
  193. {
  194. try
  195. {
  196. int userId = this.dkUserInfo.UserID.Value;
  197. BindUserJobs();
  198. DataSet result = (DataSet)DoAsync(() =>
  199. {
  200. return HRModuleProxy.Service.SearchHrStaffInfo(userId);
  201. });
  202. this.dgvClassesDetail.AutoGenerateColumns = false;
  203. // 绑定明细数据
  204. this.dgvClassesDetail.DataSource = result.Tables[0];
  205. // 允许编辑行
  206. this.dgvClassesDetail.AllowUserToAddRows = true;
  207. }
  208. catch (Exception ex)
  209. {
  210. // 对异常进行共通处理
  211. ExceptionManager.HandleEventException(this.ToString(),
  212. System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  213. }
  214. }
  215. /// <summary>
  216. /// 员工编号值改变事件
  217. /// </summary>
  218. /// <param name="sender"></param>
  219. /// <param name="e"></param>
  220. private void dgvClassesDetail_CellValueChanged(object sender, DataGridViewCellEventArgs e)
  221. {
  222. try
  223. {
  224. if (this.dgvClassesDetail.Rows.Count <= Constant.INT_IS_ONE || !_showFromFlag)
  225. {
  226. return;
  227. }
  228. DataGridViewRow rowItem = this.dgvClassesDetail.Rows[e.RowIndex];
  229. DataGridViewColumn columnItem = this.dgvClassesDetail.Columns[e.ColumnIndex];
  230. // 用编号获取员工信息
  231. if ("StaffCode".Equals(columnItem.Name)
  232. && !string.IsNullOrEmpty(this.dgvClassesDetail.Rows[e.RowIndex].Cells[columnItem.Name].Value + ""))
  233. {
  234. this._showFromFlag = false;
  235. FormUtility.BindStaffRowDataSource(this.dgvClassesDetail,
  236. e.RowIndex, columnItem.Name, this._staffCode, this.dkUserInfo.UserID.Value, true);
  237. this._showFromFlag = true;
  238. // 设置可输入单元格的颜色
  239. this.dgvClassesDetail.IsSetInputColumnsColor = true;
  240. // 不可出现重复的人员
  241. //for (int i = 0; i < this.dgvClassesDetail.Rows.Count; i++)
  242. //{
  243. // if (i != e.RowIndex)
  244. // {
  245. // if (this.dgvClassesDetail.Rows[i].IsNewRow == true)
  246. // {
  247. // return;
  248. // }
  249. // String NowStaffID = this.dgvClassesDetail.Rows[e.RowIndex].Cells["StaffID"].Value.ToString();
  250. // if (NowStaffID == string.Empty)
  251. // {
  252. // this.dgvClassesDetail.Rows.RemoveAt(e.RowIndex);
  253. // return;
  254. // }
  255. // String ForStaffID = "";
  256. // if (this.dgvClassesDetail.Rows[i].Cells["StaffID"].Value != null)
  257. // {
  258. // ForStaffID = this.dgvClassesDetail.Rows[i].Cells["StaffID"].Value.ToString();
  259. // }
  260. // if (NowStaffID == ForStaffID)
  261. // {
  262. // ((DataTable)this.dgvClassesDetail.DataSource).Rows[e.RowIndex].Delete();
  263. // //仅限当前页面,工号间的待修改
  264. // MessageBox.Show("员工信息不可重复配置!", this.Text,
  265. // MessageBoxButtons.OK, MessageBoxIcon.Warning);
  266. // return;
  267. // }
  268. // }
  269. //}
  270. }
  271. if (columnItem.Name == "UJobsId")
  272. {
  273. string JobsId = this.dgvClassesDetail.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
  274. if (JobsId == string.Empty)
  275. {
  276. if (((DataTable)this.dgvClassesDetail.DataSource).Rows[e.RowIndex]["UJobsId", DataRowVersion.Original] != null)
  277. {
  278. string OValue = ((DataTable)this.dgvClassesDetail.DataSource).Rows[e.RowIndex]["UJobsId", DataRowVersion.Original].ToString();
  279. ((DataTable)this.dgvClassesDetail.DataSource).Rows[e.RowIndex]["UJobsId"] = OValue;
  280. }
  281. else
  282. {
  283. ((DataTable)this.dgvClassesDetail.DataSource).Rows[e.RowIndex].Delete();
  284. }
  285. }
  286. }
  287. }
  288. catch (Exception ex)
  289. {
  290. this._showFromFlag = true;
  291. // 对异常进行共通处理
  292. ExceptionManager.HandleEventException(this.ToString(),
  293. System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  294. }
  295. }
  296. /// <summary>
  297. /// 单元格编辑时
  298. /// </summary>
  299. /// <param name="sender"></param>
  300. /// <param name="e"></param>
  301. private void dgvClassesDetail_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
  302. {
  303. try
  304. {
  305. if (this.dgvClassesDetail.Rows.Count <= Constant.INT_IS_ONE)
  306. {
  307. return;
  308. }
  309. DataGridViewColumn columnItem = this.dgvClassesDetail.Columns[e.ColumnIndex];
  310. if ("StaffCode".Equals(columnItem.Name))
  311. {
  312. this._staffCode = this.dgvClassesDetail.Rows[e.RowIndex].Cells[columnItem.Name].Value + "";
  313. }
  314. }
  315. catch (Exception ex)
  316. {
  317. // 对异常进行共通处理
  318. ExceptionManager.HandleEventException(this.ToString(),
  319. System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  320. }
  321. }
  322. /// <summary>
  323. /// 保存按钮事件
  324. /// </summary>
  325. /// <param name="sender"></param>
  326. /// <param name="e"></param>
  327. private void btnSave_Click(object sender, EventArgs e)
  328. {
  329. try
  330. {
  331. // 至少有一条明细信息
  332. if (isWhiteTable() == true)
  333. {
  334. MessageBox.Show("至少要有一条班次配置明细信息!",
  335. this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
  336. return;
  337. }
  338. // 验证界面必录项的录入;
  339. if (!this.CheckInputValidity())
  340. {
  341. return;
  342. }
  343. // 不可更改帐务日期之前的班次配置
  344. DateTime accountDate = CommonModuleProxy.Service.GetAccountDate();
  345. if (Convert.ToDateTime(this.dtpAccountDate.Text) < accountDate)
  346. {
  347. SearchClassesSettingEntity scsEntity = new SearchClassesSettingEntity();
  348. scsEntity.UserCode = this.dkUserInfo.UserCode;
  349. scsEntity.UserID = this.dkUserInfo.UserID;
  350. scsEntity.StartAccountDate = Convert.ToDateTime(Convert.ToDateTime(this.dtpAccountDate.Text).ToString("yyyy-MM-dd"));
  351. scsEntity.EndAccountDate = Convert.ToDateTime(scsEntity.StartAccountDate).AddHours(23)
  352. .AddMinutes(59).AddSeconds(59);
  353. //查询
  354. DataSet dsResult = (DataSet)DoAsync(new BaseAsyncMethod(() =>
  355. {
  356. return WCF.Proxys.PCModuleProxy.Service.SearchClassesSetting(scsEntity);
  357. }));
  358. if (dsResult.Tables[0].Rows.Count > Constant.INT_IS_ZERO)
  359. {
  360. MessageBox.Show("选择日期已存在班次配置,不可再次补录!",
  361. this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
  362. return;
  363. }
  364. }
  365. // 保存
  366. ClassesSettingEntity setEntity = new ClassesSettingEntity();
  367. setEntity.UserID = this.dkUserInfo.UserID.Value;
  368. setEntity.UserCode = this.dkUserInfo.UserCode;
  369. setEntity.UserName = this.dkUserInfo.UserName;
  370. setEntity.AccountDate = Convert.ToDateTime(this.dtpAccountDate.Text);
  371. setEntity.ClassesSettingID = this._classesSettingID;
  372. DataTable dTable = (DataTable)this.dgvClassesDetail.DataSource;
  373. dTable.AcceptChanges();
  374. // 修改table中的工号为当前配置的工号
  375. foreach (DataRow row in dTable.Rows)
  376. {
  377. row["UserID"] = this.dkUserInfo.UserID.Value;
  378. row["UserCode"] = this.dkUserInfo.UserCode;
  379. if (row["UJobsId"].ToString() == string.Empty && row["StaffCode"].ToString() == string.Empty)
  380. {
  381. continue;
  382. }
  383. if (row["UJobsId"].ToString() == string.Empty)
  384. {
  385. MessageBox.Show("请为所有员工配置工种!",
  386. this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
  387. return;
  388. }
  389. if (row["StaffCode"].ToString() == "")
  390. {
  391. MessageBox.Show("请为已选择工种配置员工!",
  392. this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
  393. return;
  394. }
  395. }
  396. this._returnRow = (int)DoAsync(new BaseAsyncMethod(() =>
  397. {
  398. return PCModuleProxy.Service.SaveClassesSetting(setEntity, dTable);
  399. }));
  400. if (this._returnRow > Constant.INT_IS_ZERO)
  401. {
  402. // 保存成功提示信息
  403. MessageBox.Show(string.Format(Messages.MSG_CMN_I001, "班次配置", "保存"),
  404. this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
  405. this.InitializationForm();
  406. }
  407. }
  408. catch (Exception ex)
  409. {
  410. // 对异常进行共通处理
  411. ExceptionManager.HandleEventException(this.ToString(),
  412. System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
  413. }
  414. }
  415. /// <summary>
  416. /// 取消按钮
  417. /// </summary>
  418. /// <param name="sender"></param>
  419. /// <param name="e"></param>
  420. private void btnCancel_Click(object sender, EventArgs e)
  421. {
  422. if (this._returnRow > Constant.INT_IS_ZERO)
  423. {
  424. this.DialogResult = System.Windows.Forms.DialogResult.OK;
  425. }
  426. else
  427. {
  428. this.DialogResult = System.Windows.Forms.DialogResult.Cancel;
  429. }
  430. }
  431. #endregion
  432. #region 私有方法
  433. /// <summary>
  434. /// 验证输入格式是否正确
  435. /// </summary>
  436. /// <returns></returns>
  437. private bool CheckInputValidity()
  438. {
  439. // 验证员工信息是否录入;
  440. if (string.IsNullOrEmpty(this.dkUserInfo.Text.Trim()))
  441. {
  442. MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "工号"),
  443. this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1);
  444. this.dkUserInfo.Focus();
  445. return false;
  446. }
  447. if (this.dgvClassesDetail.RowCount <= Constant.INT_IS_ONE)
  448. {
  449. MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "员工信息"),
  450. this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1);
  451. this.dgvClassesDetail.Focus();
  452. return false;
  453. }
  454. return true;
  455. }
  456. /// <summary>
  457. /// 清空输入项
  458. /// </summary>
  459. private void InitializationForm()
  460. {
  461. if (this._editStatus == Constant.FormMode.Add)
  462. {
  463. this.dkUserInfo.Text = "";
  464. this.txtRemarks.Clear();
  465. this.dgvClassesDetail.DataSource = null;
  466. }
  467. else
  468. {
  469. this.DialogResult = System.Windows.Forms.DialogResult.OK;
  470. }
  471. }
  472. /// <summary>
  473. /// 绑定用户工种
  474. /// </summary>
  475. private void BindUserJobs()
  476. {
  477. try
  478. {
  479. //获取可选择的工种数据源
  480. DataSet userJobsData = (DataSet)DoAsync(new BaseAsyncMethod(GetUserRowData));
  481. this.UJobsId.DisplayMember = "UserJobsName";
  482. this.UJobsId.ValueMember = "UserJobsId";
  483. this.UJobsId.DataSource = userJobsData.Tables[0];
  484. this._userJobsTable = userJobsData.Tables[0];
  485. }
  486. catch (Exception ex)
  487. {
  488. throw ex;
  489. }
  490. }
  491. /// <summary>
  492. /// 根据工号ID获取该工号的工种关联
  493. /// </summary>
  494. /// <returns></returns>
  495. private DataSet GetUserRowData()
  496. {
  497. try
  498. {
  499. return SystemModuleProxy.Service.GetJobByUserId(Convert.ToInt32(this.dkUserInfo.UserID));
  500. }
  501. catch (Exception ex)
  502. {
  503. throw ex;
  504. }
  505. }
  506. /// <summary>
  507. /// 是否空表
  508. /// </summary>
  509. /// <returns></returns>
  510. private bool isWhiteTable()
  511. {
  512. foreach (DataGridViewRow gvrFor in this.dgvClassesDetail.Rows)
  513. {
  514. if ((gvrFor.Cells["UJobsId"].Value != null && gvrFor.Cells["UJobsId"].Value.ToString() != "")
  515. || (gvrFor.Cells["StaffCode"].Value != null && gvrFor.Cells["StaffCode"].Value.ToString() != ""))
  516. {
  517. return false;
  518. }
  519. }
  520. return true;
  521. }
  522. #endregion
  523. }
  524. }