## 20170724工作内容 #### 火锅节消息推送 150   #### 物流供应链会议 #### 根据短码补全商品信息 200 SELECT t2.FFullName ,t_ICItem.*,t_ICItem.FStoreUnitID as FCUUnit_ID,t1.FName as FUnitName,t3.FName as FCUUnitName,t4.FName as FSecUnitName, t1.FNumber as FUnitNumber,t3.FNumber as FCUUnitNumber FROM t_ICItem Left Join t_MeasureUnit t1 on t_ICItem.FUnitID=t1.FItemID Inner join t_Item t2 on t_ICItem.FItemID=t2.FItemID Left Join t_MeasureUnit t3 on t_ICItem.FStoreUnitID=t3.FItemID AND t3.FDeleted=0 Left Join t_MeasureUnit t4 on t_ICItem.FSecUnitID=t4.FItemID AND t3.FDeleted=0 Where t2.FDetail=1 AND t_ICItem.FDeleted=0 AND (t_ICItem.FNumber='01.01.01.002' OR t_ICItem.FShortNumber='01.01.01.002' ) and t_ICItem.FErpClsID NOT IN (6,8) #### 部门查询 SELECT TOP 50 t1.FItemID ,t1.FDeleted ,t1.FNumber,t1.FName,t1.FDetail FROM [AIS20170612094709].[dbo].[t_Item] t1 with(index (uk_Item2)) LEFT JOIN t_Department x2 ON t1.FItemID = x2.FItemID WHERE FItemClassID = 2 AND t1.FDetail=1 AND ((t1.FNumber Like '%01.01.02%' OR t1.FName LIKE '%01.01.02%')) AND t1.FDeleteD=0 ORDER BY t1.FNumber SELECT TOP 50 t1.[FItemID] ,t1.[FDeleted] ,t1.[FNumber],t1.[FName],t1.[FDetail] FROM [stock].[dbo].[t_Item] t1 with(index (uk_Item2)) LEFT JOIN [stock].[dbo].[t_Department] x2 ON t1.FItemID = x2.FItemID WHERE FItemClassID = 2 AND t1.FDetail=1 AND ((t1.FNumber Like '01%' OR t1.FName LIKE '01%')) AND t1.FDeleteD=0 ORDER BY t1.FNumber #### 主管查询 SELECT TOP 50 t1.FItemID ,t1.FDeleted ,t1.FNumber,t1.FName,t1.FDetail FROM [stock].[dbo].[t_Item] t1 with(index (uk_Item2)) LEFT JOIN [stock].[dbo].[t_Emp] x2 ON t1.FItemID = x2.FItemID WHERE FItemClassID = 3 AND t1.FDetail=1 AND ((t1.FNumber Like '%0102%' OR t1.FName LIKE '%0102%')) AND t1.FDeleteD=0 ORDER BY t1.FNumber #### 业务员查询 SELECT TOP 50 t1.FItemID ,t1.FDeleted ,t1.FNumber,t1.FName,t1.FDetail FROM [stock].[dbo].[t_Item] t1 with(index (uk_Item2)) LEFT JOIN [stock].[dbo].[t_Emp] x2 ON t1.FItemID = x2.FItemID WHERE FItemClassID = 3 AND t1.FDetail=1 AND ((t1.FNumber Like '%0201%' OR t1.FName LIKE '%0201%')) AND t1.FDeleteD=0 ORDER BY t1.FNumber #### 保管员查询 SELECT t1.FItemID ,t1.FDeleted FROM t_Item t1 with(index (uk_Item2)) LEFT JOIN t_Emp x2 ON t1.FItemID = x2.FItemID WHERE FItemClassID = 3 AND t1.FDetail=1 AND ((t1.FNumber Like '%0116%' OR t1.FName Like '%0116%')) AND t1.FDeleteD=0 ORDER BY t1.FNumber #### 获取销售方式： SELECT FTypeID,FInterID FItemID, FID FNumber,FName,FSpec FROM t_SubMessage Where FInterID>0 AND FDeleted=0 And FTypeID=101 AND (FInterID<> 20296) And (FInterID<> 20296) ORDER BY FID SELECT TOP 1000 [FBrNo] ,[FInterID] ,[FID] ,[FParentID] ,[FName] ,[FTypeID] ,[FDetail] ,[FDeleted] ,[FModifyTime] ,[FSystemType] ,[FSpec] ,[UUID] FROM [AIS20170612094709].[dbo].[t_SubMessage] t1 Where t1.FInterID>0 AND t1.FDeleted=0 And t1.FTypeID=101 AND (t1.FInterID<> 20296) And (t1.FInterID<> 20296) ORDER BY t1.FID #### 获取购货单位： SELECT TOP 50 t1.FItemID ,t1.FDeleted ,t1.FNumber,t1.FName,t1.FDetail FROM t_Item t1 with(index (uk_Item2)) LEFT JOIN t_Organization x2 ON t1.FItemID = x2.FItemID WHERE FItemClassID = 1 AND t1.FDetail=1 AND t1.FDeleteD=0 ORDER BY t1.FNumber SELECT TOP 1000 t1.[FItemID] ,t1.[FItemClassID] ,t1.[FExternID] ,t1.[FNumber] ,t1.[FParentID] ,t1.[FLevel] ,t1.[FDetail] ,t1.[FName] ,t1.[FUnUsed] ,t1.[FBrNo] ,t1.[FFullNumber] ,t1.[FDiff] ,t1.[FDeleted] ,t1.[FShortNumber] ,t1.[FFullName] ,t1.[UUID] ,t1.[FGRCommonID] ,t1.[FSystemType] ,t1.[FUseSign] ,t1.[FChkUserID] ,t1.[FAccessory] ,t1.[FGrControl] ,t1.[FModifyTime] ,t1.[FHavePicture] FROM [AIS20170612094709].[dbo].[t_Item]t1 with(index (uk_Item2)) LEFT JOIN [AIS20170612094709].[dbo].t_Organization x2 ON t1.FItemID = x2.FItemID WHERE t1.[FItemClassID] = 1 AND t1.[FDetail]=1 AND t1.[FDeleted]= 0 ORDER BY t1.[FNumber] DESC #### 商品基本信息 100 + 商品编号 + 商品品牌编号 + 商品名称 + 规格 + 采购规格 * #### 商品品牌 + 品牌编号 + 品牌名称 + 商户名称 #### 商品价格 + 商品编号 + 商品单价 + 参考成本价 + 采购价 #### 商品基本单位 + 基本单位 #### 仓库 + 仓库编号 #### 商品库存清单 + 商品编号 + 仓库编号 + 库存数量 #### 商品规格型号 + 规格型号 #### 商品软属性 + 商品编号 + 商品标签