public DataTable get_MaByTenCaLamViec(CaLamViecDTO _caLamViecDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@CaLamViec", _caLamViecDTO.CaLamViec)
};
return(base.executeNonQuerya("CaLamViecNew_getMaByTenCa", sqlParams));
}
public DataTable get_CaLamViecByMaCaLamViec(CaLamViecDTO _caLamViecDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaCaLamViec", _caLamViecDTO.MaCaLamViec)
};
return(base.executeNonQuerya("CaLamViec_getTenByMaCaLamViec", sqlParams));
}
public void Delete_CaLamViec(CaLamViecDTO _caLamViecDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaCaLamViec", _caLamViecDTO.MaCaLamViec)
};
base.Procedure("CALAMVIEC_delete", sqlParams);
}
public DataTable CaLamViec_getDataGirdView(CaLamViecDTO _caLamViecDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaCaLamViec", _caLamViecDTO.MaCaLamViec)
};
return(base.executeNonQuerya("CaLamViec_getDataGirdView", sqlParams));
}
public ArrayList SelectTenCaLamViec()
{
SqlDataReader reader = this.dbHelper.ExecuteQuery("CALAMVIEC_get_TenMay");
ArrayList list = new ArrayList();
while (reader.Read())
{
CaLamViecDTO cdto = new CaLamViecDTO(reader.GetString(0), reader.GetString(1));
list.Add(cdto);
}
reader.Close();
return(list);
}
public void Insert_CaLamViec(CaLamViecDTO _caLamViecDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaCaLamViec", _caLamViecDTO.MaCaLamViec),
new SqlParameter("@CaLamViec", _caLamViecDTO.CaLamViec),
new SqlParameter("@GioVaoLamViec", _caLamViecDTO.GioVaoLamViec),
new SqlParameter("@GioKetThucLamViec", _caLamViecDTO.GioKetThucLamViec),
new SqlParameter("@GioBatDauNghiTrua", _caLamViecDTO.GioBatDauNghiTrua),
new SqlParameter("@GioKetThucNghiTrua", _caLamViecDTO.GioKetThucNghiTrua),
new SqlParameter("@TongGioNghiTrua", _caLamViecDTO.TongGioNghiTrua),
new SqlParameter("@TongGioTrongCaLamViec", _caLamViecDTO.TongGioTrongCaLamViec),
new SqlParameter("@CongTinh", _caLamViecDTO.CongTinh),
new SqlParameter("@BatDauVao", _caLamViecDTO.BatDauVao),
new SqlParameter("@KetThucVao", _caLamViecDTO.KetThucVao),
new SqlParameter("@BatDauRa", _caLamViecDTO.BatDauRa),
new SqlParameter("@KetThucRa", _caLamViecDTO.KetThucRa),
new SqlParameter("@KhongCoGioRa", _caLamViecDTO.KhongCoGioRa),
new SqlParameter("@KhongCoGioVao", _caLamViecDTO.KhongCoGioVao),
new SqlParameter("@XemCaDem", _caLamViecDTO.XemCaDem),
new SqlParameter("@TinhBuTru", _caLamViecDTO.TinhBuTru),
new SqlParameter("@TruGioDiTre", _caLamViecDTO.TruGioDiTre),
new SqlParameter("@TruGioVeSom", _caLamViecDTO.TruGioVeSom),
new SqlParameter("@ChoPhepDiTre", _caLamViecDTO.ChoPhepDiTre),
new SqlParameter("@BatDauTinhDiTre", _caLamViecDTO.BatDauTinhDiTre),
new SqlParameter("@ChoPhepVeSom", _caLamViecDTO.ChoPhepVeSom),
new SqlParameter("@BatDauTinhVeSom", _caLamViecDTO.BatDauTinhVeSom),
new SqlParameter("@XemCaNayLaTangCa", _caLamViecDTO.XemCaNayLaTangCa),
new SqlParameter("@TangCaMuc", _caLamViecDTO.TangCaMuc),
new SqlParameter("@XemCuoiTuanLaTangCa", _caLamViecDTO.XemCuoiTuanLaTangCa),
new SqlParameter("@TangCaCuoiTuanMuc", _caLamViecDTO.TangCaCuoiTuanMuc),
new SqlParameter("@XemNgayLeLaTangCa", _caLamViecDTO.XemNgayLeLaTangCa),
new SqlParameter("@TangCaNgayLeMuc", _caLamViecDTO.TangCaNgayLeMuc),
new SqlParameter("@TangCaTruocGioLamViec", _caLamViecDTO.TangCaTruocGioLamViec),
new SqlParameter("@SoPhutTangCaTruocGioLamViec", _caLamViecDTO.SoPhutTangCaTruocGioLamViec),
new SqlParameter("@TangCaSauGioLamViec", _caLamViecDTO.TangCaSauGioLamViec),
new SqlParameter("@SoPhutTangCaSauGioLamViec", _caLamViecDTO.SoPhutTangCaSauGioLamViec),
new SqlParameter("@TongGioLamDatDen", _caLamViecDTO.TongGioLamDatDen),
new SqlParameter("@SoPhutTongGioLamDatDen", _caLamViecDTO.SoPhutTongGioLamDatDen),
new SqlParameter("@TangCaTruocGioLamViecDatDen", _caLamViecDTO.TangCaTruocGioLamViecDatDen),
new SqlParameter("@PhutTruTangCaTruoc", _caLamViecDTO.PhutTruTangCaTruoc),
new SqlParameter("@TangCaSauGioLamViecDatDen", _caLamViecDTO.TangCaSauGioLamViecDatDen),
new SqlParameter("@PhutTruTangCaSau", _caLamViecDTO.PhutTruTangCaSau),
new SqlParameter("@GioiHanTangCa1", _caLamViecDTO.GioiHanTangCa1),
new SqlParameter("@GioiHanTangCa2", _caLamViecDTO.GioiHanTangCa2),
new SqlParameter("@GioiHanTangCa3", _caLamViecDTO.GioiHanTangCa3),
new SqlParameter("@GioiHanTangCa4", _caLamViecDTO.GioiHanTangCa4)
};
base.Procedure("CALAMVIEC_add", sqlParams);
}
public void UpdateCaLamViec(CaLamViecDTO _caLamViecDTO)
{
this._caLamViecDAL.Update_CaLamViec(_caLamViecDTO);
}
public void InsertCaLamViec(CaLamViecDTO _caLamViecDTO)
{
this._caLamViecDAL.Insert_CaLamViec(_caLamViecDTO);
}
public DataTable getMaByTenCaLamViec(CaLamViecDTO _caLamViecDTO)
{
return(this._caLamViecDAL.get_MaByTenCaLamViec(_caLamViecDTO));
}
public DataTable getCaLamViecByMaCaLamViec(CaLamViecDTO _caLamViecDTO)
{
return(this._caLamViecDAL.get_CaLamViecByMaCaLamViec(_caLamViecDTO));
}
public void DeleteCaLamViec(CaLamViecDTO _caLamViecDTO)
{
this._caLamViecDAL.Delete_CaLamViec(_caLamViecDTO);
}
public DataTable CaLamViecgetDataGirdView(CaLamViecDTO _caLamViecDTO)
{
return(this._caLamViecDAL.CaLamViec_getDataGirdView(_caLamViecDTO));
}
public DataTable CaLamViecGetByMaCaLamViec(CaLamViecDTO _caLamViecDTO)
{
return(this._caLamViecDAL.CaLamViec_getByMaCaLamViec(_caLamViecDTO));
}