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 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()
{
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 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);
}
//��ʼ����ͷ����ʾ��Ϣ
public bool iniDataGrid(DataGrid dataGrid1,int iPos)
{
try
{
this.iniDGDataSource(dataGrid1);
// Create a table style that will hold the new column style
// that we set and also tie it to our customer's table from our DB
DataGridTableStyle tableStyle = new DataGridTableStyle();
DataTable dt=(DataTable)dataGrid1.DataSource;
tableStyle.MappingName =dt.TableName;
DataTable dtGprsData=null;
ArrayList alColsCap=null;
//�����ʽ��ʼ��
if(getGprsData(ref dtGprsData,ref alColsCap,iPos)==false)
{
return false;
}
// since the dataset has things like field name and number of columns,
// we will use those to create new columnstyles for the columns in our DB table
int numCols = dtGprsData.Columns.Count;
DataGridColoredTextBoxColumn aColumnTextColumn ;
delegateGetColorRowCol d = new delegateGetColorRowCol(MyGetColorRowCol);
int[] iColWidths=null;
getColWidths(ref iColWidths);
for(int i = 0; i < numCols; i++)
{
aColumnTextColumn = new DataGridColoredTextBoxColumn(d, i,dtGprsData.Columns[i].ColumnName);
aColumnTextColumn.HeaderText = alColsCap[i].ToString();
aColumnTextColumn.Width=iColWidths[i]-2;
aColumnTextColumn.MappingName = dtGprsData.Columns[i].ColumnName;
tableStyle.GridColumnStyles.Add(aColumnTextColumn);
}
// make the dataGrid use our new tablestyle and bind it to our table
dataGrid1.TableStyles.Clear();
tableStyle.AllowSorting=false;
//tableStyle.
dataGrid1.AllowSorting=false;
dataGrid1.TableStyles.Add(tableStyle);
DataRow dr=dt.NewRow();
for(int i=0;i<dt.Columns.Count;i++)
{
dr[i]="";
}
dt.Rows.Add(dr);
//tableStyle.RowHeadersVisible=false;
dataGrid1.DataSource = dt;
return true;
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
return 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 = ds.Tables[0].TableName;
ts.AllowSorting = false;
TextCol1 = new DataGridColoredTextBoxColumn(de, 0);
TextCol1.MappingName = "maql";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 1);
TextCol1.MappingName = "mabn";
TextCol1.HeaderText = "Mã BN";
TextCol1.Width = 60;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 2);
TextCol1.MappingName = "hoten";
TextCol1.HeaderText = "Họ tên";
TextCol1.Width = 180;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 3);
TextCol1.MappingName = "namsinh";
TextCol1.HeaderText = "NS";
TextCol1.Width = 40;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 4);
TextCol1.MappingName = "doituong";
TextCol1.HeaderText = "Đối tượng";
TextCol1.Width = 100;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 5);
TextCol1.MappingName = "sothe";
TextCol1.HeaderText = "Số thẻ";
TextCol1.Width = 100;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 6);
TextCol1.MappingName = "tenkp";
TextCol1.HeaderText = "Khám";
TextCol1.Width = 130;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 7);
TextCol1.MappingName = "done";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 8);
TextCol1.MappingName = "sovaovien";
TextCol1.HeaderText = "Số khám";
TextCol1.Width = 60;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 9);
TextCol1.MappingName = "mavaovien";
TextCol1.HeaderText = "";
TextCol1.Width = 0;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
}
private bool DesignTableStyle(ref string strErrMsg)
{
try
{
string m_strMaskCols = "", m_strShowCols = "";
dgTabSt=new DataGridTableStyle();
dgTabSt.MappingName=dtSource.TableName;
dgTabSt.PreferredRowHeight=15;
////**** If the Default design is false then setting Colors for that Grid
dgTabSt.HeaderBackColor=System.Drawing.Color.Lavender;
dgTabSt.HeaderForeColor=System.Drawing.Color.Navy;
dgTabSt.GridLineColor=System.Drawing.Color.Silver;
for(int i=0; i < dtSource.Columns.Count; i++)
{
int local0 = 0;
if(CheckComboBoxColumn(i))
{
DataGridComboBoxColumn dgCBCol = new DataGridComboBoxColumn(i);
dgCBCol.MappingName = strColNames[i];
dgCBCol.HeaderText = strHeadings[i];
dgCBCol.Alignment = HorizontalAlignment.Center; //Added by Nilanjan 14/05/07
dgCBCol.ColumnComboBox.DataSource = GetComboValue(i);
arlEnableColumns = new ArrayList();
arlEnableRows = new ArrayList();
if(CheckReadOnlyColumn(i))
{
dgCBCol.ReadOnly = true;
dgCBCol.TextBox.TabStop = false;
}
dgCBCol.CheckCellEnabled += new EnableCellEventHandler(SetEnableValues);
//changing color
dgCBCol.CheckCellColor +=new EnableCellColorEventHandler(dgTBCol_CheckCellColor);
dgCBCol.TextChangedCombo += new EventHandler(TextBox_TextChanged);
//dgCBCol.TextBox.TextChanged+=new EventHandler(TextBox_TextChanged); //added By Nilanjan 14/05/07
dgTabSt.GridColumnStyles.Add(dgCBCol);
dgCBCol.Dispose();
}
else if(CheckDateTimeColumn(i))
{
DataGridDateTimePicker dgDTPCol = new DataGridDateTimePicker(i);
dgDTPCol.MappingName = strColNames[i];
dgDTPCol.HeaderText = strHeadings[i];
if(CheckReadOnlyColumn(i))
{
dgDTPCol.ReadOnly = true;
dgDTPCol.TextBox .TabStop = false;
}
dgDTPCol.CheckCellEnabled += new EnableCellEventHandler(SetEnableValues);
//changing color
dgDTPCol.CheckCellColor +=new EnableCellColorEventHandler(dgTBCol_CheckCellColor);
dgDTPCol.TextChangedDTP +=new EventHandler(TextBox_TextChanged);
dgTabSt.GridColumnStyles.Add(dgDTPCol);
dgDTPCol.Dispose();
}
else if(CheckButtonColumn(i))
{
DataGridButtonColumn dgBtnCol = new DataGridButtonColumn(i);
dgBtnCol.MappingName = strColNames[i];
dgBtnCol.HeaderText = strHeadings[i];
dgTabSt.GridColumnStyles.Add(dgBtnCol);
dgBtnCol.Dispose();
}
else
{
MyGridTextBoxColumn dgTBCol=new MyGridTextBoxColumn(i);
dgTBCol.MappingName=strColNames[i];
dgTBCol.HeaderText=strHeadings[i];
if(_boolPrivScreen)
{
delegateGetColorRowCol d = new delegateGetColorRowCol(MyGetColorRowCol);
dgTBCol.GetColorRowCol = d;
}
if(CheckReadOnlyColumn(i))
{
dgTBCol.ReadOnly = true;
dgTBCol.TextBox.TabStop = false;
}
if(CheckRightAlignColumn(i))
dgTBCol.Alignment = HorizontalAlignment.Right;
if(CheckNumericColumn(i,ref local0))
{
dgTBCol.TextType = TxtType(arlNumericColumnType[local0].ToString());
dgTBCol.IntPrecision = Convert.ToInt32(arlNumericColIntSize[local0].ToString());
dgTBCol.DecPrecision = Convert.ToInt32(arlNumericColFloatSize[local0].ToString());
dgTBCol.IsCurrency = Convert.ToBoolean (arlNumericColCurrency[local0].ToString());
}
else
{
dgTBCol.TextType = clsTxtBox.TypeEnum.String;
dgTBCol.TextBox.MaxLength = getMaxStrLength(i);
}
dgTBCol.CheckCellEnabled += new EnableCellEventHandler(SetEnableValues);
//changing color
dgTBCol.CheckCellColor +=new EnableCellColorEventHandler(dgTBCol_CheckCellColor);
dgTBCol .KeyTextBox.TextChanged +=new EventHandler(TextBox_TextChanged);
dgTabSt.GridColumnStyles.Add(dgTBCol);
dgTBCol.Dispose();
}
}
for(int i=0; i < dtSource.Columns.Count; i++)
{
if(strColNames[i].Length >= 4)
{
if(strColNames[i].Substring(0,4).ToUpper()=="MASK")
{
m_strMaskCols += i.ToString() + ",";
dgTabSt.GridColumnStyles[i].Width=0;
}
else
{
m_strShowCols += i.ToString() + ",";
}
}
dgTabSt.GridColumnStyles[i].NullText = "";
}
#region changing for ColSizing
for(int i=0;i<listOfColumnsForResizing .Count ;i++)
{
colWidth obj = (colWidth)listOfColumnsForResizing[i];
dgTabSt.GridColumnStyles[obj.ColumnIndex].Width=obj.ColumnWidth;
}
#endregion
if(m_strMaskCols.Trim() != "")
{
m_strMaskCols = m_strMaskCols.Substring(0,m_strMaskCols.Length-1);
string[] local0 = m_strMaskCols.Split(',');
intHiddenCols = new int[local0.Length];
for(int i=0;i<local0.Length;i++)
intHiddenCols[i] = Convert.ToInt32(local0[i]);
Array.Sort(intHiddenCols);
}
if(m_strShowCols.Trim() != "")
{
m_strShowCols = m_strShowCols.Substring(0,m_strShowCols.Length-1);
string[] local0 = m_strShowCols.Split(',');
intShowCols = new int[local0.Length];
for(int i=0;i<local0.Length;i++)
intShowCols[i] = Convert.ToInt32(local0[i]);
Array.Sort(intShowCols);
}
this.TableStyles.Clear();
this.TableStyles.Add(dgTabSt);
this.SetDataBinding( dtSource, "" ); //INDRANIL
this.Refresh();
intLoadRowCount = dtSource.Rows.Count;
intTotalRowCount = intLoadRowCount;
dgTxt=new MyGridTextBoxColumn[dtSource.Columns.Count];
DataGridTxtBox=new KeyTrapTextBox[dtSource.Columns.Count];
dgComboBox = new DataGridComboBoxColumn[intNumComboCols];
dgDateTimePicker = new DataGridDateTimePicker[intNumDateTimeCols];
dgButton = new DataGridButtonColumn[intNumButtonCols];
int m_intComboCount = 0, m_intDTPCount = 0, m_intBtnCount = 0;
for(int i=0;i<dtSource.Columns.Count;i++)
{
if(CheckComboBoxColumn(i))
{
dgComboBox[m_intComboCount] =(DataGridComboBoxColumn)this.TableStyles[0].GridColumnStyles[i];
++m_intComboCount;
}
else if(CheckDateTimeColumn(i))
{
dgDateTimePicker[m_intDTPCount] = (DataGridDateTimePicker)this.TableStyles[0].GridColumnStyles[i];
++m_intDTPCount;
}
else if(CheckButtonColumn(i))
{
dgButton[m_intBtnCount] = (DataGridButtonColumn) this.TableStyles[0].GridColumnStyles[i];
++m_intBtnCount;
}
else
{
dgTxt[i]=(MyGridTextBoxColumn)this.TableStyles[0].GridColumnStyles[i];
DataGridTxtBox[i]= dgTxt[i].KeyTextBox;
}
}
dvSource = ((DataTable)this.DataSource).DefaultView;
dvSource.ListChanged += new ListChangedEventHandler(dvSource_ListChanged);
this.DoubleBuffered = true;
this.Paint += new PaintEventHandler(RowHeaderPaint);
if(this.RowCount > 0)
pointInCell00 = new Point(this.GetCellBounds(0,0).X + 4, this.GetCellBounds(0,0).Y + 4);
this.Scroll += new EventHandler(HorizontalScroll);
//this.AllowSorting = true;
return true;
}
catch(Exception ex)
{
strErrMsg = ex.Source + " - " + ex.Message;
return 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 = 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);
}
//初始化表头与显示信息
public bool iniDataGrid(DataGrid dataGrid1, int iPos)
{
try
{
this.iniDGDataSource(dataGrid1);
// Create a table style that will hold the new column style
// that we set and also tie it to our customer's table from our DB
DataGridTableStyle tableStyle = new DataGridTableStyle();
DataTable dt = (DataTable)dataGrid1.DataSource;
tableStyle.MappingName = dt.TableName;
DataTable dtGprsData = null;
ArrayList alColsCap = null;
//报表格式初始化
if (getGprsData(ref dtGprsData, ref alColsCap, iPos) == false)
{
return(false);
}
// since the dataset has things like field name and number of columns,
// we will use those to create new columnstyles for the columns in our DB table
int numCols = dtGprsData.Columns.Count;
DataGridColoredTextBoxColumn aColumnTextColumn;
delegateGetColorRowCol d = new delegateGetColorRowCol(MyGetColorRowCol);
int[] iColWidths = null;
getColWidths(ref iColWidths);
for (int i = 0; i < numCols; i++)
{
aColumnTextColumn = new DataGridColoredTextBoxColumn(d, i, dtGprsData.Columns[i].ColumnName);
aColumnTextColumn.HeaderText = alColsCap[i].ToString();
aColumnTextColumn.Width = iColWidths[i] - 2;
aColumnTextColumn.MappingName = dtGprsData.Columns[i].ColumnName;
tableStyle.GridColumnStyles.Add(aColumnTextColumn);
}
// make the dataGrid use our new tablestyle and bind it to our table
dataGrid1.TableStyles.Clear();
tableStyle.AllowSorting = false;
//tableStyle.
dataGrid1.AllowSorting = false;
dataGrid1.TableStyles.Add(tableStyle);
DataRow dr = dt.NewRow();
for (int i = 0; i < dt.Columns.Count; i++)
{
dr[i] = "";
}
dt.Rows.Add(dr);
//tableStyle.RowHeadersVisible=false;
dataGrid1.DataSource = dt;
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
}
public DataGridColoredTextBoxColumn(delegateGetColorRowCol getcolorRowCol, int column, string strColName)
{
_getColorRowCol = getcolorRowCol;
_column = column;
_colName = strColName;
}
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;
ts.AllowSorting = false;
TextCol1 = new DataGridColoredTextBoxColumn(de, 0);
TextCol1.MappingName = "ma";
TextCol1.HeaderText = "Mã số";
TextCol1.Width = 50;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 1);
TextCol1.MappingName = "ten";
TextCol1.HeaderText = "Tên thuốc - hàm lượng";
TextCol1.Width = (d.bQuanlynguon(i_nhom))?128:208;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 2);
TextCol1.MappingName = "tenhc";
TextCol1.HeaderText = "Hoạt chất";
TextCol1.Width = 0;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 3);
TextCol1.MappingName = "dang";
TextCol1.HeaderText = "ĐVT";
TextCol1.Width = 50;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 4);
TextCol1.MappingName = "tennguon";
TextCol1.HeaderText = "Nguồn";
TextCol1.Width = (d.bQuanlynguon(i_nhom))?80:0;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 5);
TextCol1.MappingName = "slyeucau";
TextCol1.HeaderText = "Yêu cầu";
TextCol1.Width = 60;
TextCol1.Format = "# ### ###.##";
TextCol1.ReadOnly = true;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 6);
TextCol1.MappingName = "soluong";
TextCol1.HeaderText = "Duyệt cấp";
TextCol1.Width = 60;
TextCol1.Format = "# ### ###.##";
TextCol1.ReadOnly = (bSuasoluong_khiduyetkhocap) ? false : true;
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.Format = "# ### ###.##";
TextCol1.ReadOnly = true;
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 8);
TextCol1.MappingName = "sltoithieu";
TextCol1.HeaderText = "Tồn tối thiểu";
TextCol1.Width = 72;
TextCol1.Format = "# ### ##0.00";
TextCol1.ReadOnly = true;
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 = "tenkp";
TextCol.HeaderText = "Khoa";
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 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ác xét nghiệm";
TextCol1.Width = 420;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 3);
TextCol1.MappingName = "donvi";
TextCol1.HeaderText = "Đơn vị";
TextCol1.Width = 100;
TextCol1.ReadOnly = true;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 4);
TextCol1.MappingName = "C01";
TextCol1.HeaderText = "Tổng số";
TextCol1.Width = 100;
TextCol1.Format = "# ### ###";
TextCol1.Alignment = HorizontalAlignment.Right;
ts.GridColumnStyles.Add(TextCol1);
dataGrid1.TableStyles.Add(ts);
TextCol1 = new DataGridColoredTextBoxColumn(de, 5);
TextCol1.MappingName = "C02";
TextCol1.HeaderText = "Trong đó nội trú";
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 = 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;
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 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);
}
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);
}
}
public DataGridColoredTextBoxColumn(delegateGetColorRowCol getcolorRowCol, int column)
{
_getColorRowCol = getcolorRowCol;
_column = column;
}
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);
}
public DataGridColoredTextBoxColumn(delegateGetColorRowCol getcolorRowCol, int column,string strColName)
{
_getColorRowCol = getcolorRowCol;
_column = column;
_colName=strColName;
}
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 = 185;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "nguoithuhoi";
TextCol.HeaderText = "Người thu hồi";
TextCol.Width = 120;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 5);
TextCol.MappingName = "thuhoiluc";
TextCol.HeaderText = "Thu hồi lúc";
TextCol.Width = 120;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 6);
TextCol.MappingName = "mmyy";
TextCol.HeaderText = "MMYY";
TextCol.Width = 0;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
TextCol = new DataGridColoredTextBoxColumn(de, 4);
TextCol.MappingName = "loai";
TextCol.HeaderText = "";
TextCol.Width = 0;
ts.GridColumnStyles.Add(TextCol);
dataGrid1.TableStyles.Add(ts);
}
