public int f_insert(cdha_hen obj) { int result = 0; try { string userid = AccessData.m_userid; //PHAU THUAT KTC sql = "insert into BV115.cdha_hen (id,ngaycd,ngaychup,mabn,mabs,mavp,soLuong,makp,madoituong,dongia,userid,noithuchien) "; sql += " values ({ID},{NGAYCD},{NGAYCHUP},'{MABN}',{MABSCD},{MAVP},{SOLUONG},{MAKP},{MADOITUONG},{DONGIA},{USERID},{NOITHUCHIEN}) "; sql = sql.Replace("{ID}", obj.ID.ToString()); sql = sql.Replace("{NGAYCD}", m_format.f_formatdata(obj.NGAYCD.ToString(), "date")); sql = sql.Replace("{NGAYCHUP}", m_format.f_formatdata(obj.NGAYCHUP.ToString(), "date")); sql = sql.Replace("{MABN}", obj.MABN.ToString()); sql = sql.Replace("{MAKP}", m_format.f_formatdata(obj.MAKP.ToString())); sql = sql.Replace("{MADOITUONG}", m_format.f_formatdata(obj.MADOITUONG.ToString())); sql = sql.Replace("{MAVP}", m_format.f_formatdata(obj.MAVP.ToString())); sql = sql.Replace("{SOLUONG}", obj.SOLUONG.ToString()); sql = sql.Replace("{DONGIA}", obj.DONGIA.ToString()); sql = sql.Replace("{NOITHUCHIEN}", obj.NOITHUCHIEN.ToString()); sql = sql.Replace("{MABSCD}", m_format.f_formatdata(obj.MABSCD.ToString())); sql = sql.Replace("{MADOITUONG}", m_format.f_formatdata(obj.MADOITUONG.ToString())); sql = sql.Replace("{USERID}", AccessData.m_userid); result = OracleData.f_execute_data(sql); f_update_v_chidinh(obj.ID.ToString(), "hen", "1"); } catch { } return(result); }
public int f_update(cdha_hen obj) { int result = 0; try { string userid = AccessData.m_userid; //PHAU THUAT KTC sql = " update BV115.cdha_hen "; sql += " set done='{DONE}',NGAYTHUCHIEN={NGAYTHUCHIEN},MAKTV='{MAKTV}' , ngayud=sysdate"; sql += " where id={ID} "; sql = sql.Replace("{ID}", obj.ID.ToString()); sql = sql.Replace("{NGAYTHUCHIEN}", m_format.f_formatdata(obj.NGAYTHUCHIEN.ToString(), "date")); sql = sql.Replace("{DONE}", obj.DONE); sql = sql.Replace("{MAKTV}", AccessData.m_userid); result = OracleData.f_execute_data(sql); } catch { } return(result); }
private void save() { cdha_hen_Oracle cdha_hen_O = new cdha_hen_Oracle(); // DataGridViewRow row = dview.SelectedRows[0]; int stt = 0; foreach (DataGridViewRow item in dview.Rows) { DataGridViewCell oCell = item.Cells["check"]; bool check = Convert.ToBoolean(oCell.Value); if (check == true && item.Visible == true) { cdha_hen vct = new cdha_hen(); //sql = "insert into BV115.cdha_hen (id,ngaycd,ngaychup,mabn,mabs,mavp,soLuong,makp,madoituong,dongia,userid) "; vct.ID = long.Parse(item.Cells["ID"].Value.ToString()); vct.NGAYCD = DateTime.ParseExact(item.Cells["NGAY"].Value.ToString(), "dd/MM/yyyy HH:mm", null); vct.NGAYCHUP = dngaybc.Value.Date; vct.MABN = item.Cells["MABN"].Value.ToString(); vct.MABSCD = item.Cells["MaBS"].Value.ToString(); vct.MAVP = item.Cells["MAVP"].Value.ToString(); vct.SOLUONG = float.Parse(item.Cells["SL"].Value.ToString()); vct.MAKP = item.Cells["MAKP"].Value.ToString(); vct.MADOITUONG = item.Cells["MADOITUONG"].Value.ToString(); vct.DONGIA = float.Parse(item.Cells["DONGIA"].Value.ToString()); vct.USERTN = AccessData.m_userid; vct.STT = stt; vct.NOITHUCHIEN = cbarea.SelectedValue.ToString(); cdha_hen_O.f_insert(vct); stt++; } } f_loadDS(); }
public int f_update_trakq(cdha_hen obj) { int result = 0; try { string userid = AccessData.m_userid; //PHAU THUAT KTC sql = " update BV115.cdha_hen "; sql += " set trakq={TRAKQ}, ngayud=sysdate"; sql += " where id={ID} "; sql = sql.Replace("{ID}", obj.ID.ToString()); sql = sql.Replace("{TRAKQ}", obj.TRAKQ); result = OracleData.f_execute_data(sql); } catch { } return(result); }