public bool UpdateRoleInfo(RoleInfoEntity roleInfoEntity) { bool flag = false; StringBuilder whereCommandText = new StringBuilder(); whereCommandText.Append(" RoleID=@RoleID AND JournalID=@JournalID"); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("RoleName=@RoleName"); sqlCommandText.Append(", Note=@Note"); sqlCommandText.Append(", GroupID=@GroupID"); DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.RoleInfo SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString())); db.AddInParameter(cmd, "@RoleID", DbType.Int64, roleInfoEntity.RoleID); db.AddInParameter(cmd, "@JournalID", DbType.Int64, roleInfoEntity.JournalID); db.AddInParameter(cmd, "@RoleName", DbType.AnsiString, roleInfoEntity.RoleName); db.AddInParameter(cmd, "@Note", DbType.AnsiString, roleInfoEntity.Note); db.AddInParameter(cmd, "@GroupID", DbType.Byte, roleInfoEntity.GroupID); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
public bool AddRoleInfo(RoleInfoEntity roleInfoEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("@JournalID"); sqlCommandText.Append(", @RoleName"); sqlCommandText.Append(", @GroupID"); sqlCommandText.Append(", @Note"); DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.RoleInfo ({0}) VALUES ({1})", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString())); db.AddInParameter(cmd, "@JournalID", DbType.Int64, roleInfoEntity.JournalID); db.AddInParameter(cmd, "@GroupID", DbType.Int16, roleInfoEntity.GroupID); db.AddInParameter(cmd, "@RoleName", DbType.AnsiString, roleInfoEntity.RoleName); db.AddInParameter(cmd, "@Note", DbType.AnsiString, roleInfoEntity.Note); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
/// <summary> /// 角色修改 /// </summary> /// <returns></returns> public ActionResult Edit(long?RoleID) { RoleInfoEntity roleEntity = new RoleInfoEntity(); if (RoleID != null) { ISiteSystemFacadeService sysService = ServiceContainer.Instance.Container.Resolve <ISiteSystemFacadeService>(); roleEntity = sysService.GetRoleEntity(new RoleInfoQuery { RoleID = RoleID.Value }); } return(View(roleEntity)); }
public List <RoleInfoEntity> MakeRoleInfoList(DataTable dt) { List <RoleInfoEntity> list = new List <RoleInfoEntity>(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { RoleInfoEntity roleInfoEntity = MakeRoleInfo(dt.Rows[i]); list.Add(roleInfoEntity); } } return(list); }
public RoleInfoEntity MakeRoleInfo(DataRow dr) { RoleInfoEntity roleInfoEntity = null; if (dr != null) { roleInfoEntity = new RoleInfoEntity(); roleInfoEntity.RoleID = (Int64)dr["RoleID"]; roleInfoEntity.JournalID = (Int64)dr["JournalID"]; roleInfoEntity.RoleName = (String)dr["RoleName"]; roleInfoEntity.Note = (String)dr["Note"]; roleInfoEntity.GroupID = (Byte)dr["GroupID"]; roleInfoEntity.AddDate = (DateTime)dr["AddDate"]; } return(roleInfoEntity); }
public RoleInfoEntity MakeRoleInfo(IDataReader dr) { RoleInfoEntity roleInfoEntity = null; if (dr.Read()) { roleInfoEntity = new RoleInfoEntity(); roleInfoEntity.RoleID = (Int64)dr["RoleID"]; roleInfoEntity.JournalID = (Int64)dr["JournalID"]; roleInfoEntity.RoleName = (String)dr["RoleName"]; roleInfoEntity.Note = (String)dr["Note"]; roleInfoEntity.GroupID = (Byte)dr["GroupID"]; roleInfoEntity.AddDate = (DateTime)dr["AddDate"]; } dr.Close(); return(roleInfoEntity); }
public RoleInfoEntity GetRoleInfo(Int64 roleID) { RoleInfoEntity roleInfoEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 RoleID,JournalID,RoleName,Note,GroupID,AddDate FROM dbo.RoleInfo WITH(NOLOCK)"); sqlCommandText.Append(" WHERE RoleID=@RoleID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@RoleID", DbType.Int64, roleID); using (IDataReader dr = db.ExecuteReader(cmd)) { roleInfoEntity = MakeRoleInfo(dr); } return(roleInfoEntity); }
public List <RoleInfoEntity> MakeRoleInfoList(IDataReader dr) { List <RoleInfoEntity> list = new List <RoleInfoEntity>(); while (dr.Read()) { RoleInfoEntity roleInfoEntity = new RoleInfoEntity(); roleInfoEntity.RoleID = (Int64)dr["RoleID"]; roleInfoEntity.JournalID = (Int64)dr["JournalID"]; roleInfoEntity.RoleName = (String)dr["RoleName"]; roleInfoEntity.Note = (String)dr["Note"]; roleInfoEntity.GroupID = (Byte)dr["GroupID"]; roleInfoEntity.AddDate = (DateTime)dr["AddDate"]; list.Add(roleInfoEntity); } dr.Close(); return(list); }
/// <summary> /// 新增 /// </summary> /// <param name="t_RoleInfo"></param> /// <returns></returns> public long InsertRoleInfo(RoleInfoDTO t_RoleInfo) { using (B2CDbContext ctx = new B2CDbContext()) { List <SysFunEntity> sysFunEntities = new List <SysFunEntity>(); foreach (var item in t_RoleInfo.SysfunIds) { sysFunEntities.Add(ctx.SysFuns.Where(u => u.Id == item).SingleOrDefault()); } RoleInfoEntity roleInfoEntity = new RoleInfoEntity() { DisCount = t_RoleInfo.DisCount, RoleName = t_RoleInfo.RoleName, RoleDesc = t_RoleInfo.RoleDesc, SysFuns = sysFunEntities }; ctx.RolesInfo.Add(roleInfoEntity); ctx.SaveChanges(); return(roleInfoEntity.Id); } }
public bool DeleteRoleInfo(RoleInfoEntity roleInfoEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("DELETE FROM dbo.RoleInfo"); sqlCommandText.Append(" WHERE RoleID=@RoleID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@RoleID", DbType.Int64, roleInfoEntity.RoleID); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
/// <summary> /// 从存储媒介删除实体数据 /// </summary> /// <param name="roleInfo">RoleInfoEntity实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public bool DeleteRoleInfo(RoleInfoEntity roleInfo) { return(RoleInfoDataAccess.Instance.DeleteRoleInfo(roleInfo)); }
/// <summary> /// 更新存储媒介中的实体数据 /// </summary> /// <param name="roleInfo">RoleInfoEntity实体对象</param> /// <returns>true:更新成功 false:更新失败</returns> public bool UpdateRoleInfo(RoleInfoEntity roleInfo) { return(RoleInfoDataAccess.Instance.UpdateRoleInfo(roleInfo)); }
/// <summary> /// 将实体数据存入存储媒介(持久化一个对象) /// </summary> /// <param name="roleInfo">RoleInfoEntity实体对象</param> /// <returns>true:存储成功 false:存储失败</returns> public bool AddRoleInfo(RoleInfoEntity roleInfo) { return(RoleInfoDataAccess.Instance.AddRoleInfo(roleInfo)); }
/// <summary> /// 从存储媒介删除实体数据 /// </summary> /// <param name="roleInfo">RoleInfoEntity实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public bool DeleteRoleInfo(RoleInfoEntity roleInfo) { return(RoleInfoBusProvider.DeleteRoleInfo(roleInfo)); }
/// <summary> /// 更新存储媒介中的实体数据 /// </summary> /// <param name="roleInfo">RoleInfoEntity实体对象</param> /// <returns>true:更新成功 false:更新失败</returns> public bool UpdateRoleInfo(RoleInfoEntity roleInfo) { return(RoleInfoBusProvider.UpdateRoleInfo(roleInfo)); }
/// <summary> /// 将实体数据存入存储媒介(持久化一个对象) /// </summary> /// <param name="roleInfo">RoleInfoEntity实体对象</param> /// <returns>true:存储成功 false:存储失败</returns> public bool AddRoleInfo(RoleInfoEntity roleInfo) { return(RoleInfoBusProvider.AddRoleInfo(roleInfo)); }