public void InsertSystemLog(NhatKyDTO _nhatKyDTO) { List <SqlParameter> paramlist = new List <SqlParameter>(); SqlParameter item = new SqlParameter(); item = new SqlParameter("@MaNguoiDung", SqlDbType.NChar) { Value = _nhatKyDTO.MaNguoiDung }; paramlist.Add(item); item = new SqlParameter("@ThoiGian", SqlDbType.DateTime) { Value = _nhatKyDTO.ThoiGian }; paramlist.Add(item); item = new SqlParameter("@ChucNang", SqlDbType.NVarChar) { Value = _nhatKyDTO.ChucNang }; paramlist.Add(item); item = new SqlParameter("@HanhDong", SqlDbType.NVarChar) { Value = _nhatKyDTO.HanhDong }; paramlist.Add(item); item = new SqlParameter("@ThoiGianSearch", SqlDbType.NVarChar) { Value = _nhatKyDTO.ThoiGianSearch }; paramlist.Add(item); this.dbHelper.ExecuteNonQuery("NhatKy_SetDateLoginUser", paramlist); }
public DataTable NhatKyHeThong_Search(NhatKyDTO _nhatKyDTO) { List <SqlParameter> sqlParams = new List <SqlParameter> { new SqlParameter("@ThoiGianSearch", _nhatKyDTO.ThoiGianSearch) }; return(base.executeNonQuerya("NhatKyHeThong_Search", sqlParams)); }
public void NhatKyHeThong_DeleteByThoiGian(NhatKyDTO _nhatKyDTO) { List <SqlParameter> sqlParams = new List <SqlParameter> { new SqlParameter("@ThoiGianSearch", _nhatKyDTO.ThoiGianSearch) }; base.Procedure("NhatKyHeThong_deleteByThoiGian", sqlParams); }
public DataTable NhatKyHeThong_ThoiGian(NhatKyDTO _nhatKyDTO) { List <SqlParameter> sqlParams = new List <SqlParameter> { new SqlParameter("@FromDate", _nhatKyDTO.FromDate), new SqlParameter("@ToDate", _nhatKyDTO.ToDate) }; return(base.executeNonQuerya("NhatKyHeThong_getallByThoiGian", sqlParams)); }
public NhatKyDTO SelectLastLoginUser(string _MaNguoiDung) { List <SqlParameter> paramlist = new List <SqlParameter>(); SqlParameter item = new SqlParameter(); item = new SqlParameter("@MaNguoiDung", SqlDbType.NChar) { Value = _MaNguoiDung }; paramlist.Add(item); SqlDataReader reader = null; reader = this.dbHelper.ExecuteQuery("NhatKy_GetLastLoginUser", paramlist); if (reader.Read()) { NhatKyDTO ydto = new NhatKyDTO(reader.GetInt32(0), reader.GetString(1), reader.GetDateTime(2).ToString(), reader.GetString(3), reader.GetString(4), DateTime.Now.ToString()); reader.Close(); return(ydto); } reader.Close(); return(null); }
public DataTable NhatKyHeThongThoiGian(NhatKyDTO _nhatKyDTO) { return(this._nhatKyDAL.NhatKyHeThong_ThoiGian(_nhatKyDTO)); }
public DataTable NhatKyHeThongSearch(NhatKyDTO _nhatKyDTO) { return(this._nhatKyDAL.NhatKyHeThong_Search(_nhatKyDTO)); }
public void NhatKyHeThongDeleteByThoiGian(NhatKyDTO _nhatKyDTO) { this._nhatKyDAL.NhatKyHeThong_DeleteByThoiGian(_nhatKyDTO); }
public void NhatKyDelete(NhatKyDTO _nhatKyDTO) { this._nhatKyDAL.NhatKy_Delete(_nhatKyDTO); }
public void SetSystemLog(NhatKyDTO _nhatKyDTO) { this._nguoiDungDAL.InsertSystemLog(_nhatKyDTO); }
public void NhatKy_Delete(NhatKyDTO _nhatKyDTO) { List <SqlParameter> sqlParams = new List <SqlParameter>(); base.Procedure("NhatKyHeThong_deleteAll", sqlParams); }
public void SetSystemLog(NhatKyDTO _nhatKyDTO) { this._userDAL.InsertSystemLog(_nhatKyDTO); }