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