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); }