MES_Client/TGMES/Core.StlMes.Client.ZGMil/Signature/FrmOfflineProcessAudit.cs

using com.steering.mes.zgmil.entity;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.ZGMil.Common;
using Core.StlMes.Client.ZGMil.Entity;
using Core.StlMes.Client.ZGMil.NodeResultQuery;
using Core.StlMes.Client.ZGMil.Popup;
using Core.StlMes.Client.ZGMil.Report;
using Core.StlMes.Client.ZGMil.ResultConrtrol;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace Core.StlMes.Client.ZGMil.Signature
{
    public partial class FrmOfflineProcessAudit : FrmBase
    {
        public FrmOfflineProcessAudit()
        {
            InitializeComponent();
            EntityHelper.ShowGridCaption<OfflineProcessAuditEntity>(ultraGrid1.DisplayLayout.Bands[0]);
        }
        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    doQuery();
                    break;
                case "Audit1":
                    doSave("1");
                    break;
                case "Audit2":
                    doSave("2");
                    break;
                case "Audit3":
                    doSave("3");
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        private void doQuery()
        {
            string StartTime = "";
            string EndTime = "";
            string isAudit = "";
            String id = "";
            if (ultraGrid1.ActiveRow != null) id = ultraGrid1.ActiveRow.Cells["ID"].Value.ToString();
            if (chkTim.Checked )
            {
                if (DateTime.Parse(startTime.Value.ToString()) > DateTime.Parse(endTime.Value.ToString()))
                {
                    MessageUtil.ShowTips("选择的前面时间不能大于后面的时间!");
                    return;
                }
                else
                {
                    StartTime = this.startTime.Value.ToString("yyyy-MM-dd");
                    EndTime = this.endTime.Value.ToString("yyyy-MM-dd");
                }
            }
            if (shr1.Checked)
            {
                isAudit = proc_chekedAudit(shr1.Checked, this.isAudit.Text.Trim());
            }
            
            dataSet1.Clear();
            this.dataTable1.Clear();
            this.dataTable2.Clear();
            DataTable dt = ServerHelper.GetData("com.steering.mes.signature.FrmOfflineProcessAudit.QueryOfflineProcessAudit", new object[] { StartTime, EndTime, isAudit }, ob);
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
            for (int i = 0; i < ultraGrid1.Rows.Count; i++)
            {
                if (ultraGrid1.Rows[i].Cells["ID"].Value.ToString().Equals(id))
                {
                    ultraGrid1.ActiveRow = ultraGrid1.Rows[i];
                    //ulgridSteelPlan.Rows[i].Selected = true;
                    return;
                }
                //else
                //{
                //    ulgridSteelPlan.ActiveRow = ulgridSteelPlan.Rows[i];
                //    //ulgridSteelPlan.Rows[i].Selected = true;
                //    return;
                //}
            }
        }
        private void FrmOfflineProcessAudit_Load(object sender, EventArgs e)
        {
            doQuery();
        }

        private void doSave(string ToolbarKey)
        {
            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要提交的信息!");
                return;
            }
            ArrayList parmList = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                OfflineProcessAuditEntity entity = new OfflineProcessAuditEntity();
                if (String.IsNullOrEmpty(row.Cells["ID"].Value.ToString()))
                    continue;
                if (ToolbarKey.Equals("1"))
                {
                    entity.Id = row.Cells["id"].Value.ToString();
                    entity.AuditDep2 = UserInfo.GetDepartment();
                    entity.Memo2 = memo2.Text;
                    entity.AuditMan2 = UserInfo.GetUserName();
                    entity.AuditTime2 = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                    entity.AuditState2 = "1";
                    entity.ResultNo = row.Cells["result_no"].Value.ToString();

                }
                if (ToolbarKey.Equals("2"))
                {
                    entity.Id = row.Cells["ID"].Value.ToString();
                    entity.AuditDep2 = "质保部";
                    entity.Memo2 = memo2.Text;
                    entity.AuditMan2 = UserInfo.GetUserName();
                    entity.AuditTime2 = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                    entity.AuditState2 = "2";
                    entity.ResultNo = row.Cells["result_no"].Value.ToString();
                }
                //entity.RecRevisor = UserInfo.GetUserName();
                string baseEntity = JSONFormat.Format(entity);
                parmList.Add(baseEntity);
            }
            if (parmList.Count > 0)
            {
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.mes.signature.FrmOfflineProcessAudit";
                ccp.MethodName = "doAddAudits";
                ccp.ServerParams = new object[] { parmList };
                ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    if (ccp.ReturnInfo.Equals("操作成功"))
                    {
                        // DoQueryInList();
                        doQuery();
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                    }
                    else
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                    }
                }
            }




            //if (ToolbarKey.Equals("1"))
            //{
            //    MessageUtil.ShowTips("质检标准类型不能为空!");
            //    return;
            //}
            //if (text_inspectStandName.Text == null || text_inspectStandName.Text.Equals(""))
            //{
            //    MessageUtil.ShowTips("质检标准名称不能为空!");
            //    return;
            //}
            //if (text_standStartDate.Text == null || text_standStartDate.Text.Equals(""))
            //{
            //    MessageUtil.ShowTips("标准开始日期不能为空!");
            //    return;
            //}
            //if (text_standEndDate.Text == null || text_standEndDate.Text.Equals(""))
            //{
            //    MessageUtil.ShowTips("标准结束日期不能为空!");
            //    return;
            //}
            //if (text_elmCode.Text == null || text_elmCode.Text.Equals(""))
            //{
            //    MessageUtil.ShowTips("元素代码不能为空!");
            //    return;
            //}
            //if (text_elmName.Text == null || text_elmName.Text.Equals(""))
            //{
            //    MessageUtil.ShowTips("元素名称不能为空!");
            //    return;
            //}

            //Tpopi26Entity entity = new Tpopi26Entity();
            //entity.InspectStandType = text_inspectStandType.Text;
            //entity.InspectStandName = text_inspectStandName.Text;
            //entity.StandStartDate = text_standStartDate.DateTime.ToString("yyyymmddHHmmss");
            //entity.StandEndDate = text_standEndDate.DateTime.ToString("yyyymmddHHmmss");
            //entity.ElmCode = text_elmCode.Text;
            //entity.ElmName = text_elmName.Text;
            //entity.InspectStandShort = text_inspectStandShort.Text;
            //entity.InspectOperatType = text_InspectOperatType.Text;
            //entity.JdeLevel = text_jdeLevel.Text;
            //entity.InspectStandDesc = text_InspectStandDesc.Text;
            //entity.RecCreator = UserInfo.GetUserName();
            //entity.RecRevisor = UserInfo.GetUserName();
            //entity.InspectStandCode = text_InspectStandCode.Text;
            //string baseEntity = JSONFormat.Format(entity);
            //if (ToolbarKey.Equals("ADD"))
            //{
            //    CoreClientParam ccp = new CoreClientParam();
            //    ccp.ServerName = "com.steering.lims.data.pipe.Tpopi26";
            //    ccp.MethodName = "doAdd";
            //    ccp.ServerParams = new object[] { new ArrayList { baseEntity } };
            //    ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            //    if (ccp.ReturnCode != -1)
            //    {
            //        doQuery();
            //        MessageUtil.ShowTips("新增成功！");
            //    }
            //}
            //if (ToolbarKey.Equals("Update"))
            //{
            //    CoreClientParam ccp = new CoreClientParam();
            //    ccp.ServerName = "com.steering.lims.data.pipe.Tpopi26";
            //    ccp.MethodName = "doUpdate";
            //    ccp.ServerParams = new object[] { new ArrayList { baseEntity } };
            //    ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            //    if (ccp.ReturnCode != -1)
            //    {
            //        doQuery();
            //        MessageUtil.ShowTips("保存成功！");
            //    }
            //}
            

        }

        private string proc_chekedAudit(bool cheked, string str)
        {
            switch (str)
            {
                case "等待评审":
                    return "0";
                case "开始评审":
                    return "1";
                case "评审通过":
                    return "2";
                default:
                    return "";
            }
        }

        private void doUpdate()
        {

            //this.ultraGrid1.UpdateData();
            //IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            //if (checkMagRows.Count() == 0)
            //{
            //    MessageUtil.ShowTips("请选择需要修改的信息!");
            //    return;
            //}
            //ArrayList parmList = new ArrayList();
            //foreach (UltraGridRow row in checkMagRows)
            //{
            //    Tpopi26Entity entity = row.ListObject as Tpopi26Entity;
            //    if (String.IsNullOrEmpty(entity.InspectStandCode) || String.IsNullOrEmpty(entity.JdeLevel) || String.IsNullOrEmpty(entity.ElmCode))
            //        continue;

            //    //entity.RecRevisor = UserInfo.GetUserName();
            //    string baseEntity = JSONFormat.Format(entity);
            //    parmList.Add(baseEntity);
            //}
            //if (parmList.Count > 0)
            //{
            //    CoreClientParam ccp = new CoreClientParam();
            //    ccp.ServerName = "com.steering.lims.data.pipe.Tpopi26";
            //    ccp.MethodName = "doUpdate";
            //    ccp.ServerParams = new object[] { parmList };
            //    ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            //    if (ccp.ReturnCode != -1)
            //    {
            //        doQuery();
            //        MessageUtil.ShowTips("修改成功！");
            //    }
            //}
        }

        private void doDelete()
        {
            //this.ultraGrid1.UpdateData();
            //IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            //if (checkMagRows.Count() == 0)
            //{
            //    MessageUtil.ShowTips("请选择需要删除的信息!");
            //    return;
            //}
            //ArrayList parmList = new ArrayList();
            //foreach (UltraGridRow row in checkMagRows)
            //{
            //    Tpopi26Entity entity = row.ListObject as Tpopi26Entity;
            //    if (String.IsNullOrEmpty(entity.InspectStandCode) || String.IsNullOrEmpty(entity.JdeLevel) || String.IsNullOrEmpty(entity.ElmCode))
            //        continue;
            //    string baseEntity = JSONFormat.Format(entity);
            //    parmList.Add(baseEntity);
            //}
            //if (parmList.Count > 0)
            //{
            //    CoreClientParam ccp = new CoreClientParam();
            //    ccp.ServerName = "com.steering.lims.data.pipe.Tpopi26";
            //    ccp.MethodName = "doDelete";
            //    ccp.ServerParams = new object[] { parmList };
            //    ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            //    if (ccp.ReturnCode != -1)
            //    {
            //        doQuery();
            //        MessageUtil.ShowTips("删除成功！");
            //    }
            //}
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            //try
            //{

            //    if (ultraGrid1.ActiveRow == null)
            //        return;
            //    Infragistics.Win.UltraWinGrid.UltraGridRow ulRow = ultraGrid1.ActiveRow;

            //    text_inspectStandType.Text = Convert.ToString(ulRow.Cells["InspectStandType"].Value);
            //    text_inspectStandName.Text = Convert.ToString(ulRow.Cells["InspectStandName"].Value);
            //    text_inspectStandShort.Text = Convert.ToString(ulRow.Cells["InspectStandShort"].Value);
            //    text_InspectStandCode.Text = Convert.ToString(ulRow.Cells["InspectStandCode"].Value);
            //    text_InspectOperatType.Text = Convert.ToString(ulRow.Cells["InspectOperatType"].Value);
            //    text_jdeLevel.Text = Convert.ToString(ulRow.Cells["JdeLevel"].Value);
            //    text_standStartDate.Text = Convert.ToString(ulRow.Cells["StandStartDate"].Value);
            //    text_standEndDate.Text = Convert.ToString(ulRow.Cells["StandEndDate"].Value);
            //    text_InspectStandDesc.Text = Convert.ToString(ulRow.Cells["InspectStandDesc"].Value);
            //    text_elmCode.Text = Convert.ToString(ulRow.Cells["ElmCode"].Value);
            //    text_elmName.Text = Convert.ToString(ulRow.Cells["ElmName"].Value);

            //   // text_inspectStandCode.Text = Convert.ToString(ulRow.Cells["InspectStandCode"].Value);
            //}
            //catch (Exception ex)
            //{
            //    MessageBox.Show(ex.Message, "提示");
            //}
        }

        private void ultraGrid1_AfterRowExpanded(object sender, RowEventArgs e)
        {
            e.Row.Activated = true;
            for (int i = 0; i < ultraGrid1.Rows.Count; i++)
            {
                if (ultraGrid1.Rows[i].Expanded == true && ultraGrid1.Rows[i].Activated == false)
                {
                    ultraGrid1.Rows[i].Expanded = false;
                }
            }
            string id = e.Row.Cells["ID"].Value.ToString();
            DataTable dt = ServerHelper.GetData("com.steering.mes.signature.FrmOfflineProcessAudit.QueryOfflineAudit", new object[] { id }, ob);
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable2, true);
            for (int idx = this.dataTable2.Rows.Count - 1; idx >= 0; idx--)
            {
                if (Convert.ToString(this.dataTable2.Rows[idx]["ID"]) == id)
                    this.dataTable2.Rows[idx].Delete();
            }
            this.dataTable2.AcceptChanges();
            DataRow newRow = null;
            foreach (DataRow row in dt.Rows)
            {
                newRow = this.dataTable2.NewRow();
                foreach (DataColumn col in dt.Columns)
                {
                    if (this.dataTable2.Columns.Contains(col.ColumnName))
                        newRow[col.ColumnName] = row[col.ColumnName];
                }
                this.dataTable2.Rows.Add(newRow);
            }
            this.dataTable2.AcceptChanges();
            //ClsControlPack.RefreshAndAutoSize(ulgridSteelPlan);
        }

        

    }
}