/// <summary> /// 修改 /// </summary> /// <param name="context"></param> private void Upt(HttpContext context) { entity.ResponseResult result = new entity.ResponseResult(); try { Models.CustomForm model = new Models.CustomForm(); model.ID = Convert.ToInt32(context.Request.Form["ID"]); model.Name = context.Request.Form["Name"]; List <entity.Fields> fields = JsonConvert.DeserializeObject <List <entity.Fields> >(context.Request.Form["Fields"]); model.Fields = JsonConvert.SerializeObject(fields); model.SQL = context.Request.Form["SQL"]; model.ModuleID = context.Request.Form["ModuleID"]; if (string.IsNullOrWhiteSpace(model.Name) || fields.Count == 0 || string.IsNullOrWhiteSpace(model.SQL) || model.ID == 0) { result.IsSuccess = false; result.Message = "自定义内容,全部都为必填项。"; } else { if (model.SQL.ToLower().Trim().StartsWith("select") == false) { result.IsSuccess = false; result.Message = "SQL语句只能为select语句。"; } else { string validSqlMsg = ""; bool isValidSql = ValidateSQL(model.SQL, fields, ref validSqlMsg); if (!isValidSql) { result.IsSuccess = false; result.Message = validSqlMsg; } else { int flag = CustomFormDal.GetCustomFormDAL.UpdateCustomForm(model); if (flag > 0) { result.IsSuccess = true; result.Message = "修改成功。"; } else { result.IsSuccess = false; result.Message = "修改失败,请稍后重试。"; } } } } } catch { result.IsSuccess = false; result.Message = "修改失败,请稍后重试。"; } context.Response.Write(JsonConvert.SerializeObject(result)); }
/// <summary> /// 批量删除 /// </summary> /// <param name="context"></param> private void Det(HttpContext context) { entity.ResponseResult result = new entity.ResponseResult(); int[] ids = JsonConvert.DeserializeObject <int[]>(context.Request.Form["ids"]); bool flag = DAL.CustomFormDal.GetCustomFormDAL.BatchDelete(ids); if (flag) { result.IsSuccess = true; result.Message = "删除成功"; } else { result.IsSuccess = false; result.Message = "删除失败,请稍后重试"; } context.Response.Write(JsonConvert.SerializeObject(result)); }