/// <summary> /// 得到DawnAuthUserRole实体对象 /// </summary> /// <param name="dr">dr</param> /// <returns>DawnAuthUserRoles实体对象</returns> public DawnAuthUserRoleMDL Select(IDataReader dr) { DawnAuthUserRoleMDL obj = new DawnAuthUserRoleMDL(); try { obj.MapId = ((dr["map_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["map_id"]); } catch { } try { obj.UserId = ((dr["user_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["user_id"]); } catch { } try { obj.RoleId = ((dr["role_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["role_id"]); } catch { } try { obj.MapTime = ((dr["map_time"]) == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(dr["map_time"]); } catch { } return(obj); }
public string BindRoled(FormCollection form) { var stateInfo = GeneralHandler.StateSuccess; int userId = TypeHelper.TypeToInt32(form["userId"], -1); int roleId = TypeHelper.TypeToInt32(form["roleId"], -1); string opFlag = form["opFlag"] as string; if (userId > 0 && roleId > 0 && !string.IsNullOrEmpty(opFlag)) { if (opFlag == "add") { DawnAuthUserRoleMDL dataInfo = new DawnAuthUserRoleMDL(); dataInfo.UserId = userId; dataInfo.RoleId = roleId; dataInfo.MapTime = DateTime.Now; DawnAuthUserRoleBLL.Insert(dataInfo); } else if (opFlag == "del") { DawnAuthUserRoleBLL.DeleteWhere(string.Format("user_id='{0}' and role_id='{1}'", userId, roleId)); } } else { stateInfo = GeneralHandler.FBaseInfo; } return(stateInfo); }
/// <summary> /// 得到DawnAuthUserRole实体对象 /// </summary> /// <param name="row">row</param> /// <returns>DawnAuthUserRole实体对象</returns> public DawnAuthUserRoleMDL Select(DataRow row) { DawnAuthUserRoleMDL obj = new DawnAuthUserRoleMDL(); if (row != null) { try { obj.MapId = ((row["map_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["map_id"]); } catch { } try { obj.UserId = ((row["user_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["user_id"]); } catch { } try { obj.RoleId = ((row["role_id"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["role_id"]); } catch { } try { obj.MapTime = ((row["map_time"]) == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(row["map_time"]); } catch { } } else { return(null); } return(obj); }
/// <summary> /// 向数据表DawnAuthUserRole修改一条记录 /// </summary> /// <param name="dawnAuthUserRole">DawnAuthUserRole实体对象</param> /// <returns></returns> public static int Update(DawnAuthUserRoleMDL dawnAuthUserRole) { if (dawnAuthUserRole == null) { return(0); } return(DawnAuthUserRoleBLL._dal.Update(dawnAuthUserRole)); }
/// <summary> /// 向数据表DawnAuthUserRole中插入一条新记录。带事务 /// </summary> /// <param name="sp">事务对象</param> /// <param name="dawnAuthUserRole">DawnAuthUserRole实体对象</param> /// <returns>ı</returns> public static int Insert(SqlTransaction sp, DawnAuthUserRoleMDL dawnAuthUserRole) { if (dawnAuthUserRole == null) { return(0); } return(DawnAuthUserRoleBLL._dal.Insert(sp, dawnAuthUserRole)); }
/// <summary> /// 向数据表DawnAuthUserRole中插入一条新记录 /// </summary> /// <param name="dawnAuthUserRole">DawnAuthUserRole实体对象</param> /// <returns></returns> public static int Insert(DawnAuthUserRoleMDL dawnAuthUserRole) { if (dawnAuthUserRole == null) { return(0); } return(DawnAuthUserRoleBLL._dal.Insert(dawnAuthUserRole)); }
/// <summary> /// 删除数据表DawnAuthUserRole中的一条记录,带事务 /// </summary> /// <param name="sp">事务对象</param> /// <param name="dawnAuthUserRole">dawnAuthUserRole实体对象</param> /// <returns></returns> public int Delete(SqlTransaction sp, DawnAuthUserRoleMDL dawnAuthUserRole) { string sqlCommand = "DawnAuthUserRoleDelete"; SqlParameter[] param = { new SqlParameter("@MapId", SqlDbType.Int) }; param[0].Value = dawnAuthUserRole.MapId; return(SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param)); }
/// <summary> /// 向数据表DawnAuthUserRole修改一条记录。带事务 /// </summary> /// <param name="sp">事务对象</param> /// <param name="dawnAuthUserRole">dawnAuthUserRole实体对象</param> /// <returns></returns> public int Update(SqlTransaction sp, DawnAuthUserRoleMDL dawnAuthUserRole) { string sqlCommand = "DawnAuthUserRoleUpdate"; SqlParameter[] param = { new SqlParameter("@MapId", SqlDbType.Int), new SqlParameter("@UserId", SqlDbType.Int), new SqlParameter("@RoleId", SqlDbType.Int), new SqlParameter("@MapTime", SqlDbType.DateTime) }; param[0].Value = dawnAuthUserRole.MapId; param[1].Value = dawnAuthUserRole.UserId; param[2].Value = dawnAuthUserRole.RoleId; param[3].Value = dawnAuthUserRole.MapTime; return(SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param)); }
/// <summary> /// 向数据表DawnAuthUserRole中插入一条新记录。带事务 /// </summary> /// <param name="sp">事务对象</param> /// <param name="dawnAuthUserRole">DawnAuthUserRole实体对象</param> /// <returns></returns> public int Insert(SqlTransaction sp, DawnAuthUserRoleMDL dawnAuthUserRole) { string sqlCommand = "DawnAuthUserRoleInsert"; int res; SqlParameter[] param = { new SqlParameter("@MapId", SqlDbType.Int), new SqlParameter("@UserId", SqlDbType.Int), new SqlParameter("@RoleId", SqlDbType.Int), new SqlParameter("@MapTime", SqlDbType.DateTime) }; param[0].Direction = ParameterDirection.Output; param[1].Value = dawnAuthUserRole.UserId; param[2].Value = dawnAuthUserRole.RoleId; param[3].Value = dawnAuthUserRole.MapTime; res = SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param); dawnAuthUserRole.MapId = ((param[0].Value) == DBNull.Value) ? 0 : Convert.ToInt32(param[0].Value); return(res); }
/// <summary> /// 根据ID,返回一个DawnAuthUserRole实体对象 /// </summary> /// <param name="mapId">系统编号</param> /// <returns>DawnAuthUserRole实体对象</returns> public DawnAuthUserRoleMDL Select(int mapId) { DawnAuthUserRoleMDL obj = null; SqlParameter[] param = { new SqlParameter("@MapId", SqlDbType.Int) }; param[0].Value = mapId; string sqlCommand = "DawnAuthUserRoleSelect"; using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param)) { while (dr.Read()) { obj = this.Select(dr); } } return(obj); }
/// <summary> /// 删除数据表DawnAuthUserRole中的一条记录,带事务 /// </summary> /// <param name="sp">事务对象</param> /// <param name="dawnAuthUserRole">DawnAuthUserRole实体对象</param> /// <returns></returns> public int Delete(SqlTransaction sp, DawnAuthUserRoleMDL dawnAuthUserRole) { return(DawnAuthUserRoleBLL._dal.Delete(sp, dawnAuthUserRole)); }
/// <summary> /// 删除数据表DawnAuthUserRole中的一条记录 /// </summary> /// <param name="dawnAuthUserRole">DawnAuthUserRole实体对象</param> /// <returns></returns> public static int Delete(DawnAuthUserRoleMDL dawnAuthUserRole) { return(DawnAuthUserRoleBLL._dal.Delete(dawnAuthUserRole)); }