//批量删除
protected void btnDelete_Click(object sender, EventArgs e)
{
ChkAdminLevel("loan_company", DTEnums.ActionEnum.Delete.ToString()); //检查权限
int sucCount = 0;
int errorCount = 0;
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
var preDel = context.li_loaner_companies.FirstOrDefault(q => q.id == id);
if (preDel != null)
{
sucCount += 1;
context.li_loaner_companies.DeleteOnSubmit(preDel);
}
else
{
errorCount += 1;
}
}
}
try
{
context.SubmitChanges();
AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除企业信息" + sucCount + "条，失败" + errorCount + "条"); //记录日志
JscriptMsg("删除成功" + sucCount + "条，失败" + errorCount + "条！", Utils.CombUrlTxt("company_list.aspx", "keywords={0}", txtKeywords.Text), "Success");
}
catch (Exception ex)
{
JscriptMsg("删除失败！" + FriendlyDBError.HandleDeleteError(ex), Utils.CombUrlTxt("company_list.aspx", "keywords={0}", txtKeywords.Text), "Failure");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
int insCount = 0, delCount = 0;
var risk = risk_id == 0 ? new li_risks() : context.li_risks.First(r => r.id == risk_id);
var selectedLoaner = Convert.ToInt32(ddlLoaner.SelectedValue);
if (risk.loaner == null)
{
risk.loaner = selectedLoaner;
risk.last_update_time = DateTime.Now;
}
else if (risk.loaner != selectedLoaner) // 更换借款人后，之前的抵押物绑定需要全部删除
{
var dtRiskMortgages = context.li_risk_mortgage.Where(rm => rm.risk == risk_id).ToList();
delCount += dtRiskMortgages.Count;
context.li_risk_mortgage.DeleteAllOnSubmit(dtRiskMortgages);
risk.loaner = selectedLoaner;
risk.last_update_time = DateTime.Now;
}
for (int i = 0; i < rptList.Items.Count; i++)
{
int mortgageId = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (!cb.Enabled)
{
continue;
}
var riskMortgage = context.li_risk_mortgage.FirstOrDefault(rm => rm.risk == risk_id && rm.mortgage == mortgageId);
if (cb.Checked) // 绑定抵押物
{
if (riskMortgage != null)
{
continue;
}
riskMortgage = new li_risk_mortgage
{
mortgage = mortgageId,
//risk = risk_id,
last_update_time = DateTime.Now,
li_risks = risk
};
context.li_risk_mortgage.InsertOnSubmit(riskMortgage);
insCount += 1;
}
else // 解除绑定
{
if (riskMortgage == null)
{
continue;
}
context.li_risk_mortgage.DeleteOnSubmit(riskMortgage);
delCount += 1;
}
}
var action = project_id == "0" ? "Add" : "Edit";
try
{
context.SubmitChanges();
AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "绑定标的物 " + insCount + " 条，取消绑定 " + delCount + " 条"); //记录日志
JscriptMsg("绑定标的物 " + insCount + " 条，取消绑定 " + delCount + " 条！", Utils.CombUrlTxt("../project/project_edit_" + pageName + ".aspx", "action={0}&" +
"risk_id={1}&channel_id={2}&id={3}&show_risk={4}", action, risk.id.ToString(), channel_id, project_id, "true"), "Success");
}
catch (Exception ex)
{
JscriptMsg("设置失败！ " + FriendlyDBError.HandleDeleteError(ex), Utils.CombUrlTxt("../project/project_edit_" + pageName + ".aspx", "action={0}&" +
"risk_id={1}&channel_id={2}&id={3}&show_risk={4}", action, risk.id.ToString(), channel_id, project_id, "true"), "Failure");
}
}
