private void rptKiemkekho_Load(object sender, System.EventArgs e) { user = ttb.user; sql = "select * from " + user + ".ttb_dmkho where nhom=" + i_nhom; if (s_kho != "") { sql += " and id in (" + s_kho.Substring(0, s_kho.Length - 1) + ")"; } sql += " order by stt"; dtkho = ttb.get_data(sql).Tables[0]; kho.DataSource = dtkho; kho.DisplayMember = "TEN"; kho.ValueMember = "ID"; //Nguon nguon.DisplayMember = "TEN"; nguon.ValueMember = "ID"; sql = "select * from " + user + ".ttb_dmnguon where nhom=" + i_nhom; sql += " order by stt"; nguon.DataSource = ttb.get_data(sql).Tables[0]; nguon.Enabled = ttb.bQuanlynguon(i_nhom); // sql = "select a.*,b.ten as tenhang,c.ten as tennuoc,d.stt as sttnn,d.ten as noingoai from " + user + ".ttb_dmbd a," + user + ".ttb_dmhang b," + user + ".ttb_dmnuoc c," + user + ".ttb_nhomhang d where a.mahang=b.id and a.manuoc=c.id and b.loai=d.id and a.nhom=" + i_nhom + " order by a.id"; dt = ttb.get_data(sql).Tables[0]; ds.ReadXml("..\\..\\..\\xml\\ttb_kiemkekho.xml"); dsxml.ReadXml("..\\..\\..\\xml\\ttb_kiemkekho.xml"); }
private void rptBcngay_Load(object sender, System.EventArgs e) { manguon.DisplayMember = "TEN"; manguon.ValueMember = "ID"; if (ttb.bQuanlynguon(i_nhom)) { manguon.DataSource = ttb.get_data("select * from ttb_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0]; } else { manguon.DataSource = ttb.get_data("select * from ttb_dmnguon where id=0 or nhom=" + i_nhom + " order by stt").Tables[0]; } nhomcc.DisplayMember = "TEN"; nhomcc.ValueMember = "ID"; if (ttb.bQuanlynhomcc(i_nhom)) { nhomcc.DataSource = ttb.get_data("select * from ttb_nhomcc where nhom=" + i_nhom + " order by stt").Tables[0]; } else { nhomcc.DataSource = ttb.get_data("select * from ttb_nhomcc where id=0 or nhom=" + i_nhom + " order by stt").Tables[0]; } dt = ttb.get_data("select * from ttb_dmbd where nhom=" + i_nhom + " order by id").Tables[0]; sql = "select * from 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"; dtdmkho = ttb.get_data(sql).Tables[0]; kho.DisplayMember = "TEN"; kho.ValueMember = "ID"; kho.DataSource = dtdmkho; dsngay.ReadXml("..\\..\\..\\xml\\ttb_tsngay.xml"); }
private void frmChonkhong_Load(object sender, System.EventArgs e) { user = ttb.user; manguon.DisplayMember = "TEN"; manguon.ValueMember = "ID"; if (ttb.bQuanlynguon(i_nhom)) { manguon.DataSource = ttb.get_data("select * from " + user + ".ttb_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0]; } else { manguon.DataSource = ttb.get_data("select * from " + user + ".ttb_dmnguon where id=0 or nhom=" + i_nhom + " order by stt").Tables[0]; } manguon.SelectedIndex = -1; 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]; makho.SelectedIndex = 0; }
private void rptThekho_Load(object sender, System.EventArgs e) { user = ttb.user; theo.SelectedIndex = 0; manguon.DisplayMember = "TEN"; manguon.ValueMember = "ID"; if (ttb.bQuanlynguon(i_nhom)) { manguon.DataSource = ttb.get_data("select * from " + user + ".ttb_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0]; } else { manguon.DataSource = ttb.get_data("select * from " + user + ".ttb_dmnguon where id=0 or nhom=" + i_nhom + " order by stt").Tables[0]; } kho.DisplayMember = "TEN"; kho.ValueMember = "ID"; sql = "select * from " + user + ".ttb_dmkho where nhom=" + i_nhom; if (s_kho != "") { sql += " and id in (" + s_kho.Substring(0, s_kho.Length - 1) + ")"; } sql += " order by stt"; dtkho = ttb.get_data(sql).Tables[0]; kho.DataSource = dtkho; tmpkho = ttb.get_data("select * from " + user + ".ttb_dmkho where nhom=" + i_nhom).Tables[0]; dtkhac = ttb.get_data("select * from " + user + ".ttb_dmkhac where nhom=0 or nhom=" + i_nhom + " order by stt").Tables[0]; dtphieu = ttb.get_data("select * from " + user + ".ttb_loaiphieu where nhom=" + i_nhom + " order by stt").Tables[0]; dtloaint = ttb.get_data("select * from " + user + ".ttb_dmloaint where nhom=" + i_nhom + " order by stt").Tables[0]; dtkp = ttb.get_data("select * from " + ttb.UserMedi + ".d_duockp" + ttb.dbLink + " where nhom like '%" + i_nhom.ToString() + ",%'" + " order by stt").Tables[0]; string s_field_sel = ttb.f_get_select_field("ttb_dmbd", "image", "a"); dt = ttb.get_data("select " + s_field_sel + ",b.ten as tenhang,c.ten as tennuoc,d.ten as tennhom from " + user + ".ttb_dmbd a," + user + ".ttb_dmhang b," + user + ".ttb_dmnuoc c," + user + ".ttb_dmnhom d where a.mahang=b.id and a.manuoc=c.id and a.manhom=d.id and a.nhom=" + i_nhom + " order by a.id").Tables[0]; dsdm.ReadXml("..\\..\\..\\xml\\ttb_thekho.xml"); ds.ReadXml("..\\..\\..\\xml\\ttb_sochitiet.xml"); //dsxml.ReadXml("..\\..\\..\\xml\\d_sochitiet.xml"); dsdm.Tables[0].Columns.Add("Chon", typeof(bool)); ds.Tables[0].Columns.Add("sltra", typeof(decimal)).DefaultValue = 0; ds.Tables[0].Columns.Add("sttra", typeof(decimal)).DefaultValue = 0; dsxml = ds.Copy();// load_grid(); AddGridTableStyle(); 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)); }
private void rptBkhoadon_Load(object sender, System.EventArgs e) { user = ttb.user; stime = "'" + ttb.f_ngay + "'"; madv.DisplayMember = "TEN"; madv.ValueMember = "ID"; dt = ttb.get_data("select * from " + user + ".ttb_dmnx where nhom=" + i_nhom + " order by stt").Tables[0]; kho.DisplayMember = "TEN"; kho.ValueMember = "ID"; sql = "select * from " + user + ".ttb_dmkho where nhom=" + i_nhom; if (s_kho != "") { sql += " and id in (" + s_kho.Substring(0, s_kho.Length - 1) + ")"; } sql += " order by stt"; kho.DataSource = ttb.get_data(sql).Tables[0]; // manguon.DisplayMember = "TEN"; manguon.ValueMember = "ID"; sql = "select * from " + user + ".ttb_dmnguon "; if (ttb.bQuanlynguon(i_nhom)) { sql += " where nhom=" + i_nhom; } else { sql += " where id=0"; } sql += " order by stt"; manguon.DataSource = ttb.get_data(sql).Tables[0]; manguon.SelectedIndex = -1; ds.ReadXml("..\\..\\..\\xml\\ttb_bkhoadon.xml"); // manguon.Enabled = ttb.bQuanlynguon(i_nhom); }
private void frmChonnguon_Load(object sender, System.EventArgs e) { user = ttb.user; manguon.DisplayMember = "TEN"; manguon.ValueMember = "ID"; if (ttb.bQuanlynguon(i_nhom)) { manguon.DataSource = ttb.get_data("select * from " + user + ".ttb_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0]; } else { manguon.DataSource = ttb.get_data("select * from " + user + ".ttb_dmnguon where id=0 or nhom=" + i_nhom + " order by stt").Tables[0]; } manguon.SelectedIndex = -1; }
private void rptXuatkho_Load(object sender, System.EventArgs e) { kho.DisplayMember = "TEN"; kho.ValueMember = "ID"; sql = "select * from ttb_dmkho where nhom=" + i_nhom; if (s_kho != "") { sql += " and id in (" + s_kho.Substring(0, s_kho.Length - 1) + ")"; } sql += " order by stt"; dtdmkho = ttb.get_data(sql).Tables[0]; kho.DataSource = dtdmkho; dtdmnhom = ttb.get_data("select * from ttb_dmnhom where stt<>0 and nhom=" + i_nhom + " order by stt").Tables[0]; manhom.DisplayMember = "TEN"; manhom.ValueMember = "ID"; manhom.DataSource = dtdmnhom; manguon.DisplayMember = "TEN"; manguon.ValueMember = "ID"; if (ttb.bQuanlynguon(i_nhom)) { manguon.DataSource = ttb.get_data("select * from ttb_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0]; } else { manguon.DataSource = ttb.get_data("select * from ttb_dmnguon where id=0 or nhom=" + i_nhom + " order by stt").Tables[0]; } nhomcc.DisplayMember = "TEN"; nhomcc.ValueMember = "ID"; if (ttb.bQuanlynhomcc(i_nhom)) { nhomcc.DataSource = ttb.get_data("select * from ttb_nhomcc where nhom=" + i_nhom + " order by stt").Tables[0]; } else { nhomcc.DataSource = ttb.get_data("select * from ttb_nhomcc where id=0 or nhom=" + i_nhom + " order by stt").Tables[0]; } sql = "select a.*, b.stt tt, b.ten nhombd, a.maloai idnn, f.ten noingoai from ttb_dmbd a, ttb_dmnhom b, ttb_dmhang e, ttb_dmloai f"; sql += " where a.manhom=b.id and a.mahang=e.id and a.maloai=f.id and a.nhom=" + i_nhom + " order by a.id"; dt = ttb.get_data(sql).Tables[0]; ds.ReadXml("..\\..\\..\\xml\\ttb_dasudung.xml"); dsxml.ReadXml("..\\..\\..\\xml\\ttb_dasudung.xml"); }
private void rptBctheonhom_Load(object sender, System.EventArgs e) { ds.ReadXml("..\\..\\..\\xml\\ttb_bctheoloai.xml"); dsxml.ReadXml("..\\..\\..\\xml\\ttb_bctheoloai.xml"); dtdmnhom = ttb.get_data("select * from ttb_dmnhom where stt<>0 and nhom=" + i_nhom + " order by stt").Tables[0]; manguon.DisplayMember = "TEN"; manguon.ValueMember = "ID"; if (ttb.bQuanlynguon(i_nhom)) { manguon.DataSource = ttb.get_data("select * from ttb_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0]; } else { manguon.DataSource = ttb.get_data("select * from ttb_dmnguon where id=0 or nhom=" + i_nhom + " order by stt").Tables[0]; } nhomcc.DisplayMember = "TEN"; nhomcc.ValueMember = "ID"; if (ttb.bQuanlynhomcc(i_nhom)) { nhomcc.DataSource = ttb.get_data("select * from ttb_nhomcc where nhom=" + i_nhom + " order by stt").Tables[0]; } else { nhomcc.DataSource = ttb.get_data("select * from ttb_nhomcc where id=0 or nhom=" + i_nhom + " order by stt").Tables[0]; } dt = ttb.get_data("select a.*,b.ten tennhom from ttb_dmbd a,ttb_dmnhom b where a.manhom=b.id and a.nhom=" + i_nhom + " order by a.id").Tables[0]; sql = "select * from 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"; dtdmkho = ttb.get_data(sql).Tables[0]; kho.DisplayMember = "TEN"; kho.ValueMember = "ID"; kho.DataSource = dtdmkho; manhom.DisplayMember = "TEN"; manhom.ValueMember = "ID"; manhom.DataSource = dtdmnhom; s_manhom = ttb.Thongso("manhom").Trim(); }
private void frmThdutru_Load(object sender, System.EventArgs e) { user = ttb.user; xxx = user;// +s_mmyy; dc = new DataColumn(); dc.ColumnName = "makp"; dc.DataType = Type.GetType("System.String"); dtmakp.Columns.Add(dc); dc = new DataColumn(); dc.ColumnName = "tenkp"; dc.DataType = Type.GetType("System.String"); dtmakp.Columns.Add(dc); dc = new DataColumn(); dc.ColumnName = "stt"; dc.DataType = Type.GetType("System.Decimal"); dtmakp.Columns.Add(dc); manguon.DisplayMember = "TEN"; manguon.ValueMember = "ID"; if (ttb.bQuanlynguon(i_nhom)) { manguon.DataSource = ttb.get_data("select * from " + user + ".ttb_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0]; } else { manguon.DataSource = ttb.get_data("select * from " + user + ".ttb_dmnguon where id=0 or nhom=" + i_nhom + " order by stt").Tables[0]; } makho.DisplayMember = "TEN"; makho.ValueMember = "ID"; sql = "select * from " + user + ".ttb_dmkho where nhom=" + i_nhom; if (s_kho != "") { sql += " and id in (" + s_kho.Substring(0, s_kho.Length - 1) + ")"; } sql += " order by stt"; makho.DataSource = ttb.get_data(sql).Tables[0]; dtdmkho = ttb.get_data("select * from " + user + ".ttb_dmkho where nhom=" + i_nhom + " order by stt").Tables[0]; }
private void rptNhap_th_Load(object sender, System.EventArgs e) { user = ttb.user; stime = "'" + ttb.f_ngay + "'"; sql = "select * from " + user + ".ttb_dmnhom where nhom=" + i_nhom + " order by stt"; dtnhom = ttb.get_data(sql).Tables[0]; nhom.DataSource = dtnhom; nhom.DisplayMember = "TEN"; nhom.ValueMember = "ID"; sql = "select * from " + user + ".ttb_dmkho where nhom=" + i_nhom; if (s_kho != "") { sql += " and id in (" + s_kho.Substring(0, s_kho.Length - 1) + ")"; } sql += " order by stt"; dtdmkho = ttb.get_data(sql).Tables[0]; kho.DataSource = dtdmkho; kho.DisplayMember = "TEN"; kho.ValueMember = "ID"; manguon.DisplayMember = "TEN"; manguon.ValueMember = "ID"; if (ttb.bQuanlynguon(i_nhom)) { manguon.DataSource = ttb.get_data("select * from " + user + ".ttb_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0]; } else { manguon.DataSource = ttb.get_data("select * from " + user + ".ttb_dmnguon where id=0 or nhom=" + i_nhom + " order by stt").Tables[0]; } // sql = "select a.*, b.stt as sttnhom, b.ten as nhombd,c.ten as tenhang from " + user + ".ttb_dmbd a, " + user + ".ttb_dmnhom b," + user + ".ttb_dmhang c where a.manhom=b.id and a.mahang=c.id and a.nhom=" + i_nhom + " order by a.id"; dt = ttb.get_data(sql).Tables[0]; // ds.ReadXml("..\\..\\..\\xml\\ttb_dasudung.xml"); dsxml.ReadXml("..\\..\\..\\xml\\ttb_dasudung.xml"); muamoi.Visible = i_nhapxuat == 1; }
private void AddGridTableStyle() { DataGridTableStyle ts = new DataGridTableStyle(); ts.MappingName = dtct.TableName; ts.AlternatingBackColor = Color.Beige; ts.BackColor = Color.GhostWhite; ts.ForeColor = Color.MidnightBlue; ts.GridLineColor = Color.RoyalBlue; ts.HeaderBackColor = Color.MidnightBlue; ts.HeaderForeColor = Color.Lavender; ts.SelectionBackColor = Color.Teal; ts.SelectionForeColor = Color.PaleGreen; ts.ReadOnly = false; ts.RowHeaderWidth = 5; DataGridTextBoxColumn TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "stt"; TextCol.HeaderText = ""; TextCol.Width = 0; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "doituong"; TextCol.HeaderText = ""; TextCol.Width = 0; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "ma"; TextCol.HeaderText = "Mã số"; TextCol.Width = 50; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "ten"; TextCol.HeaderText = "Tên"; TextCol.Width = (bGiaban)?200:230; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "tenhc"; TextCol.HeaderText = ""; TextCol.Width = 0; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "dang"; TextCol.HeaderText = "ĐVT"; TextCol.Width = 50; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "tenkho"; TextCol.HeaderText = "Kho xuất"; TextCol.Width = 70; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "tennguon"; TextCol.HeaderText = "Nguồn"; TextCol.Width = (ttb.bQuanlynguon(i_nhom))?80:0; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "tennhomcc"; TextCol.HeaderText = "Nhà cung cấp"; TextCol.Width = (ttb.bQuanlynhomcc(i_nhom))?90:0; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "handung"; TextCol.HeaderText = "Date"; TextCol.Width = (ttb.bQuanlyhandung(i_nhom))?30:0; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "losx"; TextCol.HeaderText = "Số hiệu"; TextCol.Width = (ttb.bQuanlylosx(i_nhom))?50:0; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "soluong"; TextCol.HeaderText = "Số lượng"; TextCol.Width = 70; TextCol.Format = "#,###,##0.00"; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "dongia"; TextCol.HeaderText = "Đơn giá"; TextCol.Width = 80; TextCol.Format = "###,###,###,##0.000"; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "sotien"; TextCol.HeaderText = "Số tiền"; TextCol.Width = 100; TextCol.Format = "###,###,###,##0.000"; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "giaban"; TextCol.HeaderText = ""; TextCol.Width = 0; TextCol.Format = "###,###,###,##0"; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); }
private void AddGridTableStyle() { DataGridTableStyle ts = new DataGridTableStyle(); ts.MappingName = dt.TableName; ts.AlternatingBackColor = Color.Beige; ts.BackColor = Color.GhostWhite; ts.ForeColor = Color.MidnightBlue; ts.GridLineColor = Color.RoyalBlue; ts.HeaderBackColor = Color.MidnightBlue; ts.HeaderForeColor = Color.Lavender; ts.SelectionBackColor = Color.Teal; ts.SelectionForeColor = Color.PaleGreen; ts.ReadOnly = false; ts.RowHeaderWidth = 10; DataGridTextBoxColumn TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "tennguon"; TextCol.HeaderText = "Nguồn"; TextCol.Width = (ttb.bQuanlynguon(i_nhom) || i_loai == 2)?80:0; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "ma"; TextCol.HeaderText = "Mã số"; TextCol.Width = 50; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "tenbd"; TextCol.HeaderText = "Tên"; TextCol.Width = (ttb.bHoatchat && i_loai == 1)?200:270; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "tenhc"; TextCol.HeaderText = "Hoạt chất"; TextCol.Width = (ttb.bHoatchat && i_loai == 1)?200:0; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "dang"; TextCol.HeaderText = "ĐVT"; TextCol.Width = 50; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "tondau"; TextCol.HeaderText = "Tồn đầu"; TextCol.Width = 72; TextCol.Format = format_soluong; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "slnhap"; TextCol.HeaderText = "Nhập"; TextCol.Width = 72; TextCol.Format = format_soluong; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "slxuat"; TextCol.HeaderText = "Xuất"; TextCol.Width = 72; TextCol.Format = format_soluong; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "toncuoi"; TextCol.HeaderText = "Tồn cuối"; TextCol.Width = 72; TextCol.Format = format_soluong; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "tenkho"; TextCol.HeaderText = "Kho"; TextCol.Width = 100; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); }
private void AddGridTableStyle() { DataGridTableStyle ts = new DataGridTableStyle(); ts.MappingName = dt.TableName; ts.AlternatingBackColor = Color.Beige; ts.BackColor = Color.GhostWhite; ts.ForeColor = Color.MidnightBlue; ts.GridLineColor = Color.RoyalBlue; ts.HeaderBackColor = Color.MidnightBlue; ts.HeaderForeColor = Color.Lavender; ts.SelectionBackColor = Color.Teal; ts.SelectionForeColor = Color.PaleGreen; ts.ReadOnly = false; ts.RowHeaderWidth = 10; DataGridTextBoxColumn TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "tennguon"; TextCol.HeaderText = "Nguồn"; TextCol.Width = (ttb.bQuanlynguon(i_nhom))?80:0; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "tennhomcc"; TextCol.HeaderText = "Nhóm cung cấp"; TextCol.Width = (ttb.bQuanlynhomcc(i_nhom))?90:0; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "ma"; TextCol.HeaderText = "Mã số"; TextCol.Width = 50; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "tenbd"; TextCol.HeaderText = "Tên"; TextCol.Width = 200; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "dang"; TextCol.HeaderText = "ĐVT"; TextCol.Width = 50; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "handung"; TextCol.HeaderText = "Date"; TextCol.Width = (ttb.bQuanlyhandung(i_nhom))?30:0; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "losx"; TextCol.HeaderText = "Số hiệu"; TextCol.Width = (ttb.bQuanlylosx(i_nhom))?50:0; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "giamua"; TextCol.HeaderText = "Đơn gía"; TextCol.Width = 80; TextCol.Format = format_dongia; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "tondau"; TextCol.HeaderText = "Tồn đầu"; TextCol.Width = 80; TextCol.Format = format_soluong; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "sttondau"; TextCol.HeaderText = ""; TextCol.Width = 0; TextCol.Format = format_sotien; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "slnhap"; TextCol.HeaderText = "Nhập"; TextCol.Width = 80; TextCol.Format = format_soluong; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "stnhap"; TextCol.HeaderText = ""; TextCol.Width = 0; TextCol.Format = format_sotien; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "slxuat"; TextCol.HeaderText = "Xuất"; TextCol.Width = 80; TextCol.Format = format_soluong; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "stxuat"; TextCol.HeaderText = ""; TextCol.Width = 0; TextCol.Format = format_sotien; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "toncuoi"; TextCol.HeaderText = "Tồn cuối"; TextCol.Width = 80; TextCol.Format = format_soluong; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); TextCol = new DataGridTextBoxColumn(); TextCol.MappingName = "sttoncuoi"; TextCol.HeaderText = ""; TextCol.Width = 0; TextCol.Format = format_sotien; TextCol.Alignment = HorizontalAlignment.Right; ts.GridColumnStyles.Add(TextCol); dataGrid1.TableStyles.Add(ts); }
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; } } }