MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/基础信息管理/FrmCloutRetrieve.cs

using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Lims.Data.PipeAndOutdec.封装类.实体类;
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.Lims.Data.PipeAndOutdec
{
    public partial class FrmCloutRetrieve : FrmBase
    {
        PipeCloutRetrieveEntity entity;

        public PipeCloutRetrieveEntity Entity
        {
            get { return entity; }
            set { entity = value; }
        } 
        public FrmCloutRetrieve()
        {
            InitializeComponent();
            EntityHelper.ShowGridCaption<PipeCloutRetrieveEntity>(ultraGrid1.DisplayLayout.Bands[0]);
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    Query();
                    break;
                case "Add":
                    Add();
                    break;
                case "Update":
                    Update();
                    break;
                case "Nullify":
                    Delete();
                    break;
                case "Recover":
                    Recovery();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }


        private void Recovery()
        {
            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkRows = this.ultraGrid1.Rows.AsQueryable().Where(a => a.GetValue("CHK") == "True");
            ArrayList parms = new ArrayList();
            foreach (UltraGridRow row in checkRows)
            {
                PipeCloutRetrieveEntity parm = row.ListObject as PipeCloutRetrieveEntity;
                parm.UpdateName = this.UserInfo.GetUserName();
                parms.Add(JSONFormat.Format(parm));
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认恢复记录？") == DialogResult.No)
            {
                return;
            }
            List<string> jsons = new List<string>();
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.lims.data.pipe.FrmCloutRetrieve";
            ccp.MethodName = "UpdateValidflag";
            ccp.ServerParams = new object[] { parms, "1" };
            ccp.IfShowErrMsg = false;
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp != null)
            {
                if (ccp.ReturnCode == -1)
                {
                    MessageUtil.ShowWarning(ccp.ReturnInfo);
                    return;
                }
                MessageUtil.ShowTips("恢复成功！");
                Query();
            }
        }

        private void Delete()
        {
            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkRows = this.ultraGrid1.Rows.AsQueryable().Where(a => a.GetValue("CHK") == "True");
            ArrayList parms = new ArrayList();
            foreach (UltraGridRow row in checkRows)
            {
                PipeCloutRetrieveEntity parm = row.ListObject as PipeCloutRetrieveEntity;
                parm.DeleteName = this.UserInfo.GetUserName();
                parms.Add(JSONFormat.Format(parm));
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认作废记录？") == DialogResult.No)
            {
                return;
            }
            List<string> jsons = new List<string>();
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.lims.data.pipe.FrmCloutRetrieve";
            ccp.MethodName = "UpdateValidflag";
            ccp.ServerParams = new object[] { parms, "0" };
            ccp.IfShowErrMsg = false;
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp != null)
            {
                if (ccp.ReturnCode == -1)
                {
                    MessageUtil.ShowWarning(ccp.ReturnInfo);
                    return;
                }
                MessageUtil.ShowTips("作废成功！");
                Query();
            }
        }

        private void Update()
        {
            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkRows = this.ultraGrid1.Rows.AsQueryable().Where(a => a.GetValue("CHK") == "True");


            ArrayList parms = new ArrayList();
            foreach (UltraGridRow row in checkRows)
            {
                PipeCloutRetrieveEntity parm = row.ListObject as PipeCloutRetrieveEntity;
                parm.Steelcode = row.Cells["Steelcode"].Value.ToString2();
                parm.Steelname = row.Cells["Steelcode"].Text.ToString2();
                parm.CloutType = row.Cells["CloutType"].Text.ToString2();
                parm.UpdateName = this.UserInfo.GetUserName();
                parms.Add(JSONFormat.Format(parm));
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认修改记录？") == DialogResult.No)
            {
                return;
            }
            List<string> jsons = new List<string>();
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.lims.data.pipe.FrmCloutRetrieve";
            ccp.MethodName = "Update";
            ccp.ServerParams = new object[] { parms };
            ccp.IfShowErrMsg = false;
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp != null)
            {
                if (ccp.ReturnCode == -1)
                {
                    MessageUtil.ShowWarning(ccp.ReturnInfo);
                    return;
                }
                MessageUtil.ShowTips("修改成功！");
                Query();
            }
        }
        private void Add()
        {
            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkRows = this.ultraGrid1.Rows.AsQueryable().Where(a => a.GetValue("CHK") == "True");

            ArrayList parms = new ArrayList();
            foreach (UltraGridRow row in checkRows)
            {
                PipeCloutRetrieveEntity parm = row.ListObject as PipeCloutRetrieveEntity;
                parm.Steelcode = row.Cells["Steelcode"].Value.ToString2();
                parm.Steelname = row.Cells["Steelcode"].Text.ToString2();
                parm.CloutType = row.Cells["CloutType"].Text.ToString2();
                parm.CreateName = this.UserInfo.GetUserName();
                parms.Add(JSONFormat.Format(parm));
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认新增记录？") == DialogResult.No)
            {
                return;
            }
            List<string> jsons = new List<string>();
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.lims.data.pipe.FrmCloutRetrieve";
            ccp.MethodName = "Insert";
            ccp.ServerParams = new object[] { parms };
            //ccp.IfShowErrMsg = false;
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp != null)
            {
                if (ccp.ReturnCode == -1)
                {
                    MessageUtil.ShowWarning(ccp.ReturnInfo);
                    return;
                }
                MessageUtil.ShowTips("新增成功！");
                Query();
            }
        }

        private void Query()
        {
            string steelName = labelTextBox1.CheckBox.Checked ? labelTextBox1.Text.Trim() : "";
            string flag = ultraCheckEditor1.Checked ? "0" : "1";
            List<PipeCloutRetrieveEntity> listSource = EntityHelper.GetData<PipeCloutRetrieveEntity>(
            "com.steering.lims.data.pipe.FrmCloutRetrieve.Query", new object[] { steelName, flag }, this.ob);
            pipeCloutRetrieveEntityBindingSource.DataSource = listSource;
        }

        private void FrmCloutRetrieve_Load(object sender, EventArgs e)
        {
            // 查询钢种
            DataTable dt = ServerHelper.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.queryGrade", null, this.ob);
            Steel_S.DataSource = dt;
            Steel_S.DisplayMember = "GRADENAME";
            Steel_S.ValueMember = "GRADECODE";
            Steel_S.DataBind();

            Query();
        }
    }
}