File manager - Edit - G:/PleskVhosts/indiaminerals.in/tlt.INFOFIXDEVELOPERS.COM/admin/SaleRateList.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 { public partial class SaleRateList : BasePageClass { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { fromDate.Text = Common.DateTimeNow().AddDays(-30).ToString("dd/MM/yyyy"); ToDate.Text = Common.DateTimeNow().ToString("dd/MM/yyyy"); if (fromDate.Text.Length > 0 && ToDate.Text.Length > 0) { var fdate = Common.DateConvertMultimatch(fromDate.Text); var tdate = Common.DateConvertMultimatch(ToDate.Text); int CompId = SiteSession.CompnayId; //var sale = Global.Context.ExecuteStoreQuery<saleListmodal>("select InvoiceNo,[Date],TotalQuantity,TotalAmount,(select Customer.CustomerName from Customer where Customer.CustomerId=SaleRate.CustomerId) as CustomerName,(select Location.LocationName from Location where Location.LocationId=Salerate.LocationId) as LocationName,(select Hamal.HamalName from Hamal where Hamal.HamalId=SaleRate.HamalId) as HamalName, SaleRateId, isnull((select top 1 stuff(( select ',' + u.ItemName from (select ((select Item.ItemName from Item where Item.ItemId=SaleRateItem.ItemId)+' ' + isnull( (select Brand.BrandName from Brand where Brand.BrandId=SaleRateItem.BrandId),'')+' '+ isnull( (select [Weight].WeightName from [Weight] where [Weight].WeightId=SaleRateItem.WeightId),'')+'='+CONVERT(nvarchar(150),Quantity)) as ItemName from SaleRateItem where SaleRateItem.SaleRateId=SaleRate.SaleRateId ) u for xml path('')),1,1,'')),'') as Data from SaleRate where [Date] between '" + fdate.ToString("dd-MMM-yyyy") + "' and '" + tdate.ToString("dd-MMM-yyyy") + "' and CompnayId=" + CompId + " ").ToList(); //Common.BindControl(gvcompnay, sale.ToList().OrderByDescending(p => Common.ConvertInt(p.InvoiceNo)).ToList()); } } } protected void savecompnay_Click(object sender, EventArgs e) { if (fromDate.Text.Length > 0 && ToDate.Text.Length > 0) { var fdate = Common.DateConvertMultimatch(fromDate.Text); var tdate = Common.DateConvertMultimatch(ToDate.Text); int CompId = SiteSession.CompnayId; var sale = Global.Context.ExecuteStoreQuery<saleListmodal>("select InvoiceNo,[Date],TotalQuantity,TotalAmount,(select Customer.CustomerName from Customer where Customer.CustomerId=SaleRate.CustomerId) as CustomerName,(select Location.LocationName from Location where Location.LocationId=Salerate.LocationId) as LocationName,(select Hamal.HamalName from Hamal where Hamal.HamalId=SaleRate.HamalId) as HamalName, SaleRateId, isnull((select top 1 stuff(( select ',' + u.ItemName from (select ((select Item.ItemName from Item where Item.ItemId=SaleRateItem.ItemId)+' ' + isnull( (select Brand.BrandName from Brand where Brand.BrandId=SaleRateItem.BrandId),'')+' '+ isnull( (select [Weight].WeightName from [Weight] where [Weight].WeightId=SaleRateItem.WeightId),'')+'='+CONVERT(nvarchar(150),Quantity)) as ItemName from SaleRateItem where SaleRateItem.SaleRateId=SaleRate.SaleRateId ) u for xml path('')),1,1,'')),'') as Data from SaleRate where [Date] between '" + fdate.ToString("dd-MMM-yyyy") + "' and '" + tdate.ToString("dd-MMM-yyyy") + "' and CompnayId=" + CompId + " ").ToList(); Common.BindControl(gvcompnay, sale.ToList().OrderByDescending(p => Common.ConvertInt(p.InvoiceNo)).ToList()); } } } }
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.08 |
proxy
|
phpinfo
|
Settings