private void Check_AuditReward(HttpContext context)
{
int achieveId = RequestHelper.int_transfer(context.Request, "AchieveId");
int Id = RequestHelper.int_transfer(context.Request, "Id");
TPM_AuditReward model = rauditbll.GetEntityById(Id).retData as TPM_AuditReward;
model.Status = Convert.ToByte(context.Request["Status"]);
jsonModel = rauditbll.Update(model);
}
public int[] Oper_AuditAllotReward(TPM_AuditReward audModel, List <TPM_AllotReward> items)
{
int result = 0;
List <SqlParameter> pms = new List <SqlParameter>();
StringBuilder str = new StringBuilder();
pms.Add(new SqlParameter("@Acheive_Id", audModel.Acheive_Id));
pms.Add(new SqlParameter("@RewardBatch_Id", audModel.RewardBatch_Id));
string sql = "select Id from TPM_AuditReward where Acheive_Id=@Acheive_Id and RewardBatch_Id=@RewardBatch_Id and IsDelete=0";
int auditid = Convert.ToInt32(SQLHelp.ExecuteScalar(sql, CommandType.Text, pms.ToArray()));
if (auditid > 0)
{
pms.Add(new SqlParameter("@Status", audModel.Status));
str.Append("update TPM_AuditReward set Status=@Status where Id=@Audit_Id;");
}
else
{
auditid = new TPM_AuditRewardDal().Add(audModel);
}
pms.Add(new SqlParameter("@Audit_Id", auditid));
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 Audit_Id=@Audit_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(Audit_Id,AllotMoney,RewardUser_Id,CreateUID)
values(@Audit_Id,@AllotMoney" + i + ",@RewardUser_Id" + i + ",@CreateUID" + i + ");");
}
}
result = SQLHelp.ExecuteNonQuery(str.ToString(), CommandType.Text, pms.ToArray());
}
return(new int[] { result, auditid });
}
private void Oper_AuditAllotReward(HttpContext context)
{
try
{
TPM_AuditReward audModel = new TPM_AuditReward();
audModel.Acheive_Id = RequestHelper.int_transfer(context.Request, "Acheive_Id");
audModel.RewardBatch_Id = RequestHelper.int_transfer(context.Request, "RewardBatch_Id");
audModel.Status = Convert.ToByte(context.Request["Status"]);
audModel.CreateUID = RequestHelper.string_transfer(context.Request, "CreateUID");
string allotUser = RequestHelper.string_transfer(context.Request, "AllotUser");
List <TPM_AllotReward> allotlist = new List <TPM_AllotReward>();
if (!string.IsNullOrEmpty(allotUser))
{
allotlist = JsonConvert.DeserializeObject <List <TPM_AllotReward> >(allotUser);
}
jsonModel = bll.Oper_AuditAllotReward(audModel, allotlist);
if (jsonModel.errNum == 0)
{
bll.Edit_AchieveStatus(Convert.ToInt32(audModel.Acheive_Id), 10);
string add_Path = RequestHelper.string_transfer(context.Request, "Add_Path");
string edit_PathId = RequestHelper.string_transfer(context.Request, "Edit_PathId");
if (!string.IsNullOrEmpty(add_Path) || !string.IsNullOrEmpty(edit_PathId))
{
List <Sys_Document> pathlist = new List <Sys_Document>();
if (!string.IsNullOrEmpty(add_Path))
{
pathlist = JsonConvert.DeserializeObject <List <Sys_Document> >(add_Path);
}
new Sys_DocumentService().OperDocument(pathlist, edit_PathId, Convert.ToInt32(jsonModel.retData));
}
}
}
catch (Exception ex)
{
jsonModel = new JsonModel()
{
errNum = 400,
errMsg = ex.Message,
retData = ""
};
LogService.WriteErrorLog(ex.Message);
}
}
public JsonModel Oper_AuditAllotReward(TPM_AuditReward audModel, List <TPM_AllotReward> items)
{
JsonModel jsonModel = new JsonModel();
try
{
int[] retInfo = new TPM_AllotRewardDal().Oper_AuditAllotReward(audModel, items);
if (retInfo[0] > 0)
{
jsonModel = new JsonModel()
{
errNum = 0,
errMsg = "success",
retData = retInfo[1]
};
}
else
{
jsonModel = new JsonModel()
{
errNum = 999,
errMsg = "数据更新失败",
retData = ""
};
}
return(jsonModel);
}
catch (Exception ex)
{
jsonModel = new JsonModel()
{
errNum = 400,
errMsg = ex.Message,
retData = ""
};
return(jsonModel);
}
}
