Пример #1
0
        private void raw_del()
        {
            wnDm      wDm = new wnDm();
            DataTable dt  = wDm.select_all_rawCd(txt_raw_mat_cd.Text.ToString());

            if (dt != null && dt.Rows.Count > 0)
            {
                MessageBox.Show("해당 자재의 사용내역이 남아있어서 삭제할 수 없습니다.");
                return;
            }

            ComInfo      comInfo = new ComInfo();
            DialogResult msgOk   = comInfo.deleteConfrim("원자재", txt_raw_mat_nm.Text.ToString());

            if (msgOk == DialogResult.No)
            {
                return;
            }
            int rsNum = wDm.deleteRaw(txt_raw_mat_cd.Text.ToString());

            if (rsNum == 0)
            {
                resetSetting();

                raw_list();
                MessageBox.Show("성공적으로 삭제하였습니다.");
            }
            else if (rsNum == 1)
            {
                MessageBox.Show("삭제에 실패하였습니다.");
            }
        }
Пример #2
0
        private void HACCP_list()
        {
            try
            {
                wnDm      wDm = new wnDm();
                DataTable dt  = null;

                StringBuilder sb = new StringBuilder();
                sb.AppendLine("where 1=1 ");

                if (!txt_srch.Text.ToString().Equals(""))
                {
                    sb.AppendLine("and CHK_NM like '%" + txt_srch.Text.ToString() + "%' ");
                }
                else if (cmb_cd2.SelectedValue != "전체" && cmb_cd2.SelectedValue != "")
                {
                    sb.AppendLine("and FLOW_CD = '" + cmb_cd2.SelectedValue + "' ");
                }

                dt = wDm.haccp_Grid_List(sb.ToString());

                if (dt != null && dt.Rows.Count > 0)
                {
                    this.dataChkGrid.RowCount = dt.Rows.Count;

                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        dataChkGrid.Rows[i].Cells[0].Value = dt.Rows[i]["CHK_ORD"].ToString();
                        ComInfo comInfo  = new ComInfo();
                        string  sqlQuery = "";

                        //cmb.ValueMember = "코드";
                        //cmb.DisplayMember = "명칭";
                        //sqlQuery = comInfo.queryFlow();
                        //wConst.ComboBox_Read_Blank(cmb, sqlQuery);

                        dataChkGrid.Rows[i].Cells[1].Value = dt.Rows[i]["FLOW_NM"].ToString();
                        dataChkGrid.Rows[i].Cells[2].Value = dt.Rows[i]["CHK_CD"].ToString();
                        dataChkGrid.Rows[i].Cells[3].Value = dt.Rows[i]["CHK_NM"].ToString();
                        dataChkGrid.Rows[i].Cells[5].Value = dt.Rows[i]["FLOW_CD"].ToString();
                        if (dt.Rows[i]["USE_YN"].ToString().Equals("Y"))
                        {
                            dataChkGrid.Rows[i].Cells[4].Value = "Y";
                        }
                        else
                        {
                            dataChkGrid.Rows[i].Cells[4].Value = "N";
                        }
                    }
                }
                else
                {
                    dataChkGrid.Rows.Clear();
                }
            }
            catch (Exception e)
            {
                MessageBox.Show("시스템 에러: " + e.Message.ToString());
            }
        }
 private void frm공정코드등록_Load(object sender, EventArgs e)
 {
     ComInfo.gridHeaderSet(dataFlowGrid);
     btnDelete.Enabled = false;
     init_ComboBox();
     flow_list();
 }
Пример #4
0
        private void frm원자재등록_Load(object sender, EventArgs e)
        {
            ComInfo.gridHeaderSet(dataRawCdGrid);

            init_ComboBox();
            raw_list();
        }
        private void init_ComboBox()
        {
            ComInfo comInfo  = new ComInfo();
            string  sqlQuery = "";

            cmb_meatkind.ValueMember   = "코드";
            cmb_meatkind.DisplayMember = "명칭";
            sqlQuery = comInfo.queryMeatKind();
            wConst.ComboBox_Read_Blank(cmb_meatkind, sqlQuery);

            cmb_grade_gubun.ValueMember   = "코드";
            cmb_grade_gubun.DisplayMember = "명칭";
            sqlQuery = comInfo.queryGradeGubun();
            wConst.ComboBox_Read_NoBlank(cmb_grade_gubun, sqlQuery);

            cmb_fgubun.ValueMember   = "코드";
            cmb_fgubun.DisplayMember = "명칭";
            sqlQuery = comInfo.queryFrozenGubun();
            wConst.ComboBox_Read_NoBlank(cmb_fgubun, sqlQuery);

            cmb_corigin.ValueMember   = "코드";
            cmb_corigin.DisplayMember = "명칭";
            sqlQuery = comInfo.queryOriginGubun();
            wConst.ComboBox_Read_NoBlank(cmb_corigin, sqlQuery);
        }
Пример #6
0
        private void init_ComboBox()
        {
            ComInfo comInfo  = new ComInfo();
            string  sqlQuery = "";

            //공정
            cmb_srch_gbn.ValueMember   = "코드";
            cmb_srch_gbn.DisplayMember = "명칭";
            sqlQuery = comInfo.queryItemGbnAll();
            wConst.ComboBox_Read_NoBlank(cmb_srch_gbn, sqlQuery);

            cmb_item_flow.ValueMember   = "코드";
            cmb_item_flow.DisplayMember = "명칭";
            sqlQuery = comInfo.queryFlow();
            wConst.ComboBox_Read_Blank(cmb_item_flow, sqlQuery);

            //cmb_eva_gbn.ValueMember = "코드";
            //cmb_eva_gbn.DisplayMember = "명칭";
            //sqlQuery = comInfo.queryCode("620");
            //wConst.ComboBox_Read_Blank(cmb_eva_gbn, sqlQuery);

            //제품
            cmb_srch_gbn2.ValueMember   = "코드";
            cmb_srch_gbn2.DisplayMember = "명칭";
            sqlQuery = comInfo.queryItemGbnAll();
            wConst.ComboBox_Read_NoBlank(cmb_srch_gbn2, sqlQuery);
        }
Пример #7
0
        private void output_del()
        {
            ComInfo      comInfo = new ComInfo();
            DialogResult msgOk   = comInfo.deleteConfrim("반품등록삭제", txt_return_date.Text.ToString() + " - " + txt_retrun_cd.Text.ToString());

            if (msgOk == DialogResult.No)
            {
                return;
            }



            wnDm wDm   = new wnDm();
            int  rsNum = wDm.반품등록삭제(txt_return_date.Text.ToString(), txt_retrun_cd.Text.ToString());

            if (rsNum == 0)
            {
                resetSetting();

                MessageBox.Show("성공적으로 삭제하였습니다.");
            }
            else if (rsNum == 1)
            {
                MessageBox.Show("삭제에 실패하였습니다.");
            }
        }
Пример #8
0
        private void pop계산서매출검색_Load(object sender, EventArgs e)
        {
            ComInfo.gridHeaderSet(GridRecord);
            start_date.Text  = DateTime.Now.ToString().Substring(0, 8) + "01";
            lbl_cust_nm.Text = sName;

            ComInfo     cominfo  = new ComInfo();
            wnGConstant wConst   = new wnGConstant();
            string      sqlQuery = "";

            cmb_vat_cd.ValueMember   = "코드";
            cmb_vat_cd.DisplayMember = "명칭";
            sqlQuery = cominfo.queryVatAll();
            wConst.ComboBox_Read_NoBlank(cmb_vat_cd, sqlQuery);

            cmb_vat_cd.SelectedValue = sVatCd;
            rsTable.Columns.Add("매출일자");
            rsTable.Columns.Add("번호");
            rsTable.Columns.Add("순번");
            rsTable.Columns.Add("부가세구분");
            rsTable.Columns.Add("상품명");
            rsTable.Columns.Add("규격");
            rsTable.Columns.Add("총수량");
            rsTable.Columns.Add("단가");
            rsTable.Columns.Add("금액");
            rsTable.Columns.Add("상품코드");
            rsTable.Columns.Add("상품구분");

            bindData("where B.CUST_CD = '" + sCode + "' and A.SALES_DATE >= '" + start_date.Text + "' and A.SALES_DATE <= '" + end_date.Text + "'  and A.ESCALATION_YN = 'N' ");
        }
Пример #9
0
        public static bool p_Isdel = true;    // 삭제 권한
        private void frm제품출고원장_Load(object sender, EventArgs e)
        {
            addButton(txtType, 0);
            lbl_title.Tag = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[0] + "$" + wnDm.fn_TitleName(this.Name.ToString()).Split('$')[1]; lbl_title.Text = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[2];
            if (Common.p_strUserAdmin != "5")
            {
                DataTable dtcheck = wnDm.fn_auth_check(lbl_title.Tag.ToString().Split('$')[0], lbl_title.Tag.ToString().Split('$')[1]);
                p_IsAuth  = dtcheck.Rows[0]["auth_yn"].ToString() == "Y" ? true : false;
                p_Isrgstr = dtcheck.Rows[0]["rgstr_yn"].ToString() == "Y" ? true : false;
                p_Isdel   = dtcheck.Rows[0]["del_yn"].ToString() == "Y" ? true : false;
                try
                {
                    if (!p_IsAuth)
                    {
                        this.BeginInvoke(new MethodInvoker(Close));
                        /// MessageBox.Show("권한이없습니다.");
                    }
                }
                catch (Exception ex)
                {
                }
            }
            cboType.SelectedIndex = 0;
            start_date.Text       = DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd");

            GridList();


            ComInfo.gridHeaderSet(itemOutGrid);
        }
Пример #10
0
        private void picLogic()
        {
            OpenFileDialog ofd = new OpenFileDialog();

            ofd.Filter = "Images Files(*.jpg; *.jpeg; *.gif; *.bmp; *.png)|*.jpg;*.jpeg;*.gif;*.bmp;*.png";
            ofd.ShowDialog();


            if (ofd.FileNames.Length > 0)
            {
                foreach (string filename in ofd.FileNames)
                {
                    txtFloorPlanNm.Text = Path.GetFileNameWithoutExtension(filename); //경로빼고 파일명만!
                    image   = Image.FromFile(filename);                               //이미지
                    ImgPath = filename;                                               //파일경로

                    Image floorPlanImg = ComInfo.pic_resize_logic(pictureBox1, image);
                    pictureBox1.BackgroundImage = floorPlanImg;
                }
            }
            else
            {
                pictureBox1.BackgroundImage = null;
            }
        }
Пример #11
0
        // 接口5 获取公司信息
        public string GetCompanyInfo([FromBody] Models.GetCompanyInfo value)
        {
            ComInfo    ci = new ComInfo();
            InfoEntity ie = new InfoEntity();
            DataTable  dt = cii.GetList();

            try
            {
                //string Where = "FirmInfoID=1";
                //string sql = string.Format("select * from FirmInfo where FirmInfoID=1");
                ////DataTable dt = DALHelp.ExecuteDataTable(sql, null);
                //DataTable dt = ServerOrLit.isDataTable(LoginController.connType, sql);
                if (dt.Rows.Count > 0)
                {
                    ci.StateCode   = (int)Common.EnumParam.Code.Sucess;
                    ci.Reason      = "";
                    ci.Info        = ie;
                    ie.LogoUrl     = "http://" + dt.Rows[0]["LogoUrl"].ToString();
                    ie.CompanyName = dt.Rows[0]["CompanyName"].ToString();
                }
                else
                {
                    ci.StateCode = (int)Common.EnumParam.Code.Fail;
                    ci.Reason    = "获取数据失败";
                    ci.Info      = null;
                }
            }
            catch (Exception ex)
            {
                ci.StateCode = 104;
                ci.Reason    = ex.Message;
                ci.Info      = null;
            }
            return(JsonConvert.SerializeObject(ci));
        }
Пример #12
0
        private void init_ComboBox()
        {
            ComInfo comInfo  = new ComInfo();
            string  sqlQuery = "";

            //불량유형 시작
            cmb_poor_type.ValueMember   = "코드";
            cmb_poor_type.DisplayMember = "명칭";
            sqlQuery = comInfo.queryUnitType("1");
            wConst.ComboBox_Read_Blank(cmb_poor_type, sqlQuery);



            //담당자
            cmb_manager.ValueMember   = "코드";
            cmb_manager.DisplayMember = "명칭";
            sqlQuery = comInfo.queryStaff();
            wConst.ComboBox_Read_Blank(cmb_manager, sqlQuery);

            //창고
            cmb_stor.ValueMember   = "코드";
            cmb_stor.DisplayMember = "명칭";
            sqlQuery = comInfo.queryStorage();
            wConst.ComboBox_Read_Blank(cmb_stor, sqlQuery);
        }
Пример #13
0
        public static ComInfo BuildCom(Component com)
        {
            ComInfo data = null;
            var     exp  = CustomExport.allExports.Find(a => a.att.com == com.GetType());

            if (exp != null)
            {
                var build = exp.type.GetMethod("Build");
                var obj   = System.Activator.CreateInstance(exp.type) as IComExprot;
                if (build != null)
                {
                    data = new ComInfo
                    {
                        name = obj.ClasName,
                        data = obj.Build(com)
                    };
                    if (string.IsNullOrEmpty(data.data))
                    {
                        data = null;
                    }
//                    if (obj.doExportToLaya)
//                    {
//                        Object.DestroyImmediate(com);
//                    }
                }
            }

            return(data);
        }
Пример #14
0
        private void frm씨지엠출고지시현황_Load(object sender, EventArgs e)
        {
            //input_list(tdInputGrid, "where convert(varchar(10), Z.INTIME, 120) = convert(varchar(10), getDate(), 120) ");
            //input_list(inputGrid, "where Z.INPUT_DATE >= '" + start_date.Text.ToString() + "' and  Z.INPUT_DATE <= '" + end_date.Text.ToString() + "'");
            ComInfo.gridHeaderSet(inputGrid);
            ComInfo.gridHeaderSet(ProductGrid);
            ComInfo.gridHeaderSet(InputTempGrid);

            DataGridViewCellStyle cellStyle = new DataGridViewCellStyle();

            cellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            cellStyle.BackColor = Color.FromArgb(210, 219, 254);
            DataGridViewCellStyle cellStyle2 = new DataGridViewCellStyle();

            cellStyle2.Alignment = DataGridViewContentAlignment.MiddleCenter;
            cellStyle2.BackColor = Color.FromArgb(227, 210, 254);

            btnSave.Enabled = false;

            for (int i = 0; i < 8; i++)
            {
                ProductGrid.Columns[i].HeaderCell.Style = cellStyle;
            }
            for (int i = 8; i < 10; i++)
            {
                ProductGrid.Columns[i].HeaderCell.Style = cellStyle2;
            }
            lbl_usual.BackColor = Color.FromArgb(97, 143, 253);
            lbl_plan.BackColor  = Color.FromArgb(148, 97, 253);



            input_list("WHERE 1=1");
            txt_approval_date.Text = DateTime.Now.ToString("yyyy-MM-dd");
        }
Пример #15
0
        private void frm작업일보관리2_Load(object sender, EventArgs e)
        {
            lbl_title.Tag = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[0] + "$" + wnDm.fn_TitleName(this.Name.ToString()).Split('$')[1]; lbl_title.Text = wnDm.fn_TitleName(this.Name.ToString()).Split('$')[2];

            ComInfo.gridHeaderSet(MadeGrid);
            ComInfo.gridHeaderSet(ToipGrid);
        }
        private void frm생산계획등록_Load(object sender, EventArgs e)
        {
            //DateTime today = DateTime.Today.AddMonths(-1);

            start_date.Text = DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd");

            itemPlanGridAdd();

            plan_list(planGrid, "where A.PLAN_DATE >= '" + start_date.Text.ToString() + "' and  A.PLAN_DATE <= '" + end_date.Text.ToString() + "'");

            del_planGrid.AllowUserToAddRows = false;

            del_planGrid.Columns.Add("PLAN_DATE", "PLAN_DATE");
            del_planGrid.Columns.Add("PLAN_CD", "PLAN_CD");
            del_planGrid.Columns.Add("SEQ", "SEQ");

            del_HalfGrid.AllowUserToAddRows = false;

            del_HalfGrid.Columns.Add("PLAN_DATE", "PLAN_DATE");
            del_HalfGrid.Columns.Add("PLAN_CD", "PLAN_CD");
            del_HalfGrid.Columns.Add("SEQ", "SEQ");

            pHalfGrid.AllowUserToAddRows = false;
            for (int i = 0; i < itemHalfGrid.Columns.Count; i++)
            {
                pHalfGrid.Columns.Add(itemHalfGrid.Columns[i].Name.ToString(), itemHalfGrid.Columns[i].Name.ToString());
            }
            pHalfGrid.Columns.Add("F_LEVEL", "F_LEVEL");
            pHalfGrid.Columns.Add("TOP_ITEM_CD", "TOP_ITEM_CD");

            ComInfo.gridHeaderSet(itemPlanGrid);
            ComInfo.gridHeaderSet(planGrid);
        }
Пример #17
0
        private void plan_del()
        {
            ComInfo      comInfo = new ComInfo();
            DialogResult msgOk   = comInfo.deleteConfrim("견적서", txt_esti_date.Text.ToString() + " - " + txt_esti_cd.Text.ToString());

            if (msgOk == DialogResult.No)
            {
                return;
            }

            wnDm wDm   = new wnDm();
            int  rsNum = wDm.deleteEstimate(txt_esti_date.Text.ToString(), txt_esti_cd.Text.ToString());

            if (rsNum == 0)
            {
                resetSetting();

                esti_list(estiGrid, "where A.ESTI_DATE >= '" + start_date.Text.ToString() + "' and  A.ESTI_DATE <= '" + end_date.Text.ToString() + "'");

                MessageBox.Show("성공적으로 삭제하였습니다.");
            }
            else if (rsNum == 1)
            {
                MessageBox.Show("삭제에 실패하였습니다.");
            }
        }
 private void planGrid_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
 {
     if (ComInfo.grdHeaderNoAction(e))
     {
         planDetail(planGrid, e);
     }
 }
        private void item_chk_del()
        {
            ComInfo      comInfo = new ComInfo();
            DialogResult msgOk   = comInfo.deleteConfrim("제품검사항목", txt_item_nm.Text.ToString() + "-" + cmb_item_flow.SelectedValue.ToString());

            if (msgOk == DialogResult.No)
            {
                return;
            }

            wnDm wDm   = new wnDm();
            int  rsNum = wDm.deleteItemChk(txt_item_cd2.Text.ToString());

            if (rsNum == 0)
            {
                resetSetting2();

                item_list();
                MessageBox.Show("성공적으로 삭제하였습니다.");
            }
            else if (rsNum == 1)
            {
                MessageBox.Show("삭제에 실패하였습니다.");
            }
        }
        private void frm원자재투입현황_Load(object sender, EventArgs e)
        {
            start_date.Text = DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd");
            ComInfo.gridHeaderSet(rawOutGrid);

            init_ComboBox();
        }
        private void btnAllSave_Click(object sender, EventArgs e)
        {
            if (txt_root_path.Text.Equals("미등록"))
            {
                MessageBox.Show("작업 경로를 먼저 등록해주시기 바랍니다");
                return;
            }
            StringBuilder sb = new StringBuilder();

            sb.AppendLine("작업경로 : " + txt_root_path.Text + "/Haccp/");
            sb.AppendLine("하위 3개 디렉터리");
            sb.AppendLine("내부의 모든 파일을 일괄 등록합니다.");
            sb.AppendLine("");
            sb.AppendLine("정말로 등록하시겠습니까?");
            sb.AppendLine("");
            sb.AppendLine("***작성일자는 현재 날짜로 등록됩니다***");
            sb.AppendLine("(이미 등록되었거나 이름이 중복되었다면 스킵합니다.)");
            ComInfo      comInfo = new ComInfo();
            DialogResult msgOk   = comInfo.warningMessage(sb.ToString());

            if (msgOk == DialogResult.No)
            {
                return;
            }
            else
            {
                pathAllScan();
            }
        }
Пример #22
0
        private void frmBack_Load(object sender, EventArgs e)
        {
            notice_ExpertDate(sender, e);
            string today = DateTime.Today.AddMonths(0).ToString("yyyy-MM-dd");

            Srch_by_LotNo("L" + today.Replace("-", "").Substring(2));

            ComInfo.gridHeaderSet(MadeGrid);

            updateList(sender, e);
            notice_ExpertDate(sender, e);
            timer          = new Timer();
            timer.Enabled  = true;
            timer.Interval = 1000;
            timer.Tick    += new EventHandler(twin);

            timer.Start();

            timer2          = new Timer();
            timer2.Enabled  = true;
            timer2.Interval = 60000;
            timer2.Tick    += new EventHandler(notice_ExpertDate);
            timer2.Tick    += new EventHandler(updateList);

            timer2.Start();
        }
Пример #23
0
 private void button1_Click(object sender, EventArgs e)
 {
     if (!DesignMode)
     {
         ComInfo.Open();
     }
 }
Пример #24
0
        //콤보박스 바인딩 모음
        private void init_ComboBox()
        {
            ComInfo comInfo  = new ComInfo();
            string  sqlQuery = "";

            매출구분.DataSource    = wnDm.매출구분();
            매출구분.ValueMember   = "코드";
            매출구분.DisplayMember = "명칭";

            sqlQuery              = "";
            cbo배송사원.ValueMember   = "코드";
            cbo배송사원.DisplayMember = "명칭";
            sqlQuery              = comInfo.queryStaff();
            wConst.ComboBox_Read_Blank(cbo배송사원, sqlQuery);

            sqlQuery              = "";
            cbo전표상태.ValueMember   = "코드";
            cbo전표상태.DisplayMember = "명칭";
            sqlQuery              = comInfo.queryCode("640");
            sqlQuery             += "and B.S_CODE in('2','3') "; //2: 배송 3:배송완료

            wConst.ComboBox_Read_Blank(cbo전표상태, sqlQuery);

            sqlQuery = "";

            cbo담당사원.ValueMember   = "코드";
            cbo담당사원.DisplayMember = "명칭";
            sqlQuery = comInfo.queryStaff();
            wConst.ComboBox_Read_Blank(cbo담당사원, sqlQuery);
        }
 private void tdInputGrid_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
 {
     if (ComInfo.grdHeaderNoAction(e))
     {
         input_detail(tdInputGrid, e);
     }
 }
Пример #26
0
        internal static AppDomain NewAppDomain(ComInfo comInfo)
        {
            string clsIdName = comInfo.ClsId.ToString("B");

            //Have we already created an AppDomain for this class id in the loaded module?
            //If so, return it.
            if (appDomains.ContainsKey(clsIdName))
            {
                return(appDomains[clsIdName]);
            }

            //http://stackoverflow.com/a/13355702/864414
            AppDomainSetup domaininfo = new AppDomainSetup();

            domaininfo.ApplicationBase = Path.GetDirectoryName(comInfo.CodeBaseLocal); // CurrentFolder();
            var curDomEvidence = AppDomain.CurrentDomain.Evidence;

            string appDomainName = comInfo.AppDomain ?? clsIdName;

            //The AppDomain name should be the DLL's name.
            AppDomain newDomain = AppDomain.CreateDomain(
                appDomainName,
                curDomEvidence, domaininfo);

            appDomains.Add(clsIdName, newDomain);

            return(newDomain);
        }
Пример #27
0
        private void frmHACCP기준등록_Load(object sender, EventArgs e)
        {
            ComInfo.gridHeaderSet(dataChkGrid);

            HACCP_list();
            init_ComboBox();
        }
Пример #28
0
        private void order_del()
        {
            ComInfo      comInfo = new ComInfo();
            DialogResult msgOk   = comInfo.deleteConfrim("발주서", txt_order_date.Text.ToString() + " - " + txt_order_cd.Text.ToString());

            if (msgOk == DialogResult.No)
            {
                return;
            }

            wnDm wDm   = new wnDm();
            int  rsNum = wDm.deleteOrder(txt_order_date.Text.ToString(), txt_order_cd.Text.ToString());

            if (rsNum == 0)
            {
                resetSetting();
                StringBuilder sb = new StringBuilder();
                sb.AppendLine("and A.ORDER_DATE >= '" + start_date.Text.ToString() + "' and  A.ORDER_DATE <= '" + end_date.Text.ToString() + "'");

                string str = queryStr(sb.ToString());
                order_list(orderGrid, str);

                MessageBox.Show("성공적으로 삭제하였습니다.");
            }
            else if (rsNum == 1)
            {
                MessageBox.Show("삭제에 실패하였습니다.");
            }
        }
        private void init_ComboBox()
        {
            ComInfo comInfo  = new ComInfo();
            string  sqlQuery = "";

            //불량유형 시작
            cmb_poor.ValueMember   = "코드";
            cmb_poor.DisplayMember = "명칭";
            sqlQuery = comInfo.queryPoor(); //" select TYPE_CD as 코드, TYPE_NM as 명칭 from N_TYPE_CODE where 1=1 and POOR_TYPE_YN = 'Y'";
            wConst.ComboBox_Read_Blank(cmb_poor, sqlQuery);

            cmb_poor_type.ValueMember   = "코드";
            cmb_poor_type.DisplayMember = "명칭";
            wConst.ComboBox_Read_Blank(cmb_poor_type, sqlQuery);
            //불량유형 끝

            //담당자
            cmb_manager.ValueMember   = "코드";
            cmb_manager.DisplayMember = "명칭";
            sqlQuery = comInfo.queryStaff();
            wConst.ComboBox_Read_Blank(cmb_manager, sqlQuery);

            //창고
            cmb_stor.ValueMember   = "코드";
            cmb_stor.DisplayMember = "명칭";
            sqlQuery = comInfo.queryStorage();
            wConst.ComboBox_Read_Blank(cmb_stor, sqlQuery);
        }
Пример #30
0
 /// <summary>
 /// 渲染界面
 /// </summary>
 private void RenderLayout()
 {
     try
     {
         lbWriteComStauts.Text       = lbMonitorComStauts.Text = "关闭";;
         btnWriteComOpenOrClose.Text = btnMonitorComOpenOrClose.Text = "开启(&O)";
         if (CardConfiger.GetInstance().ComInfo != null)
         {
             ComInfo objCInfo = CardConfiger.GetInstance().ComInfo;
             if (objCInfo.ComProperty != null)
             {
                 Classes.ComProperty objCom = objCInfo.ComProperty;
                 btnWriteComOpenOrClose.Text = (objCInfo.IfOpen ? "关闭(&C)" : "开启(&O)");
                 lbWriteComStauts.Text       = string.Format("{0},{1},{2},{3},{4},{5}", objCom.PortName.ToUpper(), objCom.BaudRate, objCom.DataBits, GetParityDesc(objCom.Parity), objCom.StopBits, (objCInfo.IfOpen ? "开启" : "关闭"));
             }
         }
         if (CardMonitor.GetInstance().ComInfo != null)
         {
             ComInfo objCInfo = CardMonitor.GetInstance().ComInfo;
             if (objCInfo.ComProperty != null)
             {
                 Classes.ComProperty objCom = objCInfo.ComProperty;
                 btnMonitorComOpenOrClose.Text = (objCInfo.IfOpen ? "关闭(&C)" : "开启(&O)");
                 lbMonitorComStauts.Text       = string.Format("{0},{1},{2},{3},{4},{5}", objCom.PortName.ToUpper(), objCom.BaudRate, objCom.DataBits, GetParityDesc(objCom.Parity), objCom.StopBits, (objCInfo.IfOpen ? "开启" : "关闭"));
             }
         }
     }
     catch
     {
     }
 }