/// <summary>
/// 删除指定数据
/// </summary>
/// <param name="ID">要删除的对象 （通过主键）</param>
/// <returns></returns>
public int Delete(BU_UserLogin _bU_UserLogin)
{
return(db.ExecuteNonQuery(deleteByKeyText, CommandType.Text,
new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.BigInt, 19)
{
Value = _bU_UserLogin.ID
}
}));
}
/// <summary>
/// 将表转换为对象集合
/// </summary>
/// <param name="dt">要转换的表</param>
/// <returns></returns>
public List <BU_UserLogin> DataTableToList(DataTable dt)
{
List <BU_UserLogin> bu_userlogins = new List <BU_UserLogin>();
BU_UserLogin _bu_userlogin = null;
object _temp = null;
DataColumnCollection dcs = dt.Columns;
foreach (DataRow item in dt.Rows)
{
_bu_userlogin = new BU_UserLogin();
if (dcs.Contains("id"))
{
_bu_userlogin.ID = Convert.ToInt64(item["ID"]);
}
if (dcs.Contains("loginsource"))
{
_bu_userlogin.LoginSource = Convert.ToInt32(item["LoginSource"]);
}
if (dcs.Contains("uid"))
{
_bu_userlogin.UID = item["UID"].ToString();
}
if (dcs.Contains("userno"))
{
_bu_userlogin.UserNO = item["UserNO"].ToString();
}
if (dcs.Contains("addtime"))
{
_bu_userlogin.AddTime = Convert.ToDateTime(item["AddTime"]);
}
if (dcs.Contains("state"))
{
_bu_userlogin.State = Convert.ToInt32(item["State"]);
}
if (dcs.Contains("opuserid"))
{
_bu_userlogin.OpUserID = Convert.ToInt64(item["OpUserID"]);
}
if (dcs.Contains("opusername"))
{
_bu_userlogin.OpUserName = item["OpUserName"].ToString();
}
if (dcs.Contains("optime"))
{
_temp = item["OpTime"];
if (!(_temp is DBNull))
{
_bu_userlogin.OpTime = Convert.ToDateTime(_temp);
}
}
bu_userlogins.Add(_bu_userlogin);
}
return(bu_userlogins);
}
/// <summary>
/// 将数据行转换为对象
/// </summary>
/// <param name="dt">要转换的数据行</param>
/// <returns></returns>
public BU_UserLogin DataRowToModel(DataRow dr)
{
BU_UserLogin _bu_userlogin = null;
object _temp = null;
DataColumnCollection dcs = dr.Table.Columns;
_bu_userlogin = new BU_UserLogin();
if (dcs.Contains("id"))
{
_bu_userlogin.ID = Convert.ToInt64(dr["ID"]);
}
if (dcs.Contains("loginsource"))
{
_bu_userlogin.LoginSource = Convert.ToInt32(dr["LoginSource"]);
}
if (dcs.Contains("uid"))
{
_bu_userlogin.UID = dr["UID"].ToString();
}
if (dcs.Contains("userno"))
{
_bu_userlogin.UserNO = dr["UserNO"].ToString();
}
if (dcs.Contains("addtime"))
{
_bu_userlogin.AddTime = Convert.ToDateTime(dr["AddTime"]);
}
if (dcs.Contains("state"))
{
_bu_userlogin.State = Convert.ToInt32(dr["State"]);
}
if (dcs.Contains("opuserid"))
{
_bu_userlogin.OpUserID = Convert.ToInt64(dr["OpUserID"]);
}
if (dcs.Contains("opusername"))
{
_bu_userlogin.OpUserName = dr["OpUserName"].ToString();
}
if (dcs.Contains("optime"))
{
_temp = dr["OpTime"];
if (!(_temp is DBNull))
{
_bu_userlogin.OpTime = Convert.ToDateTime(_temp);
}
}
return(_bu_userlogin);
}
/// <summary>
/// 更新数据库的一条记录
/// </summary>
/// <param name="_bU_UserLogin">需要更新的对象</param>
/// <returns></returns>
public int Update(BU_UserLogin _bU_UserLogin)
{
return(db.ExecuteNonQuery(updateByKeyText, CommandType.Text,
new SqlParameter[] {
new SqlParameter("@LoginSource", SqlDbType.Int, 10)
{
Value = _bU_UserLogin.LoginSource
}
, new SqlParameter("@UID", SqlDbType.NVarChar, 100)
{
Value = _bU_UserLogin.UID
}
, new SqlParameter("@UserNO", SqlDbType.VarChar, 32)
{
Value = _bU_UserLogin.UserNO
}
, new SqlParameter("@AddTime", SqlDbType.DateTime, 23)
{
Value = _bU_UserLogin.AddTime
}
, new SqlParameter("@State", SqlDbType.Int, 10)
{
Value = _bU_UserLogin.State
}
, new SqlParameter("@OpUserID", SqlDbType.BigInt, 19)
{
Value = _bU_UserLogin.OpUserID
}
, new SqlParameter("@OpUserName", SqlDbType.NVarChar, 50)
{
Value = _bU_UserLogin.OpUserName
}
, new SqlParameter("@OpTime", SqlDbType.DateTime, 23)
{
Value = _bU_UserLogin.OpTime
}
, new SqlParameter("@ID1", SqlDbType.BigInt, 19)
{
Value = _bU_UserLogin.ID
}
}));
}
/// <summary>
/// 向数据库插入一条新数据 返回插入的自增长值
/// </summary>
/// <param name="_bU_UserLogin">需要插入的对象</param>
/// <returns></returns>
public long Add(BU_UserLogin _bU_UserLogin)
{
object obj = db.ExecuteScalar(insertText, CommandType.Text,
new SqlParameter[] {
new SqlParameter("@LoginSource", SqlDbType.Int, 10)
{
Value = _bU_UserLogin.LoginSource
}
, new SqlParameter("@UID", SqlDbType.NVarChar, 100)
{
Value = _bU_UserLogin.UID
}
, new SqlParameter("@UserNO", SqlDbType.VarChar, 32)
{
Value = _bU_UserLogin.UserNO
}
, new SqlParameter("@AddTime", SqlDbType.DateTime, 23)
{
Value = _bU_UserLogin.AddTime
}
, new SqlParameter("@State", SqlDbType.Int, 10)
{
Value = _bU_UserLogin.State
}
, new SqlParameter("@OpUserID", SqlDbType.BigInt, 19)
{
Value = _bU_UserLogin.OpUserID
}
, new SqlParameter("@OpUserName", SqlDbType.NVarChar, 50)
{
Value = _bU_UserLogin.OpUserName
}
, new SqlParameter("@OpTime", SqlDbType.DateTime, 23)
{
Value = _bU_UserLogin.OpTime
}
});
return(obj is DBNull ? 0 : Convert.ToInt64(obj));
}
/// <summary>
/// 删除指定数据
/// </summary>
/// <param name="ID">要删除的对象 （通过主键）</param>
/// <returns></returns>
public int Delete(BU_UserLogin _bU_UserLogin)
{
return(_dal.Delete(_bU_UserLogin));
}
/// <summary>
/// 更新数据库的一条记录
/// </summary>
/// <param name="_bU_UserLogin">需要更新的对象</param>
/// <returns></returns>
public int Update(BU_UserLogin _bU_UserLogin)
{
return(_dal.Update(_bU_UserLogin));
}
/// <summary>
/// 向数据库插入一条新数据 返回插入的自增长值
/// </summary>
/// <param name="_bU_UserLogin">需要插入的对象</param>
/// <returns></returns>
public long Add(BU_UserLogin _bU_UserLogin)
{
return(_dal.Add(_bU_UserLogin));
}
