private void EmpReport_Load(object sender, EventArgs e) { Class.btnControl btnemp = new Class.btnControl(); btnemp.BtnControl(txtEmployer, "Employer"); Class.btnControl btnFm = new Class.btnControl(); btnFm.BtnControl(txtFmId, "CardFormula"); }
private void CardReceive_Load(object sender, EventArgs e) { Class.btnControl btnemp = new Class.btnControl(); Class.btnControl btnformula = new Class.btnControl(); btnemp.BtnControl(txtEmployer, "Employer");//กำหนดรูปแบบปุ่มการใช้งานเพื่อเรียกใช้ฟังก์ชัน designfunction ข้อมูลเรือนจำ btnformula.BtnControl(txtFmId, "CardFormula");//กำหนดรูปแบบปุ่มการใช้งานเพื่อเรียกใช้ฟังก์ชัน designfunction ข้อมูลสูตรผลิต }
/*ปิด textbox กรณีเลือก combobox*/ private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { switch (comboBox1.SelectedIndex) { case 0: Class.btnControl btn = new Class.btnControl(); btn.BtnControl(textBox1, "Supplier"); textBox1.Visible = true; textBox1.Dock = DockStyle.Fill; textBox1.Focus(); textBox2.Visible = false; textBox3.Visible = false; textBox4.Visible = false; textBox5.Visible = false; break; case 1: Class.btnControl btn2 = new Class.btnControl(); btn2.BtnControl(textBox2, "Product"); textBox1.Visible = false; textBox2.Visible = true; textBox2.Dock = DockStyle.Fill; textBox2.Focus(); textBox3.Visible = false; textBox4.Visible = false; textBox5.Visible = false; break; case 2: Class.btnControl btn3 = new Class.btnControl(); btn3.BtnControl(textBox3, "Shipper"); textBox1.Visible = false; textBox2.Visible = false; textBox3.Visible = true; textBox3.Dock = DockStyle.Fill; textBox3.Focus(); textBox4.Visible = false; textBox5.Visible = false; break; case 3: textBox1.Visible = false; textBox2.Visible = false; textBox3.Visible = false; textBox4.Visible = true; textBox4.Dock = DockStyle.Fill; textBox4.Focus(); textBox5.Visible = false; break; case 4: textBox1.Visible = false; textBox2.Visible = false; textBox3.Visible = false; textBox4.Visible = false; textBox5.Visible = true; textBox5.Dock = DockStyle.Fill; textBox5.Focus(); break; } }
private void CheckRequirementManage_Load(object sender, EventArgs e) { Class.btnControl btnFm = new Class.btnControl(); btnFm.BtnControl(txtContractor, "username"); String UserName = clsCash.sUserIdLogin; string sqlPermission = "USE KTC SELECT COUNT(UserName)UserName FROM REQUESTUSER WHERE ClaimId = 2 AND UserName = '******'"; DataTable dtPermission = Class.DBConnString.clsDB.QueryDataTable(sqlPermission); int Permission = Convert.ToInt16(dtPermission.Rows[0]["UserName"].ToString()); if (Permission < 1) { toolStripButton3.Enabled = false; } else { toolStripButton3.Enabled = true; } }
private void AddBankBranch_Load(object sender, EventArgs e) { Class.btnControl btn = new Class.btnControl(); btn.BtnControl(textBox1, "Employer"); Class.Function.LoadDataCate(comboBox1, "select * from bank", "bankId", "bankName"); Class.Function.LoadDataCate(comboBox2, "select bankbranchId,bankbranchName from bankbranch","bankbranchId", "bankbranchName"); Class.Function.LoadDataCate(comboBox3, "select * from [BANKTYPE]", "BankTypeId", "BankTypeName"); textBox2.Text = ID; textBox1.Text = "[" + strSid + "] " + strSname; comboBox1.Text = strBank; comboBox2.Text = strMajor; textBox3.Text = strAname; textBox4.Text = strDes; comboBox3.Text = strType; }
/*กำหนดปุ่มการทำงานเรียกใช้ฟังก์ชัน*/ private void call_function() { Class.btnControl btcus = new Class.btnControl(); btcus.BtnControl(textBox5, "Customer"); /////////// Class.btnControl btpro = new Class.btnControl(); btpro.BtnControl(textBox4, "Product"); /////////// Class.btnControl sup = new Class.btnControl(); sup.BtnControl(textBox6, "Supplier"); /////////// Class.Function.LoadDataCate(comboBox1, "select 0 as saleheadstatusid,'ทั้งหมด' as saleheadstatusname union all select * from SALEHEADSTATUS where saleheadstatusid not in(3) ", "saleheadstatusid", "saleheadstatusname"); }
private void LeadTime_Load(object sender, EventArgs e) { Class.btnControl btws = new Class.btnControl();//กำหนดปุ่มการทำงาน btws.BtnControl(txtWeekStart, "Week"); Class.btnControl btwe = new Class.btnControl();//กำหนดปุ่มการทำงาน btwe.BtnControl(txtWeekEnd, "Week"); rdoYear.Checked = true; rdoTri.Checked = false; rdoMonth.Checked = false; rdoWeek.Checked = false; rdoDay.Checked = false; int i = 0; foreach (string s in month) { cboMonthStart.Items.Add(new ComboboxItem { Text = s, Value = i }); i++; } cboMonthStart.SelectedIndex = 0; int j = 0; foreach (string s in month) { cboMonthEnd.Items.Add(new ComboboxItem { Text = s, Value = j }); j++; } cboMonthEnd.SelectedIndex = 0; int k = 0; foreach (string t in trimas) { cboTriStart.Items.Add(new ComboboxItem { Text = t, Value = k }); k++; } cboTriStart.SelectedIndex = 0; int z = 0; foreach (string t in trimas) { cboTriEnd.Items.Add(new ComboboxItem { Text = t, Value = z }); z++; } cboTriEnd.SelectedIndex = 0; }
void setFirstLoad()/*ตั้งค่าเริ่มต้นการใช้งานเมื่อเปิด form*/ { tabControl1.TabPages.Remove(tabPage2); string sqlTax = "select * from Tax where tax_auto_id not in(5,6)"; Class.Function.LoadDataCate(comboBox3, sqlTax, "tax_auto_id", "tax_type"); ///// ลูกค้า Class.btnControl btcus = new Class.btnControl(); btcus.BtnControl(textBox13, "Customer"); textBox1.Text = saleSOid(); ////// accountid Class.btnControl bk = new btnControl(); bk.BtnControl(textBox26, "TRCustomer2"); ////// bank string sqlBank = "SELECT BankId,BankName FROM Bank"; Class.Function.LoadDataCate(comboBox6, sqlBank, "BankId", "BankName"); string sqlreason = "SELECT ReTypeId,ReTypeName FROM RE_REASON_TYPE"; Class.Function.LoadDataCate(comboBox1, sqlreason, "ReTypeId", "ReTypeName"); }
private void InvoiceOriginalRe_Load(object sender, EventArgs e) { tabControl1.TabPages.RemoveAt(4); tabControl1.TabPages.RemoveAt(4); tabControl1.TabPages.RemoveAt(4); tabControl1.TabPages.RemoveAt(4); setFirstLoad(); if (head == null) { getNewId(); } else { getFromManage(head); } if (clsCash.IsPermissionId("P39") == false) { button1.Enabled = false; } else { if (iSta == "ยกเลิก") { button1.Enabled = false; } else { if (iConf == "อนุมัติ") { button1.Enabled = false; } else { button1.Enabled = true; } } } Class.btnControl btShipp = new Class.btnControl(); btShipp.BtnControl(txtShip, "AShipper"); }
private void AddOwnAccount2_Load(object sender, EventArgs e) { Class.btnControl btn = new Class.btnControl(); btn.BtnControl(textBox1, "testfunction"); Class.Function.LoadDataCate(comboBox1, "select * from bank ", "bankId", "bankName"); Class.Function.LoadDataCate(comboBox2, "select bankbranchId,bankbranchName from bankbranch", "bankbranchId", "bankbranchName"); Class.Function.LoadDataCate(comboBox3, "select * from [BANKTYPE]", "BankTypeId", "BankTypeName"); if (ID != "") { txtBankBookCode.Text = ID; textBox1.Text = strName; textBox1.Enabled = false; textBox2.Text = strAccNumber; textBox3.Text = strAccName; comboBox3.Text = strType; comboBox2.Text = strbname; comboBox1.Text = strbn; textBox4.Text = strDes; } else { textBox1.Enabled = true; } //LoadValue(); }
private void ProductionPeapleWait_Load(object sender, EventArgs e) { //dateTimePicker1.Value = Convert.ToDateTime(Class.DBConnString.clsDB.QueryExecuteScalarNonAlert("SELECT GETDATE()")); if (EditId != "") { txtWaitId.Text = EditId.Trim(); } else { txtWaitId.Text = loadId(); } //Class.btnControl btcus = new Class.btnControl();//กำหนดปุ่มการทำงาน //btcus.BtnControl(textBox3, "Customer"); Class.btnControl btsup = new Class.btnControl();//กำหนดปุ่มการทำงาน btsup.BtnControl(textBox3, "Supplier"); }
private void ReturnMaterial_Load(object sender, EventArgs e) { Class.btnControl btEmployer = new Class.btnControl(); btEmployer.BtnControl(txtEmployer, "Employer");//เรียกใช้ฟังก์ชัน designfunction Class.btnControl btShip = new Class.btnControl(); btShip.BtnControl(txtShip, "Shipper");//เรียกใช้ฟังก์ชัน designfunction Class.btnControl btFmId = new Class.btnControl(); btFmId.BtnControl(txtFmId, "FormuLar");//เรียกใช้ฟังก์ชัน designfunction loadingfirst(); if (clsCash.IsPermissionId("P47") == false) { toolStripButton3.Enabled = false; toolStripButton5.Enabled = false; } else { toolStripButton3.Enabled = true; toolStripButton5.Enabled = true; } }
private void loadChecking(String w = "") { dataGridView1.DataSource = null; dataGridView2.DataSource = null; dataGridView3.DataSource = null; label1.Text = "ค้นใบตรวจ"; label2.Text = "สินค้าเสีย"; label4.Text = "สินค้าดี"; Class.btnControl btne = new Class.btnControl(); Class.btnControl btns = new Class.btnControl(); btne.BtnControl(textBox2, "NettingFail");//เรียกใช้ฟังก์ชัน designfunction ประเภทอวนเสีย btns.BtnControl(textBox4, "Product");//เรียกใช้ฟังก์ชัน designfunction รายการสินค้า //tableLayoutPanel2.SetColumnSpan(dataGridView2, 1); //dataGridView3.Visible = true; //dataGridView3.Dock = DockStyle.Fill; TableLayoutColumnStyleCollection columnStyles = tableLayoutPanel2.ColumnStyles; //columnStyles[2].Width =200; String sql = "select c.productioncheckdate,c.ProductionCheckId,c.ProductionWaitId,wh.ProductionWaitDate,c.ProductionWaitdetailId,ey.employername,c.FmId,f.fmName,c.Quantity,c.NetWell,c.NetFail,c.NetDiff,c.NetLost,cc.confirmname,case when c.productioncheckstatusid = 0 then 'ปกติ' else 'ยกเลิก' end as productioncheckstatusid " + "from ProductionCheck c inner join productionformular f on f.fmid = c.fmid inner join confirm cc on c.confirmid = cc.confirmid inner join productionwaithead wh on wh.ProductionWaitId = c.ProductionWaitId inner join employer ey on ey.employerid = wh.employerid " +w; DataTable dt = Class.DBConnString.clsDB.QueryDataTable(sql); dataGridView1.DataSource = dt; loadCheckingHead(); if (dt.Rows.Count<1) return; sql = "select w.ProductionCheckWellId,w.ProductionCheckId,w.ProductId,p.ProductName,w.Quantity,u.UnitSaleName,"+ " (select f.fmid from productionformular f inner join productiondraw_head ph on f.fmid = ph.fmid where ph.newproductionid = w.newproductionid) as fmid,"+ " (select f.fmname from productionformular f inner join productiondraw_head ph on f.fmid = ph.fmid where ph.newproductionid = w.newproductionid) as fmname,w.newproductionid as id,pcs.productioncheckstatusname from ProductionCheckWell w " + "inner join product p on w.productid = p.productid inner join unitsale u on p.unitsaleid = u.unitsaleid inner join productioncheckstatus pcs on w.productioncheckstatusid = pcs.productioncheckstatusid where w.ProductionCheckId = " + dt.Rows[0]["ProductionCheckId"].ToString(); dataGridView2.DataSource = Class.DBConnString.clsDB.QueryDataTable(sql);//ดึงข้อมูลเก็บใน Datagridview sql = "select w.ProductionCheckFailId,w.ProductionCheckId,w.NetFId,p.NetFName,w.Quantity,"+ "(select f.fmid from productionformular f inner join productiondraw_head ph on f.fmid = ph.fmid where ph.newproductionid = w.newproductionid) as fmid," + "(select f.fmname from productionformular f inner join productiondraw_head ph on f.fmid = ph.fmid where ph.newproductionid = w.newproductionid) as fmname,w.newproductionid as id,pcs.productioncheckstatusname from ProductionCheckFail w " + "inner join productionnettingfail p on w.NetFId = p.NetFId inner join productioncheckstatus pcs on w.productioncheckstatusid = pcs.productioncheckstatusid where w.ProductionCheckId = " + dt.Rows[0]["ProductionCheckId"].ToString(); dataGridView3.DataSource = Class.DBConnString.clsDB.QueryDataTable(sql);//ดึงข้อมูลเก็บใน Datagridview loadCheckingWell(); loadCheckingFail(); }
private void ReportComplete_Load(object sender, EventArgs e) { Class.btnControl btReq = new Class.btnControl();//กำหนดปุ่มการทำงาน btReq.BtnControl(txtReqId, "Req"); }
private void loadFirst() { dptRecDate.Value = Class.DBConnString.toDay; textBox3.Text = round(Class.Function.GetDate(dptRecDate.Value)); BtnCustomerControlTxtProductName(); //txtInvoice.Text = ""; //Class.clsCash.sUserLogin; b = new Class.btnControl(); b.BtnControl(textBox4, "Stock",stock); }
private void ProductionChecking_Load(object sender, EventArgs e) { dgvQty.AutoGenerateColumns = true; textBox1.Text = ProductionId(); Class.btnControl btnE = new Class.btnControl(); btnE.BtnControl(txtVillager, "Supplier"); //dateTimePicker1.Value = Convert.ToDateTime(Class.DBConnString.clsDB.QueryExecuteScalarNonAlert("SELECT GETDATE()")); //if (Id != "") { // loadValues(); //}else{ // loadFirst(); //} }
private void ProductionBackNew_Load(object sender, EventArgs e) { dtpDate.Value = Convert.ToDateTime(Class.DBConnString.clsDB.QueryExecuteScalarNonAlert("SELECT GETDATE()")); Class.btnControl btShipp = new Class.btnControl(); btShipp.BtnControl(txtSupplier, "Supplier"); txtDrawHeadId.Text = ProductionDrawEmployerId(); if (head == "") { txtDrawHeadId.Text = ProductionDrawEmployerId(); } else { } }
/*เริ่มต้นเข้าใช้งานใน form*/ private void loadFirst() { txtRec.Text = loadId(); Class.btnControl btnE = new Class.btnControl(); BtnProductNameControlTxtProductName(); btnE.BtnControl(txtEmp, "Employer"); dgvReceive.ColumnCount = 7; dgvReceive.Columns[0].Name = "productioncheckfailId"; dgvReceive.Columns[0].HeaderText = "รหัสใบรอซ่อม"; dgvReceive.Columns[1].Name = "FmId"; dgvReceive.Columns[1].HeaderText = "รหัสสูตร"; dgvReceive.Columns[2].Name = "FmName"; dgvReceive.Columns[2].HeaderText = "ชื่อสูตร"; dgvReceive.Columns[3].Name = "NetFName"; dgvReceive.Columns[3].HeaderText = "ประเภทอวนผิด"; dgvReceive.Columns[4].Name = "SendQuantity"; dgvReceive.Columns[4].HeaderText = "จำนวนส่งได้"; dgvReceive.Columns[5].Name = "Quantity"; dgvReceive.Columns[5].HeaderText = "จำนวน"; dgvReceive.Columns[6].Name = "Remark"; dgvReceive.Columns[6].HeaderText = "หมายเหตุ";/*กำหนด column name และ headertext ของ datagridview*/ if (Id != "") { String sql = "select *,e.employername from ProductionRepairHead p inner join employer e on p.employerid = e.employerid " + "where ProductionRepairHeadId = '"+Id+"'"; DataTable dt = Class.DBConnString.clsDB.QueryDataTable(sql); txtRec.Text = dt.Rows[0]["ProductionRepairHeadId"].ToString();//เลขที่ใบซ่อม txtEmp.Text = "[" + dt.Rows[0]["employerid"].ToString() + "] " + dt.Rows[0]["employername"].ToString();//ข้อมูลเรือนจำ dptRecDate.Value = Convert.ToDateTime(dt.Rows[0]["ProductionRepairHeadDate"]);//วันที่ซ่อม TxtDescription.Text = dt.Rows[0]["Remark"].ToString();//หมายเหตุ if (dt.Rows[0]["ProductionSendProductId"].ToString() == "0")//สถานที่ส่งอวนซ่อม { radioButton1.Checked = true; } else { radioButton2.Checked = true; } sql = "select d.*,fm.netfname,fl.fmname,(isnull(pf.Quantity,0) - isnull(pf.QuantityReceive,0)) + isnull(d.Quantity,0) as qty " + "from ProductionRepairDetail d inner join productioncheckfail pf ON pf.ProductionCheckFailId = d.ProductionCheckFailId INNER JOIN "+ "dbo.ProductionNettingFail fm on pf.netfid = fm.NetFId inner join productionformular fl on fl.fmid = d.fmid where d.ProductionRepairHeadId = '"+Id+"'"; DataTable dd = Class.DBConnString.clsDB.QueryDataTable(sql); foreach (DataRow d in dd.Rows) { dgvReceive.Rows.Add(d["productioncheckfailId"].ToString(),d["fmid"].ToString(),d["fmname"].ToString(), d["netfname"].ToString(), d["qty"].ToString(), d["Quantity"].ToString(), d["Remark"].ToString()); } } }
private void frmMakingNetsWage_Load(object sender, EventArgs e) { toolStripSeparator1.Visible = false; toolStripLabel1.Visible = false; toolStripTextBox1.Visible = false; Class.btnControl btne = new Class.btnControl(); btne.BtnControl(txtJ, "Employer");//เรียกใช้ฟังก์ชัน designfunction ข้อมูลเรือนจำ InitColumnsHead(); InitColumnsItem(); InitColumnsCard(); LoadFirst(); }
private void TranferManage_Load(object sender, EventArgs e) { //String sql = "select 0 as GrStockDetailId,'ทั้งหมด' as GrStockDetailLName UNION ALL select gsd.GrStockDetailId,gsd.GrStockDetailLName FROM dbo.GrStockDetail gsd WHERE gsd.GrStockId = 1 "; //Class.Function.LoadDataCate(toolStripComboBox1.ComboBox, sql, "GrStockDetailId", "GrStockDetailLName"); //if(!Class.clsCash.IsPermissionId("P16")){ //toolStripButton3.Enabled = false; //} Class.btnControl s = new Class.btnControl(); s.BtnControl(textBox2, "Stock",stock); Class.btnControl d = new Class.btnControl(); d.BtnControl(textBox3, "Stock",stock); }
private void ProductionReqAdd_Load(object sender, EventArgs e) { dateTimePicker1.Value = Convert.ToDateTime(Class.DBConnString.clsDB.QueryExecuteScalarNonAlert("SELECT GETDATE()")); BtnBtnPrisonNameControlTxtPrisonName(); BtnBtnProductNameControlTxtPrisonName(); Class.btnControl btn = new Class.btnControl(); btn.BtnControl(textBox6, "Shipper"); //if (Lid != "" && Pid != "") { // LoadDataPlus(); //} //if (Lid == "" && Pid != "") { // LoadData(); // textBox3.Enabled = false; //} if (Pid != "") { LoadData(); textBox3.Enabled = false; } if (Class.clsCash.IsPermissionId("P11") == false) { button1.Enabled = false; } p = 1; }
private void TranferBrn_Load(object sender, EventArgs e) { Class.btnControl brn = new Class.btnControl(); brn.BtnControl(textBox1, "Branch"); }
private void ProductionTransferMoney_Load(object sender, EventArgs e) { Class.btnControl btnemp = new Class.btnControl(); btnemp.BtnControl(txtJ, "Employer"); InitColumnsHead(); InitColumnsItem(); LoadDataFirst(); }
void setFirstLoad() { tabControl1.TabPages.Remove(tabPage2); ///// DESTENATION string sqlDestination = "SELECT * FROM FINALDESTENATION"; Class.Function.LoadDataCate(comboBox2, sqlDestination, "FinalDestenationId", "FinalDestenationName"); string sqlLoading = "SELECT * FROM LOADING"; Class.Function.LoadDataCate(comboBox7, sqlLoading, "LoadingId", "LoadingName"); string sqlFeeder = "SELECT * FROM FEEDER"; Class.Function.LoadDataCate(comboBox8, sqlFeeder, "FeederId", "FeederName"); ///// สกุลเงิน string sqlCURRENCY = "SELECT SaleCurrencyId,SaleCurrencyName FROM CURRENCY WHERE SaleCurrencyId !='3'"; Class.Function.LoadDataCate(comboBox5, sqlCURRENCY, "SaleCurrencyId", "SaleCurrencyName"); Class.Function.LoadDataCate(comboBox4, sqlCURRENCY, "SaleCurrencyId", "SaleCurrencyName"); ///// ภาษี string sqlTax = "select * from Tax where tax_auto_id not in(5,6)"; Class.Function.LoadDataCate(comboBox3, sqlTax, "tax_auto_id", "tax_type"); ///// ลูกค้า Class.btnControl btcus = new Class.btnControl(); btcus.BtnControl(textBox13, "CustomerInv"); ////// id //textBox1.Text = saleInvHeadId(); Id = Class.Function.ReturnId("saleheadid", "sale_head").ToString(); ////// accountid Class.btnControl bk = new btnControl(); bk.BtnControl(textBox26, "TRCustomer2"); ////// bank string sqlBank = "SELECT BankId,BankName FROM Bank"; Class.Function.LoadDataCate(comboBox6, sqlBank, "BankId", "BankName"); string sqlreason = "SELECT ReTypeId,ReTypeName FROM RE_REASON_TYPE"; Class.Function.LoadDataCate(comboBox1, sqlreason, "ReTypeId", "ReTypeName"); }
void firstLoad() { //setcolname toolStripButton1.Text = toolStripButton1.Text + " " + Class.DBConnString.sDb; //set list event Class.Function.LoadDataCate(comboBox1, "select 0 AS id,'ทั้งหมด' AS list "+ "union all "+ "SELECT ROW_NUMBER() over(order by list),list FROM dbo.StockInOut GROUP BY list", "id", "list"); // set type customer or supplier Class.Function.LoadDataCate(comboBox2, "SELECT 1 as id,'ลูกค้า' as name UNION SELECT 2,'ผู้ขาย'","id","name"); btnc.BtnControl(textBox4, "Customer"); // main cate Class.Function.LoadDataCate(comboBox3, "select -1 as id,'ทั้งหมด' as name union all select maincateid,maincatename from maincate", "id", "name"); Class.Function.LoadDataCate(comboBox4, "select -1 as id,'ทั้งหมด' as name", "id", "name"); //set datepicker DataTable dt = Class.DBConnString.clsDB.QueryDataTable("SELECT min(stdate),max(stdate) FROM dbo.StockInOut"); dateTimePicker1.Value = Convert.ToDateTime(dt.Rows[0][0]); dateTimePicker2.Value = Convert.ToDateTime(dt.Rows[0][1]); //set text find Class.btnControl btn = new Class.btnControl(); btn.BtnControl(textBox5,"Shipper"); Class.btnControl btnp = new Class.btnControl(); btnp.BtnControl(textBox3, "Product"); // call fist disabled FistDisabled(); }
private void MetBack_Load(object sender, EventArgs e) { Class.btnControl btne = new Class.btnControl(); btne.BtnControl(txtEmployer, "Employer");//กำหนดรูปแบบปุ่มการใช้งานเพื่อเรียกใช้ฟังก์ชัน designfunction ข้อมูลเรือนจำ Class.btnControl btEmployer = new Class.btnControl(); btEmployer.BtnControl(txtEmployer2, "Employer");//เรียกใช้ฟังก์ชัน designfunction Class.btnControl btShip = new Class.btnControl(); btShip.BtnControl(txtShip, "Shipper");//เรียกใช้ฟังก์ชัน designfunction Class.btnControl btnProduct = new Class.btnControl(); btnProduct.BtnControl(txtProduct, "Product"); }
private void loadFirst() { /*ดึงหน้า form เริ่มต้นการใช้งาน*/ textBox1.Text = loadId(); Class.btnControl btnE = new Class.btnControl(); btnE.BtnControl(textBox3, "Employer");//เรียกใช้ฟังก์ชัน Designfunction ข้อมูลเรือนจำ Class.btnControl btnS = new Class.btnControl(); btnS.BtnControl(textBox6, "Shipper");//เรียกใช้ฟังก์ชัน Designfunction ข้อมูลขนส่ง dataGridView2.ColumnCount = 15;/*กำหนด column name และ headertext ของ datagridview */ dataGridView2.Columns[0].Name = "Id"; dataGridView2.Columns[0].HeaderText = "รหัสพาเลต"; dataGridView2.Columns[1].Name = "FmId"; dataGridView2.Columns[1].HeaderText = "รหัสสูตร"; dataGridView2.Columns[2].Name = "FmName"; dataGridView2.Columns[2].HeaderText = "ชื่อสูตร"; dataGridView2.Columns[2].Width = 200; dataGridView2.Columns[3].Name = "Pallet"; dataGridView2.Columns[3].HeaderText = "พาเลท"; dataGridView2.Columns[4].Name = "Quantity"; dataGridView2.Columns[4].HeaderText = "จำนวน"; dataGridView2.Columns[5].Name = "Unit"; dataGridView2.Columns[5].HeaderText = "หน่วย"; dataGridView2.Columns[6].Name = "PwId"; dataGridView2.Columns[6].HeaderText = "รหัสค่าจ้าง"; dataGridView2.Columns[7].Name = "PwN7"; dataGridView2.Columns[7].HeaderText = "หมายเลข7/น"; dataGridView2.Columns[8].Name = "PwOutSide"; dataGridView2.Columns[8].HeaderText = "ค่าจ้างนอก/น"; dataGridView2.Columns[9].Name = "PwPB"; dataGridView2.Columns[9].HeaderText = "ผบ/น"; dataGridView2.Columns[10].Name = "PwShip"; dataGridView2.Columns[10].HeaderText = "ขนส่ง/น"; dataGridView2.Columns[11].Name = "PwOther"; dataGridView2.Columns[11].HeaderText = "อื่นๆ/น"; dataGridView2.Columns[12].Name = "Total"; dataGridView2.Columns[12].HeaderText = "รวมทั้งสิ้น"; dataGridView2.Columns[13].Name = "Remark"; dataGridView2.Columns[13].HeaderText = "หมายเหตุ"; dataGridView2.Columns[14].Name = "cate"; dataGridView2.Columns[14].HeaderText = "ประเภท"; }
private void ProductionReqAdd_Load(object sender, EventArgs e) { var c = System.Threading.Thread.CurrentThread.CurrentCulture; dateTimePicker1.Value = Convert.ToDateTime(Class.DBConnString.clsDB.QueryExecuteScalarNonAlert("SELECT GETDATE()")); tableLayoutPanel5.Enabled = true; BtnBtnPrisonNameControlTxtPrisonName(); BtnBtnProductNameControlTxtPrisonName(); Class.btnControl btn = new Class.btnControl(); btn.BtnControl(textBox6, "Shipper");//เรียกใช้ฟังก์ชัน เลือกเรือนจำ SetEdit(); //if (Lid != "" && Pid != "") { // LoadDataPlus(); //} //if (Lid == "" && Pid != "") { // LoadData(); // textBox3.Enabled = false; //} if (Pid != "") { LoadData(); textBox3.Enabled = false; } if (Class.clsCash.IsPermissionId("P11") == false) { button1.Enabled = false; } p = 1; }
private void MainSalePos_Load(object sender, EventArgs e) { Class.btnControl btcus = new Class.btnControl();//กำหนดปุ่มการทำงาน btcus.BtnControl(textBox5, "Customer"); //end Class.btnControl btpd = new Class.btnControl();//กำหนดปุ่มการทำงาน btpd.BtnControl(textBox4, "Product"); //end Class.Function.LoadDataCate(comboBox1, "select 0 as saleheadstatusid,'ทั้งหมด' as saleheadstatusname union all select * from SALEHEADSTATUS where saleheadstatusid not in(3) ", "saleheadstatusid", "saleheadstatusname");//สถานะใบขายเพื่อการค้นหา comboBox2.Items.Add(new ComboboxItem { Text = "ทั้งหมด", Value = 0 }); comboBox2.Items.Add(new ComboboxItem { Text = "1000", Value = 1000 }); comboBox2.Items.Add(new ComboboxItem { Text = "500", Value = 500 }); comboBox2.Items.Add(new ComboboxItem { Text = "100", Value = 100 }); comboBox2.SelectedIndex = 0; //การกำหนดสิทธิ์เข้าใช้งานโปรแกรม ให้ใช้ได้เฉพาะฐานข้อมูล if (Class.DBConnString.sDb != "KTC") { ตางประเทศToolStripMenuItem.Visible = false; toolStripButton6.Visible = false; toolStripButton9.Visible = false; iNVOICESAHADEEToolStripMenuItem.Visible = false; iNVOICEORIGINALToolStripMenuItem.Visible = false; pACKINGLISTORIGINALToolStripMenuItem.Visible = false; pACKINGREPORTToolStripMenuItem.Visible = false; } //end //กำหนดสิทธิ์ในการเข้าใช้งานของพนักงาน if (clsCash.IsPermissionId("P31") == false) { toolStripButton2.Enabled = false; toolStripButton3.Enabled = false; } else { toolStripButton2.Enabled = true; toolStripButton3.Enabled = true; } //end }
/*กำหนด form เริ่มต้น*/ void setFirstLoad() { ///// รหัสเบิก //string sqlDRAW = "SELECT DrawId,DrawName FROM DRAW"; //Class.Function.LoadDataCate(comboBox1, sqlDRAW, "DrawId", "DrawName"); //if (Class.DBConnString.sDb == "7CSK") { comboBox1.SelectedIndex = 11; } //else if (Class.DBConnString.sDb == "SHOP") { comboBox1.SelectedIndex = 7; } //else if (Class.DBConnString.sDb == "KTC") { comboBox1.SelectedIndex = 2; } //else { comboBox1.SelectedIndex = 11; } ///// ประเภทการขาย //string sqlSaleType = "SELECT SaleHeadSaleTypeId,SaleHeadSaleTypeName FROM SALEHEADSALETYPE"; //Class.Function.LoadDataCate(comboBox2, sqlSaleType, "SaleHeadSaleTypeId", "SaleHeadSaleTypeName"); ///// สกุลเงิน //string sqlCURRENCY = "SELECT SaleCurrencyId,SaleCurrencyName FROM CURRENCY"; //Class.Function.LoadDataCate(comboBox5, sqlCURRENCY, "SaleCurrencyId", "SaleCurrencyName"); //Class.Function.LoadDataCate(comboBox4, sqlCURRENCY, "SaleCurrencyId", "SaleCurrencyName"); ///// ภาษี string sqlTax = "select * from Tax where tax_auto_id not in(5,6)"; Class.Function.LoadDataCate(comboBox3, sqlTax, "tax_auto_id", "tax_type"); ///// ลูกค้า Class.btnControl btcus = new Class.btnControl(); btcus.BtnControl(textBox13, "Customer"); ////// accountid Class.btnControl bk = new btnControl(); bk.BtnControl(textBox26, "TRCustomer2"); ////// bank string sqlBank = "SELECT BankId,BankName FROM Bank"; Class.Function.LoadDataCate(comboBox6, sqlBank, "BankId", "BankName"); }