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()
{
}
}
}