/// <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)); }