private void load_dmnhombd() { s_makho = ""; sql = "select * from " + user + ".d_dmnhom where nhom=" + int.Parse(nhom.SelectedValue.ToString()); sql += " order by stt"; dtnhom = d.get_data(sql).Tables[0]; dmnhom.DataSource = dtnhom; }
private void frmChonthongso_Load(object sender, EventArgs e) { cmbsophieu.DisplayMember = "sophieu"; cmbsophieu.ValueMember = "id"; cmbKho.DisplayMember = "ten"; cmbKho.ValueMember = "id"; cmbKho.DataSource = d.get_data("select id,ten from " + d.user + ".d_dmkho").Tables[0]; }
private void frmPhieuxuat_ng_Load(object sender, System.EventArgs e) { user = d.user; stime = "'" + d.f_ngay + "'"; i_dongiale = d.d_dongia_le(i_nhom); sql = "select * from " + user + ".d_duockp "; sql += " where nhom like '%" + i_nhom.ToString() + ",%'"; if (s_makp != "") { string s = s_makp.Replace(",", "','"); sql += " and makp in ('" + s.Substring(0, s.Length - 3) + "')"; } sql += " order by stt"; dtkp = d.get_data(sql).Tables[0]; makp.DataSource = dtkp; makp.DisplayMember = "TEN"; makp.ValueMember = "ID"; sql = "select * from " + user + ".d_dmloaint where nhom=" + i_nhom; if (s_loaint != "") { sql += " and id in (" + s_loaint.Substring(0, s_loaint.Length - 1) + ")"; } sql += " order by stt"; dtloai = d.get_data(sql).Tables[0]; loai.DataSource = dtloai; loai.DisplayMember = "TEN"; loai.ValueMember = "ID"; sql = "select a.*,b.stt as sttnhom,b.ten as tennhom,c.ten as tenhang "; sql += " from " + user + ".d_dmbd a," + user + ".d_dmnhom b," + user + ".d_dmhang c where a.manhom=b.id and a.mahang=c.id and a.nhom=" + i_nhom; dt = d.get_data(sql).Tables[0]; s_makho = d.get_dmkho(7).Trim(); s_makho = (s_makho == "") ? "" : s_makho.Substring(0, s_makho.Length - 1); sql = "select * from " + user + ".d_dmkho where hide=0 and nhom=" + i_nhom; if (s_makho != "") { sql += " and id in (" + s_makho + ")"; } sql += " order by stt"; dtdmkho = d.get_data(sql).Tables[0]; kho.DataSource = dtdmkho; kho.DisplayMember = "TEN"; kho.ValueMember = "ID"; ds.ReadXml("..//..//..//xml//d_thkhoa.xml"); dsxml.ReadXml("..//..//..//xml//d_thkhoa.xml"); }
private void frmTtkcb_Load(object sender, System.EventArgs e) { user = m.user; s_thetrongtinh = d.thetrongtinh(m.nhom_duoc); s_thetunguyen = d.thetunguyen(m.nhom_duoc); if (s_thetunguyen != "") { s_tunguyen = s_thetunguyen.Replace(",", "','"); } string vitri = d.thetunguyen_vitri_ora(m.nhom_duoc); if (vitri != "") { v1 = int.Parse(vitri.Substring(0, 1)); v2 = int.Parse(vitri.Substring(2, 1)); } dtnhom = d.get_data("select distinct stt from " + user + ".v_nhombhyt order by stt").Tables[0]; madoituong.DataSource = m.get_data("select a.*,to_char(madoituong) as madoituong1 from " + user + ".doituong a where sothe<>0 order by madoituong").Tables[0]; madoituong.DisplayMember = "DOITUONG"; madoituong.ValueMember = "MADOITUONG"; sql = "select * from " + user + ".btdkp_bv"; if (s_makp != "") { string s = s_makp.Replace(",", "','"); sql += " where makp in ('" + s.Substring(0, s.Length - 3) + "')"; } sql += " order by loai,makp"; dtkp = m.get_data(sql).Tables[0]; makp.DataSource = dtkp; makp.DisplayMember = "TENKP"; makp.ValueMember = "MAKP"; taotable(); loaidt.SelectedIndex = 0; }
private void load_dmkho() { try { dtdmkho = ttb.get_data("select * from " + user + ".ttb_dmkho where nhom=" + i_nhomkho.ToString() + " order by stt").Tables[0]; makho.DataSource = dtdmkho; makho.DisplayMember = "TEN"; makho.ValueMember = "ID"; dtmakp = d.get_data("select * from " + d.user + ".d_duockp where nhom like '%" + i_nhomkho.ToString() + ",%' order by stt").Tables[0]; makp.DataSource = dtmakp; dtdmnhom = ttb.get_data("select * from " + user + ".ttb_dmnhom where nhom=" + i_nhomkho.ToString() + " order by stt").Tables[0]; manhom.DataSource = dtdmnhom; dtnt = ttb.get_data("select * from " + user + ".ttb_dmloaint where nhom=" + i_nhomkho.ToString() + " order by stt").Tables[0]; loaint.DataSource = dtnt; dtkhac = ttb.get_data("select * from " + user + ".ttb_dmkhac where nhom in(0," + i_nhomkho.ToString() + ") order by stt").Tables[0]; loaikhac.DataSource = dtkhac; manhom.DisplayMember = "TEN"; manhom.ValueMember = "ID"; loaint.DisplayMember = "TEN"; loaint.ValueMember = "ID"; loaikhac.DisplayMember = "TEN"; loaikhac.ValueMember = "ID"; makp.DisplayMember = "TEN"; makp.ValueMember = "ID"; makho.DisplayMember = "TEN"; makho.ValueMember = "ID"; } catch {} }
private void frmKiemtrakhoa_Load(object sender, System.EventArgs e) { if (Screen.PrimaryScreen.WorkingArea.Width > 800) { this.WindowState = System.Windows.Forms.FormWindowState.Normal; } user = ttb.user; stime = "'" + ttb.f_ngay + "'"; sql = "select * from " + user + ".ttb_dmnhomkho where id=" + i_nhom + " order by stt"; nhom.DisplayMember = "TEN"; nhom.ValueMember = "ID"; nhom.DataSource = ttb.get_data(sql).Tables[0]; phieu.DisplayMember = "TEN"; phieu.ValueMember = "ID"; loai.DisplayMember = "TEN"; loai.ValueMember = "ID"; loai.DataSource = ttb.get_data("select * from " + user + ".ttb_dmphieu order by stt").Tables[0]; load_phieu(); sql = "select * from " + d.user + ".d_duockp where nhom like '%" + i_nhom.ToString() + ",%'"; sql += " order by stt"; makp.DisplayMember = "TEN"; makp.ValueMember = "ID"; makp.DataSource = d.get_data(sql).Tables[0]; }
private void loadgrid(string maloai) { try { sql = " Select * from " + m.user + ".bhyt_maubaocao "; if (maloai.Trim() != "") { sql += " where maloai='" + maloai + "'"; } dsxml = m.get_data(sql); dtct = dsxml.Tables[0].Copy(); dataGrid1.DataSource = dtct; } catch {} }
private void frmTscdlc_Load(object sender, System.EventArgs e) { user = ttb.user; pic.Tag = "0000.bmp"; fstr = new System.IO.FileStream(pic.Tag.ToString(), System.IO.FileMode.Open, System.IO.FileAccess.Read); map = new Bitmap(Image.FromStream(fstr)); pic.Image = (Bitmap)map; image = new byte[fstr.Length]; fstr.Read(image, 0, System.Convert.ToInt32(fstr.Length)); fstr.Close(); pic.Tag = image; sql = "select * from " + d.user + ".d_duockp where nhom like '%" + i_nhom.ToString().Trim() + ",%'"; if (i_stt == 0) { sql += " and id<>" + i_makp; } sql += " order by stt"; makp.DisplayMember = "TEN"; makp.ValueMember = "ID"; makp.DataSource = d.get_data(sql).Tables[0]; if (i_stt != 0) { foreach (DataRow r in ttb.get_data("select makp,to_char(ngay,'dd/mm/yyyy') as ngay,diengiai,image from " + user + ".ttb_tscdlc where id=" + l_id + " and stt=" + i_stt).Tables[0].Rows) { makp.SelectedValue = r["makp"].ToString(); ngay.Value = new DateTime(int.Parse(r["ngay"].ToString().Substring(6)), int.Parse(r["ngay"].ToString().Substring(3, 2)), int.Parse(r["ngay"].ToString().Substring(0, 2)), 0, 0, 0); diengiai.Text = r["diengiai"].ToString(); } } vanban.DisplayMember = "TT"; vanban.ValueMember = "TT"; load_vanban(); }
private void frmChonkhoa_Load(object sender, System.EventArgs e) { user = ttb.user; makho.DisplayMember = "TEN"; makho.ValueMember = "ID"; string sql = "select * from " + user + ".ttb_dmkho where nhom=" + i_nhom; if (s_makho != "") { sql += " and id in (" + s_makho.Substring(0, s_makho.Length - 1) + ")"; } sql += " order by stt"; makho.DataSource = ttb.get_data(sql).Tables[0]; if (makho.Items.Count > 0) { makho.SelectedIndex = 0; } makp.DisplayMember = "TEN"; makp.ValueMember = "ID"; sql = "select * from " + d.user + ".d_duockp where nhom like '%" + i_nhom.ToString() + ",%'"; if (s_makp != "") { sql += " and id in (" + s_makp.Substring(0, s_makp.Length - 1) + ")"; } sql += " order by stt"; dtkhoa = d.get_data(sql).Tables[0]; ttb.convertFont(dtkhoa, "ten"); makp.DataSource = dtkhoa; if (makp.Items.Count > 0) { makp.SelectedIndex = 0; } }
private void butMoi_Click(object sender, System.EventArgs e) { try { stt.Value = decimal.Parse(ttb.get_data("select max(stt) from " + user + ".ttb_dmnhomkho").Tables[0].Rows[0][0].ToString()) + 1; } catch { stt.Value = 1; } try { stt_medi = int.Parse(d.get_data("select max(stt) from " + d.user + ".d_dmnhomkho").Tables[0].Rows[0][0].ToString()) + 1; } catch { stt_medi = 1; } l_id = 0; ten.Text = ""; nhomcc.SelectedIndex = -1; ena_object(true); stt.Focus(); }
private void frmHaophi_Load(object sender, System.EventArgs e) { //if (Screen.PrimaryScreen.WorkingArea.Width > 800) this.WindowState = System.Windows.Forms.FormWindowState.Normal; user = ttb.user; xxx = user;// +s_mmyy; // f_capnhat_db(); // bKhoaso = ttb.bKhoaso(i_nhom, s_mmyy); link = ttb.dbLink; string sField = ttb.f_get_select_field("ttb_dmbd", "image"); sql = "select " + sField.Trim().Trim(',') + " from " + user + ".ttb_dmbd where nhom=" + i_nhom + " order by id"; dtdmbd = ttb.get_data(sql).Tables[0]; dtphieu = ttb.get_data("select * from " + user + ".ttb_loaiphieu where nhom=" + i_nhom + " and loai=" + i_loai + " order by stt").Tables[0]; phieu.DisplayMember = "TEN"; phieu.ValueMember = "ID"; phieu.DataSource = dtphieu; sql = "select * from " + d.user + ".d_duockp where nhom like '%" + i_nhom.ToString() + ",%'"; if (s_makp != "") { sql += " and id in (" + s_makp.Substring(0, s_makp.Length - 1) + ")"; } sql += " order by stt"; dtkp = d.get_data(sql).Tables[0]; makp.DisplayMember = "TEN"; makp.ValueMember = "ID"; makp.DataSource = dtkp; butChoduyet_Click(null, null); sql = "select a.id,a.mabn,b.ten as hoten,to_char(a.ngay,'dd/mm/yyyy') as ngay,a.phieu,a.makp,a.idduyet,a.makhoa from " + xxx + ".ttb_xuatsdll a," + d.user + ".d_duockp" + link + " b "; sql += "where a.makp=b.id and a.loai=" + i_loai + " and a.nhom=" + i_nhom; if (ttb.bUserid) { sql += " and a.userid=" + i_userid; } if (ttb.bLoclinh) { sql += " and to_char(a.ngay,'dd/mm/yyyy')='" + s_ngay + "'"; } if (s_makp != "") { sql += " and a.makp in (" + s_makp.Substring(0, s_makp.Length - 1) + ")"; } sql += " order by a.id"; dtll = ttb.get_data(sql).Tables[0]; mabn.DisplayMember = "MABN"; mabn.ValueMember = "ID"; mabn.DataSource = dtll; if (dtll.Rows.Count > 0) { l_id = decimal.Parse(mabn.SelectedValue.ToString()); } load_head(); AddGridTableStyle(); }
private void load_grid(string s_ngay, decimal l_id, decimal l_sophieu, int idkho, int idkhoa) { sql = "select b.ma,b.id as mabd1 ,trim(b.ten)||' '||b.hamluong as ten,b.hamluong,b.dang,g.ten as nhasx,f.sophieu,c.stt as sttnhom,c.ten as tennhom,d.ten as tenhang,"; sql += "b.sltoithieu, b.tenhc,a.*,a.soluong as slduyet,e.ten as tenkho "; sql += " from " + user + ".d_dutrucsttct a," + user + ".d_dutrucsttll f," + user + ".d_dmbd b," + user + ".d_dmnhom c," + user + ".d_dmhang d," + user + ".d_dmkho e," + user + ".d_dmnx g "; sql += " where a.mabd=b.id and b.manhom=c.id and b.mahang=d.id and e.id=f.makho and b.madv=g.id and a.id=f.id and f.makho=" + idkho; sql += " and to_char(f.ngay,'dd/mm/yyyy')='" + s_ngay + "'"; sql += " and a.id=" + l_id + " and sophieu=" + l_sophieu; sql += " and a.soluong >0 "; sql += " and f.done =2 and makp='" + i_makhoa + "'"; sql += " order by c.stt,b.ma"; dtct = d.get_data(sql).Tables[0]; dataGrid1.DataSource = dtct; CurrencyManager cm = (CurrencyManager)BindingContext[dataGrid1.DataSource]; DataView dv = (DataView)cm.List; dv.AllowNew = false; dv.AllowDelete = false; }
private void load_gird() { DataTable dt = new DataTable(); string user = d.user; string sql = "select to_number('0') as chon,d.hoten as tenuser,b.id as makp,b.ten as tenkp,c.id as sophieu,c.ten as phieu,a.computer,to_char(a.ngay,'dd/mm/yyyy') as ngay from " + user + ".d_danglaysolieu a "; sql += " left join " + user + ".d_duockp b on a.makp=b.id left join " + user + ".d_loaiphieu c on a.phieu=c.id left join " + user + ".d_dlogin d on a.userid=d.id"; sql += " where a.computer<>'" + System.Environment.MachineName + "'"; dt = d.get_data(sql).Tables[0]; dataGridView1.DataSource = dt; }
private void frmDanhsachdutru_Load(object sender, EventArgs e) { d = new LibDuoc.AccessData(); cboKhoa.DisplayMember = "TEN"; cboKhoa.ValueMember = "ID"; string sql = "select id,ten from " + d.user + ".d_duockp"; if (s_makp != "") { sql += " where makp in ('" + s_makp.Replace(",", "','") + "')"; } sql += " order by ten"; cboKhoa.DataSource = d.get_data(sql).Tables[0]; txtThang.Value = (decimal)DateTime.Now.Month; txtNam.Value = (decimal)DateTime.Now.Year; dsdutru = d.get_data("select 0 as id,'' as ngay,'' as loaiphieu,'' as tenphieu").Clone(); dslinh = d.get_data("select '' as ngay,'' as tenphieu").Clone(); AddGridTableStyle(); AddGridTableStyle2(); this.WindowState = FormWindowState.Maximized; }
private void frmTtkcbngtr_Load(object sender, System.EventArgs e) { user = m.user; i_nhom = m.nhom_duoc; s_thetrongtinh = d.thetrongtinh(i_nhom); s_thetunguyen = d.thetunguyen(i_nhom); if (s_thetunguyen != "") { s_tunguyen = s_thetunguyen.Replace(",", "','"); } string vitri = d.thetunguyen_vitri_ora(i_nhom); if (vitri != "") { v1 = int.Parse(vitri.Substring(0, 1)); v2 = int.Parse(vitri.Substring(2, 1)); } dtnhom = d.get_data("select distinct stt from " + user + ".v_nhombhyt order by stt").Tables[0]; madoituong.DataSource = d.get_data("select a.*,to_char(madoituong) as madoituong1 from " + user + ".doituong a where sothe<>0 order by madoituong").Tables[0]; madoituong.DisplayMember = "DOITUONG"; madoituong.ValueMember = "MADOITUONG"; taotable(); loaidt.SelectedIndex = 0; }
private void butXem_Click(object sender, EventArgs e) { d = new LibDuoc.AccessData(); string mmyy = txtThang.Value.ToString().PadLeft(2, '0') + txtNam.Value.ToString().Substring(2); if (d.bMmyy(mmyy)) { string user = d.user; string xxx = user + mmyy; string exp = " where a.makp=" + cboKhoa.SelectedValue.ToString() + " and to_date(to_char(a.ngay,'dd/mm/yyyy'),'dd/mm/yyyy') between to_date('" + txtTungay.Text + "','dd/mm/yyyy') and to_date('" + txtDenngay.Text + "','dd/mm/yyyy') "; string sql = "select distinct a.id,to_char(a.ngay,'dd/mm/yyyy') as ngay,b.ten as loaiphieu,c.ten as tenphieu,"; sql += " case when a.done=0 then 'x' else '' end as chuachuyen,"; sql += " case when a.done=1 then 'x' else '' end as chuyen,"; sql += " case when a.done=2 then 'x' else '' end as duyet,a.loai,d.hoten "; sql += " from " + xxx + ".d_duyet a inner join " + xxx + ".d_dutrull a1 on a.id=a1.idduyet inner join " + user + ".d_dmphieu b on a.loai=b.id "; sql += " inner join " + user + ".d_loaiphieu c on a.phieu=c.id "; sql += " left join " + user + ".dlogin d on a.userid=d.id "; sql += exp; sql += " union all "; sql += "select distinct a.id,to_char(a.ngay,'dd/mm/yyyy') as ngay,b.ten as loaiphieu,c.ten as tenphieu,"; sql += " case when a.done=0 then 'x' else '' end as chuachuyen,"; sql += " case when a.done=1 then 'x' else '' end as chuyen,"; sql += " case when a.done=2 then 'x' else '' end as duyet,a.loai,d.hoten "; sql += " from " + xxx + ".d_duyet a inner join " + xxx + ".d_xtutrucll a1 on a.id=a1.idduyet inner join " + user + ".d_dmphieu b on a.loai=b.id "; sql += " inner join " + user + ".d_loaiphieu c on a.phieu=c.id "; sql += " left join " + user + ".dlogin d on a.userid=d.id "; sql += exp; sql += " union all "; sql += "select distinct a.id,to_char(a.ngay,'dd/mm/yyyy') as ngay,b.ten as loaiphieu,c.ten as tenphieu,"; sql += " case when a.done=0 then 'x' else '' end as chuachuyen,"; sql += " case when a.done=1 then 'x' else '' end as chuyen,"; sql += " case when a.done=2 then 'x' else '' end as duyet,a.loai,d.hoten "; sql += " from " + xxx + ".d_duyet a inner join " + xxx + ".d_hoantrall a1 on a.id=a1.idduyet inner join " + user + ".d_dmphieu b on a.loai=b.id "; sql += " inner join " + user + ".d_loaiphieu c on a.phieu=c.id "; sql += " left join " + user + ".dlogin d on a.userid=d.id "; sql += exp; sql += " union all "; sql += "select distinct a.id,to_char(a.ngay,'dd/mm/yyyy') as ngay,b.ten as loaiphieu,c.ten as tenphieu,"; sql += " case when a.done=0 then 'x' else '' end as chuachuyen,"; sql += " case when a.done=1 then 'x' else '' end as chuyen,"; sql += " case when a.done=2 then 'x' else '' end as duyet,a.loai,d.hoten "; sql += " from " + xxx + ".d_duyet a inner join " + xxx + ".d_haophill a1 on a.id=a1.idduyet inner join " + user + ".d_dmphieu b on a.loai=b.id "; sql += " inner join " + user + ".d_loaiphieu c on a.phieu=c.id "; sql += " left join " + user + ".dlogin d on a.userid=d.id "; sql += exp; dsdutru = d.get_data(sql); dataGrid1.DataSource = dsdutru.Tables[0]; } }
private void frmChonphieucstt_Load(object sender, EventArgs e) { user = d.user; cmbsophieu.DisplayMember = "sophieu"; cmbsophieu.ValueMember = "id"; cmbKho.DisplayMember = "ten"; cmbKho.ValueMember = "id"; sql = "select id,ten from " + user + ".d_dmkho "; if (s_makho != "") { sql += " where id in (" + s_makho.Trim(',') + ")"; } cmbKho.DataSource = d.get_data(sql).Tables[0]; cmbKhoa.DisplayMember = "ten"; cmbKhoa.ValueMember = "id"; sql = "select id,ten from " + user + ".d_duockp "; if (s_makp != "") { sql += " where id in (" + s_makp + ")"; } cmbKhoa.DataSource = d.get_data(sql).Tables[0]; ddmmyyyy_Validated(null, null); }
private void load_treeview() { try { treeView1.Nodes.Clear(); DateTime ngay_dangnhap = new DateTime(int.Parse(s_ngaydangnhap.Substring(6, 4)), int.Parse(s_ngaydangnhap.Substring(3, 2)), int.Parse(s_ngaydangnhap.Substring(0, 2))); int i_ngaykiemke = d.iNgaykiemke; sql = " select a.sophieu,a.id,to_char(a.ngay,'dd/mm/yyyy') as ngay,b.ten from " + user + ".d_dutrukholl a," + user + ".d_dmkho b " + " where a.makho=b.id and to_date(to_char(a.ngay,'dd/mm/yyyy'),'dd/mm/yyyy') between to_date('" + ngay_dangnhap.AddDays(-i_ngaykiemke).ToString("dd/MM/yyyy") + "','dd/mm/yyyy') and to_date('" + ngay_dangnhap.AddDays(i_ngaykiemke).ToString("dd/MM/yyyy") + "','dd/mm/yyyy') and done=2"; foreach (DataRow row in d.get_data(sql).Tables[0].Rows) { TreeNode node = new TreeNode(row["ten"].ToString() + " ( " + row["ngay"].ToString() + " )"); node.Tag = row["id"].ToString(); node.Nodes.Add(""); treeView1.Nodes.Add(node); } } catch { } }
private void frmAbout_KeyDown(object sender, KeyEventArgs e) { string user = d.user, xxx = user + mmyy; if (e.KeyCode == Keys.F7) { string sql = "select a.* from " + xxx + ".d_tutrucct a," + user + ".d_dmkho b," + xxx + ".d_theodoi t where a.makho=b.id and a.tondau<0 and a.stt=t.id and b.nhom=" + i_nhom + " order by a.makp,a.makho,t.manguon,a.mabd,a.stt"; decimal sl = 0; foreach (DataRow r in d.get_data(sql).Tables[0].Rows) { sl = decimal.Parse(r["tondau"].ToString()); sql = "select a.* from " + xxx + ".d_tutrucct a," + xxx + ".d_theodoi t where a.stt=t.id and a.mabd=" + decimal.Parse(r["mabd"].ToString()) + " and a.makp=" + decimal.Parse(r["makp"].ToString()); sql += " and a.makho=" + decimal.Parse(r["makho"].ToString()) + " and t.manguon=" + decimal.Parse(r["manguon"].ToString()); sql += " and a.tondau>=" + Math.Abs(sl) + " and a.tondau+a.slnhap-a.slxuat>=" + Math.Abs(sl); sql += " order by a.makp,a.makho,t.manguon,a.mabd,a.stt"; foreach (DataRow r1 in d.get_data(sql).Tables[0].Rows) { sql = "update " + xxx + ".d_tutrucct set tondau=tondau+" + sl + " where mabd=" + decimal.Parse(r["mabd"].ToString()); sql += " and makp=" + decimal.Parse(r["makp"].ToString()) + " and stt=" + decimal.Parse(r1["stt"].ToString()); d.execute_data(sql); sql = "update " + xxx + ".d_tutrucct set tondau=0 where mabd=" + decimal.Parse(r["mabd"].ToString()); sql += " and makp=" + decimal.Parse(r["makp"].ToString()) + " and stt=" + decimal.Parse(r["stt"].ToString()); d.execute_data(sql); break; } } MessageBox.Show(lan.Change_language_MessageText("Đã kiểm tra lại tồn đầu tủ trực !"), d.Msg); } else if (e.KeyCode == Keys.F8) { kiemtra_nhap(); } else if (e.KeyCode == Keys.F12) { if (!d.bMahoamatkhau) { foreach (DataRow r in m.get_data("select * from " + user + ".d_dlogin").Tables[0].Rows) { try { d.execute_data("update " + user + ".d_dlogin set password_='" + m.encode(r["password_"].ToString()) + "' where id=" + decimal.Parse(r["id"].ToString())); } catch { } } d.upd_thongso(i_nhom, -13, "", "1"); MessageBox.Show(lan.Change_language_MessageText("Đã mã hóa mật khẩu !"), LibMedi.AccessData.Msg); } else { MessageBox.Show(lan.Change_language_MessageText("Mật khẩu đã mã hóa !"), LibMedi.AccessData.Msg); } } else if (e.KeyCode == Keys.F11) { if (d.bMahoamatkhau) { foreach (DataRow r in m.get_data("select * from " + user + ".d_dlogin").Tables[0].Rows) { try { d.execute_data("update " + user + ".d_dlogin set password_='" + m.decode(r["password_"].ToString()) + "' where id=" + decimal.Parse(r["id"].ToString())); } catch { } } d.execute_data("delete from " + user + ".d_thongso where id=-13"); MessageBox.Show(lan.Change_language_MessageText("Đã giải hóa mật khẩu !"), LibMedi.AccessData.Msg); } else { MessageBox.Show(lan.Change_language_MessageText("Mật khẩu chưa mã hóa !"), LibMedi.AccessData.Msg); } } else if (e.KeyCode == Keys.L && e.Control && e.Alt && e.Shift) { frmRight_BV f = new frmRight_BV(d, tree, i_nhom); f.Show(); } }
private void frmInphieu_Load(object sender, System.EventArgs e) { link = ttb.dbLink; user = ttb.user; xxx = user;// +s_mmyy; f_ngay = ttb.f_ngay; bInngang = ttb.bPhieulinh_ngang(i_nhom); bDoituong_phieulinh = ttb.bDoituong_Phieulinh(i_nhom); xem.Checked = ttb.bPreview; banin.Enabled = !xem.Checked; s_doc = ""; if (ttb.bHoten_docGN(i_nhom) != 0) { s_doc += ttb.bHoten_docGN(i_nhom).ToString() + ","; } if (ttb.bHoten_docHTT(i_nhom) != 0) { s_doc += ttb.bHoten_docHTT(i_nhom).ToString() + ","; } if (ttb.bHoten_docAB(i_nhom) != 0) { s_doc += ttb.bHoten_docAB(i_nhom).ToString() + ","; } s_doc = (s_doc != "")?s_doc.Substring(0, s_doc.Length - 1):""; bNhomin_mabd = ttb.bNhomin_mabd(i_nhom); xuatcstt.Enabled = i_loai == 2 || bBuhaophi; i_songay = ttb.Ngay_in_phieu(i_nhom); ds.ReadXml("..\\..\\..\\xml\\ttb_inphieu.xml"); dsxml.ReadXml("..\\..\\..\\xml\\ttb_inphieu.xml"); sql = "select a.id,a.ma,trim(a.ten)||' '||a.hamluong as ten,a.dang,a.tenhc,c.ten as tennhom,c.stt as manhom,c.stt,d.ten as tenhang from " + user + ".ttb_dmbd a," + user + ".ttb_dmnhom b," + user + ".ttb_nhomin c," + user + ".ttb_dmhang d"; sql += " where a.manhom=b.id "; if (bNhomin_mabd) { sql += " and a.nhomin=c.id "; } else { sql += " and b.nhomin=c.id "; } sql += " and a.mahang=d.id and a.nhom=" + i_nhom; dt = ttb.get_data(sql).Tables[0]; tu.Value = new DateTime(int.Parse(s_ngay.Substring(6, 4)), int.Parse(s_ngay.Substring(3, 2)), int.Parse(s_ngay.Substring(0, 2)), 0, 0, 0); den.Value = tu.Value; phieu.DisplayMember = "TEN"; phieu.ValueMember = "ID"; phieu.DataSource = dtphieu; if (i_phieu != -1) { phieu.SelectedValue = i_phieu.ToString(); } else { phieu.SelectedIndex = 0; } makp.DisplayMember = "TEN"; makp.ValueMember = "ID"; makp.DataSource = dtkp; if (i_makp != -1) { makp.SelectedValue = i_makp.ToString(); } else { makp.SelectedIndex = 0; } if (ttb.bQuanlynguon(i_nhom)) { dtnguon = ttb.get_data("select * from " + user + ".ttb_dmnguon where nhom=" + i_nhom + " order by id").Tables[0]; } else { dtnguon = ttb.get_data("select * from " + user + ".ttb_dmnguon where id=0 or nhom=" + i_nhom + " order by id").Tables[0]; } manguon.DataSource = dtnguon; manguon.DisplayMember = "TEN"; manguon.ValueMember = "ID"; dtdt = d.get_data("select * from " + d.user + ".d_doituong order by madoituong").Tables[0]; madoituong.DataSource = dtdt; madoituong.DisplayMember = "DOITUONG"; madoituong.ValueMember = "MADOITUONG"; if (bDoituong_phieulinh) { foreach (DataRow r in dtdt.Rows) { dc = new DataColumn(); dc.ColumnName = "c_" + r["madoituong"].ToString().Trim(); dc.DataType = Type.GetType("System.Decimal"); ds.Tables[0].Columns.Add(dc); dc = new DataColumn(); dc.ColumnName = "c_" + r["madoituong"].ToString().Trim(); dc.DataType = Type.GetType("System.Decimal"); dsxml.Tables[0].Columns.Add(dc); } } load_makho(); kho.DisplayMember = "TEN"; kho.ValueMember = "ID"; if (bBuhaophi) { file1 = "ttb_haophill"; file2 = "ttb_haophict"; } else { switch (i_loai) { case 1: file1 = "ttb_dutrull"; file2 = "ttb_dutruct"; break; case 2: file1 = "ttb_xtutrucll"; file2 = "ttb_xtutrucct"; break; case 3: file1 = "ttb_hoantrall"; file2 = "ttb_hoantract"; break; default: file1 = "ttb_haophill"; file2 = "ttb_haophict"; break; } } }
private void butTao_Click(object sender, EventArgs e) { m.execute_data("create table " + user + ".anhxa(ma_medisoft numeric(7) ,ma_benhvien numeric(7),loai varchar(50),constraint pk_anhxa primary key(ma_medisoft,ma_benhvien,loai))"); m.execute_data("alter table " + user + ".anhxa modify (ma_benhvien numeric(7),ma_medisoft numeric(7))"); dtdm = m.get_data("select * from " + user + ".anhxa where loai='" + cboSolieu.Tag.ToString() + "'").Tables[0]; }