public Boolean LuuDong(DOBangChamCong dto) { string sql = "update BANG_CHAM_CONG set SANG = @SANG, CHIEU = @CHIEU where NV_ID = @NV_ID and NGAY = @NGAY"; DatabaseFB db = HelpDB.getDatabase(); DbCommand cmd = db.GetSQLStringCommand(sql); db.AddInParameter(cmd, "@NV_ID", DbType.Int64, dto.NV_ID); db.AddInParameter(cmd, "@NGAY", DbType.DateTime, dto.NGAY); db.AddInParameter(cmd, "@SANG", DbType.String, dto.SANG); db.AddInParameter(cmd, "@CHIEU", DbType.String, dto.CHIEU); if (db.ExecuteNonQuery(cmd) > 0) return true; return false; }
void rep_xoa_Click(object sender, EventArgs e) { if (HelpMsgBox.ShowConfirmMessage("Bạn có thực sự muốn xóa không ?") == DialogResult.Yes) { DataRow dr = gridViewDetails.GetDataRow(gridViewDetails.FocusedRowHandle); for (int i = 0; i < ChonNgay.Length; i++) { DOBangChamCong dto = new DOBangChamCong(); dto.NV_ID = long.Parse(dr["NV_ID"].ToString()); dto.NGAY = ChonNgay[i]; DABangChamCong.Ins.XoaDong(dto); } gridViewDetails.DeleteRow(gridViewDetails.FocusedRowHandle); ((DataTable)gridControlDetails.DataSource).AcceptChanges(); barButtonItemAdd.Enabled = true; } }
private bool CapNhat() { string err = string.Empty; try { DataTable tb = (DataTable)gridControlDetails.DataSource; for (int i = 0; i < tb.Rows.Count; i++) { int sc = 0; for (int j = 0; j < ChonNgay.Length; j++) { DOBangChamCong dto = new DOBangChamCong(); dto.NGAY = ChonNgay[j]; dto.NV_ID = long.Parse(tb.Rows[i]["NV_ID"].ToString()); dto.SANG = tb.Rows[i][sc].ToString(); sc++; dto.CHIEU = tb.Rows[i][sc].ToString(); sc++; if (DABangChamCong.Ins.IsTonTai(dto.NV_ID, dto.NGAY)) { if (dto.SANG.Length > 0 || dto.CHIEU.Length > 0) DABangChamCong.Ins.LuuDong(dto); else if (dto.SANG == "" && dto.CHIEU == "") DABangChamCong.Ins.XoaDong(dto); } else { if(dto.SANG.Length>0 ||dto.CHIEU.Length>0) DABangChamCong.Ins.ThemDong(dto); } } } } catch (Exception ex) { err = ex.Message; HelpMsgBox.ShowErrorMessage(ex.Message); } if (err == string.Empty) return true; return false; }
public void ThemNhanVien() { //Xem lại hàm này bên chấm công tự động để sửa lại DataTable Kq = ((DataTable)gridControlDetails.DataSource); DataTable NVBoSung = this.LocNhanVien(); if (NVBoSung.Rows.Count > 0) { for (int i = 0; i < NVBoSung.Rows.Count; i++) { DataRow dr = Kq.NewRow(); dr["NV_ID"] = long.Parse(NVBoSung.Rows[i]["ID"].ToString()); dr["NAME"] = NVBoSung.Rows[i]["NAME"].ToString(); Kq.Rows.Add(dr); //Ghi xuong csdl for (int j = 0; j < SoNgayChon; j++) { DOBangChamCong dto = new DOBangChamCong(); dto.NV_ID = long.Parse(dr["NV_ID"].ToString()); dto.NGAY = ChonNgay[j]; dto.SANG = ""; dto.CHIEU = ""; dto.THANG_NAM = ""; DABangChamCong.Ins.ThemDong(dto); } } barButtonItemAdd.Enabled = true; CapNhatThongKe(); } }
public Boolean ThemDong(DOBangChamCong dto) { string sql = "insert into BANG_CHAM_CONG(ID,NV_ID,NGAY,SANG,CHIEU) values(@ID,@NV_ID,@NGAY,@SANG,@CHIEU)"; DatabaseFB db = HelpDB.getDatabase(); DbCommand cmd = db.GetSQLStringCommand(sql); db.AddInParameter(cmd,"@ID",DbType.Int64, db.GetID("GEN_BANG_CHAM_CONG_ID")); db.AddInParameter(cmd, "@NV_ID", DbType.Int64, dto.NV_ID); db.AddInParameter(cmd, "@NGAY", DbType.DateTime, dto.NGAY); db.AddInParameter(cmd, "@SANG", DbType.String, dto.SANG); db.AddInParameter(cmd, "@CHIEU", DbType.String, dto.CHIEU); if (db.ExecuteNonQuery(cmd)> 0) return true; return false; }
public Boolean XoaDong(DOBangChamCong dto) { string sql = "delete from BANG_CHAM_CONG where NV_ID = @NV_ID and NGAY = @NGAY"; DatabaseFB db = HelpDB.getDatabase(); DbCommand cmd = db.GetSQLStringCommand(sql); db.AddInParameter(cmd, "@NV_ID", DbType.Int64, dto.NV_ID); db.AddInParameter(cmd, "@NGAY", DbType.DateTime, dto.NGAY); if (db.ExecuteNonQuery(cmd) > 0) return true; return false; }