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