Ejemplo n.º 1
0
        private void LoadSnRange()
        {
            if (mFrm is Frm_SnRange)
            {
                FrmBLL.cdbAccess ass = new FrmBLL.cdbAccess();
                DataTable        dt  = ass.GetDatatable(string.Format("select woId,sntype,snstart,snend,snprefix,snpostfix,ver,reve,snleng,usenum from wosnrule where woId='{0}' and sntype='{1}'", this.mwoId, this.mKey));

                if (dt.Rows.Count > 0)
                {
                    dgvserialnumberrule.DataSource = dt;
                }
                else
                {
                    this.dgvserialnumberrule["woId", 0].Value      = this.mwoId;
                    this.dgvserialnumberrule["sntype", 0].Value    = this.mKey;
                    this.dgvserialnumberrule["snstart", 0].Value   = "";
                    this.dgvserialnumberrule["snend", 0].Value     = "";
                    this.dgvserialnumberrule["snprefix", 0].Value  = "NA";
                    this.dgvserialnumberrule["snpostfix", 0].Value = "NA";
                    this.dgvserialnumberrule["ver", 0].Value       = "A";
                    this.dgvserialnumberrule["reve", 0].Value      = "NA";
                    this.dgvserialnumberrule["snleng", 0].Value    = "0";
                    this.dgvserialnumberrule["usenum", 0].Value    = "1";
                }
            }
        }
Ejemplo n.º 2
0
        private DataTable GetLineList()
        {
            FrmBLL.cdbAccess ass  = new FrmBLL.cdbAccess();
            string           sSQL = "select * from tLineInfo";

            return(ass.GetDatatable(sSQL));
        }
Ejemplo n.º 3
0
        private DataTable GetCraftList()
        {
            FrmBLL.cdbAccess ass  = new FrmBLL.cdbAccess();
            string           sSQL = "select craftId,craftname,craftparameterurl,beworkseg from tCraftInfo";

            return(ass.GetDatatable(sSQL));
        }
Ejemplo n.º 4
0
        private DataTable GetPartNumber()
        {
            FrmBLL.cdbAccess ass  = new FrmBLL.cdbAccess();
            string           sSQL = "select partnumber,sortname,productname,productcolor,productdesc,other from tProduct";

            return(ass.GetDatatable(sSQL));
        }
Ejemplo n.º 5
0
        private DataTable GetWoIdList()
        {
            FrmBLL.cdbAccess ass  = new FrmBLL.cdbAccess();
            string           sSQL = "select woId from tWorkOrderInfo";

            return(ass.GetDatatable(sSQL));
        }
Ejemplo n.º 6
0
 private void LoadSerialnumberRule()
 {
     this.mFrm.ShowPrgMsg("序列号区间加载中,请稍等..", MainParent.MsgType.Warning);
     this.dgvserialnumberrule.Invoke(new EventHandler(delegate
     {
         FrmBLL.cdbAccess ass = new FrmBLL.cdbAccess();
         DataTable _dt        = FrmBLL.ReleaseData.arrByteToDataTable(RefWebService_BLL.refWebtWoInfo.Instance.GetWoSnRule(this.mwoid, this.mKey));
         if (_dt != null && _dt.Rows.Count > 0)
         {
             this.dgvserialnumberrule.DataSource = _dt;
         }
         else if ((_dt = ass.GetDatatable(string.Format("select woId,sntype,snstart,snend,snprefix,snpostfix,ver,reve,snleng,usenum from wosnrule where woId='{0}' and sntype='{1}'", this.mwoid, this.mKey))) != null && _dt.Rows.Count > 0)
         {
             this.dgvserialnumberrule.DataSource = _dt;
         }
         else
         {
             this.dgvserialnumberrule["woId", 0].Value      = this.mwoid;
             this.dgvserialnumberrule["sntype", 0].Value    = this.mKey;
             this.dgvserialnumberrule["snstart", 0].Value   = "";
             this.dgvserialnumberrule["snend", 0].Value     = "";
             this.dgvserialnumberrule["snprefix", 0].Value  = "NA";
             this.dgvserialnumberrule["snpostfix", 0].Value = "NA";
             this.dgvserialnumberrule["ver", 0].Value       = "A";
             this.dgvserialnumberrule["reve", 0].Value      = "NA";
             this.dgvserialnumberrule["snleng", 0].Value    = "0";
             this.dgvserialnumberrule["usenum", 0].Value    = "1";
         }
     }));
     this.mFrm.ShowPrgMsg("序列号区间加载完成", MainParent.MsgType.Outgoing);
 }
Ejemplo n.º 7
0
        private void DownLoad_DB_SnRange(string m_woId)
        {
            DataTable _mdt = FrmBLL.ReleaseData.arrByteToDataTable(RefWebService_BLL.refWebtWoInfo.Instance.GetWoSnRule(m_woId, null));

            if (_mdt.Rows.Count > 0)
            {
                FrmBLL.cdbAccess ass = new FrmBLL.cdbAccess();

                ass.ExecuteOracleCommand(string.Format("delete from wosnrule where woId='{0}'", m_woId));
                foreach (DataRow dr in _mdt.Rows)
                {
                    string sql = string.Format("insert into wosnrule(woId,sntype,snstart,snend,snprefix,snpostfix,ver,reve,snleng,usenum) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')",
                                               dr["WOID"].ToString(),      // this.dgvserialnumberrule["woid", i].Value.ToString(),
                                               dr["SNTYPE"].ToString(),    //this.dgvserialnumberrule["sntype", i].Value.ToString(),
                                               dr["SNSTART"].ToString(),   //this.dgvserialnumberrule["snstart", i].Value.ToString(),
                                               dr["SNEND"].ToString(),     // this.dgvserialnumberrule["snend", i].Value.ToString(),
                                               dr["SNPREFIX"].ToString(),  // this.dgvserialnumberrule["snprefix", i].Value.ToString(),
                                               dr["SNPOSTFIX"].ToString(), // this.dgvserialnumberrule["snpostfix", i].Value.ToString(),
                                               dr["VER"].ToString(),       // this.dgvserialnumberrule["ver", i].Value.ToString(),
                                               dr["REVE"].ToString(),      // this.dgvserialnumberrule["reve", i].Value.ToString(),
                                               dr["SNLENG"].ToString(),    // this.dgvserialnumberrule["snleng", i].Value.ToString(),
                                               dr["USENUM"].ToString());   // this.dgvserialnumberrule["usenum", i].Value.ToString());
                    if (!ass.ExecuteOracleCommand(sql))
                    {
                        ass.ExecuteOracleCommand(string.Format("delete from wosnrule where woId='{1}'", dr["WOID"].ToString()));
                        (mFrm as Frm_MO_Manage).SendMsg(Frm_MO_Manage.mLogMsgType.Error, string.Format("加载条码区间[{0}]失败,请联系SFIS人员", dr["SNTYPE"].ToString()));
                        ip_labletypes.Enabled = false;
                        return;
                    }
                }
            }
            dgv_snRange.DataSource = _mdt;
        }
Ejemplo n.º 8
0
        private void RunData(DataTable mdt)
        {
            FrmBLL.cdbAccess ass = new FrmBLL.cdbAccess();
            ass.ExecuteOracleCommand("delete from bomdata");
            int i = 0;

            this.ShowMsg(LogMsgType.Warning, "正在加载BOM数据");
            foreach (DataRow dr in mdt.Rows)
            {
                i++;
                string sql = string.Format("insert into bomdata(kpnumber,kpdesc,loction,kpgroup,bomver,kptype,qty) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')",
                                           dr[0].ToString(), dr[1].ToString(), dr[6].ToString(), dr[2].ToString(), dr[3].ToString(), dr[4].ToString(), dr[5].ToString());
                ass.ExecuteOracleCommand(sql);
                this.Showpb(i);
            }
            string str = string.Empty;

            if (this.gelidip)
            {
                str = " where kptype<>'DIP'";
            }
            this.ShowData(this.BomDataTable = ass.GetDatatable(string.Format("select kpnumber,kpdesc,kpgroup,bomver,qty,loction from bomdata {0}", str)));
            this.ShowMsg(LogMsgType.Outgoing, "BOM数据加载完成");
        }
Ejemplo n.º 9
0
        private void bt_save_Click(object sender, EventArgs e)
        {
            if (this.dgvserialnumberrule.Rows.Count < 2)
            {
                MessageBoxEx.Show("没有设置序列号区间", "提示");
                return;
            }
            try
            {
                string           strTemp  = string.Empty;
                string           strTemp1 = string.Empty;
                FrmBLL.cdbAccess ass      = new FrmBLL.cdbAccess();
                ass.ExecuteOracleCommand(string.Format("delete from wosnrule where woId='{1}' and  sntype='{0}'", this.mKey, this.mwoId));
                for (int i = 0; i < this.dgvserialnumberrule.Rows.Count - 1; i++)
                {
                    object _snstart = this.dgvserialnumberrule["snstart", i].Value;
                    object _snend   = this.dgvserialnumberrule["snend", i].Value;

                    //判断开始序列号是否大于结束序列号
                    if (_snstart == null || _snstart.ToString().Length < 3 || _snend == null || _snend.ToString().Length < 3)
                    {
                        // ass.ExecuteOracleCommand(string.Format("delete from wosnrule where woId='{1}' and  sntype='{0}'", this.mKey, this.mwoid));
                        this.dgvserialnumberrule.Rows[i].DefaultCellStyle.BackColor = Color.FromArgb(250, 250, 160);
                        MessageBoxEx.Show("序列号区间存在空值,或长度小于3!!请修正..", "提示");
                        return;
                    }
                    //判断长度是否一致
                    if (_snstart.ToString().Length != _snend.ToString().Length)
                    {
                        // ass.ExecuteOracleCommand(string.Format("delete from wosnrule where woId='{1}' and  sntype='{0}'", this.mKey, this.mwoid));
                        this.dgvserialnumberrule.Rows[i].DefaultCellStyle.BackColor = Color.FromArgb(250, 250, 160);
                        MessageBoxEx.Show("起始序列号与结束序列号长度不一致,请修正..");
                        return;
                    }

                    if (string.CompareOrdinal(_snstart.ToString(), _snend.ToString()) > 0)
                    {
                        // ass.ExecuteOracleCommand(string.Format("delete from wosnrule where woId='{1}' and  sntype='{0}'", this.mKey, this.mwoid));
                        this.dgvserialnumberrule.Rows[i].DefaultCellStyle.BackColor = Color.FromArgb(250, 250, 160);
                        MessageBoxEx.Show("序列号起始值大于结束值!!,请修正..");
                        return;
                    }

                    DataTable dtt   = ass.GetDatatable(string.Format("select * from wosnrule where '{0}' between snstart and snend", this.dgvserialnumberrule["snstart", i].Value.ToString()));
                    bool      bflag = true;
                    if (dtt != null && dtt.Rows.Count > 0)
                    {
                        if (dtt.Rows[0]["woId"].ToString().ToUpper() != this.mwoId.ToUpper())
                        {
                            bflag = false;
                        }
                    }
                    if (bflag)
                    {
                        dtt = ass.GetDatatable(string.Format("select * from wosnrule where '{0}' between snstart and snend", this.dgvserialnumberrule["snend", i].Value.ToString()));
                        if (dtt != null && dtt.Rows.Count > 0)
                        {
                            if (dtt.Rows[0]["woId"].ToString().ToUpper() != this.mwoId.ToUpper())
                            {
                                bflag = false;
                            }
                        }
                    }
                    if (!bflag)
                    {
                        this.dgvserialnumberrule.Rows[i].DefaultCellStyle.BackColor = Color.FromArgb(250, 250, 160);
                        // ass.ExecuteOracleCommand(string.Format("delete from wosnrule where woId='{1}' and  sntype='{0}'", this.mKey, this.mwoid));
                        MessageBox.Show("序列号区间已经存在于工单" + dtt.Rows[0]["woId"].ToString() + "中,请重新设置..", "提示");
                        return;
                    }
                    //需要剔除重工工单
                    if ((mFrm as Frm_SnRange)._woType != "Rework" && (mFrm as Frm_SnRange)._woType != "RMA")
                    {//如果是重工工单或者是RAM工单
                     //DataTable _dta = new DataTable();

                        string err = RefWebService_BLL.refWebtWoInfo.Instance.ChkSerialNumberRule_New(this.mwoId, _snstart.ToString(), _snend.ToString());
                        if (err.ToUpper() != "OK")
                        {
                            this.dgvserialnumberrule.Rows[i].DefaultCellStyle.BackColor = Color.FromArgb(250, 250, 160);
                            //  ass.ExecuteOracleCommand(string.Format("delete from wosnrule where woId='{1}' and  sntype='{0}'", this.mKey, this.mwoid));
                            MessageBox.Show(err, "提示");
                            return;
                        }
                        #region xxx
                        //bool _flag = true;
                        //_dta = FrmBLL.ReleaseData.arrByteToDataTable(RefWebService_BLL.refWebtWoInfo.Instance.ChkSerialNumberRule(_snstart.ToString()));
                        //if (_dta != null && _dta.Rows.Count > 0)
                        //{//在数据库中找到了数据
                        //    if (_dta.Rows[0]["woId"].ToString().ToUpper() != this.mwoid.ToUpper()) //但是返回的数据不是同一个工单
                        //        _flag = false;
                        //}
                        //if (_flag)
                        //{
                        //    _dta = FrmBLL.ReleaseData.arrByteToDataTable(RefWebService_BLL.refWebtWoInfo.Instance.ChkSerialNumberRule(_snend.ToString()));
                        //    if (_dta != null && _dta.Rows.Count > 0)
                        //    {
                        //        if (_dta.Rows[0]["woId"].ToString().ToUpper() != this.mwoid.ToUpper())
                        //            _flag = false;
                        //    }
                        //}
                        //if (!_flag)
                        //{
                        //    this.dgvserialnumberrule.Rows[i].DefaultCellStyle.BackColor = Color.FromArgb(250, 250, 160);
                        //    ass.ExecuteOracleCommand(string.Format("delete from wosnrule where woId='{1}' and  sntype='{0}'", this.mKey, this.mwoid));
                        //    MessageBox.Show("序列号区间已经存在于工单" + _dta.Rows[0]["woId"].ToString() + "中,请重新设置..", "提示");
                        //    return;
                        //}
                        #endregion
                    }

                    string sql = string.Format("insert into wosnrule(woId,sntype,snstart,snend,snprefix,snpostfix,ver,reve,snleng,usenum) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')",
                                               this.dgvserialnumberrule["woid", i].Value.ToString(),
                                               this.dgvserialnumberrule["sntype", i].Value.ToString(),
                                               this.dgvserialnumberrule["snstart", i].Value.ToString(),
                                               this.dgvserialnumberrule["snend", i].Value.ToString(),
                                               this.dgvserialnumberrule["snprefix", i].Value.ToString(),
                                               this.dgvserialnumberrule["snpostfix", i].Value.ToString(),
                                               this.dgvserialnumberrule["ver", i].Value.ToString(),
                                               this.dgvserialnumberrule["reve", i].Value.ToString(),
                                               this.dgvserialnumberrule["snleng", i].Value.ToString(),
                                               this.dgvserialnumberrule["usenum", i].Value.ToString());
                    if (!ass.ExecuteOracleCommand(sql))
                    {
                        ass.ExecuteOracleCommand(string.Format("delete from wosnrule where woId='{1}' and  sntype='{0}'", this.mKey, this.mwoId));
                        MessageBox.Show("数据记录失败!!", "错误");
                        return;
                    }
                    this.dgvserialnumberrule.Rows[i].DefaultCellStyle.BackColor = Color.Green;
                }
                this.DialogResult = DialogResult.OK;
            }
            catch (Exception ex)
            {
                MessageBoxEx.Show(ex.Message);
            }
        }
Ejemplo n.º 10
0
        private void SaveExcelSmtSoftKpList(string[] sFileName)
        {
            this.ShowMsg(LogMsgType.Warning, "开始读取Excel.");
            DataTable dtTemp = new DataTable();

            dtTemp.Columns.Add("IID", System.Type.GetType("System.String"));
            dtTemp.Columns.Add("smtsoftname", System.Type.GetType("System.String"));
            dtTemp.Columns.Add("pcbside", System.Type.GetType("System.String"));
            dtTemp.Columns.Add("LineId", System.Type.GetType("System.String"));
            dtTemp.Columns.Add("stationId", System.Type.GetType("System.String"));
            dtTemp.Columns.Add("kpnumber", System.Type.GetType("System.String"));
            dtTemp.Columns.Add("feeder", System.Type.GetType("System.String"));
            dtTemp.Columns.Add("loction", System.Type.GetType("System.String"));

            foreach (string item in sFileName)
            {
                DataTable          dt1 = new DataTable();
                FrmBLL.ClsAllExcel cls = new FrmBLL.ClsAllExcel();
                cls.OpenFileName = item;
                cls.OpenExcelFile();
                dt1 = cls.getAllCellsValue();
                cls.CloseExcelFile();
                foreach (DataRow dr in dt1.Rows)
                {
                    dtTemp.ImportRow(dr);
                }
            }
            this.ShowMsg(LogMsgType.Incoming, "读取Execel完成.");
            this.ShowMsg(LogMsgType.Warning, "开始处理料站表...");
            SmtSoftKpList = dtTemp;


            this.SetPb2MaxValue(SmtSoftKpList.Rows.Count);
            int i = 0;

            FrmBLL.cdbAccess ass = new FrmBLL.cdbAccess();
            ass.ExecuteOracleCommand("delete from smtsoftkplist");
            foreach (DataRow dr in SmtSoftKpList.Rows)
            {
                string sql = string.Format("insert into smtsoftkplist(smtsoftname,pcbside,lineId,stationId,kpnumber,feeder,stationcount,loction) values('{0}','{1}','{2}','{3}','{4}','{5}','0','{6}')",
                                           dr["smtsoftname"].ToString(),
                                           dr["pcbside"].ToString(),
                                           dr["lineId"].ToString(),
                                           dr["stationId"].ToString(),
                                           dr["kpnumber"].ToString(),
                                           dr["feeder"].ToString(),
                                           dr["loction"].ToString());
                ass.ExecuteOracleCommand(sql);
                this.Showpb1(i++);
            }
            string    cmd = "select lineId,count(stationId) as total from smtsoftkplist group by lineId";
            DataTable dt  = ass.GetDatatable(cmd);

            foreach (DataRow dr in dt.Rows)
            {
                cmd = string.Format("update smtsoftkplist set stationcount='{0}' where lineId='{1}'", dr["total"].ToString(),
                                    dr["lineId"].ToString());
                ass.ExecuteOracleCommand(cmd);
            }
            SmtSoftKpList = ass.GetDatatable("select * from smtsoftkplist");
            this.ShowMsg(LogMsgType.Incoming, "Excel料站表处理完成.");
            this.ShowData2(SmtSoftKpList);
        }
Ejemplo n.º 11
0
 private void SaveSmtSoftKpList(string[] filenames, string machine)
 {
     try
     {
         this.ShowMsg(LogMsgType.Outgoing, "正在处理SMT料站表......");
         this.SmtSoftKpList = new DataTable();
         string Err       = "";
         string extension = "";
         foreach (string item in filenames)
         {
             extension = System.IO.Path.GetExtension(item).ToUpper();//扩展名 “.aspx”
         }
         if (extension.Contains("TXT"))
         {
             SmtSoftKpList = FrmBLL.publicfuntion.LoadTxt(filenames, machine, out Err);
         }
         if (extension.Contains("CSV"))
         {
             SmtSoftKpList = FrmBLL.publicfuntion.LoadCSV(filenames, machine, out Err);
         }
         if (!string.IsNullOrEmpty(Err))
         {
             if (Err.IndexOf("警告!!") != -1)
             {
                 this.ShowMsg(LogMsgType.Error, Err);
             }
             else
             {
                 this.ShowMsg(LogMsgType.Error, Err);
                 return;
             }
         }
         this.SetPb2MaxValue(SmtSoftKpList.Rows.Count);
         int i = 0;
         FrmBLL.cdbAccess ass = new FrmBLL.cdbAccess();
         ass.ExecuteOracleCommand("delete from smtsoftkplist");
         foreach (DataRow dr in SmtSoftKpList.Rows)
         {
             string sql = string.Format("insert into smtsoftkplist(smtsoftname,pcbside,lineId,stationId,kpnumber,feeder,stationcount,loction) values('{0}','{1}','{2}','{3}','{4}','{5}','0','{6}')",
                                        dr["smtsoftname"].ToString(),
                                        dr["pcbside"].ToString(),
                                        dr["lineId"].ToString(),
                                        dr["stationId"].ToString(),
                                        dr["kpnumber"].ToString(),
                                        dr["feeder"].ToString(),
                                        dr["loction"].ToString());
             ass.ExecuteOracleCommand(sql);
             this.Showpb1(i++);
         }
         string    cmd = "select lineId,count(stationId) as total from smtsoftkplist group by lineId";
         DataTable dt  = ass.GetDatatable(cmd);
         foreach (DataRow dr in dt.Rows)
         {
             cmd = string.Format("update smtsoftkplist set stationcount='{0}' where lineId='{1}'", dr["total"].ToString(),
                                 dr["lineId"].ToString());
             ass.ExecuteOracleCommand(cmd);
         }
         SmtSoftKpList = ass.GetDatatable("select * from smtsoftkplist");
         this.ShowMsg(LogMsgType.Incoming, "SMT料站表处理完成.");
         this.ShowData2(SmtSoftKpList);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Ejemplo n.º 12
0
        private void FrmRepair_Load(object sender, EventArgs e)
        {
            try
            {
                #region 添加应用程序
                if (this.sMain.gUserInfo.rolecaption == "系统开发员")
                {
                    IList <IDictionary <string, object> > lsfunls = new List <IDictionary <string, object> >();
                    IDictionary <string, object>          funls   = new Dictionary <string, object>();
                    funls = new Dictionary <string, object>();
                    funls.Add("FUNID", "PD_Transfer".ToUpper());
                    funls.Add("PROGID", this.Name);
                    funls.Add("FUNNAME", "生产转账");
                    funls.Add("FUNDESC", "生产转账");
                    lsfunls.Add(funls);

                    Dictionary <string, object> dic = new Dictionary <string, object>();
                    dic.Add("PROGID", this.Name);
                    dic.Add("PROGNAME", this.Text);
                    dic.Add("PROGDESC", this.Text);

                    FrmBLL.publicfuntion.GetFromCtls(this, ref lsfunls);
                    FrmBLL.publicfuntion.AddProgInfo(dic, lsfunls);
                }
                #endregion
            }
            catch (Exception ex)
            {
                this.sMain.ShowPrgMsg(ex.Message, MainParent.MsgType.Error);
            }



            tbrepairuser.Text = sMain.gUserInfo.userId;

            RCList = new GetRCList(GetReasonCode);
            RCList.BeginInvoke(null, null);
            CraftInfo = new GetCraftInfo(GetAllCraftInfo);
            CraftInfo.BeginInvoke(null, null);
            GetDutyData = new GetDuty(GetDutyInfo);
            GetDutyData.BeginInvoke(null, null);

            #region 单元格交替颜色
            this.dgvallrepairinfo.RowsDefaultCellStyle.BackColor            = Color.Bisque;
            this.dgvallrepairinfo.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;

            this.dgvRepairReport.RowsDefaultCellStyle.BackColor            = Color.Bisque;
            this.dgvRepairReport.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;

            this.dgvQrepair.RowsDefaultCellStyle.BackColor            = Color.Bisque;
            this.dgvQrepair.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
            #endregion

            tabSelect.SelectedIndex = 3;


            //for (int i = 0; i < 24; i++)
            //{
            //    combStime.Items.Add(i.ToString().PadLeft(2, '0') + ":30");
            //    combEtime.Items.Add(i.ToString().PadLeft(2, '0') + ":30");
            //}
            CB_Class.Items.Clear();
            CB_Class.Items.Add("ALL");
            CB_Class.Items.Add("D");
            CB_Class.Items.Add("N");
            CB_Class.SelectedIndex = 0;

            GetColnumName();

            FrmBLL.cdbAccess ass = new FrmBLL.cdbAccess();
            ass.ExecuteOracleCommand("delete from tProduct");
        }
Ejemplo n.º 13
0
        private void ip_labletypes_ItemClick(object sender, EventArgs e)
        {
            try
            {
                if (sender is DevComponents.DotNetBar.CheckBoxItem)
                {
                    FrmBLL.cdbAccess ass = new FrmBLL.cdbAccess();
                    //    if (!ChkPwd(((DevComponents.DotNetBar.CheckBoxItem)sender).Name))
                    //    {
                    #region SN修改需要权限
                    if (((DevComponents.DotNetBar.CheckBoxItem)sender).Name.ToUpper() == "SN")
                    {
                        //DataTable dt = _mdt;
                        //if (dt == null || dt.Rows.Count < 1)
                        //{
                        //    (mFrm as Frm_MO_Manage).SendMsg(Frm_MO_Manage.mLogMsgType.Error ,"工单未找到,请确认...");
                        //    return;
                        //}
                        if (Convert.ToInt32(dgv_woinfo.Rows[0].Cells["inputqty"].Value.ToString()) > 0)
                        {
                            string pwd = Input.InputQuery.ShowInputBox("输入密码", string.Empty, '*');
                            if (pwd != "phicomm_mes")
                            {
                                (mFrm as Frm_MO_Manage).SendMsg(Frm_MO_Manage.mLogMsgType.Error, "密码不符,请确认...");
                                return;
                            }
                        }
                    }
                    #endregion
                    if (((DevComponents.DotNetBar.CheckBoxItem)sender).Checked)
                    {//选中
                        this.cbSetEsn.Items.Add(((DevComponents.DotNetBar.CheckBoxItem)sender).Name);

                        if (MessageBoxEx.Show(string.Format("是否需要对[{0}]号设定区间?\n继续 , 请选择[Yes] ,不设定区间 , 请选择[No]",
                                                            ((DevComponents.DotNetBar.CheckBoxItem)sender).Name)
                                              , "区间设定提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes)
                        {
                            Frm_AddSnRange asr = new Frm_AddSnRange(((DevComponents.DotNetBar.CheckBoxItem)sender).Name, dgv_woinfo.Rows[0].Cells["WOID"].Value.ToString(), this);
                            asr.ShowDialog();
                        }
                    }
                    else
                    {//取消选中
                        this.cbSetEsn.Items.Remove(((DevComponents.DotNetBar.CheckBoxItem)sender).Name);
                        if (MessageBoxEx.Show("查看数据请选择 [Yes] ,清除原来的数据请选择 [No]", "提示",
                                              MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes)
                        {
                            ((DevComponents.DotNetBar.CheckBoxItem)sender).Checked = true;
                            this.cbSetEsn.Items.Add(((DevComponents.DotNetBar.CheckBoxItem)sender).Name);
                            // this.ip_labletypes_ItemClick(sender, null);
                            Frm_AddSnRange asr = new Frm_AddSnRange(((DevComponents.DotNetBar.CheckBoxItem)sender).Name, dgv_woinfo.Rows[0].Cells["WOID"].Value.ToString(), this);
                            asr.ShowDialog();
                        }
                        else
                        {
                            ass.ExecuteOracleCommand(string.Format("delete from wosnrule where woId='{0}' and sntype='{1}'",
                                                                   dgv_woinfo.Rows[0].Cells["WOID"].Value.ToString(), ((DevComponents.DotNetBar.CheckBoxItem)sender).Name));
                        }

                        // this.NewLableTypesValues.Remove(((DevComponents.DotNetBar.CheckBoxItem)sender).Name);
                    }
                    //}
                    //else
                    //{
                    //    (mFrm as Frm_MO_Manage).SendMsg(Frm_MO_Manage.mLogMsgType.Warning,string.Format("当前选择的属于密码类型{0}",
                    //        ((DevComponents.DotNetBar.CheckBoxItem)sender).Name));
                    //}
                    //  }

                    dgv_snRange.DataSource = ass.GetDatatable(string.Format("select distinct  woId,sntype,snstart,snend,snprefix,snpostfix,ver,reve,snleng,usenum from wosnrule where woId='{0}' ",
                                                                            dgv_woinfo.Rows[0].Cells["WOID"].Value.ToString()));
                }
            }
            catch (Exception ex)
            {
                (mFrm as Frm_MO_Manage).SendMsg(Frm_MO_Manage.mLogMsgType.Error, ex.Message);
            }
        }