private void DataGridResize(ref DataGrid grd, int iColumnCount)
{
grd.BeginInit();
foreach (DataGridTableStyle grdStyle in grd.TableStyles)
{
try
{
int width = grd.Width - 56; //53;//real is 56
GridColumnStylesCollection cols = grdStyle.GridColumnStyles;
int oldwidth = 0;
for (byte i = 0; i < iColumnCount; i++)
{
oldwidth = oldwidth + cols[i].Width; // col.Width;
}
if (oldwidth == 0)
{
return;
}
int count = grdStyle.GridColumnStyles.Count;
double scale = 1.0 * width / oldwidth;
foreach (DataGridColumnStyle col in cols)
{
col.Width = (int)(col.Width * scale);
}
}
catch (Exception ex)
{
log.Error(ex.Message, ex);
}
}
grd.EndInit();
}
private void InitDataGridColumnHeader()
{
DataGridTableStyle dataGridStyle = null;
dataGridStyle = new DataGridTableStyle();
this.dataGrid1.DataSource = createDataTable();
this.dataGrid1.TableStyles.Clear();
this.dataGrid1.TableStyles.Add(dataGridStyle);
GridColumnStylesCollection dataGridColStyle = this.dataGrid1.TableStyles[0].GridColumnStyles;
DataGridTextBoxColumn aaa = new DataGridTextBoxColumn();
DataGridTextBoxColumn Text = new DataGridTextBoxColumn();
dataGridColStyle[0].Width = 44;
dataGridColStyle[1].Width = 40;
dataGridColStyle[2].Width = 40;
dataGridColStyle[3].Width = 40;
dataGridColStyle[4].Width = 40;
dataGridColStyle[0].HeaderText = "";
dataGridColStyle[1].HeaderText = "";
dataGridColStyle[2].HeaderText = "";
dataGridColStyle[3].HeaderText = "";
dataGridColStyle[4].HeaderText = "";
}
/// <summary>
/// 过账创建空table
/// </summary>
/// <returns></returns>
public void Grid3DataTable()
{
DataTable table = new DataTable();
table.Columns.Add("单据编号");
table.Columns.Add("单据行号");
table.Columns.Add("物料编码");
table.Columns.Add("物料名称");
table.Columns.Add("数量");
table.Columns.Add("从仓库");
table.Columns.Add("从仓库名称");
table.Columns.Add("从库位");
table.Columns.Add("到仓库");
table.Columns.Add("到仓库名称");
table.Columns.Add("到库位");
table.Columns.Add("批次");
table.Columns.Add("从库位标识");
table.Columns.Add("到库位标识");
table.Columns.Add("转储数量");
table.Columns.Add("制单人");
DataGridTableStyle mydata2 = new DataGridTableStyle();
GridColumnStylesCollection mycol2 = null;
DataGrid2.DataSource = table;
mydata2.MappingName = table.TableName;
DataGrid2.TableStyles.Clear();
DataGrid2.TableStyles.Add(mydata2);
mycol2 = DataGrid2.TableStyles[0].GridColumnStyles;
mycol2["单据编号"].Width = 0;
mycol2["单据行号"].Width = 0;
}
public void TestAdd()
{
DataGridTableStyle ts = new DataGridTableStyle();
GridColumnStylesCollection sc = ts.GridColumnStyles;
sc.CollectionChanged += new CollectionChangeEventHandler(OnCollectionEventHandler);
// Add single
ResetEventData();
DataGridTextBoxColumn col1 = new DataGridTextBoxColumn();
col1.MappingName = "Column1";
sc.Add(col1);
Assert.AreEqual(true, eventhandled);
Assert.AreEqual(col1, Element);
Assert.AreEqual(CollectionChangeAction.Add, Action);
// Add multiple
ResetEventData();
DataGridTextBoxColumn elem1 = new DataGridTextBoxColumn();
DataGridTextBoxColumn elem2 = new DataGridTextBoxColumn();
sc.AddRange(new DataGridTextBoxColumn [] { elem1, elem2 });
Assert.AreEqual(true, eventhandled, "A1");
Assert.AreEqual(CollectionChangeAction.Add, Action, "A2");
Assert.AreEqual(elem2, Element, "A3");
}
public void TestIndexContains()
{
DataGridTableStyle ts = new DataGridTableStyle();
GridColumnStylesCollection sc = ts.GridColumnStyles;
sc.CollectionChanged += new CollectionChangeEventHandler(OnCollectionEventHandler);
// Add single
DataGridTextBoxColumn col1 = new DataGridTextBoxColumn();
col1.MappingName = "Column1";
sc.Add(col1);
DataGridTextBoxColumn col2 = new DataGridTextBoxColumn();
col2.MappingName = "Column2";
sc.Add(col2);
DataGridTextBoxColumn col3 = new DataGridTextBoxColumn();
col3.MappingName = "Column3";
sc.Add(col3);
ResetEventData();
IList ilist = (IList)sc;
Assert.AreEqual(1, ilist.IndexOf(col2), "A1");
Assert.AreEqual(false, sc.Contains("nothing"), "A2");
Assert.AreEqual(true, sc.Contains(col3), "A3");
}
public void DumpGridColumnStylesCollection(GridColumnStylesCollection ts)
{
Console.WriteLine("IsSynchronized {0} ", ts.IsSynchronized);
Console.WriteLine("SyncRoot {0} ", ts.SyncRoot);
//Console.WriteLine ("IsFixedSize {0} ", ts.IsFixedSize);
Console.WriteLine("IsReadOnly {0} ", ts.IsReadOnly);
}
private void cmbSaleNo_SelectedValueChanged(object sender, EventArgs e)
{
try
{
if (cmbSaleNo.Text != "")
{
//根据销售订单检索销售订单明细行 AND U_XSQty < Quantity AND LineStatus ='O' AND U_XSLineStatus = 'O'
string sql = string.Format("SELECT ItemCode as 物料编码, Dscription as 物料名称,Quantity as 数量,(Quantity-isnull(U_XSQty,0)) as 剩余未清数量,LineNum as 行号,WhsCode as 仓库 FROM {0} ..RDR1 WHERE DocEntry = @docentry AND OpenQty != 0 AND isnull(U_XSQty,'0') < Quantity AND LineStatus ='O' AND U_XSLineStatus = 'O' and U_ZCLineStatus='O'", ConnModel.commonDB);
SqlParameter[] ps = new SqlParameter[] { new SqlParameter("@docentry", cmbSaleNo.SelectedValue.ToString()) };
tbl = SqlHelper.GetDataTable(sql, CommandType.Text, ps);
//设置datagrid的列宽
DataGridTableStyle mydata = new DataGridTableStyle();
GridColumnStylesCollection mycol = null;
DGsale.DataSource = tbl;
mydata.MappingName = tbl.TableName;
DGsale.TableStyles.Clear();
DGsale.TableStyles.Add(mydata);
mycol = DGsale.TableStyles[0].GridColumnStyles;
mycol[0].Width = 80;
mycol[1].Width = 80;
}
txtTraceNo.Text = "";
tb_Quantity.Text = "";
}
catch (Exception ex)
{
MessageBox.Show(ex.StackTrace);
}
}
public GridColumnStylesCollectionTests()
{
DataGridTableStyle ts = new DataGridTableStyle();
GridColumnStylesCollection sc = ts.GridColumnStyles;
Console.WriteLine("GridColumnStylesCollection default --- ");
DumpGridColumnStylesCollection(sc);
}
// <Snippet1>
private void ResetButton_Click(object sender, EventArgs e)
{
DataGridTableStyle myTableStyle = myDataGrid.TableStyles[0];
GridColumnStylesCollection myColumns = myTableStyle.GridColumnStyles;
// Reset the property descriptor of column styles collection.
myColumns.ResetPropertyDescriptors();
}
public void GridColumnStylesCollection_Add_DataGridColumnStyle_Success()
{
var tableStyle = new DataGridTableStyle();
GridColumnStylesCollection collection = tableStyle.GridColumnStyles;
var style = new SubDataGridColumnStyle();
Assert.Equal(0, collection.Add(style));
Assert.Same(style, Assert.Single(collection));
Assert.Same(tableStyle, style.DataGridTableStyle);
}
public void FixupLastColumn()
{
if (grid.DataSource == null)
{
return;
}
if (tableStyle == null)
{
return;
}
GridColumnStylesCollection colStyles = tableStyle.GridColumnStyles;
if (colStyles.Count == 0)
{
return;
}
// Okay, we've got the data to do the sizing
inManualSize = true;
//get the target width
int width = GetGridWidth();
if (IsScrollBarVisible(grid))
{
width -= SystemInformation.VerticalScrollBarWidth;
}
int nCols = tableStyle.GridColumnStyles.Count;
int lastColIndex = nCols - 1;
int totalWidth = width;
for (int i = 0; i < lastColIndex; ++i)
{
totalWidth -= colStyles[i].Width;
}
int minSizeLastCol = -1;
if (null != minimumWidths)
{
minSizeLastCol = minimumWidths[lastColIndex];
}
// Last column always gets remainder of space
if (totalWidth > minSizeLastCol)
{
colStyles[lastColIndex].Width = totalWidth;
}
inManualSize = false;
}
public void TestDefaultValues()
{
DataGridTableStyle ts = new DataGridTableStyle();
GridColumnStylesCollection sc = ts.GridColumnStyles;
Assert.AreEqual(false, sc.IsSynchronized, "IsSynchronized property");
Assert.AreEqual(0, sc.Count, "Count");
Assert.AreEqual(sc, sc.SyncRoot, "SyncRoot property");
Assert.AreEqual(false, ((IList)sc).IsFixedSize, "IsFixedSize property");
Assert.AreEqual(false, sc.IsReadOnly, "IsReadOnly property");
}
// </Snippet2>
// <Snippet3>
private void PrintColumnInformationUsingIndex()
{
myLabel.Text = "Table Styles info: No of Styles " + myDataGrid.TableStyles.Count;
foreach (DataGridTableStyle myTableStyle in myDataGrid.TableStyles)
{
myLabel.Text += "\nTable Name : " + myTableStyle.MappingName;
GridColumnStylesCollection myColumns = myTableStyle.GridColumnStyles;
for (int index = 0; index < myColumns.Count; index++)
{
myLabel.Text += "\nMapping Name: " + myColumns[index].MappingName;
}
}
}
// <Snippet1>
private void Clear_Clicked(object sender, System.EventArgs e)
{
// TablesAlreadyAdded set to false so that table styles can be added again.
TablesAlreadyAdded = false;
myLabel.Text = "All Table Styles Cleared.";
// Clear all the column styles and also table style for the grid.
foreach (DataGridTableStyle myTableStyle in myDataGrid.TableStyles)
{
GridColumnStylesCollection myColumns = myTableStyle.GridColumnStyles;
myColumns.Clear();
}
myDataGrid.TableStyles.Clear();
}
public void fillDataGrid()
{
try
{
DataSet dt = consulta(select);
DataGridTableStyle tableStyle = new DataGridTableStyle();
tableStyle.MappingName = dt.Tables[0].TableName;
GridColumnStylesCollection columnStyles = tableStyle.GridColumnStyles;
DataGridTextBoxColumn columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "Codigo";
columnStyle.HeaderText = "CODIGO";
columnStyle.Width = 89;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "Ubicacion";
columnStyle.HeaderText = "UBICACIÓN";
columnStyle.Width = 89;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "Piezas";
columnStyle.HeaderText = "TAG";
columnStyle.Width = 38;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "EPC";
columnStyle.HeaderText = "EPC";
columnStyle.Width = 38;
columnStyles.Add(columnStyle);
dataGrid1.TableStyles.Clear();//se agrego para limpiar antes de agregar
GridTableStylesCollection tableStyles = dataGrid1.TableStyles;
tableStyles.Add(tableStyle);
dataGrid1.PreferredRowHeight = 16;
dataGrid1.RowHeadersVisible = false;
//------------------------------
dataGrid1.DataSource = dt.Tables[0];
//------------------------------
}
catch (Exception e)
{
//MessageBox.Show(e.Message);
MessageBox.Show("Hubo un asunto con la conexion. \nFavor de Reintentar en unos momentos", "Advertencia");
}
}
/// <summary>
/// 收货单 - 回车
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtdocEntry_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 13)
{
#region 置空
DataGrid1.DataSource = null;
ClearControl();
#endregion
string docEntry = txtdocEntry.Text.Trim();
if (System.Text.RegularExpressions.Regex.IsMatch(docEntry, @"^[1-9]\d*$"))
{
if (!string.IsNullOrEmpty(docEntry))
{
#region 订单页
//根据输入的质检单号，查询
string sql = " SELECT Row_Number() OVER ( ORDER BY Id )-1 '#', CardCode 供应商编码,CardName 供应商名称,DocEntry 采购订单,LineNum 采购订单行号,ZJD 质检单,ZJDHH 质检单行号,ItemCode 物料编码,ItemName 物料名称,ItemBatch 批次,WhsFlag 是否库位,WhsCode 仓库编码,WhsName 仓库名称,AbsEntry 库位标识,BinCode 库位编码,InWhsQty 入库数量 FROM [dbo].[CGRK] WHERE IsImport=1";
DataTable dt1 = SqlHelper.GetDataTable(sql, CommandType.Text);
if (dt1 != null && dt1.Rows.Count > 0)
{
DataGridTableStyle mydata1 = new DataGridTableStyle();
GridColumnStylesCollection mycol1 = null;
DataGrid1.DataSource = dt1;
mydata1.MappingName = dt1.TableName;
DataGrid1.TableStyles.Clear();
DataGrid1.TableStyles.Add(mydata1);
mycol1 = DataGrid1.TableStyles[0].GridColumnStyles;
mycol1["#"].Width = 0;
mycol1["供应商编码"].Width = 0;
mycol1["供应商名称"].Width = 0;
mycol1["采购订单"].Width = 0;
mycol1["采购订单行号"].Width = 0;
mycol1["质检单"].Width = 0;
mycol1["质检单行号"].Width = 0;
mycol1["是否库位"].Width = 0;
tabControl1.SelectedIndex = 1;
txtBarcode.Focus();
}
else
{
MessageBox.Show("当前收货单不存在,请更换收货单", "提示");
}
#endregion
}
}
else
{
MessageBox.Show("输入订单编号不合法!", "错误");
}
}
}
public void fillDataGrid()
{
try
{
DataSet dt = consulta("SELECT idInv, almacen, fecha, cveInv from InvCongelado WHERE usuario = '" + user[4] + "' AND numConteo < 4"); //CAMBIE ESTO PARA QUE LE APAREZCAN AL USUARUI TODOS LOS CONTEOS ASIGNADOS AND status = 0");
DataGridTableStyle tableStyle = new DataGridTableStyle();
tableStyle.MappingName = dt.Tables[0].TableName;
GridColumnStylesCollection columnStyles = tableStyle.GridColumnStyles;
DataGridTextBoxColumn columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "idInv";
columnStyle.HeaderText = "ID";
columnStyle.Width = 30;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "almacen";
columnStyle.HeaderText = "Ubicación";
columnStyle.Width = 50;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "fecha";
columnStyle.HeaderText = "Fecha";
columnStyle.Width = 100;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "cveInv";
columnStyle.HeaderText = "Clave";
columnStyle.Width = 54;
columnStyles.Add(columnStyle);
GridTableStylesCollection tableStyles = dataGrid1.TableStyles;
tableStyles.Add(tableStyle);
dataGrid1.PreferredRowHeight = 16;
dataGrid1.RowHeadersVisible = false;
//------------------------------
dataGrid1.DataSource = dt.Tables[0];
//------------------------------
}
catch (Exception e)
{
//MessageBox.Show(e.Message);
MessageBox.Show("Hubo un asunto con la conexion. \nFavor de Reintentar en unos momentos", "Advertencia");
}
}
private void txtDocEntry_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
#region 置空
DataGrid1.DataSource = null;
DataGrid2.DataSource = null;
Grid3DataTable();
ClearControl();
#endregion
string docEntry = txtDocEntry.Text.Trim();
if (System.Text.RegularExpressions.Regex.IsMatch(docEntry, @"^[1-9]\d*$"))
{
if (!string.IsNullOrEmpty(docEntry))
{
#region 订单页
//根据输入的库存转储请求单号，查询
//string sql = string.Format(@"exec [SAP_KCZC_SelKCZCQQ] '{0}','{1}'", docEntry, ConnModel.commonDB);
string sql = string.Format(@"exec [SAP_NEW_KCZC_LOAD] '{0}'", docEntry);
DataTable dt1 = SqlHelper.GetDataTable(sql, CommandType.Text);
if (dt1 != null && dt1.Rows.Count > 0)
{
DataGridTableStyle mydata1 = new DataGridTableStyle();
GridColumnStylesCollection mycol1 = null;
DataGrid1.DataSource = dt1;
mydata1.MappingName = dt1.TableName;
DataGrid1.TableStyles.Clear();
DataGrid1.TableStyles.Add(mydata1);
mycol1 = DataGrid1.TableStyles[0].GridColumnStyles;
mycol1["单据编号"].Width = 0;
mycol1["单据行号"].Width = 0;
mycol1["#"].Width = 0;
tabControl1.SelectedIndex = 1;
txtBarcode.Focus();
}
else
{
txtDocEntry.Text = "";
MessageBox.Show("当前库存转储请求单不存在,请更换单据", "提示");
}
#endregion
}
}
else
{
txtDocEntry.Text = "";
MessageBox.Show("输入库存转储请求编号不合法!", "错误");
}
}
}
/// <summary>
/// Get Header Title and Index of table of DataGridTableStyle
/// </summary>
/// <param name="view"></param>
/// <param name="cols"></param>
/// <param name="headers"></param>
/// <param name="indexes"></param>
/// <remarks>
/// Author: PhatLT. FPTSS.
/// Created date: 14/02/2011
/// </remarks>
public void GetExportInfo(DataView view, GridColumnStylesCollection cols, ref string[] headers, ref int [] indexes)
{
int count = cols.Count;
headers = new string[count];
indexes = new int[count];
DataTable dt = view.Table;
for (int i = 0; i < count; i++)
{
headers[i] = cols[i].HeaderText;
indexes[i] = GetColumnIndex(dt, cols[i].MappingName);
}
}
public void fillDataGrid()
{
//el que estaba
DataSet listas = consulta("SELECT de.EPC, ca.[Descripción] as Item, de.Piezas "
+ "FROM DetEscuadras de INNER JOIN catArt ca "
+ "ON ca.Clave = de.EPC "
+ "WHERE (de.piezas > 0)");
if (listas == null)
{
return;
}
DataGridTableStyle tableStyle = new DataGridTableStyle();
tableStyle.MappingName = listas.Tables[0].TableName;
GridColumnStylesCollection columnStyles = tableStyle.GridColumnStyles;
DataGridTextBoxColumn columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "EPC";
columnStyle.HeaderText = "EPC";
columnStyle.Width = 80;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "Item";
columnStyle.HeaderText = "Articulo";
columnStyle.Width = 80;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "Piezas";
columnStyle.HeaderText = "Cantidad";
columnStyle.Width = 65;
columnStyles.Add(columnStyle);
GridTableStylesCollection tableStyles = dataGrid1.TableStyles;
tableStyles.Add(tableStyle);
dataGrid1.PreferredRowHeight = 16;
dataGrid1.RowHeadersVisible = false;
//------------------------------
dataGrid1.DataSource = listas.Tables[0];
//------------------------------
}
// </Snippet1>
// <Snippet2>
private void PrintColumnInformationUsingColumnName()
{
myLabel.Text = "Table Styles info: No of Styles " + myDataGrid.TableStyles.Count;
foreach (DataGridTableStyle myTableStyle in myDataGrid.TableStyles)
{
myLabel.Text += "\nTable Name : " + myTableStyle.MappingName;
GridColumnStylesCollection myColumns = myTableStyle.GridColumnStyles;
// 'myTableStyle.GridColumnStyles[index].MappingName' specifies the column came for the table.
for (int index = 0; index < myColumns.Count; index++)
{
myLabel.Text += "\nMapping Name: " +
myColumns[myTableStyle.GridColumnStyles[index].MappingName].MappingName;
}
}
}
/// <summary>
/// 物料明细页签
/// </summary>
/// <param name="docEntry"></param>
private void LoadItemPage(int docEntry)
{
//物料明细 根据（物料编码,仓库）
DataTable tb2 = SqlHelper.GetDataTable(string.Format(" exec {1}..{2} {0},'' ", docEntry, ConnModel.commonDB, currSql), CommandType.Text);
//设置datagrid的列宽
DataGridTableStyle mydata2 = new DataGridTableStyle();
GridColumnStylesCollection mycol2 = null;
DG2.DataSource = tb2;
mydata2.MappingName = tb2.TableName;
DG2.TableStyles.Clear();
DG2.TableStyles.Add(mydata2);
mycol2 = DG2.TableStyles[0].GridColumnStyles;
mycol2[1].Width = 80;
mycol2[2].Width = 80;
}
// <Snippet1>
private void RemoveColumnStyle_Clicked(object sender, EventArgs e)
{
DataGridTableStyle myTableStyle = myDataGrid.TableStyles[0];
// Get the GridColumnStylesCollection of Data Grid.
myColumns = myTableStyle.GridColumnStyles;
int i;
// Remove the CustName ColumnStyle from the data grid.
if (myColumns.Contains("CustName"))
{
DataGridColumnStyle myDataColumnStyle = myColumns["CustName"];
i = myColumns.IndexOf(myDataColumnStyle);
myColumns.RemoveAt(i);
}
}
/// <summary>
/// Handle the data grid that auto resize column width
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <remarks>
/// Author : PhatLT G3
/// Created day : 04/10/2011
/// </remarks>
private static void DataGrid_Resize(object sender, EventArgs e)
{
if (sender == null)
{
return;
}
DataGrid grd = (DataGrid)sender;
// DataGridTableStyle grdStyle = grd.TableStyles[0];
// if(grdStyle == null || grdStyle.GridColumnStyles == null || grdStyle.GridColumnStyles.Count == 0)
// return;
grd.BeginInit();
foreach (DataGridTableStyle grdStyle in grd.TableStyles)
{
int width = grd.Width - 56; //53;//real is 56
GridColumnStylesCollection cols = grdStyle.GridColumnStyles;
//calculate total of col
int oldwidth = 0;
foreach (DataGridColumnStyle col in cols)
{
oldwidth = oldwidth + col.Width;
}
if (oldwidth == 0)
{
return;
}
int count = grdStyle.GridColumnStyles.Count;
double scale = 1.0 * width / oldwidth;
foreach (DataGridColumnStyle col in cols)
{
if (col.Width != 0)
{
col.Width = (int)(col.Width * scale);
}
}
}
grd.EndInit();
}
public Form1()
{
InitializeComponent();
dataTable.Columns.Add("MortgageTypeName", typeof(String));
dataTable.Columns.Add("FixedRate", typeof(Int32));
dataTable.Columns.Add("ARMRate", typeof(Int32));
DataRow dr = dataTable.NewRow();
dr["MortgageTypeName"] = "Fixed";
dr["FixedRate"] = 5;
dr["ARMRate"] = 10;
dataTable.Rows.Add(dr);
DataGridTableStyle tableStyle = new DataGridTableStyle();
tableStyle.MappingName = dataTable.TableName;
GridColumnStylesCollection columnStyles = tableStyle.GridColumnStyles;
DataGridTextBoxColumn columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "MortgageTypeName";
columnStyle.HeaderText = "Years";
columnStyle.Width = 58;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "FixedRate";
columnStyle.HeaderText = "Fixed(%)";
columnStyle.Width = 64;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "ARMRate";
columnStyle.HeaderText = "ARM(%)";
columnStyle.Width = 64;
columnStyles.Add(columnStyle);
GridTableStylesCollection tableStyles = dgRates.TableStyles;
tableStyles.Add(tableStyle); dgRates.PreferredRowHeight = 16;
dgRates.RowHeadersVisible = false;
dgRates.DataSource = dataTable;
}
/// <summary>
/// 订单信息页签
/// </summary>
/// <param name="docEntry"></param>
private void LoadOrdrPage(int docEntry)
{
// 订单信息 根据销售订单检索销售订单明细行 AND U_XSQty < Quantity AND LineStatus ='O' AND U_XSLineStatus = 'O'
DataTable tbl = SqlHelper.GetDataTable(string.Format(@"SELECT A.ItemCode as 物料编码, A.Dscription as 物料名称,A.Quantity as 销售数量,(A.Quantity-isnull(A.U_XSQty,0)) as 剩余数量, 0 as 出库数量,A.LineNum as 行号,A.WhsCode as 仓库 FROM {0}..RDR1 A
WHERE A.DocEntry = {1} AND A.OpenQty != 0 AND isnull(A.U_XSQty,'0') < A.Quantity AND A.LineStatus ='O' AND A.U_XSLineStatus = 'O'", ConnModel.commonDB, docEntry), CommandType.Text);
//设置datagrid的列宽
DataGridTableStyle mydata = new DataGridTableStyle();
GridColumnStylesCollection mycol = null;
DGsale.DataSource = tbl;
mydata.MappingName = tbl.TableName;
DGsale.TableStyles.Clear();
DGsale.TableStyles.Add(mydata);
mycol = DGsale.TableStyles[0].GridColumnStyles;
mycol[0].Width = 80;
mycol[1].Width = 80;
}
public void FixupLastColumn()
{
if (tableStyle == null)
{
return;
}
GridColumnStylesCollection colStyles = tableStyle.GridColumnStyles;
if (colStyles.Count == 0)
{
return;
}
// Okay, we've got the data to do the sizing
inManualSize = true;
//get the target width
int width = grid.ClientRectangle.Width - 4; // the 4 handles the borders
if (IsScrollBarVisible(grid))
{
width -= SystemInformation.VerticalScrollBarWidth;
}
int lastColIndex = tableStyle.GridColumnStyles.Count - 1;
for (int i = 0; i < lastColIndex; ++i)
{
width -= colStyles[i].Width;
}
int minSizeLastCol = -1;
if (null != minimumWidths)
{
minSizeLastCol = minimumWidths[lastColIndex];
}
// Last column always gets remainder of space
if (width > minSizeLastCol)
{
colStyles[lastColIndex].Width = width;
}
inManualSize = false;
}
/// <summary>
/// 过账创建空table
/// </summary>
/// <returns></returns>
public void Grid3DataTable()
{
DataTable table = new DataTable();
table.Columns.Add("供应商编码");
table.Columns.Add("供应商名称");
table.Columns.Add("采购订单");
table.Columns.Add("采购订单行号");
table.Columns.Add("质检单号");
table.Columns.Add("质检单行号");
table.Columns.Add("物料编码");//6
table.Columns.Add("物料名称");
table.Columns.Add("批次");
table.Columns.Add("订单数量");
table.Columns.Add("单价");
table.Columns.Add("行合计");
table.Columns.Add("是否库位");
table.Columns.Add("仓库编码");
table.Columns.Add("仓库名称");
table.Columns.Add("库位标识");
table.Columns.Add("库位编码");
table.Columns.Add("入库数量");
table.Columns.Add("制单人");
DataGridTableStyle mydata2 = new DataGridTableStyle();
GridColumnStylesCollection mycol2 = null;
DataGrid2.DataSource = table;
mydata2.MappingName = table.TableName;
DataGrid2.TableStyles.Clear();
DataGrid2.TableStyles.Add(mydata2);
mycol2 = DataGrid2.TableStyles[0].GridColumnStyles;
mycol2["供应商编码"].Width = 0;
mycol2["供应商名称"].Width = 0;
mycol2["采购订单"].Width = 0;
mycol2["采购订单行号"].Width = 0;
mycol2["质检单号"].Width = 0;
mycol2["质检单行号"].Width = 0;
mycol2["订单数量"].Width = 0;
mycol2["单价"].Width = 0;
mycol2["行合计"].Width = 0;
mycol2["是否库位"].Width = 0;
mycol2["库位标识"].Width = 0;
mycol2["制单人"].Width = 0;
}
public void llenaListas()
{
DataSet listas = consulta("SELECT IDInv, EPCArt, IDArticulo FROM detalleInvCong WHERE (Estatus = 0)");
DataGridTableStyle tableStyle = new DataGridTableStyle();
tableStyle.MappingName = listas.Tables[0].TableName;
GridColumnStylesCollection columnStyles = tableStyle.GridColumnStyles;
DataGridTextBoxColumn columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "EPCArt";
columnStyle.HeaderText = "EPC";
columnStyle.Width = 150;
columnStyles.Add(columnStyle);
columnStyle = new DataGridTextBoxColumn();
columnStyle.MappingName = "IDArticulo";
columnStyle.HeaderText = "Articulo";
columnStyle.Width = 100;
columnStyles.Add(columnStyle);
GridTableStylesCollection tableStyles = dataGrid1.TableStyles;
tableStyles.Add(tableStyle);
dataGrid1.PreferredRowHeight = 16;
dataGrid1.RowHeadersVisible = false;
//------------------------------
dataGrid1.DataSource = listas.Tables[0];
//------------------------------
lstNum.DataSource = listas.Tables[0];
lstNum.DisplayMember = "IDDetInvCong";
lstSerie.DataSource = listas.Tables[0];
lstSerie.DisplayMember = "EPCArt";
lstDescripcion.DataSource = listas.Tables[0];
lstDescripcion.DisplayMember = "IDArticulo";
foreach (DataRow dtRow in listas.Tables[0].Rows)
{
epcs.Add(dtRow[1]);
idArts.Add(dtRow[2]);
}
}
public void TestAddRange()
{
DataGridTableStyle ts = new DataGridTableStyle ();
GridColumnStylesCollection sc = ts.GridColumnStyles;
sc.CollectionChanged += new CollectionChangeEventHandler (OnCollectionEventHandler);
ResetEventData ();
DataGridTextBoxColumn col1 = new DataGridTextBoxColumn ();
col1.MappingName = "Column1";
DataGridTextBoxColumn col2 = new DataGridTextBoxColumn ();
col2.MappingName = "Column2";
sc.AddRange (new DataGridColumnStyle[] {col1, col2});
Assert.AreEqual (true, eventhandled, "A1");
Assert.AreEqual (col2, Element, "A2");
Assert.AreEqual (CollectionChangeAction.Add, Action, "A3");
Assert.AreEqual (2, times, "A4");
}
