File manager - Edit - G:/PleskVhosts/indiaminerals.in/tlt.INFOFIXDEVELOPERS.COM/admin/Printdoc/changesoprint.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; using System.Data; namespace WebApp.admin.Printdoc { public partial class changesoprint : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrWhiteSpace(Request.QueryString["id"])) { int EditId = Request.QueryString["id"].ConvertInt(); var Items = Global.Context.Sales.AsEnumerable().SingleOrDefault(p => p.SaleId == EditId); GSTNO.Text = SiteSession.CompnayName.GSTNO; CompnayName.Text = SiteSession.CompnayName.CompnayName; AddressData.Text = SiteSession.CompnayName.Address; Phono.Text = SiteSession.CompnayName.PhoneNo.Replace("~","<br/>"); InvoiceNo.Text = Items.InvoiceNo; InvoiceDate.Text = Items.Date.Value.ToString("dd/MM/yyyy"); CustomerId.Text = Items.Customer.CustomerName; TotalSaman.Text = Items.SaleItems.Sum(p => Common.ConvertDecimal(p.Quantity)).ToString(); Common.BindControl(LoopItem, Items.SaleItems.AsEnumerable().ToList()); } } // if (!string.IsNullOrWhiteSpace(Request.QueryString["id"])) // { // int EditId = Request.QueryString["id"].ConvertInt(); // var Items = Global.Context.SoItems.AsEnumerable().Where(p => p.SOID == EditId); // var obj = Global.Context.SOes.AsEnumerable().SingleOrDefault(p => p.SOId == EditId); // var objParent= Global.Context.SOes.AsEnumerable().SingleOrDefault(p => p.SOId == obj.ParentId); // ConsigneeAddress.Text = obj.ConsigneeAddress; // PONO.Text = obj.SoNo; // PODate.Text = obj.SoDate.Value.ToString("dd/MM/yyyy"); // SoNo.Text = objParent.SoNo; // SoDate.Text = objParent.SoDate.Value.ToString("dd/MM/yyyy"); // CustomerId.Text = obj.Customer.CustomerAddress; // try // { // int[] UserId = { obj.SalesOfficerId.Value, obj.BranchHeadId.Value, obj.PKMId.Value, obj.AdminId.Value }; // var objUser = Global.Context.UserLogins.AsEnumerable().Where(p => UserId.Contains(p.UserLoginId)).ToList(); // string Sales = objUser.Where(p => p.UserLoginId == obj.SalesOfficerId.Value).FirstOrDefault().FullName; // var objSaleStus = Global.Context.ExecuteStoreQuery<StatusSoData>("select UniqNo as SoStatusId,[Datetime] from (select MAX(SoStatusId) as SoStatusId from SoStatus where SoId=" + EditId.ToString() + " and UserId=" + obj.SalesOfficerId.Value.ToString() + " ) as x left join SoStatus on x.SoStatusId=SoStatus.SoStatusId").ToList(); // SalesOffice.Text = Sales + "<br/>" + objSaleStus.FirstOrDefault().Datetime.ToString("dd/MM/yyyy hh:mm tt") + "<br/>(" + objSaleStus.FirstOrDefault().SoStatusId.ToString() + ")"; // string BranchHeadstr = objUser.Where(p => p.UserLoginId == obj.BranchHeadId.Value).FirstOrDefault().FullName; // var objBranchHeadStus = Global.Context.ExecuteStoreQuery<StatusSoData>("select UniqNo as SoStatusId,[Datetime] from (select MAX(SoStatusId) as SoStatusId from SoStatus where SoId=" + EditId.ToString() + " and UserId=" + obj.BranchHeadId.Value.ToString() + " ) as x left join SoStatus on x.SoStatusId=SoStatus.SoStatusId").ToList(); // BranchHead.Text = BranchHeadstr + "<br/>" + objBranchHeadStus.FirstOrDefault().Datetime.ToString("dd/MM/yyyy hh:mm tt") + "<br/>(" + objBranchHeadStus.FirstOrDefault().SoStatusId.ToString() + ")"; // string BranchPKMstr = objUser.Where(p => p.UserLoginId == obj.PKMId.Value).FirstOrDefault().FullName; // var objPKMStus = Global.Context.ExecuteStoreQuery<StatusSoData>("select UniqNo as SoStatusId,[Datetime] from (select MAX(SoStatusId) as SoStatusId from SoStatus where SoId=" + EditId.ToString() + " and UserId=" + obj.PKMId.Value.ToString() + " ) as x left join SoStatus on x.SoStatusId=SoStatus.SoStatusId").ToList(); // PKM.Text = BranchPKMstr + "<br/>" + objPKMStus.FirstOrDefault().Datetime.ToString("dd/MM/yyyy hh:mm tt") + "<br/>(" + objPKMStus.FirstOrDefault().SoStatusId.ToString() + ")"; // string Adminstr = objUser.Where(p => p.UserLoginId == obj.AdminId.Value).FirstOrDefault().FullName; // var objAdminStus = Global.Context.ExecuteStoreQuery<StatusSoData>("select UniqNo as SoStatusId,[Datetime] from (select MAX(SoStatusId) as SoStatusId from SoStatus where SoId=" + EditId.ToString() + " and UserId=" + obj.AdminId.Value.ToString() + " ) as x left join SoStatus on x.SoStatusId=SoStatus.SoStatusId").ToList(); // Admin.Text = Adminstr + "<br/>" + objAdminStus.FirstOrDefault().Datetime.ToString("dd/MM/yyyy hh:mm tt") + "<br/>(" + objAdminStus.FirstOrDefault().SoStatusId.ToString() + ")"; // } // catch { } // DataTable Dt= ChangeSoClass.Change(obj.SOId); // LIBS.Common.BindControldt(LoopItem, Dt); // } // } } } }
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.1 |
proxy
|
phpinfo
|
Settings