/// <summary>
/// 根据条件语句取得第一个实体
/// </summary>
/// <param name="m_where">条件语句，不包含“where”</param>
/// <returns></returns>
public static Relpy Find(string m_where)
{
IDbHelper Sql = GetHelper();
Relpy M = new Relpy();
DbDataReader Rs = Sql.ExecuteReader(CommandType.Text, "select [ID],[ModelID],[NewsID],[UserID],[UserName],[IP],[ReplyTime],[Content] from [Relpy] where " + m_where, true);
if (!Rs.Read())
{
M.Id = 0;
}
else
{
M.Id = Rs["ID"].ToInt32();
M.ModelID = Rs["ModelID"].ToInt32();
M.NewsID = Rs["NewsID"].ToInt32();
M.UserID = Rs["UserID"].ToInt32();
M.UserName = Rs["UserName"].ToString();
M.Ip = Rs["IP"].ToString();
M.ReplyTime = Rs["ReplyTime"].ToDateTime();
M.Content = Rs["Content"].ToString();
}
Rs.Close();
Rs = null;
return(M);
}
/// <summary>
/// 将修改过的实体修改到数据库
/// </summary>
/// <param name="M">赋值后的实体</param>
/// <returns></returns>
public static int Update(Relpy M)
{
IDbHelper Sql = GetHelper();
StringBuilder sb = new StringBuilder();
sb.Append("update [Relpy] set ");
sb.Append("[ModelID]=" + M.ModelID.ToS());
sb.Append(",");
sb.Append("[NewsID]=" + M.NewsID.ToS());
sb.Append(",");
sb.Append("[UserID]=" + M.UserID.ToS());
sb.Append(",");
sb.Append("[UserName]=N'" + M.UserName + "'");
sb.Append(",");
sb.Append("[IP]=N'" + M.Ip + "'");
sb.Append(",");
sb.Append("[ReplyTime]=N'" + M.ReplyTime + "'");
sb.Append(",");
sb.Append("[Content]=N'" + M.Content + "'");
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(Relpy M)
{
IDbHelper Sql = GetHelper();
StringBuilder sb = new StringBuilder();
sb.Append("insert into [Relpy]([ModelID],[NewsID],[UserID],[UserName],[IP],[ReplyTime],[Content]) values(");
sb.Append(M.ModelID.ToS());
sb.Append(",");
sb.Append(M.NewsID.ToS());
sb.Append(",");
sb.Append(M.UserID.ToS());
sb.Append(",");
sb.Append("N'" + M.UserName + "'");
sb.Append(",");
sb.Append("N'" + M.Ip + "'");
sb.Append(",");
sb.Append("N'" + M.ReplyTime + "'");
sb.Append(",");
sb.Append("N'" + M.Content + "'");
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 Relpy");
}
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 <Relpy> DataTableToList(DataTable dt)
{
List <Relpy> Ms = new List <Relpy>();
for (int i = 0; i < dt.Rows.Count; i++)
{
Relpy M = new Relpy();
M.Id = dt.Rows[i]["ID"].ToInt32();
M.ModelID = dt.Rows[i]["ModelID"].ToInt32();
M.NewsID = dt.Rows[i]["NewsID"].ToInt32();
M.UserID = dt.Rows[i]["UserID"].ToInt32();
M.UserName = dt.Rows[i]["UserName"].ToString();
M.Ip = dt.Rows[i]["IP"].ToString();
M.ReplyTime = dt.Rows[i]["ReplyTime"].ToDateTime();
M.Content = dt.Rows[i]["Content"].ToString();
Ms.Add(M);
}
return(Ms);
}
public static Relpy CreateRelpy(int id)
{
Relpy relpy = new Relpy();
relpy.ID = id;
return relpy;
}
public void AddToRelpy(Relpy relpy)
{
base.AddObject("Relpy", relpy);
}
