File manager - Edit - G:/PleskVhosts/indiaminerals.in/tlt.INFOFIXDEVELOPERS.COM/admin/Printdoc/WebForm1.aspx.cs
Back
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WebApp.LIBS; using Business; namespace WebApp.admin.Printdoc { public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrWhiteSpace(Request.QueryString["fromdate"]) && !string.IsNullOrWhiteSpace(Request.QueryString["todate"])) { int CompId=SiteSession.CompnayId; var fdate = Common.DateConvertMultimatch(Request.QueryString["fromdate"].ToString()); var tdate = Common.DateConvertMultimatch(Request.QueryString["todate"].ToString()); var obj = Global.Context.Sales.AsEnumerable().Where(s => s.Date.Value >= fdate && s.Date.Value <= tdate && s.CompnayId == CompId).ToList(); List<DataCheck> DataBind = new List<DataCheck>(); string Trdata = ""; obj.ForEach(p => { int xx = 1; Trdata = Trdata + "<tr><td style='text-align:left;padding-left:5px;'>No." + p.InvoiceNo + " </td><td colspan=2 style='text-align:left;padding-left:5px;'> दिनांक:" + p.Date.Value.ToString("dd/MM/yyy") + " <span style='text-align:right;padding-left:5px;'>नाम:" + p.Customer.CustomerName + "</span> </td></tr>"; Trdata = Trdata +"<tr><td>सं.</td><td>सामान</td><td style='width:70px;'>मात्रा.</td></tr>"; p.SaleItems.AsEnumerable().ToList().ForEach(x=> { Trdata = Trdata + "<tr><td>"+ (xx++ ).ToString()+ "</td><td>"+ x.Brand.BrandName+ " " + x.Weight.WeightName + " Remark:" + x.Weightkg + "</td><td>" + x.Quantity.Value.ToString()+"</td></tr> <tr>"; }); Trdata = Trdata + "<tr><td colspan='3' style='text-align:right;padding-left:5px;'><b>" + p.SaleItems.AsEnumerable().Sum(pt => pt.Quantity).Value.ToString() + "<b/></td><tr><td colspan='3'><tr><td colspan='3'> </td><tr>"; DataBind.Add(( new DataCheck() { Data = Trdata, Number = Common.ConvertInt(p.InvoiceNo) })); Trdata = ""; }); var SaleRatess = Global.Context.SaleRates.AsEnumerable().Where(s => s.Date.Value >= fdate && s.Date.Value <= tdate && s.CompnayId == CompId).ToList(); Trdata = ""; SaleRatess.ForEach(p => { int xx = 1; Trdata = Trdata + "<tr><td style='text-align:left;padding-left:5px;'>No." + p.InvoiceNo + " </td><td colspan=2 style='text-align:left;padding-left:5px;'> दिनांक:" + p.Date.Value.ToString("dd/MM/yyy") + " <span style='text-align:right;padding-left:5px;'>नाम:" + p.Customer.CustomerName + "</span> </td></tr>"; Trdata = Trdata + "<tr><td>सं.</td><td>सामान</td><td style='width:70px;'>मात्रा.</td></tr>"; p.SaleRateItems.AsEnumerable().ToList().ForEach(x => { Trdata = Trdata + "<tr><td>" + (xx++).ToString() + "</td><td>" + x.Brand.BrandName + " " + x.Weight.WeightName + " Remark:"+x.Weightkg+" ("+ x.Quantity.Value.ToString() + "*"+x.Rate.Value.ToString()+" Rs.="+x.Amount.Value.ToString()+") </td><td>" + x.Quantity.Value.ToString() + "</td></tr> <tr>"; }); Trdata = Trdata + "<tr><td colspan='3' style='text-align:right;padding-left:5px;'>(<b>Total Amount" + p.SaleRateItems.AsEnumerable().Sum(pt => pt.Amount).Value.ToString() + "<b/>) ----- Qty<b>" + p.SaleRateItems.AsEnumerable().Sum(pt => pt.Quantity).Value.ToString() + "<b/></td><tr><td colspan='3'><tr><td colspan='3'> </td><tr>"; DataBind.Add((new DataCheck() { Data = Trdata, Number = Common.ConvertInt(p.InvoiceNo) })); Trdata = ""; }); data.Text =string.Join(" ", DataBind.OrderBy(p=> p.Number).Select(p=> p.Data).ToArray()); } } } } public class DataCheck { public int Number { get; set; } public string Data { get; set; } }
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.07 |
proxy
|
phpinfo
|
Settings