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