public void CheckInOut_deleteByMaChamCong(CheckInOutDTO _checkInOutDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _checkInOutDTO.MaChamCong)
};
base.Procedure("CheckInOut_deleteByMaChamCong", sqlParams);
}
public DataTable CheckInOut_getGioChamByMaChamCong(CheckInOutDTO _checkInOutDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _checkInOutDTO.MaChamCong)
};
return(base.executeNonQuerya("CheckInOut_getGioChamByMaChamCong", sqlParams));
}
public void CheckInOut_DeleteGioCham(CheckInOutDTO _checkInOutDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@ID", _checkInOutDTO.ID)
};
base.Procedure("CheckInOut_deleteGioCham", sqlParams);
}
public void Delete_NhanVienByCheckInOut(CheckInOutDTO _checkInOutDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _checkInOutDTO.MaChamCong)
};
base.Procedure("NHANVIEN_deleteCheckInOut", sqlParams);
}
public DataTable NhanVien_getCheckInOutNhanVienHienHanh(CheckInOutDTO _checkInOutDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _checkInOutDTO.MaChamCong)
};
return(base.executeNonQuerya("NHANVIEN_getCheckInOutNhanVienVienHanh", sqlParams));
}
public DataTable get_CheckInOutByMaChamCongAndNgayCham(CheckInOutDTO _checkInOutDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _checkInOutDTO.MaChamCong),
new SqlParameter("@NgayCham", _checkInOutDTO.NgayCham)
};
return(base.executeNonQuerya("NhanVien_getNhanVienByMaChamCongAndDatetime", sqlParams));
}
public DataTable NhanVien_GetGioRaVao(CheckInOutDTO _checkInOutDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _checkInOutDTO.MaChamCong),
new SqlParameter("@NgayCham", _checkInOutDTO.NgayCham)
};
return(base.executeNonQuerya("NhanVien_getGioRaVao", sqlParams));
}
public DataTable CheckInOut_getMin(CheckInOutDTO _checkInOutDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _checkInOutDTO.MaChamCong),
new SqlParameter("@NgayCham", _checkInOutDTO.NgayCham)
};
return(base.executeNonQuerya("CheckInOut_getMin", sqlParams));
}
public void CheckInOut_updateGioCham(CheckInOutDTO _checkInOutDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@ID", _checkInOutDTO.ID),
new SqlParameter("@MaChamCong", _checkInOutDTO.MaChamCong),
new SqlParameter("@GioCham", _checkInOutDTO.GioCham),
new SqlParameter("@KieuCham", _checkInOutDTO.KieuCham),
new SqlParameter("@MaSoMay", _checkInOutDTO.MaSoMay)
};
base.Procedure("CheckInOut_updateGioCham", sqlParams);
}
public void CheckInOut_ThemGio(CheckInOutDTO _checkInOutDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _checkInOutDTO.MaChamCong),
new SqlParameter("@NgayCham", _checkInOutDTO.NgayCham),
new SqlParameter("@GioCham", _checkInOutDTO.GioCham),
new SqlParameter("@KieuCham", _checkInOutDTO.KieuCham),
new SqlParameter("@NguonCham", _checkInOutDTO.NguonCham),
new SqlParameter("@MaSoMay", _checkInOutDTO.MaSoMay),
new SqlParameter("@TenMay", _checkInOutDTO.TenMay)
};
base.Procedure("CheckInOut_ThemGio", sqlParams);
}
public frmTaiDuLieuChamCong()
{
InitializeComponent();
// this.comboBoxLuaChonTai.ComboWidth = 150;
//this.comboBoxLuaChonTai.DropDownHeight = 0x6a;
//this.comboBoxLuaChonTai.ItemHeight = 0x10;
//this.comboBoxLuaChonTai.Items.AddRange(new object[] { this.comboItem1, this.comboItem2 });
//this.comboBoxLuaChonTai.Name = "comboBoxLuaChonTai";
//this.comboBoxLuaChonTai.SelectedIndexChanged += new EventHandler(this.comboBoxLuaChonTai_SelectedIndexChanged);
this._kiemTraManHinh = 0;
this._checkInOutDTO = new CheckInOutDTO();
this._checkInOutBLL = new CheckInOutBLL();
this._value = 0;
this._mayChamCongBLL = new MayChamCongBLL();
this.arrMCC = new ArrayList();
this.DGVDuLieuVaoRa.AllowUserToAddRows = false;
// this.DGVDuLieuVaoRa.BackgroundColor = Color.GhostWhite;
// this.DGVDuLieuVaoRa.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize;
// this.DGVDuLieuVaoRa.Columns.AddRange(new DataGridViewColumn[] { this.ColMaChamCong, this.ColNgay, this.ColGio, this.Column4, this.Column5, this.Column6, this.ColTenMay });
//this.DGVDuLieuVaoRa.Dock = DockStyle.Fill;
//this.DGVDuLieuVaoRa.GridColor = Color.FromArgb(0xd0, 0xd7, 0xe5);
//this.DGVDuLieuVaoRa.Location = new Point(0, 0);
//this.DGVDuLieuVaoRa.Name = "DGVDuLieuVaoRa";
//this.DGVDuLieuVaoRa.Size = new Size(0x2e7, 0x233);
//this.DGVDuLieuVaoRa.TabIndex = 2;
//this.ColMaChamCong.HeaderText = "M\x00e3 Chấm C\x00f4ng";
//this.ColMaChamCong.Name = "ColMaChamCong";
//this.ColNgay.HeaderText = "Ng\x00e0y";
//this.ColNgay.Name = "ColNgay";
//this.ColGio.HeaderText = "Giờ";
//this.ColGio.Name = "ColGio";
//this.Column4.HeaderText = "Kiểu Chấm";
//this.Column4.Name = "Column4";
//this.Column5.HeaderText = "Nguồn Chấm";
//this.Column5.Name = "Column5";
//this.Column6.HeaderText = "M\x00e3 Số M\x00e1y";
//this.Column6.Name = "Column6";
//this.ColTenMay.HeaderText = "T\x00ean M\x00e1y";
//this.ColTenMay.Name = "ColTenMay";
}
public DataTable getCheckInOutNhanVienHienHanh(CheckInOutDTO _checkInOutDTO)
{
return(this._nhanVienDAL.NhanVien_getCheckInOutNhanVienHienHanh(_checkInOutDTO));
}
public DataTable CheckInOutgetGioChamByMaChamCong(CheckInOutDTO _checkInOutDTO)
{
return(this._checkInOutDAL.CheckInOut_getGioChamByMaChamCong(_checkInOutDTO));
}
public void CheckInOutDeleteGioCham(CheckInOutDTO _checkInOutDTO)
{
this._checkInOutDAL.CheckInOut_DeleteGioCham(_checkInOutDTO);
}
public void CheckInOutThemGio(CheckInOutDTO _checkInOutDTO)
{
// NhatKyDTO ydto = new NhatKyDTO(frmClassico.MaNguoiDung, DateTime.Now.ToString(), "Th\x00eam giờ", "Th\x00eam giờ", DateTime.Now.ToString());
// this._nguoiDungBLL.SetSystemLog(ydto);
this._checkInOutDAL.CheckInOut_ThemGio(_checkInOutDTO);
}
public DataTable CheckInOutGetMin(CheckInOutDTO _checkInOutDTO)
{
return(this._checkInOutDAL.CheckInOut_getMin(_checkInOutDTO));
}
public DataTable SelectAll_CheckInOut(CheckInOutDTO _checkInOutDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
return(base.executeNonQuerya("CheckInOut_getall", sqlParams));
}
public void CheckInOutupdateGioCham(CheckInOutDTO _checkInOutDTO)
{
this._checkInOutDAL.CheckInOut_updateGioCham(_checkInOutDTO);
}
public DataTable getCheckInOutByMaChamCongAndNgayCham(CheckInOutDTO _checkInOutDTO)
{
return(this._checkInOutDAL.get_CheckInOutByMaChamCongAndNgayCham(_checkInOutDTO));
}
public void DeleteNhanVienByCheckInOut(CheckInOutDTO _checkInOutDTO)
{
this._checkInOutDAL.Delete_NhanVienByCheckInOut(_checkInOutDTO);
}
public void Insert_CheckinOut(CheckInOutDTO _checkInOutDTO)
{
this._checkInOutDAL.InsertCheckInOut(_checkInOutDTO);
}
public void DeleteAll_NhanVienByCheckInOut(CheckInOutDTO _checkInOutDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
base.Procedure("CheckInOut_deleteAll", sqlParams);
}
public DataTable NhanVienGetGioRaVao(CheckInOutDTO _checkInOutDTO)
{
return(this._checkInOutDAL.NhanVien_GetGioRaVao(_checkInOutDTO));
}
public void CheckInOutDeleteByMaChamCongAndNgayCham(CheckInOutDTO _checkInOutDTO)
{
this._checkInOutDAL.CheckInOut_deleteByMaChamCongAndNgayCham(_checkInOutDTO);
}
public DataTable SelectAllCheckInOut(CheckInOutDTO _checkInOutDTO)
{
return(this._checkInOutDAL.SelectAll_CheckInOut(_checkInOutDTO));
}
