public DataTable MayChamCong_getLoad(MayChamCongDTO _mayChamCongDTO) { List <SqlParameter> sqlParams = new List <SqlParameter> { new SqlParameter("@MaMCC", _mayChamCongDTO.MaMCC) }; return(base.executeNonQuerya("MayChamCong_get", sqlParams)); }
public void DELELEMAYCHAMCONG(MayChamCongDTO _mayChamCongDTO) { List <SqlParameter> sqlParams = new List <SqlParameter> { new SqlParameter("@MaMCC", _mayChamCongDTO.MaMCC) }; base.Procedure("MAYCHAMCONG_delete", sqlParams); }
public void CapNhatActiveKey(MayChamCongDTO _mayChamCongDTO) { List <SqlParameter> sqlParams = new List <SqlParameter> { new SqlParameter("@MaMCC", _mayChamCongDTO.MaMCC), new SqlParameter("@Serial", _mayChamCongDTO.Serial), new SqlParameter("@SoDangKy", _mayChamCongDTO.SoDangKy) }; base.Procedure("MAYCHAMCONG_activeKey", sqlParams); }
public void SuaMayChamCong(MayChamCongDTO _mayChamCongDTO) { List <SqlParameter> sqlParams = new List <SqlParameter> { new SqlParameter("@MaMCC", _mayChamCongDTO.MaMCC), new SqlParameter("@TenMCC", _mayChamCongDTO.TenMCC), new SqlParameter("@IDMCC", _mayChamCongDTO.IDMCC), new SqlParameter("@KieuKetNoi", _mayChamCongDTO.KieuKetNoi), new SqlParameter("@DiaChiIP", _mayChamCongDTO.DiaChiIP), new SqlParameter("@Port", _mayChamCongDTO.Port), new SqlParameter("@CongCOM", _mayChamCongDTO.CongCOM), new SqlParameter("@TocDoTruyen", _mayChamCongDTO.TocDoTruyen), new SqlParameter("@DiaChiWeb", _mayChamCongDTO.DiaChiWeb), new SqlParameter("@SuDungWeb", _mayChamCongDTO.SuDungWeb), new SqlParameter("@TrangThai", _mayChamCongDTO.TrangThai), new SqlParameter("@TrangThaiMay", _mayChamCongDTO.TrangThaiMay) }; base.Procedure("MAYCHAMCONG_update", sqlParams); }
public void THEMMAYCHAMCONG(MayChamCongDTO _mayChamCongDTO) { this._mayChamCongDAL.ThemMayChamCong(_mayChamCongDTO); }
public void SUAMAYCHAMCONG(MayChamCongDTO _mayChamCongDTO) { this._mayChamCongDAL.SuaMayChamCong(_mayChamCongDTO); }
public void SUAACTIVEKEY(MayChamCongDTO _mayChamCongDTO) { this._mayChamCongDAL.CapNhatActiveKey(_mayChamCongDTO); }
public DataTable MayChamCongGetLoad(MayChamCongDTO _mayChamCongDTO) { return(this._mayChamCongDAL.MayChamCong_getLoad(_mayChamCongDTO)); }
public DataTable MayChamCongGetAllByTenMCC(MayChamCongDTO _mayChamCongDTO) { return(this._mayChamCongDAL.MayChamCong_getAllByTenMCC(_mayChamCongDTO)); }
public void DELETEMAYCHAMCONG(MayChamCongDTO _mayChamCongDTO) { this._mayChamCongDAL.DELELEMAYCHAMCONG(_mayChamCongDTO); }
public ArrayList SelectAllMCC() { SqlDataReader reader = dbHelper.ExecuteQuery("MAYCHAMCONG_getall"); ArrayList list = new ArrayList(); try { while (reader.Read()) { string a0; string a1; int a2; string a3; if (reader[0] != DBNull.Value && string.IsNullOrEmpty(reader[0].ToString().Trim())) { a0 = reader.GetString(0); } else { a0 = ""; } if (reader[1] != DBNull.Value && string.IsNullOrEmpty(reader[1].ToString().Trim())) { a1 = reader.GetString(1); } else { a1 = ""; } if (reader[2] != DBNull.Value) { a2 = reader.GetInt32(2); } else { // } if (reader[3] != DBNull.Value && string.IsNullOrEmpty(reader[3].ToString().Trim())) { a3 = reader.GetString(3); } else { a3 = ""; } string a4; if (reader[4] != DBNull.Value && string.IsNullOrEmpty(reader[4].ToString().Trim())) { a4 = reader.GetString(4); } else { a4 = ""; } int a5; if (reader[5] != DBNull.Value) { a5 = reader.GetInt32(5); } else { // } int a6; if (reader[6] != DBNull.Value) { a6 = reader.GetInt32(6); } else { // } string a7; if (reader[7] != DBNull.Value && string.IsNullOrEmpty(reader[7].ToString().Trim())) { a7 = reader.GetString(7); } else { a7 = ""; } string a8; if (reader[8] != DBNull.Value && string.IsNullOrEmpty(reader[8].ToString().Trim())) { a8 = reader.GetString(8); } else { a8 = ""; } DateTime a9; if (reader[9] != DBNull.Value && string.IsNullOrEmpty(reader[9].ToString().Trim())) { a9 = reader.GetDateTime(9); } else { // } string a11; if (reader[11] != DBNull.Value && string.IsNullOrEmpty(reader[11].ToString().Trim())) { a11 = reader.GetString(11); } else { a11 = ""; } string a12; if (reader[12] != DBNull.Value && string.IsNullOrEmpty(reader[12].ToString().Trim())) { a12 = reader.GetString(12); } else { a12 = ""; } MayChamCongDTO gdto = new MayChamCongDTO(reader.GetString(0), reader.GetString(1), reader.GetInt32(2), reader.GetString(3), reader.GetString(4), reader.GetInt32(5), reader.GetInt32(6), reader.GetString(7), reader.GetString(8), reader.GetDateTime(9), reader.GetBoolean(10), reader.GetString(11), reader.GetString(12), reader.GetBoolean(13), reader.GetInt32(14)); list.Add(gdto); } } finally { if (reader != null) { reader.Close(); } } return(list); }