/// <summary>
/// 对DataGrid列样式进行设置
/// </summary>
/// <param name="datagrid">要设置的DataGrid</param>
/// <param name="dt">DataTable表</param>
private void addColumnStyle(System.Windows.Forms.DataGrid datagrid,System.Data.DataTable dt)
{
DataGridTableStyle ts=new DataGridTableStyle();
ts.MappingName=dt.TableName;
//分别添加列格式
//0
DataGridColumnStyle cs0=new DataGridTextBoxColumn();
cs0.MappingName="City";
cs0.HeaderText="编号";
cs0.Width=30;
ts.GridColumnStyles.Add(cs0);
//1
DataGridColumnStyle cs1=new DataGridTextBoxColumn();
cs1.MappingName="Region";
cs1.HeaderText="出售单位";
cs1.Width=150;
ts.GridColumnStyles.Add(cs1);
//2
DataGridColumnStyle cs2=new DataGridTextBoxColumn();
cs2.MappingName="规格品名";
cs2.HeaderText="规格品名";
cs2.Width=120;
ts.GridColumnStyles.Add(cs2);
//3
DataGridColumnStyle cs3=new DataGridTextBoxColumn();
cs3.MappingName="单位";
cs3.HeaderText="单位";
cs3.Width=30;
ts.GridColumnStyles.Add(cs3);
//4
DataGridColumnStyle cs4=new DataGridTextBoxColumn();
cs4.MappingName="数量";
cs4.HeaderText="数量";
cs4.Width=30;
ts.GridColumnStyles.Add(cs4);
//5
DataGridColumnStyle cs5=new DataGridTextBoxColumn();
cs5.MappingName="单价";
cs5.HeaderText="单价";
cs5.Width=60;
ts.GridColumnStyles.Add(cs5);
//6
DataGridColumnStyle cs6=new DataGridTextBoxColumn();
cs6.MappingName="运杂费";
cs6.HeaderText="运杂费";
cs6.Width=50;
ts.GridColumnStyles.Add(cs6);
//7
DataGridColumnStyle cs7=new DataGridTextBoxColumn();
cs7.MappingName="金额";
cs7.HeaderText="金额";
cs7.Width=60;
ts.GridColumnStyles.Add(cs7);
//8
DataGridColumnStyle cs8=new DataGridTextBoxColumn();
cs8.MappingName="验收";
cs8.HeaderText="验收";
cs8.Width=50;
ts.GridColumnStyles.Add(cs8);
//9
DataGridColumnStyle cs9=new DataGridTextBoxColumn();
cs9.MappingName="采购";
cs9.HeaderText="采购";
cs9.Width=50;
ts.GridColumnStyles.Add(cs9);
//10
DataGridColumnStyle cs10=new DataGridTextBoxColumn();
cs10.MappingName="附发票";
cs10.HeaderText="附发票";
cs10.Width=50;
ts.GridColumnStyles.Add(cs10);
//11
DataGridColumnStyle cs11=new DataGridTextBoxColumn();
cs11.MappingName="购进日期";
cs11.HeaderText="购进日期";
cs11.Width=80;
ts.GridColumnStyles.Add(cs11);
//12
DataGridColumnStyle cs12=new DataGridTextBoxColumn();
cs12.MappingName="类别";
cs12.HeaderText="类别";
cs12.Width=80;
ts.GridColumnStyles.Add(cs12);
//13
DataGridColumnStyle cs13=new DataGridTextBoxColumn();
cs13.MappingName="分类";
cs13.HeaderText="分类";
cs13.Width=80;
ts.GridColumnStyles.Add(cs13);
//14
DataGridColumnStyle cs14=new DataGridTextBoxColumn();
cs14.MappingName="部门";
cs14.HeaderText="部门";
cs14.Width=60;
ts.GridColumnStyles.Add(cs14);
//15
DataGridColumnStyle cs15=new DataGridTextBoxColumn();
cs15.MappingName="产地";
cs15.HeaderText="产地";
cs15.Width=30;
ts.GridColumnStyles.Add(cs15);
//16
DataGridColumnStyle cs16=new DataGridTextBoxColumn();
cs16.MappingName="新旧程度";
cs16.HeaderText="新旧程度";
cs16.Width=60;
ts.GridColumnStyles.Add(cs16);
//17
DataGridColumnStyle cs17=new DataGridTextBoxColumn();
cs17.MappingName="存放地点";
cs17.HeaderText="存放地点";
cs17.Width=80;
ts.GridColumnStyles.Add(cs17);
//18
DataGridColumnStyle cs18=new DataGridTextBoxColumn();
cs18.MappingName="使用人";
cs18.HeaderText="使用人";
cs18.Width=50;
ts.GridColumnStyles.Add(cs18);
//19
DataGridColumnStyle cs19=new DataGridTextBoxColumn();
cs19.MappingName="备注";
cs19.HeaderText="备注";
cs19.Width=30;
ts.GridColumnStyles.Add(cs19);
//20
DataGridColumnStyle cs20=new DataGridTextBoxColumn();
cs20.MappingName="报废日期";
cs20.HeaderText="报废日期";
cs20.Width=100;
ts.GridColumnStyles.Add(cs20);
//添加到datagrid
datagrid.TableStyles.Add(ts);
}
/// 对DataGrid列样式进行设置
/// </summary>
/// <param name="datagrid">要设置的DataGrid</param>
/// <param name="dt">DataTable表</param>
private void addColumnStyle(System.Windows.Forms.DataGrid datagrid,System.Data.DataTable dt)
{
DataGridTableStyle ts=new DataGridTableStyle();
ts.MappingName=dt.TableName;
//分别添加列格式
//0
DataGridColumnStyle cs0=new DataGridTextBoxColumn();
cs0.MappingName="City";
cs0.HeaderText="编号";
cs0.Width=30;
ts.GridColumnStyles.Add(cs0);
//1
DataGridColumnStyle cs1=new DataGridTextBoxColumn();
cs1.MappingName="Region";
cs1.HeaderText="出售单位";
cs1.Width=150;
ts.GridColumnStyles.Add(cs1);
//2
DataGridColumnStyle cs2=new DataGridTextBoxColumn();
cs2.MappingName="规格品名";
cs2.HeaderText="规格品名";
cs2.Width=120;
ts.GridColumnStyles.Add(cs2);
//3
DataGridColumnStyle cs3=new DataGridTextBoxColumn();
cs3.MappingName="单位";
cs3.HeaderText="单位";
cs3.Width=30;
ts.GridColumnStyles.Add(cs3);
//4
DataGridColumnStyle cs4=new DataGridTextBoxColumn();
cs4.MappingName="数量";
cs4.HeaderText="数量";
cs4.Width=30;
ts.GridColumnStyles.Add(cs4);
//5
DataGridColumnStyle cs5=new DataGridTextBoxColumn();
cs5.MappingName="单价";
cs5.HeaderText="单价";
cs5.Width=60;
ts.GridColumnStyles.Add(cs5);
//6
DataGridColumnStyle cs6=new DataGridTextBoxColumn();
cs6.MappingName="运杂费";
cs6.HeaderText="运杂费";
cs6.Width=50;
ts.GridColumnStyles.Add(cs6);
//7
DataGridColumnStyle cs7=new DataGridTextBoxColumn();
cs7.MappingName="金额";
cs7.HeaderText="金额";
cs7.Width=60;
ts.GridColumnStyles.Add(cs7);
//8
DataGridColumnStyle cs8=new DataGridTextBoxColumn();
cs8.MappingName="验收";
cs8.HeaderText="验收";
cs8.Width=50;
ts.GridColumnStyles.Add(cs8);
//9
DataGridColumnStyle cs9=new DataGridTextBoxColumn();
cs9.MappingName="采购";
cs9.HeaderText="采购";
cs9.Width=50;
ts.GridColumnStyles.Add(cs9);
//10
DataGridColumnStyle cs10=new DataGridTextBoxColumn();
cs10.MappingName="附发票";
cs10.HeaderText="附发票";
cs10.Width=50;
ts.GridColumnStyles.Add(cs10);
//11
DataGridColumnStyle cs11=new DataGridTextBoxColumn();
cs11.MappingName="购进日期";
cs11.HeaderText="购进日期";
cs11.Width=80;
ts.GridColumnStyles.Add(cs11);
//12
DataGridColumnStyle cs12=new DataGridTextBoxColumn();
cs12.MappingName="类别";
cs12.HeaderText="类别";
cs12.Width=80;
ts.GridColumnStyles.Add(cs12);
//13
DataGridColumnStyle cs13=new DataGridTextBoxColumn();
cs13.MappingName="分类";
cs13.HeaderText="分类";
cs13.Width=80;
ts.GridColumnStyles.Add(cs13);
//14
DataGridColumnStyle cs14=new DataGridTextBoxColumn();
cs14.MappingName="部门";
cs14.HeaderText="部门";
cs14.Width=60;
ts.GridColumnStyles.Add(cs14);
//15
DataGridColumnStyle cs15=new DataGridTextBoxColumn();
cs15.MappingName="产地";
cs15.HeaderText="产地";
cs15.Width=30;
ts.GridColumnStyles.Add(cs15);
//16
DataGridColumnStyle cs16=new DataGridTextBoxColumn();
cs16.MappingName="新旧程度";
cs16.HeaderText="新旧程度";
cs16.Width=60;
ts.GridColumnStyles.Add(cs16);
//17
DataGridColumnStyle cs17=new DataGridTextBoxColumn();
cs17.MappingName="存放地点";
cs17.HeaderText="存放地点";
cs17.Width=80;
ts.GridColumnStyles.Add(cs17);
//18
DataGridColumnStyle cs18=new DataGridTextBoxColumn();
cs18.MappingName="使用人";
cs18.HeaderText="使用人";
cs18.Width=50;
ts.GridColumnStyles.Add(cs18);
//19
DataGridColumnStyle cs19=new DataGridTextBoxColumn();
cs19.MappingName="备注";
cs19.HeaderText="备注";
cs19.Width=30;
ts.GridColumnStyles.Add(cs19);
//20
DataGridColumnStyle cs20=new DataGridTextBoxColumn();
cs20.MappingName="报废日期";
cs20.HeaderText="报废日期";
cs20.Width=100;
ts.GridColumnStyles.Add(cs20);
//添加到datagrid
datagrid.TableStyles.Add(ts);
}