private void f_loaddsdaduyet()
{
cdha_hen_Oracle dvll_Ora = new cdha_hen_Oracle();
DateTime tungay = d_tungay.Value;
DateTime denngay = d_denngay.Value;
string s_makp;
try
{
s_makp = cbDanhMucKP.SelectedValue.ToString();
}
catch
{
s_makp = "-1";
}
DataTable dtcp = dvll_Ora.f_getCLS_DADUYET_KHOA(tungay, denngay, s_makp);
ddsdaduyet.Rows.Clear();
foreach (DataRow item in dtcp.Rows)
{
ddsdaduyet.Rows.Add(item.ItemArray);
}
format_grid();
}
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 init()
{
try
{
lbkhu.Text = AccessData.s_tenkhuvuc;
DataSet ds = new DataSet();
cdha_hen_Oracle Data_cdha_hen = new cdha_hen_Oracle();
ds = Data_cdha_hen.f_getCDHA_Loai("");
cbCDHA_loai.DataSource = ds.Tables[0];
cbCDHA_loai.DisplayMember = "Name";
cbCDHA_loai.ValueMember = "ID";
cbCDHA_loai.SelectedIndex = 0;
ds = Data_cdha_hen.f_getCDHA_NOITHUCHIEN(AccessData.s_makhuvuc);
cbarea.DataSource = ds.Tables[0];
cbarea.DisplayMember = "Name";
cbarea.ValueMember = "ID";
cbarea.SelectedIndex = 0;
panel1.Visible = false;
panel3.Visible = false;
xml_read();
m_option option = new m_option();
date_lock = option.f_get_CDHA_LockDate(AccessData.s_makhuvuc);
}
catch { }
}
private void btnSave_Click(object sender, EventArgs e)
{
cdha_hen_Oracle O_henData = new cdha_hen_Oracle();
string s_thuchien = "0";
string s_noithuchien = cbarea.SelectedValue.ToString();
foreach (DataGridViewRow dr in ddsdaduyet.Rows)
{
s_thuchien = "0";
try
{
DataGridViewCell oCell = dr.Cells["TRAKQ"];
bool check = Convert.ToBoolean(oCell.Value);
if (check == true && dr.Visible == true)
{
s_thuchien = "1";
}
}
catch { }
string s_thoigian = dr.Cells["NGAY_HEN"].Value.ToString() + " " + mformat.f_GetTime(dr.Cells["GIO_HEN"].Value.ToString());
string s_id = dr.Cells["id_"].Value.ToString();
O_henData.f_update_thoigianhen(s_thoigian, s_thuchien, s_id, s_noithuchien);
}
f_loadDS();
}
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();
}
private void init()
{
try {
cdha_hen_Oracle Data_cdha_hen = new cdha_hen_Oracle();
ds = Data_cdha_hen.f_getCDHA_Loai("");
cbCDHA_loai.DataSource = ds.Tables[0];
cbCDHA_loai.DisplayMember = "Name";
cbCDHA_loai.ValueMember = "ID";
cbCDHA_loai.SelectedIndex = 0;
ds = Data_cdha_hen.f_getCDHA_NOITHUCHIEN(AccessData.s_makhuvuc);
cbarea.DataSource = ds.Tables[0];
cbarea.DisplayMember = "Name";
cbarea.ValueMember = "ID";
cbarea.SelectedIndex = 0;
ds = Data_cdha_hen.f_getCDHA_NOITHUCHIEN("-1");
DataTable dt = ds.Tables[0].Copy();
cbNoiChuyen.DataSource = dt;
cbNoiChuyen.DisplayMember = "Name";
cbNoiChuyen.ValueMember = "ID";
cbNoiChuyen.SelectedIndex = 0;
xml_read();
}
catch { }
}
private void frmBCDuocMau20_Load(object sender, EventArgs e)
{
cbLoai.SelectedIndex = 0;
cdha_hen_Oracle Data_cdha_hen = new cdha_hen_Oracle();
treeview_room.setDataSource(Data_cdha_hen.f_getCDHA_NOITHUCHIEN(AccessData.s_makhuvuc).Tables[0], "Name", "Id", "NƠI THỰC HIỆN", false, "NƠI THỰC HIỆN");
}
private void btnXoa_Click(object sender, EventArgs e)
{
cdha_hen_Oracle O_henData = new cdha_hen_Oracle();
foreach (DataGridViewRow dr in ddsdaduyet.Rows)
{
DataGridViewCell oCell = dr.Cells["chon_"];
bool check = Convert.ToBoolean(oCell.Value);
if (check == true && dr.Visible == true)
{
O_henData.f_delete(long.Parse(dr.Cells["id_"].Value.ToString()));
}
}
f_loadDS();
}
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);
}
}
}
private void init()
{
try
{
DataSet ds = new DataSet();
cdha_hen_Oracle Data_cdha_hen = new cdha_hen_Oracle();
//ds = Data_cdha_hen.f_getCDHA_Loai("");
//cbCDHA_loai.DataSource = ds.Tables[0];
//cbCDHA_loai.DisplayMember = "Name";
//cbCDHA_loai.ValueMember = "ID";
//cbCDHA_loai.SelectedIndex = 0;
ds = Data_cdha_hen.f_getCDHA_NOITHUCHIEN("-1");
cbarea.DataSource = ds.Tables[0];
cbarea.DisplayMember = "Name";
cbarea.ValueMember = "ID";
cbarea.SelectedIndex = 0;
}
catch { }
}
private void f_loaddsxeplich()
{
try
{
cdha_hen_Oracle dvll_Ora = new cdha_hen_Oracle();
DateTime tungay = d_tungay.Value;
DateTime denngay = d_denngay.Value;
// string s_dieukien "";= cbCDHA_loai.SelectedValue.ToString();
string s_noithuchien = cbarea.SelectedValue.ToString();
DataTable dtcp = dvll_Ora.f_getCLS_DADUYET(tungay, denngay, "", s_noithuchien);
dsxeplich.Rows.Clear();
foreach (DataRow item in dtcp.Rows)
{
dsxeplich.Rows.Add(item.ItemArray);
}
format_grid();
}
catch { }
}
private void btListHen_Click(object sender, EventArgs e)
{
cdha_hen_Oracle dvll_Ora = new cdha_hen_Oracle();
DateTime tungay = d_tungay.Value;
DateTime denngay = d_denngay.Value;
string s_makp;
try{
s_makp = cbDanhMucKP.SelectedValue.ToString();
}catch {
s_makp = "-1";
}
DataTable mydt = dvll_Ora.f_getCLS_DADUYET_KHOA(tungay, denngay, s_makp);
AccessData d = new AccessData();
string s_reportname = "danhsachhen_bc.rpt";
string s_title = "";
frmReport a = new frmReport(d, mydt, s_reportname, s_title, "họ tên", "Giam đốc", "", "", "", "", "", "", "");
a.Show();
}
private void Load_Chitiet_CP()
{
try
{
cdha_hen_Oracle dataOracle = new cdha_hen_Oracle();
DateTime ngayvao = dngayvao.Value;
DateTime ngayra = dngayra.Value;
string s_dieukien = cbCDHA_loai.SelectedValue.ToString();
DataTable dtcp = dataOracle.f_getDanhSach(ngayvao, ngayra, s_dieukien).Tables[0];
dview.Rows.Clear();
foreach (DataRow item in dtcp.Rows)
{
dview.Rows.Add(item.ItemArray);
}
}
catch { }
}
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 f_suadaduyet()
{
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)
{
DateTime ngayth = m_format.DateTime_parse(item.Cells["ngayth2"].Value.ToString());
if (f_kiemtra_locked(ngayth))
{
string s_id = item.Cells["id_"].Value.ToString();
dvll_Oracle.f_delete(long.Parse(s_id));
cdha_hen_Oracle henOracle = new cdha_hen_Oracle();
henOracle.f_update_dathuchien("0", s_id);
}
}
}
}
private void btLuuChuyen_Click(object sender, EventArgs e)
{
cdha_hen_Oracle O_henData = new cdha_hen_Oracle();
string s_thuchien = "0";
string s_noithuchien = cbNoiChuyen.SelectedValue.ToString();
foreach (DataGridViewRow dr in ddsdaduyet.Rows)
{
DataGridViewCell oCellChon = dr.Cells["chon_"];
bool checkchon = false;
try{
checkchon = Convert.ToBoolean(oCellChon.Value);
}catch {}
if (checkchon == true && dr.Visible == true)
{
s_thuchien = "0";
DataGridViewCell oCell = dr.Cells["TRAKQ"];
bool check = false;
try
{
check = Convert.ToBoolean(oCell.Value);
}
catch { }
if (check == true && dr.Visible == true)
{
s_thuchien = "1";
}
string s_thoigian = string.Format("{0:dd/MM/yyyy} 00:00", dngaychuyen.Value);
string s_id = dr.Cells["id_"].Value.ToString();
O_henData.f_update_thoigianhen(s_thoigian, s_thuchien, s_id, s_noithuchien);
}
}
f_loadDS();
pnchuyen.Visible = false;
}
