k3销售订单支持批号sql.doc

k3销售订单支持批号sql.txt人生在世 ，难敌宿命，沉沦其中。我不爱风尘，似被前缘误！我只为我最爱的人流泪“我会学着放弃你，是因为我太爱你”赢了你,我可以放弃整个世界-select * from ICTemplateEntry Where FID=S01-select * from ICTemplateEntry Where FID=S02 and ffieldname=FBatchNo-销售订单增加批号V12.2Insert Into ICTemplateEntry(FID,FCtlOrder,FCtlIndex,FCtlType,FLookUpCls,FNeedSave,FValueType,FSaveValue,FFieldName,FEnable,FPrint,FHeadCaption,FWidth,FNeedCount,FRelationID,FAction,FMustInput,FFilter,FSaveRule,FDefaultCtl,FVisForBillType,FRelateOutTbl,FSysMustInputItem,FHeadCaption_CHT,FHeadCaption_EN,FStatCount,FIsVisibleForList,FCanEditedAllTime,FAllowCopy,FDefaultValue,FMaxValue,FMinValue,FFormat,FPrintStatus,flookuptype,foptionext,fitemclassid,fuserdefineclassid)select S01,68,68,FCtlType,FLookUpCls,FNeedSave,FValueType,FSaveValue,FFieldName,FEnable,FPrint,FHeadCaption,FWidth,FNeedCount,FRelationID,FAction,FMustInput,FFilter,FSaveRule,FDefaultCtl,FVisForBillType,FRelateOutTbl,FSysMustInputItem,FHeadCaption_CHT,FHeadCaption_EN,FStatCount,FIsVisibleForList,FCanEditedAllTime,FAllowCopy,FDefaultValue,FMaxValue,FMinValue,FFormat,FPrintStatus,flookuptype,foptionext,fitemclassid,fuserdefineclassid from ICTemplateEntry Where FID=S02 and ffieldname=FBatchNo-更新批号数据select fbatchno,* from seorderentryupdate seorderentry set fbatchno=fentryselfs0163 -销售订单序时薄增加批号V12.2-select * from ICChatBillTitle where ftypeid=61 -select * from ICChatBillTitle where ftypeid=64 and finterid=48goDeclare FInterID INT Select FInterID=ISNULL(MAX(FInterID),0)+1 From ICChatBillTitle where FTypeID=61Insert Into ICChatBillTitle(FInterID,FTypeID,FColCaption,FHeadSecond,FColName,FTableName,FColType,FColWidth,FVisible,FItemClassID,FVisForQuest,FReturnDataType, FCountPriceType,FCtlIndex,FName,FTableAlias,FAction,FNeedCount,FIsPrimary,FLogicAction,FStatistical,FMergeable,FVisForOrder, FColCaption_CHT,FColCaption_EN,FControl,FMode,FControlType,FPrecisionField,FAlign,FEditable,FFormat,FFormatType,fmustselected) select FInterID,61,FColCaption,FHeadSecond,FColName,SEOrderEntry,FColType,FColWidth,FVisible,FItemClassID,FVisForQuest,FReturnDataType, FCountPriceType,FCtlIndex,FName,FTableAlias,FAction,FNeedCount,FIsPrimary,FLogicAction,FStatistical,FMergeable,FVisForOrder, FColCaption_CHT,FColCaption_EN,FControl,FMode,FControlType,FPrecisionField,FAlign,FEditable,FFormat,FFormatType,fmustselectedfrom ICChatBillTitle where ftypeid=64 and finterid=48goDeclare FInterID1 INT Select FInterID1 =ISNULL(MAX(FInterID),0)+1 From ICTableRelation where FTypeID=61Insert Into ICTableRelation(FTypeID,FInterID,FTableName,FTableNameAlias,FFieldName,FTableName11,FTableNameAlias11,FFieldName11,FLogic,FBillID,FFieldID,FMode,FIndex,FCondition,FLeftParentheses,FRightParentheses,FLogicOperator,FISConst,FConstType,FSubFilter)Values(61,FInterID1 ,SEorderEntry,u1,fbatchno,icinventory,t444,fbatchno,*=,0,0,=,0,0,)-销售订单下推发货通知单关联批号-delete from ICSelbills where FID=P01 AND FDstCtlField =fbatchno - FOrderInterID,FPPOrderInterID,FSalBillInterID,FSCBillInterIDgoupdate icselbillsset faction= WHERE FID = S02 AND FFieldName = FCnnInterID AND FSelType 1 AND FDK NOT IN (1,2) AND FDstCtlField and fname=fbatchno/*Insert Into ICSelbills (FID,FFieldName,fdstctlfield,fseltype,fdk,fcolname,fname,ftablename,ftablealias,faction ,frob,fallowedited)select S02,FCnnInterID,fdstctlfield,fsel