public static DOHenPhongVan getHenPhongVan(long UV_ID)
{
string sql = "select * from HEN_PHONG_VAN where R_ID = " + UV_ID.ToString() + " and 1=1";
QueryBuilder query = new QueryBuilder(sql);
DataSet ds = HelpDB.getDatabase().LoadDataSet(query, "AA");
if (ds == null || ds.Tables[0].Rows.Count == 0)
return null;
DOHenPhongVan HenPhongVan = new DOHenPhongVan();
HenPhongVan.ID = long.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
HenPhongVan.R_ID = UV_ID;
HenPhongVan.NGAY_GIO_PHONG_VAN = (DateTime)ds.Tables[0].Rows[0]["NGAY_GIO_PHONG_VAN"];
HenPhongVan.GIO_PHONG_VAN = (TimeSpan)ds.Tables[0].Rows[0]["GIO_PHONG_VAN"];
HenPhongVan.VONG_PHONG_VAN =int.Parse( ds.Tables[0].Rows[0]["VONG_PHONG_VAN"].ToString());
HenPhongVan.LAN_MOI_PHONG_VAN = int.Parse(ds.Tables[0].Rows[0]["LAN_MOI_PHONG_VAN"].ToString());
HenPhongVan.MOI_PHONG_VAN = ds.Tables[0].Rows[0]["MOI_PHONG_VAN"].ToString();
HenPhongVan.UNG_VIEN_XAC_NHAN = ds.Tables[0].Rows[0]["UNG_VIEN_XAC_NHAN"].ToString();
HenPhongVan.UNG_VIEN_XAC_NHAN_GHI_CHU = ds.Tables[0].Rows[0]["UNG_VIEN_XAC_NHAN_GHI_CHU"].ToString();
HenPhongVan.THAM_DU = ds.Tables[0].Rows[0]["THAM_DU"].ToString();
HenPhongVan.THAM_DU_GHI_CHU = ds.Tables[0].Rows[0]["THAM_DU_GHI_CHU"].ToString();
HenPhongVan.KET_QUA = ds.Tables[0].Rows[0]["KET_QUA"].ToString();
HenPhongVan.NGAY_BAT_DAU = (ds.Tables[0].Rows[0]["NGAY_BAT_DAU"].ToString()!="") ? (DateTime)ds.Tables[0].Rows[0]["NGAY_BAT_DAU"] : new DateTime(1,1,1);
HenPhongVan.THOI_GIAN_LAM_VIEC = ds.Tables[0].Rows[0]["THOI_GIAN_LAM_VIEC"].ToString();
HenPhongVan.KET_QUA_GHI_CHU = ds.Tables[0].Rows[0]["KET_QUA_GHI_CHU"].ToString();
HenPhongVan.UNG_VIEN_DA_CHAP_NHAN = ds.Tables[0].Rows[0]["UNG_VIEN_DA_CHAP_NHAN"].ToString();
HenPhongVan.THONG_BAO_KET_QUA = ds.Tables[0].Rows[0]["THONG_BAO_KET_QUA"].ToString();
HenPhongVan.MUC_LUONG = HelpNumber.ParseDecimal(ds.Tables[0].Rows[0]["MUC_LUONG"].ToString());
HenPhongVan.THONG_TIN_KHAC = ds.Tables[0].Rows[0]["THONG_TIN_KHAC"].ToString();
//HenPhongVan.DEN_NGAY = (ds.Tables[0].Rows[0]["DEN_NGAY"].ToString() != "") ? (DateTime)ds.Tables[0].Rows[0]["DEN_NGAY"] : new DateTime(1900, 1, 1);
HenPhongVan.SO_NGAY = HelpNumber.ParseInt64(ds.Tables[0].Rows[0]["SO_NGAY"]);
return HenPhongVan;
}
public static bool Update(DOHenPhongVan HenPhongVan)
{
try
{
string sql = "UPDATE HEN_PHONG_VAN "
+ "SET "
+ "NGAY_GIO_PHONG_VAN =@NGAY_GIO_PHONG_VAN ,"
+ "GIO_PHONG_VAN =@GIO_PHONG_VAN ,"
+ "VONG_PHONG_VAN=@VONG_PHONG_VAN,"
+ "LAN_MOI_PHONG_VAN = @LAN_MOI_PHONG_VAN,"
+ "MOI_PHONG_VAN = @MOI_PHONG_VAN,"
+ "UNG_VIEN_XAC_NHAN =@UNG_VIEN_XAC_NHAN,"
+ "UNG_VIEN_XAC_NHAN_GHI_CHU = @UNG_VIEN_XAC_NHAN_GHI_CHU,"
+ "THAM_DU = @THAM_DU,"
+ "THAM_DU_GHI_CHU = @THAM_DU_GHI_CHU,"
+ "KET_QUA = @KET_QUA,"
+ "NGAY_BAT_DAU = @NGAY_BAT_DAU,"
+ "THOI_GIAN_LAM_VIEC = @THOI_GIAN_LAM_VIEC,"
+ "KET_QUA_GHI_CHU = @KET_QUA_GHI_CHU,"
+ "UNG_VIEN_DA_CHAP_NHAN = @UNG_VIEN_DA_CHAP_NHAN,"
+ "THONG_BAO_KET_QUA = @THONG_BAO_KET_QUA,"
+ "MUC_LUONG = @MUC_LUONG, "
+ "THONG_TIN_KHAC = @THONG_TIN_KHAC "
+ ",SO_NGAY=@SO_NGAY "
//+ "DEN_NGAY = @DEN_NGAY "
+ "WHERE R_ID=@R_ID";
DatabaseFB db = HelpDB.getDatabase();
System.Data.Common.DbCommand cmd = db.GetSQLStringCommand(sql);
db.AddInParameter(cmd, "@R_ID", DbType.Int64, HenPhongVan.R_ID);
db.AddInParameter(cmd, "@NGAY_GIO_PHONG_VAN", DbType.DateTime, HenPhongVan.NGAY_GIO_PHONG_VAN);
db.AddInParameter(cmd, "@GIO_PHONG_VAN", DbType.Time, HenPhongVan.GIO_PHONG_VAN);
db.AddInParameter(cmd, "@VONG_PHONG_VAN", DbType.String, HenPhongVan.VONG_PHONG_VAN);
db.AddInParameter(cmd, "@LAN_MOI_PHONG_VAN", DbType.String, HenPhongVan.LAN_MOI_PHONG_VAN);
db.AddInParameter(cmd, "@MOI_PHONG_VAN", DbType.String, HenPhongVan.MOI_PHONG_VAN);
db.AddInParameter(cmd, "@UNG_VIEN_XAC_NHAN", DbType.String, HenPhongVan.UNG_VIEN_XAC_NHAN);
db.AddInParameter(cmd, "@UNG_VIEN_XAC_NHAN_GHI_CHU", DbType.String, HenPhongVan.UNG_VIEN_XAC_NHAN_GHI_CHU);
db.AddInParameter(cmd, "@THAM_DU", DbType.String, HenPhongVan.THAM_DU);
db.AddInParameter(cmd, "@THAM_DU_GHI_CHU", DbType.String, HenPhongVan.THAM_DU_GHI_CHU);
db.AddInParameter(cmd, "@KET_QUA", DbType.String, HenPhongVan.KET_QUA);
if(HenPhongVan.NGAY_BAT_DAU== new DateTime(1900,1,1))
db.AddInParameter(cmd, "@NGAY_BAT_DAU", DbType.DateTime, DBNull.Value);
else
db.AddInParameter(cmd, "@NGAY_BAT_DAU", DbType.DateTime, HenPhongVan.NGAY_BAT_DAU);
db.AddInParameter(cmd, "@THOI_GIAN_LAM_VIEC", DbType.String, HenPhongVan.THOI_GIAN_LAM_VIEC);
db.AddInParameter(cmd, "@KET_QUA_GHI_CHU", DbType.String, HenPhongVan.KET_QUA_GHI_CHU);
db.AddInParameter(cmd, "@UNG_VIEN_DA_CHAP_NHAN", DbType.String, HenPhongVan.UNG_VIEN_DA_CHAP_NHAN);
db.AddInParameter(cmd, "@THONG_BAO_KET_QUA", DbType.String, HenPhongVan.THONG_BAO_KET_QUA);
db.AddInParameter(cmd, "@MUC_LUONG", DbType.Decimal, HenPhongVan.MUC_LUONG);
db.AddInParameter(cmd, "@THONG_TIN_KHAC", DbType.String, HenPhongVan.THONG_TIN_KHAC);
//them
db.AddInParameter(cmd, "@SO_NGAY", DbType.Int64, HenPhongVan.SO_NGAY);
//db.AddInParameter(cmd, "@DEN_NGAY", DbType.DateTime, HenPhongVan.DEN_NGAY);
int iCmd = db.ExecuteNonQuery(cmd);
if (iCmd > 0)
return true;
return false;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static bool InsertKhongDat(DOHenPhongVan HenPhongVan)
{
try
{
string sql = "INSERT INTO HEN_PHONG_VAN "
+ "("
+ "ID,R_ID,NGAY_GIO_PHONG_VAN,GIO_PHONG_VAN,VONG_PHONG_VAN,LAN_MOI_PHONG_VAN,MOI_PHONG_VAN,"
+ "UNG_VIEN_XAC_NHAN,UNG_VIEN_XAC_NHAN_GHI_CHU,THAM_DU,THAM_DU_GHI_CHU,KET_QUA,"
+ "KET_QUA_GHI_CHU,THONG_BAO_KET_QUA,"
+ "THONG_TIN_KHAC"
+ ")"
+ "VALUES"
+ "("
+ "@ID,@R_ID,@NGAY_GIO_PHONG_VAN,@GIO_PHONG_VAN,@VONG_PHONG_VAN,@LAN_MOI_PHONG_VAN,@MOI_PHONG_VAN,"
+ "@UNG_VIEN_XAC_NHAN,@UNG_VIEN_XAC_NHAN_GHI_CHU,@THAM_DU,@THAM_DU_GHI_CHU,@KET_QUA,"
+ "@KET_QUA_GHI_CHU,@THONG_BAO_KET_QUA,"
+ "@THONG_TIN_KHAC"
+ ")";
DatabaseFB db = HelpDB.getDatabase();
System.Data.Common.DbCommand cmd = db.GetSQLStringCommand(sql);
db.AddInParameter(cmd, "@ID", DbType.Int64, db.GetID("GEN_HEN_PHONG_VAN_ID"));
db.AddInParameter(cmd, "@R_ID", DbType.Int64, HenPhongVan.R_ID);
db.AddInParameter(cmd, "@NGAY_GIO_PHONG_VAN", DbType.DateTime, HenPhongVan.NGAY_GIO_PHONG_VAN);
db.AddInParameter(cmd, "@GIO_PHONG_VAN", DbType.Time, HenPhongVan.GIO_PHONG_VAN);
db.AddInParameter(cmd, "@VONG_PHONG_VAN", DbType.String, HenPhongVan.VONG_PHONG_VAN);
db.AddInParameter(cmd, "@LAN_MOI_PHONG_VAN", DbType.String, HenPhongVan.LAN_MOI_PHONG_VAN);
db.AddInParameter(cmd, "@MOI_PHONG_VAN", DbType.String, HenPhongVan.MOI_PHONG_VAN);
db.AddInParameter(cmd, "@UNG_VIEN_XAC_NHAN", DbType.String, HenPhongVan.UNG_VIEN_XAC_NHAN);
db.AddInParameter(cmd, "@UNG_VIEN_XAC_NHAN_GHI_CHU", DbType.String, HenPhongVan.UNG_VIEN_XAC_NHAN_GHI_CHU);
db.AddInParameter(cmd, "@THAM_DU", DbType.String, HenPhongVan.THAM_DU);
db.AddInParameter(cmd, "@THAM_DU_GHI_CHU", DbType.String, HenPhongVan.THAM_DU_GHI_CHU);
db.AddInParameter(cmd, "@KET_QUA", DbType.String, HenPhongVan.KET_QUA);
db.AddInParameter(cmd, "@KET_QUA_GHI_CHU", DbType.String, HenPhongVan.KET_QUA_GHI_CHU);
db.AddInParameter(cmd, "@THONG_BAO_KET_QUA", DbType.String, HenPhongVan.THONG_BAO_KET_QUA);
db.AddInParameter(cmd, "@THONG_TIN_KHAC", DbType.String, HenPhongVan.THONG_TIN_KHAC);
int iCmd = db.ExecuteNonQuery(cmd);
if (iCmd > 0)
return true;
return false;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static bool InsertDat(DOHenPhongVan HenPhongVan)
{
try
{
string sql = "INSERT INTO HEN_PHONG_VAN "
+ "("
+ "ID,R_ID,NGAY_GIO_PHONG_VAN,GIO_PHONG_VAN,VONG_PHONG_VAN,LAN_MOI_PHONG_VAN,MOI_PHONG_VAN,"
+ "UNG_VIEN_XAC_NHAN,UNG_VIEN_XAC_NHAN_GHI_CHU,THAM_DU,THAM_DU_GHI_CHU,KET_QUA,"
+ "NGAY_BAT_DAU,THOI_GIAN_LAM_VIEC,KET_QUA_GHI_CHU,"
+ "UNG_VIEN_DA_CHAP_NHAN,THONG_BAO_KET_QUA,"
+ "MUC_LUONG,THONG_TIN_KHAC"
+ ",SO_NGAY" //Them
+ ")"
+ "VALUES"
+ "("
+ "@ID,@R_ID,@NGAY_GIO_PHONG_VAN,@GIO_PHONG_VAN,@VONG_PHONG_VAN,@LAN_MOI_PHONG_VAN,@MOI_PHONG_VAN,"
+ "@UNG_VIEN_XAC_NHAN,@UNG_VIEN_XAC_NHAN_GHI_CHU,@THAM_DU,@THAM_DU_GHI_CHU,@KET_QUA,"
+ "@NGAY_BAT_DAU,@THOI_GIAN_LAM_VIEC,@KET_QUA_GHI_CHU,"
+ "@UNG_VIEN_DA_CHAP_NHAN,@THONG_BAO_KET_QUA,"
+ "@MUC_LUONG,@THONG_TIN_KHAC"
+ ",@SO_NGAY"
+ ")";
DatabaseFB db = HelpDB.getDatabase();
System.Data.Common.DbCommand cmd = db.GetSQLStringCommand(sql);
db.AddInParameter(cmd, "@ID", DbType.Int64, db.GetID("GEN_HEN_PHONG_VAN_ID"));
db.AddInParameter(cmd, "@R_ID", DbType.Int64, HenPhongVan.R_ID);
db.AddInParameter(cmd, "@NGAY_GIO_PHONG_VAN", DbType.DateTime, HenPhongVan.NGAY_GIO_PHONG_VAN);
db.AddInParameter(cmd, "@GIO_PHONG_VAN", DbType.Time, HenPhongVan.GIO_PHONG_VAN);
db.AddInParameter(cmd, "@VONG_PHONG_VAN", DbType.String, HenPhongVan.VONG_PHONG_VAN);
db.AddInParameter(cmd, "@LAN_MOI_PHONG_VAN", DbType.String, HenPhongVan.LAN_MOI_PHONG_VAN);
db.AddInParameter(cmd, "@MOI_PHONG_VAN", DbType.String,HenPhongVan.MOI_PHONG_VAN );
db.AddInParameter(cmd, "@UNG_VIEN_XAC_NHAN", DbType.String, HenPhongVan.UNG_VIEN_XAC_NHAN);
db.AddInParameter(cmd, "@UNG_VIEN_XAC_NHAN_GHI_CHU", DbType.String, HenPhongVan.UNG_VIEN_XAC_NHAN_GHI_CHU);
db.AddInParameter(cmd, "@THAM_DU", DbType.String, HenPhongVan.THAM_DU);
db.AddInParameter(cmd, "@THAM_DU_GHI_CHU", DbType.String, HenPhongVan.THAM_DU_GHI_CHU);
db.AddInParameter(cmd, "@KET_QUA", DbType.String, HenPhongVan.KET_QUA);
db.AddInParameter(cmd, "@NGAY_BAT_DAU", DbType.DateTime, HenPhongVan.NGAY_BAT_DAU);
db.AddInParameter(cmd, "@THOI_GIAN_LAM_VIEC", DbType.String, HenPhongVan.THOI_GIAN_LAM_VIEC);
db.AddInParameter(cmd, "@KET_QUA_GHI_CHU", DbType.String, HenPhongVan.KET_QUA_GHI_CHU);
db.AddInParameter(cmd, "@UNG_VIEN_DA_CHAP_NHAN", DbType.String, HenPhongVan.UNG_VIEN_DA_CHAP_NHAN);
db.AddInParameter(cmd, "@THONG_BAO_KET_QUA", DbType.String, HenPhongVan.THONG_BAO_KET_QUA);
db.AddInParameter(cmd, "@MUC_LUONG", DbType.Decimal, HenPhongVan.MUC_LUONG);
db.AddInParameter(cmd, "@THONG_TIN_KHAC", DbType.String, HenPhongVan.THONG_TIN_KHAC);
//Them
//db.AddInParameter(cmd, "@ISHL_TV_TT", DbType.String, HenPhongVan.ISHL_TV_TT);
db.AddInParameter(cmd, "@SO_NGAY", DbType.Int64, HenPhongVan.SO_NGAY);
//db.AddInParameter(cmd, "@DEN_NGAY", DbType.DateTime, HenPhongVan.DEN_NGAY);
int iCmd = db.ExecuteNonQuery(cmd);
//Xử lý phần Quản lý danh sách Training,...
if (iCmd > 0)
return true;
return false;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void setThongTinHenPhongVan(DOHenPhongVan HenPhongVan)
{
//Page 1
HoTen.Text = DAResume.getNameUngVien(IDKey);
//Page 2
HPV_NgayPV.DateTime = HenPhongVan.NGAY_GIO_PHONG_VAN.Date;
HPV_GioPV.Time = new DateTime(
HenPhongVan.NGAY_GIO_PHONG_VAN.Date.Year,
HenPhongVan.NGAY_GIO_PHONG_VAN.Date.Month,
HenPhongVan.NGAY_GIO_PHONG_VAN.Date.Day,
HenPhongVan.NGAY_GIO_PHONG_VAN.Hour,
HenPhongVan.NGAY_GIO_PHONG_VAN.Minute,
HenPhongVan.NGAY_GIO_PHONG_VAN.Second
);
HPV_VongPV.Value = (decimal)HenPhongVan.VONG_PHONG_VAN;
HPV_LanPV.Value = (decimal)HenPhongVan.LAN_MOI_PHONG_VAN;
HPV_MoiPV.CheckState = (HenPhongVan.MOI_PHONG_VAN == "Y") ? CheckState.Checked : CheckState.Unchecked;
HPV_UVXNGhiChu.Text = HenPhongVan.UNG_VIEN_XAC_NHAN_GHI_CHU;
HPV_ThamDuGhiChu.Text = HenPhongVan.THAM_DU_GHI_CHU;
this.setNhomUngVienXacNhan(HenPhongVan.UNG_VIEN_XAC_NHAN);
this.setNhomThamDu(HenPhongVan.THAM_DU);
//Page 3
if (HenPhongVan.KET_QUA == "1")
{
KQ_KetQuaDat.Checked = true;
KQ_KetQuaDat.Focus();
KQ_NgayBatDau.DateTime = (DateTime)HenPhongVan.NGAY_BAT_DAU;
KQ_MucLuong.Value = HenPhongVan.MUC_LUONG;
if (HenPhongVan.THOI_GIAN_LAM_VIEC == "Y")
KQ_ToanThoiGian.CheckState = CheckState.Checked;
if (HenPhongVan.THOI_GIAN_LAM_VIEC == "N")
KQ_BanThoiGian.CheckState = CheckState.Checked;
KQ_GhiChuDat.Text = HenPhongVan.KET_QUA_GHI_CHU;
KQ_DaThongBaoDat.CheckState = (HenPhongVan.THONG_BAO_KET_QUA == "Y") ? CheckState.Checked : CheckState.Unchecked;
KQ_DaChapNhan.CheckState = (HenPhongVan.UNG_VIEN_DA_CHAP_NHAN == "Y") ? CheckState.Checked : CheckState.Unchecked;
KQ_SoNgay.EditValue = HenPhongVan.SO_NGAY;
//if(HenPhongVan.DEN_NGAY.Equals(new DateTime(1900,1,1)))
// KQ_NgayKetThuc.EditValue = null;
//else KQ_NgayKetThuc.EditValue = HenPhongVan.DEN_NGAY ;
}
else if (HenPhongVan.KET_QUA == "2") {
KQ_KetQuaKhongDat.Checked = true ;
KQ_DaThongBaoKhongDat.CheckState = (HenPhongVan.THONG_BAO_KET_QUA == "Y") ? CheckState.Checked : CheckState.Unchecked;
KQ_GhiChuKhongDat.Text = HenPhongVan.KET_QUA_GHI_CHU;
}
else
{
chk_Cho.Checked = true;
KQ_ChoGhiChu.Text = HenPhongVan.KET_QUA_GHI_CHU;
}
PLTinhTrangHoSo._setSelectedID(DAResume.getTinhTrangHoSo(IDKey));
ThongTinKhac.Text = HenPhongVan.THONG_TIN_KHAC;
}
private DOHenPhongVan getThongTinHenPhongVan()
{
long Id = isAdd != true ? IDKey : -1;
DOHenPhongVan HenPhongVan = new DOHenPhongVan();
HenPhongVan.ID = Id;
HenPhongVan.NGAY_GIO_PHONG_VAN = new DateTime(HPV_NgayPV.DateTime.Year, HPV_NgayPV.DateTime.Month, HPV_NgayPV.DateTime.Day,
HPV_GioPV.Time.Hour, HPV_GioPV.Time.Minute, HPV_GioPV.Time.Second
);
HenPhongVan.GIO_PHONG_VAN = new TimeSpan(HPV_GioPV.Time.Hour, HPV_GioPV.Time.Minute, HPV_GioPV.Time.Second);
HenPhongVan.VONG_PHONG_VAN = (int)HPV_VongPV.Value;
HenPhongVan.LAN_MOI_PHONG_VAN = (int)HPV_LanPV.Value;
HenPhongVan.MOI_PHONG_VAN = (HPV_MoiPV.CheckState == CheckState.Checked) ? "Y" : "N";
HenPhongVan.UNG_VIEN_XAC_NHAN = getUngVienXacNhan();
HenPhongVan.UNG_VIEN_XAC_NHAN_GHI_CHU = HPV_UVXNGhiChu.Text.Trim();
HenPhongVan.THAM_DU = getUngVienThamDu();
HenPhongVan.THAM_DU_GHI_CHU = HPV_ThamDuGhiChu.Text;
HenPhongVan.KET_QUA = getKetQua();
HenPhongVan.KET_QUA_GHI_CHU = getKetQuaGhiChu();
HenPhongVan.UNG_VIEN_DA_CHAP_NHAN = (KQ_DaChapNhan.CheckState == CheckState.Checked) ? "Y" : "N";
HenPhongVan.THOI_GIAN_LAM_VIEC = getThoiGianLamViec();
HenPhongVan.THONG_BAO_KET_QUA = getThongBaoKetQua();
if (KQ_NgayBatDau.DateTime.Equals("") == false)
HenPhongVan.NGAY_BAT_DAU = KQ_NgayBatDau.DateTime;
else
HenPhongVan.NGAY_BAT_DAU = new DateTime(1900, 1, 1);
HenPhongVan.MUC_LUONG = KQ_MucLuong.Value;
HenPhongVan.R_ID = IDKey;
HenPhongVan.THONG_TIN_KHAC = ThongTinKhac.Text;
//Them
//HenPhongVan.ISHL_TV_TT = "";
HenPhongVan.SO_NGAY = (long) KQ_SoNgay.Value;
//HenPhongVan.DEN_NGAY = KQ_NgayBatDau.DateTime.AddDays(17);
return HenPhongVan;
}
