public void SelectJson(int payApplyId)
{
int pageIndex = 1, pageSize = 100;
string orderStr = string.Empty, whereStr = string.Empty;
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
NFMT.Funds.BLL.PayApplyBLL bll = new NFMT.Funds.BLL.PayApplyBLL();
NFMT.Common.SelectModel select = bll.GetSelectedSelect(pageIndex, pageSize, orderStr, payApplyId);
NFMT.Common.IAuthority auth = new NFMT.Common.BasicAuth();
NFMT.Common.ResultModel result = bll.Load(user, select,auth);
int totalRows = result.AffectCount;
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
if (dt != null)
{
foreach (System.Data.DataRow dr in dt.Rows)
{
if (dt.Rows.IndexOf(dr) > 0) { this.Sids += ","; }
if (dr["StockId"] != DBNull.Value)
{
int stockId = Convert.ToInt32(dr["StockId"]);
this.Sids += stockId.ToString();
}
}
}
this.SelectedJson = 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, 52, new List<NFMT.Common.OperateEnum>() { NFMT.Common.OperateEnum.修改 });
string redirectUrl = "PayApplyList.aspx";
this.navigation1.Routes.Add("付款申请列表", redirectUrl);
this.navigation1.Routes.Add("付款申请新增--关联发票", string.Empty);
this.PayMatterStyle = (int)NFMT.Data.StyleEnum.付款事项;
this.PayModeStyle = (int)NFMT.Data.StyleEnum.PayMode;
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
int payApplyId = 0;
if (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out payApplyId))
Response.Redirect(redirectUrl);
//获取付款申请
NFMT.Funds.BLL.PayApplyBLL payApplyBLL = new NFMT.Funds.BLL.PayApplyBLL();
NFMT.Common.ResultModel result = payApplyBLL.Get(user, payApplyId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
this.curPayApply = result.ReturnValue as NFMT.Funds.Model.PayApply;
if (this.curPayApply == null || this.curPayApply.PayApplyId <= 0)
Response.Redirect(redirectUrl);
//获取主申请
NFMT.Operate.BLL.ApplyBLL applyBLL = new NFMT.Operate.BLL.ApplyBLL();
result = applyBLL.Get(user, this.curPayApply.ApplyId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
this.curApply = result.ReturnValue as NFMT.Operate.Model.Apply;
if (this.curApply == null || this.curApply.ApplyId <= 0)
Response.Redirect(redirectUrl);
NFMT.Authority.CorpAuth auth = new NFMT.Authority.CorpAuth();
auth.AuthColumnNames.Add("inv.InCorpId");
NFMT.Common.SelectModel select = payApplyBLL.GetInvoiceListByApplySelect(1, 100, "si.SIId desc", this.curPayApply.PayApplyId);
result = payApplyBLL.Load(user, select, auth);
int totalRows = result.AffectCount;
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
this.JsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter());
}
}
public void SelectJson(int payApplyId, int paymentId)
{
int pageIndex = 1, pageSize = 100;
string orderStr = string.Empty, whereStr = string.Empty;
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
NFMT.Funds.BLL.PayApplyBLL bll = new NFMT.Funds.BLL.PayApplyBLL();
NFMT.Common.SelectModel select = bll.GetPaymentStockCreateSelect(pageIndex, pageSize, orderStr, payApplyId, paymentId);
NFMT.Common.ResultModel result = bll.Load(user, select,new NFMT.Common.BasicAuth());
int totalRows = result.AffectCount;
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, 52, new List<NFMT.Common.OperateEnum>() { NFMT.Common.OperateEnum.修改 });
if (!IsPostBack)
{
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
this.curUser = user;
this.PayMatterStyle = (int)NFMT.Data.StyleEnum.付款事项;
this.PayModeStyle = (int)NFMT.Data.StyleEnum.PayMode;
string redirectUrl = "PayApplyList.aspx";
this.navigation1.Routes.Add("付款申请列表", redirectUrl);
this.navigation1.Routes.Add("付款申请修改", string.Empty);
int applyId = 0 , payApplyId = 0;
if (string.IsNullOrEmpty(Request.QueryString["aid"]))
int.TryParse(Request.QueryString["aid"], out applyId);
if (applyId<=0 && (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out payApplyId)))
Response.Redirect(redirectUrl);
NFMT.Common.ResultModel result = new NFMT.Common.ResultModel();
//获取出库申请
NFMT.Funds.BLL.PayApplyBLL payApplyBLL = new NFMT.Funds.BLL.PayApplyBLL();
if (applyId > 0)
result = payApplyBLL.GetByApplyId(user, applyId);
else
result = payApplyBLL.Get(user, payApplyId);
if(result.ResultStatus!=0)
Response.Redirect(redirectUrl);
NFMT.Funds.Model.PayApply payApply = result.ReturnValue as NFMT.Funds.Model.PayApply;
if (payApply == null || payApply.PayApplyId <= 0)
Response.Redirect(redirectUrl);
this.curPayApply = payApply;
//获取主申请
NFMT.Operate.BLL.ApplyBLL applyBLL = new NFMT.Operate.BLL.ApplyBLL();
result = applyBLL.Get(user, payApply.ApplyId);
if(result.ResultStatus!=0)
Response.Redirect(redirectUrl);
NFMT.Operate.Model.Apply apply = result.ReturnValue as NFMT.Operate.Model.Apply;
if(apply == null || apply.ApplyId<=0)
Response.Redirect(redirectUrl);
this.curApply = apply;
//获取合约付款申请
NFMT.Funds.BLL.ContractPayApplyBLL contractPayApplyBLL = new NFMT.Funds.BLL.ContractPayApplyBLL();
result = contractPayApplyBLL.GetByPayApplyId(user, payApply.PayApplyId);
if(result.ResultStatus!=0)
Response.Redirect(redirectUrl);
NFMT.Funds.Model.ContractPayApply contractPayApply = result.ReturnValue as NFMT.Funds.Model.ContractPayApply;
if(contractPayApply == null || contractPayApply.RefId<=0)
Response.Redirect(redirectUrl);
//获取子合约
NFMT.Contract.BLL.ContractSubBLL subBll = new NFMT.Contract.BLL.ContractSubBLL();
result = subBll.Get(user, contractPayApply.ContractSubId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub;
if (sub == null || sub.ContractId == 0)
Response.Redirect(redirectUrl);
this.curSub = sub;
//合约
NFMT.Contract.BLL.ContractBLL bll = new NFMT.Contract.BLL.ContractBLL();
result = bll.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);
this.contractExpander1.CurContract = contract;
this.contractExpander1.CurContractSub = sub;
this.contractExpander1.RedirectUrl = redirectUrl;
NFMT.Common.SelectModel select = payApplyBLL.GetPayApplyStocksSelect(1, 100, "spa.RefId desc", payApply.PayApplyId);
result = payApplyBLL.Load(user, select,new NFMT.Common.BasicAuth());
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
if (dt == null)
Response.Redirect(redirectUrl);
this.StockDetailsJson = Newtonsoft.Json.JsonConvert.SerializeObject(dt, new Newtonsoft.Json.Converters.DataTableConverter());
result = payApplyBLL.GetContractBalancePayment(user, sub.SubId, 0);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
BalancePaymentValue = (decimal)result.ReturnValue;
}
}
public void ProcessRequest(HttpContext context)
{
int pageIndex = 1, pageSize = 10;
string orderStr = string.Empty, whereStr = string.Empty;
DateTime fromDate = NFMT.Common.DefaultValue.DefaultTime;
DateTime toDate = NFMT.Common.DefaultValue.DefaultTime;
int status = 0;
if (!string.IsNullOrEmpty(context.Request["s"]))
int.TryParse(context.Request["s"], out status);
if (!string.IsNullOrEmpty(context.Request.QueryString["fd"]))
{
if (!DateTime.TryParse(context.Request.QueryString["fd"], out fromDate))
fromDate = NFMT.Common.DefaultValue.DefaultTime;
}
if (!string.IsNullOrEmpty(context.Request.QueryString["td"]))
{
toDate = !DateTime.TryParse(context.Request.QueryString["td"], out toDate) ? NFMT.Common.DefaultValue.DefaultTime : toDate.AddDays(1);
}
int recCorpId = 0;
int applyDeptId = 0;
if (string.IsNullOrEmpty(context.Request.QueryString["ad"]) || !int.TryParse(context.Request.QueryString["ad"].Trim(), out applyDeptId))
{
applyDeptId = 0;
}
if (string.IsNullOrEmpty(context.Request.QueryString["rc"]) || !int.TryParse(context.Request.QueryString["rc"].Trim(), out recCorpId))
{
recCorpId = 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 "ApplyTime":
sortDataField = "app.ApplyTime";
break;
case "ApplyNo":
sortDataField = "app.ApplyNo";
break;
case "PayMatterName":
sortDataField = "pa.PayMatter";
break;
case "PayModeName":
sortDataField = "pa.PayMode";
break;
case "RecCorpName":
sortDataField = "recCor.CorpName ";
break;
case "ApplyBala":
sortDataField = "pa.ApplyBala";
break;
case "Name":
sortDataField = "emp.Name";
break;
case "DeptName":
sortDataField = "dep.DeptName";
break;
case "StatusName":
sortDataField = "app.ApplyStatus";
break;
}
orderStr = string.Format("{0} {1}", sortDataField, sortOrder);
}
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
NFMT.Funds.BLL.PayApplyBLL bll = new NFMT.Funds.BLL.PayApplyBLL();
NFMT.Common.SelectModel select = bll.GetSelectModel(pageIndex, pageSize, orderStr, fromDate, toDate, status, applyDeptId, recCorpId);
NFMT.Authority.CorpAuth auth = new NFMT.Authority.CorpAuth();
auth.AuthColumnNames.Add("app.ApplyCorp");
NFMT.Common.ResultModel 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);
}
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 "StockDate":
sortDataField = "sto.StockDate";
break;
case "RefNo":
sortDataField = "sn.RefNo";
break;
case "StockWeight":
sortDataField = "sto.GrossAmount";
break;
case "CorpName":
sortDataField = "cor.CorpName";
break;
case "AssetName":
sortDataField = "ass.AssetName ";
break;
case "BrandName":
sortDataField = "bra.BrandName";
break;
case "StockStatusName":
sortDataField = "sto.StockStatus";
break;
}
orderStr = string.Format("{0} {1}", sortDataField, sortOrder);
}
string sids = context.Request.QueryString["sids"];
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
NFMT.Funds.BLL.PayApplyBLL bll = new NFMT.Funds.BLL.PayApplyBLL();
NFMT.Common.SelectModel select = bll.GetStockListSelect(pageIndex, pageSize, orderStr,sids);
NFMT.Authority.StockAuth auth= new NFMT.Authority.StockAuth();
NFMT.Common.ResultModel 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);
}
public void ProcessRequest(HttpContext context)
{
int pageIndex = 1, pageSize = 10;
string orderStr = string.Empty, whereStr = string.Empty;
string subNo = context.Request.QueryString["sn"];
DateTime fromDate = NFMT.Common.DefaultValue.DefaultTime;
DateTime toDate = NFMT.Common.DefaultValue.DefaultTime;
int outCorpId = 0;
if (!string.IsNullOrEmpty(context.Request.QueryString["oci"]))
{
if (!int.TryParse(context.Request.QueryString["oci"], out outCorpId))
outCorpId = 0;
}
if (!string.IsNullOrEmpty(context.Request.QueryString["fd"]))
{
if (!DateTime.TryParse(context.Request.QueryString["fd"], out fromDate))
fromDate = NFMT.Common.DefaultValue.DefaultTime;
}
if (!string.IsNullOrEmpty(context.Request.QueryString["td"]))
{
if (!DateTime.TryParse(context.Request.QueryString["td"], 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"]))
{
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 "InCorpName":
sortDataField = "inccd.CorpName";
break;
case "OutCorpName":
sortDataField = "outccd.CorpName";
break;
case "AssetName":
sortDataField = "a.AssetName";
break;
case "CurrencyName":
sortDataField = "cur.CurrencyName";
break;
case "ApplyBala":
sortDataField = "pa.ApplyBala";
break;
case "AllotWeigth":
sortDataField = "soad.SumWeight";
break;
case "LaveWeight":
sortDataField = "(cs.SignAmount -isnull(soad.SumWeight,0))";
break;
case "StatusName":
sortDataField = "sd.StatusName";
break;
}
orderStr = string.Format("{0} {1}", sortDataField, sortOrder);
}
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
NFMT.Funds.BLL.PayApplyBLL bll = new NFMT.Funds.BLL.PayApplyBLL();
NFMT.Common.SelectModel select = bll.GetContractListSelect(pageIndex, pageSize, orderStr, subNo, outCorpId, fromDate, toDate);
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)
{
if (!IsPostBack)
{
Utility.VerificationUtility ver = new Utility.VerificationUtility();
ver.JudgeOperate(this.Page, 52, new List<NFMT.Common.OperateEnum>() { NFMT.Common.OperateEnum.提交审核, NFMT.Common.OperateEnum.作废, NFMT.Common.OperateEnum.撤返, NFMT.Common.OperateEnum.确认完成, NFMT.Common.OperateEnum.确认完成撤销,NFMT.Common.OperateEnum.关闭 });
string redirectUrl = "PayApplyList.aspx";
this.navigation1.Routes.Add("付款申请列表", redirectUrl);
this.navigation1.Routes.Add("付款申请明细--关联发票", string.Empty);
this.PayMatterStyle = (int)NFMT.Data.StyleEnum.付款事项;
this.PayModeStyle = (int)NFMT.Data.StyleEnum.PayMode;
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
int applyId = 0;
if (string.IsNullOrEmpty(Request.QueryString["aid"]) || !int.TryParse(Request.QueryString["aid"], out applyId))
applyId = 0;
int payApplyId = 0;
if (applyId == 0 && (string.IsNullOrEmpty(Request.QueryString["id"]) || !int.TryParse(Request.QueryString["id"], out payApplyId)))
Response.Redirect(redirectUrl);
//获取付款申请
NFMT.Funds.BLL.PayApplyBLL payApplyBLL = new NFMT.Funds.BLL.PayApplyBLL();
NFMT.Common.ResultModel result = new NFMT.Common.ResultModel();
if (applyId > 0)
result = payApplyBLL.GetByApplyId(user, applyId);
else
result = payApplyBLL.Get(user, payApplyId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
this.curPayApply = result.ReturnValue as NFMT.Funds.Model.PayApply;
if (this.curPayApply == null || this.curPayApply.PayApplyId <= 0)
Response.Redirect(redirectUrl);
//获取主申请
NFMT.Operate.BLL.ApplyBLL applyBLL = new NFMT.Operate.BLL.ApplyBLL();
result = applyBLL.Get(user, this.curPayApply.ApplyId);
if (result.ResultStatus != 0)
Response.Redirect(redirectUrl);
this.curApply = result.ReturnValue as NFMT.Operate.Model.Apply;
if (this.curApply == null || this.curApply.ApplyId <= 0)
Response.Redirect(redirectUrl);
NFMT.Common.SelectModel select = payApplyBLL.GetInvoiceListByApplySelect(1, 100, "si.SIId desc", this.curPayApply.PayApplyId);
result = payApplyBLL.Load(user, select,new NFMT.Common.BasicAuth());
int totalRows = result.AffectCount;
System.Data.DataTable dt = result.ReturnValue as System.Data.DataTable;
this.JsonStr = 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.curApply);
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 "InvoiceId":
sortDataField = "inv.InvoiceId";
break;
case "SIId":
sortDataField = "si.SIId";
break;
case "InvoiceDate":
sortDataField = "inv.InvoiceDate";
break;
case "InvoiceNo":
sortDataField = "inv.InvoiceNo";
break;
case "OutCorpName":
sortDataField = "inv.OutCorpName ";
break;
case "InCorpName":
sortDataField = "inv.InCorpName";
break;
case "InvoiceBala":
sortDataField = "inv.InvoiceBala";
break;
case "CurrencyName":
sortDataField = "cur.CurrencyName";
break;
case "LastBala":
sortDataField = "ISNULL(inv.InvoiceBala,0) - ISNULL(ipar.SumBala,0)";
break;
case "DeptName":
sortDataField = "dept.DeptName";
break;
}
orderStr = string.Format("{0} {1}", sortDataField, sortOrder);
}
string ids = context.Request.QueryString["ids"];
string refIds = context.Request.QueryString["refIds"];
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
NFMT.Funds.BLL.PayApplyBLL bll = new NFMT.Funds.BLL.PayApplyBLL();
NFMT.Common.SelectModel select = bll.GetInvoiceListSelect(pageIndex, pageSize, orderStr,ids,refIds);
NFMT.Authority.CorpAuth auth = new NFMT.Authority.CorpAuth();
auth.AuthColumnNames.Add("inv.InCorpId");
NFMT.Common.ResultModel 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);
}
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["s"]) || !DateTime.TryParse(context.Request["s"], out startDate))
startDate = NFMT.Common.DefaultValue.DefaultTime;
if (string.IsNullOrEmpty(context.Request["e"]) || !DateTime.TryParse(context.Request["e"], out endDate))
endDate = NFMT.Common.DefaultValue.DefaultTime;
else
endDate = endDate.AddDays(1);
int applyCorp = 0;
if (string.IsNullOrEmpty(context.Request.QueryString["corp"]) || !int.TryParse(context.Request.QueryString["corp"], out applyCorp))
applyCorp = 0;
int applyDept = 0;
if (string.IsNullOrEmpty(context.Request.QueryString["dept"]) || !int.TryParse(context.Request.QueryString["dept"], out applyDept))
applyDept = 0;
int currency = 0;
if (string.IsNullOrEmpty(context.Request.QueryString["cur"]) || !int.TryParse(context.Request.QueryString["cur"], out currency))
currency = 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 "PayApplyId":
sortDataField = "pa.PayApplyId";
break;
case "ApplyTime":
sortDataField = "a.ApplyTime";
break;
case "ApplyNo":
sortDataField = "a.ApplyNo";
break;
case "ApplyBala":
sortDataField = "pa.ApplyBala";
break;
case "CurrencyName":
sortDataField = "cur.CurrencyName";
break;
case "ApplyCorpName":
sortDataField = "corp.CorpName";
break;
case "DeptName":
sortDataField = "dept.DeptName";
break;
case "RecCorpName":
sortDataField = "recCorp.CorpName";
break;
case "BankName":
sortDataField = "bank.BankName";
break;
case "RecBankAccount":
sortDataField = "pa.RecBankAccount";
break;
case "DetailName":
sortDataField = "bdPayMode.DetailName";
break;
}
orderStr = string.Format("{0} {1}", sortDataField, sortOrder);
}
NFMT.Funds.BLL.PayApplyBLL bll = new NFMT.Funds.BLL.PayApplyBLL();
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
NFMT.Common.SelectModel select = bll.GetPayApplyReportSelect(pageIndex, pageSize, orderStr, applyCorp, applyDept, currency, startDate, endDate);
NFMT.Common.ResultModel result = bll.Load(user, select, new NFMT.Common.BasicAuth());
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);
}
