public void ProcessRequest(HttpContext context) { NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; int pageIndex = 1, pageSize = 100; string orderStr = string.Empty, whereStr = string.Empty; string stockLogIds = context.Request.QueryString["lgs"]; 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 "CustomsTypeName": sortDataField = "sl.CustomsType"; break; default: sortDataField = "sl.StockLogId"; break; } orderStr = string.Format("{0} {1}", sortDataField, sortOrder); } NFMT.WareHouse.BLL.StockLogBLL bll = new NFMT.WareHouse.BLL.StockLogBLL(); NFMT.Common.SelectModel select = bll.GetSubSelectStockLogsSelect(pageIndex, pageSize, orderStr, stockLogIds); 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, 37, new List<NFMT.Common.OperateEnum>() { NFMT.Common.OperateEnum.录入 }); user = Utility.UserUtility.CurrentUser; string redirectUrl = "ContractOutStockList.aspx"; this.navigation1.Routes.Add("合约列表", "ContractList.aspx"); this.navigation1.Routes.Add("库存列表", redirectUrl); this.navigation1.Routes.Add("合约添加", string.Empty); stockIds = Request.QueryString["ids"]; //库存验证 if (string.IsNullOrEmpty(stockIds)) Utility.JsUtility.WarmAlert(this, "未选中任务库存", redirectUrl); string[] ids = stockIds.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); if (ids == null || ids.Length == 0) Utility.JsUtility.WarmAlert(this, "未选中任务库存", redirectUrl); int assetId = 0; int customsType = 0; NFMT.WareHouse.BLL.StockBLL stockBLL = new NFMT.WareHouse.BLL.StockBLL(); NFMT.Common.ResultModel result = new NFMT.Common.ResultModel(); NFMT.WareHouse.BLL.StockExclusiveBLL stockExclusiveBLL = new NFMT.WareHouse.BLL.StockExclusiveBLL(); foreach (string id in ids) { int stockId = 0; if (!int.TryParse(id, out stockId) || stockId <= 0) Utility.JsUtility.WarmAlert(this, "库存序号错误", redirectUrl); result = stockBLL.Get(user, stockId); if (result.ResultStatus != 0) Utility.JsUtility.WarmAlert(this, result.Message, redirectUrl); NFMT.WareHouse.Model.Stock stock = result.ReturnValue as NFMT.WareHouse.Model.Stock; if (stock == null || stock.StockId <= 0) Utility.JsUtility.WarmAlert(this, "库存不存在", redirectUrl); if (assetId == 0) assetId = stock.AssetId; if (customsType == 0) { customsType = stock.CustomsType; if (customsType == (int)NFMT.WareHouse.CustomTypeEnum.关内) curTradeBorder = (int)NFMT.Contract.TradeBorderEnum.内贸; else curTradeBorder = (int)NFMT.Contract.TradeBorderEnum.外贸; } //比较是否同一品种 if (assetId != stock.AssetId) Utility.JsUtility.WarmAlert(this, "选中库存非同一品种", redirectUrl); //比对关内外库存 if (stock.CustomsType != customsType) Utility.JsUtility.WarmAlert(this, "选中库存关境状态不相同", redirectUrl); result = stockExclusiveBLL.LoadByStockId(user, stock.StockId); if(result.ResultStatus!=0) Utility.JsUtility.WarmAlert(this, result.Message, redirectUrl); List<NFMT.WareHouse.Model.StockExclusive> excs = result.ReturnValue as List<NFMT.WareHouse.Model.StockExclusive>; if (excs == null) Utility.JsUtility.WarmAlert(this,"排他表获取失败", redirectUrl); decimal excAmount = excs.Sum(temp => temp.ExclusiveAmount); sumGrossAmount += (stock.CurNetAmount - excAmount); } NFMT.Data.Model.Asset asset = NFMT.Data.BasicDataProvider.Assets.FirstOrDefault(temp => temp.AssetId == assetId); this.curAsset = asset; // int pageIndex = 1; int pageSize = 100; string orderStr = string.Empty; NFMT.WareHouse.BLL.StockLogBLL stockLogBLL = new NFMT.WareHouse.BLL.StockLogBLL(); NFMT.Common.SelectModel select = stockLogBLL.GetContractOutStockSelect(pageIndex, pageSize, orderStr, string.Empty, NFMT.Common.DefaultValue.DefaultTime, NFMT.Common.DefaultValue.DefaultTime, stockIds); result = stockLogBLL.Load(user, select, NFMT.Common.DefaultValue.ClearAuth); System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable; this.SelectedJson = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter()); }
public void ProcessRequest(HttpContext context) { int pageIndex = 1, pageSize = 10; string orderStr = string.Empty; int subId = 0; if (!string.IsNullOrEmpty(context.Request.QueryString["id"])) int.TryParse(context.Request.QueryString["id"], out subId); string logIds = context.Request.QueryString["logIds"]; 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 "RefNo": sortDataField = "sn.RefNo"; break; case "StatusName": sortDataField = "ss.StatusName"; break; case "OwnCorpName": sortDataField = "ownCorp.CorpName"; break; case "AssetName": sortDataField = "ass.AssetName"; break; case "BrandName": sortDataField = "bra.BrandName "; break; case "NetAmount": sortDataField = "sl.NetAmount"; break; case "MUName": sortDataField = "mu.MUName"; break; } orderStr = string.Format("{0} {1}", sortDataField, sortOrder); } NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; NFMT.WareHouse.BLL.StockLogBLL bll = new NFMT.WareHouse.BLL.StockLogBLL(); NFMT.Common.SelectModel select = bll.GetLogsBySubIdSelect(pageIndex, pageSize, orderStr, subId, logIds); 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); }
protected void Page_Load(object sender, EventArgs e) { Utility.VerificationUtility ver = new Utility.VerificationUtility(); ver.JudgeOperate(this.Page, 37, new List<NFMT.Common.OperateEnum>() { NFMT.Common.OperateEnum.修改 }); user = Utility.UserUtility.CurrentUser; string redirectUrl = "ContractOutStockList.aspx"; this.navigation1.Routes.Add("合约列表", "ContractList.aspx"); this.navigation1.Routes.Add("库存列表", redirectUrl); this.navigation1.Routes.Add("合约明细", string.Empty); int subId = 0; if (!string.IsNullOrEmpty(Request.QueryString["sid"])) int.TryParse(Request.QueryString["sid"], out subId); int contractId = 0; if (subId <= 0 && (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out contractId) || contractId <= 0)) Utility.JsUtility.WarmAlert(this, "合约序号错误", redirectUrl); NFMT.Common.ResultModel result = new NFMT.Common.ResultModel(); NFMT.Contract.BLL.ContractSubBLL subBLL = new NFMT.Contract.BLL.ContractSubBLL(); NFMT.Contract.BLL.ContractDetailBLL detailBLL = new NFMT.Contract.BLL.ContractDetailBLL(); NFMT.Contract.BLL.ContractPriceBLL priceBLL = new NFMT.Contract.BLL.ContractPriceBLL(); NFMT.Contract.BLL.ContractCorporationDetailBLL corpBLL = new NFMT.Contract.BLL.ContractCorporationDetailBLL(); NFMT.Contract.BLL.ContractDeptBLL deptBLL = new NFMT.Contract.BLL.ContractDeptBLL(); //主合约进入 if (contractId > 0) { result = contractBLL.Get(user, contractId); if (result.ResultStatus != 0) Utility.JsUtility.WarmAlert(this, "合约不存在", redirectUrl); NFMT.Contract.Model.Contract contract = result.ReturnValue as NFMT.Contract.Model.Contract; if (contract == null || contract.ContractId <= 0) Utility.JsUtility.WarmAlert(this, "合约不存在", redirectUrl); if (contract.CreateFrom != (int)NFMT.Common.CreateFromEnum.销售合约库存创建) Utility.JsUtility.WarmAlert(this, "合约创建来源不正确", redirectUrl); this.curContract = contract; result = subBLL.GetSubByContractId(user, contract.ContractId); if (result.ResultStatus != 0) Utility.JsUtility.WarmAlert(this, "子合约获取失败", redirectUrl); NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub; if (sub == null || sub.SubId <= 0) Utility.JsUtility.WarmAlert(this, "子合约获取失败", redirectUrl); this.curSub = sub; } else if (subId > 0)//子合约进入 { result = subBLL.Get(user, subId); if (result.ResultStatus != 0) Utility.JsUtility.WarmAlert(this, "子合约获取失败", redirectUrl); NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub; if (sub == null || sub.SubId <= 0) Utility.JsUtility.WarmAlert(this, "子合约获取失败", redirectUrl); this.curSub = sub; result = contractBLL.Get(user, sub.ContractId); if (result.ResultStatus != 0) Utility.JsUtility.WarmAlert(this, "合约不存在", redirectUrl); NFMT.Contract.Model.Contract contract = result.ReturnValue as NFMT.Contract.Model.Contract; if (contract == null || contract.ContractId <= 0) Utility.JsUtility.WarmAlert(this, "合约不存在", redirectUrl); if (contract.CreateFrom != (int)NFMT.Common.CreateFromEnum.销售合约库存创建) Utility.JsUtility.WarmAlert(this, "合约创建来源不正确", redirectUrl); this.curContract = contract; } //获取合约品种 NFMT.Data.Model.Asset asset = NFMT.Data.BasicDataProvider.Assets.FirstOrDefault(temp => temp.AssetId == this.curContract.AssetId); if (asset == null || asset.AssetId <= 0) Utility.JsUtility.WarmAlert(this, "合约品种获取失败", redirectUrl); this.curAsset = asset; //获取明细 result = detailBLL.GetDetailByContractId(user, this.curContract.ContractId); if (result.ResultStatus != 0) Utility.JsUtility.WarmAlert(this, "合约明细获取失败", redirectUrl); curContraceDetail = result.ReturnValue as NFMT.Contract.Model.ContractDetail; if (curContraceDetail == null) Utility.JsUtility.WarmAlert(this, "合约明细获取失败", redirectUrl); //获取价格 result = priceBLL.GetPriceByContractId(user, this.curContract.ContractId); if (result.ResultStatus != 0) Utility.JsUtility.WarmAlert(this, "合约价格获取失败", redirectUrl); curContractPrice = result.ReturnValue as NFMT.Contract.Model.ContractPrice; if (curContractPrice == null) Utility.JsUtility.WarmAlert(this, "合约价格获取失败", redirectUrl); //获取公司列表 //我方公司 result = corpBLL.LoadCorpListByContractId(user, this.curContract.ContractId, true); if (result.ResultStatus != 0) Utility.JsUtility.WarmAlert(this, "合约我方抬头获取失败", redirectUrl); List<NFMT.Contract.Model.ContractCorporationDetail> inCorps = result.ReturnValue as List<NFMT.Contract.Model.ContractCorporationDetail>; if (inCorps == null || inCorps.Count == 0) Utility.JsUtility.WarmAlert(this, "合约我方抬头获取失败", redirectUrl); //对方公司 result = corpBLL.LoadCorpListByContractId(user, this.curContract.ContractId, false); if (result.ResultStatus != 0) Utility.JsUtility.WarmAlert(this, "合约对方抬头获取失败", redirectUrl); List<NFMT.Contract.Model.ContractCorporationDetail> outCorps = result.ReturnValue as List<NFMT.Contract.Model.ContractCorporationDetail>; if (outCorps == null || outCorps.Count == 0) Utility.JsUtility.WarmAlert(this, "合约对方抬头获取失败", redirectUrl); //执行部门 result = deptBLL.LoadDeptByContractId(user, this.curContract.ContractId); if (result.ResultStatus != 0) Response.Redirect("ContractList.aspx"); List<NFMT.Contract.Model.ContractDept> depts = result.ReturnValue as List<NFMT.Contract.Model.ContractDept>; foreach (var obj in outCorps) { if (outCorps.IndexOf(obj) > 0) curOutCorpsString += ","; curOutCorpsString += obj.CorpId.ToString(); } foreach (var obj in inCorps) { if (inCorps.IndexOf(obj) > 0) this.curInCorpsString += ","; curInCorpsString += obj.CorpId.ToString(); } foreach (var obj in depts) { if (depts.IndexOf(obj) > 0) curDeptsString += ","; curDeptsString += obj.DeptId.ToString(); } //合约类型 NFMT.Contract.BLL.ContractTypeDetailBLL contractTypeBLL = new NFMT.Contract.BLL.ContractTypeDetailBLL(); result = contractTypeBLL.LoadContractTypesById(user, this.curContract.ContractId); if (result.ResultStatus != 0) this.WarmAlert("合约类型获取失败", redirectUrl); List<NFMT.Contract.Model.ContractTypeDetail> contractTypes = result.ReturnValue as List<NFMT.Contract.Model.ContractTypeDetail>; if (contractTypes == null) this.WarmAlert("合约类型获取失败", redirectUrl); foreach (NFMT.Contract.Model.ContractTypeDetail contractType in contractTypes) { if (contractTypes.IndexOf(contractType) > 0) this.curContractTypesString += ","; this.curContractTypesString += contractType.ContractType.ToString(); } int pageIndex = 1; int pageSize = 100; string orderStr = string.Empty; NFMT.WareHouse.BLL.StockLogBLL stockLogBLL = new NFMT.WareHouse.BLL.StockLogBLL(); NFMT.Common.SelectModel select = stockLogBLL.GetContractOutStockSelect(pageIndex, pageSize, orderStr, this.curSub.SubId); result = stockLogBLL.Load(user, select, NFMT.Common.DefaultValue.ClearAuth); System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable; this.SelectedJson = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter()); System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); string json = serializer.Serialize(this.curContract); this.hidModel.Value = json; this.attach1.BusinessIdValue = this.curContract.ContractId; }
public void ProcessRequest(HttpContext context) { int pageIndex = 1, pageSize = 10; string orderStr = string.Empty, whereStr = string.Empty; DateTime startDate = NFMT.Common.DefaultValue.DefaultTime; DateTime endDate = NFMT.Common.DefaultValue.DefaultTime; if (string.IsNullOrEmpty(context.Request["sd"]) || !DateTime.TryParse(context.Request["sd"], out startDate)) startDate = NFMT.Common.DefaultValue.DefaultTime; if (string.IsNullOrEmpty(context.Request["ed"]) || !DateTime.TryParse(context.Request["ed"], out endDate)) endDate = NFMT.Common.DefaultValue.DefaultTime; else endDate = endDate.AddDays(1); string refNo = context.Request["rn"]; int logType = 0; if (string.IsNullOrEmpty(context.Request.QueryString["lt"]) || !int.TryParse(context.Request.QueryString["lt"], out logType)) logType = 0; int customsType = 0; if (string.IsNullOrEmpty(context.Request.QueryString["ct"]) || !int.TryParse(context.Request.QueryString["ct"], out customsType)) customsType = 0; int assetId = 0; if (string.IsNullOrEmpty(context.Request.QueryString["ass"]) || !int.TryParse(context.Request.QueryString["ass"], out assetId)) assetId = 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 "LogTypeName": sortDataField = "lt.DetailName"; break; case "RefNo": sortDataField = "sn.RefNo"; break; case "PaperNo": sortDataField = "sto.PaperNo"; break; case "AssetName": sortDataField = "ass.AssetName"; break; case "BrandName": sortDataField = "bra.BrandName"; break; case "CustomsTypeName": sortDataField = "cus.DetailName"; break; case "DPName": sortDataField = "dp.DPName"; break; case "GrossAmount": sortDataField = "sl.GrossAmount"; break; case "NetAmount": sortDataField = "sl.NetAmount"; break; case "MUName": sortDataField = "mu.MUName"; break; case "CardNo": sortDataField = "sto.CardNo"; break; case "InCorpName": sortDataField = "inCorp.CorpName"; break; case "OutCorpName": sortDataField = "outCorp.CorpName"; break; case "SubNo": sortDataField = "cs.SubNo"; break; case "TradeDirectionName": sortDataField = "td.DetailName"; break; case "AvgPrice": sortDataField = "pri.AvgPrice"; break; case "CurrencyName": sortDataField = "cur.CurrencyName"; break; } orderStr = string.Format("{0} {1}", sortDataField, sortOrder); } NFMT.WareHouse.BLL.StockLogBLL bll = new NFMT.WareHouse.BLL.StockLogBLL(); NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; NFMT.Common.SelectModel select = bll.GetStockLogReportSelect(pageIndex, pageSize, orderStr, refNo, logType, customsType,assetId, startDate, endDate); 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) { int pageIndex = 1, pageSize = 10; string orderStr = string.Empty, whereStr = string.Empty; int stockId = 0; if(string.IsNullOrEmpty(context.Request["si"])) { context.Response.Write("库存序号错误"); context.Response.End(); } if (!int.TryParse(context.Request["si"], out stockId)) { context.Response.Write("库存序号错误"); context.Response.End(); } 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 "LogDate": sortDataField = string.Format("sl.{0}", sortDataField); break; case "DetailName": sortDataField = "sl.LogType"; break; case "Name": sortDataField = "emp.Name"; break; case "Memo": sortDataField = "sl.Memo"; break; } orderStr = string.Format("{0} {1}", sortDataField, sortOrder); } NFMT.WareHouse.BLL.StockLogBLL stockLogBLL = new NFMT.WareHouse.BLL.StockLogBLL(); NFMT.Common.SelectModel select = stockLogBLL.GetLogListByStockIdSelect(pageIndex, pageSize, orderStr,stockId); NFMT.Common.ResultModel result = stockLogBLL.Load(new NFMT.Common.UserModel(), 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); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Utility.VerificationUtility ver = new Utility.VerificationUtility(); ver.JudgeOperate(this.Page, 94, new List<NFMT.Common.OperateEnum>() { NFMT.Common.OperateEnum.录入 }); string redirectUrl = "CashInAllotList.aspx"; this.navigation1.Routes.Add("收款分配列表", redirectUrl); this.navigation1.Routes.Add("合约收款分配新增", string.Empty); int subId = 0; if (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out subId) || subId <= 0) Response.Redirect(redirectUrl); NFMT.Common.ResultModel result = new NFMT.Common.ResultModel(); NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; //获取子合约 NFMT.Contract.BLL.ContractSubBLL subBLL = new NFMT.Contract.BLL.ContractSubBLL(); result = subBLL.Get(user, subId); if (result.ResultStatus != 0) Response.Redirect(redirectUrl); NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub; if (sub == null || sub.SubId <= 0) Response.Redirect(redirectUrl); this.curSub = sub; //获取合约 NFMT.Contract.BLL.ContractBLL contractBLL = new NFMT.Contract.BLL.ContractBLL(); result = contractBLL.Get(user, sub.ContractId); if (result.ResultStatus != 0) Response.Redirect(redirectUrl); NFMT.Contract.Model.Contract contract = result.ReturnValue as NFMT.Contract.Model.Contract; if (contract == null || contract.ContractId <= 0) Response.Redirect(redirectUrl); result = subBLL.GetContractOutCorp(user, subId); if (result.ResultStatus != 0) Response.Redirect(redirectUrl); this.contractExpander1.CurContract = contract; this.contractExpander1.CurContractSub = sub; this.contractExpander1.RedirectUrl = redirectUrl; System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable; if (dt == null || dt.Rows.Count == 0) Response.Redirect(redirectUrl); for (int i = 0; i < dt.Rows.Count; i++) { System.Data.DataRow dr = dt.Rows[i]; if (dr["CorpId"] != DBNull.Value) { if (i != 0) this.curOutCorpIds += ","; this.curOutCorpIds += dr["CorpId"].ToString(); } } this.JsonOutCorp = Newtonsoft.Json.JsonConvert.SerializeObject(result.ReturnValue); //拼接合约库存 NFMT.WareHouse.BLL.StockLogBLL stockLogBLL = new NFMT.WareHouse.BLL.StockLogBLL(); NFMT.Common.SelectModel select = stockLogBLL.GetLogListBySubSelect(1, 100, "sl.StockLogId desc", sub.SubId); result = stockLogBLL.Load(user, select); dt = result.ReturnValue as System.Data.DataTable; System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("["); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { System.Data.DataRow dr = dt.Rows[i]; if (i != 0) sb.Append(","); string refNo = dr["RefNo"].ToString(); int stockLogId = 0; decimal stockLogGrossWeight = 0; decimal stockLogNetWeight = 0; int.TryParse(dr["StockLogId"].ToString(), out stockLogId); decimal.TryParse(dr["GrossAmount"].ToString(), out stockLogGrossWeight); decimal.TryParse(dr["NetAmount"].ToString(),out stockLogNetWeight); string muName = dr["MUName"].ToString(); string assetName = dr["AssetName"].ToString(); string brandName = dr["BrandName"].ToString(); sb.Append("{ Html: \"<div style='padding: 1px;'>"); sb.AppendFormat("<div>{0}</div>", refNo); sb.AppendFormat("<div>毛重: {0}{1}</div>", stockLogGrossWeight, muName); sb.AppendFormat("<div>净重: {0}{1}</div>", stockLogNetWeight, muName); sb.AppendFormat("<div>品种: {0}</div><div>品牌: {1}</div></div>\"", assetName, brandName); sb.AppendFormat(", Title: \"{0}\"",refNo); sb.Append(",StockLogId:"); sb.Append(stockLogId); sb.Append("}"); } } sb.Append("]"); this.JsonStock = sb.ToString(); } }