public void ProcessRequest(HttpContext context) { int pageIndex = 1, pageSize = 100; string orderStr = string.Empty, whereStr = string.Empty; int stockLogId = 0; if (string.IsNullOrEmpty(context.Request.QueryString["stockLogId"]) || !int.TryParse(context.Request.QueryString["stockLogId"], out stockLogId) || stockLogId == 0) { context.Response.Write("获取数据错误"); context.Response.End(); } if (!string.IsNullOrEmpty(context.Request.QueryString["sortdatafield"]) && !string.IsNullOrEmpty(context.Request.QueryString["sortorder"])) { string sortDataField = context.Request.QueryString["sortdatafield"].Trim(); string sortOrder = context.Request.QueryString["sortorder"].Trim(); switch (sortDataField) { case "AllotTime": sortDataField = "cia.AllotTime"; break; case "AlloterName": sortDataField = "emp.Name"; break; case "AllotBala": sortDataField = "cia.AllotBala"; break; case "CurrencyName": sortDataField = "cur.CurrencyName"; break; case "StatusName": sortDataField = "cia.AllotStatus"; break; } orderStr = string.Format("{0} {1}", sortDataField, sortOrder); } NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; NFMT.Funds.BLL.CashInStcokBLL bll = new NFMT.Funds.BLL.CashInStcokBLL(); NFMT.Common.SelectModel select = bll.GetOtherAllotInStock(pageIndex, pageSize, orderStr,stockLogId); NFMT.Common.ResultModel result = bll.Load(user, select); context.Response.ContentType = "text/plain"; if (result.ResultStatus != 0) { context.Response.Write(result.Message); context.Response.End(); } int totalRows = result.AffectCount; System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable; Dictionary<string, object> dic = new Dictionary<string, object>(); dic.Add("count", totalRows); dic.Add("data", dt); string postData = Newtonsoft.Json.JsonConvert.SerializeObject(dic, new Newtonsoft.Json.Converters.DataTableConverter()); context.Response.Write(postData); }
public void ProcessRequest(HttpContext context) { NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; int pageIndex = 1, pageSize = 10; string orderStr = string.Empty, whereStr = string.Empty; int status = 0; if (!string.IsNullOrEmpty(context.Request.QueryString["s"])) { if (!int.TryParse(context.Request.QueryString["s"], out status)) status = 0; } if (!string.IsNullOrEmpty(context.Request.QueryString["pagenum"])) int.TryParse(context.Request.QueryString["pagenum"], out pageIndex); pageIndex++; if (!string.IsNullOrEmpty(context.Request.QueryString["pagesize"])) int.TryParse(context.Request.QueryString["pagesize"], out pageSize); if (!string.IsNullOrEmpty(context.Request.QueryString["sortdatafield"]) && !string.IsNullOrEmpty(context.Request.QueryString["sortorder"])) { string sortDataField = context.Request.QueryString["sortdatafield"].Trim(); string sortOrder = context.Request.QueryString["sortorder"].Trim(); switch (sortDataField) { case "Name": sortDataField = "e.Name"; break; case "CorpName": sortDataField = "co.CorpName"; break; case "AllotBala": sortDataField = "cia.AllotBala"; break; case "StatusName": sortDataField = "AllotStatus"; break; } orderStr = string.Format("{0} {1}", sortDataField, sortOrder); } string subNo = context.Request.QueryString["sn"]; NFMT.Funds.BLL.CashInStcokBLL bll = new NFMT.Funds.BLL.CashInStcokBLL(); NFMT.Common.SelectModel select = bll.GetAllotReadyStockSelect(pageIndex, pageSize, orderStr, status, subNo); NFMT.Common.ResultModel result = bll.Load(user, select); context.Response.ContentType = "application/json; charset=utf-8"; if (result.ResultStatus != 0) { context.Response.Write(result.Message); context.Response.End(); } System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable; System.Collections.Generic.Dictionary<string, object> dic = new System.Collections.Generic.Dictionary<string, object>(); dic.Add("count", result.AffectCount); dic.Add("data", dt); string postData = Newtonsoft.Json.JsonConvert.SerializeObject(dic); context.Response.Write(postData); }
protected void Page_Load(object sender, EventArgs e) { Utility.VerificationUtility ver = new Utility.VerificationUtility(); ver.JudgeOperate(this.Page, 58, new List<NFMT.Common.OperateEnum>() { NFMT.Common.OperateEnum.修改 }); int allotId = 0; string redirctUrl = "CashInAllotStockList.aspx"; NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; NFMT.Common.ResultModel result = new NFMT.Common.ResultModel(); if (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out allotId) || allotId <= 0) Response.Redirect(redirctUrl); //获取收款分配主表 NFMT.Funds.BLL.CashInBLL cashInBLL = new NFMT.Funds.BLL.CashInBLL(); result = cashInBLL.Get(user, allotId); if (result.ResultStatus != 0) Response.Redirect(redirctUrl); cashInAllot = result.ReturnValue as NFMT.Funds.Model.CashInAllot; if (cashInAllot == null) Response.Redirect(redirctUrl); NFMT.Common.StatusEnum status = NFMT.Common.StatusEnum.已生效; if (cashInAllot.AllotStatus == NFMT.Common.StatusEnum.已完成) status = NFMT.Common.StatusEnum.已完成; else if (cashInAllot.AllotStatus == NFMT.Common.StatusEnum.已作废) status = NFMT.Common.StatusEnum.已作废; else if (cashInAllot.AllotStatus == NFMT.Common.StatusEnum.已关闭) status = NFMT.Common.StatusEnum.已关闭; //通过收款分配Id获取库存收款分配明细表 NFMT.Funds.BLL.CashInStcokBLL cashInStcokBLL = new NFMT.Funds.BLL.CashInStcokBLL(); result = cashInStcokBLL.LoadByAllot(user, allotId, status); if (result.ResultStatus != 0) Response.Redirect(redirctUrl); NFMT.Funds.Model.CashInStcok cashInStock = result.ReturnValue as NFMT.Funds.Model.CashInStcok; if (cashInStock == null) Response.Redirect(redirctUrl); int stockLogId = cashInStock.StockLogId; //获取库存流水 NFMT.WareHouse.BLL.StockLogBLL stockLogBLL = new NFMT.WareHouse.BLL.StockLogBLL(); result = stockLogBLL.Get(user, stockLogId); if (result.ResultStatus != 0) Response.Redirect(redirctUrl); NFMT.WareHouse.Model.StockLog stockLog = result.ReturnValue as NFMT.WareHouse.Model.StockLog; if (stockLog == null || stockLog.StockLogId <= 0) Response.Redirect(redirctUrl); this.curStockLog = stockLog; //获取子合约 NFMT.Contract.BLL.ContractSubBLL subBLL = new NFMT.Contract.BLL.ContractSubBLL(); result = subBLL.Get(user, stockLog.SubContractId); if (result.ResultStatus != 0) Response.Redirect(redirctUrl); NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub; if (sub == null || sub.SubId <= 0) Response.Redirect(redirctUrl); this.curSub = sub; //合约抬头 NFMT.Contract.BLL.ContractCorporationDetailBLL ccdBll = new NFMT.Contract.BLL.ContractCorporationDetailBLL(); //内部公司 result = ccdBll.LoadCorpListByContractId(user, sub.ContractId, true); List<NFMT.Contract.Model.ContractCorporationDetail> innerCorps = result.ReturnValue as List<NFMT.Contract.Model.ContractCorporationDetail>; foreach (NFMT.Contract.Model.ContractCorporationDetail innerCorp in innerCorps) { this.spnInCorpNames.InnerHtml += string.Format("[{0}] ", innerCorp.CorpName); } //外部公司 result = ccdBll.LoadCorpListByContractId(user, sub.ContractId, false); List<NFMT.Contract.Model.ContractCorporationDetail> outCorps = result.ReturnValue as List<NFMT.Contract.Model.ContractCorporationDetail>; foreach (NFMT.Contract.Model.ContractCorporationDetail outCorp in outCorps) { this.spnOutCorpNames.InnerHtml += string.Format("[{0}] ", outCorp.CorpName); } NFMT.Data.Model.MeasureUnit mu = NFMT.Data.BasicDataProvider.MeasureUnits.FirstOrDefault(temp => temp.MUId == sub.UnitId); if (mu != null && mu.MUId > 0) this.spnSignAmount.InnerHtml = string.Format("{0},{1}", sub.SignAmount, mu.MUName); //获取库存 NFMT.WareHouse.BLL.StockBLL stockBLL = new NFMT.WareHouse.BLL.StockBLL(); result = stockBLL.Get(user, stockLog.StockId); if (result.ResultStatus != 0) Response.Redirect(redirctUrl); NFMT.WareHouse.Model.Stock stock = result.ReturnValue as NFMT.WareHouse.Model.Stock; if (stock == null || stock.StockId <= 0) Response.Redirect(redirctUrl); this.curStock = stock; //获取业务单号 NFMT.WareHouse.BLL.StockNameBLL stockNameBLL = new NFMT.WareHouse.BLL.StockNameBLL(); result = stockNameBLL.Get(user, stock.StockNameId); if (result.ResultStatus != 0) Response.Redirect(redirctUrl); NFMT.WareHouse.Model.StockName stockName = result.ReturnValue as NFMT.WareHouse.Model.StockName; if (stockName == null || stockName.StockNameId <= 0) Response.Redirect(redirctUrl); this.spanRefNo.InnerHtml = stockName.RefNo; this.spanStockDate.InnerHtml = stock.StockDate.ToShortDateString(); NFMT.User.Model.Corporation ownCorp = NFMT.User.UserProvider.Corporations.FirstOrDefault(temp => temp.CorpId == stock.CorpId); if (ownCorp != null && ownCorp.CorpId > 0) this.spanCorpId.InnerHtml = ownCorp.CorpName; if (mu != null && mu.MUId > 0) this.spanGrossAmout.InnerHtml = string.Format("{0},{1}", stock.GrossAmount, mu.MUName); NFMT.Data.Model.Asset ass = NFMT.Data.BasicDataProvider.Assets.FirstOrDefault(temp => temp.AssetId == stock.AssetId); if (ass != null && ass.AssetId > 0) this.spanAssetId.InnerHtml = ass.AssetName; NFMT.Data.Model.Brand bra = NFMT.Data.BasicDataProvider.Brands.FirstOrDefault(temp => temp.BrandId == stock.BrandId); if (bra != null && bra.BrandId > 0) this.spanBrandId.InnerHtml = bra.BrandName; this.navigation1.Routes.Add("库存分配列表", redirctUrl); this.navigation1.Routes.Add("库存分配修改", string.Empty); this.JsonOutCorp = Newtonsoft.Json.JsonConvert.SerializeObject(outCorps); for (int i = 0; i < outCorps.Count; i++) { NFMT.Contract.Model.ContractCorporationDetail corp = outCorps[i]; if (corp.CorpId > 0) { if (i != 0) this.curOutCorpIds += ","; this.curOutCorpIds += corp.CorpId; } } NFMT.Funds.BLL.CashInStcokBLL bll = new NFMT.Funds.BLL.CashInStcokBLL(); NFMT.Common.SelectModel select = bll.GetCurDetailsSelect(1, 100, "cisr.RefId desc", stockLogId); result = bll.Load(user, select); int totalRows = result.AffectCount; System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable; this.JsonContractSelect = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter()); }