Esempio n. 1
0
        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;
  */              
            }
        }
Esempio n. 2
0
        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());
                }
            }
        }
Esempio n. 3
0
        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;

            }
        }
Esempio n. 4
0
        /*ดึงข้อมูลจากใบเบิก*/
        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());
            }
        }