File manager - Edit - G:/PleskVhosts/indiaminerals.in/vgm.INFOFIXDEVELOPERS.COM/App_Data/PendingRCOwnerAmount.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 PendingRCOwnerAmount : BasePageClass { protected void Page_Load(object sender, EventArgs e) { } protected void SaveData_Click(object sender, EventArgs e) { if (fromDate.Text.Length > 0 && ToDate.Text.Length > 0) { var FromDates = Common.DateConvert(fromDate.Text, "dd/MM/yyyy"); var ToDates = Common.DateConvert(ToDate.Text, "dd/MM/yyyy"); var Data = Global.Context.ExecuteStoreQuery<PendingAmountRc>("select x.RcOwnerId,Name,PhoneNumber,Pencard as PanCard,Amount,(select top 1 stuff((select ',' + u.BiltyNumber from (select BiltyNumber from Bilty where Bilty.ChalanId in (( select ChallanId from Challan where [Date] between '" + FromDates.Date.ToString("dd-MMM-yyyy") + "' and '" + ToDates.Date.ToString("dd-MMM-yyyy") + "' and isnull(FinalAmountPad,0)=0 and RCOwnerId=x.RCOwnerId))) u for xml path('')),1,1,'')) as Biltys from (select RcOwnerId, sum( (case when isnull(CLoseBalance,0)>0 then isnull(CLoseBalance,0) else isnull(Balance,0) end )) as Amount from Challan where [Date] between '" + FromDates.Date.ToString("dd-MMM-yyyy") + "' and '" + ToDates.Date.ToString("dd-MMM-yyyy") + "' and isnull(FinalAmountPad,0)=0 group by RCOwnerId) as x left join RcOwner on x.RcOwnerId=RcOwner.RcOwnerId").ToList(); Common.BindControl(gvcourse, Data.OrderBy(p => p.Name).ToList()); gvcourse.FooterRow.Cells[2].Text = "Total"; gvcourse.FooterRow.Cells[2].HorizontalAlign = HorizontalAlign.Right; gvcourse.FooterRow.Cells[3].Text = Data.Sum(p => p.Amount).ToString(); gvcourse.FooterRow.Cells[3].HorizontalAlign = HorizontalAlign.Right; gvcourse.FooterRow.Cells[2].ForeColor = System.Drawing.Color.White; gvcourse.FooterRow.Cells[3].ForeColor = System.Drawing.Color.White; gvcourse.FooterRow.Cells[2].Font.Bold = true; gvcourse.FooterRow.Cells[3].Font.Bold = true; gvcourse.FooterRow.BackColor = System.Drawing.Color.Orange; } } } } public class PendingAmountRc { public int RcOwnerId { get; set; } public string Name { get; set; } public string PhoneNumber { get; set; } public string PanCard { get; set; } public string Biltys { get; set; } public decimal Amount { get; set; } }
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.04 |
proxy
|
phpinfo
|
Settings