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