private void AddGridTableStyle1()
{
DataGridTableStyle ts1 = new DataGridTableStyle();
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
ts1.MappingName = dsxml.Tables[0].TableName;
ts1.AlternatingBackColor = Color.Beige;
ts1.BackColor = Color.GhostWhite;
ts1.ForeColor = Color.MidnightBlue;
ts1.GridLineColor = Color.RoyalBlue;
ts1.HeaderBackColor = Color.MidnightBlue;
ts1.HeaderForeColor = Color.Lavender;
ts1.SelectionBackColor = Color.Teal;
ts1.SelectionForeColor = Color.PaleGreen;
ts1.ReadOnly = false;
ts1.RowHeaderWidth = 5;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "ten";
TextCol.HeaderText = "Tên thuốc - hàm lượng";
TextCol.Width = 150;
ts1.GridColumnStyles.Add(TextCol);
dataGrid2.TableStyles.Add(ts1);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "dang";
TextCol.HeaderText = "ĐVT";
TextCol.Width = 40;
ts1.GridColumnStyles.Add(TextCol);
dataGrid2.TableStyles.Add(ts1);
int i = 3;
string ngay;
i_col = 0;
for (; i < dsct.Tables[0].Columns.Count - 1; i++)
{
ngay = dsct.Tables[0].Columns[i].ColumnName.ToString().Substring(2);
if (ngay.Substring(6, 2) + "/" + ngay.Substring(4, 2) + "/" + ngay.Substring(0, 4) == ngaypt)
{
i_col = i - 3;
}
TextCol = new DataGridColoredTextBoxColumn(de, i - 2);
TextCol.MappingName = dsct.Tables[0].Columns[i].ColumnName.ToString();
TextCol.HeaderText = ngay.Substring(6, 2) + "/" + ngay.Substring(4, 2) + "/" + ngay.Substring(2, 2);
TextCol.Width = 50;
TextCol.Format = "#,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts1.GridColumnStyles.Add(TextCol);
dataGrid2.TableStyles.Add(ts1);
}
TextCol = new DataGridColoredTextBoxColumn(de, i);
TextCol.MappingName = "tongso";
TextCol.HeaderText = "Tổng số";
TextCol.Width = 50;
TextCol.Format = "#,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts1.GridColumnStyles.Add(TextCol);
dataGrid2.TableStyles.Add(ts1);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol1;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
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.RowHeaderWidth = 10;
ts.MappingName = ds.Tables[0].TableName;
ts.AllowSorting = false;
TextCol1 = new DataGridColoredTextBoxColumn(de, 0);
TextCol1.MappingName = "ma";
TextCol1.HeaderText = "ma";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 1);
TextCol1.MappingName = "stt";
TextCol1.HeaderText = "STT";
TextCol1.Width = 24;
TextCol1.ReadOnly = true;
TextCol1.Alignment = HorizontalAlignment.Center;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 2);
TextCol1.MappingName = "ten";
TextCol1.HeaderText = "Khoản mục";
TextCol1.Width = 520;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 3);
TextCol1.MappingName = "vienphi";
TextCol1.HeaderText = "Viện phí (1000đ)";
TextCol1.Width = 100;
TextCol1.Format = "# ### ###.##";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 3);
TextCol1.MappingName = "bhyt";
TextCol1.HeaderText = "BHYT (1000đ)";
TextCol1.Width = 100;
TextCol1.Format = "# ### ###.##";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = ds.Tables[0].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;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "ngay";
TextCol.HeaderText = "Ngày";
TextCol.Width = 70;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "tenkp";
TextCol.HeaderText = "Khoa";
TextCol.Width = 100;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 2);
TextCol.MappingName = "tenloai";
TextCol.HeaderText = "Loại";
TextCol.Width = 90;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "tenphieu";
TextCol.HeaderText = "Phiếu";
TextCol.Width = 105;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "done";
TextCol.HeaderText = "";
TextCol.Width = 0;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
private void KrijoStilHeader(int neVazhdim)
{
hGrid.TableStyles.Clear();
DataGridTableStyle style = new DataGridTableStyle();
style.MappingName = "Table2";
style.HeaderFont = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.hGrid.ReadOnly = true;
style.PreferredRowHeight = 26;
style.RowHeadersVisible = true;
style.HeaderBackColor = SystemColors.InactiveCaptionText;
DateTime data_sot = System.DateTime.Today;
DateTime data_pare;
if (neVazhdim == 1)
{
data_pare = Convert.ToDateTime(ds.Tables[0].Columns[3].ColumnName);
}
else
{
data_pare = data_sot;
}
DateTime data;
string str_data;
for (int i = 0; i < numer_datash; i++)
{
DataGridColoredTextBoxColumn colData = new DataGridColoredTextBoxColumn();
//data = data_sot.AddDays(i);
data = data_pare.AddDays(i);
str_data = data.ToShortDateString();
colData.MappingName = this.ConvertDate(str_data);
colData.HeaderText = ConDate(str_data);
colData.Width = 40;
colData.NullText = "";
style.GridColumnStyles.Add(colData);
}
style.RowHeaderWidth = 80;
hGrid.TableStyles.Add(style);
hGrid.FlatMode = false;
hGrid.Expand(-1);
}
private void AddGridTableStyle(DataSet v_ds)
{
try
{
DataGrid1.TableStyles.Clear();
DataGrid1.AllowSorting = true;
//DataGrid1.DataSource=v_ds.Tables[0];//null;
//return;
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = v_ds.Tables[0].TableName;
ts.AlternatingBackColor = Color.Linen;
ts.BackColor = Color.GhostWhite;
ts.ForeColor = Color.MidnightBlue;
ts.GridLineColor = SystemColors.Control;
ts.HeaderBackColor = SystemColors.Control;
ts.HeaderForeColor = Color.Navy;
ts.SelectionBackColor = Color.Teal;
ts.SelectionForeColor = Color.White;
ts.RowHeaderWidth = 16;
ts.AllowSorting = true;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "ten";
TextCol.HeaderText = "Tên report";
TextCol.ReadOnly = true;
TextCol.Alignment = HorizontalAlignment.Left;
TextCol.Width = 200;
TextCol.NullText = "";
ts.GridColumnStyles.Add(TextCol);
DataGrid1.TableStyles.Add(ts);
DataGrid1.TableStyles.Add(ts);
DataGrid1.DataSource = v_ds.Tables[0];
//MessageBox.Show(v_ds.Tables[0].Rows.Count.ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = ds.Tables[0].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.RowHeaderWidth = 10;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "khoa";
TextCol.HeaderText = "Khoa";
TextCol.Width = 0;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "mabn";
TextCol.HeaderText = "Mã BN";
TextCol.Width = 60;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 2);
TextCol.MappingName = "hoten";
TextCol.HeaderText = "Họ tên";
TextCol.Width = 310;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "phai";
TextCol.HeaderText = "Giới tính";
TextCol.Width = 60;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "namsinh";
TextCol.HeaderText = "Năm sinh";
TextCol.Width = 60;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 5);
TextCol.MappingName = "ngay";
TextCol.HeaderText = "Ngày vào";
TextCol.Width = 110;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 6);
TextCol.MappingName = "tenkp";
TextCol.HeaderText = "Nơi chuyển";
TextCol.Width = 130;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle()
{
DataGridTableStyle ts1 = new DataGridTableStyle();
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
ts1.MappingName = ds.Tables[0].TableName;
ts1.AlternatingBackColor = Color.Beige;
ts1.BackColor = Color.GhostWhite;
ts1.ForeColor = Color.MidnightBlue;
ts1.GridLineColor = Color.RoyalBlue;
ts1.HeaderBackColor = Color.MidnightBlue;
ts1.HeaderForeColor = Color.Lavender;
ts1.SelectionBackColor = Color.Teal;
ts1.SelectionForeColor = Color.PaleGreen;
ts1.ReadOnly = false;
ts1.RowHeaderWidth = 5;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "mabn";
TextCol.HeaderText = "Mã BN";
TextCol.Width = 55;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "hoten";
TextCol.HeaderText = "Họ và tên";
TextCol.Width = 140;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
TextCol = new DataGridColoredTextBoxColumn(de, 2);
TextCol.MappingName = "sothe";
TextCol.HeaderText = "Số thẻ";
TextCol.Width = 100;
TextCol.NullText = string.Empty;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "ngayvao";
TextCol.HeaderText = "Ngày vào";
TextCol.Width = 100;
TextCol.NullText = string.Empty;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "ngayra";
TextCol.HeaderText = "Ngày ra";
TextCol.Width = 100;
TextCol.NullText = string.Empty;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
TextCol = new DataGridColoredTextBoxColumn(de, 5);
TextCol.MappingName = "thuoc";
TextCol.HeaderText = "Thuốc";
TextCol.Width = 80;
TextCol.Format = "###,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
TextCol = new DataGridColoredTextBoxColumn(de, 6);
TextCol.MappingName = "vienphi";
TextCol.HeaderText = "Viện phí";
TextCol.Width = 80;
TextCol.Format = "###,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
TextCol = new DataGridColoredTextBoxColumn(de, 7);
TextCol.MappingName = "sotien";
TextCol.HeaderText = "Chi phí";
TextCol.Width = 80;
TextCol.Format = "###,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol1;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
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.RowHeaderWidth = 10;
ts.MappingName = dsxml.Tables[0].TableName;
TextCol1 = new DataGridColoredTextBoxColumn(de, 0);
TextCol1.MappingName = "ten";
TextCol1.HeaderText = "Tên vật tư";
TextCol1.Width = 200;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 1);
TextCol1.MappingName = "donvi";
TextCol1.HeaderText = "Đóng gói";
TextCol1.Width = 60;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 2);
TextCol1.MappingName = "dang";
TextCol1.HeaderText = "ĐVT";
TextCol1.Width = 40;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 3);
TextCol1.MappingName = "tenhang";
TextCol1.HeaderText = "Hãng SX";
TextCol1.Width = 150;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 4);
TextCol1.MappingName = "dau";
TextCol1.HeaderText = "Tồn đầu";
TextCol1.Width = 60;
TextCol1.ReadOnly = true;
TextCol1.Format = format_soluong;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 5);
TextCol1.MappingName = "nhap";
TextCol1.HeaderText = "Nhập";
TextCol1.Width = 60;
TextCol1.ReadOnly = true;
TextCol1.Format = format_soluong;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 6);
TextCol1.MappingName = "xuat";
TextCol1.HeaderText = "Xuất";
TextCol1.Width = 60;
TextCol1.ReadOnly = true;
TextCol1.Format = format_soluong;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 7);
TextCol1.MappingName = "ton";
TextCol1.HeaderText = "Tồn kho";
TextCol1.Width = 60;
TextCol1.ReadOnly = true;
TextCol1.Format = format_soluong;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 8);
TextCol1.MappingName = "tutruc";
TextCol1.HeaderText = "Tủ trực";
TextCol1.Width = 60;
TextCol1.ReadOnly = true;
TextCol1.Format = format_soluong;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 9);
TextCol1.MappingName = "tc";
TextCol1.HeaderText = "Tổng tồn";
TextCol1.Width = 60;
TextCol1.ReadOnly = true;
TextCol1.Format = format_soluong;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 10);
TextCol1.MappingName = "dongia";
TextCol1.HeaderText = "Đơn giá";
TextCol1.Width = 80;
TextCol1.Format = format_dongia;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 11);
TextCol1.MappingName = "ghichu";
TextCol1.HeaderText = "Xuất nhiều nhất";
TextCol1.Width = 100;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 12);
TextCol1.MappingName = "l1";
TextCol1.HeaderText = "Dự trù " + i_lanthu.ToString();
TextCol1.Width = 60;
TextCol1.Format = format_soluong;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 13);
TextCol1.MappingName = "d1";
TextCol1.HeaderText = "Duyệt " + i_lanthu.ToString();
TextCol1.Width = 60;
TextCol1.Format = format_soluong;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 14);
TextCol1.MappingName = "nhacc";
TextCol1.HeaderText = "Nhà cung cấp";
TextCol1.Width = 200;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 15);
TextCol1.MappingName = "mabd";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle()
{
DataGridTableStyle ts1 = new DataGridTableStyle();
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
ts1.MappingName = ds.Tables[0].TableName;
ts1.AlternatingBackColor = Color.Beige;
ts1.BackColor = Color.GhostWhite;
ts1.ForeColor = Color.MidnightBlue;
ts1.GridLineColor = Color.RoyalBlue;
ts1.HeaderBackColor = Color.MidnightBlue;
ts1.HeaderForeColor = Color.Lavender;
ts1.SelectionBackColor = Color.Teal;
ts1.SelectionForeColor = Color.PaleGreen;
ts1.ReadOnly = false;
ts1.RowHeaderWidth = 5;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "tenkp";
TextCol.HeaderText = "Khoa";
TextCol.Width = 100;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "mabn";
TextCol.HeaderText = "Mã BN";
TextCol.Width = 55;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
TextCol = new DataGridColoredTextBoxColumn(de, 2);
TextCol.MappingName = "hoten";
TextCol.HeaderText = "Họ và tên";
TextCol.Width = 140;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "ngayvao";
TextCol.HeaderText = "Ngày vào";
TextCol.Width = 100;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "ngayra";
TextCol.HeaderText = "Ngày ra";
TextCol.Width = 100;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
TextCol = new DataGridColoredTextBoxColumn(de, 5);
TextCol.MappingName = "chandoan";
TextCol.HeaderText = "Chẩn đoán";
TextCol.Width = 150;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
TextCol = new DataGridColoredTextBoxColumn(de, 6);
TextCol.MappingName = "maicd";
TextCol.HeaderText = "ICD 10";
TextCol.Width = 40;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
TextCol = new DataGridColoredTextBoxColumn(de, 7);
TextCol.MappingName = "soluong";
TextCol.HeaderText = "Số lượng";
TextCol.Width = 50;
TextCol.Format = "###,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts1.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts1);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = ds.Tables[0].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;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "ma";
TextCol.HeaderText = "Mã số";
TextCol.Width = 50;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "tenbd";
TextCol.HeaderText = "Tên thuốc - hàm lượng";
TextCol.Width = 200;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 2);
TextCol.MappingName = "dang";
TextCol.HeaderText = "ĐVT";
TextCol.Width = 50;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "tc";
TextCol.HeaderText = "Tổng Tồn";
TextCol.Width = 72;
TextCol.Format = format_soluong;
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
int i = 4; i_makho = 0;
foreach (DataRow r in dtkho.Rows)
{
if (r["id"].ToString().Trim() + "," == s_kho)
{
i_makho = i;
}
TextCol = new DataGridColoredTextBoxColumn(de, i++);
TextCol.MappingName = "c_" + r["id"].ToString().PadLeft(3, '0');
TextCol.HeaderText = r["ten"].ToString();
TextCol.Width = 72;
TextCol.Format = format_soluong;
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = ds.Tables[0].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.AllowSorting = false;
ts.ReadOnly = false;
ts.RowHeaderWidth = 10;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "makp";
TextCol.HeaderText = "Khoa";
TextCol.Width = 150;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "so";
TextCol.HeaderText = "Tổng số";
TextCol.Width = 60;
TextCol.Format = "###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 2);
TextCol.MappingName = "nam";
TextCol.HeaderText = "Nam";
TextCol.Width = 60;
TextCol.Format = "###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "nu";
TextCol.HeaderText = "Nữ";
TextCol.Width = 60;
TextCol.Format = "###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "bhyt";
TextCol.HeaderText = "BHYT";
TextCol.Width = 60;
TextCol.Format = "###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 5);
TextCol.MappingName = "khac";
TextCol.HeaderText = "Khác";
TextCol.Width = 60;
TextCol.Format = "###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 6);
TextCol.MappingName = "t04";
TextCol.HeaderText = "0-4 Tuổi";
TextCol.Width = 60;
TextCol.Format = "###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 7);
TextCol.MappingName = "t06";
TextCol.HeaderText = "0-6 Tuổi";
TextCol.Width = 60;
TextCol.Format = "###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 8);
TextCol.MappingName = "t14";
TextCol.HeaderText = "0-14 Tuổi";
TextCol.Width = 60;
TextCol.Format = "###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 9);
TextCol.MappingName = "t1560";
TextCol.HeaderText = "15-60 Tuổi";
TextCol.Width = 60;
TextCol.Format = "###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 10);
TextCol.MappingName = "t90";
TextCol.HeaderText = "90 Tuổi";
TextCol.Width = 60;
TextCol.Format = "###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 11);
TextCol.MappingName = "tinh";
TextCol.HeaderText = "Tỉnh";
TextCol.Width = 60;
TextCol.Format = "###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 12);
TextCol.MappingName = "tp";
TextCol.HeaderText = s_tinh;
TextCol.Width = 60;
TextCol.Format = "###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 13);
TextCol.MappingName = "cv";
TextCol.HeaderText = "Chuyển viện";
TextCol.Width = 60;
TextCol.Format = "###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 14);
TextCol.MappingName = "tv";
TextCol.HeaderText = "Tử vong";
TextCol.Width = 60;
TextCol.Format = "###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle(DataSet v_ds)
{
try
{
DataGrid1.TableStyles.Clear();
DataGrid1.AllowSorting = true;
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = v_ds.Tables[0].TableName;
ts.AlternatingBackColor = Color.LightYellow;
ts.BackColor = Color.White;
ts.ForeColor = Color.MidnightBlue;
ts.GridLineColor = Color.RoyalBlue;
ts.HeaderBackColor = SystemColors.Control;
ts.HeaderForeColor = Color.Black;
ts.SelectionBackColor = Color.Teal;
ts.SelectionForeColor = Color.PaleGreen;
ts.RowHeaderWidth = 16;
ts.AllowSorting = true;
ts.PreferredRowHeight = 20;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "id";
TextCol.HeaderText = "id";
TextCol.ReadOnly = true;
TextCol.Alignment = HorizontalAlignment.Left;
TextCol.Width = 0;
TextCol.NullText = "";
ts.GridColumnStyles.Add(TextCol);
DataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "ma";
TextCol.HeaderText = "Tên report";
TextCol.ReadOnly = true;
TextCol.Alignment = HorizontalAlignment.Left;
TextCol.Width = 100;
TextCol.NullText = "";
ts.GridColumnStyles.Add(TextCol);
DataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "ten";
TextCol.HeaderText = "Diễn giải";
TextCol.ReadOnly = true;
TextCol.Alignment = HorizontalAlignment.Left;
TextCol.Width = 336;
TextCol.NullText = "";
ts.GridColumnStyles.Add(TextCol);
DataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "tenloai";
TextCol.HeaderText = "Loại bảng kê";
TextCol.ReadOnly = true;
TextCol.Alignment = HorizontalAlignment.Left;
TextCol.Width = 150;
TextCol.NullText = "";
ts.GridColumnStyles.Add(TextCol);
DataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "loai";
TextCol.HeaderText = "";
TextCol.NullText = "";
TextCol.ReadOnly = true;
TextCol.Alignment = HorizontalAlignment.Center;
TextCol.Width = 0;
ts.GridColumnStyles.Add(TextCol);
DataGrid1.TableStyles.Add(ts);
DataGrid1.DataSource = v_ds.Tables[0];
}
catch //(Exception ex)
{
// MessageBox.Show(ex.ToString());
}
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = ds.Tables[0].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.SelectionBackColor = Color.FromArgb(0, 255, 255);
ts.SelectionForeColor = Color.PaleGreen;
//ts.ReadOnly=false;
ts.RowHeaderWidth = 5;
DataGridBoolColumn ChkCol = new DataGridBoolColumn();
ChkCol.MappingName = "chon";
ChkCol.HeaderText = "Chọn";
ChkCol.Width = 30;
ChkCol.ReadOnly = false;
ChkCol.AllowNull = false;
ts.GridColumnStyles.Add(ChkCol);
dataGrid1.TableStyles.Add(ts);
//FormattableBooleanColumn discontinuedCol = new FormattableBooleanColumn();
//discontinuedCol.MappingName = "chon";
//discontinuedCol.HeaderText = "Chọn";
//discontinuedCol.Width = 30;
//discontinuedCol.SetCellFormat += new FormatCellEventHandler(SetCellFormat);
//discontinuedCol.BoolValueChanged += new BoolValueChangedEventHandler(BoolValueChanged);
//ts.GridColumnStyles.Add(discontinuedCol);
//dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "tenkp";
TextCol.HeaderText = "Khoa/Phòng";
TextCol.Width = 100;
TextCol.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "ngay";
TextCol.HeaderText = "Ngày";
TextCol.Width = 70;
TextCol.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 2);
TextCol.MappingName = "tenbd";
TextCol.HeaderText = "Tên thuốc - hàm lượng";
TextCol.Width = 200;
TextCol.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "dang";
TextCol.HeaderText = "ĐVT";
TextCol.Width = 30;
TextCol.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "soluong";
TextCol.HeaderText = "Số lượng";
TextCol.Width = 50;
TextCol.ReadOnly = true;
TextCol.Format = "#,###,##0.00";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 5);
TextCol.MappingName = "loai";
TextCol.HeaderText = "";
TextCol.Width = 0;
TextCol.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = ds.Tables[0].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;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "tenkp";
TextCol.HeaderText = "Khoa/Phòng";
TextCol.Width = 100;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "ngay";
TextCol.HeaderText = "Ngày";
TextCol.Width = 70;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 2);
TextCol.MappingName = "tenbd";
TextCol.HeaderText = "Tên thuốc - hàm lượng";
TextCol.Width = 200;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "dang";
TextCol.HeaderText = "ĐVT";
TextCol.Width = 30;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "soluong";
TextCol.HeaderText = "Số lượng";
TextCol.Width = 50;
TextCol.Format = "#,###,##0.00";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 5);
TextCol.MappingName = "loai";
TextCol.HeaderText = "";
TextCol.Width = 0;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = ds.Tables[0].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;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "ten";
TextCol.HeaderText = "Nội dung";
TextCol.Width = 380;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "c01";
TextCol.HeaderText = "Ca chỉ định";
TextCol.Width = 80;
TextCol.Format = "###,###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 2);
TextCol.MappingName = "c02";
TextCol.HeaderText = "Ca thu tiền";
TextCol.Width = 80;
TextCol.Format = "###,###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "c03";
TextCol.HeaderText = "Số tiền đã thu";
TextCol.Width = 100;
TextCol.Format = "###,###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "c04";
TextCol.HeaderText = "Ca đã thực hiện";
TextCol.Width = 100;
TextCol.Format = "###,###,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
private void KrijoStilGrid(int neVazhdim)
{
grid.TableStyles.Clear();
DataGridTableStyle style = new DataGridTableStyle();
style.MappingName = "Table1";
style.HeaderFont = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
style.SelectionBackColor = System.Drawing.SystemColors.InactiveCaption;
style.GridLineColor = System.Drawing.Color.SteelBlue;
this.grid.ReadOnly = true;
style.PreferredRowHeight = 16;
style.RowHeadersVisible = true;
style.HeaderBackColor = SystemColors.InactiveCaptionText;
DateTime data_sot = System.DateTime.Today;
DateTime data_pare;
if (neVazhdim == 1)
{
data_pare = Convert.ToDateTime(ds.Tables[0].Columns[3].ColumnName);
}
else
{
data_pare = data_sot;
}
DateTime data;
string str_data;
for (int i = -3; i < numer_datash; i++)
{
DataGridColoredTextBoxColumn colData = new DataGridColoredTextBoxColumn();
if (i >= 0)
{
//data = data_sot.AddDays(i);
data = data_pare.AddDays(i);
str_data = data.ToShortDateString();
colData.MappingName = this.ConvertDate(str_data);
colData.HeaderText = ConDate(str_data);
colData.Width = 40;
colData.NullText = "";
style.GridColumnStyles.Add(colData);
}
else if (i == -3)
{
colData.HeaderText = "Id";
colData.MappingName = "ID_DHOMA";
colData.Width = 0;
style.GridColumnStyles.Add(colData);
}
else if (i == -2)
{
// colData.HeaderText = "Dhoma";
// colData.MappingName = "DHOMA_EMRI";
// colData.Width = 100;
// style.GridColumnStyles.Add(colData);
}
else if (i == -1)
{
colData.HeaderText = "Numer Krevatesh";
colData.MappingName = "NR_KREVATESH";
colData.Width = 0;
style.GridColumnStyles.Add(colData);
}
}
style.RowHeaderWidth = 80;
grid.TableStyles.Add(style);
grid.FlatMode = false;
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol1;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
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.RowHeaderWidth = 10;
ts.MappingName = dtct.TableName;
TextCol1 = new DataGridColoredTextBoxColumn(de, 0);
TextCol1.MappingName = "tenhc";
TextCol1.HeaderText = "Hoạt chất";
TextCol1.Width = 120;
TextCol1.NullText = string.Empty;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
TextCol1 = new DataGridColoredTextBoxColumn(de, 1);
TextCol1.MappingName = "mabd";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
TextCol1 = new DataGridColoredTextBoxColumn(de, 2);
TextCol1.MappingName = "ma";
TextCol1.HeaderText = "Mã";
TextCol1.Width = 60;
ts.GridColumnStyles.Add(TextCol1);
TextCol1 = new DataGridColoredTextBoxColumn(de, 3);
TextCol1.MappingName = "ten";
TextCol1.HeaderText = "Tên thuốc - hàm lượng";
TextCol1.Width = 200;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
TextCol1 = new DataGridColoredTextBoxColumn(de, 4);
TextCol1.MappingName = "donvi";
TextCol1.HeaderText = "Đóng gói";
TextCol1.Width = 60;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
TextCol1 = new DataGridColoredTextBoxColumn(de, 5);
TextCol1.MappingName = "dang";
TextCol1.HeaderText = "ĐVT";
TextCol1.Width = 40;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
TextCol1 = new DataGridColoredTextBoxColumn(de, 6);
TextCol1.MappingName = "tenhang";
TextCol1.HeaderText = "Hãng SX";
TextCol1.Width = 100;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
TextCol1 = new DataGridColoredTextBoxColumn(de, 7);
TextCol1.MappingName = "nhacc";
TextCol1.HeaderText = "Nhà cung cấp";
TextCol1.Width = 200;
TextCol1.ReadOnly = true;
TextCol1.NullText = "";
ts.GridColumnStyles.Add(TextCol1);
TextCol1 = new DataGridColoredTextBoxColumn(de, 8);
TextCol1.MappingName = "xuat10";
TextCol1.HeaderText = "Sử dụng(-10)";
TextCol1.Width = 75;
TextCol1.ReadOnly = true;
TextCol1.Format = format_soluong;
TextCol1.NullText = "0";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
TextCol1 = new DataGridColoredTextBoxColumn(de, 9);
TextCol1.MappingName = "xuat30";
TextCol1.HeaderText = "Sử dụng(-30)";
TextCol1.Width = 75;
TextCol1.ReadOnly = true;
TextCol1.NullText = "0";
TextCol1.Format = format_soluong;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
TextCol1 = new DataGridColoredTextBoxColumn(de, 10);
TextCol1.MappingName = "slton";
TextCol1.HeaderText = "Tồn";
TextCol1.Width = 60;
TextCol1.ReadOnly = true;
TextCol1.NullText = "0";
TextCol1.Format = format_soluong;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
TextCol1 = new DataGridColoredTextBoxColumn(de, 11);
TextCol1.MappingName = "slgoiy";
TextCol1.HeaderText = "SL gợi ý";
TextCol1.Width = 60;
TextCol1.ReadOnly = true;
TextCol1.NullText = "0";
TextCol1.Format = format_soluong;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
TextCol1 = new DataGridColoredTextBoxColumn(de, 12);
TextCol1.MappingName = "soluong";
TextCol1.HeaderText = "Dự trù ";
TextCol1.Width = 60;
TextCol1.NullText = "0.0";
TextCol1.Format = format_soluong;
//TextCol1.ReadOnly = bDutru_Readonly;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
TextCol1 = new DataGridColoredTextBoxColumn(de, 13);
TextCol1.MappingName = "lydo";
TextCol1.HeaderText = "Lý do";
TextCol1.Width = 60;
TextCol1.NullText = "";
//TextCol1.ReadOnly = !bDutru_Readonly;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
TextCol1 = new DataGridColoredTextBoxColumn(de, 14);
TextCol1.MappingName = "id";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Clear();
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = dsxml.Tables[0].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.AllowSorting = false;
ts.ReadOnly = false;
ts.RowHeaderWidth = 5;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "id";
TextCol.HeaderText = "";
TextCol.Width = 0;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "ten";
TextCol.HeaderText = (i_dang != 0)?"Tên thuốc - hàm lượng":"Nội dung";
TextCol.Width = 175 - i_dang + ((theo.SelectedIndex == 4 || rb1.Checked || rb2.Checked)?185:0);
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 2);
TextCol.MappingName = "dang";
TextCol.HeaderText = "ĐVT";
TextCol.Width = i_dang;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
if (theo.SelectedIndex == 7 || theo.SelectedIndex == 5)
{
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "kho";
TextCol.HeaderText = "Kho";
TextCol.Width = 105;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "losx";
TextCol.HeaderText = (theo.SelectedIndex == 7)?"Lô":"Số ĐK";
TextCol.Width = 50;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 5);
TextCol.MappingName = "handung";
TextCol.HeaderText = "Date";
TextCol.Width = 35;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 6);
TextCol.MappingName = "soluong";
TextCol.HeaderText = "Số lượng";
TextCol.Width = 40;
TextCol.Format = "###,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 6);
TextCol.MappingName = "giamua";
TextCol.HeaderText = "Đơn giá";
TextCol.Width = 60;
TextCol.Format = "###,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 7);
TextCol.MappingName = "sotien";
TextCol.HeaderText = "Số tiền";
TextCol.Width = 80;
TextCol.Format = "###,###,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
else if (theo.SelectedIndex == 6)
{
string ngay;
int i = 3;
for (; i < dsxml.Tables[0].Columns.Count - 2; i++)
{
ngay = dsxml.Tables[0].Columns[i].ColumnName.ToString().Substring(1);
TextCol = new DataGridColoredTextBoxColumn(de, i);
TextCol.MappingName = dsxml.Tables[0].Columns[i].ColumnName.ToString();
TextCol.HeaderText = ngay.Substring(4, 2) + "/" + ngay.Substring(2, 2) + "/" + ngay.Substring(0, 2);
TextCol.Format = "#,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
TextCol.Width = 50;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
TextCol = new DataGridColoredTextBoxColumn(de, i + 1);
TextCol.MappingName = "tyle";
TextCol.HeaderText = "Tỷ lệ";
TextCol.Width = 35;
TextCol.Format = "###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, i + 2);
TextCol.MappingName = "ghichu";
TextCol.HeaderText = "Ghi chú";
TextCol.Width = 50;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
else
{
if (rb1.Checked || rb3.Checked)
{
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "n_so";
TextCol.HeaderText = (i_dang != 0)?"SL":"Số";
TextCol.Width = 30;
TextCol.Format = "#,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "n_so_tl";
TextCol.HeaderText = "%";
TextCol.Width = 35;
TextCol.Format = "#,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 5);
TextCol.MappingName = "n_tien";
TextCol.HeaderText = "Số tiền nhập";
TextCol.Width = 85;
TextCol.Format = "#,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 6);
TextCol.MappingName = "n_tien_tl";
TextCol.HeaderText = "%";
TextCol.Width = 35;
TextCol.Format = "#,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
if (rb2.Checked || rb3.Checked)
{
TextCol = new DataGridColoredTextBoxColumn(de, 7);
TextCol.MappingName = "x_so";
TextCol.HeaderText = (i_dang != 0)?"SL":"Số";
TextCol.Width = 30;
TextCol.Format = "#,###,###";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 8);
TextCol.MappingName = "x_so_tl";
TextCol.HeaderText = "%";
TextCol.Width = 35;
TextCol.Format = "#,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 9);
TextCol.MappingName = "x_tien";
TextCol.HeaderText = "Số tiền xuất";
TextCol.Width = 85;
TextCol.Format = "#,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 10);
TextCol.MappingName = "x_tien_tl";
TextCol.HeaderText = "%";
TextCol.Width = 35;
TextCol.Format = "#,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
}
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol1;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
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.RowHeaderWidth = 10;
ts.MappingName = ds.Tables[0].TableName;
ts.AllowSorting = false;
TextCol1 = new DataGridColoredTextBoxColumn(de, 0);
TextCol1.MappingName = "id";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 1);
TextCol1.MappingName = "tenkp";
TextCol1.HeaderText = "Khoa/phòng";
TextCol1.Width = 95;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 2);
TextCol1.MappingName = "ngay";
TextCol1.HeaderText = "Ngày";
TextCol1.Width = 70;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 3);
TextCol1.MappingName = "doituong";
TextCol1.HeaderText = "Đối tượng";
TextCol1.Width = 58;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 4);
TextCol1.MappingName = "ten";
TextCol1.HeaderText = "Dịch vụ";
TextCol1.Width = 230;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 5);
TextCol1.MappingName = "dvt";
TextCol1.HeaderText = "ĐVT";
TextCol1.Width = 30;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 6);
TextCol1.MappingName = "soluong";
TextCol1.HeaderText = "Số lượng";
TextCol1.Width = 50;
TextCol1.Format = "### ###.00";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 7);
TextCol1.MappingName = "makp";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 8);
TextCol1.MappingName = "madoituong";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 9);
TextCol1.MappingName = "mavp";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 10);
TextCol1.MappingName = "dongia";
TextCol1.HeaderText = "Đơn gía";
TextCol1.Width = 65;
TextCol1.Format = "### ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 11);
TextCol1.MappingName = "paid";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 12);
TextCol1.MappingName = "done";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 13);
TextCol1.MappingName = "maql";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 14);
TextCol1.MappingName = "idkhoa";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 15);
TextCol1.MappingName = "vattu";
TextCol1.HeaderText = "Vật tư";
TextCol1.Width = 65;
TextCol1.Format = "### ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol1;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
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.RowHeaderWidth = 10;
ts.MappingName = dtct.TableName;
TextCol1 = new DataGridColoredTextBoxColumn(de, 0);
TextCol1.MappingName = "tenhc";
TextCol1.HeaderText = "Hoạt chất";
TextCol1.Width = 120;
TextCol1.NullText = string.Empty;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 1);
TextCol1.MappingName = "mabd";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 2);
TextCol1.MappingName = "ten";
TextCol1.HeaderText = "Tên thuốc - hàm lượng";
TextCol1.Width = 200;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 3);
TextCol1.MappingName = "dang";
TextCol1.HeaderText = "ĐVT";
TextCol1.Width = 40;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 4);
TextCol1.MappingName = "soluong";
TextCol1.HeaderText = "Dự trù ";
TextCol1.Width = 60;
TextCol1.NullText = "0";
TextCol1.Format = format_soluong;
TextCol1.ReadOnly = true;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 5);
TextCol1.MappingName = "slduyet";
TextCol1.HeaderText = "Duyệt";
TextCol1.Width = 60;
TextCol1.NullText = "0";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 6);
TextCol1.MappingName = "id";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
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 = 5;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "tennguon";
TextCol.HeaderText = "Nguồn";
TextCol.Width = (d.bQuanlynguon(i_nhom))?80:0;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "ma";
TextCol.HeaderText = "Mã số";
TextCol.Width = 50;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 2);
TextCol.MappingName = "tenbd";
TextCol.HeaderText = "Tên";
TextCol.Width = (d.bHoatchat)?200:270;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "tenhc";
TextCol.HeaderText = "Hoạt chất";
TextCol.Width = (d.bHoatchat)?200:0;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "dang";
TextCol.HeaderText = "ĐVT";
TextCol.Width = 50;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 5);
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 DataGridColoredTextBoxColumn(de, 6);
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 DataGridColoredTextBoxColumn(de, 7);
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 DataGridColoredTextBoxColumn(de, 8);
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 DataGridColoredTextBoxColumn(de, 9);
TextCol.MappingName = "tongton";
TextCol.HeaderText = "Tổng tồn";
TextCol.Width = 72;
TextCol.Format = format_soluong;
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 10);
TextCol.MappingName = "toithieu";
TextCol.HeaderText = "Tồn tối thiểu";
TextCol.Width = 72;
TextCol.Format = format_soluong;
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 11);
TextCol.MappingName = "slyeucau";
TextCol.HeaderText = "KP Dự trù";
TextCol.Width = 72;
TextCol.Format = format_soluong;
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 12);
TextCol.MappingName = "makho";
TextCol.HeaderText = "";
TextCol.Width = 0;
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 13);
TextCol.MappingName = "mabd";
TextCol.HeaderText = "";
TextCol.Width = 0;
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = ds.Tables[0].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;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "tennguon";
TextCol.HeaderText = "Nguồn";
TextCol.Width = (d.bQuanlynguon(i_nhom))?80:0;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "ma";
TextCol.HeaderText = "Mã số";
TextCol.Width = 50;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 2);
TextCol.MappingName = "tenbd";
TextCol.HeaderText = "Tên";
TextCol.Width = (d.bHoatchat)?200:270;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "tenhc";
TextCol.HeaderText = "Hoạt chất";
TextCol.Width = (d.bHoatchat)?200:0;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "dang";
TextCol.HeaderText = "ĐVT";
TextCol.Width = 50;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 5);
TextCol.MappingName = "tc";
TextCol.HeaderText = "Tổng Tồn";
TextCol.Width = 72;
TextCol.Format = format_soluong;
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
int i = 6;
foreach (DataRow r in dtkho.Rows)
{
TextCol = new DataGridColoredTextBoxColumn(de, i++);
TextCol.MappingName = "c_" + r["id"].ToString().PadLeft(3, '0');
TextCol.HeaderText = r["ten"].ToString();
TextCol.Width = 72;
TextCol.Format = format_soluong;
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = ds.Tables[0].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.RowHeaderWidth = 10;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "khoa";
TextCol.HeaderText = "Khoa";
TextCol.Width = (songay != 0)?100:0;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "mabn";
TextCol.HeaderText = "Mã BN";
TextCol.Width = 60;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 2);
TextCol.MappingName = "hoten";
TextCol.HeaderText = "Họ tên";
TextCol.Width = 200;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "phai";
TextCol.HeaderText = "Phái";
TextCol.Width = 40;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "namsinh";
TextCol.HeaderText = "Năm sinh";
TextCol.Width = 60;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 5);
TextCol.MappingName = "ngay";
TextCol.HeaderText = "Ngày vào";
TextCol.Width = 110;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 6);
TextCol.MappingName = "tenkp";
TextCol.HeaderText = "Nơi chuyển";
TextCol.Width = 100;
TextCol.NullText = string.Empty;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 7);
TextCol.MappingName = "ngaydt";
TextCol.HeaderText = "Số ngày";
TextCol.Format = "### ###";
TextCol.Alignment = HorizontalAlignment.Right;
TextCol.Width = 60;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 8);
TextCol.MappingName = "sothe";
TextCol.HeaderText = "Số thẻ";
TextCol.Width = 100;
TextCol.NullText = string.Empty;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 9);
TextCol.MappingName = "traituyen";
TextCol.HeaderText = "Trái tuyến";
TextCol.Width = 50;
TextCol.NullText = string.Empty;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol1;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
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.RowHeaderWidth = 10;
ts.MappingName = ds.Tables[0].TableName;
TextCol1 = new DataGridColoredTextBoxColumn(de, 0);
TextCol1.MappingName = "tennguon";
TextCol1.HeaderText = "Nguồn";
TextCol1.ReadOnly = true;
TextCol1.Width = 80;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 1);
TextCol1.MappingName = "tennx";
TextCol1.HeaderText = "Nhà cung cấp";
TextCol1.Width = 200;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 2);
TextCol1.MappingName = "ten";
TextCol1.HeaderText = "Tên thuốc - hàm lượng";
TextCol1.Width = 200;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 3);
TextCol1.MappingName = "dang";
TextCol1.HeaderText = "ĐVT";
TextCol1.Width = 40;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 4);
TextCol1.MappingName = "tenhang";
TextCol1.HeaderText = "Hãng SX";
TextCol1.Width = 150;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 5);
TextCol1.MappingName = "giamua";
TextCol1.HeaderText = "Đơn giá";
TextCol1.Width = 70;
TextCol1.Format = format_dongia;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 6);
TextCol1.MappingName = "handung";
TextCol1.HeaderText = "Date";
TextCol1.Width = 40;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 7);
TextCol1.MappingName = "losx";
TextCol1.HeaderText = "Lô";
TextCol1.Width = 80;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 8);
TextCol1.MappingName = "slton";
TextCol1.HeaderText = "Tồn cuối";
TextCol1.Width = 60;
TextCol1.ReadOnly = true;
TextCol1.Format = format_soluong;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 9);
TextCol1.MappingName = "slkk";
TextCol1.HeaderText = "Kiểm kê";
TextCol1.Width = 60;
TextCol1.Format = format_soluong;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 10);
TextCol1.MappingName = "thua";
TextCol1.HeaderText = "Thừa";
TextCol1.Width = 50;
TextCol1.ReadOnly = true;
TextCol1.Format = format_soluong;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 11);
TextCol1.MappingName = "thieu";
TextCol1.HeaderText = "Thiếu";
TextCol1.Width = 50;
TextCol1.ReadOnly = true;
TextCol1.Format = format_soluong;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 12);
TextCol1.MappingName = "stt";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle1()
{
DataGridColoredTextBoxColumn TextCol1;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol1);
DataGridTableStyle ts = new DataGridTableStyle();
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.RowHeaderWidth = 10;
ts.MappingName = ds1.Tables[0].TableName;
ts.ColumnHeadersVisible = false;
TextCol1 = new DataGridColoredTextBoxColumn(de, 0);
TextCol1.MappingName = "ten";
TextCol1.HeaderText = "";
TextCol1.Width = 395;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid2.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 1);
TextCol1.MappingName = "C01";
TextCol1.HeaderText = "";
TextCol1.Width = 35;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid2.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 2);
TextCol1.MappingName = "ten1";
TextCol1.HeaderText = "";
TextCol1.Width = 75;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid2.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 3);
TextCol1.MappingName = "C02";
TextCol1.HeaderText = "";
TextCol1.Width = 30;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid2.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 4);
TextCol1.MappingName = "ten2";
TextCol1.HeaderText = "";
TextCol1.Width = 110;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid2.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 5);
TextCol1.MappingName = "C03";
TextCol1.HeaderText = "";
TextCol1.Width = 30;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid2.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 6);
TextCol1.MappingName = "ten3";
TextCol1.HeaderText = "";
TextCol1.Width = 70;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid2.TableStyles.Add(ts);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = ds.Tables[0].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;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "stt";
TextCol.HeaderText = "Stt";
TextCol.Width = 20;
TextCol.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "ten";
TextCol.HeaderText = "Nội dung";
TextCol.Width = 140;
TextCol.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 2);
TextCol.MappingName = "dongia";
TextCol.HeaderText = "Đơn giá";
TextCol.Width = 60;
TextCol.Format = "###,###,##0";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "lamthem";
TextCol.HeaderText = "Làm thêm";
TextCol.Width = 140;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "ketqua";
TextCol.HeaderText = "Kết quả";
TextCol.Width = 200;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 5);
TextCol.MappingName = "ghichu";
TextCol.HeaderText = "Ghi chú";
TextCol.Width = 300;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 6);
TextCol.MappingName = "mavp";
TextCol.HeaderText = "";
TextCol.Width = 0;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 7);
TextCol.MappingName = "ngoaihd";
TextCol.HeaderText = "";
TextCol.Width = 0;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol1;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
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.RowHeaderWidth = 10;
ts.MappingName = ds.Tables[0].TableName;
ts.AllowSorting = false;
TextCol1 = new DataGridColoredTextBoxColumn(de, 0);
TextCol1.MappingName = "ma";
TextCol1.HeaderText = "ma";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 1);
TextCol1.MappingName = "stt";
TextCol1.HeaderText = "STT";
TextCol1.Width = 24;
TextCol1.ReadOnly = true;
TextCol1.Alignment = HorizontalAlignment.Center;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 2);
TextCol1.MappingName = "ten";
TextCol1.HeaderText = "Tên thiết bị";
TextCol1.Width = 230;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 3);
TextCol1.MappingName = "C01";
TextCol1.HeaderText = "C01";
TextCol1.Width = 70;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 4);
TextCol1.MappingName = "C02";
TextCol1.HeaderText = "C02";
TextCol1.Width = 70;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 5);
TextCol1.MappingName = "C03";
TextCol1.HeaderText = "C03";
TextCol1.Width = 70;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 6);
TextCol1.MappingName = "C04";
TextCol1.HeaderText = "C04";
TextCol1.Width = 70;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 7);
TextCol1.MappingName = "C05";
TextCol1.HeaderText = "C05";
TextCol1.Width = 70;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 8);
TextCol1.MappingName = "C06";
TextCol1.HeaderText = "C06";
TextCol1.Width = 70;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 9);
TextCol1.MappingName = "C07";
TextCol1.HeaderText = "C07";
TextCol1.Width = 70;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = dsxml.Tables[0].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.AllowSorting = false;
ts.ReadOnly = false;
ts.RowHeaderWidth = 5;
TextCol = new DataGridColoredTextBoxColumn(de, 0);
TextCol.MappingName = "id";
TextCol.HeaderText = "";
TextCol.Width = 0;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 1);
TextCol.MappingName = "ten";
TextCol.HeaderText = "Tên thuốc - hàm lượng";
TextCol.Width = 200;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 2);
TextCol.MappingName = "dang";
TextCol.HeaderText = "ĐVT";
TextCol.Width = 40;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 3);
TextCol.MappingName = "kho";
TextCol.HeaderText = "Kho";
TextCol.Width = 100;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "losx";
TextCol.HeaderText = "Lô";
TextCol.Width = 70;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 5);
TextCol.MappingName = "handung";
TextCol.HeaderText = "Date";
TextCol.Width = 35;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 6);
TextCol.MappingName = "soluong";
TextCol.HeaderText = "SL";
TextCol.Width = 40;
TextCol.Format = "###,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 6);
TextCol.MappingName = "giamua";
TextCol.HeaderText = "Đơn giá";
TextCol.Width = 60;
TextCol.Format = "###,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 7);
TextCol.MappingName = "sotien";
TextCol.HeaderText = "Số tiền";
TextCol.Width = 80;
TextCol.Format = "###,###,###,###.##";
TextCol.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol1;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
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.RowHeaderWidth = 10;
ts.MappingName = ds.Tables[0].TableName;
ts.AllowSorting = false;
TextCol1 = new DataGridColoredTextBoxColumn(de, 0);
TextCol1.MappingName = "ma";
TextCol1.HeaderText = "ma";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 1);
TextCol1.MappingName = "stt";
TextCol1.HeaderText = "STT";
TextCol1.Width = 24;
TextCol1.ReadOnly = true;
TextCol1.Alignment = HorizontalAlignment.Center;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 2);
TextCol1.MappingName = "ten";
TextCol1.HeaderText = "Cơ sở, trạm y tế thuộc TTYT huyện";
TextCol1.Width = 190;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 3);
TextCol1.MappingName = "C01";
TextCol1.HeaderText = "C01";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 4);
TextCol1.MappingName = "C02";
TextCol1.HeaderText = "C02";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 5);
TextCol1.MappingName = "C03";
TextCol1.HeaderText = "C03";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 6);
TextCol1.MappingName = "C04";
TextCol1.HeaderText = "C04";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 7);
TextCol1.MappingName = "C05";
TextCol1.HeaderText = "C05";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 8);
TextCol1.MappingName = "C06";
TextCol1.HeaderText = "C06";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 9);
TextCol1.MappingName = "C07";
TextCol1.HeaderText = "C07";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 10);
TextCol1.MappingName = "C08";
TextCol1.HeaderText = "C08";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 11);
TextCol1.MappingName = "C09";
TextCol1.HeaderText = "C09";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 12);
TextCol1.MappingName = "C10";
TextCol1.HeaderText = "C10";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 13);
TextCol1.MappingName = "C11";
TextCol1.HeaderText = "C11";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 14);
TextCol1.MappingName = "C12";
TextCol1.HeaderText = "C12";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 15);
TextCol1.MappingName = "C13";
TextCol1.HeaderText = "C13";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 16);
TextCol1.MappingName = "C14";
TextCol1.HeaderText = "C14";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 17);
TextCol1.MappingName = "C15";
TextCol1.HeaderText = "C15";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 18);
TextCol1.MappingName = "C16";
TextCol1.HeaderText = "C16";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 19);
TextCol1.MappingName = "C17";
TextCol1.HeaderText = "C17";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 20);
TextCol1.MappingName = "C18";
TextCol1.HeaderText = "C18";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 21);
TextCol1.MappingName = "C19";
TextCol1.HeaderText = "C19";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 22);
TextCol1.MappingName = "C20";
TextCol1.HeaderText = "C20";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 23);
TextCol1.MappingName = "C21";
TextCol1.HeaderText = "C22";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 24);
TextCol1.MappingName = "C22";
TextCol1.HeaderText = "C22";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 25);
TextCol1.MappingName = "C23";
TextCol1.HeaderText = "C23";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 26);
TextCol1.MappingName = "C24";
TextCol1.HeaderText = "C24";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 27);
TextCol1.MappingName = "C25";
TextCol1.HeaderText = "C25";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 28);
TextCol1.MappingName = "C26";
TextCol1.HeaderText = "C26";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 29);
TextCol1.MappingName = "C27";
TextCol1.HeaderText = "C27";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 30);
TextCol1.MappingName = "C28";
TextCol1.HeaderText = "C28";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 31);
TextCol1.MappingName = "C29";
TextCol1.HeaderText = "C29";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 32);
TextCol1.MappingName = "C30";
TextCol1.HeaderText = "C30";
TextCol1.Width = 39;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
}
private void AddGridTableStyle()
{
DataGridColoredTextBoxColumn TextCol1;
delegateGetColorRowCol de = new delegateGetColorRowCol(MyGetColorRowCol);
DataGridTableStyle ts = new DataGridTableStyle();
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.RowHeaderWidth = 10;
ts.MappingName = ds.Tables[0].TableName;
ts.AllowSorting = false;
TextCol1 = new DataGridColoredTextBoxColumn(de, 0);
TextCol1.MappingName = "ma";
TextCol1.HeaderText = "STT";
TextCol1.Width = 24;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
// TextCol1=new DataGridColoredTextBoxColumn(de, 1);
// TextCol1.MappingName = "ma";
// TextCol1.HeaderText = "STT";
// TextCol1.Width = 24;
// TextCol1.ReadOnly=true;
// TextCol1.Alignment=HorizontalAlignment.Center;
// ts.GridColumnStyles.Add(TextCol1);
// dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 1);
TextCol1.MappingName = "ten";
TextCol1.HeaderText = "Tên đề tài";
TextCol1.Width = 450;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 2);
TextCol1.MappingName = "C01";
TextCol1.HeaderText = "Kinh phí (1000đ)";
TextCol1.Width = 85;
TextCol1.Format = "# ### ### ###.##";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 3);
TextCol1.MappingName = "C02";
TextCol1.HeaderText = "Cấp nhà nước";
TextCol1.Width = 75;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 4);
TextCol1.MappingName = "C03";
TextCol1.HeaderText = "Cấp bộ";
TextCol1.Width = 60;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 5);
TextCol1.MappingName = "C04";
TextCol1.HeaderText = "Cấp cơ sở";
TextCol1.Width = 60;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
}
