public int f_insert(CCDHA_THUOCPHIM obj) { int result = 0; try { string userid = AccessData.m_userid; //PHAU THUAT KTC sql = "insert into " + schema + ".cdha_thuocphim(id,stt,mabd,soluong,sl_phimhu,ngayud) values "; sql += "({ID},{STT},{MABD},{SOLUONG},{SL_PHIMHU},sysdate)"; sql = sql.Replace("{ID}", obj.Id.ToString()); sql = sql.Replace("{STT}", obj.Stt.ToString()); sql = sql.Replace("{MABD}", obj.Mabd.ToString()); sql = sql.Replace("{SOLUONG}", obj.Soluong.ToString()); sql = sql.Replace("{SL_PHIMHU}", obj.Sl_phimhu.ToString()); result = OracleData.f_execute_data(sql); } catch { } return(result); }
private void f_save() { dataOracle.f_delete(long.Parse(_s_id)); foreach (DataGridViewRow dr in dDanhMuc.Rows) { if (dr.IsNewRow == false) { CCDHA_THUOCPHIM item = new CCDHA_THUOCPHIM(); item.Id = _s_id; item.Mabd = int.Parse(dr.Cells["cbloai"].Value.ToString()); item.Mavp = int.Parse(_s_mavp); item.Soluong = double.Parse(dr.Cells["soluong"].Value.ToString()); item.Sl_phimhu = double.Parse(dr.Cells["sl_hu"].Value.ToString()); item.Stt = dr.Index.ToString();; dataOracle.f_insert(item); } } }