public void ProcessRequest(HttpContext context) { NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; int pageIndex = 1, pageSize = 10; string orderStr = string.Empty, whereStr = string.Empty; string stockName = context.Request.QueryString["stockName"]; DateTime fromDate = NFMT.Common.DefaultValue.DefaultTime; DateTime toDate = NFMT.Common.DefaultValue.DefaultTime; int status = 0; if (!string.IsNullOrEmpty(context.Request.QueryString["status"])) { if (!int.TryParse(context.Request.QueryString["status"], out status)) status = 0; } if (!string.IsNullOrEmpty(context.Request.QueryString["fromDate"])) { if (!DateTime.TryParse(context.Request.QueryString["fromDate"], out fromDate)) fromDate = NFMT.Common.DefaultValue.DefaultTime; } if (!string.IsNullOrEmpty(context.Request.QueryString["toDate"])) { if (!DateTime.TryParse(context.Request.QueryString["toDate"], out toDate)) toDate = NFMT.Common.DefaultValue.DefaultTime; } 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"])) orderStr = string.Format("{0} {1}", context.Request.QueryString["sortdatafield"].Trim(), context.Request.QueryString["sortorder"].Trim()); NFMT.WareHouse.BLL.ContractStockIn_BLL bll = new NFMT.WareHouse.BLL.ContractStockIn_BLL(); NFMT.Common.SelectModel select = bll.GetStockInNoContractSelect(pageIndex, pageSize, orderStr, stockName, status, fromDate, toDate); 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) { if (!IsPostBack) { Utility.VerificationUtility ver = new Utility.VerificationUtility(); ver.JudgeOperate(this.Page, 41, new List<NFMT.Common.OperateEnum>() { NFMT.Common.OperateEnum.提交审核, NFMT.Common.OperateEnum.作废, NFMT.Common.OperateEnum.撤返 }); string redirectUrl = "StockInContractList.aspx"; this.navigation1.Routes.Add("入库分配列表", "StockInContractList.aspx"); this.navigation1.Routes.Add("入库分配明细", string.Empty); if (string.IsNullOrEmpty(Request.QueryString["id"])) Response.Redirect(redirectUrl); int refId = 0; if (!int.TryParse(Request.QueryString["id"], out refId)) Response.Redirect(redirectUrl); NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; NFMT.Common.ResultModel result = new NFMT.Common.ResultModel(); //获取入库分配 NFMT.WareHouse.BLL.ContractStockIn_BLL contractStockInBLL = new NFMT.WareHouse.BLL.ContractStockIn_BLL(); result = contractStockInBLL.Get(user, refId); if (result.ResultStatus != 0) Response.Redirect(redirectUrl); NFMT.WareHouse.Model.ContractStockIn contractStockIn = result.ReturnValue as NFMT.WareHouse.Model.ContractStockIn; if (contractStockIn == null || contractStockIn.RefId <= 0) Response.Redirect(redirectUrl); this.curContractStockIn = contractStockIn; //获取入库登记 NFMT.WareHouse.BLL.StockInBLL stockInBLL = new NFMT.WareHouse.BLL.StockInBLL(); result = stockInBLL.Get(user, contractStockIn.StockInId); if (result.ResultStatus != 0) Response.Redirect(redirectUrl); NFMT.WareHouse.Model.StockIn stockIn = result.ReturnValue as NFMT.WareHouse.Model.StockIn; if (stockIn == null || stockIn.StockInId <= 0) Response.Redirect(redirectUrl); this.curStockIn = stockIn; NFMT.WareHouse.CustomTypeEnum customsType = (NFMT.WareHouse.CustomTypeEnum)stockIn.CustomType; this.CustomTypeName = customsType.ToString("F"); NFMT.User.Model.Corporation corp = NFMT.User.UserProvider.Corporations.FirstOrDefault(temp => temp.CorpId == stockIn.CorpId); if (corp != null) this.CorpName = corp.CorpName; NFMT.Data.Model.Asset asset = NFMT.Data.BasicDataProvider.Assets.FirstOrDefault(temp => temp.AssetId == stockIn.AssetId); if (asset != null) this.AssetName = asset.AssetName; NFMT.Data.Model.MeasureUnit unit = NFMT.Data.BasicDataProvider.MeasureUnits.FirstOrDefault(temp => temp.MUId == stockIn.UintId); if (unit != null) this.MUName = unit.MUName; NFMT.WareHouse.BLL.ContractStockIn_BLL bll = new NFMT.WareHouse.BLL.ContractStockIn_BLL(); NFMT.Common.SelectModel select = bll.GetContractSelect(1, 100, "si.StockInId desc", stockIn.StockInId); result = bll.Load(user, select); int totalRows = result.AffectCount; System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable; this.curContractJson = 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(contractStockIn); this.hidModel.Value = json; } }
public void ProcessRequest(HttpContext context) { int pageIndex = 1, pageSize = 10; string orderStr = string.Empty, whereStr = string.Empty; 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 = "si.RefNo"; break; case "StockInDate": sortDataField = "si.StockInDate"; break; case "GrossWeight": sortDataField = "si.GrossAmount"; break; case "AssetName": sortDataField = "ass.AssetName"; break; case "BrandName": sortDataField = "bra.BrandName "; break; case "StatusName": sortDataField = "ref.RefStatus"; break; } orderStr = string.Format("{0} {1}", sortDataField, sortOrder); } int subId = 0; int refId = 0; if (string.IsNullOrEmpty(context.Request.QueryString["subId"]) || !int.TryParse(context.Request.QueryString["subId"], out subId)) { context.Response.Write("子合约序号错误"); context.Response.End(); } if(string.IsNullOrEmpty(context.Request.QueryString["refId"]) || !int.TryParse(context.Request.QueryString["refId"],out refId)) refId =0 ; NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; NFMT.WareHouse.BLL.ContractStockIn_BLL bll = new NFMT.WareHouse.BLL.ContractStockIn_BLL(); NFMT.Common.SelectModel select = bll.GetSelectedModel(pageIndex, pageSize, orderStr,subId,refId); 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; 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 "StockOutId": sortDataField = "so.StockOutId"; break; case "StockOutTime": sortDataField = "so.StockOutTime"; break; case "SubNo": sortDataField = "cs.SubNo"; break; case "ApplyNo": sortDataField = "app.ApplyNo"; break; case "InCorpName": sortDataField = "inCorp.CorpName "; break; case "OutCorpName": sortDataField = "outCorp.CorpName"; break; case "AssetName": sortDataField = "ass.AssetName"; break; case "OutWeight": sortDataField = "od.SumWeight"; break; case "ExecutorName": sortDataField = "emp.Name"; break; case "StatusName": sortDataField = "so.StockOutStatus"; break; } orderStr = string.Format("{0} {1}", sortDataField, sortOrder); } int subId = 0; if (string.IsNullOrEmpty(context.Request.QueryString["id"]) || !int.TryParse(context.Request.QueryString["id"], out subId)) subId = 0; int stockInId = 0; if (string.IsNullOrEmpty(context.Request.QueryString["stockId"]) || !int.TryParse(context.Request.QueryString["stockId"], out stockInId)) stockInId = 0; NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; NFMT.WareHouse.BLL.StockInBLL stockInBLL = new NFMT.WareHouse.BLL.StockInBLL(); NFMT.Common.ResultModel result = stockInBLL.Get(user, stockInId); int corpId = 0; int assetId = 0; int customsType = 0; if (result.ResultStatus == 0) { NFMT.WareHouse.Model.StockIn stockIn = result.ReturnValue as NFMT.WareHouse.Model.StockIn; if (stockIn != null && stockIn.StockInId > 0) { corpId = stockIn.CorpId; assetId = stockIn.AssetId; customsType = stockIn.CustomType; } } NFMT.WareHouse.BLL.ContractStockIn_BLL bll = new NFMT.WareHouse.BLL.ContractStockIn_BLL(); NFMT.Common.SelectModel select = bll.GetStockInCanSelect(pageIndex, pageSize, orderStr, subId,assetId,corpId,customsType); NFMT.Common.IAuthority auth = new NFMT.Authority.ContractAuth(); result = bll.Load(user, select,auth); 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, 41, new List<NFMT.Common.OperateEnum>() { NFMT.Common.OperateEnum.查询 }); string redirectUrl = "StockInContractList.aspx"; this.navigation1.Routes.Add("入库分配列表", "StockInContractList.aspx"); this.navigation1.Routes.Add("合约列表", "StockInNoContractList.aspx"); this.navigation1.Routes.Add("入库分配", string.Empty); if (string.IsNullOrEmpty(Request.QueryString["id"])) Response.Redirect(redirectUrl); int stockInId = 0; if (!int.TryParse(Request.QueryString["id"], out stockInId)) Response.Redirect(redirectUrl); //获取入库登记 NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; NFMT.Common.ResultModel result = new NFMT.Common.ResultModel(); NFMT.WareHouse.BLL.StockInBLL stockInBLL = new NFMT.WareHouse.BLL.StockInBLL(); result = stockInBLL.Get(user, stockInId); if (result.ResultStatus != 0) Response.Redirect(redirectUrl); NFMT.WareHouse.Model.StockIn stockIn = result.ReturnValue as NFMT.WareHouse.Model.StockIn; if (stockIn == null || stockIn.StockInId <= 0) Response.Redirect(redirectUrl); this.curStockIn = stockIn; NFMT.WareHouse.CustomTypeEnum customsType = (NFMT.WareHouse.CustomTypeEnum)stockIn.CustomType; this.CustomTypeName = customsType.ToString("F"); NFMT.User.Model.Corporation corp = NFMT.User.UserProvider.Corporations.FirstOrDefault(temp => temp.CorpId == stockIn.CorpId); if (corp != null) this.CorpName = corp.CorpName; NFMT.Data.Model.Asset asset = NFMT.Data.BasicDataProvider.Assets.FirstOrDefault(temp => temp.AssetId == stockIn.AssetId); if (asset != null) this.AssetName = asset.AssetName; NFMT.Data.Model.MeasureUnit unit = NFMT.Data.BasicDataProvider.MeasureUnits.FirstOrDefault(temp => temp.MUId == stockIn.UintId); if (unit != null) this.MUName = unit.MUName; NFMT.WareHouse.BLL.ContractStockIn_BLL bll = new NFMT.WareHouse.BLL.ContractStockIn_BLL(); NFMT.Common.SelectModel select = bll.GetContractSelect(1, 100, "si.StockInId desc",stockIn.StockInId); result = bll.Load(user, select); int totalRows = result.AffectCount; System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable; this.curContractJson = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter()); if (result.AffectCount > 0) { //合约存在,即修改状态 System.Data.DataRow dr = dt.Rows[0]; if (dr["ContractId"] == DBNull.Value || !int.TryParse(dr["ContractId"].ToString(), out this.curSubContractId)) Response.Redirect(redirectUrl); } NFMT.Data.Model.Brand brand = NFMT.Data.BasicDataProvider.Brands.FirstOrDefault(temp => temp.BrandId == this.curStockIn.BrandId); if (brand != null && brand.BrandId > 0) this.curBrandName = brand.BrandName; } }