/// <summary>
/// 得到DawnAuthUserPower实体对象
/// </summary>
/// <param name="dr">dr</param>
/// <returns>DawnAuthUserPowers实体对象</returns>
public DawnAuthUserPowerMDL Select(IDataReader dr)
{
DawnAuthUserPowerMDL obj = new DawnAuthUserPowerMDL();
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.MapTime = ((dr["map_time"]) == DBNull.Value)?DateTime.MinValue:Convert.ToDateTime(dr["map_time"]);
}
catch { }
try
{
obj.MapModule = ((dr["map_module"]) == DBNull.Value)?0:Convert.ToInt32(dr["map_module"]);
}
catch { }
try
{
obj.MapFunction = dr["map_function"].ToString();
}
catch { }
return(obj);
}
/// <summary>
/// 向数据表DawnAuthUserPower修改一条记录
/// </summary>
/// <param name="dawnAuthUserPower">DawnAuthUserPower实体对象</param>
/// <returns></returns>
public static int Update(DawnAuthUserPowerMDL dawnAuthUserPower)
{
if (dawnAuthUserPower == null)
{
return(0);
}
return(DawnAuthUserPowerBLL._dal.Update(dawnAuthUserPower));
}
/// <summary>
/// 向数据表DawnAuthUserPower中插入一条新记录。带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="dawnAuthUserPower">DawnAuthUserPower实体对象</param>
/// <returns>ı</returns>
public static int Insert(SqlTransaction sp, DawnAuthUserPowerMDL dawnAuthUserPower)
{
if (dawnAuthUserPower == null)
{
return(0);
}
return(DawnAuthUserPowerBLL._dal.Insert(sp, dawnAuthUserPower));
}
/// <summary>
/// 向数据表DawnAuthUserPower中插入一条新记录
/// </summary>
/// <param name="dawnAuthUserPower">DawnAuthUserPower实体对象</param>
/// <returns></returns>
public static int Insert(DawnAuthUserPowerMDL dawnAuthUserPower)
{
if (dawnAuthUserPower == null)
{
return(0);
}
return(DawnAuthUserPowerBLL._dal.Insert(dawnAuthUserPower));
}
public string BindPowered(FormCollection form)
{
var stateInfo = GeneralHandler.StateSuccess;
int userId = TypeHelper.TypeToInt32(form["userId"], -1);
int mapModule = TypeHelper.TypeToInt32(form["mapModule"], -1);
int mapFunction = TypeHelper.TypeToInt32(form["mapFunction"], -1);
string opFlag = form["opFlag"] as string;
if (userId > 0 && mapModule > 0 && mapFunction > 0)
{
var powList = DawnAuthUserPowerBLL.ISelect(string.Format("user_id='{0}' and map_module='{1}'", userId, mapModule));
if (powList == null || powList.Count < 1)
{
var upFun = string.Format(",{0},", mapFunction);
if (opFlag == "add")
{
DawnAuthUserPowerMDL dataInfo = new DawnAuthUserPowerMDL();
dataInfo.UserId = userId;
dataInfo.MapTime = DateTime.Now;
dataInfo.MapModule = mapModule;
dataInfo.MapFunction = upFun;
DawnAuthUserPowerBLL.Insert(dataInfo);
}
}
else
{
var upFun = string.Format("{0},", mapFunction);
var strFun = powList.First().MapFunction;
if (string.IsNullOrEmpty(strFun))
{
strFun = ",";
}
if (opFlag == "add")
{
if (!strFun.Contains(upFun))
{
strFun += upFun;
DawnAuthUserPowerBLL.UpdateFunction(userId, mapModule, strFun);
}
}
else if (opFlag == "del")
{
upFun = string.Format(",{0},", mapFunction);
strFun = strFun.Replace(upFun, ",");
DawnAuthUserPowerBLL.UpdateFunction(userId, mapModule, strFun);
}
}
}
else
{
stateInfo = GeneralHandler.FBaseInfo;
}
return(stateInfo);
}
/// <summary>
/// 根据ID,返回一个DawnAuthUserPower实体对象
/// </summary>
/// <param name="mapId">系统编号</param>
/// <returns>DawnAuthUserPower实体对象</returns>
public DawnAuthUserPowerMDL Select(int mapId)
{
DawnAuthUserPowerMDL obj = null;
SqlParameter[] param =
{
new SqlParameter("@MapId", SqlDbType.Int)
};
param[0].Value = mapId;
string sqlCommand = "DawnAuthUserPowerSelect";
using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param))
{
while (dr.Read())
{
obj = this.Select(dr);
}
}
return(obj);
}
/// <summary>
/// 得到DawnAuthUserPower实体对象
/// </summary>
/// <param name="row">row</param>
/// <returns>DawnAuthUserPower实体对象</returns>
public DawnAuthUserPowerMDL Select(DataRow row)
{
DawnAuthUserPowerMDL obj = new DawnAuthUserPowerMDL();
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.MapTime = ((row["map_time"]) == DBNull.Value)?DateTime.MinValue:Convert.ToDateTime(row["map_time"]);
}
catch { }
try
{
obj.MapModule = ((row["map_module"]) == DBNull.Value)?0:Convert.ToInt32(row["map_module"]);
}
catch { }
try
{
obj.MapFunction = row["map_function"].ToString();
}
catch { }
}
else
{
return(null);
}
return(obj);
}
/// <summary>
/// 删除数据表DawnAuthUserPower中的一条记录,带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="dawnAuthUserPower">DawnAuthUserPower实体对象</param>
/// <returns></returns>
public int Delete(SqlTransaction sp, DawnAuthUserPowerMDL dawnAuthUserPower)
{
return(DawnAuthUserPowerBLL._dal.Delete(sp, dawnAuthUserPower));
}
/// <summary>
/// 删除数据表DawnAuthUserPower中的一条记录
/// </summary>
/// <param name="dawnAuthUserPower">DawnAuthUserPower实体对象</param>
/// <returns></returns>
public static int Delete(DawnAuthUserPowerMDL dawnAuthUserPower)
{
return(DawnAuthUserPowerBLL._dal.Delete(dawnAuthUserPower));
}
