public int f_update(v_bhytds obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
sql = "update " + schema + ".e_bhytds ";
sql += " set MAICD={MAICD} ,CHANDOAN={CHANDOAN},MAKP={MAKP} ";
sql += " ,sothe={SOTHE},TUNGAY=TO_DATE('{TUNGAY}','dd/MM/yyyy'),DENNGAY=TO_DATE('{DENNGAY}','dd/MM/yyyy')";
sql += " where id={ID} ";
sql = sql.Replace("{ID}", obj.ID.ToString());
sql = sql.Replace("{CHANDOAN}", m_format.f_formatdata(obj.CHANDOAN.ToString()));
sql = sql.Replace("{MAICD}", m_format.f_formatdata(obj.MAICD.ToString()));
sql = sql.Replace("{SOTHE}", m_format.f_formatdata(obj.SOTHE));
sql = sql.Replace("{MAKP}", m_format.f_formatdata(obj.MaKP));
sql = sql.Replace("{TUNGAY}", string.Format("{0:dd/MM/yyyy}", obj.TUNGAY));
sql = sql.Replace("{DENNGAY}", string.Format("{0:dd/MM/yyyy}", obj.DENNGAY));
result = OracleData.f_execute_data(sql);
}
catch
{
}
return(result);
}
public int f_update_ICD(v_bhytds obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
sql = "update " + schema + ".e_bhytds ";
sql += " set MAICD={MAICD} ,CHANDOAN={CHANDOAN} ";
sql += " where id={ID} ";
sql = sql.Replace("{ID}", obj.ID.ToString());
sql = sql.Replace("{CHANDOAN}", m_format.f_formatdata(obj.CHANDOAN.ToString()));
sql = sql.Replace("{MAICD}", m_format.f_formatdata(obj.MAICD.ToString()));
result = OracleData.f_execute_data(sql);
}
catch
{
}
return(result);
}
public int f_insert(v_bhytds obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
//PHAU THUAT KTC
sql = "insert into " + schema + ".e_bhytds(ID,MABN,MAVAOVIEN,MAQL,IDKHOA,GIUONG,NGAYVAO,NGAYRA,CHANDOAN, ";
sql += " MAICD,SOTHE,MAPHU,TUNGAY,DENNGAY,MABV,NOIGIOITHIEU,TRAITUYEN,COMPUTER,USERID,NGAYUD,MAICDKT,CHANDOANKT,BCKTC,BCTHUOCUB,MAKP,HUONGKTC,MACN) ";
sql += " values ({ID},{MABN},{MAVAOVIEN},{MAQL},{IDKHOA},{GIUONG},{NGAYVAO},{NGAYRA},{CHANDOAN},";
sql += " {MAICD},{SOTHE},{MAPHU},{TUNGAY},{DENNGAY},{MABV},{NOIGIOITHIEU},{TRAITUYEN},{COMPUTER},{USERID},{NGAYUD},{MAICDKT},{CHANDOANKT},{BCKTC},{BCTHUOCUB},{MAKP},{HUONGKTC},{MACN}) ";
sql = sql.Replace("{ID}", obj.ID.ToString());
sql = sql.Replace("{MABN}", m_format.f_formatdata(obj.MABN.ToString()));
sql = sql.Replace("{MAVAOVIEN}", obj.MAVAOVIEN.ToString());
sql = sql.Replace("{MAQL}", obj.MAQL.ToString());
sql = sql.Replace("{IDKHOA}", obj.IDKHOA.ToString());
sql = sql.Replace("{GIUONG}", m_format.f_formatdata(obj.GIUONG.ToString()));
sql = sql.Replace("{NGAYVAO}", m_format.f_formatdata(obj.NGAYVAO.ToString(), "date"));
sql = sql.Replace("{NGAYRA}", m_format.f_formatdata(obj.NGAYRA.ToString(), "date"));
sql = sql.Replace("{CHANDOAN}", m_format.f_formatdata(obj.CHANDOAN.ToString()));
sql = sql.Replace("{MAICD}", m_format.f_formatdata(obj.MAICD.ToString()));
sql = sql.Replace("{SOTHE}", m_format.f_formatdata(obj.SOTHE.ToString()));
sql = sql.Replace("{MAPHU}", m_format.f_formatdata(obj.MAPHU.ToString()));
sql = sql.Replace("{TUNGAY}", m_format.f_formatdata(obj.TUNGAY.ToString(), "date"));
sql = sql.Replace("{DENNGAY}", m_format.f_formatdata(obj.DENNGAY.ToString(), "date"));
sql = sql.Replace("{MABV}", m_format.f_formatdata(obj.MABV.ToString()));
sql = sql.Replace("{NOIGIOITHIEU}", m_format.f_formatdata(obj.NOIGIOITHIEU.ToString()));
sql = sql.Replace("{TRAITUYEN}", obj.TRAITUYEN.ToString());
sql = sql.Replace("{COMPUTER}", m_format.f_formatdata(obj.COMPUTER.ToString()));
sql = sql.Replace("{USERID}", obj.USERID.ToString());
sql = sql.Replace("{NGAYUD}", m_format.f_formatdata(obj.NGAYUD.ToString(), "date"));
sql = sql.Replace("{MAICDKT}", m_format.f_formatdata(obj.MAICDKT.ToString()));
sql = sql.Replace("{CHANDOANKT}", m_format.f_formatdata(obj.CHANDOANKT.ToString()));
sql = sql.Replace("{BCKTC}", m_format.f_formatdata(obj.BCKTC.ToString()));
sql = sql.Replace("{BCTHUOCUB}", m_format.f_formatdata(obj.BCThuocUB.ToString()));
sql = sql.Replace("{MAKP}", m_format.f_formatdata(obj.MaKP.ToString()));
sql = sql.Replace("{HUONGKTC}", m_format.f_formatdata(obj.HuongKTC.ToString()));
sql = sql.Replace("{MACN}", m_format.f_formatdata(obj.Macanngheo.ToString()));
result = OracleData.f_execute_data(sql);
eve_log.Action = "INSERT";
eve_log.Content = schema + ".E_BHYTDS_" + obj.ID + "_" + obj.MABN + "_" + obj.SOTHE + "_" + obj.MAVAOVIEN;
eve_logDAO.f_insert(eve_log);
}
catch
{
}
return(result);
}
private void btSave_Click(object sender, EventArgs e)
{
try
{
v_bhytds v_ds = new v_bhytds();
v_bhytds_Oracle Ora_v_bhytds = new v_bhytds_Oracle();
v_ds.ID = long.Parse(txtIDDuyet.Text);
v_ds.MAICD = txtMaICD.Text;
v_ds.CHANDOAN = txtChanDoan.Text;
Ora_v_bhytds.f_update_ICD(v_ds);
}
catch { }
}
public int f_update(v_bhytds obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
sql = "update " + schema + ".v_bhytds ";
sql += " set MAICD={MAICD} ,CHANDOAN={CHANDOAN},MAKP={MAKP} ";
sql += " ,sothe={SOTHE},NGAYVAO=TO_DATE('{NGAYVAO}','dd/MM/yyyy'),NGAYRA=TO_DATE('{NGAYRA}','dd/MM/yyyy')";
sql += " ,TUNGAY=TO_DATE('{TUNGAY}','dd/MM/yyyy'),DENNGAY=TO_DATE('{DENNGAY}','dd/MM/yyyy') ";
sql += " where id={ID} ";
sql = sql.Replace("{ID}", obj.ID.ToString());
sql = sql.Replace("{CHANDOAN}", m_format.f_formatdata(obj.CHANDOAN.ToString()));
sql = sql.Replace("{MAICD}", m_format.f_formatdata(obj.MAICD.ToString()));
sql = sql.Replace("{SOTHE}", m_format.f_formatdata(obj.SOTHE));
sql = sql.Replace("{MAKP}", m_format.f_formatdata(obj.MaKP));
sql = sql.Replace("{NGAYVAO}", string.Format("{0:dd/MM/yyyy}", obj.NGAYVAO));
sql = sql.Replace("{NGAYRA}", string.Format("{0:dd/MM/yyyy}", obj.NGAYRA));
sql = sql.Replace("{TUNGAY}", string.Format("{0:dd/MM/yyyy}", obj.TUNGAY));
sql = sql.Replace("{DENNGAY}", string.Format("{0:dd/MM/yyyy}", obj.DENNGAY));
result = OracleData.f_execute_data(sql);
eve_log.Action = "UPDATE";
eve_log.Content = schema + ".v_BHYTDS_" + obj.ID.ToString() + "_" + obj.MABN + "_" + obj.SOTHE + "_" + string.Format("{0:dd/MM/yyyy}", obj.NGAYVAO);
eve_log.Content += "_" + string.Format("{0:dd/MM/yyyy}", obj.NGAYRA) + "_" + obj.MAICD.ToString();
eve_logDAO.f_insert(eve_log);
}
catch
{
}
return(result);
}
