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