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 ProcessRequest(HttpContext context)
{
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
int pageIndex = 1, pageSize = 10;
string orderStr = string.Empty, whereStr = string.Empty;
int status = 0;
if (!string.IsNullOrEmpty(context.Request.QueryString["s"]))
{
if (!int.TryParse(context.Request.QueryString["s"], out status))
status = 0;
}
int bank = 0;
if (!string.IsNullOrEmpty(context.Request.QueryString["b"]))
{
if (!int.TryParse(context.Request.QueryString["b"], out bank))
bank = 0;
}
int empId = 0;
if (!string.IsNullOrEmpty(context.Request.QueryString["e"]))
{
if (!int.TryParse(context.Request.QueryString["e"], out empId))
empId = 0;
}
DateTime fromDate = NFMT.Common.DefaultValue.DefaultTime;
if (!string.IsNullOrEmpty(context.Request.QueryString["f"]))
{
if (!DateTime.TryParse(context.Request.QueryString["f"], out fromDate))
fromDate = NFMT.Common.DefaultValue.DefaultTime;
}
DateTime toDate = NFMT.Common.DefaultValue.DefaultTime;
if (!string.IsNullOrEmpty(context.Request.QueryString["t"]))
{
if (!DateTime.TryParse(context.Request.QueryString["t"], 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 "CashInId":
sortDataField = "ci.CashInId";
break;
case "CashInDate":
sortDataField = "ci.CashInDate";
break;
case "InnerCorp":
sortDataField = "c.CorpName";
break;
case "CashInBala":
sortDataField = "ci.CashInBala";
break;
case "BankName":
sortDataField = "b.BankName";
break;
case "OutCorp":
sortDataField = "ci.PayCorpName";
break;
case "StatusName":
sortDataField = "bd.StatusName";
break;
case "CanAllotBala":
sortDataField = "ci.CashInBala";
break;
}
orderStr = string.Format("{0} {1}", sortDataField, sortOrder);
}
NFMT.Funds.BLL.CashInBLL bll = new NFMT.Funds.BLL.CashInBLL();
NFMT.Common.SelectModel select = bll.GetCanAllotSelectModel(pageIndex, pageSize, orderStr, fromDate, toDate, empId, bank, status);
NFMT.Common.IAuthority authority = new NFMT.Authority.CorpAuth();
authority.AuthColumnNames.Add("ci.CashInCorpId");
NFMT.Common.ResultModel result = bll.Load(user, select, authority);
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);
}
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 ResultModel LoadAuthSelfCorp(UserModel user)
{
ResultModel result = new ResultModel();
try
{
NFMT.Authority.CorpAuth auth = new NFMT.Authority.CorpAuth();
auth.AuthColumnNames.Add("corp.CorpId");
result = auth.CreateAuthorityStr(user);
string cmdText = string.Format("select corp.* from dbo.Corporation corp where corp.IsSelf=1 and corp.CorpStatus ={0} {1}", (int)StatusEnum.已生效, result.ReturnValue.ToString());
DataTable dt = SqlHelper.ExecuteDataTable(ConnectString, cmdText, null, CommandType.Text);
List<Corporation> corporations = new List<Corporation>();
foreach (DataRow dr in dt.Rows)
{
Corporation corporation = new Corporation();
corporation.CorpId = Convert.ToInt32(dr["CorpId"]);
if (dr["ParentId"] != DBNull.Value)
{
corporation.ParentId = Convert.ToInt32(dr["ParentId"]);
}
if (dr["CorpCode"] != DBNull.Value)
{
corporation.CorpCode = Convert.ToString(dr["CorpCode"]);
}
if (dr["CorpName"] != DBNull.Value)
{
corporation.CorpName = Convert.ToString(dr["CorpName"]);
}
if (dr["CorpEName"] != DBNull.Value)
{
corporation.CorpEName = Convert.ToString(dr["CorpEName"]);
}
if (dr["TaxPayerId"] != DBNull.Value)
{
corporation.TaxPayerId = dr["TaxPayerId"].ToString();
}
if (dr["CorpFullName"] != DBNull.Value)
{
corporation.CorpFullName = Convert.ToString(dr["CorpFullName"]);
}
if (dr["CorpFullEName"] != DBNull.Value)
{
corporation.CorpFullEName = Convert.ToString(dr["CorpFullEName"]);
}
if (dr["CorpAddress"] != DBNull.Value)
{
corporation.CorpAddress = Convert.ToString(dr["CorpAddress"]);
}
if (dr["CorpEAddress"] != DBNull.Value)
{
corporation.CorpEAddress = Convert.ToString(dr["CorpEAddress"]);
}
if (dr["CorpTel"] != DBNull.Value)
{
corporation.CorpTel = Convert.ToString(dr["CorpTel"]);
}
if (dr["CorpFax"] != DBNull.Value)
{
corporation.CorpFax = Convert.ToString(dr["CorpFax"]);
}
if (dr["CorpZip"] != DBNull.Value)
{
corporation.CorpZip = Convert.ToString(dr["CorpZip"]);
}
if (dr["CorpType"] != DBNull.Value)
{
corporation.CorpType = Convert.ToInt32(dr["CorpType"]);
}
if (dr["CorpStatus"] != DBNull.Value)
{
corporation.CorpStatus = (Common.StatusEnum)Enum.Parse(typeof(Common.StatusEnum), dr["CorpStatus"].ToString());
}
if (dr["CreatorId"] != DBNull.Value)
{
corporation.CreatorId = Convert.ToInt32(dr["CreatorId"]);
}
if (dr["CreateTime"] != DBNull.Value)
{
corporation.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
}
if (dr["LastModifyId"] != DBNull.Value)
{
corporation.LastModifyId = Convert.ToInt32(dr["LastModifyId"]);
}
if (dr["LastModifyTime"] != DBNull.Value)
{
corporation.LastModifyTime = Convert.ToDateTime(dr["LastModifyTime"]);
}
corporations.Add(corporation);
}
result.AffectCount = dt.Rows.Count;
result.Message = "获取列表成功";
result.ResultStatus = 0;
result.ReturnValue = corporations;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return result;
}
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)
{
NFMT.Common.UserModel user = Utility.UserUtility.CurrentUser;
int pageIndex = 1, pageSize = 10;
string orderStr = string.Empty, whereStr = string.Empty;
int status = 0;
if (!string.IsNullOrEmpty(context.Request.QueryString["s"]))
{
if (!int.TryParse(context.Request.QueryString["s"], out status))
status = 0;
}
int applyPerson = 0;
if (!string.IsNullOrEmpty(context.Request.QueryString["a"]))
{
if (!int.TryParse(context.Request.QueryString["a"], out applyPerson))
applyPerson = 0;
}
DateTime fromDate = NFMT.Common.DefaultValue.DefaultTime;
if (!string.IsNullOrEmpty(context.Request.QueryString["f"]))
{
if (!DateTime.TryParse(context.Request.QueryString["f"], out fromDate))
fromDate = NFMT.Common.DefaultValue.DefaultTime;
}
DateTime toDate = NFMT.Common.DefaultValue.DefaultTime;
if (!string.IsNullOrEmpty(context.Request.QueryString["t"]))
{
if (!DateTime.TryParse(context.Request.QueryString["t"], 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.PledgeApplyBLL bll = new NFMT.WareHouse.BLL.PledgeApplyBLL();
NFMT.Common.SelectModel select = bll.GetSelectModel(pageIndex, pageSize, orderStr, applyPerson, status, fromDate, toDate);
NFMT.Common.IAuthority authority = new NFMT.Authority.CorpAuth();
authority.AuthColumnNames.Add("app.ApplyCorp");
NFMT.Common.ResultModel result = bll.Load(user, select,authority);
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);
}
