阿修罗一平

To visual studio 2005 execute:

 Infragistics2.ToolboxUtility.exe /t:8.0 8.2

from

\t:8.0 is the vesion of Visual Studio (in a VS window go to Help->About Microsoft Visual Studio ej: 8.0.50727.42)

 8.2 is the version of Build or Relese (Ej NetAdvantage for .NET 2008 Vol. 2 CLR 2.0)

      8 year

      2 vol

如果是Infragistics.NetAdvantage.for.Windows.Forms.2009.Vol.1(CLR2.0)，

then execute:

Infragistics2.ToolboxUtility.exe /t:8.0 9.1

To visual studio 2008 execute:

Infragistics2.ToolboxUtility.exe /v /t:9.0 9.1

1、需要使用配置文件

我们在使用NUnit做单元测试的时候，逻辑代码中可能会使用到应用的配置文件里的数据，比如常见的App.config的数据库连接字符串。解决方法就是将配置文件（如App.config)放在测试项目中，偷懒的话就设置为“始终复制”，编译并测试项目，就可访问配置文件中的数据了。

<configuration>
 <appSettings>
  <add key="DALTYPE" value="VLP2011.SQLServerDAL"/>
  <add key="CONNECTIONSTRING" value="server=YIPING\SQLSERVER2005;database=VPL2011_BaseDB;uid=sa;pwd=sa"/>
 </appSettings>
</configuration>

string ConnectionString = ConfigurationManager.AppSettings["CONNECTIONSTRING"];
Console.WriteLine("连接字符串：" + path);

有些用法老是记不住，现在记录在网上，下次就容易查到了，不必到处搜索了。

1、Groupby

var tempPlanGoodsItems =
                (from p in m_StockInPlan.GoodsItems
                group p by new { p.GoodsName, p.MaterialNo, p.CompanySerialNo, p.SpecAndModel, p.BatchNo, p.SkuNo } into g
                select new RestGoodsItem
                {
                    GoodsName = g.Key.GoodsName,
                    MaterialNo = g.Key.MaterialNo,
                    CompanySerialNo = g.Key.CompanySerialNo,
                    SpecAndModel = g.Key.SpecAndModel,
                    BatchNo = g.Key.BatchNo,
                    SkuNo = g.Key.SkuNo,
                    PlanQuantity = g.Sum<PlanGoodsItem>(p => p.Quantity),
                    Quantity = 0,

                }).ToList<RestGoodsItem>();

2、主子表查询（子表条件）

 IList<StockOutPlan> stockOutPlans = m_StockOutPlanBizService.CreateQueryNoNoLazies("select distinct p from StockOutPlan as p inner join p.GoodsItems as g where g.StockInPlanNo='" + m_StockInPlan.PlanNo + "'", new List<string> { StockOutPlan.NON_LAZY_GOODSITEMS});