using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using CoreFS.CA03; using CoreFS.CA04; using CoreFS.CA06; using System.Collections; using Infragistics.Win.UltraWinGrid; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Tool; using System; namespace Core.StlMes.Client.Lims.Resource { public partial class FrmPmJJClassRecord : FrmBase { private string[] arrId;//数据权限 public FrmPmJJClassRecord() { InitializeComponent(); } protected override void OnLoad(EventArgs e) { base.OnLoad(e); } private void FrmPmJJClassRecord_Load(object sender, EventArgs e) { arrId = this.ValidDataPurviewIds; //获取数据权限 InitColumns(); } private void InitColumns() { string[] arrColumnsBase = new string[] { "ISCONFIRM", "ISCONFIRM_DESC", "RECORD_ID", "DEPT_ID", "DEPT_NAME", "SEND_NAME", "SEND_TIME", "SEND_SHIFT", "SEND_CLASS", "MEETING", "DEVICE_RUN_STATE", "TOOLS_USAGE", "MEASURE_USAGE", "SAFE_STATE", "DEVICE_HEALTH", "SANITATION", "LIGHTING", "PRODUCT_STATE", "REMARK", "RECEIVE_NAME", "RECEIVE_TIME", "RECEIVE_SHIFT", "RECEIVE_CLASS", "RECEIVE_REMARK", "CONNECT_TIME" }; string[] arrCaptionBase = new string[] { "ISCONFIRM", "是否交接", "RECORD_ID", "科室", "科室", "交班人", "交班日期", "交班班次", "交班班组", "班前会", "设备运行", "工具", "量具", "安全", "设备卫生", "环境卫生", "照明", "生产情况", "其他", "接班人", "接班日期", "接班班次", "接班班组", "接班备注", "交接日期" }; PublicResource.InitColumns(arrColumnsBase, arrCaptionBase, dataTable1, ultraGrid1, new string[] { "ISCONFIRM", "RECORD_ID", "DEPT_ID" }, false, null); string[] arrColumnsDetail = new string[] { "CONNECT_TIME", "DEPT_NAME", "1", "2", "3", "0" }; string[] arrColumnsCaption = new string[] { "交接日期", "科室", "早班", "中班", "夜班", "常白班" }; PublicResource.InitColumns(arrColumnsDetail, arrColumnsCaption, dataTable2, ultraGrid2, new string[] { "DEPT_NAME" }, false, null); string department = UserInfo.GetDepartment(); string baseName = ""; //加载班前会 DataTable dt = PublicServer.GetData("com.steering.lims.resource.person.FrmPmJJClassRecord.initMeeting", new Object[] { "100201%", department }, ob); if (dt != null && dt.Rows.Count > 0) { txtMEETING.DataSource = dt; txtMEETING.ValueMember = "BASENAME"; } //加载生产情况 DataTable dt2 = PublicServer.GetData("com.steering.lims.resource.person.FrmPmJJClassRecord.initMeeting", new Object[] { "100202%", department }, ob); if (dt2 != null && dt.Rows.Count > 0) { txtPRODUCT_STATE.DataSource = dt2; txtPRODUCT_STATE.ValueMember = "BASENAME"; } DataTable lxDt = PublicServer.GetData("com.steering.lims.resource.person.FrmPmJJClassRecord.initMeeting", new Object[] { "100123%", department }, ob); if (lxDt.Rows.Count > 0 && lxDt != null) { baseName = lxDt.Rows[0][0].ToString(); } this.ultraLabel17.Text = "交接班记录" + " " + baseName; } /// /// 重写基类方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": QueryJJClassRecord(); break; case "Confirm": ConfirmJJClassRecord(); break; case "Cancel": CancelJJClassRecord(); break; case "Add": AddJJClassRecord(); break; case "Update": UpdateJJClassRecord(); break; case "Delete": DeleteJJClassRecord(); break; case "Clear": ClearJJClassRecordData(); break; case "Close": if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面?") == DialogResult.Yes) { this.Close(); } break; } } private void QueryJJClassRecord() { try { if (arrId == null) { arrId = this.ValidDataPurviewIds; } ArrayList arrayList = new ArrayList(); if (chkTime.Checked) { arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00"); arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59"); } else { arrayList.Add("0001/01/01 00:00:00"); arrayList.Add("9999/12/31 23:59:59"); } if (chkSEND_SHIFT.Checked) { arrayList.Add(ultraQuerySEND_SHIFT.Text.Trim()); } else { arrayList.Add(""); } if (chkDEPT_ID.Checked) { arrayList.Add(ultraQueryDEPT_ID.UltDept_Name == "" ? "" : ultraQueryDEPT_ID.UltDept_ID); } else { arrayList.Add(""); } DataTable dt = PublicServer.GetData("com.steering.lims.resource.person.FrmPmJJClassRecord.QueryJJClassRecord", new Object[] { arrayList, arrId }, ob); if (dt == null || dt.Rows.Count == 0) { dataTable1.Rows.Clear(); MessageUtil.ShowTips("没有交接班记录!"); return; } GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable1 GridHelper.RefreshAndAutoSize(ultraGrid1); } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } private void QueryJJClassRecordDetail() { } /// /// 确认接班 /// private void ConfirmJJClassRecord() { try { if (ultraGrid1.ActiveRow == null) { MessageUtil.ShowTips("请点击选择一条需要接班的记录!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认接班?") == DialogResult.Yes) { string strRECEIVE_SHIFT = ultraRECEIVE_SHIFT.Text.Trim() == "" ? UserInfo.GetUserOrderText() : ultraRECEIVE_SHIFT.Text.Trim(); string strRECORD_ID = ultraGrid1.ActiveRow.Cells["RECORD_ID"].Text.Trim(); ArrayList arrayList = new ArrayList(); arrayList.Add(UserInfo.GetUserName()); arrayList.Add(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));//接班日期 arrayList.Add(strRECEIVE_SHIFT);//接班班次 arrayList.Add(UserInfo.GetUserGroupText());//接班班组 arrayList.Add(txtRECEIVE_REMARK.Text.Trim()); arrayList.Add("1"); arrayList.Add("0"); arrayList.Add(strRECORD_ID); PublicServer.SetData("com.steering.lims.resource.person.FrmPmJJClassRecord.ConfirmJJClassRecord", new Object[] { UserInfo.GetDeptid(), strRECORD_ID, arrayList }, this.ob); QueryJJClassRecord(); MessageUtil.ShowTips("接班成功!"); } } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } /// /// 取消接班 /// private void CancelJJClassRecord() { try { if (ultraGrid1.ActiveRow == null) { MessageUtil.ShowTips("请点击选择一条需要取消接班的记录!"); return; } if (UserInfo.GetUserName() != ultraGrid1.ActiveRow.Cells["RECEIVE_NAME"].Text.Trim()) { MessageUtil.ShowTips("只能取消自己的接班记录!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认取消接班?") == DialogResult.Yes) { string strRECORD_ID = ultraGrid1.ActiveRow.Cells["RECORD_ID"].Text.Trim(); ArrayList arrayList = new ArrayList(); arrayList.Add(""); arrayList.Add("");//接班日期 arrayList.Add("");//接班班次 arrayList.Add("");//接班班组 arrayList.Add(""); arrayList.Add("0"); arrayList.Add("1"); arrayList.Add(strRECORD_ID); PublicServer.SetData("com.steering.lims.resource.person.FrmPmJJClassRecord.CancelJJClassRecord", new Object[] { arrayList }, this.ob); QueryJJClassRecord(); MessageUtil.ShowTips("取消接班成功!"); } } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } /// /// 交班 /// private void AddJJClassRecord() { try { if (MessageUtil.ShowYesNoAndQuestion("是否确认交班?") == DialogResult.Yes) { //string strSEND_SHIFT = ultraSEND_SHIFT.Text.Trim() == "" ? UserInfo.GetUserOrderText() : ultraSEND_SHIFT.Text.Trim(); string strSEND_SHIFT = UserInfo.GetUserOrderText(); ArrayList arrayList = new ArrayList(); arrayList.Add(UserInfo.GetDeptid()); arrayList.Add(UserInfo.GetDepartment()); arrayList.Add(UserInfo.GetUserName()); arrayList.Add(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));//交班日期 arrayList.Add(strSEND_SHIFT);//交班班次 arrayList.Add(UserInfo.GetUserGroupText());//交班班组 arrayList.Add(txtMEETING.Text.Trim()); arrayList.Add(txtDEVICE_RUN_STATE.Text.Trim()); arrayList.Add(txtTOOLS_USAGE.Text.Trim()); arrayList.Add(txtMEASURE_USAGE.Text.Trim()); arrayList.Add(txtSAFE_STATE.Text.Trim()); arrayList.Add(txtDEVICE_HEALTH.Text.Trim()); arrayList.Add(txtSANITATION.Text.Trim()); arrayList.Add(txtLIGHTING.Text.Trim()); arrayList.Add(txtPRODUCT_STATE.Text.Trim()); arrayList.Add(txtREMARK.Text.Trim()); arrayList.Add(DateTime.Now.ToString("yyyy-MM-dd")); PublicServer.SetData("com.steering.lims.resource.person.FrmPmJJClassRecord.AddJJClassRecord", new Object[] { strSEND_SHIFT, arrayList }, this.ob); QueryJJClassRecord(); MessageUtil.ShowTips("交班成功!"); } } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } /// /// 修改 /// private void UpdateJJClassRecord() { try { if (ultraGrid1.ActiveRow == null) { MessageUtil.ShowTips("请点击选择一条需要修改的记录!"); return; } if (UserInfo.GetUserName() != ultraGrid1.ActiveRow.Cells["SEND_NAME"].Text.Trim()) { MessageUtil.ShowTips("只能修改自己的交班记录!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认修改交班信息?") == DialogResult.Yes) { string strRECORD_ID = ultraGrid1.ActiveRow.Cells["RECORD_ID"].Text.Trim(); ArrayList arrayList = new ArrayList(); arrayList.Add(txtMEETING.Text.Trim()); arrayList.Add(txtDEVICE_RUN_STATE.Text.Trim()); arrayList.Add(txtTOOLS_USAGE.Text.Trim()); arrayList.Add(txtMEASURE_USAGE.Text.Trim()); arrayList.Add(txtSAFE_STATE.Text.Trim()); arrayList.Add(txtDEVICE_HEALTH.Text.Trim()); arrayList.Add(txtSANITATION.Text.Trim()); arrayList.Add(txtLIGHTING.Text.Trim()); arrayList.Add(txtPRODUCT_STATE.Text.Trim()); arrayList.Add(txtREMARK.Text.Trim()); arrayList.Add(strRECORD_ID); PublicServer.SetData("com.steering.lims.resource.person.FrmPmJJClassRecord.UpdateJJClassRecord", new Object[] { strRECORD_ID, arrayList }, this.ob); QueryJJClassRecord(); MessageUtil.ShowTips("修改交班信息成功!"); } } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } /// /// 删除 /// private void DeleteJJClassRecord() { try { if (ultraGrid1.ActiveRow == null) { MessageUtil.ShowTips("请点击选择一条需要删除的记录!"); return; } if (UserInfo.GetUserName() != ultraGrid1.ActiveRow.Cells["SEND_NAME"].Text.Trim()) { MessageUtil.ShowTips("只能删除自己的交班记录!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认删除交班信息?") == DialogResult.Yes) { string strRECORD_ID = ultraGrid1.ActiveRow.Cells["RECORD_ID"].Text.Trim(); PublicServer.SetData("com.steering.lims.resource.person.FrmPmJJClassRecord.DeleteJJClassRecord", new Object[] { strRECORD_ID }, this.ob); QueryJJClassRecord(); MessageUtil.ShowTips("删除交班信息成功!"); } } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } private void chkTime_CheckedChanged(object sender, EventArgs e) { this.dateBegin.Enabled = chkTime.Checked; this.dateEnd.Enabled = chkTime.Checked; } private void chkDEPT_ID_CheckedChanged(object sender, EventArgs e) { ultraQueryDEPT_ID.Enabled = chkDEPT_ID.Checked; } private void chkSEND_SHIFT_CheckedChanged(object sender, EventArgs e) { ultraQuerySEND_SHIFT.Enabled = chkSEND_SHIFT.Checked; } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { txtDEPT_NAME.Text = ultraGrid1.ActiveRow.Cells["DEPT_NAME"].Text.Trim(); txtSEND_NAME.Text = ultraGrid1.ActiveRow.Cells["SEND_NAME"].Text.Trim(); ultraSEND_SHIFT.Text = ultraGrid1.ActiveRow.Cells["SEND_SHIFT"].Text.Trim(); txtSEND_TIME.Text = ultraGrid1.ActiveRow.Cells["SEND_TIME"].Text.Trim(); txtRECEIVE_NAME.Text = ultraGrid1.ActiveRow.Cells["RECEIVE_NAME"].Text.Trim(); ultraRECEIVE_SHIFT.Text = ultraGrid1.ActiveRow.Cells["RECEIVE_SHIFT"].Text.Trim(); txtMEETING.Text = ultraGrid1.ActiveRow.Cells["MEETING"].Text.Trim(); txtDEVICE_RUN_STATE.Text = ultraGrid1.ActiveRow.Cells["DEVICE_RUN_STATE"].Text.Trim(); txtTOOLS_USAGE.Text = ultraGrid1.ActiveRow.Cells["TOOLS_USAGE"].Text.Trim(); txtMEASURE_USAGE.Text = ultraGrid1.ActiveRow.Cells["MEASURE_USAGE"].Text.Trim(); txtDEVICE_HEALTH.Text = ultraGrid1.ActiveRow.Cells["DEVICE_HEALTH"].Text.Trim(); txtSANITATION.Text = ultraGrid1.ActiveRow.Cells["SANITATION"].Text.Trim(); txtSAFE_STATE.Text = ultraGrid1.ActiveRow.Cells["SAFE_STATE"].Text.Trim(); txtLIGHTING.Text = ultraGrid1.ActiveRow.Cells["LIGHTING"].Text.Trim(); txtPRODUCT_STATE.Text = ultraGrid1.ActiveRow.Cells["PRODUCT_STATE"].Text.Trim(); txtREMARK.Text = ultraGrid1.ActiveRow.Cells["REMARK"].Text.Trim(); txtRECEIVE_REMARK.Text = ultraGrid1.ActiveRow.Cells["RECEIVE_REMARK"].Text.Trim(); } private void ClearJJClassRecordData() { } } }