protected override IModel CreateModel(SqlDataReader dr)
{
SupBill supbill = new SupBill();
int indexSupBillId = dr.GetOrdinal("SupBillId");
supbill.SupBillId = Convert.ToInt32(dr[indexSupBillId]);
int indexBillDate = dr.GetOrdinal("BillDate");
if (dr[indexBillDate] != DBNull.Value)
{
supbill.BillDate = Convert.ToDateTime(dr[indexBillDate]);
}
int indexPayDate = dr.GetOrdinal("PayDate");
if (dr[indexPayDate] != DBNull.Value)
{
supbill.PayDate = Convert.ToDateTime(dr[indexPayDate]);
}
int indexPayCity = dr.GetOrdinal("PayCity");
if (dr[indexPayCity] != DBNull.Value)
{
supbill.PayCity = Convert.ToInt32(dr[indexPayCity]);
}
int indexSupId = dr.GetOrdinal("SupId");
if (dr[indexSupId] != DBNull.Value)
{
supbill.SupId = Convert.ToInt32(dr[indexSupId]);
}
int indexBillPensionIns = dr.GetOrdinal("BillPensionIns");
if (dr[indexBillPensionIns] != DBNull.Value)
{
supbill.BillPensionIns = Convert.ToDecimal(dr[indexBillPensionIns]);
}
int indexBillMedicalIns = dr.GetOrdinal("BillMedicalIns");
if (dr[indexBillMedicalIns] != DBNull.Value)
{
supbill.BillMedicalIns = Convert.ToDecimal(dr[indexBillMedicalIns]);
}
int indexBillUnempIns = dr.GetOrdinal("BillUnempIns");
if (dr[indexBillUnempIns] != DBNull.Value)
{
supbill.BillUnempIns = Convert.ToDecimal(dr[indexBillUnempIns]);
}
int indexBillInjuryIns = dr.GetOrdinal("BillInjuryIns");
if (dr[indexBillInjuryIns] != DBNull.Value)
{
supbill.BillInjuryIns = Convert.ToDecimal(dr[indexBillInjuryIns]);
}
int indexBillBirthIns = dr.GetOrdinal("BillBirthIns");
if (dr[indexBillBirthIns] != DBNull.Value)
{
supbill.BillBirthIns = Convert.ToDecimal(dr[indexBillBirthIns]);
}
int indexBillDisabledIns = dr.GetOrdinal("BillDisabledIns");
if (dr[indexBillDisabledIns] != DBNull.Value)
{
supbill.BillDisabledIns = Convert.ToDecimal(dr[indexBillDisabledIns]);
}
int indexBillIllnessIns = dr.GetOrdinal("BillIllnessIns");
if (dr[indexBillIllnessIns] != DBNull.Value)
{
supbill.BillIllnessIns = Convert.ToDecimal(dr[indexBillIllnessIns]);
}
int indexBillHeatAmount = dr.GetOrdinal("BillHeatAmount");
if (dr[indexBillHeatAmount] != DBNull.Value)
{
supbill.BillHeatAmount = Convert.ToDecimal(dr[indexBillHeatAmount]);
}
int indexBillHouseFund = dr.GetOrdinal("BillHouseFund");
if (dr[indexBillHouseFund] != DBNull.Value)
{
supbill.BillHouseFund = Convert.ToDecimal(dr[indexBillHouseFund]);
}
int indexBillRepInjuryIns = dr.GetOrdinal("BillRepInjuryIns");
if (dr[indexBillRepInjuryIns] != DBNull.Value)
{
supbill.BillRepInjuryIns = Convert.ToDecimal(dr[indexBillRepInjuryIns]);
}
int indexCorpOtherPay = dr.GetOrdinal("CorpOtherPay");
if (dr[indexCorpOtherPay] != DBNull.Value)
{
supbill.CorpOtherPay = Convert.ToDecimal(dr[indexCorpOtherPay]);
}
int indexEmpOtherPay = dr.GetOrdinal("EmpOtherPay");
if (dr[indexEmpOtherPay] != DBNull.Value)
{
supbill.EmpOtherPay = Convert.ToDecimal(dr[indexEmpOtherPay]);
}
int indexServiceAmount = dr.GetOrdinal("ServiceAmount");
if (dr[indexServiceAmount] != DBNull.Value)
{
supbill.ServiceAmount = Convert.ToDecimal(dr[indexServiceAmount]);
}
int indexTotalAmount = dr.GetOrdinal("TotalAmount");
if (dr[indexTotalAmount] != DBNull.Value)
{
supbill.TotalAmount = Convert.ToDecimal(dr[indexTotalAmount]);
}
int indexMemo = dr.GetOrdinal("Memo");
if (dr[indexMemo] != DBNull.Value)
{
supbill.Memo = Convert.ToString(dr[indexMemo]);
}
int indexSupBillStatus = dr.GetOrdinal("SupBillStatus");
if (dr[indexSupBillStatus] != DBNull.Value)
{
supbill.SupBillStatus = Convert.ToInt32(dr[indexSupBillStatus]);
}
int indexCreatorId = dr.GetOrdinal("CreatorId");
if (dr[indexCreatorId] != DBNull.Value)
{
supbill.CreatorId = Convert.ToInt32(dr[indexCreatorId]);
}
int indexCreateTime = dr.GetOrdinal("CreateTime");
if (dr[indexCreateTime] != DBNull.Value)
{
supbill.CreateTime = Convert.ToDateTime(dr[indexCreateTime]);
}
int indexLastModifyId = dr.GetOrdinal("LastModifyId");
if (dr[indexLastModifyId] != DBNull.Value)
{
supbill.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]);
}
int indexLastModifyTime = dr.GetOrdinal("LastModifyTime");
if (dr[indexLastModifyTime] != DBNull.Value)
{
supbill.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]);
}
return(supbill);
}
protected override List <SqlParameter> CreateInsertParameters(IModel obj, ref SqlParameter returnValue)
{
SupBill usr_supbill = (SupBill)obj;
List <SqlParameter> paras = new List <SqlParameter>();
returnValue.Direction = ParameterDirection.Output;
returnValue.SqlDbType = SqlDbType.Int;
returnValue.ParameterName = "@SupBillId";
returnValue.Size = 4;
paras.Add(returnValue);
SqlParameter billdatepara = new SqlParameter("@BillDate", SqlDbType.DateTime, 8);
billdatepara.Value = usr_supbill.BillDate;
paras.Add(billdatepara);
SqlParameter paydatepara = new SqlParameter("@PayDate", SqlDbType.DateTime, 8);
paydatepara.Value = usr_supbill.PayDate;
paras.Add(paydatepara);
SqlParameter paycitypara = new SqlParameter("@PayCity", SqlDbType.Int, 4);
paycitypara.Value = usr_supbill.PayCity;
paras.Add(paycitypara);
SqlParameter supidpara = new SqlParameter("@SupId", SqlDbType.Int, 4);
supidpara.Value = usr_supbill.SupId;
paras.Add(supidpara);
SqlParameter billpensioninspara = new SqlParameter("@BillPensionIns", SqlDbType.Decimal, 9);
billpensioninspara.Value = usr_supbill.BillPensionIns;
paras.Add(billpensioninspara);
SqlParameter billmedicalinspara = new SqlParameter("@BillMedicalIns", SqlDbType.Decimal, 9);
billmedicalinspara.Value = usr_supbill.BillMedicalIns;
paras.Add(billmedicalinspara);
SqlParameter billunempinspara = new SqlParameter("@BillUnempIns", SqlDbType.Decimal, 9);
billunempinspara.Value = usr_supbill.BillUnempIns;
paras.Add(billunempinspara);
SqlParameter billinjuryinspara = new SqlParameter("@BillInjuryIns", SqlDbType.Decimal, 9);
billinjuryinspara.Value = usr_supbill.BillInjuryIns;
paras.Add(billinjuryinspara);
SqlParameter billbirthinspara = new SqlParameter("@BillBirthIns", SqlDbType.Decimal, 9);
billbirthinspara.Value = usr_supbill.BillBirthIns;
paras.Add(billbirthinspara);
SqlParameter billdisabledinspara = new SqlParameter("@BillDisabledIns", SqlDbType.Decimal, 9);
billdisabledinspara.Value = usr_supbill.BillDisabledIns;
paras.Add(billdisabledinspara);
SqlParameter billillnessinspara = new SqlParameter("@BillIllnessIns", SqlDbType.Decimal, 9);
billillnessinspara.Value = usr_supbill.BillIllnessIns;
paras.Add(billillnessinspara);
SqlParameter billheatamountpara = new SqlParameter("@BillHeatAmount", SqlDbType.Decimal, 9);
billheatamountpara.Value = usr_supbill.BillHeatAmount;
paras.Add(billheatamountpara);
SqlParameter billhousefundpara = new SqlParameter("@BillHouseFund", SqlDbType.Decimal, 9);
billhousefundpara.Value = usr_supbill.BillHouseFund;
paras.Add(billhousefundpara);
SqlParameter billrepinjuryinspara = new SqlParameter("@BillRepInjuryIns", SqlDbType.Decimal, 9);
billrepinjuryinspara.Value = usr_supbill.BillRepInjuryIns;
paras.Add(billrepinjuryinspara);
SqlParameter corpotherpaypara = new SqlParameter("@CorpOtherPay", SqlDbType.Decimal, 9);
corpotherpaypara.Value = usr_supbill.CorpOtherPay;
paras.Add(corpotherpaypara);
SqlParameter empotherpaypara = new SqlParameter("@EmpOtherPay", SqlDbType.Decimal, 9);
empotherpaypara.Value = usr_supbill.EmpOtherPay;
paras.Add(empotherpaypara);
SqlParameter serviceamountpara = new SqlParameter("@ServiceAmount", SqlDbType.Decimal, 9);
serviceamountpara.Value = usr_supbill.ServiceAmount;
paras.Add(serviceamountpara);
SqlParameter totalamountpara = new SqlParameter("@TotalAmount", SqlDbType.Decimal, 9);
totalamountpara.Value = usr_supbill.TotalAmount;
paras.Add(totalamountpara);
if (!string.IsNullOrEmpty(usr_supbill.Memo))
{
SqlParameter memopara = new SqlParameter("@Memo", SqlDbType.VarChar, 50);
memopara.Value = usr_supbill.Memo;
paras.Add(memopara);
}
SqlParameter supbillstatuspara = new SqlParameter("@SupBillStatus", SqlDbType.Int, 4);
supbillstatuspara.Value = usr_supbill.SupBillStatus;
paras.Add(supbillstatuspara);
SqlParameter creatoridpara = new SqlParameter("@CreatorId", SqlDbType.Int, 4);
creatoridpara.Value = obj.CreatorId;
paras.Add(creatoridpara);
return(paras);
}
public ActionResult Insert(SupBill supBill, SupBillDetail[] details)
{
supBill.SupBillStatus = (int)StatusEnum.已完成;
//string json = Newtonsoft.Json.JsonConvert.SerializeObject(employee);
SupBillBLL supBillBLL = new SupBillBLL();
SupBillDetailBLL detailBLL = new SupBillDetailBLL();
//获取企业账单
ResultModel <SupBill> supBillResult = supBillBLL.LoadSupBills(supBill.SupId);
if (supBillResult.ResultStatus != 0)
{
return(Json(ResultModel.GenericResult <SupBill>(supBillResult)));
}
List <SupBill> rtnSupBill = supBillResult.ReturnValues;
if (rtnSupBill == null)
{
return(Json(new ResultModel("获取账单列表失败")));
}
int supBillCount = rtnSupBill.Count();
if (supBillCount > 0)
{
return(Content(JsUtility.WarmAlert("供应商本月账单已生成", redirectUrl)));
}
//新增账单
ResultModel result = supBillBLL.Insert(supBill);
if (result.ResultStatus != 0)
{
return(Json(result));
}
int supBillId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out supBillId) || supBillId <= 0)
{
return(Content("账单新增失败"));
}
//新增制单明细
foreach (SupBillDetail detail in details)
{
detail.SupBillId = supBillId;
detail.DetailStatus = (int)StatusEnum.已完成;
result = detailBLL.Insert(detail);
if (result.ResultStatus != 0)
{
return(Json(result));
}
}
result.Message = "账单新增成功";
result.ReturnValue = "";
result.ResultStatus = 0;
return(Json(result));
}
