新增文章

文章标题分类内容

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 过滤方案

select * from ICClassProfile  where FUserID = 16398 and FTranType = 210001202
   
   select *         from ICClassProfileEntry   where FSchemeID in (
   select FSchemeID from ICClassProfile        where FUserID   = 16398 and FTranType = 210001202
   )
   and FKey = 'ColHide'

------------------------------------------------------------------------------------------------------------------
   select * from ICClassProfileEntry   where FSchemeID = 10387

select * from ICClassProfileEntry   where FSchemeID >= 999999978

/*
   delete           FROM ICClassProfileEntry where FSchemeID In (
   SELECT FSchemeID FROM ICClassProfile      where FUserID = 16399 AND FTranType = 210001201
   )
   
   SELECT MAX(FSchemeID) AS MAXID from ICClassProfile where FSchemeID<999999978
   
   INSERT INTO ICClassProfile(FSchemeID,FSchemeName,FUserID,FTranType,FSysName,FStatus,FIsShare) VALUES(10387,'全部字段',16398,210000003,'',0,0)
   
   INSERT INTO ICSchemeSharing(FUserID,FSchemeID,FTranType,FIsDel) Values(0,10387,210000003,0)
   
   INSERT INTO ICClassProfileEntry(FSchemeID,FType,FKey,FValue) VALUES(10387,0,'AdvancedFieldList','||0##<&0##<&')
   INSERT INTO ICClassProfileEntry(FSchemeID,FType,FKey,FValue) VALUES(10387,0,'AdvancedFilterStr','')
   INSERT INTO ICClassProfileEntry(FSchemeID,FType,FKey,FValue) VALUES(10387,0,'ColAlign','a_StockBill.FVoucherId=0|a_StockBill.FPrintCount=0|t_User1.FName=0|a_StockBill.FMultiCheckStatus=0|t_User.FName=0|a_StockBill.FDate=0|a_StockBill.FBillNo=0|a_CompanyEntry.FName=0|t_SubMessage.FName=0|a_StockBillEntry.FSrcBillNo=0|a_StockBillEntry.FSrcIndex=0|ICClassType1.FName_CHS=0|t_Item_3001.FNumber._0011_FBaseProperty2=0|t_Item_3001.FName=0|a_StockBill.FOrderNoCust=0|t_Item_3001.F_108._0049_FBaseProperty8=0|t_Emp.FNumber._0040_FBaseProperty3=0|t_Emp.FName=0|t_Department.FNumber._0041_FBaseProperty4=0|t_Department.FName=0|t_Stock.FName=0|t_ICItem.FNumber=0|t_ICItem.FName._0002_FBaseProperty=0|t_ICItem.FModel._0003_FBaseProperty1=0|t_AuxItem.FName=0|t_Measureunit.FName=0|a_StockBillEntry.FQtySale=0|a_StockBillEntry.FPriceSale=0|a_StockBillEntry.FAmountSale=0|t_Measureunit1.FName=0|a_StockBillEntry.FQtyBase=0|a_StockBillEntry.FPriceBase=0|a_StockBillEntry.FPriceCost=0|a_StockBillEntry.FAmountCost=0|a_StockBill.FExplanation=0|a_StockBillEntry.FNoteCust=0|a_StockBillEntry.FNote=0|')
   INSERT INTO ICClassProfileEntry(FSchemeID,FType,FKey,FValue) VALUES(10387,0,'ColHide','a_StockBill.FVoucherId=-1|a_StockBill.FPrintCount=0|t_User1.FName=-1|a_StockBill.FMultiCheckStatus=0|t_User.FName=-1|a_StockBill.FDate=-1|a_StockBill.FBillNo=-1|a_CompanyEntry.FName=-1|t_SubMessage.FName=-1|a_StockBillEntry.FSrcBillNo=-1|a_StockBillEntry.FSrcIndex=-1|ICClassType1.FName_CHS=-1|t_Item_3001.FNumber._0011_FBaseProperty2=-1|t_Item_3001.FName=-1|a_StockBill.FOrderNoCust=-1|t_Item_3001.F_108._0049_FBaseProperty8=-1|t_Emp.FNumber._0040_FBaseProperty3=-1|t_Emp.FName=-1|t_Department.FNumber._0041_FBaseProperty4=-1|t_Department.FName=-1|t_Stock.FName=-1|t_ICItem.FNumber=-1|t_ICItem.FName._0002_FBaseProperty=-1|t_ICItem.FModel._0003_FBaseProperty1=-1|t_AuxItem.FName=-1|t_Measureunit.FName=-1|a_StockBillEntry.FQtySale=-1|a_StockBillEntry.FPriceSale=-1|a_StockBillEntry.FAmountSale=-1|t_Measureunit1.FName=-1|a_StockBillEntry.FQtyBase=-1|a_StockBillEntry.FPriceBase=-1|a_StockBillEntry.FPriceCost=-1|a_StockBillEntry.FAmountCost=-1|a_StockBill.FExplanation=-1|a_StockBillEntry.FNoteCust=-1|a_StockBillEntry.FNote=-1|')
   INSERT INTO ICClassProfileEntry(FSchemeID,FType,FKey,FValue) VALUES(10387,0,'ColIndex','a_StockBill.FVoucherId=1|a_StockBill.FPrintCount=2|t_User1.FName=3|a_StockBill.FMultiCheckStatus=4|t_User.FName=5|a_StockBill.FDate=6|a_StockBill.FBillNo=7|a_CompanyEntry.FName=8|t_SubMessage.FName=9|a_StockBillEntry.FSrcBillNo=10|a_StockBillEntry.FSrcIndex=11|ICClassType1.FName_CHS=12|t_Item_3001.FNumber._0011_FBaseProperty2=13|t_Item_3001.FName=14|a_StockBill.FOrderNoCust=15|t_Item_3001.F_108._0049_FBaseProperty8=16|t_Emp.FNumber._0040_FBaseProperty3=17|t_Emp.FName=18|t_Department.FNumber._0041_FBaseProperty4=19|t_Department.FName=20|t_Stock.FName=21|t_ICItem.FNumber=22|t_ICItem.FName._0002_FBaseProperty=23|t_ICItem.FModel._0003_FBaseProperty1=24|t_AuxItem.FName=25|t_Measureunit.FName=26|a_StockBillEntry.FQtySale=27|a_StockBillEntry.FPriceSale=28|a_StockBillEntry.FAmountSale=29|t_Measureunit1.FName=30|a_StockBillEntry.FQtyBase=31|a_StockBillEntry.FPriceBase=32|a_StockBillEntry.FPriceCost=33|a_StockBillEntry.FAmountCost=34|a_StockBill.FExplanation=35|a_StockBillEntry.FNoteCust=36|a_StockBillEntry.FNote=37|')
   INSERT INTO ICClassProfileEntry(FSchemeID,FType,FKey,FValue) VALUES(10387,0,'ColWidth','a_StockBill.FVoucherId=737|a_StockBill.FPrintCount=737|t_User1.FName=567|a_StockBill.FMultiCheckStatus=1077|t_User.FName=567|a_StockBill.FDate=737|a_StockBill.FBillNo=737|a_CompanyEntry.FName=737|t_SubMessage.FName=737|a_StockBillEntry.FSrcBillNo=737|a_StockBillEntry.FSrcIndex=737|ICClassType1.FName_CHS=737|t_Item_3001.FNumber._0011_FBaseProperty2=737|t_Item_3001.FName=737|a_StockBill.FOrderNoCust=737|t_Item_3001.F_108._0049_FBaseProperty8=737|t_Emp.FNumber._0040_FBaseProperty3=907|t_Emp.FName=567|t_Department.FNumber._0041_FBaseProperty4=737|t_Department.FName=340|t_Stock.FName=737|t_ICItem.FNumber=737|t_ICItem.FName._0002_FBaseProperty=737|t_ICItem.FModel._0003_FBaseProperty1=737|t_AuxItem.FName=737|t_Measureunit.FName=737|a_StockBillEntry.FQtySale=737|a_StockBillEntry.FPriceSale=737|a_StockBillEntry.FAmountSale=737|t_Measureunit1.FName=737|a_StockBillEntry.FQtyBase=1077|a_StockBillEntry.FPriceBase=1077|a_StockBillEntry.FPriceCost=1247|a_StockBillEntry.FAmountCost=737|a_StockBill.FExplanation=340|a_StockBillEntry.FNoteCust=737|a_StockBillEntry.FNote=737|')
   INSERT INTO ICClassProfileEntry(FSchemeID,FType,FKey,FValue) VALUES(10387,0,'OrderBy','')
   INSERT INTO ICClassProfileEntry(FSchemeID,FType,FKey,FValue) VALUES(10387,0,'Relation','')
   INSERT INTO ICClassProfileEntry(FSchemeID,FType,FKey,FValue) VALUES(10387,0,'RelationExt','FVoucherID=0|FCheckId=0|FMultiCheckStatus=0|')
   INSERT INTO ICClassProfileEntry(FSchemeID,FType,FKey,FValue) VALUES(10387,0,'RelationFormula','')
   INSERT INTO ICClassProfileEntry(FSchemeID,FType,FKey,FValue) VALUES(10387,0,'SelPage',',1*,2,')
   INSERT INTO ICClassProfileEntry(FSchemeID,FType,FKey,FValue) VALUES(10387,0,'TransferWildcard','0')
   
*/