public ActionResult EditInfo(Model.SettlementSituation SettlementSituation)
{
Business.Sys_SettlementSituation Sys_SettlementSituation = new Business.Sys_SettlementSituation();
if (Sys_SettlementSituation.UpdateInfo(SettlementSituation))
{
return(Content("1"));
}
return(Content("0"));
}
public ActionResult Edit()
{
Business.Sys_SettlementSituation Sys_SettlementSituation = new Business.Sys_SettlementSituation();
Model.SettlementSituation SettlementSituation = Sys_SettlementSituation.GetInfo(Request["ID"]);
ViewData["GetPayTypeList"] = GetPayTypeList(SettlementSituation.PayType);
ViewData["GetBillTypeTypeList"] = GetBillTypeTypeList(SettlementSituation.BillType);
ViewData["GetIsrenewTypeList"] = GetIsrenewTypeList(SettlementSituation.Isrenew);
ViewData["GetWhatMonthTypeList"] = GetWhatMonthTypeList();
return(View(SettlementSituation));
}
/// <summary>
/// 添加一行记录
/// </summary>
/// <param name="SettlementSituation"></param>
/// <returns></returns>
public bool AddInfo(Model.SettlementSituation SettlementSituation)
{
const string sql =
@"INSERT INTO SettlementSituation(BillingInformation,MonthlyRent,PayType,AmountPayable,AmountPaid,
BillType,Remark,WhatMonth,SettlementDay,CustomerAbbreviation,Isrenew,CompanyName)
VALUES(@BillingInformation,@MonthlyRent,@PayType,@AmountPayable,@AmountPaid,@BillType,
@Remark,@WhatMonth,@SettlementDay,@CustomerAbbreviation,@Isrenew,@CompanyName)";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
SettlementSituation.BillingInformation,
SettlementSituation.MonthlyRent,
SettlementSituation.PayType,
SettlementSituation.AmountPayable,
SettlementSituation.AmountPaid,
SettlementSituation.BillType,
SettlementSituation.Remark,
SettlementSituation.WhatMonth,
SettlementSituation.SettlementDay,
SettlementSituation.CustomerAbbreviation,
SettlementSituation.Isrenew,
SettlementSituation.CompanyName,
})));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="SettlementSituation"></param>
/// <returns></returns>
public bool UpdateInfo(Model.SettlementSituation SettlementSituation)
{
const string sql =
@"UPDATE SettlementSituation SET BillingInformation=@BillingInformation,MonthlyRent=@MonthlyRent,PayType=@PayType,AmountPayable=@AmountPayable,AmountPaid=@AmountPaid,
BillType=@BillType,Remark=@Remark,WhatMonth=@WhatMonth,SettlementDay=@SettlementDay,CustomerAbbreviation=@CustomerAbbreviation,
Isrenew=@Isrenew,CompanyName=@CompanyName where id=@ID";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
SettlementSituation.BillingInformation,
SettlementSituation.MonthlyRent,
SettlementSituation.PayType,
SettlementSituation.AmountPayable,
SettlementSituation.AmountPaid,
SettlementSituation.BillType,
SettlementSituation.Remark,
SettlementSituation.WhatMonth,
SettlementSituation.SettlementDay,
SettlementSituation.CustomerAbbreviation,
SettlementSituation.Isrenew,
SettlementSituation.CompanyName,
SettlementSituation.ID,
})));
}
