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