public int AddSensitiveWord(SensitiveWordEntity item)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into M_System_SensitiveWords(");
strSql.Append("SensitiveWords,StateTypeID,IsNeedRecheck,CreateUserID,CreateTime)");
strSql.Append(" values (");
strSql.Append("@SensitiveWords,@StateTypeID,@IsNeedRecheck,@CreateUserID,@CreateTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@SensitiveWords", SqlDbType.NVarChar, 100),
new SqlParameter("@StateTypeID", SqlDbType.Int, 4),
new SqlParameter("@IsNeedRecheck", SqlDbType.Bit, 1),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime)
};
parameters[0].Value = item.SensitiveWords;
parameters[1].Value = item.StateTypeID;
parameters[2].Value = item.IsNeedRecheck;
parameters[3].Value = item.CreateUserID;
parameters[4].Value = item.CreateTime;
object obj = SQlHelper.ExecuteScalar(SQlHelper.MyConnectStr, CommandType.Text, strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private SensitiveWordEntity GetEntityByDataRow(DataRow dr)
{
SensitiveWordEntity item = null;
if (dr != null)
{
item = new SensitiveWordEntity();
if (dr["SWID"] != null && dr["SWID"].ToString() != "")
{
item.SWID = int.Parse(dr["SWID"].ToString());
}
if (dr["SensitiveWords"] != null)
{
item.SensitiveWords = dr["SensitiveWords"].ToString();
}
if (dr["StateTypeID"] != null && dr["StateTypeID"].ToString() != "")
{
item.StateTypeID = int.Parse(dr["StateTypeID"].ToString());
}
if (dr["IsNeedRecheck"] != null && dr["IsNeedRecheck"].ToString() != "")
{
if ((dr["IsNeedRecheck"].ToString() == "1") || (dr["IsNeedRecheck"].ToString().ToLower() == "true"))
{
item.IsNeedRecheck = true;
}
else
{
item.IsNeedRecheck = false;
}
}
if (dr["CreateUserID"] != null && dr["CreateUserID"].ToString() != "")
{
item.CreateUserID = int.Parse(dr["CreateUserID"].ToString());
}
if (dr["CreateTime"] != null && dr["CreateTime"].ToString() != "")
{
item.CreateTime = DateTime.Parse(dr["CreateTime"].ToString());
}
}
return(item);
}
public List <SensitiveWordEntity> GetWordsList()
{
List <SensitiveWordEntity> list = null;
DataTable table = this.GetWordsTable();
if (table != null)
{
list = new List <SensitiveWordEntity>();
foreach (DataRow dr in table.Rows)
{
SensitiveWordEntity item = this.GetEntityByDataRow(dr);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public bool UpdateSensitiveWord(SensitiveWordEntity item)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update M_System_SensitiveWords set ");
strSql.Append("SensitiveWords=@SensitiveWords,");
strSql.Append("StateTypeID=@StateTypeID,");
strSql.Append("IsNeedRecheck=@IsNeedRecheck,");
strSql.Append("CreateUserID=@CreateUserID,");
strSql.Append("CreateTime=@CreateTime");
strSql.Append(" where SWID=@SWID");
SqlParameter[] parameters =
{
new SqlParameter("@SensitiveWords", SqlDbType.NVarChar, 100),
new SqlParameter("@StateTypeID", SqlDbType.Int, 4),
new SqlParameter("@IsNeedRecheck", SqlDbType.Bit, 1),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@SWID", SqlDbType.Int, 4)
};
parameters[0].Value = item.SensitiveWords;
parameters[1].Value = item.StateTypeID;
parameters[2].Value = item.IsNeedRecheck;
parameters[3].Value = item.CreateUserID;
parameters[4].Value = item.CreateTime;
parameters[5].Value = item.SWID;
if (SQlHelper.ExecuteNonQuery(SQlHelper.MyConnectStr, CommandType.Text, strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
public int AddSensitiveWord(SensitiveWordEntity item)
{
return(dao.AddSensitiveWord(item));
}
public bool UpdateSensitiveWord(SensitiveWordEntity item)
{
return(dao.UpdateSensitiveWord(item));
}
public string SensitiveWordEdit(HttpContext context)
{
int id = 0;
string sw = "";
bool st = false;
if (!string.IsNullOrEmpty(context.Request.Form["sw"]))
{
int.TryParse(context.Request.Form["id"], out id);
bool.TryParse(context.Request.Form["st"], out st);
sw = De(context.Request.Form["sw"]);
BCtrl_SensitiveWordSearch bll = new BCtrl_SensitiveWordSearch();
if (id > 0)
{
SensitiveWordEntity item = new SensitiveWordEntity()
{
SWID = id,
SensitiveWords = sw,
IsNeedRecheck = st,
StateTypeID = 1,
CreateTime = DateTime.Now,
CreateUserID = int.Parse(this.CurrentAdmin.Sys_UserID)
};
if (bll.UpdateSensitiveWord(item))
{
return(string.Format(G.JSON_OK_STATE_STRING, "修改成功"));
}
else
{
return(string.Format(G.JSON_ERROR_STATE_STRING, "修改失败"));
}
}
else
{
string[] sws = sw.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (sws != null)
{
bool success = true;
foreach (string _sw in sws)
{
SensitiveWordEntity item = new SensitiveWordEntity()
{
SWID = id,
SensitiveWords = _sw,
IsNeedRecheck = st,
StateTypeID = 1,
CreateTime = DateTime.Now,
CreateUserID = int.Parse(this.CurrentAdmin.Sys_UserID)
};
if (bll.AddSensitiveWord(item) == 0)
{
success = false;
break;
}
}
if (success)
{
return(string.Format(G.JSON_OK_STATE_STRING, "添加成功"));
}
else
{
return(string.Format(G.JSON_ERROR_STATE_STRING, "添加失败"));
}
}
else
{
return(string.Format(G.JSON_ERROR_STATE_STRING, "添加失败"));
}
}
}
else
{
return(string.Format(G.JSON_PMSERROR_STATE_STRING, "参数获取失败"));
}
}
