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); } }