private void rptXuat_khoa_Load(object sender, System.EventArgs e) { user = d.user; stime = "'" + d.f_ngay + "'"; i_dongia = d.d_dongia_le(i_nhom); format_soluong = d.format_soluong(i_nhom); sql = "select a.*, b.stt as sttnhom, b.ten as tennhom from " + user + ".d_dmbd a, " + user + ".d_dmnhom b"; sql += " where a.manhom=b.id and a.nhom=" + i_nhom + " order by a.id"; dt = d.get_data(sql).Tables[0]; manguon.DisplayMember = "TEN"; manguon.ValueMember = "ID"; if (d.bQuanlynguon(i_nhom)) { manguon.DataSource = d.get_data("select * from " + user + ".d_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0]; } else { manguon.DataSource = d.get_data("select * from " + user + ".d_dmnguon where id=0 or nhom=" + i_nhom + " order by stt").Tables[0]; } sql = "select * from " + user + ".d_dmkho where hide=0 and nhom=" + i_nhom; if (s_kho != "") { sql += " and id in (" + s_kho.Substring(0, s_kho.Length - 1) + ")"; } sql += " order by stt"; dtdmkho = d.get_data(sql).Tables[0]; makho.DataSource = dtdmkho; makho.DisplayMember = "TEN"; makho.ValueMember = "ID"; }
private void frmXemtonth_Load(object sender, System.EventArgs e) { if (bbadt) { this.Location = new System.Drawing.Point(188 - 38, 120);//151 this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None; this.Size = new Size(829 + 40, 610); } if (Screen.PrimaryScreen.WorkingArea.Width > 800) { this.WindowState = System.Windows.Forms.FormWindowState.Normal; } user = d.user; /* * s_manguon=d.get_manguon(i_loai).Trim(); * s_makho=d.get_dmkho(i_loai).Trim(); * if (m.bDanhmuc_nhathuoc && i_nhom==m.nhom_nhathuoc && s_makho!="" && m.kho_nhathuoc!="00:00") //nha thuoc * { * int hh1=int.Parse(s_ngay.Substring(11,2)),mm1=int.Parse(s_ngay.Substring(14,2)),hh2=int.Parse(m.gio_nhathuoc.Substring(0,2)),mm2=int.Parse(m.gio_nhathuoc.Substring(3,2)); * string kho=m.kho_nhathuoc; * if (kho!="") kho+=","; * if (hh1>hh2 || (hh1==hh2 && mm1>mm2)) s_makho=kho; * else if (kho!="") s_makho=s_makho.Remove(s_makho.IndexOf(kho),kho.Length); * } * */ format_soluong = d.format_soluong(i_nhom); load_grid(); AddGridTableStyle(); }
private void frmTreoduyet_Load(object sender, System.EventArgs e) { user = d.user; format_soluong = d.format_soluong(i_nhom); if (bTutrucchung) { label3.Text = "Tủ trực :"; } load_ngay_duyet(); makp.DisplayMember = "TEN"; makp.ValueMember = "ID"; makp.DataSource = dtkp; makp.SelectedValue = i_makp.ToString(); if (makp.Items.Count > 0) { kp.Text = dtkp.Rows[makp.SelectedIndex]["ma"].ToString(); } string sql = "select * from " + user + ".d_loaiphieu "; if (bThua) { sql += " where id=0"; } else { sql += " where nhom=" + i_nhom + " and loai=" + i_loai; sql += " and id<>0 order by stt"; } dtph = d.get_data(sql).Tables[0]; phieudutru.DisplayMember = "TEN"; phieudutru.ValueMember = "ID"; phieudutru.DataSource = dtph; load_phieu(); }
private void frmXemtutructh_Load(object sender, System.EventArgs e) { if (Screen.PrimaryScreen.WorkingArea.Width > 800) { this.WindowState = System.Windows.Forms.FormWindowState.Normal; } user = d.user; xxx = user + s_mmyy; format_soluong = d.format_soluong(i_nhom); load_grid(); AddGridTableStyle(); }
private void frmPttt_thuoc_Load(object sender, System.EventArgs e) { user = d.user; dtdt = m.get_data("select * from " + user + ".d_doituong order by madoituong").Tables[0]; if (d.bQuanlynguon(i_nhom)) { dtnguon = d.get_data("select * from " + user + ".d_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0]; } else { dtnguon = d.get_data("select * from " + user + ".d_dmnguon where nhom=0 or nhom=" + i_nhom + " order by stt").Tables[0]; } dsdm.ReadXml("..//..//..//xml//d_tutructh.xml"); dsdm.Tables[0].Columns.Add("Chon", typeof(bool)); if (mapt != "") { foreach (DataRow r in m.get_data("select mavp from " + user + ".dmpttt where mapt='" + mapt + "'").Tables[0].Rows) { l_mavp = decimal.Parse(r["mavp"].ToString()); } } load_grid(); AddGridTableStyle(); f_soluong = d.format_soluong(i_nhom); this.disabledBackBrush = new SolidBrush(Color.FromArgb(255, 255, 192)); this.disabledTextBrush = new SolidBrush(Color.FromArgb(255, 0, 0)); this.alertBackBrush = new SolidBrush(SystemColors.HotTrack); this.alertFont = new Font(this.dataGrid1.Font.Name, this.dataGrid1.Font.Size, FontStyle.Bold); this.alertTextBrush = new SolidBrush(Color.White); this.currentRowFont = new Font(this.dataGrid1.Font.Name, this.dataGrid1.Font.Size, FontStyle.Regular); this.currentRowBackBrush = new SolidBrush(Color.FromArgb(0, 255, 255)); ds.ReadXml("..//..//..//xml//m_pttt_thuoc.xml"); AddGridTableStyle1(); load_chitiet(); }
private void frmKhoacstt_Load(object sender, System.EventArgs e) { s_makho = ""; user = d.user; stime = "'" + d.f_ngay + "'"; foreach (DataRow r in d.get_data("select kho from " + user + ".d_dmphieu where id=2").Tables[0].Rows) { s_makho = r["kho"].ToString(); } makho.DisplayMember = "TEN"; makho.ValueMember = "ID"; string sql = "select * from " + user + ".d_dmkho where hide=0 and loai=" + i_loai; if (i_loai == 1) { sql += " and nhom=" + i_nhom; if (s_makho != "") { sql += " and id in (" + s_makho.Substring(0, s_makho.Length - 1) + ")"; } } else { sql += " and nhom<>" + i_nhom; if (s_nhomkho != "") { sql += " and nhom in (" + s_nhomkho.Substring(0, s_nhomkho.Length - 1) + ")"; } } sql += " order by stt"; dtdmkho = d.get_data(sql).Tables[0]; makho.DataSource = dtdmkho; if (makho.Items.Count > 0) { makho.SelectedIndex = 0; } makp.DisplayMember = "TEN"; makp.ValueMember = "ID"; sql = "select * from " + user + ".d_duockp 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; if (makp.Items.Count > 0) { makp.SelectedIndex = 0; } ds.ReadXml("..//..//..//xml//d_khoacstt.xml"); dsxml.ReadXml("..//..//..//xml//d_khoacstt.xml"); format_soluong = d.format_soluong(i_nhom); sql = "select a.*, b.stt as sttnhom, b.ten as tennhom,c.ten as tenhang,d.ten as nuocsx from " + user + ".d_dmbd a, " + user + ".d_dmnhom b," + user + ".d_dmhang c," + user + ".d_dmnuoc d"; sql += " where a.manhom=b.id and a.mahang=c.id and a.manuoc=d.id and a.nhom=" + i_nhom + " order by a.id"; dt = d.get_data(sql).Tables[0]; manguon.DisplayMember = "TEN"; manguon.ValueMember = "ID"; if (d.bQuanlynguon(i_nhom)) { manguon.DataSource = d.get_data("select * from " + user + ".d_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0]; } else { manguon.DataSource = d.get_data("select * from " + user + ".d_dmnguon where nhom=0 or nhom=" + i_nhom + " order by stt").Tables[0]; } }