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