private void button6_Click(object sender, EventArgs e) { //Product prd = new Product(); //DialogResult kq1 = MessageBox.Show("Xóa toàn bộ Product ? ", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); //bool kq; string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); //switch (kq1) //{ // case DialogResult.None: // break; // case DialogResult.Yes: // DialogResult kq2 = MessageBox.Show("Yes là xóa toàn bộ data product, are you sure ? ", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); // // this.uploadCustomerToolStripMenuItem.Enabled = false; // // this.reportsToolStripMenuItem.Enabled = false; // if (kq2 == DialogResult.Yes) // { // prd.productlistinput(); // VInputchange inputcdata2 = new VInputchange("", "LIST MASTER DATA PRODUCTS ", dc, "tbl_kaProductlist", "tbl_kaProductlist", typeff, typeff, "id", "id", ""); // inputcdata2.Show(); // } // break; // case DialogResult.Cancel: // break; // case DialogResult.Abort: // break; // case DialogResult.Retry: // break; // case DialogResult.Ignore: // break; // case DialogResult.OK: // break; // case DialogResult.No: var typeff = typeof(tbl_kaProductlist); VInputchange inputcdata = new VInputchange("", "LIST MASTER DATA PRODUCTS ", dc, "tbl_kaProductlist", "tbl_kaProductlist", typeff, typeff, "id", "id", ""); inputcdata.Show(); // break; //default: // break; // } }
private void button7_Click(object sender, EventArgs e) { programlist proglist = new programlist(); // DialogResult kq1 = MessageBox.Show("Xóa toàn bộ Program ? ", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); // bool kq; string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var typeff = typeof(tbl_kaprogramlist); //switch (kq1) //{ // case DialogResult.None: // break; // case DialogResult.Yes: // // this.uploadCustomerToolStripMenuItem.Enabled = false; // // this.reportsToolStripMenuItem.Enabled = false; // proglist.input(); VInputchange inputcdata = new VInputchange("", "LIST PROGRAM LIST ", dc, "tbl_kaprogramlist", "tbl_kaprogramlist", typeff, typeff, "id", "id", ""); inputcdata.Show(); // break; // case DialogResult.Cancel: // break; // case DialogResult.Abort: // break; // case DialogResult.Retry: // break; // case DialogResult.Ignore: // break; // case DialogResult.OK: // break; // case DialogResult.No: //inputcdata = new VInputchange("", "LIST PROGRAM LIST ", dc, "tbl_kaprogramlist", "tbl_kaprogramlist", typeff, typeff, "id", "id", ""); //inputcdata.Show(); // break; // default: // break; //} }
public Seachcode(VInputchange Fromeditable, string tablename) { // return false; InitializeComponent(); this.Fromeditable = Fromeditable; this.tablename = tablename; }
private void button1_Click_1(object sender, EventArgs e) { string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); // tbl_kaPrcingreportsTem var typeff = typeof(tbl_KAlistpricefunction); VInputchange inputcdata = new VInputchange("", "LIST CONDITION TYPE TO CONVER FUCTION AND PROMOTION ", dc, "tbl_KAlistpricefunction", "tbl_KAlistpricefunction", typeff, typeff, "id", "id", ""); inputcdata.Show(); }
private void button2_Click(object sender, EventArgs e) { string connection_string = Utils.getConnectionstr(); string urs = Utils.getusername(); // var db = new LinqtoSQLDataContext(connection_string); LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string); // tbl_karegion var typeff = typeof(Tka_RegionRight); VInputchange inputcdata = new VInputchange("", "LIST EDIT REGION VIEW RIGHT", db, "Tka_RegionRight", "Tka_RegionRight", typeff, typeff, "id", "id", ""); inputcdata.Show(); }
private void button17_Click_1(object sender, EventArgs e) { string connection_string = Utils.getConnectionstr(); string urs = Utils.getusername(); // var db = new LinqtoSQLDataContext(connection_string); LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string); // tbl_karegion var typeff = typeof(Tka_RightContracttypeview); VInputchange inputcdata = new VInputchange("", "LIST CONTRACT TYPE VIEW RIGHT", db, "Tka_RightContracttypeview", "Tka_RightContracttypeview", typeff, typeff, "id", "id", ""); inputcdata.Show(); }
private void button14_Click(object sender, EventArgs e) { string connection_string = Utils.getConnectionstr(); //string urs = Utils.getusername(); // var db = new LinqtoSQLDataContext(connection_string); LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string); // tbl_karegion var typeff = typeof(tbl_kaChannel); VInputchange inputcdata = new VInputchange("", "LIST CHANNEL", db, "tbl_kaChannel", "tbl_kaChannel", typeff, typeff, "id", "id", ""); inputcdata.Show(); }
private void button15_Click(object sender, EventArgs e) { kaPriodmake makepriod = new kaPriodmake(); makepriod.ShowDialog(); string connection_string = Utils.getConnectionstr(); // string urs = Utils.getusername(); // var db = new LinqtoSQLDataContext(connection_string); LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string); // tbl_karegion var typeff = typeof(tbl_Kapriod); VInputchange inputcdata = new VInputchange("", "LIST PRIOD", db, "tbl_Kapriod", "tbl_Kapriod", typeff, typeff, "id", "id", ""); inputcdata.Show(); }
private void button9_Click(object sender, EventArgs e) { string connection_string = Utils.getConnectionstr(); string urs = Utils.getusername(); // var db = new LinqtoSQLDataContext(connection_string); LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string); // tbl_karegion var typeff = typeof(tbl_karegion); //string sql =" IF OBJECT_ID(N'tbl_kaPrdgrpTMP" + urs + @"', N'U') IS NOT NULL // DROP TABLE tbl_kaPrdgrpTMP" + urs; //db.ExecuteCommand(sql); //db.SubmitChanges(); //sql ="CREATE TABLE tbl_kaPrdgrpTMP" + urs + @" // ( [PrdGrp] [nvarchar](255) NULL, // [ProductGroup] [nvarchar](255) NULL, // [WStatement] [nvarchar](255) NULL, // [id] [int] IDENTITY(1,1) NOT NULL) // "; //db.ExecuteCommand(sql); //db.SubmitChanges(); VInputchange inputcdata = new VInputchange("", "LIST REGION", db, "tbl_karegion", "tbl_karegion", typeff, typeff, "id", "id", ""); inputcdata.Show(); }
private void button2_Click(object sender, EventArgs e) { string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); dc.CommandTimeout = 0; // select tblEDLP; string username = Utils.getusername(); // tbl_Kasa dc.ExecuteCommand("DELETE FROM tbl_kasalesTemp where tbl_kasalesTemp.Username = '******' or tbl_kasalesTemp.Username is null or tbl_kasalesTemp.Priod is null"); // dc.tblFBL5Nnewthisperiods.DeleteAllOnSubmit(rsthisperiod); dc.SubmitChanges(); //tbl_kasalesTemp p = new tbl_kasalesTemp(); //p.Priod dc.ExecuteCommand("DELETE FROM tbl_KaCustomertemp where tbl_KaCustomertemp.Username ='******' or tbl_KaCustomertemp.Username is null"); dc.SubmitChanges(); FormCollection fc = System.Windows.Forms.Application.OpenForms; bool kq = false; foreach (Form frm in fc) { if (frm.Text == "kaPriodpicker") { kq = true; frm.Focus(); } } if (!kq) { View.kaPriodpicker kaPriodpicker = new View.kaPriodpicker(); // Datepick kaPriodpicker.ShowDialog(); string priod = kaPriodpicker.priod; DateTime fromdate = kaPriodpicker.fromdate; DateTime todate = kaPriodpicker.todate; bool chon = kaPriodpicker.kq; if (chon) { if (priod != "" && fromdate != todate && priod != null) { Model.Salesinput_ctrl slmodel = new Model.Salesinput_ctrl(); slmodel.edlpinput(); List <string> condtypelist = new List <string>(); condtypelist.Add("YPR0"); condtypelist.Add("YPRD"); condtypelist.Add("NETP"); #region // giới hạn doc type chỉ chấp nhận 3 loại YPR0,YPRD,NETP var rsdoc = (from tbl_kasalesTemp in dc.tbl_kasalesTemps where tbl_kasalesTemp.Username == username && !condtypelist.Contains(tbl_kasalesTemp.Cond_Type) select tbl_kasalesTemp).Take(10); if (rsdoc.Count() > 0) { Viewtable viewtbl2 = new Viewtable(rsdoc, dc, "kHÔNG UPLOAD ĐƯỢC, CÓ CÁC DOC TYPE KHÔNG ĐÚNG KIỂU : YPR0, YPRD, NETP ", 3);// view code 1 la can viet them lenh viewtbl2.Show(); viewtbl2.Focus(); return; } #endregion #region // list doc da post var rsdoc3 = (from tbl_kasalesTemp in dc.tbl_kasalesTemps where tbl_kasalesTemp.Username == username && ((tbl_kasalesTemp.Invoice_Date <fromdate || tbl_kasalesTemp.Invoice_Date> todate)) select tbl_kasalesTemp).Take(10); if (rsdoc3.Count() > 0) { Viewtable viewtbl2 = new Viewtable(rsdoc3, dc, "kHÔNG UPLOAD ĐƯỢC, CÓ CÁC DOC DATE KHÔNG THUỘC PRIOD: " + priod, 3);// view code 1 la can viet them lenh viewtbl2.Show(); viewtbl2.Focus(); return; } #endregion #region // productnew var da = new LinqtoSQLDataContext(connection_string); da.ExecuteCommand("DELETE FROM tbl_kaProductlistemp where tbl_kaProductlistemp.Username ='******'"); da.SubmitChanges(); var rscustemp = from tbl_kasalesTemp in dc.tbl_kasalesTemps where !(from tbl_kaProductlist in dc.tbl_kaProductlists select tbl_kaProductlist.MatNumber).Contains(tbl_kasalesTemp.Mat_Number) && tbl_kasalesTemp.Mat_Number != null group tbl_kasalesTemp by tbl_kasalesTemp.Mat_Number into g select new { MatNumber = g.Key, MatText = g.Select(gg => gg.Mat_Text).FirstOrDefault(), UoM = g.Select(gg => gg.UoM).FirstOrDefault(), Pcrate = 0, Ucrate = 0 }; if (rscustemp.Count() > 0) { // var db = new LinqtoSQLDataContext(connection_string); foreach (var item in rscustemp) { tbl_kaProductlistemp prduct = new tbl_kaProductlistemp(); prduct.MatNumber = item.MatNumber; prduct.MatText = item.MatText; prduct.UoM = item.UoM; prduct.Pcrate = 0; prduct.Ucrate = 0; prduct.Username = username; if (prduct.MatNumber != null) { da.tbl_kaProductlistemps.InsertOnSubmit(prduct); da.SubmitChanges(); } } var typeffmain = typeof(tbl_kaProductlist); var typeffsub = typeof(tbl_kaProductlistemp); VInputchange inputcdata = new VInputchange("PRODUCT LIST", "LIST PRODUCT NOT IN MASTER DATAPRODUCT", dc, "tbl_kaProductlist", "tbl_kaProductlistemp", typeffmain, typeffsub, "id", "id", username); inputcdata.Show(); inputcdata.Focus(); return; } #endregion product new //-------------------- #region// update pc, uc SqlConnection conn2 = null; SqlDataReader rdr1 = null; string destConnString = Utils.getConnectionstr(); try { conn2 = new SqlConnection(destConnString); conn2.Open(); SqlCommand cmd1 = new SqlCommand("KAupdateSalePC_UCtemptable", conn2); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.Add("@priod", SqlDbType.VarChar).Value = priod; cmd1.CommandTimeout = 0; rdr1 = cmd1.ExecuteReader(); // rdr1 = cmd1.ExecuteReader(); } finally { if (conn2 != null) { conn2.Close(); } if (rdr1 != null) { rdr1.Close(); } } // MessageBox.Show("ok", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); #endregion update pc, uc #region // view sales volume var rs = from tbl_kasalesTemp in dc.tbl_kasalesTemps where tbl_kasalesTemp.Username == username && tbl_kasalesTemp.Priod == priod //&& tbl_kasalesTemp.Username == username select new { tbl_kasalesTemp.Priod, tbl_kasalesTemp.Sold_to, tbl_kasalesTemp.Sales_Org, tbl_kasalesTemp.Sales_District, tbl_kasalesTemp.Sales_District_desc, tbl_kasalesTemp.Cust_Name, tbl_kasalesTemp.Outbound_Delivery, tbl_kasalesTemp.Delivery_Date, tbl_kasalesTemp.Invoice_Doc_Nr, tbl_kasalesTemp.Invoice_Date, tbl_kasalesTemp.Key_Acc_Nr, tbl_kasalesTemp.Cond_Type, tbl_kasalesTemp.Mat_Group, tbl_kasalesTemp.Mat_Group_Text, tbl_kasalesTemp.Mat_Number, tbl_kasalesTemp.Mat_Text, tbl_kasalesTemp.Currency, PCs = tbl_kasalesTemp.EC, tbl_kasalesTemp.UoM, tbl_kasalesTemp.EmptyCountValue, tbl_kasalesTemp.GSR, tbl_kasalesTemp.Litter, tbl_kasalesTemp.NETP, tbl_kasalesTemp.NSR, EC = tbl_kasalesTemp.PC, tbl_kasalesTemp.UC, tbl_kasalesTemp.Username, tbl_kasalesTemp.id, }; if (rs.Count() > 0) { Viewtable viewtbl = new Viewtable(rs, dc, "SALES DATA PRIOD: " + priod, 1);// view code 1 la can viet them lenh viewtbl.Show(); viewtbl.Focus(); } #endregion } } } }
private void button16_Click(object sender, EventArgs e) { string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var typeff = typeof(tbl_kacontractsdatadetail); VInputchange inputcdata = new VInputchange("", "LIST DATA CONTRACTS DETAIL ", dc, "tbl_kacontractsdatadetail", "tbl_kacontractsdatadetail", typeff, typeff, "id", "id", ""); inputcdata.Show(); //#region //Contract ctract = new Contract(); //DialogResult kq1 = MessageBox.Show("Delete all begin contract detail ? ", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); //// bool kq; //string connection_string = Utils.getConnectionstr(); //LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); //var typeff = typeof(tbl_kacontractbegindatadetail); //switch (kq1) //{ // case DialogResult.None: // break; // case DialogResult.Yes: // DialogResult kq2 = MessageBox.Show("YEs là xóa dữ liệu begin Contract, bạn định xóa ? ", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); // if (kq2 == DialogResult.Yes) // { // Contract Rm = new Contract(); // bool kq = Rm.deleteallcontractbegindetail(); // } // ctract.inputcontractdetail(); // //VInputchange inputcdata = new VInputchange("", "LIST DATA CONTRACTS DETAIL ", dc, "tbl_kacontractmasterdatadetail", "tbl_kacontractmasterdatadetail", typeff, typeff, "id", "id", ""); // //inputcdata.Show(); // var rscustemp2 = from tbl_kacontractmasterdatadetail in dc.tbl_kacontractbegindatadetails // select tbl_kacontractmasterdatadetail; // Viewtable viewtbl = new Viewtable(rscustemp2, dc, "LIST DATA CONTRACTS DETAIL", 3);// view code 1 la can viet them lenh // viewtbl.Show(); // break; // case DialogResult.Cancel: // break; // case DialogResult.Abort: // break; // case DialogResult.Retry: // break; // case DialogResult.Ignore: // break; // case DialogResult.OK: // break; // case DialogResult.No: // ctract.inputcontractdetail(); // rscustemp2 = from tbl_kacontractmasterdatadetail in dc.tbl_kacontractbegindatadetails // select tbl_kacontractmasterdatadetail; // viewtbl = new Viewtable(rscustemp2, dc, "LIST DATA CONTRACTS DETAIL", 3);// view code 1 la can viet them lenh // viewtbl.Show(); // break; // default: // break; //} //#endregion }
private void button1_Click(object sender, EventArgs e) { customerinput_ctrl md = new customerinput_ctrl(); // DialogResult kq1 = MessageBox.Show("Xóa toàn bộ dataCustomer ? ", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); // bool kq; string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var typeffmain = typeof(tbl_KaCustomer); var typeffsub = typeof(tbl_KaCustomer); //switch (kq1) //{ // case DialogResult.None: // break; // case DialogResult.Yes: // // this.uploadCustomerToolStripMenuItem.Enabled = false; //DialogResult kq2 = MessageBox.Show("YEs là xóa dữ liệu customer, bạn định xóa ? ", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); //if (kq2 == DialogResult.Yes) //{ // md.customerinput(); // VInputchange inputcdata1 = new VInputchange("", "LIST MASTER DATA CUSTOMER ", dc, "tbl_KaCustomer", "tbl_KaCustomer", typeffmain, typeffsub, "id", "id", ""); // inputcdata1.Show(); //} //else //{ // return; //} // inputcdata.show // inputcdata.MaximumSize = true; // break; //case DialogResult.Cancel: // break; //case DialogResult.Abort: // break; //case DialogResult.Retry: // break; //case DialogResult.Ignore: // break; //case DialogResult.OK: // break; //case DialogResult.No: // var typeffmain = typeof(tbl_KaCustomer); // var typeffsub = typeof(tbl_KaCustomer); VInputchange inputcdata = new VInputchange("", "LIST MASTER DATA CUSTOMER ", dc, "tbl_KaCustomer", "tbl_KaCustomer", typeffmain, typeffsub, "id", "id", ""); inputcdata.Show(); // break; //default: // break; // } }