XinYu_LZMES_Client/Core.LZMes.Client.UIF/UIF041/UIF041030.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using Common;

namespace Core.LZMes.Client.UIF
{
    public partial class UIF041030 : CoreFS.CA06.FrmBase
    {
        public UIF041030()
        {
            InitializeComponent();
        }

        #region "ComboBox Event"
        private void cmb_GrpType_ValueChanged(object sender, EventArgs e)
        {
            try
            {
                if (cmb_GrpType.Value.ToString() == "厚度")
                {
                    this.ugrd_Group.DataMember = "TBF02_ROLL_THK_GRP";
                    label6.Text = "厚度组";
                    this.txt_Mini.Mask = "9.999";
                    this.txt_Maxi.Mask = "9.999";
                    this.label1.Visible = true;
                    this.cmb_Type.Visible = true;
                    this.cmb_GrpType.Value = "厚度";
                }
                else
                {
                    this.ugrd_Group.DataMember = "TBF02_ROLL_WTH_GRP";
                    label6.Text = "宽度组";
                    this.txt_Mini.Mask = "9999";
                    this.txt_Maxi.Mask = "9999";
                    this.label1.Visible = false;
                    this.cmb_Type.Visible = false;
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }
        #endregion

        #region "ToolBar Event"
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            try
            {
                switch (ToolbarKey)
                {
                    case "Query":
                        Query_GrpInfo();
                        break;
                    case "Add":
                        Add_GrpInfo();
                        break;
                    case "Edit":
                        Edit_GrpInfo();
                        break;
                    case "Delete":
                        Del_GrpInfo();
                        break;
                    case "Exit":
                        this.Close();
                        break;
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }
        private void Query_GrpInfo()
        {
            try
            {
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIF.UIF04.UIF041030";
                ccp.MethodName = "Query_Group_Info";
                ccp.ServerParams = new object[] { "",this.cmb_GrpType.Value.ToString() };
                CoreClientParam obj = this.ExecuteQuery(ccp, CoreInvokeType.Internal);
                if (obj.ReturnInfo.Length == 0)
                {
                    if (this.cmb_GrpType.Value.ToString() == "厚度")
                    {
                        this.dataSet1.Tables["TBF02_ROLL_THK_GRP"].Clear();
                        System.Data.DataTable tab0 = FixDBManager.ConvertToDataTable(obj.ReturnObject as System.Collections.ArrayList, this.dataSet1.Tables["TBF02_ROLL_THK_GRP"]);
                        tab0.TableName = "TBF02_ROLL_THK_GRP";
                        this.dataSet1.Tables["TBF02_ROLL_THK_GRP"].Merge(tab0);
                        this.dataSet1.AcceptChanges();
                    }
                    else
                    {
                        this.dataSet1.Tables["TBF02_ROLL_WTH_GRP"].Clear();
                        System.Data.DataTable tab0 = FixDBManager.ConvertToDataTable(obj.ReturnObject as System.Collections.ArrayList, this.dataSet1.Tables["TBF02_ROLL_WTH_GRP"]);
                        tab0.TableName = "TBF02_ROLL_WTH_GRP";
                        this.dataSet1.Tables["TBF02_ROLL_WTH_GRP"].Merge(tab0);
                        this.dataSet1.AcceptChanges();
                    }
                   
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }
        private void Add_GrpInfo()
        {
            try
            {
                if (!CheckValue())
                    return;
                string sql = "";

                if (this.cmb_GrpType.Value.ToString() == "厚度")
                {
                    if (!CheckValueConstraints(FixDBManager.CheckNullStr(this.txt_Mini.Text), FixDBManager.CheckNullStr(this.txt_Maxi.Text), "TBF02_ROLL_THK_GRP","ADD"))
                        return;
                    sql = "INSERT INTO TBF02_ROLL_THK_GRP(PLT,THK_GRP_CD,MINI,MAXI,REG_DTIME,REG_ID,MOD_DTIME,MOD_ID,TYPE_) "
                         + "VALUES('C',"
                         + "'" + this.txt_GrpName.Text.Trim().ToUpper() + "',"
                         + FixDBManager.CheckNullStr(this.txt_Mini.Text) + ","
                         + FixDBManager.CheckNullStr(this.txt_Maxi.Text) + ","
                         + "TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),"
                         + "'" + CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName() + "',"
                         + "NULL,"
                         + "NULL,"
                         + "'" + this.cmb_Type.Value.ToString() + "'"
                         + ")";
                }
                else
                {
                    if (!CheckValueConstraints(FixDBManager.CheckNullStr(this.txt_Mini.Text), FixDBManager.CheckNullStr(this.txt_Maxi.Text), "TBF02_ROLL_WTH_GRP","ADD"))
                        return;
                    sql = "INSERT INTO TBF02_ROLL_WTH_GRP(PLT,WTH_GRP_CD,MINI,MAXI,REG_DTIME,REG_ID,MOD_DTIME,MOD_ID) "
                        + "VALUES('C',"
                        + "'" + this.txt_GrpName.Text.Trim().ToUpper() + "',"
                        + FixDBManager.CheckNullStr(this.txt_Mini.Text) + ","
                        + FixDBManager.CheckNullStr(this.txt_Maxi.Text) + ","
                        + "TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),"
                        + "'" + CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName() + "',"
                        + "NULL,"
                        + "NULL"
                        + ")";
                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIF.UIF04.UIF041030";
                ccp.MethodName = "Add_Group_Info";
                ccp.ServerParams = new object[] { sql };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if(ccp.ReturnInfo.Length==0)
                    Query_GrpInfo();
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }
        private void Edit_GrpInfo()
        {
            try
            {
                if (this.ugrd_Group.ActiveRow == null)
                {
                    MessageBox.Show("请选择您要修改的记录行");
                    return;
                }
                if (!CheckValue())
                    return;
                string sql = "";
                
                if (this.cmb_GrpType.Value.ToString() == "厚度")
                {
                    if (!CheckValueConstraints(FixDBManager.CheckNullStr(this.txt_Mini.Text), FixDBManager.CheckNullStr(this.txt_Maxi.Text), "TBF02_ROLL_THK_GRP","EDIT"))
                        return;
                    sql = "UPDATE TBF02_ROLL_THK_GRP SET THK_GRP_CD='" + this.txt_GrpName.Text.Trim().ToUpper() + "',"
                         + "MINI=" + FixDBManager.CheckNullStr(this.txt_Mini.Text) + ","
                         + "MAXI=" + FixDBManager.CheckNullStr(this.txt_Maxi.Text) + ","
                         + "MOD_DTIME=TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),"
                         + "MOD_ID='" + CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName() + "',"
                         + "TYPE_='" + this.cmb_Type.Value.ToString() + "' "
                         + "WHERE PLT='C' AND THK_GRP_CD='" + FixDBManager.CheckNullStr(this.ugrd_Group.ActiveRow.Cells["THK_GRP_CD"].Value) + "'";
                }
                else
                {
                    if (!CheckValueConstraints(FixDBManager.CheckNullStr(this.txt_Mini.Text), FixDBManager.CheckNullStr(this.txt_Maxi.Text), "TBF02_ROLL_WTH_GRP","EDIT"))
                        return;
                    sql = "UPDATE TBF02_ROLL_WTH_GRP SET WTH_GRP_CD='" + this.txt_GrpName.Text.Trim().ToUpper() + "',"
                         + "MINI=" + FixDBManager.CheckNullStr(this.txt_Mini.Text) + ","
                         + "MAXI=" + FixDBManager.CheckNullStr(this.txt_Maxi.Text) + ","
                         + "MOD_DTIME=TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),"
                         + "MOD_ID='" + CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName() + "' "
                         + "WHERE PLT='C' AND WTH_GRP_CD='" + FixDBManager.CheckNullStr(this.ugrd_Group.ActiveRow.Cells["WTH_GRP_CD"].Value) + "'";
                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIF.UIF04.UIF041030";
                ccp.MethodName = "Edit_Group_Info";
                ccp.ServerParams = new object[] { sql };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if(ccp.ReturnInfo.Length==0)
                    Query_GrpInfo();
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }
        private void Del_GrpInfo()
        {
            try
            {
                if (this.ugrd_Group.ActiveRow == null)
                {
                    MessageBox.Show("请选择您要删除的记录行");
                    return;
                }
                string sql = "";

                if (this.cmb_GrpType.Value.ToString() == "厚度")
                {
                    sql = "DELETE FROM TBF02_ROLL_THK_GRP WHERE PLT='C' AND THK_GRP_CD='" + FixDBManager.CheckNullStr(this.ugrd_Group.ActiveRow.Cells["THK_GRP_CD"].Value) + "'";
                }
                else
                {
                    sql = "DELETE FROM TBF02_ROLL_WTH_GRP WHERE PLT='C' AND WTH_GRP_CD='" + FixDBManager.CheckNullStr(this.ugrd_Group.ActiveRow.Cells["WTH_GRP_CD"].Value) + "'";
                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIF.UIF04.UIF041030";
                ccp.MethodName = "Delete_Group_Info";
                ccp.ServerParams = new object[] { sql };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if(ccp.ReturnInfo.Length==0)
                    Query_GrpInfo();
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }
        private bool CheckValue()
        {
            if (this.txt_GrpName.Text.Trim().Length == 0)
            {
                MessageBox.Show("请您确认组名");
                return false;
            }
            if (this.txt_Mini.Text.Trim().Length == 0)
            {
                MessageBox.Show("请您确认下限值");
                return false;
            }
            if (this.txt_Mini.Text.Trim().Length == 0)
            {
                MessageBox.Show("请您确认上限值");
                return false;
            }
            if (this.cmb_GrpType.Value.ToString() == "厚度")
            {
                if (this.cmb_Type.Text.Trim().Length == 0)
                {
                    MessageBox.Show("请您确认厚度组的区分");
                    return false;
                }
            }
            return true;
        }
        private bool CheckValueConstraints(string Mini,string Maxi,string TableName,string type)
        {
            string Condition = " AND ((MINI<=" + Mini + " AND " + Mini + "<MAXI) OR (MINI<=" + Maxi + " AND " + Maxi + "<MAXI)) ";

            if (type == "EDIT")
            {
                if(this.cmb_GrpType.Value.ToString()=="厚度")
                    Condition = Condition + " AND THK_GRP_CD<>'" + Common.FixDBManager.CheckNullStr(this.ugrd_Group.ActiveRow.Cells["THK_GRP_CD"].Value) + "'";
                else
                    Condition = Condition + " AND WTH_GRP_CD<>'" + Common.FixDBManager.CheckNullStr(this.ugrd_Group.ActiveRow.Cells["WTH_GRP_CD"].Value) + "'";
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "UIF.UIF04.UIF041030";
            ccp.MethodName = "Query_Group_Info";
            ccp.ServerParams = new object[] { Condition, this.cmb_GrpType.Value.ToString() };
            CoreClientParam obj = this.ExecuteQuery(ccp, CoreInvokeType.Internal);
            if (obj.ReturnInfo.Length == 0)
            {
                System.Data.DataTable tab = FixDBManager.ConvertToDataTable(obj.ReturnObject as System.Collections.ArrayList, this.dataSet1.Tables[TableName]);

                if (tab.Rows.Count> 0)
                {
                    MessageBox.Show("维护数据与已存在数据有交集，请检查");
                    return false;
                }
            }
            return true;
        }
        #endregion

        #region "Init"
        private void UIF041030_Load(object sender, EventArgs e)
        {
            try
            {
                this.cmb_GrpType.DisplayLayout.Bands[0].Columns[0].Band.ColHeadersVisible = false;
                this.cmb_GrpType.DisplayLayout.Bands[0].Columns[0].Width = this.cmb_GrpType.Width;

                this.cmb_Type.DisplayLayout.Bands[0].Columns[0].Band.ColHeadersVisible = false;
                this.cmb_Type.DisplayLayout.Bands[0].Columns[0].Width = this.cmb_Type.Width;
                cmb_GrpType.Value = "厚度";
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }
        #endregion

        #region "Grid Event"
        private void ugrd_Group_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {
                if (this.ugrd_Group.ActiveRow != null)
                {
                    if (this.cmb_GrpType.Text == "厚度")
                    {
                        this.txt_GrpName.Text = this.ugrd_Group.ActiveRow.Cells["THK_GRP_CD"].Value.ToString();
                        this.cmb_Type.Value = this.ugrd_Group.ActiveRow.Cells["TYPE_"].Value.ToString();
                    }
                    else
                    {
                        this.txt_GrpName.Text = this.ugrd_Group.ActiveRow.Cells["WTH_GRP_CD"].Value.ToString();
                    }   
                    this.txt_Mini.Text = this.ugrd_Group.ActiveRow.Cells["MINI"].Value.ToString();
                    this.txt_Maxi.Text = this.ugrd_Group.ActiveRow.Cells["MAXI"].Value.ToString();
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }
        #endregion
    }
}