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