2014-8-8-Nbearlite 查询

Query

1.in的写法

1.1直接赋值  storemanage_v3.shelf_info.shelftype.In(new object[] { 0, (int)SysTypeLibEnum.货架类型_普通货架 })

1.2数组赋值

 string[] oidarr = oids.Split(',');

  storemanage_v3.shelf_info.shelftype.In(oidarr)

2.查询sql

SelectSqlSection selectSql = DBHelper.DB.Select(storemanage_v4.order_info,
                        storemanage_v4.order_info.orderid);

selectSql.Where(storemanage_v4.order_info.ordercode == order.orderCode);

DataTable dtOrder = selectSql.ToDataSet() .Tables[0];
                        
                       

Insert

1.返回自增标示

 int identity = DBHelper.DB.Insert(storemanage_v4.order_upload)
                 .AddColumn(storemanage_v4.order_upload.data, uploadData)
                 .AddColumn(storemanage_v4.order_upload.apptime, DateTime.Now)
                .ExecuteReturnAutoIncrementID(storemanage_v4.order_upload.uploadid);

Update

 UpdateSqlSection updareSql = DBHelper.DB.Update(storemanage_v4.order_info)
                 .AddColumn(storemanage_v4.order_info.username, order.receiver);

 updareSql.AddColumn(storemanage_v4.order_info.sourceid, expType);

 int identity = updareSql.Where(storemanage_v4.order_info.orderid == orderId).Execute();