private void f_insert()
{
try
{
DMNV_Oracle NV_Oracle = new DMNV_Oracle();
CDMNV nv = new CDMNV();
Capid_Oracle Id_oracle = new Capid_Oracle();
string s_id = Id_oracle.f_get("DMNV");
Id_oracle.f_update_one("DMNV");
nv.Ma = int.Parse(s_id).ToString("D4");
txtID.Text = nv.Ma;
nv.Hoten = txtHoTen.Text;
nv.Ngaysinh = dngaysinh.Value;
nv.Phai = cbPhai.SelectedIndex.ToString();
nv.Dienthoai = txtDienThoai.Text;
nv.Diachi = txtDiaChi.Text;
nv.Makp = cbDanhMucKP.SelectedValue.ToString();
nv.Nhom = cbNhom.SelectedValue.ToString();
nv.Chuyenkhoa = cbchuyenkhoa.SelectedValue.ToString();
nv.Ngonngu = txtNgoaiNgu.Text;
nv.Bangcap = txtbangcap.Text;
nv.Dtnuocngoai = txtdtnuocngoai.Text;
nv.Kinhnghiem = txtkinhnghiem.Text;
nv.Trinhdo = cbtrinhdo.SelectedValue.ToString();
NV_Oracle.f_insert(nv);
}
catch { }
}
public int f_insert(CDMNV obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
//PHAU THUAT KTC
sql = "insert into " + schema + ".DMNV(MA,HOTEN,MAKP,VIETTAT,DIENTHOAI,DIDONG, ";
sql += " MESSAGE,CHUYENKHOA,NGONNGU,PHAI,DTNUOCNGOAI,BANGCAP,KINHNGHIEM,NGAYSINH, ";
sql += " DIACHI,NGAYUD,TRINHDO) ";
sql += " VALUES ( '{MA}','{HOTEN}','{MAKP}','{VIETTAT}','{DIENTHOAI}','{DIDONG}', ";
sql += " '{MESSAGE}',{CHUYENKHOA},'{NGONNGU}',{PHAI},'{DTNUOCNGOAI}','{BANGCAP}','{KINHNGHIEM}',{NGAYSINH}, ";
sql += " '{DIACHI}',sysdate,'{TRINHDO}') ";
sql = sql.Replace("{MA}", obj.Ma);
sql = sql.Replace("{HOTEN}", obj.Hoten);
sql = sql.Replace("{MAKP}", obj.Makp);
sql = sql.Replace("{VIETTAT}", obj.Viettat);
sql = sql.Replace("{DIENTHOAI}", obj.Dienthoai);
sql = sql.Replace("{DIDONG}", obj.Didong);
sql = sql.Replace("{MESSAGE}", obj.Message);
sql = sql.Replace("{CHUYENKHOA}", obj.Chuyenkhoa);
sql = sql.Replace("{NGONNGU}", obj.Ngonngu);
sql = sql.Replace("{PHAI}", obj.Phai);
sql = sql.Replace("{DTNUOCNGOAI}", obj.Dtnuocngoai);
sql = sql.Replace("{BANGCAP}", obj.Bangcap);
sql = sql.Replace("{KINHNGHIEM}", obj.Kinhnghiem);
sql = sql.Replace("{NGAYSINH}", m_format.f_formatdata(obj.Ngaysinh.ToString(), "date"));
sql = sql.Replace("{DIACHI}", obj.Diachi);
sql = sql.Replace("{TRINHDO}", obj.Trinhdo);
result = OracleData.f_execute_data(sql);
}
catch
{
}
return(result);
}
public int f_update(CDMNV obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
//PHAU THUAT KTC
sql = "update " + schema + ".DMNV set HOTEN='{HOTEN}',MAKP='{MAKP}',VIETTAT='{VIETTAT}',DIENTHOAI='{DIENTHOAI}',DIDONG='{DIDONG}', ";
sql += " MESSAGE='{MESSAGE}',CHUYENKHOA={CHUYENKHOA},NGONNGU='{NGONNGU}',PHAI={PHAI},DTNUOCNGOAI='{DTNUOCNGOAI}',BANGCAP='{BANGCAP}', ";
sql += "KINHNGHIEM='{KINHNGHIEM}',NGAYSINH={NGAYSINH},DIACHI='{DIACHI}',TRINHDO='{TRINHDO}' ";
sql += " where MA='{MA}' ";
sql = sql.Replace("{MA}", obj.Ma);
sql = sql.Replace("{HOTEN}", obj.Hoten);
sql = sql.Replace("{MAKP}", obj.Makp);
sql = sql.Replace("{VIETTAT}", obj.Viettat);
sql = sql.Replace("{DIENTHOAI}", obj.Dienthoai);
sql = sql.Replace("{DIDONG}", obj.Didong);
sql = sql.Replace("{MESSAGE}", obj.Message);
sql = sql.Replace("{CHUYENKHOA}", obj.Chuyenkhoa);
sql = sql.Replace("{NGONNGU}", obj.Ngonngu);
sql = sql.Replace("{PHAI}", obj.Phai);
sql = sql.Replace("{DTNUOCNGOAI}", obj.Dtnuocngoai);
sql = sql.Replace("{BANGCAP}", obj.Bangcap);
sql = sql.Replace("{KINHNGHIEM}", obj.Kinhnghiem);
sql = sql.Replace("{NGAYSINH}", m_format.f_formatdata(obj.Ngaysinh.ToString(), "date"));
sql = sql.Replace("{DIACHI}", obj.Diachi);
sql = sql.Replace("{TRINHDO}", obj.Trinhdo);
result = OracleData.f_execute_data(sql);
}
catch
{
}
return(result);
}
private void f_update()
{
try{
DMNV_Oracle NV_Oracle = new DMNV_Oracle();
CDMNV nv = new CDMNV();
nv.Ma = txtID.Text;
nv.Hoten = txtHoTen.Text;
nv.Ngaysinh = dngaysinh.Value;
nv.Phai = cbPhai.SelectedIndex.ToString();
nv.Dienthoai = txtDienThoai.Text;
nv.Diachi = txtDiaChi.Text;
nv.Makp = cbDanhMucKP.SelectedValue.ToString();
nv.Nhom = cbNhom.SelectedValue.ToString();
nv.Chuyenkhoa = cbchuyenkhoa.SelectedValue.ToString();
nv.Ngonngu = txtNgoaiNgu.Text;
nv.Bangcap = txtbangcap.Text;
nv.Dtnuocngoai = txtdtnuocngoai.Text;
nv.Kinhnghiem = txtkinhnghiem.Text;
nv.Trinhdo = cbtrinhdo.SelectedValue.ToString();
NV_Oracle.f_update(nv);
}catch {}
}
