/// <summary>
/// 删除
/// </summary>
public void DeleteData(string id)
{
var msg = new ModJsonResult();
try
{
int result = bll.DeleteStatus(id);
if (result > 0)
{
msg.success = true;
//清空用户部门信息
string sql = "update Sys_Master set OrganizaId='' where OrganizaId='" + id + "';";
bll.ExecuteNonQueryByText(sql);
}
else
{
msg.success = false;
msg.msg = "操作失败";
}
}
catch (Exception ex)
{
msg.msg = "操作失败：" + ex.Message;
}
WriteJsonToPage(msg.ToString());
}
public void SaveDataAll()
{
var msg = new ModJsonResult();
try
{
string IdList = Request["IdList"].ToString(); //主键
string CheckoutType = Request["ComCheckoutType"].ToString(); //结账方式：0未设置 1月结 2日结
string PaymentType = Request["ComPaymentType"].ToString(); //付款方式：1支付宝 2工行 3农行
string AccountName = Request["AccountName"].ToString(); //名字
string AccountNum = Request["AccountNum"].ToString(); //账号
string sql = "update Sys_Company set CheckoutType=" + CheckoutType + ",PaymentType=" + PaymentType + ",AccountName='" + AccountName + "',AccountNum='" + AccountNum + "' where Id in (" + IdList + ")";
int result = bll.ExecuteNonQueryByText(sql);
if (result > 0)
{
msg.success = true;
}
else
{
msg.success = false;
msg.msg = "操作失败";
}
}
catch (Exception)
{
json.msg = "保存失败！";
json.success = false;
}
WriteJsonToPage(json.ToString());
}
/// <summary>
/// 删除
/// </summary>
public void DeleteData(string id)
{
var msg = new ModJsonResult();
try
{
int result = bll.DeleteStatus(id);
if (result > 0)
{
msg.success = true;
//同步其他操作
StringBuilder sb = new StringBuilder();
//同步用户
sb.Append("update Sys_Master set Status=" + (int)StatusEnum.除 + " where Cid='" + id + "';");
sb.AppendLine();
//同步设备
sb.Append("update Sys_Appointed set Status=" + (int)StatusEnum.除 + " where Cid=''" + id + "';");
sb.AppendLine();
//同步巡检记录
sb.Append("delete from Sys_AppointCheckNotes where CId=''" + id + "';");
sb.AppendLine();
//同步关联单位
sb.Append("delete from Sys_CompanyCognate where CId=''" + id + "';");
sb.AppendLine();
bll.ExecuteNonQueryByText(sb.ToString());
}
else
{
msg.success = false;
msg.msg = "操作失败";
}
}
catch (Exception ex)
{
msg.msg = "操作失败：" + ex.Message;
}
WriteJsonToPage(msg.ToString());
}