private void btn_Click(object sender, EventArgs e)/*เมื่อมีการ click ปุ่มการทำงาน*/ { switch(NewFrm){ case "Supplier" ://เรียก Dialog ข้อมูลผู้ขาย Dialog.frmDialogSearchSupplier Supplier; String[] spSupplier = NewTxt.Text.Split(']'); if (spSupplier.Length < 2) { Supplier = new Dialog.frmDialogSearchSupplier(NewTxt.Text); } else { Supplier = new Dialog.frmDialogSearchSupplier(spSupplier[1]); } Supplier.ShowDialog(); if (Supplier.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Supplier.GetSuplierId() + "] " + Supplier.GetSuplierName(); } SendKeys.Send("{TAB}"); break; case "Branch"://เรียก Dialog ข้อมูลสาขา Dialog.frmDialogSearchBranch Branch; String[] spBranch = NewTxt.Text.Split(']'); if (spBranch.Length < 2) { Branch = new Dialog.frmDialogSearchBranch(NewTxt.Text); } else { Branch = new Dialog.frmDialogSearchBranch(spBranch[1]); } Branch.ShowDialog(); if (Branch.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Branch.GetBranchId() + "] " + Branch.GetBranchName(); } SendKeys.Send("{TAB}"); break; case "Shipper"://เรียก Dialog ข้อมูลขนส่ง Dialog.frmDialogSearchShipper Shipper; String[] spShipper = NewTxt.Text.Split(']'); if (spShipper.Length < 2) { Shipper = new Dialog.frmDialogSearchShipper(NewTxt.Text); } else { Shipper = new Dialog.frmDialogSearchShipper(spShipper[1]); } Shipper.ShowDialog(); if (Shipper.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Shipper.GetShipperId() + "] " + Shipper.GetShipperName(); } SendKeys.Send("{TAB}"); break; case "Employer"://เรียก Dialog ข้อมูลเรือนจำ Dialog.frmDialogSearchEmployer Employer; String[] spEmployer = NewTxt.Text.Split(']'); if (spEmployer.Length < 2) { Employer = new Dialog.frmDialogSearchEmployer(NewTxt.Text); } else { Employer = new Dialog.frmDialogSearchEmployer(spEmployer[1]); } Employer.ShowDialog(); if (Employer.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Employer.GetEmployerId() + "] " + Employer.GetEmployerName(); } SendKeys.Send("{TAB}"); break; case "CardFormula"://เรียก Dialog ข้อมูลเรือนจำ ProductionNew.DialogSelectFormula SelectFormula; String[] spSelectFormula = NewTxt.Text.Split(']'); if (spSelectFormula.Length < 2) { SelectFormula = new ProductionNew.DialogSelectFormula(NewTxt.Text); } else { SelectFormula = new ProductionNew.DialogSelectFormula(spSelectFormula[1]); } SelectFormula.ShowDialog(); if (SelectFormula.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + SelectFormula.GetFmId() + "] " + SelectFormula.GetFmName(); } SendKeys.Send("{TAB}"); break; case "Product"://เรียก Dialog ข้อมูลรายการสินค้า Dialog.frmDialogSearchProduct Product; String[] spProduct = NewTxt.Text.Split(']'); if (spProduct.Length < 2) { Product = new Dialog.frmDialogSearchProduct(NewTxt.Text); } else { Product = new Dialog.frmDialogSearchProduct(spProduct[1]); } Product.ShowDialog(); if (Product.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Product.GetProductId() + "] " + Product.GetProductName(); } SendKeys.Send("{TAB}"); break; case "Customer"://เรียก Dialog ข้อมูลลูกค้า Dialog.frmDialogSearchCustomer Customer; String[] spCustomer = NewTxt.Text.Split(']'); if (spCustomer.Length < 2) { Customer = new Dialog.frmDialogSearchCustomer(NewTxt.Text); } else { Customer = new Dialog.frmDialogSearchCustomer(spCustomer[1]); } Customer.ShowDialog(); if (Customer.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Customer.GetCustomerId() + "] " + Customer.GetCustomerName(); } SendKeys.Send("{TAB}"); break; case "CustomerInv"://เรียก Dialog ข้อมูลลูกค้าต่างประเทศ SalePosNew.DialogCustomerInv CustomerInv; String[] spCustomerInv = NewTxt.Text.Split(']'); if (spCustomerInv.Length < 2) { CustomerInv = new SalePosNew.DialogCustomerInv(NewTxt.Text,2); } else { CustomerInv = new SalePosNew.DialogCustomerInv(spCustomerInv[1],2); } CustomerInv.ShowDialog(); if (CustomerInv.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + CustomerInv.GetCustomerId() + "] " + CustomerInv.GetCustomerName(); } SendKeys.Send("{TAB}"); break; case "CustomerTHA"://เรียก Dialog ข้อมูลลูกค้าเฉพาะลูกค้าไทย SalePosNew.DialogCustomerInv CustomerTHA; String[] spCustomerTHA = NewTxt.Text.Split(']'); if (spCustomerTHA.Length < 2) { CustomerTHA = new SalePosNew.DialogCustomerInv(NewTxt.Text, 1); } else { CustomerTHA = new SalePosNew.DialogCustomerInv(spCustomerTHA[1], 1); } CustomerTHA.ShowDialog(); if (CustomerTHA.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + CustomerTHA.GetCustomerId() + "] " + CustomerTHA.GetCustomerName(); } SendKeys.Send("{TAB}"); break; case "Stock"://เรียก Dialog ข้อมูลคลังสินค้า Dialog.frmDialogSearchStocks Stock; String[] spStock = NewTxt.Text.Split(']'); if (spStock.Length < 2) { if (notInList != "") { Stock = new Dialog.frmDialogSearchStocks(NewTxt.Text, notInList,stock); } else { Stock = new Dialog.frmDialogSearchStocks(NewTxt.Text,stock); } } else { if (notInList != "") { Stock = new Dialog.frmDialogSearchStocks(spStock[1], notInList,stock); } else { Stock = new Dialog.frmDialogSearchStocks(spStock[1],stock); } } Stock.ShowDialog(); if (Stock.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Stock.GetStockId() + "] " + Stock.GetStockName(); SendKeys.Send("{TAB}"); } SendKeys.Send("{TAB}"); break; case "FormuLar"://เรียก Dialog ข้อมูลสูตรผลิต Dialog.frmDialogFormular FormuLar; String[] spFormuLar = NewTxt.Text.Split(']'); if (spFormuLar.Length < 2) { FormuLar = new Dialog.frmDialogFormular(NewTxt.Text); } else { FormuLar = new Dialog.frmDialogFormular(spFormuLar[1]); } FormuLar.ShowDialog(); if (FormuLar.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + FormuLar.getFormularId() + "]" + FormuLar.getFormularName(); } SendKeys.Send("{TAB}"); break; case "NettingFail"://เรียก Dialog ข้อมูลประเภาสินค้าที่เสีย ProductionNew.frmNettingFail NettingFail; String[] spNettingFail = NewTxt.Text.Split(']'); if (spNettingFail.Length < 2) { NettingFail = new ProductionNew.frmNettingFail(NewTxt.Text); } else { NettingFail = new ProductionNew.frmNettingFail(spNettingFail[1]); } NettingFail.ShowDialog(); if (NettingFail.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + NettingFail.getCateId() + "]" + NettingFail.getCateName(); SendKeys.Send("{TAB}"); } SendKeys.Send("{TAB}"); break; case "Material"://เรียก Dialog ข้อมูลวัตถุดิบ Dialog.frmDialogCateNet Material; String[] spMaterial = NewTxt.Text.Split(']'); if (spMaterial.Length < 2) { Material = new Dialog.frmDialogCateNet(NewTxt.Text); } else { Material = new Dialog.frmDialogCateNet(spMaterial[1]); } Material.toolStripButton5.Enabled = true; Material.ShowDialog(); if (Material.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Material.getMidString() + "]" + Material.getMnameString(); } SendKeys.Send("{TAB}"); break; case "ACustomer"://เรียก Dialog ข้อมูลคลังสินค้า StockAsiaDrink.DialogSearchCOStock ACustomer; String[] spACustomer = NewTxt.Text.Split(']'); if (spACustomer.Length < 2) { ACustomer = new StockAsiaDrink.DialogSearchCOStock(NewTxt.Text); } else { ACustomer = new StockAsiaDrink.DialogSearchCOStock(spACustomer[1]); } ACustomer.ShowDialog(); if (ACustomer.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + ACustomer.GetCustomerId() + "] " + ACustomer.GetCustomerName(); } SendKeys.Send("{TAB}"); break; case "BranchReceive"://เรียก Dialog ข้อมูลสาขาที่รับ Dialog.frmDialogSearchBranch br; String[] spBr = NewTxt.Text.Split(']'); if (spBr.Length < 2) { br = new Dialog.frmDialogSearchBranch(NewTxt.Text, Class.DBConnString.sDb); } else { br = new Dialog.frmDialogSearchBranch(spBr[1], Class.DBConnString.sDb); } br.ShowDialog(); if (br.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + br.GetBranchId() + "] " + br.GetBranchName(); } SendKeys.Send("{TAB}"); break; case "AShipper"://เรียก Dialog ข้อมูลขนส่ง Dialog.frmDialogSearchShipper AShipper; String[] spAShipper = NewTxt.Text.Split(']'); if (spAShipper.Length < 2) { AShipper = new Dialog.frmDialogSearchShipper(NewTxt.Text); } else { AShipper = new Dialog.frmDialogSearchShipper(spAShipper[1]); } AShipper.ShowDialog(); if (AShipper.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + AShipper.GetShipperId() + "] " + AShipper.GetShipperName(); } SendKeys.Send("{TAB}"); break; case "username"://เรียก Dialog ข้อมูลขนส่ง Requirement .DialogUserName username; String[] spusername = NewTxt.Text.Split(']'); if (spusername.Length < 2) { username = new Requirement.DialogUserName(NewTxt.Text); } else { username = new Requirement.DialogUserName(spusername[1]); } username.ShowDialog(); if (username.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + username.GetUserName() + "] " + username.GetName(); } SendKeys.Send("{TAB}"); break; case "usernameAll"://เรียก Dialog ข้อมูลขนส่ง Requirement.DialogUserNameAll usernameAll; String[] spusernameAll = NewTxt.Text.Split(']'); if (spusernameAll.Length < 2) { usernameAll = new Requirement.DialogUserNameAll(NewTxt.Text); } else { usernameAll = new Requirement.DialogUserNameAll(spusernameAll[1]); } usernameAll.ShowDialog(); if (usernameAll.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + usernameAll.GetUserName() + "] " + usernameAll.GetName(); } SendKeys.Send("{TAB}"); break; case "Req"://เรียก Dialog ข้อมูลขนส่ง Requirement.DialogReq Req; String[] spReq = NewTxt.Text.Split(']'); if (spReq.Length < 2) { Req = new Requirement.DialogReq(NewTxt.Text); } else { Req = new Requirement.DialogReq(spReq[1]); } Req.ShowDialog(); if (Req.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Req.GetReqId() + "] " + Req.GetTitle(); } SendKeys.Send("{TAB}"); break; // 7/5/58 test frmSentConsignmentnew case "ASid"://เรียก Dialog ข้อมูลใบเบิก Dialog.frmDialogSearchRequis ASid; String[] spASid = NewTxt.Text.Split(']'); if (spASid.Length < 2) { ASid = new Dialog.frmDialogSearchRequis(NewTxt.Text); } else { ASid = new Dialog.frmDialogSearchRequis(spASid[1]); } ASid.ShowDialog(); if (ASid.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + ASid.GetShipperId() + "] " + ASid.GetShipperName(); } SendKeys.Send("{TAB}"); break; // end 7/5/58 test frmSentConsignmentnew case "ProductAsiadrink"://เรียก Dialog ข้อมูลรายการสินค้าของสต็อกย่อย Dialog.frmDialogSearchProductStockAsiadrink ProductAsiadrink; String[] spProductAsiadrink = NewTxt.Text.Split(']'); if (spProductAsiadrink.Length < 2) { ProductAsiadrink = new Dialog.frmDialogSearchProductStockAsiadrink(NewTxt.Text); } else { ProductAsiadrink = new Dialog.frmDialogSearchProductStockAsiadrink(spProductAsiadrink[1]); } ProductAsiadrink.ShowDialog(); if (ProductAsiadrink.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + ProductAsiadrink.GetProductId() + "] " + ProductAsiadrink.GetProductName(); } SendKeys.Send("{TAB}"); break; case "TRCustomer"://เรียก Dialog ข้อมูลลูกค้า Transf.DialogSearchTRCustomer TRCustomer; String[] SRCustomer = NewTxt.Text.Split(']'); if (SRCustomer.Length < 2) { TRCustomer = new Transf.DialogSearchTRCustomer(NewTxt.Text); } else { TRCustomer = new Transf.DialogSearchTRCustomer(SRCustomer[1]); } TRCustomer.ShowDialog(); if (TRCustomer.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + TRCustomer.GetCustomerId() + "] " + TRCustomer.GetCustomerName(); } SendKeys.Send("{TAB}"); break; // end 7/5/58 test frmSentConsignmentnew case "testfunction"://เรียก Dialog ข้อมูลสาขา StockAsiaDrink.DialogSearchBranch ProductAsiadrink1; String[] spProductAsiadrink1 = NewTxt.Text.Split(']'); if (spProductAsiadrink1.Length < 2) { ProductAsiadrink1 = new StockAsiaDrink.DialogSearchBranch(NewTxt.Text); } else { ProductAsiadrink1 = new StockAsiaDrink.DialogSearchBranch(spProductAsiadrink1[1]); } ProductAsiadrink1.ShowDialog(); if (ProductAsiadrink1.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + ProductAsiadrink1.GetProductId() + "] " + ProductAsiadrink1.GetProductName(); } SendKeys.Send("{TAB}"); break; case "TRCustomer2"://เรียก Dialog ข้อมูลธนาคาร StockAsiaDrink.DialogSearchBank TRCustomer2; String[] SRCustomer2 = NewTxt.Text.Split(']'); if (SRCustomer2.Length < 2) { TRCustomer2 = new StockAsiaDrink.DialogSearchBank(NewTxt.Text); } else { TRCustomer2 = new StockAsiaDrink.DialogSearchBank(SRCustomer2[1]); } TRCustomer2.ShowDialog(); if (TRCustomer2.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + TRCustomer2.GetCustomerId() + "] " + TRCustomer2.GetCustomerName(); //NewTxt.Text = TRCustomer2.GetCustomerId(); } SendKeys.Send("{TAB}"); break; case "DialogDeposit"://เรียก Dialog ข้อมูลมัดจำ SalePosNew.DialogDeposit DialogDeposit; //String[] SRDialogDeposit = NewTxt.Text.Split(']'); String SRDialogDeposit = NewTxt.Text; DialogDeposit = new SalePosNew.DialogDeposit(SRDialogDeposit, notInList); DialogDeposit.ShowDialog(); if (DialogDeposit.DialogResult == DialogResult.OK) { NewTxt.Text = DialogDeposit.GetCustomerId(); } SendKeys.Send("{TAB}"); break; case "ProductCallToReport"://เรียก Dialog ข้อมูลสินค้าในคลังสินค้าย่อย StockAsiaDrink.DialogSearchProductReport ProductCallToReport; String[] SRProductCallToReport = NewTxt.Text.Split(']'); if (SRProductCallToReport.Length < 2) { ProductCallToReport = new StockAsiaDrink.DialogSearchProductReport(NewTxt.Text); } else { ProductCallToReport = new StockAsiaDrink.DialogSearchProductReport(SRProductCallToReport[1]); } ProductCallToReport.ShowDialog(); if (ProductCallToReport.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + ProductCallToReport.GetCustomerId() + "] " + ProductCallToReport.GetCustomerName(); //NewTxt.Text = TRCustomer2.GetCustomerId(); } SendKeys.Send("{TAB}"); break; case "DialogSaleVat"://เรียก Dialog ข้อมูลการขาย SalePosNew.DialogSaleVat DialogSaleVat; String[] spDialogSaleVat = NewTxt.Text.Split(' '); if (spDialogSaleVat.Length < 2) { DialogSaleVat = new SalePosNew.DialogSaleVat(NewTxt.Text); } else { DialogSaleVat = new SalePosNew.DialogSaleVat(spDialogSaleVat[1]); } DialogSaleVat.ShowDialog(); if (DialogSaleVat.DialogResult == DialogResult.OK) { NewTxt.Text = "" + DialogSaleVat.GetCustomerId() + ""; } SendKeys.Send("{TAB}"); break; case "Employee"://เรียก Dialog ข้อมูลรายการพนักงาน Dialog.frmDialogSearchEmployee Employee; String[] spEmployee = NewTxt.Text.Split(']'); if (spEmployee.Length < 2) { Employee = new Dialog.frmDialogSearchEmployee(NewTxt.Text); } else { Employee = new Dialog.frmDialogSearchEmployee(spEmployee[1]); } Employee.ShowDialog(); if (Employee.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Employee.GetEmployeeId() + "] " + Employee.GetEmployeeName(); } SendKeys.Send("{TAB}"); break; case "Week"://เรียก Dialog ข้อมูลสัปดาห์ DataAnalysis.DialogWeek DialogWeek; String SDialogWeek = NewTxt.Text; DialogWeek = new DataAnalysis.DialogWeek(NewTxt.Text); DialogWeek.StartPosition = FormStartPosition.CenterScreen; DialogWeek.ShowDialog(); if (DialogWeek.DialogResult == DialogResult.OK) { NewTxt.Text = DialogWeek.GetData(); } SendKeys.Send("{TAB}"); break; case "productTranfer"://เรียก Dialog ข้อมูลรายการแจ้งโอนเงินเรือนจำ Dialog.DialogProductTranfer productTranfer; String[] SProductTranfer = NewTxt.Text.Split(']'); if (SProductTranfer.Length < 2) { productTranfer = new Dialog.DialogProductTranfer(NewTxt.Text); } else { productTranfer = new Dialog.DialogProductTranfer(SProductTranfer[1]); } productTranfer.ShowDialog(); if (productTranfer.DialogResult == DialogResult.OK) { NewTxt.Text ="[" + productTranfer.returnVal() + "]"; } SendKeys.Send("{TAB}"); break; //case "ProductCustomer": // SalePosNew.DialogProductCustomer ProductCustomer; // String[] spProductCustomer = NewTxt.Text.Split(' '); // if (spProductCustomer.Length < 2) // { // ProductCustomer = new SalePosNew.DialogProductCustomer(NewTxt.Text); // } // else // { // ProductCustomer = new SalePosNew.DialogProductCustomer(spProductCustomer[1]); // } // ProductCustomer.ShowDialog(); // if (ProductCustomer.DialogResult == DialogResult.OK) // { // NewTxt.Text = "" + ProductCustomer.GetCustomerId() + ""; // } // SendKeys.Send("{TAB}"); // break; /* case "Shipping": Dialog.DialogSearchShipping BillSale; String[] spBillSale = NewTxt.Text.Split(']'); if (spBillSale.Length < 2) { BillSale = new Dialog.DialogSearchShipping(NewTxt.Text); } else { BillSale = new Dialog.DialogSearchShipping(spBillSale[1]); } BillSale.ShowDialog(); if (BillSale.DialogResult == DialogResult.OK) { NewTxt.Text = BillSale.GetBillSaleId(); } SendKeys.Send("{TAB}"); break; */ } }
private void textBox2_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (textBox13.Text == "") { MessageBox.Show("กรุณาเลือกลูกค้า"); return; } if (Class.Function.GetTextId(textBox13.Text) == null) { MessageBox.Show("กรุณาเลือกลูกค้า"); return; } Dialog.frmDialogSearchRequis frm = new Dialog.frmDialogSearchRequis(textBox11.Text.Trim(), Class.Function.GetTextId(textBox13.Text).ToString()); frm.ShowDialog(); if (frm.DialogResult == DialogResult.OK) { String sid = frm.GetShipperId(); //String sql = "select d.productid,p.productname,d.saleappdetailquantitypack,up.unitpackname,d.saleappdetailquantity,u.unitsalename,d.saleappdetailweight,d.productapptype," + // "h.sdateid from sale_app_detail d " + // "inner join sale_app_head h on h.saleappheadid = d.saleappheadid inner join product p on d.productid = p.productid inner join unitsale u on u.unitsaleid = p.unitsaleid " + // "inner join unitpack up on up.unitpackid = p.unitpackid where h.sid = " + sid; String sql = "select d.productid,p.productname,d.InvDetailQuantityPack,up.unitpackname,d.InvDetailQuantity," + "u.unitsalename,d.InvDetailWeight,d.detailType,h.InvHeadId,d.InvDetailId,d.ProductBorderId,b.ProductBorderName " + "from INVOICE_ORIGINAL_DETAIL d " + "inner join INVOICE_ORIGINAL_HEAD h on h.InvHeadId = d.InvHeadId " + "inner join product p on d.productid = p.productid " + "inner join unitsale u on u.unitsaleid = p.unitsaleid " + "INNER JOIN PRODUCT_BORDER b ON b.ProductBorderId=d.ProductBorderId " + "inner join unitpack up on up.unitpackid = p.unitpackid where h.InvHeadId = " + sid; List<string> sidNew = new List<string>(); List<string> ProductId = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<string>("productid")).ToList(); List<string> ProductName = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<string>("productname")).ToList(); List<string> ProductBorderName = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<string>("ProductBorderName")).ToList(); List<string> QuantityPack = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<double>("saleappdetailquantitypack").ToString()).ToList(); List<string> Quantity = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<double>("saleappdetailquantity").ToString()).ToList(); List<string> UnitPackName = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<string>("unitpackname")).ToList(); List<string> UnitSaleName = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<string>("unitsalename")).ToList(); List<string> Weight = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<double>("saleappdetailweight").ToString()).ToList(); List<string> type = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<int>("productapptype").ToString()).ToList(); List<string> sdate = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<string>("sdateid")).ToList(); for (int i = 0; i < ProductId.Count; i++) { sidNew.Add(sid); } if (sidNew.Intersect(sidOld).Count() > 0) { MessageBox.Show("ใบเบิกนี้ถูกเลือกแล้ว"); return; } else { sidOld.Add(sid); for (int i = 0; i < ProductId.Count; i++) { String w = ""; String sqlw = "select * from sale_app_weight w inner join sale_app_head h on w.saleappheadid = h.saleappheadid where w.productid = '" + ProductId[i] + "' " + "AND h.sid = '" + sid + "' "; System.Data.SqlClient.SqlDataReader readerw = Class.DBConnString.clsDB.QueryDataReader(sqlw); if (type[i] != "3") { while (readerw.Read()) { w += readerw["SaleAppPackId"].ToString() + "#"; w += readerw["SaleAppPack"].ToString() + "#"; if (type[i] == "1") { w += readerw["SaleAppWeight"].ToString() + "#"; } } } lProidOld.Add(new ListId { ProductId = ProductId[i], ProductName = ProductName[i], ProductBorderName = ProductBorderName[i], UnitPackName = UnitPackName[i], UnitSaleName = UnitSaleName[i], QuantityPack = QuantityPack[i], Quantity = Quantity[i], Weight = Weight[i], type = type[i], sdate = sdate[i], price = "0.00", distext = "0", disper = "0.00", dis = "0.00", total = "0.00" }); loadGridSale(ProductId[i], ProductName[i], ProductBorderName[i], Convert.ToDouble(QuantityPack[i]).ToString("#,##0.00"), UnitPackName[i], Convert.ToDouble(Quantity[i]).ToString("#,##0.00"), UnitSaleName[i], "0.00", Convert.ToDouble(Weight[i]).ToString("#,##0.00"), Convert.ToInt16(type[i]).ToString(), w, sdate[i].ToString(), "0", "0.00", "0.00", "0.00"); //loadGridSale(ProductId[i], ProductName[i], UnitPackName[i], UnitSaleName[i], "0.00", // Convert.ToDouble(QuantityPack[i]).ToString("#,##0.00"), Convert.ToDouble(Quantity[i]).ToString("#,##0.00"), // Convert.ToDouble(Weight[i]).ToString("#,##0.00"), Convert.ToInt16(type[i]).ToString(), w, sdate[i].ToString(), // "0", "0.00", "0.00", "0.00"); } //Convert.ToDouble(Class.Function.SaleTopReturnPriceAndDate(ProductId[i], Class.DBConnString.sDb, Class.Function.GetTextId(textBox13.Text))).ToString("#,##0.00") /////////////// setCalulate(); /////////////// } Class.Function.SetDgvWeightFnc(dataGridView1.Rows[0].Cells[17].Value.ToString(), dataGridView2, dataGridView1.Rows[0].Cells[18].Value.ToString()); } } }
private void btn_Click(object sender, EventArgs e) { //if () //{ //} switch (NewFrm) { //case "ProductCallToReport": // StockAsiaDrink.DialogSearchProductReport ProductCallToReport; // String[] spProductCallToReport = NewTxt.Text.Split(']'); // if (spProductCallToReport.Length < 2) // { // ProductCallToReport = new StockAsiaDrink.DialogSearchProductReport(NewTxt.Text); // } // else // { // ProductCallToReport = new StockAsiaDrink.DialogSearchProductReport(spProductCallToReport[1]); // } // ProductCallToReport.ShowDialog(); // if (ProductCallToReport.DialogResult == DialogResult.OK) // { // NewTxt.Text = "[" + ProductCallToReport.GetCustomerId() + "] " + ProductCallToReport.GetCustomerName(); // } // SendKeys.Send("{TAB}"); // break; case "Supplier"://เรียก Dialog ข้อมูลผู้ขาย Dialog.frmDialogSearchSupplier Supplier; String[] spSupplier = NewTxt.Text.Split(']'); if (spSupplier.Length < 2) { Supplier = new Dialog.frmDialogSearchSupplier(NewTxt.Text); } else { Supplier = new Dialog.frmDialogSearchSupplier(spSupplier[1]); } Supplier.ShowDialog(); if (Supplier.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Supplier.GetSuplierId() + "] " + Supplier.GetSuplierName(); } SendKeys.Send("{TAB}"); break; case "Branch"://เรียก Dialog ข้อมูลสาขา Dialog.frmDialogSearchBranch Branch; String[] spBranch = NewTxt.Text.Split(']'); if (spBranch.Length < 2) { Branch = new Dialog.frmDialogSearchBranch(NewTxt.Text); } else { Branch = new Dialog.frmDialogSearchBranch(spBranch[1]); } Branch.ShowDialog(); if (Branch.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Branch.GetBranchId() + "] " + Branch.GetBranchName(); } SendKeys.Send("{TAB}"); break; case "Shipper"://เรียก Dialog ข้อมูลขนส่ง Dialog.frmDialogSearchShipper Shipper; String[] spShipper = NewTxt.Text.Split(']'); if (spShipper.Length < 2) { Shipper = new Dialog.frmDialogSearchShipper(NewTxt.Text); } else { Shipper = new Dialog.frmDialogSearchShipper(spShipper[1]); } Shipper.ShowDialog(); if (Shipper.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Shipper.GetShipperId() + "] " + Shipper.GetShipperName(); } SendKeys.Send("{TAB}"); break; case "Employer"://เรียก Dialog ข้อมูลเรือนจำ Dialog.frmDialogSearchEmployer Employer; String[] spEmployer = NewTxt.Text.Split(']'); if (spEmployer.Length < 2) { Employer = new Dialog.frmDialogSearchEmployer(NewTxt.Text); } else { Employer = new Dialog.frmDialogSearchEmployer(spEmployer[1]); } Employer.ShowDialog(); if (Employer.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Employer.GetEmployerId() + "] " + Employer.GetEmployerName(); } SendKeys.Send("{TAB}"); break; case "CardFormula"://เรียก Dialog ข้อมูลเรือนจำ ProductionNew.DialogSelectFormula SelectFormula; String[] spSelectFormula = NewTxt.Text.Split(']'); if (spSelectFormula.Length < 2) { SelectFormula = new ProductionNew.DialogSelectFormula(NewTxt.Text); } else { SelectFormula = new ProductionNew.DialogSelectFormula(spSelectFormula[1]); } SelectFormula.ShowDialog(); if (SelectFormula.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + SelectFormula.GetFmId() + "] " + SelectFormula.GetFmName(); } SendKeys.Send("{TAB}"); break; case "Product"://เรียก Dialog ข้อมูลรายการสินค้า Dialog.frmDialogSearchProduct Product; String[] spProduct = NewTxt.Text.Split(']'); if (spProduct.Length < 2) { Product = new Dialog.frmDialogSearchProduct(NewTxt.Text); } else { Product = new Dialog.frmDialogSearchProduct(spProduct[1]); } Product.ShowDialog(); if (Product.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Product.GetProductId() + "] " + Product.GetProductName(); } SendKeys.Send("{TAB}"); break; case "Customer"://เรียก Dialog ข้อมูลลูกค้า Dialog.frmDialogSearchCustomer Customer; String[] spCustomer = NewTxt.Text.Split(']'); if (spCustomer.Length < 2) { Customer = new Dialog.frmDialogSearchCustomer(NewTxt.Text); } else { Customer = new Dialog.frmDialogSearchCustomer(spCustomer[1]); } Customer.ShowDialog(); if (Customer.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + Customer.GetCustomerId() + "] " + Customer.GetCustomerName(); } SendKeys.Send("{TAB}"); break; case "ACustomer"://เรียก Dialog ข้อมูลลูกค้า Dialog.frmDialogSearchCustomer ACustomer; String[] spACustomer = NewTxt.Text.Split(']'); if (spACustomer.Length < 2) { ACustomer = new Dialog.frmDialogSearchCustomer(NewTxt.Text); } else { ACustomer = new Dialog.frmDialogSearchCustomer(spACustomer[1]); } ACustomer.ShowDialog(); if (ACustomer.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + ACustomer.GetCustomerId() + "] " + ACustomer.GetCustomerName(); } SendKeys.Send("{TAB}"); break; case "BranchReceive"://เรียก Dialog ข้อมูลสาขารับ Dialog.frmDialogSearchBranch br; String[] spBr = NewTxt.Text.Split(']'); if (spBr.Length < 2) { br = new Dialog.frmDialogSearchBranch(NewTxt.Text, Class.DBConnString.sDb); } else { br = new Dialog.frmDialogSearchBranch(spBr[1], Class.DBConnString.sDb); } br.ShowDialog(); if (br.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + br.GetBranchId() + "] " + br.GetBranchName(); } SendKeys.Send("{TAB}"); break; case "AShipper"://เรียก Dialog ข้อมูลขนส่ง Dialog.frmDialogSearchShipper AShipper; String[] spAShipper = NewTxt.Text.Split(']'); if (spAShipper.Length < 2) { AShipper = new Dialog.frmDialogSearchShipper(NewTxt.Text); } else { AShipper = new Dialog.frmDialogSearchShipper(spAShipper[1]); } AShipper.ShowDialog(); if (AShipper.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + AShipper.GetShipperId() + "] " + AShipper.GetShipperName(); } SendKeys.Send("{TAB}"); break; // 7/5/58 test frmSentConsignmentnew case "ASid"://เรียก Dialog ข้อมูลใบเบิก Dialog.frmDialogSearchRequis ASid; String[] spASid = NewTxt.Text.Split(']'); if (spASid.Length < 2) { ASid = new Dialog.frmDialogSearchRequis(NewTxt.Text); } else { ASid = new Dialog.frmDialogSearchRequis(spASid[1]); } ASid.ShowDialog(); if (ASid.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + ASid.GetShipperId() + "] " + ASid.GetShipperName(); } SendKeys.Send("{TAB}"); break; // end 7/5/58 test frmSentConsignmentnew case "ProductAsiadrink"://เรียก Dialog ข้อมูลรายการสินค้าในคลังย่อย Dialog.frmDialogSearchProductStockAsiadrink ProductAsiadrink; String[] spProductAsiadrink = NewTxt.Text.Split(']'); if (spProductAsiadrink.Length < 2) { ProductAsiadrink = new Dialog.frmDialogSearchProductStockAsiadrink(NewTxt.Text); } else { ProductAsiadrink = new Dialog.frmDialogSearchProductStockAsiadrink(spProductAsiadrink[1]); } ProductAsiadrink.ShowDialog(); if (ProductAsiadrink.DialogResult == DialogResult.OK) { NewTxt.Text = "[" + ProductAsiadrink.GetProductId() + "] " + ProductAsiadrink.GetProductName(); } SendKeys.Send("{TAB}"); break; } }
/*ดึงข้อมูลจากใบเบิก*/ private void valuesRO() { if (textBox13.Text == "") { MessageBox.Show("กรุณาเลือกลูกค้า"); return; } if (Class.Function.GetTextId(textBox13.Text) == null) { MessageBox.Show("กรุณาเลือกลูกค้า"); return; } Dialog.frmDialogSearchRequis frm = new Dialog.frmDialogSearchRequis(textBox12.Text.Trim(), Class.Function.GetTextId(textBox13.Text).ToString()); frm.ShowDialog(); tempLastPrice.Clear(); if (frm.DialogResult == DialogResult.OK) { String sid = frm.GetShipperId(); String sql = "select cast(saleappdetailid as varchar(20)) AS SaleDetailId, " + "d.productid,p.productname, d.saleappdetailquantitypack,up.unitpackname,d.saleappdetailquantity,u.unitsalename," + "d.saleappdetailweight,d.productapptype,h.sdateid from sale_app_detail d " + "inner join sale_app_head h on h.saleappheadid = d.saleappheadid " + "inner join product p on d.productid = p.productid " + "inner join unitsale u on u.unitsaleid = p.unitsaleid " + "inner join unitpack up on up.unitpackid = p.unitpackid where h.sid = " + sid; List<string> sidNew = new List<string>(); List<string> DetailId = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<string>("SaleDetailId")).ToList(); List<string> ProductId = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<string>("productid")).ToList(); List<string> ProductName = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<string>("productname")).ToList(); List<string> QuantityPack = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<double>("saleappdetailquantitypack").ToString()).ToList(); List<string> Quantity = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<double>("saleappdetailquantity").ToString()).ToList(); List<string> UnitPackName = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<string>("unitpackname")).ToList(); List<string> UnitSaleName = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<string>("unitsalename")).ToList(); List<string> Weight = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<double>("saleappdetailweight").ToString()).ToList(); List<string> type = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<int>("productapptype").ToString()).ToList(); List<string> sdate = Class.DBConnString.clsDB.QueryDataTable(sql).Rows.OfType<DataRow>().Select(dr => dr.Field<string>("sdateid")).ToList(); for (int i = 0; i < ProductId.Count; i++) { sidNew.Add(sid); } if (sidNew.Intersect(sidOld).Count() > 0) { MessageBox.Show("ใบโอนนี้ถูกเลือกแล้ว"); return; } else { sidOld.Add(sid); String Price = ""; for (int i = 0; i < ProductId.Count; i++) { String w = ""; String sqlw = "select * from sale_app_weight w inner join sale_app_head h on w.saleappheadid = h.saleappheadid where w.productid = '" + ProductId[i] + "' " + "AND h.sid = '" + sid + "' "; System.Data.SqlClient.SqlDataReader readerw = Class.DBConnString.clsDB.QueryDataReader(sqlw); if (type[i] != "3") { while (readerw.Read()) { w += readerw["SaleAppPackId"].ToString() + "#"; w += readerw["SaleAppPack"].ToString() + "#"; if (type[i] == "1") { w += readerw["SaleAppWeight"].ToString() + "#"; } } } object costTop = getLastPriceSale(ProductId[i]); Price = (costTop == null) ? "0.00" : ((DataRow)costTop)["cost"].ToString(); Price = Convert.ToDouble(Price).ToString("#,##0.00"); if (lProidOld.Where(a => a.DetailId == DetailId[i]).FirstOrDefault() != null) { lProidOld.Where(a => a.DetailId == DetailId[i]).FirstOrDefault().price = Price; } lProidOld.Add(new ListId { DetailId =DetailId [i], ProductId = ProductId[i], ProductName = ProductName[i], UnitPackName = UnitPackName[i], UnitSaleName = UnitSaleName[i], QuantityPack = QuantityPack[i], Quantity = Quantity[i], Weight = Weight[i], type = type[i], sdate = sdate[i], price = Price, distext = "0", disper = "0.00", dis = "0.00", total = "0.00", Detail = w }); loadGridSale( DetailId [i], ProductId[i], ProductName[i], UnitPackName[i], UnitSaleName[i], "0.00", Convert.ToDouble(QuantityPack[i]).ToString("#,##0.00"), Convert.ToDouble(Quantity[i]).ToString("#,##0.00"), Convert.ToDouble(Weight[i]).ToString("#,##0.00"), Convert.ToInt16(type[i]).ToString(), w, sdate[i].ToString(), "0", "0.00", "0.00", "0.00"); } setCalulate(); } Class.Function.SetDgvWeightFnc(dataGridView1.Rows[0].Cells[17].Value.ToString(), dataGridView2, dataGridView1.Rows[0].Cells[18].Value.ToString()); } }