2026西湖龙井茶官网DTC发售：茶农直供，政府溯源防伪到农户家
答是，杰达新信息科技（上海）有限公司杰达公司创立于2006年，总部设立在上海，在深圳，南京设有分公司，在台湾，成都设立有研发中心，具有15年大中型企业客户的信息化实施经验，目前有200 的综合型信息化服务人才，杰达在PCB行业积极探索PCB行业的智能工厂建设方案，并率先为鹏鼎秦皇岛A8厂建立第一代PCB智能工厂样板，并相继的为鹏鼎淮安H6厂，淮安H4厂，方正珠海F7厂，广合黄石工厂提供了智能工厂解决方案，在PCB行业的智能工厂建设方面积累了大量的专业知识及成功案例。杰达是国家高新技术企业，拥有40 项自主知识产权及专利技术，是SAP， 西门子，Infor 等国际大型管理软件公司的金牌合作伙伴，为客户提供包括流程咨询&IT管理咨询，ERP&MES系统实施及导入，Kyber MES &设备自动化等自有产品的实施，IT 运维及IT人力外包等四个方面的一站式信息化解决方案。杰达成立以来，已经是鹏鼎控股，方正PCB，广合科技，晶科太阳能，英飞凌，京东方，天马微电子，SDP，华润微电子，士兰微等行业头部客户的长期合作伙伴。二、金蝶K3ERP销售报表开发：第一行显示日期怎么在第二行开始统计数量？
set nocount on SELECT CASE WHEN GROUPING(v1.Fdate)=1 THEN 1 ELSE 0 END AS Fdate_Grouping,CONVERT(varchar,v1.Fdate) AS Fdate_NOGrouping,CASE WHEN GROUPING(v1.Fdate)=1 THEN 101ELSE 0 END AS FSumSort ,SUM(CASE WHEN t4.FName ='（河南）散户' THEN IsNull(u1.Fauxqty,0) ELSE 0 END) AS Fauxqty1,SUM(CASE WHEN t4.FName ='（华东）华润万家有限公司' THEN IsNull(u1.Fauxqty,0) ELSE 0 END) AS Fauxqty2,SUM(CASE WHEN t4.FName ='（华南）华润万家有限公司' THEN IsNull(u1.Fauxqty,0) ELSE 0 END) AS Fauxqty3,SUM(IsNull(u1.Fauxqty,0)) AS Fauxqty281, IDENTITY(int,1,1) AS column_name into #CrossTab FROM ICStockBill v1 Inner Join ICStockBillEntry u1 on v1.FInterID=u1.FInterIDInner Join t_Organization t4 on v1.FSupplyID=t4.FItemIDleft outer join t_SubMessage t7 on v1.FSaleStyle=t7.FInterIDInner Join t_Stock t8 on u1.FDCStockID=t8.FItemIDleft outer join t_Emp t9 on v1.FFManagerID=t9.FItemIDleft outer join t_Emp t10 on v1.FSManagerID=t10.FItemIDInner Join t_User t11 on v1.FBillerID=t11.FUserIDInner Join t_ICItem t14 on u1.FItemID=t14.FItemIDInner Join t_MeasureUnit t17 on u1.FUnitID=t17.FItemIDleft outer join t_User t24 on v1.Fcheckerid=t24.FUserIDInner Join t_MeasureUnit t30 on t14.FUnitID=t30.FItemIDleft outer join t_SubMessage t40 on v1.FMarketingStyle=t40.FInterIDleft outer join v_ICTransType t70 on u1.FSourceTranType=t70.FIDleft outer join ICVoucherTpl t16 on v1.FPlanVchTplID=t16.FInterIDleft outer join ICVoucherTpl t13 on v1.FActualVchTplID=t13.FInterIDleft outer join t_Department t105 on v1.FDeptID=t105.FItemIDleft outer join t_Emp t106 on v1.FEmpID=t106.FItemIDleft outer join t_Emp t107 on v1.FManagerID=t107.FItemIDleft outer join t_AuxItem t112 on u1.FAuxPropID=t112.FItemidleft outer join t_MeasureUnit t500 on t14.FStoreUnitID=t500.FItemIDleft outer join t_Currency t503 on v1.FCurrencyID=t503.FCurrencyIDleft outer join t_StockPlace t510 on u1.FDCSPID=t510.FSPIDleft outer join ZPStockBill t523 on v1.FInterID=t523.FRelateBillInterIDleft outer join t_SonCompany t550 on v1.FRelateBrID=t550.FItemIDleft outer join t_MeasureUnit t552 on t14.FSecUnitID=t552.FItemIDleft outer join t_SonCompany t560 on v1.FBrID=t560.FItemIDleft outer join rtl_vip t650 on v1.FVIPCardId=t650.Fidleft outer join Rtl_WorkShift t651 on v1.FWorkShiftID=t651.FIDleft outer join t_BaseBondedManageType t621 on v1.FManageType=t621.FIDInner Join t_SubMessage t123 on u1.FPlanMode=t123.FInterIDleft outer join CRM_ServiceRequest t800 on v1.FInterID=t800.FSourceInterIDleft outer join t_Organization t44 on v1.FConsignee=t44.FItemIDleft outer join t_SubMessage tVMI on u1.FIsVMI=tVMI.FInterIDleft outer join t_Supplier tSup on u1.FEntrySupply=tSup.FItemIDleft outer join t_SubMessage tq224 on u1.FChkPassItem=tq224.FInterIDleft outer join t_User tcf on v1.FConfirmer=tcf.FUserIDleft outer join t_PayColCondition t_Pay on v1.FPayCondition=t_Pay.FIDleft outer join t_Item t3416 on u1.FEntrySelfB0178=t3416.FItemIDWHERE 1=1 AND v1.FTranType=21 AND v1.FTranType=21 AND ((v1.FDate>='2014-07-01' AND v1.FDate<'2014-08-01')) Group By v1.Fdate WITH ROLLUPupdate #CrossTab set Fauxqty281=Fauxqty1 Fauxqty2 Fauxqty3select Case Fdate_Grouping When 1 Then '合计' When 2 Then '小计' ELSE Convert(nVarchar,Fdate_NOGrouping) End As Fdate,* from #CrossTab where FSumSort<> 102 order by column_name其中两个华润是我举例子用的客户名字，你自己实际情况自己加，然后我行是客户，列是日期，这个问题应该不大，如果你一样要行是日期的话，自己改吧~对了，我用的是12.3版本
