public void ProcessRequest(HttpContext context) { NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); context.Response.ContentType = "text/plain"; NFMT.Common.ResultModel result = new NFMT.Common.ResultModel(); if (string.IsNullOrEmpty(context.Request.Form["source"])) { result.Message = "数据源为空"; result.ResultStatus = -1; context.Response.Write(serializer.Serialize(result)); context.Response.End(); } bool isPass = false; if (string.IsNullOrEmpty(context.Request.Form["ispass"]) || !bool.TryParse(context.Request.Form["ispass"], out isPass)) { result.Message = "审核结果错误"; result.ResultStatus = -1; context.Response.Write(serializer.Serialize(result)); context.Response.End(); } try { string jsonData = context.Request.Form["source"]; var obj = serializer.Deserialize<NFMT.WorkFlow.Model.DataSource>(jsonData); using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope()) { NFMT.Contract.BLL.ContractBLL bll = new NFMT.Contract.BLL.ContractBLL(); result = bll.ContractInAudit(user, obj, isPass); if (result.ResultStatus == 0) { int contractId = (int)result.ReturnValue; int subId = result.AffectCount; NFMT.WareHouse.BLL.StockLogBLL stockLogBLL = new NFMT.WareHouse.BLL.StockLogBLL(); result = stockLogBLL.ContractInAuditStockLogOperate(user, contractId, subId); } if (result.ResultStatus == 0) scope.Complete(); } } catch (Exception ex) { result.Message = ex.Message; result.ResultStatus = -1; } context.Response.Write(serializer.Serialize(result)); context.Response.End(); }
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()); }
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 = "SubStockInList.aspx"; this.hidTradeDirection.Value = ((int)NFMT.Data.StyleEnum.TradeDirection).ToString(); this.hidTradeBorder.Value = ((int)NFMT.Data.StyleEnum.TradeBorder).ToString(); this.hidContractLimit.Value = ((int)NFMT.Data.StyleEnum.ContractLimit).ToString(); this.hidMarginMode.Value = ((int)NFMT.Data.StyleEnum.MarginMode).ToString(); this.hidValueRateType.Value = ((int)NFMT.Data.StyleEnum.ValueRateType).ToString(); this.hidDiscountBase.Value = ((int)NFMT.Data.StyleEnum.DiscountBase).ToString(); this.hidWhoDoPrice.Value = ((int)NFMT.Data.StyleEnum.WhoDoPrice).ToString(); this.hidSummaryPrice.Value = ((int)NFMT.Data.StyleEnum.SummaryPrice).ToString(); this.navigation1.Routes.Add("合约列表", "ContractList.aspx"); this.navigation1.Routes.Add("库存列表", redirectUrl); this.navigation1.Routes.Add("合约添加", string.Empty); stockLogIds = Request.QueryString["lgs"]; //库存验证 if (string.IsNullOrEmpty(stockLogIds)) Utility.JsUtility.WarmAlert(this, "未选中任务库存", redirectUrl); string[] ids = stockLogIds.Split(new char[]{','},StringSplitOptions.RemoveEmptyEntries); if (ids== null || ids.Length == 0) Utility.JsUtility.WarmAlert(this, "未选中任务库存", redirectUrl); int assetId = 0; int logDirection = (int)NFMT.WareHouse.LogDirectionEnum.In;//入库流水 int customsType = 0; NFMT.WareHouse.BLL.StockLogBLL stockLogBLL = new NFMT.WareHouse.BLL.StockLogBLL(); NFMT.Common.ResultModel result = new NFMT.Common.ResultModel(); foreach (string id in ids) { int stockLogId = 0; if (!int.TryParse(id, out stockLogId) || stockLogId <= 0) Utility.JsUtility.WarmAlert(this, "库存序号错误", redirectUrl); result = stockLogBLL.Get(user, stockLogId); if (result.ResultStatus != 0) Utility.JsUtility.WarmAlert(this, result.Message, redirectUrl); NFMT.WareHouse.Model.StockLog stockLog = result.ReturnValue as NFMT.WareHouse.Model.StockLog; if (stockLog == null || stockLog.StockLogId <= 0) Utility.JsUtility.WarmAlert(this, "库存流水不存在", redirectUrl); if (assetId == 0) { assetId = stockLog.AssetId; this.curAssetId = assetId; } if (customsType == 0) { customsType = stockLog.CustomsType; if (customsType == (int)NFMT.WareHouse.CustomTypeEnum.关内) curTradeBorder = (int)NFMT.Contract.TradeBorderEnum.内贸; else curTradeBorder = (int)NFMT.Contract.TradeBorderEnum.外贸; } //比较是否同一品种 if (assetId != stockLog.AssetId) Utility.JsUtility.WarmAlert(this, "选中库存非同一品种", redirectUrl); //比较是否为入库流水 if (stockLog.LogDirection != logDirection) Utility.JsUtility.WarmAlert(this, "选中库存流水非入库流水,", redirectUrl); //比对关内外库存 if (stockLog.CustomsType != customsType) Utility.JsUtility.WarmAlert(this,"选中库存关境状态不相同",redirectUrl); sumGrossAmount += stockLog.GrossAmount; } NFMT.Data.Model.Asset asset = NFMT.Data.BasicDataProvider.Assets.FirstOrDefault(temp => temp.AssetId == assetId); this.curAsset = asset; }
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) { 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()); }
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(); } }