public void SelectJson(int subId, int priceConfirmId) { int pageIndex = 1, pageSize = 100; string orderStr = string.Empty, whereStr = string.Empty; NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; NFMT.Common.SelectModel select = new NFMT.Common.SelectModel(); NFMT.Common.ResultModel result = new NFMT.Common.ResultModel(); NFMT.DoPrice.BLL.PriceConfirmBLL bll = new NFMT.DoPrice.BLL.PriceConfirmBLL(); select = bll.GetPriceConfirmStockListSelectForUpdateUp(pageIndex, pageSize, orderStr, subId, priceConfirmId); result = bll.Load(user, select, NFMT.Common.DefaultValue.ClearAuth); System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable; this.SelectedJsonUp = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter()); select = bll.GetPriceConfirmStockListSelectForUpdateDown(pageIndex, pageSize, orderStr, subId, priceConfirmId); result = bll.Load(user, select, NFMT.Common.DefaultValue.ClearAuth); dt = result.ReturnValue as System.Data.DataTable; this.SelectedJsonDown = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter()); }
public void ProcessRequest(HttpContext context) { int pageIndex = 1, pageSize = 10; string orderStr = string.Empty, whereStr = string.Empty; string subNo = context.Request.QueryString["sn"]; 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 "PriceConfirmId": sortDataField = string.Format("pc.{0}", sortDataField); break; case "InCorpName": sortDataField = "corpIn.CorpName"; break; case "OutCorpName": sortDataField = "corpOut.CorpName"; break; case "SubNo": sortDataField = "sub.OutContractNo"; break; case "ContractAmount": sortDataField = "pc.ContractAmount"; break; case "SubAmount": sortDataField = "pc.SubAmount"; break; case "RealityAmount": sortDataField = "pc.RealityAmount"; break; case "PricingAvg": sortDataField = "pc.PricingAvg"; break; case "PremiumAvg": sortDataField = "pc.PremiumAvg"; break; case "InterestBala": sortDataField = "pc.InterestBala"; break; case "InterestAvg": sortDataField = "pc.InterestAvg"; break; case "SettlePrice": sortDataField = "pc.SettlePrice"; break; case "SettleBala": sortDataField = "pc.SettleBala"; break; case "PricingDate": sortDataField = "pc.PricingDate"; break; case "TakeCorpName": sortDataField = "corpTake.CorpName"; break; case "ContactPerson": sortDataField = "pc.ContactPerson"; break; case "Memo": sortDataField = "pc.Memo"; break; case "StatusName": sortDataField = "bd.StatusName"; break; default: break; } orderStr = string.Format("{0} {1}", sortDataField, sortOrder); } NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; NFMT.DoPrice.BLL.PriceConfirmBLL bll = new NFMT.DoPrice.BLL.PriceConfirmBLL(); NFMT.Common.SelectModel select = bll.GetSelectModel(pageIndex, pageSize, orderStr, subNo, status); 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; string subNo = context.Request.QueryString["sn"]; 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 "ContractDate": sortDataField = string.Format("cs.{0}", sortDataField); break; case "ContractNo": sortDataField = string.Format("c.{0}", sortDataField); break; case "SubNo": sortDataField = "cs.SubNo"; break; case "TradeDirectionName": sortDataField = "c.TradeDirection"; break; case "InCorpName": sortDataField = "inccd.CorpName"; break; case "OutCorpName": sortDataField = "outccd.CorpName"; break; case "AssetName": sortDataField = "a.AssetName"; break; case "SignWeight": sortDataField = "cs.SignAmount"; break; } orderStr = string.Format("{0} {1}", sortDataField, sortOrder); } NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser; NFMT.DoPrice.BLL.PriceConfirmBLL bll = new NFMT.DoPrice.BLL.PriceConfirmBLL(); NFMT.Common.SelectModel select = bll.GetPriceConfirmContractListSelect(pageIndex, pageSize, orderStr, subNo); 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); }