private void bt_exporttoex_Click(object sender, EventArgs e) { Control_ac ctrex = new Control_ac(); //string connection_string = Utils.getConnectionstr(); //LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); //string urs = Utils.getusername(); //var rs = from pp in dc.tbl_MKT_Stockends // where pp.Store_code == this.storelocation // select new // { // Store = pp.Store_code, // SAP_CODE = pp.SAP_CODE, // ITEM_Code = pp.ITEM_Code, // Material_name = pp.MATERIAL, // Description = pp.Description, // UNIT = pp.UNIT, // // END_STOCK = pp.END_STOCK, // // Real_issue = 0, // }; ctrex.exportexceldatagridtofile(this.rs, this.datacontext, "STOCK COUNT FOR APROVAL " + dateupdate.Value.ToShortDateString()); }
private void bt_exporttoex_Click(object sender, EventArgs e) { Control_ac ctrex = new Control_ac(); ctrex.exportexceldatagridtofile(this.rs, this.dc, "Detail list of Ordered Gate pass"); }
private void button1_Click(object sender, EventArgs e) { Control_ac ctrex = new Control_ac(); string connection_string = Utils.getConnectionstr(); string username = Utils.getusername(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); var listupdate1 = from p in dc.tbl_tempmastercontractmasscreates where p.Username == username select p; ctrex.exportExceldatagridtofile(listupdate1, dc, "DANH SÁCH HỢP ĐỒNG "); }
private void bt_exporttoex_Click(object sender, EventArgs e) { Control_ac ctrex = new Control_ac(); string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); string urs = Utils.getusername(); var rs = from pp in dc.tbl_MKT_Stockends where pp.Store_code == this.storelocation select new { Store = pp.Store_code, SAP_CODE = pp.SAP_CODE, ITEM_Code = pp.ITEM_Code, Material_name = pp.MATERIAL, Description = pp.Description, UNIT = pp.UNIT, // END_STOCK = pp.END_STOCK, // Real_issue = 0, }; ctrex.exportexceldatagridtofile(rs, dc, "STOCK COUNT " + datecreated.Value.ToShortDateString()); }
private void button1_Click(object sender, EventArgs e) { if (this.tblnamesub == "tbl_kaProductlistemp") { var rs = from tbl_kaProductlistemp in db.tbl_kaProductlistemps select tbl_kaProductlistemp; this.rs = rs; } if (this.tblnamesub == "tbl_KaCustomertemp") { var rs = from tblCustomerTmp in db.tbl_KaCustomertemps select tblCustomerTmp; this.rs = rs; } //if (this.tblnamesub == "tblFBL5beginbalaceTemp") //{ // var rs = from tblFBL5beginbalaceTemp in db.tbl_be // select tblFBL5beginbalaceTemp; // this.rs = rs; //} //if (this.tblnamesub == "tbl_kaCustomerGroupTemp") //{ // var rs = from tbl_kaCustomerGroupTemp in db.tbl_kaCustomerGroupTemps // select tbl_kaCustomerGroupTemp; // this.rs = rs; //} //if (this.tblnamesub == "tbl_Comboundtemp") //{ // var rs = from tbl_Comboundtemp in db.tbl_Comboundtemps // select tbl_Comboundtemp; // this.rs = rs; //} if (this.tblnamesub == "tbl_KaCustomer") { var rs = from tbl_KaCustomer in db.tbl_KaCustomers select tbl_KaCustomer; this.rs = rs; } if (this.tblnamesub == "tbl_kaProductlist") { var rs = from tbl_kaProductlist in db.tbl_kaProductlists select tbl_kaProductlist; this.rs = rs; } if (this.tblnamesub == "tbl_kacontractbegindata") { var rs = from tblFBL5beginbalace in db.tbl_kacontractbegindatas select tblFBL5beginbalace; this.rs = rs; } if (this.rs != null) { Control_ac ctrex = new Control_ac(); ctrex.exportExceldatagridtofile(this.rs, this.db, this.Text); } //else //{ //} }
private void button1_Click(object sender, EventArgs e) { string connection_string = Utils.getConnectionstr(); LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); LinqtoSQLDataContext db = new LinqtoSQLDataContext(connection_string); LinqtoSQLDataContext da = new LinqtoSQLDataContext(connection_string); if (this.txt_batchno.Text == "") { this.txt_batchno.Text = "0"; } if (Utils.IsValidnumber(this.txt_batchno.Text) == false) { MessageBox.Show("Please check Batch No !", "Thông báo !", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } int Batchno = int.Parse(this.txt_batchno.Text); #region delete DETAIL AND GRUOP RPT BY USER string username = Utils.getusername(); // string connection_string = Utils.getConnectionstr(); // LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string); string sqltext = "DELETE FROM tbl_KAdetailprogrRpt WHERE tbl_KAdetailprogrRpt.Username = '******'"; dc.ExecuteCommand(sqltext); dc.SubmitChanges(); sqltext = "DELETE FROM tbl_KapaymentrequestRpt WHERE tbl_KapaymentrequestRpt.Username = '******'"; dc.ExecuteCommand(sqltext); dc.SubmitChanges(); sqltext = "DELETE FROM tbl_KapaymentrequestRpt WHERE tbl_KapaymentrequestRpt.Username = '******'"; dc.ExecuteCommand(sqltext); dc.SubmitChanges(); #endregion #region input detail request payment tbl_KAdetailprogrRpt detailrpt2 = new tbl_KAdetailprogrRpt(); //total line detailrpt2.Balance = 0; detailrpt2.BalanceAftApproval = 0; detailrpt2.Paid = 0; detailrpt2.PaymentRequest = 0; detailrpt2.Sponsorship = 0; detailrpt2.Programe = "Total"; detailrpt2.Username = username; var rss1 = from tbl_kaprogramlist in dc.tbl_kaprogramlists where tbl_kaprogramlist.Code != "DIS" select tbl_kaprogramlist; foreach (var item in rss1) { tbl_KAdetailprogrRpt detailrpt = new tbl_KAdetailprogrRpt(); //detail line detailrpt.Programe = item.Name; detailrpt.Username = username; detailrpt.Remarks = (from tbl_kacontractsdatadetail in dc.tbl_kacontractsdatadetails where tbl_kacontractsdatadetail.PayType.Trim() == item.Code.Trim() && tbl_kacontractsdatadetail.ContractNo == contractno && tbl_kacontractsdatadetail.PayID == payiD && tbl_kacontractsdatadetail.PayType != "DIS" select tbl_kacontractsdatadetail.Remark).FirstOrDefault(); var totaldetailrs = (from tbl_kacontractsdatadetail in db.tbl_kacontractsdatadetails where tbl_kacontractsdatadetail.PayType == item.Code && tbl_kacontractsdatadetail.ContractNo.Trim() == contractno.Trim() group tbl_kacontractsdatadetail by tbl_kacontractsdatadetail.PayType into g select new { PayType = g.Key, Paid = g.Sum(gg => gg.PaidAmt).GetValueOrDefault(0), Sponsorship = g.Sum(gg => gg.SponsoredTotal).GetValueOrDefault(0), }).FirstOrDefault(); if (totaldetailrs != null) { detailrpt.Paid = totaldetailrs.Paid; detailrpt.Sponsorship = totaldetailrs.Sponsorship; detailrpt.Balance = detailrpt.Sponsorship - detailrpt.Paid; detailrpt.PaymentRequest = (from tbl_kacontractsdetailpayment in da.tbl_kacontractsdetailpayments where tbl_kacontractsdetailpayment.BatchNo == Batchno && tbl_kacontractsdetailpayment.ContractNo == contractno && tbl_kacontractsdetailpayment.PayType == item.Code && tbl_kacontractsdetailpayment.DoneOn == null select tbl_kacontractsdetailpayment.PaidRequestAmt).Sum().GetValueOrDefault(0); detailrpt.BalanceAftApproval = detailrpt.Balance - detailrpt.PaymentRequest; } else { detailrpt.PaymentRequest = 0; detailrpt.Paid = 0; detailrpt.Sponsorship = 0; detailrpt.Balance = 0; detailrpt.BalanceAftApproval = 0; } detailrpt2.Balance = detailrpt2.Balance + detailrpt.Balance; detailrpt2.BalanceAftApproval = detailrpt2.BalanceAftApproval + detailrpt.BalanceAftApproval; detailrpt2.Paid = detailrpt2.Paid + detailrpt.Paid; detailrpt2.PaymentRequest = detailrpt2.PaymentRequest + detailrpt.PaymentRequest; detailrpt2.Sponsorship = detailrpt2.Sponsorship + detailrpt.Sponsorship; dc.tbl_KAdetailprogrRpts.InsertOnSubmit(detailrpt); dc.SubmitChanges(); } dc.tbl_KAdetailprogrRpts.InsertOnSubmit(detailrpt2); dc.SubmitChanges(); #endregion #region MAKE master rpt var itemmasterKA = (from tbl_kacontractdata in dc.tbl_kacontractdatas where tbl_kacontractdata.ContractNo == contractno select tbl_kacontractdata).FirstOrDefault(); if (itemmasterKA != null) { tbl_KapaymentrequestRpt requestmaster = new tbl_KapaymentrequestRpt(); requestmaster.ContractNo = itemmasterKA.ContractNo; requestmaster.Username = username; // requestmaster.AchvRevenue // requestmaster.address = itemmasterKA.a requestmaster.Annualvolume = itemmasterKA.AnnualVolume; requestmaster.Channel = itemmasterKA.Channel; requestmaster.CityProvince = itemmasterKA.Province; // requestmaster.Colddrinks requestmaster.Committedvol = itemmasterKA.VolComm; // requestmaster.ContractNo requestmaster.ContractType = itemmasterKA.ConType; // requestmaster.Costpercase requestmaster.Creditlimit = itemmasterKA.CreditLimit; requestmaster.Creditterm = itemmasterKA.CreditTerm; requestmaster.Currency = itemmasterKA.Currency; requestmaster.Customercode = itemmasterKA.Customer; requestmaster.Deliveredby = itemmasterKA.DeliveredBy; // requestmaster.Discount requestmaster.District = itemmasterKA.District; requestmaster.EffectiveDate = itemmasterKA.EffDate; requestmaster.ExpireDate = itemmasterKA.EftDate; requestmaster.ExtendDate = itemmasterKA.ExtDate; // requestmaster.Fundspercent requestmaster.Note = txt_note.Text; // requestmaster.ProductGroup = itemmasterKA.PrdGrp; requestmaster.Representative = itemmasterKA.Representative; requestmaster.SalesOrg = itemmasterKA.SalesOrg; requestmaster.Street = itemmasterKA.HouseNo; // requestmaster.SupportCase requestmaster.TermYear = (itemmasterKA.EftDate.Value.Year - itemmasterKA.EffDate.Value.Year); requestmaster.TradeName = itemmasterKA.Fullname; requestmaster.ReferrenceDoc = Batchno.ToString(); //requestmaster.Username requestmaster.AchievedVolPCs = itemmasterKA.PCVolAched; requestmaster.NSRcommit = itemmasterKA.NSRComm; // hiện nsa co,,it requestmaster.AchvRevenue = itemmasterKA.NSRAched; if (itemmasterKA.VolComm > 0 && itemmasterKA.VolComm != null && itemmasterKA.PCVolAched != null) { requestmaster.Achievedpercent = ((itemmasterKA.PCVolAched) / itemmasterKA.VolComm); } dc.tbl_KapaymentrequestRpts.InsertOnSubmit(requestmaster); dc.SubmitChanges(); } //requestmaster.Vendor #endregion #region view reports payment request Control_ac ctrac = new Control_ac(); var rs1 = ctrac.KArptdataset1(dc); var rs2 = ctrac.KArptdataset2(dc); if (rs1 != null && rs2 != null) { Utils ut = new Utils(); var dataset1 = ut.ToDataTable(dc, rs1); var dataset2 = ut.ToDataTable(dc, rs2); Reportsview rpt = new Reportsview(dataset1, dataset2, "PaymentRequest.rdlc", Batchno, contractno, formcreatCtract); rpt.ShowDialog(); } #endregion view reports payment request // }