public int Oper_AuditAllotReward(TPM_RewardBatchDetail audModel, List <TPM_AllotReward> items)
{
int result = 0;
List <SqlParameter> pms = new List <SqlParameter>();
StringBuilder str = new StringBuilder();
pms.Add(new SqlParameter("@BatchDetail_Id", audModel.Id));
if (items.Count() > 0)
{
for (int i = 0; i < items.Count; i++)
{
TPM_AllotReward item = items[i];
if (item.AllotMoney == null)
{
pms.Add(new SqlParameter("@AllotMoney" + i, DBNull.Value));
}
else
{
pms.Add(new SqlParameter("@AllotMoney" + i, item.AllotMoney));
}
pms.Add(new SqlParameter("@RewardUser_Id" + i, item.RewardUser_Id));
pms.Add(new SqlParameter("@CreateUID" + i, item.CreateUID));
pms.Add(new SqlParameter("@EditUID" + i, item.CreateUID));
string allotsql = "select Id from TPM_AllotReward where BatchDetail_Id=@BatchDetail_Id and RewardUser_Id=@RewardUser_Id" + i + " and IsDelete=0";
int allotid = Convert.ToInt32(SQLHelp.ExecuteScalar(allotsql, CommandType.Text, pms.ToArray()));
if (allotid > 0)
{
pms.Add(new SqlParameter("@Id" + i, allotid));
str.Append("update TPM_AllotReward set AllotMoney=@AllotMoney" + i + ",EditUID=@EditUID" + i + " where Id=@Id" + i + ";");
}
else
{
str.Append(@"insert into TPM_AllotReward(BatchDetail_Id,AllotMoney,RewardUser_Id,CreateUID)
values(@BatchDetail_Id,@AllotMoney" + i + ",@RewardUser_Id" + i + ",@CreateUID" + i + ");");
}
}
result = SQLHelp.ExecuteNonQuery(str.ToString(), CommandType.Text, pms.ToArray());
}
return(result);
}
public JsonModel Oper_AuditAllotReward(TPM_RewardBatchDetail audModel, List <TPM_AllotReward> items)
{
JsonModel jsonModel = new JsonModel();
try
{
int result = new TPM_AllotRewardDal().Oper_AuditAllotReward(audModel, items);
if (result > 0)
{
jsonModel = new JsonModel()
{
errNum = 0,
errMsg = "success",
retData = ""
};
}
else
{
jsonModel = new JsonModel()
{
errNum = 999,
errMsg = "数据更新失败",
retData = ""
};
}
return(jsonModel);
}
catch (Exception ex)
{
jsonModel = new JsonModel()
{
errNum = 400,
errMsg = ex.Message,
retData = ""
};
return(jsonModel);
}
}
