/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Edit(string id)
{
var model = new SysKeyword();
if (!string.IsNullOrEmpty(id))
{
model = _sysKeywordService.GetById(id);
}
return(View(model));
}
public async Task <ActionResult> Edit(string id, SysKeyword model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
_sysKeywordService.Save(id, model);
await _iUnitOfWork.CommitAsync();
return(new EditSuccessResult(id));
}
/// <summary>
/// DataTable转换为list
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
protected static List <SysKeyword> DataTableToList(DataTable dt)
{
List <SysKeyword> Ms = new List <SysKeyword>();
for (int i = 0; i < dt.Rows.Count; i++)
{
SysKeyword M = new SysKeyword();
M.Id = dt.Rows[i]["ID"].ToInt32();
M.Keyword = dt.Rows[i]["Keyword"].ToString();
M.ModelID = dt.Rows[i]["ModelID"].ToInt32();
M.ClickCount = dt.Rows[i]["ClickCount"].ToInt32();
Ms.Add(M);
}
return(Ms);
}
/// <summary>
/// 创建系统关键词
/// </summary>
/// <param name="ModelID"></param>
/// <param name="key"></param>
public static void InsertKeyWords(int ModelID, string key)
{
SysKeyword k = SysKeywordView.Find(string.Format("ModelID={0} and Keyword=N'{1}'", ModelID, key));
if (k.Id <= 0)
{
//不存在
k.ModelID = ModelID;
k.Keyword = key;
k.ClickCount = 0;
SysKeywordView.Insert(k);
}
else
{
k.ClickCount++;
SysKeywordView.Update(k);
}
}
/// <summary>
/// 根据条件语句取得第一个实体
/// </summary>
/// <param name="m_where">条件语句，不包含“where”</param>
/// <returns></returns>
public static SysKeyword Find(string m_where)
{
IDbHelper Sql = GetHelper();
SysKeyword M = new SysKeyword();
DbDataReader Rs = Sql.ExecuteReader(CommandType.Text, "select [ID],[Keyword],[ModelID],[ClickCount] from [SysKeyword] where " + m_where, true);
if (!Rs.Read())
{
M.Id = 0;
}
else
{
M.Id = Rs["ID"].ToInt32();
M.Keyword = Rs["Keyword"].ToString();
M.ModelID = Rs["ModelID"].ToInt32();
M.ClickCount = Rs["ClickCount"].ToInt32();
}
Rs.Close();
Rs = null;
return(M);
}
/// <summary>
/// 将修改过的实体修改到数据库
/// </summary>
/// <param name="M">赋值后的实体</param>
/// <returns></returns>
public static int Update(SysKeyword M)
{
IDbHelper Sql = GetHelper();
StringBuilder sb = new StringBuilder();
sb.Append("update [SysKeyword] set ");
sb.Append("[Keyword]=N'" + M.Keyword + "'");
sb.Append(",");
sb.Append("[ModelID]=" + M.ModelID.ToS());
sb.Append(",");
sb.Append("[ClickCount]=" + M.ClickCount.ToS());
sb.Append(" where Id='" + M.Id + "'");
sb.Append("");
if (DataBase.CmsDbType == DataBase.DbType.SqlServer)
{
sb.Append(";select @@ROWCOUNT");
}
if (DataBase.CmsDbType == DataBase.DbType.SQLite)
{
sb.Append(";select 0");
}
if (DataBase.CmsDbType == DataBase.DbType.MySql)
{
sb.Append(";SELECT ROW_COUNT()");
}
if (DataBase.CmsDbType == DataBase.DbType.Access)
{
sb.Append(";select 0");
}
if (DataBase.CmsDbType == DataBase.DbType.Oracle)
{
sb.Append(";select SQL%ROWCOUNT");
}
return(Sql.ExecuteScalar(CommandType.Text, sb.ToString()).ToInt32());
}
/// <summary>
/// 将数据插入表
/// </summary>
/// <param name="M">赋值后的实体</param>
/// <returns></returns>
public static void Insert(SysKeyword M)
{
IDbHelper Sql = GetHelper();
StringBuilder sb = new StringBuilder();
sb.Append("insert into [SysKeyword]([Keyword],[ModelID],[ClickCount]) values(");
sb.Append("N'" + M.Keyword + "'");
sb.Append(",");
sb.Append(M.ModelID.ToS());
sb.Append(",");
sb.Append(M.ClickCount.ToS());
sb.Append(")");
if (DataBase.CmsDbType == DataBase.DbType.SqlServer)
{
sb.Append(";select @@Identity");
}
if (DataBase.CmsDbType == DataBase.DbType.SQLite)
{
sb.Append(";select last_insert_rowid()");
}
if (DataBase.CmsDbType == DataBase.DbType.MySql)
{
sb.Append(";select LAST_INSERT_ID()");
}
if (DataBase.CmsDbType == DataBase.DbType.Access)
{
sb.Append(";select max(ID) from SysKeyword");
}
if (DataBase.CmsDbType == DataBase.DbType.Oracle)
{
sb.Append(";select LAST_INSERT_ID()");
}
M.Id = Sql.ExecuteScalar(CommandType.Text, sb.ToString()).ToInt32();
}
/// <summary>
/// 创建系统关键词
/// </summary>
/// <param name="ModelID"></param>
/// <param name="key"></param>
public static void InsertKeyWords(int ModelID, string key)
{
using (DataEntities ent = new DataEntities())
{
var ks = //SysKeywordView.Find(string.Format("ModelID={0} and Keyword=N'{1}'", ModelID, key));
(from l in ent.SysKeyword where l.ModelID == ModelID && l.Keyword == key select l).ToList();
if (ks.Count == 0)
{
//不存在
SysKeyword k = new SysKeyword();
k.ModelID = ModelID;
k.Keyword = key;
k.ClickCount = 0;
ent.AddToSysKeyword(k);
}
else
{
SysKeyword k = ks.FirstOrDefault();
k.ClickCount++;
}
ks.FirstOrDefault().ClearListCache();
ent.SaveChanges();
}
}
public static SysKeyword CreateSysKeyword(int id)
{
SysKeyword sysKeyword = new SysKeyword();
sysKeyword.ID = id;
return sysKeyword;
}
public void AddToSysKeyword(SysKeyword sysKeyword)
{
base.AddObject("SysKeyword", sysKeyword);
}
