MES_Client/TGMES/Core.StlMes.Client.Lims.Resource/资源管理/人员管理/FrmPmJJClassRecord.cs

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;

        }

        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        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()
        {

        }

        /// <summary>
        /// 确认接班
        /// </summary>
        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;
            }
        }

        /// <summary>
        /// 取消接班
        /// </summary>
        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;
            }
        }

        /// <summary>
        /// 交班
        /// </summary>
        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;
            }
        }

        /// <summary>
        /// 修改
        /// </summary>
        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;
            }
        }

        /// <summary>
        /// 删除
        /// </summary>
        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()
        {

        }
    }
}