public AuditRuleModel DataRowToModel(DataRow row) { AuditRuleModel model = new AuditRuleModel(); if (row == null) { return(model); } if (row["AuditRuleID"] != null && row["AuditRuleID"].ToString() != "") { model.AuditRuleID = int.Parse(row["AuditRuleID"].ToString()); } if (row["Area"] != null && row["Area"].ToString() != "") { model.Area = row["Area"].ToString(); } if (row["Rule"] != null && row["Rule"].ToString() != "") { model.Rule = row["Rule"].ToString(); } if (row["Status"] != null && row["Status"].ToString() != "") { model.Status = int.Parse(row["Status"].ToString()); } return(model); }
public int Insert(AuditRuleModel model) { string sql = "INSERT INTO [AuditRule]([Area],[Rule],[Status]) VALUES(@Area,@Rule,@Status)"; SqlParameter[] parameters = { new SqlParameter("@Area", SqlDbType.NVarChar), new SqlParameter("@Rule", SqlDbType.NVarChar), new SqlParameter("@Status", SqlDbType.Int), }; parameters[0].Value = model.Area == null ? (object)DBNull.Value : model.Area; parameters[1].Value = model.Rule == null ? (object)DBNull.Value : model.Rule; parameters[2].Value = model.Status == null ? (object)DBNull.Value : model.Status; return(DbHelperSQL.ExecuteSql(sql, parameters)); }
public JsonResult Update(AuditRuleViewModel model) { try { AuditRuleModel auditRuleModel = auditRuleBll.GetModel(model.AuditRuleID); auditRuleModel.Area = model.Area; auditRuleModel.Rule = model.Rule; auditRuleModel.Status = model.Status; auditRuleBll.Update(auditRuleModel); return(Json(new { code = 200 })); } catch (Exception ex) { return(Json(new { code = 500, msg = ex.Message })); } }
public JsonResult Insert(AuditRuleViewModel model) { try { AuditRuleModel auditRuleModel = new AuditRuleModel(); auditRuleModel.Area = model.Area; auditRuleModel.Rule = model.Rule; auditRuleModel.Status = model.Status; auditRuleBll.Insert(auditRuleModel); return(Json(new { code = 200 })); } catch (Exception ex) { return(Json(new { code = 500, msg = ex.Message })); } }
public int Update(AuditRuleModel model) { string sql = "UPDATE [AuditRule] SET [Area]=@Area,[Rule]=@Rule,[Status]=@Status WHERE AuditRuleID=@AuditRuleID"; SqlParameter[] parameters = { new SqlParameter("@AuditRuleID", SqlDbType.Int), new SqlParameter("@Area", SqlDbType.NVarChar), new SqlParameter("@Rule", SqlDbType.NVarChar), new SqlParameter("@Status", SqlDbType.Int), }; parameters[0].Value = model.AuditRuleID; parameters[1].Value = model.Area == null ? (object)DBNull.Value : model.Area; parameters[2].Value = model.Rule == null ? (object)DBNull.Value : model.Rule; parameters[3].Value = model.Status == null ? (object)DBNull.Value : model.Status; return(DbHelperSQL.ExecuteSql(sql, parameters)); }
public JsonResult Delete(int auditRuleID) { try { AuditRuleModel model = auditRuleBll.GetModel(auditRuleID); if (model != null) { auditRuleBll.Delete(auditRuleID); } else { return(Json(new { code = 500, msg = "parms is null" })); } return(Json(new { code = 200 })); } catch (Exception ex) { return(Json(new { code = 500, msg = ex.Message })); } }
public int Update(AuditRuleModel model) { return(dal.Update(model)); }
public int Insert(AuditRuleModel model) { return(dal.Insert(model)); }