/// <summary>
/// 得到DawnAuthUserExtent实体对象
/// </summary>
/// <param name="dr">dr</param>
/// <returns>DawnAuthUserExtents实体对象</returns>
public DawnAuthUserExtentMDL Select(IDataReader dr)
{
DawnAuthUserExtentMDL obj = new DawnAuthUserExtentMDL();
try
{
obj.ExtId = ((dr["ext_id"]) == DBNull.Value)?0:Convert.ToInt32(dr["ext_id"]);
}
catch { }
try
{
obj.UserId = ((dr["user_id"]) == DBNull.Value)?0:Convert.ToInt32(dr["user_id"]);
}
catch { }
try
{
obj.ExtTime = ((dr["ext_time"]) == DBNull.Value)?DateTime.MinValue:Convert.ToDateTime(dr["ext_time"]);
}
catch { }
try
{
obj.ExtCode = dr["ext_code"].ToString();
}
catch { }
try
{
obj.ExtMark = dr["ext_mark"].ToString();
}
catch { }
return(obj);
}
public string BindExtented(FormCollection form)
{
var stateInfo = GeneralHandler.StateSuccess;
int userId = TypeHelper.TypeToInt32(form["userId"], -1);
string exteCode = form["exteCode"] as string;
string exteMark = form["exteMark"] as string;
string opFlag = form["opFlag"] as string;
if (userId > 0 && !string.IsNullOrEmpty(exteCode) && !string.IsNullOrEmpty(exteMark))
{
if (opFlag == "add")
{
DawnAuthUserExtentMDL dataInfo = new DawnAuthUserExtentMDL();
dataInfo.UserId = userId;
dataInfo.ExtTime = DateTime.Now;
dataInfo.ExtCode = exteCode;
dataInfo.ExtMark = exteMark;
DawnAuthUserExtentBLL.Insert(dataInfo);
}
else if (opFlag == "del")
{
DawnAuthUserExtentBLL.DeleteWhere(string.Format("user_id='{0}' and ext_code='{1}' and ext_mark='{2}'", userId, exteCode, exteMark));
}
}
else
{
stateInfo = GeneralHandler.FBaseInfo;
}
return(stateInfo);
}
/// <summary>
/// 向数据表DawnAuthUserExtent修改一条记录
/// </summary>
/// <param name="dawnAuthUserExtent">DawnAuthUserExtent实体对象</param>
/// <returns></returns>
public static int Update(DawnAuthUserExtentMDL dawnAuthUserExtent)
{
if (dawnAuthUserExtent == null)
{
return(0);
}
return(DawnAuthUserExtentBLL._dal.Update(dawnAuthUserExtent));
}
/// <summary>
/// 向数据表DawnAuthUserExtent中插入一条新记录。带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="dawnAuthUserExtent">DawnAuthUserExtent实体对象</param>
/// <returns>ı</returns>
public static int Insert(SqlTransaction sp, DawnAuthUserExtentMDL dawnAuthUserExtent)
{
if (dawnAuthUserExtent == null)
{
return(0);
}
return(DawnAuthUserExtentBLL._dal.Insert(sp, dawnAuthUserExtent));
}
/// <summary>
/// 向数据表DawnAuthUserExtent中插入一条新记录
/// </summary>
/// <param name="dawnAuthUserExtent">DawnAuthUserExtent实体对象</param>
/// <returns></returns>
public static int Insert(DawnAuthUserExtentMDL dawnAuthUserExtent)
{
if (dawnAuthUserExtent == null)
{
return(0);
}
return(DawnAuthUserExtentBLL._dal.Insert(dawnAuthUserExtent));
}
/// <summary>
/// 删除数据表DawnAuthUserExtent中的一条记录,带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="dawnAuthUserExtent">dawnAuthUserExtent实体对象</param>
/// <returns></returns>
public int Delete(SqlTransaction sp, DawnAuthUserExtentMDL dawnAuthUserExtent)
{
string sqlCommand = "DawnAuthUserExtentDelete";
SqlParameter[] param =
{
new SqlParameter("@ExtId", SqlDbType.Int)
};
param[0].Value = dawnAuthUserExtent.ExtId;
return(SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param));
}
/// <summary>
/// 向数据表DawnAuthUserExtent修改一条记录。带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="dawnAuthUserExtent">dawnAuthUserExtent实体对象</param>
/// <returns></returns>
public int Update(SqlTransaction sp, DawnAuthUserExtentMDL dawnAuthUserExtent)
{
string sqlCommand = "DawnAuthUserExtentUpdate";
SqlParameter[] param =
{
new SqlParameter("@ExtId", SqlDbType.Int),
new SqlParameter("@UserId", SqlDbType.Int),
new SqlParameter("@ExtTime", SqlDbType.DateTime),
new SqlParameter("@ExtCode", SqlDbType.VarChar, 100),
new SqlParameter("@ExtMark", SqlDbType.VarChar, 100)
};
param[0].Value = dawnAuthUserExtent.ExtId;
param[1].Value = dawnAuthUserExtent.UserId;
param[2].Value = dawnAuthUserExtent.ExtTime;
param[3].Value = dawnAuthUserExtent.ExtCode;
param[4].Value = dawnAuthUserExtent.ExtMark;
return(SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param));
}
/// <summary>
/// 根据ID,返回一个DawnAuthUserExtent实体对象
/// </summary>
/// <param name="extId">系统编号</param>
/// <returns>DawnAuthUserExtent实体对象</returns>
public DawnAuthUserExtentMDL Select(int extId)
{
DawnAuthUserExtentMDL obj = null;
SqlParameter[] param =
{
new SqlParameter("@ExtId", SqlDbType.Int)
};
param[0].Value = extId;
string sqlCommand = "DawnAuthUserExtentSelect";
using (SqlDataReader dr = SqlHelper.ExecuteReader(Conn.SqlConn, CommandType.StoredProcedure, sqlCommand, param))
{
while (dr.Read())
{
obj = this.Select(dr);
}
}
return(obj);
}
/// <summary>
/// 向数据表DawnAuthUserExtent中插入一条新记录。带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="dawnAuthUserExtent">DawnAuthUserExtent实体对象</param>
/// <returns></returns>
public int Insert(SqlTransaction sp, DawnAuthUserExtentMDL dawnAuthUserExtent)
{
string sqlCommand = "DawnAuthUserExtentInsert";
int res;
SqlParameter[] param =
{
new SqlParameter("@ExtId", SqlDbType.Int),
new SqlParameter("@UserId", SqlDbType.Int),
new SqlParameter("@ExtTime", SqlDbType.DateTime),
new SqlParameter("@ExtCode", SqlDbType.VarChar, 100),
new SqlParameter("@ExtMark", SqlDbType.VarChar, 100)
};
param[0].Direction = ParameterDirection.Output;
param[1].Value = dawnAuthUserExtent.UserId;
param[2].Value = dawnAuthUserExtent.ExtTime;
param[3].Value = dawnAuthUserExtent.ExtCode;
param[4].Value = dawnAuthUserExtent.ExtMark;
res = SqlHelper.ExecuteNonQuery(sp, CommandType.StoredProcedure, sqlCommand, param);
dawnAuthUserExtent.ExtId = ((param[0].Value) == DBNull.Value)?0:Convert.ToInt32(param[0].Value);
return(res);
}
/// <summary>
/// 得到DawnAuthUserExtent实体对象
/// </summary>
/// <param name="row">row</param>
/// <returns>DawnAuthUserExtent实体对象</returns>
public DawnAuthUserExtentMDL Select(DataRow row)
{
DawnAuthUserExtentMDL obj = new DawnAuthUserExtentMDL();
if (row != null)
{
try
{
obj.ExtId = ((row["ext_id"]) == DBNull.Value)?0:Convert.ToInt32(row["ext_id"]);
}
catch { }
try
{
obj.UserId = ((row["user_id"]) == DBNull.Value)?0:Convert.ToInt32(row["user_id"]);
}
catch { }
try
{
obj.ExtTime = ((row["ext_time"]) == DBNull.Value)?DateTime.MinValue:Convert.ToDateTime(row["ext_time"]);
}
catch { }
try
{
obj.ExtCode = row["ext_code"].ToString();
}
catch { }
try
{
obj.ExtMark = row["ext_mark"].ToString();
}
catch { }
}
else
{
return(null);
}
return(obj);
}
/// <summary>
/// 删除数据表DawnAuthUserExtent中的一条记录,带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="dawnAuthUserExtent">DawnAuthUserExtent实体对象</param>
/// <returns></returns>
public int Delete(SqlTransaction sp, DawnAuthUserExtentMDL dawnAuthUserExtent)
{
return(DawnAuthUserExtentBLL._dal.Delete(sp, dawnAuthUserExtent));
}
/// <summary>
/// 删除数据表DawnAuthUserExtent中的一条记录
/// </summary>
/// <param name="dawnAuthUserExtent">DawnAuthUserExtent实体对象</param>
/// <returns></returns>
public static int Delete(DawnAuthUserExtentMDL dawnAuthUserExtent)
{
return(DawnAuthUserExtentBLL._dal.Delete(dawnAuthUserExtent));
}
