private void save_trakq()
{
cdha_dvll_Oracle cdhadvl_O = new cdha_dvll_Oracle();
// DataGridViewRow row = dview.SelectedRows[0];
int stt = 0;
foreach (DataGridViewRow item in ddsdaduyet.Rows)
{
DataGridViewCell oCell = item.Cells["TRAKQ"];
bool check = Convert.ToBoolean(oCell.Value);
if (check == true && item.Visible == true)
{
cdha_dvll vct = new cdha_dvll();
vct.ID = long.Parse(item.Cells["id_"].Value.ToString());
vct.TRAKQ = "1";
cdhadvl_O.f_update_trakq(vct);
}
else
{
cdha_dvll vct = new cdha_dvll();
vct.ID = long.Parse(item.Cells["id_"].Value.ToString());
vct.TRAKQ = "0";
cdhadvl_O.f_update_trakq(vct);
}
}
f_load_before();
}
public int f_update(cdha_dvll obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
//PHAU THUAT KTC
sql = " update BV115.cdha_dvll ";
sql += " set done='{DONE}',NGAYTHUCHIEN={NGAYTHUCHIEN},NOITHUCHIEN='{NOITHUCHIEN}',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("{NOITHUCHIEN}", obj.Noithuchien);
sql = sql.Replace("{MAKTV}", AccessData.m_userid);
result = OracleData.f_execute_data(sql);
}
catch
{
}
return(result);
}
private void f_duyetthuchien()
{
cdha_dvll_Oracle dvll_Oracle = new cdha_dvll_Oracle();
foreach (DataGridViewRow item in dschuaduyet.Rows)
{
DataGridViewCell oCell = item.Cells["Chon"];
bool check = Convert.ToBoolean(oCell.Value);
if (check == true)
{
cdha_dvll dvll = new cdha_dvll();
dvll.ID = long.Parse(item.Cells["id"].Value.ToString());
dvll.DONE = "1";
dvll.NGAYTHUCHIEN = dngaybc.Value;
dvll.Noithuchien = cbarea.SelectedValue.ToString();
dvll_Oracle.f_update(dvll);
string s_mavp = item.Cells["mavp"].Value.ToString();
string s_tenvp = item.Cells["tenvp"].Value.ToString();
frmnhapvattu frm = new frmnhapvattu("", s_mavp, dvll.ID.ToString(), s_mavp, "1");
frm.Show();
string s_id = dvll.ID.ToString();
cdha_hen_Oracle henOracle = new cdha_hen_Oracle();
henOracle.f_update_dathuchien("1", s_id);
}
}
}
private void btnNhapVT_Click(object sender, EventArgs e)
{
cdha_dvll_Oracle cdhadvl_O = new cdha_dvll_Oracle();
int stt = 0;
foreach (DataGridViewRow item in ddsdaduyet.Rows)
{
DataGridViewCell oCell = item.Cells["CHON_"];
bool check = Convert.ToBoolean(oCell.Value);
if (check == true && item.Visible == true)
{
cdha_dvll vct = new cdha_dvll();
string s_id = item.Cells["id_"].Value.ToString();
string s_mavp = item.Cells["mavp_"].Value.ToString();
string s_tenvp = item.Cells["tenvp_"].Value.ToString();
frmnhapvattu frm = new frmnhapvattu("", s_tenvp, s_id, s_mavp, "0");
frm.Show();
return;
}
}
f_load_before();
}
private void save()
{
cdha_dvll_Oracle cdhadvl_O = new cdha_dvll_Oracle();
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_dvll vct = new cdha_dvll();
vct.ID = long.Parse(item.Cells["ID"].Value.ToString());
vct.MAKP = item.Cells["MAKP"].Value.ToString();
vct.SOHD = item.Cells["SoHDDV"].Value.ToString();
vct.SOBL = item.Cells["SoBL"].Value.ToString();
vct.MADOITUONG = item.Cells["MADOITUONG"].Value.ToString();
vct.MAVP = item.Cells["MAVP"].Value.ToString();
vct.SOLUONG = float.Parse(item.Cells["SL"].Value.ToString());
vct.DONGIA = float.Parse(item.Cells["DONGIA"].Value.ToString());
vct.NGAYCD = DateTime.ParseExact(item.Cells["NGAY"].Value.ToString(), "dd/MM/yyyy", null);
vct.MABSCD = item.Cells["MaBS"].Value.ToString();
DateTime temp = dngaybc.Value;
DateTime value = m_format.DateTime_parse_HHmm(String.Format("{0:dd/MM/yyyy} {1:HH:mm}", temp, DateTime.Now));
vct.NGAYCHUP = value;
vct.MABN = item.Cells["Mabn"].Value.ToString();
vct.STT = stt;
vct.Noithuchien = cbarea.SelectedValue.ToString();
vct.Cdhakhu = AccessData.s_makhuvuc;
cdhadvl_O.f_insert_bv(vct);
stt++;
string s_mavp = item.Cells["mavp"].Value.ToString();
string s_tenvp = item.Cells["tenvp"].Value.ToString();
string s_id = vct.ID.ToString();
frmnhapvattu frm = new frmnhapvattu("", s_tenvp, s_id, s_mavp, "1");
frm.Show();
cdha_hen_Oracle henOracle = new cdha_hen_Oracle();
henOracle.f_update_dathuchien("1", s_id);
}
}
}
public int f_insert_bv(cdha_dvll obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
//PHAU THUAT KTC
sql = "insert into BV115.cdha_dvll (id,ngaycd,ngaychup,mabn,mabs,mabsth,mavp,soLuong,sobl,sohd,makp,madoituong,dongia,userid,maktv,CDHAKHU,NGAYTHUCHIEN,DONE,NGAYUD,NOITHUCHIEN) ";
sql += " values ({ID},{NGAYCD},{NGAYCHUP},'{MABN}',{MABSCD},{MABSTH},{MAVP},{SOLUONG},{SOBL},{SOHD},{MAKP},{MADOITUONG},{DONGIA},{USERID},{USERID},{CDHAKHU},{NGAYCHUP},1,sysdate,{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("{SOBL}", m_format.f_formatdata(obj.SOBL.ToString()));
sql = sql.Replace("{SOHD}", m_format.f_formatdata(obj.SOHD.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);
sql = sql.Replace("{MABSCD}", m_format.f_formatdata(obj.MABSCD.ToString()));
sql = sql.Replace("{MABSTH}", m_format.f_formatdata(obj.MABSTH.ToString()));
sql = sql.Replace("{CDHAKHU}", m_format.f_formatdata(obj.Cdhakhu.ToString()));
sql = sql.Replace("{NGAYUD}", m_format.f_formatdata(obj.NGAYUD.ToString(), "date"));
sql = sql.Replace("{NOITHUCHIEN}", m_format.f_formatdata(obj.Noithuchien));
result = OracleData.f_execute_data(sql);
f_update_v_chidinh(obj.ID.ToString(), "nhapvt", "1");
}
catch
{
}
return(result);
}
private void btnSavefilm_Click(object sender, EventArgs e)
{
cdha_dvll_Oracle dvll_Oracle = new cdha_dvll_Oracle();
foreach (DataGridViewRow item in ddsdaduyet.Rows)
{
DataGridViewCell oCell = item.Cells["Chon_"];
bool check = Convert.ToBoolean(oCell.Value);
if (check == true)
{
cdha_dvll dvll = new cdha_dvll();
dvll.ID = long.Parse(item.Cells["id_"].Value.ToString());
string s_mavp = item.Cells["mavp_"].Value.ToString();
string s_tenvp = item.Cells["tenvp_"].Value.ToString();
frmnhapvattu frm = new frmnhapvattu("", s_tenvp, dvll.ID.ToString(), s_mavp, "1");
frm.Show();
}
}
}
private void f_xoaduyet()
{
cdha_dvll_Oracle dvll_Oracle = new cdha_dvll_Oracle();
foreach (DataGridViewRow item in ddsdaduyet.Rows)
{
DataGridViewCell oCell = item.Cells["Chon_"];
bool check = Convert.ToBoolean(oCell.Value);
if (check == true)
{
cdha_dvll dvll = new cdha_dvll();
string s_id = item.Cells["id_"].Value.ToString();
dvll.ID = long.Parse(s_id);
dvll.DONE = "0";
dvll.NGAYTHUCHIEN = DateTime.Now;
dvll_Oracle.f_update(dvll);
cdha_hen_Oracle henOracle = new cdha_hen_Oracle();
henOracle.f_update_dathuchien("0", s_id);
}
}
}
private void save()
{
cdha_dvll_Oracle cdhadvl_O = new cdha_dvll_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_dvll vct = new cdha_dvll();
vct.ID = long.Parse(item.Cells["ID"].Value.ToString());
vct.MAKP = item.Cells["MAKP"].Value.ToString();
vct.SOHD = item.Cells["SoHDDV"].Value.ToString();
vct.SOBL = item.Cells["SoBL"].Value.ToString();
vct.MADOITUONG = item.Cells["MADOITUONG"].Value.ToString();
vct.MAVP = item.Cells["MAVP"].Value.ToString();
vct.SOLUONG = float.Parse(item.Cells["SL"].Value.ToString());
vct.DONGIA = float.Parse(item.Cells["DONGIA"].Value.ToString());
vct.NGAYCD = DateTime.ParseExact(item.Cells["NGAY"].Value.ToString(), "dd/MM/yyyy", null);
vct.MABSCD = item.Cells["MaBS"].Value.ToString();
vct.NGAYCHUP = dngaybc.Value;
vct.MABN = txtMaBN.Text;
vct.STT = stt;
vct.Cdhakhu = AccessData.s_makhuvuc;
cdhadvl_O.f_insert(vct);
stt++;
}
}
}
public int f_update_trakq(cdha_dvll obj)
{
int result = 0;
try
{
string userid = AccessData.m_userid;
//PHAU THUAT KTC
sql = " update BV115.cdha_dvll ";
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);
}
