MES_Client/TGMES/Core.StlMes.Client.BuyBillet/RptPVKFSetting.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.SA06;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
//using Infragistics.Win.UltraWinGrid;
using Infragistics.Win.Misc;
using CoreFS.CA06;
using System.Net;
using System.Collections;

namespace Core.StlMes.Client.BuyBillet
{
    public partial class RptPVKFSetting : FrmBase
    {
        private DataTable dt_pl = new DataTable();
        public RptPVKFSetting()
        {
            InitializeComponent();
            qydate.Value = DateTime.Today;
            id.Text = "";
            fj_id.Text = "";
            fgz_id.Text = "";
            qz_id.Text = "";
        }

        private void RptPVKFSetting_Load(object sender, EventArgs e)
        {
            //mylocations();
            clearedit("kf");
            clearedit("fj");
            clearedit("fgz");
            clearedit("qz");
        }

        private void mylocations()
        {
            uEGB_kf.Height = 198;
            uEGB_fj.Height = 198;
            uEGB_fgz.Height = 228;
            uEGB_qz.Height = 128;
            int w, h, ub_top, edge_b = 10;
            Point mypoint;
            w = uEGB_kf.Width;
            h = uEGB_kf.Height;
            w = Convert.ToInt32(w / 2);
            ub_top = h - edge_b - uB_savekf.Height;
            mypoint=new Point( Convert.ToInt32(w / 4) + Convert.ToInt32(uB_savekf.Width / 2),ub_top);
            uB_savekf.Location = mypoint;
            mypoint = new Point( Convert.ToInt32(w / 2) + Convert.ToInt32(uB_isvalid.Width / 2), ub_top);
            uB_isvalid.Location = mypoint;
            mypoint = new Point(Convert.ToInt32(w / 4 * 3) + Convert.ToInt32(uB_delete.Width / 2), ub_top);
            uB_delete.Location = mypoint;
            mypoint = new Point(w + Convert.ToInt32(w / 3) + Convert.ToInt32(uB_addkffj.Width / 2), ub_top);
            uB_addkffj.Location = mypoint;
            mypoint = new Point(w + Convert.ToInt32(w / 3 * 2) + Convert.ToInt32(uB_addkffgz.Width / 2), ub_top);
            uB_addkffgz.Location = mypoint;

            w = uEGB_fj.Width;
            h = uEGB_fj.Height;
            ub_top = h - edge_b - uB_savefj.Height;
            mypoint = new Point(Convert.ToInt32(w / 4) + Convert.ToInt32(uB_savefj.Width / 2), ub_top);
            uB_savefj.Location = mypoint;
            mypoint = new Point(Convert.ToInt32(w / 2) + Convert.ToInt32(uB_isvalidfj.Width / 2), ub_top);
            uB_isvalidfj.Location = mypoint;
            mypoint = new Point(Convert.ToInt32(w / 4 * 3) + Convert.ToInt32(uB_deletefj.Width / 2), ub_top);
            uB_deletefj.Location = mypoint;

            w = uEGB_fgz.Width;
            h = uEGB_fgz.Height;
            ub_top = h - edge_b - uB_savefgz.Height;
            mypoint = new Point(Convert.ToInt32(w / 4) + Convert.ToInt32(uB_savefgz.Width / 2), ub_top);
            uB_savefgz.Location = mypoint;
            mypoint = new Point(Convert.ToInt32(w / 2) + Convert.ToInt32(uB_isvalidfgz.Width / 2), ub_top);
            uB_isvalidfgz.Location = mypoint;
            mypoint = new Point(Convert.ToInt32(w / 4 * 3) + Convert.ToInt32(uB_deletefgz.Width / 2), ub_top);
            uB_deletefgz.Location = mypoint;

            w = uEGB_qz.Width;
            h = uEGB_qz.Height;
            ub_top = h - edge_b - uB_saveqz.Height;
            mypoint = new Point(Convert.ToInt32(w / 4) + Convert.ToInt32(uB_saveqz.Width / 2), ub_top);
            uB_saveqz.Location = mypoint;
            mypoint = new Point(Convert.ToInt32(w / 2) + Convert.ToInt32(uB_isvalidqz.Width / 2), ub_top);
            uB_isvalidqz.Location = mypoint;
            mypoint = new Point(Convert.ToInt32(w / 4 * 3) + Convert.ToInt32(uB_deleteqz.Width / 2), ub_top);
            uB_deleteqz.Location = mypoint;
        }


        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query":
                    {
                        getkfsetting();
                        getkfsettingfjx("", "qz");
                    }
                    break;
                case "Export":
                    Export();
                    break;
                case "Close":
                    this.Close();
                    break;

            }
        }
        private void Export()
        {
            GridHelper.ulGridToExcel(ultraGridkf, "生产流速——扣分");
        }

        private void getkfsetting()
        {
            WaitingForm2 wf = new WaitingForm2("正在加载数据,请稍候....");
            try
            {
                string mytype = uCb_kftype.SelectedIndex==-1?"1":uCb_kftype.SelectedItem.DataValue.ToString();

                DataTable dtqry = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getSCLS_KF", new object[] { mytype }, this.ob);
                dt_pl = ServerHelper.GetData("com.steering.rpt.scls.SCLS.get_pline", new object[] { }, this.ob);
                wf.Close();
                DataTable dt = (DataTable)ultraGridkf.DataSource;
                if (dt!=null && dt.Rows.Count > 0)
                    dt.Rows.Clear();
                ultraGridkf.DataSource = dtqry;
                setgridcolunmName(ultraGridkf,"kf");
                if (dtqry.Rows.Count>0)
                    ultraGridkf.Rows[0].Selected = true;
            }


            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
            finally
            {
                wf.Close();
            }
        }

        private void getkfsettingfjx(string id,string fjx)
        {
            try
            {
                string mytype = id;
                if (id == "")
                    mytype = uCb_kftype.SelectedIndex == -1 ? "1" : uCb_kftype.SelectedItem.DataValue.ToString();
                if (fjx == "fj")
                {
                    DataTable dtqry = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getSCLS_KFFJX1", new object[] { mytype }, this.ob);
                    DataTable dt = (DataTable)ultraGridkffj.DataSource;
                    if (dt != null && dt.Rows.Count > 0)
                        dt.Rows.Clear(); 
                    ultraGridkffj.DataSource = dtqry;
                    setgridcolunmName(ultraGridkffj, fjx);
                    if (dtqry.Rows.Count > 0)
                        ultraGridkffj.Rows[0].Selected = true;
                    else
                    {
                        clearedit(fjx);
                        txt_kftypefj.Text = txt_kftype.Text;
                        lab_kftypefj_name.Text = lab_kftype_name.Text;
                    }
                }
                else if (fjx == "fgz")
                {
                    DataTable dtqry = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getSCLS_KFFJX2", new object[] { mytype }, this.ob);
                    DataTable dt = (DataTable)ultraGridkffgz.DataSource;
                    if (dt != null && dt.Rows.Count > 0)
                        dt.Rows.Clear(); 
                    ultraGridkffgz.DataSource = dtqry;
                    setgridcolunmName(ultraGridkffgz, fjx);
                    if (dtqry.Rows.Count > 0)
                        ultraGridkffgz.Rows[0].Selected = true;
                    else
                    {
                        clearedit(fjx);
                        txt_kftypefgz.Text = txt_kftype.Text;
                        lab_kftypefgz_name.Text = lab_kftype_name.Text;
                    }

                }
                else if (fjx == "qz")
                {
                    DataTable dtqry = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getSCLS_KFQZ", new object[] {}, this.ob);
                    DataTable dt = (DataTable)ultraGridkfqz.DataSource;
                    if (dt != null && dt.Rows.Count > 0)
                        dt.Rows.Clear();
                    ultraGridkfqz.DataSource = dtqry;
                    setgridcolunmName(ultraGridkfqz, fjx);
                    if (dtqry.Rows.Count > 0)
                        ultraGridkfqz.Rows[0].Selected = true;
                    else
                    {
                        clearedit(fjx);
                    }

                }
            }


            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
        }

        private void setkfsettingkf(int index)
        {
            Infragistics.Win.UltraWinGrid.UltraGridRow myrow = ultraGridkf.Rows[index];
            id.Text = myrow.Cells["id"].Value.ToString();
            txt_kftype.Text = myrow.Cells["kftype"].Value.ToString();

            if (uCb_kftype.SelectedIndex > -1)
                lab_kftype_name.Text = uCb_kftype.Text;
            else
            {
                foreach (Infragistics.Win.ValueListItem mylist in uCb_kftype.Items)
                {
                    if (mylist.DataValue.ToString() == txt_kftype.Text)
                    {
                        lab_kftype_name.Text = mylist.DisplayText;
                        break;
                    }
                }
            }
            qydate.Value = Convert.ToDateTime(myrow.Cells["startime"].Value.ToString());
            kf.Value = Convert.ToInt32(myrow.Cells["kf"].Value);
            isvalid.Text = myrow.Cells["isvalid"].Value.ToString();
            min_range.Value = Convert.ToInt32(myrow.Cells["min_range"].Value);
            if (myrow.Cells["max_range"].Text == "")
                max_range.Value = null;
            else
                max_range.Value = Convert.ToInt32(myrow.Cells["max_range"].Value);
            for (int i = 0; i < cLB_processcode.Items.Count; i++)
            {
                cLB_processcode.SetItemChecked(i, false);
                if (myrow.Cells["processcode"].Value.ToString().Contains(cLB_processcode.Items[i].ToString()))
                    cLB_processcode.SetItemChecked(i, true);
            }
            lab_qztypename.Text = myrow.Cells["kftype_name"].Value.ToString();
        }
        private void setkdtypename()
        {
            if (kf.Value != null && min_range.Value != null)
            {
                lab_qztypename.Text = lab_kftype_name.Text + "，";
                if (max_range.Value == null)
                    lab_qztypename.Text += "超" + min_range.Value.ToString() + "天扣" + kf.Value.ToString() + "分";
                else
                    lab_qztypename.Text += min_range.Value.ToString() + "-" + max_range.Value.ToString() + "天扣" + kf.Value.ToString() + "分";
            }
            else if (min_range.Value != null)
            {
                lab_qztypename.Text = lab_kftype_name.Text + "，";
                if (max_range.Value == null)
                    lab_qztypename.Text += "超" + min_range.Value.ToString() + "天";
                else
                    lab_qztypename.Text += min_range.Value.ToString() + "-" + max_range.Value.ToString() + "天";
            }
            else if (kf.Value != null)
            {
                lab_qztypename.Text = lab_kftype_name.Text + "，";
                if (max_range.Value == null)
                    lab_qztypename.Text += "扣" + kf.Value.ToString() + "分";
                else
                    lab_qztypename.Text += "-" + max_range.Value.ToString() + "天扣" + kf.Value.ToString() + "分";
            }
        }

        private void setkfsettingfj(int index)
        {
            Infragistics.Win.UltraWinGrid.UltraGridRow myrow = ultraGridkffj.Rows[index];
            fj_id.Text = myrow.Cells["id"].Value.ToString();
            txt_kftypefj.Text = myrow.Cells["kftype"].Value.ToString();
            if (uCb_kftype.SelectedIndex > -1)
                lab_kftypefj_name.Text = uCb_kftype.Text;
            else
            {
                foreach (Infragistics.Win.ValueListItem mylist in uCb_kftype.Items)
                {
                    if (mylist.DataValue.ToString() == txt_kftype.Text)
                    {
                        lab_kftypefj_name.Text = mylist.DisplayText;
                        break;
                    }
                }
            }
            foreach (Infragistics.Win.ValueListItem mylist in uCb_fjtype.Items)
            {
                if (mylist.DataValue.ToString() == myrow.Cells["fjtype"].Value.ToString())
                {
                    uCb_fjtype.SelectedItem = mylist;
                    break;
                }
            }
            qydatefj.Value = Convert.ToDateTime(myrow.Cells["startime"].Value.ToString());
            fj_value.Value = Convert.ToInt32(myrow.Cells["fj_value"].Value);
            isvalidfj.Text = myrow.Cells["isvalid"].Value.ToString();
            for (int i = 0; i < cLB_processcodefj.Items.Count; i++)
            {
                cLB_processcodefj.SetItemChecked(i, false);
                if (myrow.Cells["processcode"].Value.ToString().Contains(cLB_processcodefj.Items[i].ToString()))
                    cLB_processcodefj.SetItemChecked(i, true);
            }
            lab_kdtypenamefj.Text = myrow.Cells["fjtype_name"].Value.ToString();
        }

        private void txt_kftypefj_TextChanged(object sender, EventArgs e)
        {
            setkdfjtypename();
        }

        private void uCb_fjtype_SelectionChanged(object sender, EventArgs e)
        {
            setkdfjtypename();
        }

        private void fj_value_ValueChanged(object sender, EventArgs e)
        {
            setkdfjtypename();
        }



        private void setkdfjtypename()
        {
            if (fj_value.Value != null && uCb_fjtype.SelectedIndex > -1)
                lab_kdtypenamefj.Text = uCb_fjtype.SelectedItem.DisplayText + "增加" + fj_value.Value.ToString() + "天";
            else if (uCb_fjtype.SelectedIndex > -1)
                lab_kdtypenamefj.Text = uCb_fjtype.SelectedItem.DisplayText;
            else if (fj_value.Value != null)
                lab_kdtypenamefj.Text = "增加" + fj_value.Value.ToString() + "天";
            else
                lab_kdtypenamefj.Text = "";
        }

        private void setkfsettingfgz(int index)
        {
            Infragistics.Win.UltraWinGrid.UltraGridRow myrow = ultraGridkffgz.Rows[index];
            fgz_id.Text = myrow.Cells["id"].Value.ToString();
            txt_kftypefgz.Text = myrow.Cells["kftype"].Value.ToString();
            if (uCb_kftype.SelectedIndex > -1)
                lab_kftypefj_name.Text = uCb_kftype.Text;
            else
            {
                foreach (Infragistics.Win.ValueListItem mylist in uCb_kftype.Items)
                {
                    if (mylist.DataValue.ToString() == txt_kftypefgz.Text)
                    {
                        lab_kftypefgz_name.Text = mylist.DisplayText;
                        break;
                    }
                }
            }

            foreach (Infragistics.Win.ValueListItem mylist in uCb_processcode.Items)
            {
                if (mylist.DataValue.ToString() == myrow.Cells["processcode"].Value.ToString())
                {
                    uCb_processcode.SelectedItem = mylist;
                    break;
                }
            }
            foreach (Infragistics.Win.ValueListItem mylist in uCb_pline.Items)
            {
                if (mylist.DataValue.ToString() == myrow.Cells["pline_code"].Value.ToString())
                {
                    uCb_pline.SelectedItem = mylist;
                    break;
                }
            }
            qydatefgz.Value = Convert.ToDateTime(myrow.Cells["startime"].Value.ToString());
            if (myrow.Cells["nowork_days"].Text == "")
                uCb_nowork_days.SelectedIndex = -1;
            else
            {
                foreach (Infragistics.Win.ValueListItem mylist in uCb_nowork_days.Items)
                {
                    if (mylist.DataValue.ToString() == myrow.Cells["nowork_days"].Value.ToString())
                    {
                        uCb_nowork_days.SelectedItem = mylist;
                        break;
                    }
                }
            }
            if (myrow.Cells["nowork_times"].Text == "")
                uCb_nowork_times.Value = null;
            else
                uCb_nowork_times.Value = Convert.ToInt32(myrow.Cells["nowork_times"].Value);
            isvalidfgz.Text = myrow.Cells["isvalid"].Value.ToString();
            txt_noworktime_desc.Text = myrow.Cells["noworktime_desc"].Value.ToString(); 
        }

        private void getpline()
        {
            DataView dv = dt_pl.DefaultView;
            dv.RowFilter = "process_code='" + uCb_processcode.SelectedItem.DataValue.ToString() + "'";
            dv.Sort = "process_code,pline_name";
            DataTable dt = dv.ToTable(true, "pline_code", "pline_name");//注：其中ToTable（）的第一个参数为是否DISTINCT
            uCb_pline.Items.Clear();
            uCb_pline.DisplayMember = "PLINE_NAME";
            uCb_pline.ValueMember = "PLINE_CODE";
            uCb_pline.DataSource = dt;
        }

        private void setkfsettingqz(int index)
        {
            Infragistics.Win.UltraWinGrid.UltraGridRow myrow = ultraGridkfqz.Rows[index];
            qz_id.Text = myrow.Cells["id"].Value.ToString();
            uCb_kfqztype.Enabled = false;
            foreach (Infragistics.Win.ValueListItem mylist in uCb_kfqztype.Items)
            {
                if (mylist.DataValue.ToString() == myrow.Cells["qztype"].Value.ToString())
                {
                    uCb_kfqztype.SelectedItem = mylist;
                    break;
                }
            }
            qydateqz.Value = Convert.ToDateTime(myrow.Cells["startime"].Value.ToString());
            qz.Value = Convert.ToInt32(myrow.Cells["qz"].Value);
            isvalidqz.Text = myrow.Cells["isvalid"].Value.ToString();
            lab_kfqztype_desc.Text = myrow.Cells["qztype_name"].Value.ToString();
        }

        private void uCb_kfqztype_SelectionChanged(object sender, EventArgs e)
        {
            setqztypename();
        }

        private void qz_ValueChanged(object sender, EventArgs e)
        {
            setqztypename();
        }

        private void setqztypename()
        {
            if (uCb_kfqztype.SelectedIndex > -1 && qz.Value != null)
                lab_kfqztype_desc.Text = uCb_kfqztype.Text + "（" + qz.Value.ToString() + "分）";
            else if (uCb_kfqztype.SelectedIndex > -1)
                lab_kfqztype_desc.Text = uCb_kfqztype.Text;
            else if (qz.Value != null)
                lab_kfqztype_desc.Text = "（" + qz.Value.ToString() + "分）";
            else 
                lab_kfqztype_desc.Text ="";
        }

        private void txt_kftypefgz_TextChanged(object sender, EventArgs e)
        {
            setfgztypename();
        }

        private void uCb_pline_SelectionChanged(object sender, EventArgs e)
        {
            setfgztypename();
        }

        private void uCb_nowork_days_SelectionChanged(object sender, EventArgs e)
        {
            setfgztypename();
        }

        private void uCb_nowork_times_ValueChanged(object sender, EventArgs e)
        {
            setfgztypename();
        }
        private void setfgztypename()
        {
            if (uCb_pline.SelectedIndex > -1 && uCb_nowork_days.SelectedIndex > -1 && uCb_nowork_times.Value != null)
                txt_noworktime_desc.Text = uCb_pline.Text + uCb_nowork_days.Text + uCb_nowork_times.Value.ToString() + "小时无班";
            else if (uCb_pline.SelectedIndex > -1 && (uCb_nowork_days.SelectedIndex > -1 && uCb_nowork_times.Value == null))
                txt_noworktime_desc.Text = uCb_pline.Text + uCb_nowork_days.Text+"无班";
            else if (uCb_pline.SelectedIndex > -1 && (uCb_nowork_days.SelectedIndex == -1 && uCb_nowork_times.Value != null))
                txt_noworktime_desc.Text = uCb_pline.Text + "每天" + uCb_nowork_times.Value.ToString()+ "小时无班";
            else if (uCb_pline.SelectedIndex > -1)
                txt_noworktime_desc.Text = uCb_pline.Text;
            else if (uCb_pline.SelectedIndex == -1 && uCb_nowork_days.SelectedIndex > -1 && uCb_nowork_times.Value != null)
                txt_noworktime_desc.Text = uCb_nowork_days.Text + uCb_nowork_times.Value.ToString() + "小时无班";
            else if (uCb_pline.SelectedIndex == -1 && (uCb_nowork_days.SelectedIndex > -1 && uCb_nowork_times.Value == null))
                txt_noworktime_desc.Text = uCb_nowork_days.Text + "无班";
            else if (uCb_pline.SelectedIndex == -1 && (uCb_nowork_days.SelectedIndex == -1 && uCb_nowork_times.Value != null))
                txt_noworktime_desc.Text = "每天" + uCb_nowork_times.Value.ToString() + "小时无班";
            else 
                txt_noworktime_desc.Text = "";
        }


        private void uCb_kftype_SelectionChanged(object sender, EventArgs e)
        {
            getkfsetting();
        }




        private void setgridcolunmName(Infragistics.Win.UltraWinGrid.UltraGrid ultraGrid, String sign)
        {
            Dictionary<string, string> gridcolunmnames = new Dictionary<string, string>();
            if (sign == "kf")
            {
                gridcolunmnames.Add("id".ToUpper(), "ID");
                gridcolunmnames.Add("kftype".ToUpper(), "扣分类型");
                gridcolunmnames.Add("processcode".ToUpper(), "大工序码");
                gridcolunmnames.Add("kf".ToUpper(), "扣分");
                gridcolunmnames.Add("min_range".ToUpper(), "最小值");
                gridcolunmnames.Add("max_range".ToUpper(), "最大值");
               gridcolunmnames.Add("kftype_name".ToUpper(), "扣分类型说明");
                gridcolunmnames.Add("startime".ToUpper(), "启用日期");
                gridcolunmnames.Add("endtime".ToUpper(), "结束日期");
                gridcolunmnames.Add("isvalid".ToUpper(), "有效");
                gridcolunmnames.Add("createtime".ToUpper(), "创建时间");
                gridcolunmnames.Add("updatetime".ToUpper(), "修改时间");

            }
            else if (sign == "fj")
            {
                gridcolunmnames.Add("id".ToUpper(), "ID");
                gridcolunmnames.Add("kftype".ToUpper(), "扣分类型");
                gridcolunmnames.Add("fjtype".ToUpper(), "附加类型");
                gridcolunmnames.Add("fjtype_name".ToUpper(), "附加类型说明");
                gridcolunmnames.Add("processcode".ToUpper(), "大工序码");
                gridcolunmnames.Add("fj_value".ToUpper(), "增加天数");
                gridcolunmnames.Add("isvalid".ToUpper(), "有效");
                gridcolunmnames.Add("startime".ToUpper(), "启用日期");
                gridcolunmnames.Add("createtime".ToUpper(), "创建时间");
                gridcolunmnames.Add("updatetime".ToUpper(), "修改时间");
            }
            else if (sign == "fgz")
            {
                gridcolunmnames.Add("id".ToUpper(), "ID");
                gridcolunmnames.Add("kftype".ToUpper(), "扣分类型");
                gridcolunmnames.Add("noworktime_desc".ToUpper(), "非工作日说明");
                gridcolunmnames.Add("processcode".ToUpper(), "大工序码");
                gridcolunmnames.Add("pline_code".ToUpper(), "产线码");
                gridcolunmnames.Add("pline_name".ToUpper(), "产线");
                gridcolunmnames.Add("nowork_times".ToUpper(), "非工作小时");
                gridcolunmnames.Add("nowork_days".ToUpper(), "非工作星期");
                gridcolunmnames.Add("isvalid".ToUpper(), "有效");
                gridcolunmnames.Add("startime".ToUpper(), "启用日期");
                gridcolunmnames.Add("createtime".ToUpper(), "创建时间");
                gridcolunmnames.Add("updatetime".ToUpper(), "修改时间");

            }
            else if (sign == "qz")
            {
                gridcolunmnames.Add("id".ToUpper(), "ID");
                gridcolunmnames.Add("qztype".ToUpper(), "权重类型");
                gridcolunmnames.Add("qztype_name".ToUpper(), "权重说明");
                gridcolunmnames.Add("qz".ToUpper(), "权重");
                gridcolunmnames.Add("isvalid".ToUpper(), "有效");
                gridcolunmnames.Add("startime".ToUpper(), "启用日期");
                gridcolunmnames.Add("createtime".ToUpper(), "创建时间");
                gridcolunmnames.Add("updatetime".ToUpper(), "修改时间");
            }

            ultraGrid.DataBind();
            ultraGrid.DisplayLayout.Bands[0].Header.Appearance.TextHAlign = Infragistics.Win.HAlign.Center;
            ultraGrid.DisplayLayout.Bands[0].Header.Appearance.FontData.Name = "宋体";
            ultraGrid.DisplayLayout.Bands[0].Header.Appearance.FontData.SizeInPoints = 18;


            ultraGrid.DisplayLayout.UseFixedHeaders = true;
            foreach (Infragistics.Win.UltraWinGrid.UltraGridBand band in ultraGrid.DisplayLayout.Bands)
            {
                foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn column in band.Columns)
                {
                    column.Header.Caption = gridcolunmnames[column.Key].ToString();
                    if (column.Key == "ID" || column.Key == "PLINE_CODE")
                    {
                        column.Hidden = true;
                    }

                    column.PerformAutoResize(Infragistics.Win.UltraWinGrid.PerformAutoSizeType.AllRowsInBand);
                }
            }


            ultraGrid.Refresh();
        }

        private void ultraGridkf_AfterSelectChange(object sender, Infragistics.Win.UltraWinGrid.AfterSelectChangeEventArgs e)
        {
            Infragistics.Win.UltraWinGrid.UltraGrid mygrid = (Infragistics.Win.UltraWinGrid.UltraGrid) sender;
            string mykftype = "";
            if (mygrid.Selected.Rows.Count > 0)
            {
                setkfsettingkf(mygrid.Selected.Rows[0].Index);
                mykftype = ultraGridkf.Rows[mygrid.Selected.Rows[0].Index].Cells["kftype"].Value.ToString();
                getkfsettingfjx(mykftype, "fj");
                getkfsettingfjx(mykftype, "fgz");
            }
            else
            {

            }

           // getkfsettingfjx1(mygrid.Selected.Rows[0].Cells["id"].Value.ToString(), "1");
           // getkfsettingfjx1(mygrid.Selected.Rows[0].Cells["id"].Value.ToString(), "2");

        }

        private void kf_ValueChanged(object sender, EventArgs e)
        {
            setkdtypename();
        }

        private void min_range_ValueChanged(object sender, EventArgs e)
        {
            setkdtypename();
        }

        private void max_range_ValueChanged(object sender, EventArgs e)
        {
            setkdtypename();
        }

        private void txt_kftype_TextChanged(object sender, EventArgs e)
        {
            setkdtypename();
        }
        private void clearedit(string sign)
        {
            if (sign == "kf")
            {
                Infragistics.Win.UltraWinGrid.UltraGrid mygrid=ultraGridkf;
                if (mygrid.Selected.Rows.Count > 0)
                    mygrid.Rows[mygrid.Selected.Rows[0].Index].Selected = false;
                id.Text = "";
                txt_kftype.Text = "";
                lab_kftype_name.Text = "";
                qydate.Value = DateTime.Today;
                kf.Value = null;
                min_range.Value = null;
                max_range.Value = null;
                for (int i = 0; i < cLB_processcode.Items.Count; i++)
                {
                    cLB_processcode.SetItemChecked(i, false);
                }
                isvalid.Text = "0";
                lab_qztypename.Text = "";
            }
            else if (sign == "fj")
            {
                Infragistics.Win.UltraWinGrid.UltraGrid mygrid = ultraGridkffj;
                if (mygrid.Selected.Rows.Count > 0)
                    mygrid.Rows[mygrid.Selected.Rows[0].Index].Selected = false;
                fj_id.Text = "";
                txt_kftypefj.Text = "";
                lab_kftypefj_name.Text = "";
                uCb_fjtype.SelectedIndex = -1;
                qydatefj.Value = DateTime.Today;
                fj_value.Value = null;
                isvalidfj.Text = "0";
                for (int i = 0; i < cLB_processcodefj.Items.Count; i++)
                {
                    cLB_processcodefj.SetItemChecked(i, false);
                }
            }
            else if (sign == "fgz")
            {
                Infragistics.Win.UltraWinGrid.UltraGrid mygrid = ultraGridkffgz;
                if (mygrid.Selected.Rows.Count > 0)
                    mygrid.Rows[mygrid.Selected.Rows[0].Index].Selected = false;
                fgz_id.Text = "";
                txt_kftypefgz.Text = "";
                lab_kftypefgz_name.Text = "";
                uCb_processcode.SelectedIndex = -1;
                uCb_pline.Items.Clear();
                qydatefgz.Value = DateTime.Today;
                uCb_nowork_days.SelectedIndex = -1;
                uCb_nowork_times.Value = null;
                isvalidfgz.Text = "0";
                txt_noworktime_desc.Text = "";
            }
            else if (sign == "qz")
            {
                Infragistics.Win.UltraWinGrid.UltraGrid mygrid = ultraGridkfqz;
                if (mygrid.Selected.Rows.Count > 0)
                    mygrid.Rows[mygrid.Selected.Rows[0].Index].Selected = false;
                uCb_kfqztype.Enabled = true;
                uCb_kfqztype.SelectedIndex = -1;
                qz_id.Text = "";
                qz.Value = null;
                qydateqz.Value = DateTime.Today;
                isvalidqz.Text = "0";
                lab_kfqztype_desc.Text = "";
            }

        }
        private void uB_addkf_Click(object sender, EventArgs e)
        {
            if (uCb_kftype.SelectedIndex == -1)
                this.alert("请先选择流速扣分类型");
            else
            {
                clearedit("kf");
                txt_kftype.Text = uCb_kftype.Value.ToString();
                lab_kftype_name.Text = uCb_kftype.Text;
            }

        }

        private void uB_addkfqz_Click(object sender, EventArgs e)
        {
            clearedit("qz");
        }

        private void uB_addkffj_Click(object sender, EventArgs e)
        {
            if (id.Text == "")
                this.alert("请先选择流速扣分记录");
            else
            {
                clearedit("fj");
                txt_kftypefj.Text = txt_kftype.Text;
                lab_kftypefj_name.Text = lab_kftype_name.Text;
            }
        }

        private void uB_addkffgz_Click(object sender, EventArgs e)
        {
            if (id.Text == "")
                this.alert("请先选择流速扣分记录");
            else
            {
                clearedit("fgz");
                txt_kftypefgz.Text = txt_kftype.Text;
                lab_kftypefgz_name.Text = lab_kftype_name.Text;
            }
        }

        private void uCb_processcode_SelectionChanged(object sender, EventArgs e)
        {
            if (uCb_processcode.SelectedIndex > -1)
                getpline();
            else
                uCb_pline.Clear();
        }

        private void ultraGridkffj_AfterSelectChange(object sender, Infragistics.Win.UltraWinGrid.AfterSelectChangeEventArgs e)
        {
            Infragistics.Win.UltraWinGrid.UltraGrid mygrid = (Infragistics.Win.UltraWinGrid.UltraGrid)sender;
            if (mygrid.Selected.Rows.Count>0)
                setkfsettingfj(mygrid.Selected.Rows[0].Index);

        }

        private void ultraGridkfqz_AfterSelectChange(object sender, Infragistics.Win.UltraWinGrid.AfterSelectChangeEventArgs e)
        {
            Infragistics.Win.UltraWinGrid.UltraGrid mygrid = (Infragistics.Win.UltraWinGrid.UltraGrid)sender;
            if (mygrid.Selected.Rows.Count > 0)
                setkfsettingqz(mygrid.Selected.Rows[0].Index);

        }

        private void ultraGridkffgz_AfterSelectChange(object sender, Infragistics.Win.UltraWinGrid.AfterSelectChangeEventArgs e)
        {
            Infragistics.Win.UltraWinGrid.UltraGrid mygrid = (Infragistics.Win.UltraWinGrid.UltraGrid)sender;
            if (mygrid.Selected.Rows.Count > 0)
                setkfsettingfgz(mygrid.Selected.Rows[0].Index);

        }

      

        private void uCb_kftype_TextChanged(object sender, EventArgs e)
        {
            if (uCb_kftype.Text == "")
            {
                getkfsetting();
                getkfsettingfjx("", "qz");
            }
            else if (uCb_kftype.Text != "" && uCb_kftype.SelectedIndex == -1)
                uCb_kftype.Text = "";
        }

        private void setuCbselectedindex(Infragistics.Win.UltraWinEditors.UltraComboEditor myuCb,String myvalue,string sign)
        {
            foreach (Infragistics.Win.ValueListItem mylist in myuCb.Items)
            {
                if (sign == "value" && mylist.DataValue.ToString() == myvalue)
                {
                    myuCb.SelectedItem = mylist;
                    break;
                }
                else if (sign == "text" && mylist.DisplayText.ToString() == myvalue)
                {
                    myuCb.SelectedItem = mylist;
                    break;
                }
            }
        }

        private void uCb_kfqztype_TextChanged(object sender, EventArgs e)
        {
            if (uCb_kfqztype.Text == "")
                setqztypename();
            else if (uCb_kfqztype.Text != "" && uCb_kfqztype.SelectedIndex == -1)
                uCb_kfqztype.Text = "";
        }

        private void uCb_fjtype_TextChanged(object sender, EventArgs e)
        {
            if (uCb_fjtype.Text == "")
                setkdfjtypename();
            else if (uCb_fjtype.Text != "" && uCb_fjtype.SelectedIndex == -1)
                uCb_fjtype.Text = "";
        }

        private void uCb_processcode_TextChanged(object sender, EventArgs e)
        {
            if (uCb_processcode.Text == "")
                setfgztypename();
            else if (uCb_processcode.Text != "" && uCb_processcode.SelectedIndex == -1)
                uCb_processcode.Text = "";
        }

        private void uCb_pline_TextChanged(object sender, EventArgs e)
        {
            if (uCb_pline.Text == "")
                setfgztypename();
            else if (uCb_pline.Text != "" && uCb_pline.SelectedIndex == -1)
                uCb_pline.Text = "";
        }

        private void uCb_nowork_days_TextChanged(object sender, EventArgs e)
        {
            if (uCb_nowork_days.Text == "")
                setfgztypename();
            else if (uCb_nowork_days.Text != "" && uCb_nowork_days.SelectedIndex == -1)
                uCb_nowork_days.Text = "";
        }
        private void setbutton(string sign)
        {
            if (sign == "kf")
            {
                if (id.Text == "")
                {
                    uB_isvalid.Enabled = false;
                    uB_delete.Enabled = false;
                }
                else
                {
                    uB_isvalid.Enabled = true;
                    if (isvalid.Text == "0")
                    {
                        uB_isvalid.Text = "启用";
                        uB_delete.Enabled = true;
                    }
                    else
                    {
                        uB_isvalid.Text = "停用";
                        uB_delete.Enabled = false;
                    }
                }
            }
            else if (sign == "fj")
            {
                if (fj_id.Text == "")
                {
                    uB_isvalidfj.Enabled = false;
                    uB_deletefj.Enabled = false;
                }
                else
                {
                    uB_isvalidfj.Enabled = true;
                    if (isvalidfj.Text == "0")
                    {
                        uB_isvalidfj.Text = "启用";
                        uB_deletefj.Enabled = true;
                    }
                    else
                    {
                        uB_isvalidfj.Text = "停用";
                        uB_deletefj.Enabled = false;
                    }
                }
            }
            else if (sign == "fgz")
            {
                if (fgz_id.Text == "")
                {
                    uB_isvalidfgz.Enabled = false;
                    uB_deletefgz.Enabled = false;
                }
                else
                {
                    uB_isvalidfgz.Enabled = true;
                    if (isvalidfgz.Text == "0")
                    {
                        uB_isvalidfgz.Text = "启用";
                        uB_deletefgz.Enabled = true;
                    }
                    else
                    {
                        uB_isvalidfgz.Text = "停用";
                        uB_deletefgz.Enabled = false;
                    }
                }
            }
            else if (sign == "qz")
            {
                if (qz_id.Text == "")
                {
                    uB_isvalidqz.Enabled = false;
                    uB_deleteqz.Enabled = false;
                }
                else
                {
                    uB_isvalidqz.Enabled = true;
                    if (isvalidqz.Text == "0")
                    {
                        uB_isvalidqz.Text = "启用";
                        uB_deleteqz.Enabled = true;
                    }
                    else
                    {
                        uB_isvalidqz.Text = "停用";
                        uB_deleteqz.Enabled = false;
                    }
                }
            }
        }

 

        private void isvalid_TextChanged(object sender, EventArgs e)
        {
            setbutton("kf");
        }

        private void isvalidfj_TextChanged(object sender, EventArgs e)
        {
            setbutton("fj");
        }

        private void isvalidfgz_TextChanged(object sender, EventArgs e)
        {
            setbutton("fgz");
        }

        private void isvalidqz_TextChanged(object sender, EventArgs e)
        {
            setbutton("qz");
        }

        private void id_TextChanged(object sender, EventArgs e)
        {
            setbutton("kf");
        }

        private void qz_id_TextChanged(object sender, EventArgs e)
        {
            setbutton("qz");
        }

        private void fj_id_TextChanged(object sender, EventArgs e)
        {
            setbutton("fj");
        }

        private void fgz_id_TextChanged(object sender, EventArgs e)
        {
            setbutton("fgz");
        }

        private bool getifConfirm(UltraButton mybutoon, string othermessage = "",string sign="")
        {
            bool Confirm = false;
            string mymessge = othermessage != "" ? othermessage + "\n" : "";
            if (sign=="")
                mymessge += "确实要" + mybutoon.Text + "该记录吗？";
            else
                mymessge = "确实要" + othermessage+sign + "吗？";
            if (MessageBox.Show(mymessge, "提交", MessageBoxButtons.YesNo,MessageBoxIcon.Information) == DialogResult.Yes)
                Confirm = true;
            return Confirm;
        }

        private void uB_savekf_Click(object sender, EventArgs e)
        {
            if (txt_kftype.Text == "")
            {
                this.alert("流速扣分类型不能为空！");
            }
            else if (kf.Value == null || kf.Value.ToString() == "")
            {
                this.alert("最小天数不能为空！");
                //kf.Focus();
            }
            else if (min_range.Value == null || min_range.Value.ToString() == "")
            {
                this.alert("最小天数不能为空！");
                //min_range.Focus();
            }
            else if (cLB_processcode.CheckedItems.Count == 0)
            {
                this.alert("适用大工序不能为空！");
                //cLB_processcode.Focus();
            }
            else if (getifConfirm((UltraButton)sender, "请确认扣分类型、扣分、范围等内容已填写正确。"))
            {
                savedata("kf");
            }

        }



        private void uB_savefj_Click(object sender, EventArgs e)
        {
            if (txt_kftypefj.Text == "")
            {
                this.alert("流速扣分类型不能为空！");
            }
            else if (uCb_fjtype.SelectedIndex < 0)
            {
                this.alert("附加类型不能为空！");
                //uCb_fjtype.Focus();
            }
            else if (fj_value.Value == null || fj_value.Value.ToString() == "")
            {
                this.alert("增加天数不能为空！");
                //fj_value.Focus();
            }
            else if (cLB_processcodefj.CheckedItems.Count == 0)
            {
                this.alert("适用大工序不能为空！");
                //cLB_processcodefj.Focus();
            }
            else if (getifConfirm((UltraButton)sender, "请确认扣分类型、增项类型、增加天数、大工序等内容已填写正确。"))
            {
                savedata("fj");
            }
        }

        private void uB_savefgz_Click(object sender, EventArgs e)
        {
            if (txt_kftypefgz.Text == "")
            {
                this.alert("流速扣分类型不能为空！");
            }
            else if (uCb_processcode.SelectedIndex < 0)
            {
                this.alert("大工序不能为空！");
                //uCb_processcode.Focus();
            }
            else if (uCb_pline.SelectedIndex < 0)
            {
                this.alert("产线不能为空！");
                //uCb_pline.Focus();
            }
            else if (uCb_nowork_days.SelectedIndex == -1 && (uCb_nowork_times.Value == null || uCb_nowork_times.Value.ToString() == ""))
            {
                this.alert("非工作星期和小时不能同时为空！");
                //uCb_nowork_days.Focus();
            }
            else if (txt_noworktime_desc.Text == "")
            {
                this.alert("说明不能为空！");
                //txt_noworktime_desc.Focus();
            }
            else if (getifConfirm((UltraButton)sender, "请确认扣分类型、产线、非工作星期、小时以及说明等内容已填写正确。"))
            {
                savedata("fgz");
            }
        }

        private void uB_saveqz_Click(object sender, EventArgs e)
        {
            if (uCb_kfqztype.SelectedIndex < 0)
            {
                this.alert("流速扣分权重类型不能为空！");
                //uCb_kfqztype.Focus();
            }
            else if (qz.Value == null || qz.Value.ToString() == "")
            {
                this.alert("权重不能为空！");
                //qz.Focus();
            }
            else if (getifConfirm((UltraButton)sender, "请确认扣分权重类型、权重等内容已填写正确。"))
            {
                savedata("qz");
            }
        }

        private void savedata(string sign)
        {
            try
            {
                bool isnew = false;
                object[] myobj = new object[] { };
                Infragistics.Win.UltraWinGrid.UltraGrid myulgrid = new Infragistics.Win.UltraWinGrid.UltraGrid();
                UltraButton myuB_save = new UltraButton();
                string sql = "";
                String myid = ""; 
                if (sign == "kf")
                {
                    myuB_save = uB_savekf;
                    String kftype, processcode = "", mymin_range, mymax_range = "null", mykf, kftype_name, startime;
                    myid = id.Text;
                    kftype = txt_kftype.Text;
                    startime = ((DateTime)this.qydate.Value).ToString("yyyy-MM-dd");
                    foreach (string cb in cLB_processcode.CheckedItems)
                    {
                        processcode += cb;
                    }
                    mymin_range = min_range.Value.ToString();
                    if (max_range.Value != null && max_range.Value.ToString()!="")
                        mymax_range = max_range.Value.ToString();
                    mykf = kf.Value.ToString();
                    kftype_name = lab_qztypename.Text;
                    if (myid == "")
                    {
                        sql = "com.steering.rpt.scls.SCLS.insert_SCLS_KF";
                        myid = kftype + startime.Replace("-", "");
                        isnew = true;
                    }
                    else
                        sql = "com.steering.rpt.scls.SCLS.update_SCLS_KF";
                    myobj = new object[] { myid, kftype, processcode, mymin_range, mymax_range, mykf, kftype_name, startime };
                }
                else if (sign == "fj")
                {
                    myuB_save = uB_savefj;
                    String kftype, fjtype,fjtype_name,processcode = "",   myfj, startime;
                    myid = fj_id.Text;
                    kftype = txt_kftypefj.Text;
                    fjtype = uCb_fjtype.Value.ToString();
                    startime = ((DateTime)this.qydatefj.Value).ToString("yyyy-MM-dd");
                    foreach (string cb in cLB_processcodefj.CheckedItems)
                    {
                        processcode += cb;
                    }
                    myfj = fj_value.Value.ToString();
                    fjtype_name = lab_kdtypenamefj.Text;
                    if (myid == "")
                    {
                        sql = "com.steering.rpt.scls.SCLS.insert_SCLS_KFFJX1";
                        myid = kftype + startime.Replace("-", "");
                        isnew = true;
                    }
                    else
                        sql = "com.steering.rpt.scls.SCLS.update_SCLS_KFFJX1";
                    myobj = new object[] { myid, kftype, fjtype, fjtype_name, processcode, myfj, startime };
                }
                else if (sign == "fgz")
                {
                    myuB_save = uB_savefgz;
                    String kftype, mynoworktime_desc, processcode,mypline_code,mypline_name,mynowork_days,mynowork_times, startime;
                    myid = fgz_id.Text;
                    kftype = txt_kftypefgz.Text;
                    processcode = uCb_processcode.Value.ToString();
                    mypline_code = uCb_pline.Value.ToString();
                    mypline_name = uCb_pline.Text;
                    startime = ((DateTime)this.qydatefgz.Value).ToString("yyyy-MM-dd");
                    if (uCb_nowork_days.Value == null || uCb_nowork_days.Value.ToString() == "")
                        mynowork_days = "null";
                    else
                        mynowork_days = uCb_nowork_days.Value.ToString();
                    if (uCb_nowork_times.Value == null || uCb_nowork_times.Value.ToString() == "")
                        mynowork_times = "null";
                    else
                        mynowork_times = uCb_nowork_times.Value.ToString();
                    mynoworktime_desc = txt_noworktime_desc.Text;
                    if (myid == "")
                    {
                        sql = "com.steering.rpt.scls.SCLS.insert_SCLS_KFFJX2";
                        myid = kftype + startime.Replace("-", "");
                        isnew = true;
                    }
                    else
                        sql = "com.steering.rpt.scls.SCLS.update_SCLS_KFFJX2";
                    myobj = new object[] { myid, kftype, mynoworktime_desc, processcode,mypline_code,mypline_name,mynowork_days,mynowork_times, startime };
                }
                else if (sign == "qz")
                {
                    myuB_save = uB_saveqz;
                    String myqztype, myqz,myqztype_name, startime;
                    myid = qz_id.Text;
                    myqztype = uCb_kfqztype.Value.ToString();
                    startime = ((DateTime)this.qydateqz.Value).ToString("yyyy-MM-dd");
 
                    myqz = qz.Value.ToString();
                    myqztype_name = lab_qztypename.Text;
                    if (myid == "")
                    {
                        sql = "com.steering.rpt.scls.SCLS.insert_KFQZ";
                        myid = myqztype + startime.Replace("-", "");
                        isnew = true;
                    }
                    else
                        sql = "com.steering.rpt.scls.SCLS.update_KFQZ";
                    myobj = new object[] { myid, myqztype, myqz,myqztype_name, startime };
                }
                DataTable dt = ServerHelper.GetData(sql, myobj, this.ob);
                if (dt != null && dt.Rows.Count == 1)
                {
                    MessageBox.Show("该记录" + myuB_save.Text + "提交成功！", "提示");
                    setgridselected(sign, dt, myid,isnew);
                }
                else
                    MessageBox.Show("该记录" + myuB_save.Text + "提交失败！", "提示");
            }

            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
        }
        private void setgridselected(string sign, DataTable dt, string id, bool isnew)
        {
            Infragistics.Win.UltraWinGrid.UltraGrid myulgrid = new Infragistics.Win.UltraWinGrid.UltraGrid();
            Infragistics.Win.UltraWinGrid.UltraGridRow myrow;
            if (sign == "kf")
                myulgrid = ultraGridkf;
            else if (sign == "fj")
                myulgrid = ultraGridkffj;
            else if (sign == "fgz")
                myulgrid = ultraGridkffgz;
            else if (sign == "qz")
                myulgrid = ultraGridkfqz;
            if (isnew)
                myrow = myulgrid.Rows.Band.AddNew();
            else
                myrow = myulgrid.Selected.Rows[0];
            foreach (Infragistics.Win.UltraWinGrid.UltraGridCell mycell in myrow.Cells)
            {
                mycell.Value = dt.Rows[0][mycell.Column.Key];
            }

        }

        private void saveisvalid(string sign)
        {
            try
            {
                string sql = "";
                Infragistics.Win.UltraWinGrid.UltraGrid myulgrid = new Infragistics.Win.UltraWinGrid.UltraGrid();
                UltraButton myuB_isvalid = new UltraButton();
                Label myl_isvalid = new Label();
                String myid = "", kftype = "", newisvalid = "", oldisvalid = "";
                object[] myobj=new object[]{};
                if (sign == "kf")
                {
                    myulgrid = ultraGridkf;
                    myuB_isvalid = uB_isvalid;
                    myl_isvalid = isvalid;
                    myid = id.Text;
                    kftype = txt_kftype.Text;
                    oldisvalid = myl_isvalid.Text;
                    if (oldisvalid == "0")
                        newisvalid = "1";
                    else
                        newisvalid = "0";
                    sql = "com.steering.rpt.scls.SCLS.isvalid_KF";
                    myobj = new object[] { myid, kftype, newisvalid, oldisvalid };
                }
                else if (sign == "fj")
                {
                    String fjtype ;
                    myulgrid = ultraGridkffj;
                    myuB_isvalid = uB_isvalidfj;
                    myl_isvalid = isvalidfj;
                    myid = fj_id.Text;
                    kftype = txt_kftypefj.Text;
                    fjtype = uCb_fjtype.Value.ToString();
                    oldisvalid = myl_isvalid.Text;
                    if (oldisvalid == "0")
                        newisvalid = "1";
                    else
                        newisvalid = "0";
                    sql = "com.steering.rpt.scls.SCLS.isvalid_KFFJX1";
                    myobj = new object[] { myid, kftype,fjtype, newisvalid, oldisvalid };
                }
                else if (sign == "fgz")
                {
                    String mypline;
                    myulgrid = ultraGridkffgz;
                    myuB_isvalid = uB_isvalidfgz;
                    myl_isvalid = isvalidfgz;
                    myid = fgz_id.Text;
                    kftype = txt_kftypefgz.Text;
                    mypline = uCb_pline.Value.ToString();                        ;
                    oldisvalid = myl_isvalid.Text;
                    if (oldisvalid == "0")
                        newisvalid = "1";
                    else
                        newisvalid = "0";
                    sql = "com.steering.rpt.scls.SCLS.isvalid_KFFJX2";
                    myobj = new object[] { myid, kftype, mypline, newisvalid, oldisvalid };
                }
                else if (sign == "qz")
                {
                    String mykfqztype;
                    myulgrid = ultraGridkffgz;
                    myuB_isvalid = uB_isvalidfgz;
                    myl_isvalid = isvalidfgz;
                    myid = fgz_id.Text;
                    mykfqztype = uCb_kfqztype.Value.ToString(); ;
                    oldisvalid = myl_isvalid.Text;
                    if (oldisvalid == "0")
                        newisvalid = "1";
                    else
                        newisvalid = "0";
                    sql = "com.steering.rpt.scls.SCLS.isvalid_KFQZ";
                    myobj = new object[] { myid, mykfqztype, newisvalid, oldisvalid };
                }
                DataTable dt = ServerHelper.GetData(sql,myobj , this.ob);
                if (dt != null && dt.Rows.Count == 1)
                {
                    MessageBox.Show("该记录" + uB_isvalid.Text + "提交成功！", "提示");
                    myulgrid.Rows[myulgrid.Selected.Rows[0].Index].Cells["isvalid"].Value = newisvalid;
                    myl_isvalid.Text = newisvalid;
                }
                else
                    MessageBox.Show("该记录" + uB_isvalid.Text + "提交失败！", "提示");
            }

            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
        }
 

        private void uB_isvalid_Click(object sender, EventArgs e)
        {
            if (getifConfirm((UltraButton)sender)) 
            {
                saveisvalid("kf");
            }
        }

        private void uB_isvalidqz_Click(object sender, EventArgs e)
        {
            if (getifConfirm((UltraButton)sender))
            {
                saveisvalid("qz");
            }
        }

        private void uB_isvalidfj_Click(object sender, EventArgs e)
        {
            if (getifConfirm((UltraButton)sender))
            {
                saveisvalid("fj");
            }
        }

        private void uB_isvalidfgz_Click(object sender, EventArgs e)
        {
            if (getifConfirm((UltraButton)sender))
            {
                saveisvalid("fgz");
            }
        }


        private void delete(string sign)
        {
            try
            {
                string sql = "";
                Infragistics.Win.UltraWinGrid.UltraGrid myulgrid = new Infragistics.Win.UltraWinGrid.UltraGrid();
                String myid = "";
                object[] myobj = new object[] { };
                if (sign == "kf")
                {
                    myulgrid = ultraGridkf;
                    myid = id.Text;

                    sql = "com.steering.rpt.scls.SCLS.delete_KF";
                    myobj = new object[] { myid };
                }
                else if (sign == "fj")
                {
                    myulgrid = ultraGridkffj;
                    myid = fj_id.Text;
 
                    sql = "com.steering.rpt.scls.SCLS.delete_KFFJX1";
                    myobj = new object[] { myid };
                }
                else if (sign == "fgz")
                {
                    myulgrid = ultraGridkffgz;
                    myid = fgz_id.Text;
                    sql = "com.steering.rpt.scls.SCLS.delete_KFFJX2";
                    myobj = new object[] { myid };
                }
                else if (sign == "qz")
                {
                    myulgrid = ultraGridkffgz;
                    myid = fgz_id.Text;
                    sql = "com.steering.rpt.scls.SCLS.isvalid_KFQZ";
                    myobj = new object[] { myid  };
                }
                DataTable dt = ServerHelper.GetData(sql, myobj, this.ob);
                if (dt != null && dt.Rows.Count == 0)
                {
                    MessageBox.Show("删除该记录提交成功！", "提示");
                    myulgrid.Rows[myulgrid.Selected.Rows[0].Index].Delete(true);
                    if (myulgrid.Rows.Count > 0)
                        myulgrid.Rows[0].Selected = true;
                    else
                        clearedit(sign);
                }
                else
                    MessageBox.Show("删除该记录提交成功提交失败！", "提示");
            }

            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
        }

        private void uB_delete_Click(object sender, EventArgs e)
        {
            if (isvalid.Text == "1")
                this.alert("不能删除有效数据，若要删除请先停用！");
            else if (id.Text == "")
                this.alert("没有可删除的有效数据！");
            else if (getifConfirm((UltraButton)sender))
            {
                delete("kf");
            }
        }

        private void uB_deleteqz_Click(object sender, EventArgs e)
        {
            if (isvalidqz.Text == "1")
                this.alert("不能删除有效数据，若要删除请先停用！");
            else if (qz_id.Text == "")
                this.alert("没有可删除的有效数据！");
            else if (getifConfirm((UltraButton)sender))
            {
                delete("qz");
            }
        }

        private void uB_deletefj_Click(object sender, EventArgs e)
        {
            if (isvalidfj.Text == "1")
                this.alert("不能删除有效数据，若要删除请先停用！");
            else if (fj_id.Text == "")
                this.alert("没有可删除的有效数据！");
            else if (getifConfirm((UltraButton)sender))
            {
                delete("fj");
            }
        }

        private void uB_deletefgz_Click(object sender, EventArgs e)
        {
            if (isvalidfgz.Text == "1")
                this.alert("不能删除有效数据，若要删除请先停用！");
            else if (fgz_id.Text == "")
                this.alert("没有可删除的有效数据！");
            else if (getifConfirm((UltraButton)sender))
            {
                delete("fgz");
            }
        }

        private void uB_ImportData_Click(object sender, EventArgs e)
        {
            if (uCb_kftype.SelectedIndex == -1)
                this.alert("请先选择流速扣分类型");
            else 
            {
                string sql = "", sign = "";
                object[] myobj = new object[] { };
                if (uCb_kftype.Value.ToString().Contains("ls_dc"))
                {
                    sql = "com.steering.rpt.scls.SCLS.ImportDC";
                    sign = "待产";
                }
                else if (uCb_kftype.Value.ToString().Contains("ls_qx"))
                {
                    sql = "com.steering.rpt.scls.SCLS.ImportQX";
                    sign = "清线";
                }
                else if (uCb_kftype.Value.ToString().Contains("ls_lxwt"))
                {
                    sql = "com.steering.rpt.scls.SCLS.ImportLXWT";
                    sign = "离线待委托";
                }
                else if (uCb_kftype.Value.ToString().Contains("ls_lxfx"))
                {
                    sql = "com.steering.rpt.scls.SCLS.ImportLXFX";
                    sign = "离线待返线";
                }
                else if (uCb_kftype.Value.ToString().Contains("ls_dpsp"))
                {
                    sql = "com.steering.rpt.scls.SCLS.ImportDPDSP";
                    sign = "下线待送判";
                }
                else if (uCb_kftype.Value.ToString().Contains("ls_dppd"))
                {
                    sql = "com.steering.rpt.scls.SCLS.ImportDPDPD";
                    sign = "下线待判定";
                }
                else if (uCb_kftype.Value.ToString().Contains("ls_fp"))
                {
                    sql = "com.steering.rpt.scls.SCLS.ImportFP";
                    sign = "废品待处理";
                }
                if (getifConfirm((UltraButton)sender, "重新导入今天",sign))
                {
                    WaitingForm2 wf = new WaitingForm2("请耐心等待，正在处理数据....");
                    try
                    {
                        DataTable dt = ServerHelper.GetData(sql, myobj, this.ob);
                        wf.Close();
                        if (dt != null && dt.Rows.Count == 1)
                            MessageBox.Show("重新导入今天" + sign + "数据成功！", "提示");
                        else
                            MessageBox.Show("重新导入今天" + sign + "数据失败！", "提示");
                    }
                    catch (Exception ex)
                    {
                        wf.Close();
                        MessageBox.Show(ex.Message);
                    }
                    finally
                    {
                    }
                }
            }
        }

        private void ultraGridkf_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
        {
            ultraGridkf.Rows[e.Cell.Row.Index].Selected = true;
        }

        private void ultraGridkffj_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
        {
            ultraGridkffj.Rows[e.Cell.Row.Index].Selected = true;
        }

        private void ultraGridkffgz_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
        {
            ultraGridkffgz.Rows[e.Cell.Row.Index].Selected = true;
        }

        private void ultraGridkfqz_ClickCell(object sender, Infragistics.Win.UltraWinGrid.ClickCellEventArgs e)
        {
            ultraGridkfqz.Rows[e.Cell.Row.Index].Selected = true;
        }


       



















    }
}