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