/// <summary>
/// 根据条件语句取得第一个实体
/// </summary>
/// <param name="m_where">条件语句，不包含“where”</param>
/// <returns></returns>
public static TemplTags Find(string m_where)
{
IDbHelper Sql = GetHelper();
TemplTags M = new TemplTags();
DbDataReader Rs = Sql.ExecuteReader(CommandType.Text, "select [ID],[TagName],[TagCode],[FunctionName],[TagFormat],[Remark],[Enable],[TagIndex] from [TemplTags] where " + m_where, true);
if (!Rs.Read())
{
M.ID = 0;
}
else
{
M.ID = Rs["ID"].ToInt32();
M.TagName = Rs["TagName"].ToString();
M.TagCode = Rs["TagCode"].ToString();
M.FunctionName = Rs["FunctionName"].ToString();
M.TagFormat = Rs["TagFormat"].ToString();
M.Remark = Rs["Remark"].ToString();
M.Enable = Rs["Enable"].ToBoolean();
M.TagIndex = Rs["TagIndex"].ToInt32();
}
Rs.Close();
Rs = null;
return(M);
}
/// <summary>
/// 将修改过的实体修改到数据库
/// </summary>
/// <param name="M">赋值后的实体</param>
/// <returns></returns>
public static int Update(TemplTags M)
{
IDbHelper Sql = GetHelper();
StringBuilder sb = new StringBuilder();
sb.Append("update [TemplTags] set ");
sb.Append("[TagName]=N'" + M.TagName + "'");
sb.Append(",");
sb.Append("[TagCode]=N'" + M.TagCode + "'");
sb.Append(",");
sb.Append("[FunctionName]=N'" + M.FunctionName + "'");
sb.Append(",");
sb.Append("[TagFormat]=N'" + M.TagFormat + "'");
sb.Append(",");
sb.Append("[Remark]=N'" + M.Remark + "'");
sb.Append(",");
sb.Append("[Enable]=" + M.Enable.ToS());
sb.Append(",");
sb.Append("[TagIndex]=" + M.TagIndex.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(TemplTags M)
{
IDbHelper Sql = GetHelper();
StringBuilder sb = new StringBuilder();
sb.Append("insert into [TemplTags]([TagName],[TagCode],[FunctionName],[TagFormat],[Remark],[Enable],[TagIndex]) values(");
sb.Append("N'" + M.TagName + "'");
sb.Append(",");
sb.Append("N'" + M.TagCode + "'");
sb.Append(",");
sb.Append("N'" + M.FunctionName + "'");
sb.Append(",");
sb.Append("N'" + M.TagFormat + "'");
sb.Append(",");
sb.Append("N'" + M.Remark + "'");
sb.Append(",");
sb.Append(M.Enable.ToS());
sb.Append(",");
sb.Append(M.TagIndex.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 TemplTags");
}
if (DataBase.CmsDbType == DataBase.DbType.Oracle)
{
sb.Append(";select LAST_INSERT_ID()");
}
M.ID = Sql.ExecuteScalar(CommandType.Text, sb.ToString()).ToInt32();
}
/// <summary>
/// DataTable转换为list
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
protected static List <TemplTags> DataTableToList(DataTable dt)
{
List <TemplTags> Ms = new List <TemplTags>();
for (int i = 0; i < dt.Rows.Count; i++)
{
TemplTags M = new TemplTags();
M.ID = dt.Rows[i]["ID"].ToInt32();
M.TagName = dt.Rows[i]["TagName"].ToString();
M.TagCode = dt.Rows[i]["TagCode"].ToString();
M.FunctionName = dt.Rows[i]["FunctionName"].ToString();
M.TagFormat = dt.Rows[i]["TagFormat"].ToString();
M.Remark = dt.Rows[i]["Remark"].ToString();
M.Enable = dt.Rows[i]["Enable"].ToBoolean();
M.TagIndex = dt.Rows[i]["TagIndex"].ToInt32();
Ms.Add(M);
}
return(Ms);
}
public static TemplTags CreateTemplTags(int id)
{
TemplTags templTags = new TemplTags();
templTags.ID = id;
return templTags;
}
public void AddToTemplTags(TemplTags templTags)
{
base.AddObject("TemplTags", templTags);
}
