D:\Program Files\Metasoft\Auto\webapp\WEB-INF\database\patch\initquery.sql

ҵ		--Ʒѯ  
ִУ
select * from DataQueryMap where queryname='product'



delete DataQueryMap where queryname='product'
Ȼִ begin-end֮

ִ

		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(100,'product'   ,'MS_Material'    ,'ITEM_ID'        ,N'product'       ,'1'        ,-1           ,'1'        ,'0'        ,-1     ,''         ,'0'            ,''             ,'productAction.do?'  ,'0'        ,'0'              ,'ITEM_ID'            ,''                                                                                   		,''         ,''		,''  ,'0','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(100,'product'   ,'MS_Material'    ,'ITEM_TYPE'      ,N'ITEM_TYPE'     ,'1'        ,-1           ,'0'        ,'0'        ,-1     ,''         ,'0'            ,''             ,''         			,'0'        ,'0'              ,'ITEM_TYPE'          ,''                                                                                   	,'0'         ,''		,''  ,'0','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(0,  'product'   ,'MS_Material'    ,'SV_ITEM_ID'	  ,N'ۺϲѯ'      ,'0'        ,11            ,'0'        ,'1'        ,0      ,'like'     ,'0'            ,'' 			  ,''                   ,'0'        ,'2'          		,'mfilter'     		,'(a.ITEM_CODE like ''%mfilter%''  or a.PY_CODE like ''%mfilter%''  or a.ITEM_NAME like ''%mfilter%'' )' ,''         ,''		,''  ,'0','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(120,'product'   ,'MS_Material'    ,'ITEM_CODE'      ,N'Ʒ'      ,'0'        ,0            ,'0'        ,'1'        ,1      ,'like'  	  ,'1'            ,''             ,''                   ,'0'        ,'0'              ,'ITEM_CODE'          ,''                                                                                   ,''         ,'ASC'		,''  ,'0','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(150,'product'   ,'MS_Material'    ,'BAR_CODE'       ,N''      ,'0'        ,8            ,'0'        ,'1'        ,1      ,'like'  	  ,'0'            ,''             ,''                   ,'0'        ,'0'              ,'BAR_CODE'           ,''                                                                                   ,''         ,''		,''  ,'0','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(100,'product'	  ,'MS_Material'    ,'PY_CODE'     	  ,N'ƴ'      ,'0'        ,-1           ,'0'        ,'1'        ,1      ,'like'     ,'0'            ,''             ,''                   ,'0'        ,'0'              ,'PY_CODE'       		,''                                                                                   ,''         ,''		,''  ,'0','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(100,'product'	  ,'MS_Material'    ,'WB_CODE'     	  ,N'ʻ'      ,'0'        ,-1           ,'0'        ,'1'        ,1      ,'like'     ,'0'            ,''             ,''                   ,'0'        ,'0'              ,'WB_CODE'       		,''                                                                                   ,''         ,''		,''  ,'0','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(200,'product'   ,'MS_Material'    ,'ITEM_NAME'      ,N'Ʒ'      ,'0'        ,1            ,'0'        ,'1'        ,1      ,'like'     ,'2'            ,''             ,''                   ,'0'        ,'0'              ,'ITEM_NAME'          ,''                                                                                   ,''         ,''		,''  ,'0','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(180,'product'   ,'MS_Material'    ,'MODEL'          ,N''          ,'0'        ,2            ,'0'        ,'1'        ,1     ,'like'      ,'0'            ,''             ,''                   ,'0'        ,'3'              ,'mfilter'              ,'(isnull(a.MODEL,'''')='''' or a.MODEL like ''%mfilter%'' )'                                                                                   ,''         ,''		,''  ,'0','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(120,'product'   ,'MS_Material'    ,'h.DESCRIPTION'  ,N'Ʒ'      ,'0'        ,3            ,'0'        ,'1'        ,0      ,'rlike'    ,'0'            ,'category'     ,''                   ,'1'        ,'1'              ,'h.CODE_ID'          ,'left join MS_DataSet h with(nolock) on(a.CATEGORY=h.DATA_ID and h.TYPE_ID=22)'                   ,''         ,''		,''  ,'2','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(180,'product'   ,'MS_Material'    ,'i.DESCRIPTION'  ,N'ƷƷ'      ,'0'        ,4            ,'0'        ,'1'        ,3      ,'like' 	  ,'0'            ,'brand'        ,''                   ,'1'        ,'1'              ,'i.CODE_ID'          ,'left join MS_DataSet i with(nolock) on(a.BRAND=i.DATA_ID )'                      ,''         ,''		,''  ,'0','0')

		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(120,'product'   ,'MS_Material'    ,'YEAR_MODE'       ,N''         ,'0'        ,5            ,'0'        ,'1'        ,1      ,'like' 	  ,'0'            ,''			  ,''                   ,'0'        ,'0'              ,'YEAR_MODE'          ,''                      ,''         ,''		,''  ,'0','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(120,'product'   ,'MS_Material'    ,'THOUGH_OUT'      ,N''         ,'0'        ,6            ,'0'        ,'1'        ,1     ,'like' 	  ,'0'            ,''			  ,''                   ,'0'        ,'0'              ,'THOUGH_OUT'         ,''                      ,''         ,''		,''  ,'0','0')

		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(180,'product'   ,'MS_Material'    ,'ITEM_DESC'      ,N''      ,'0'        ,7            ,'0'        ,'0'        ,3     ,'like'      ,'0'            ,''             ,''                   ,'0'        ,'0'              ,'ITEM_DESC'          ,''                                                                                   ,''         ,''		,''  ,'0','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(150,'product'   ,'MS_Material'    ,'ORG_CODE'       ,N'ԭ'      ,'0'        ,9            ,'0'        ,'1'        ,1      ,'like'     ,'0'            ,''             ,''                   ,'0'        ,'0'              ,'ORG_CODE'           ,''                                                                                   ,''         ,''		,''  ,'0','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(120,'product'   ,'MS_Material'    ,'STATUS'      	  ,N'ñ־'      ,'1'        ,-1           ,'0'        ,'1'        ,2      ,'='        ,'0'            ,'usedstatus'   ,''                   ,'0'        ,'1'              ,'isnull(a.STATUS,0)' ,''                                                                                   ,''         ,''		,''  ,'0','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(200,'product'   ,'MS_Material'    ,'dp.DEPT_NAME'    ,N''     ,'0'        ,10            ,'0'        ,'1'        ,3     ,'rlike'     ,'0'             ,'dept'        ,'P'                  ,'1'        ,'1'              ,'dp.DEPT_CODE'      ,'left join	MS_Dept	dp with(nolock) on(a.DEPT_ID=dp.DEPT_ID)'                                ,''         ,''		,'1'  ,'0','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(0,  'product'   ,'MS_Material'    ,'ITEM_PECULIARITY',N'λ'         ,'0'        ,12           ,'0'        ,'1'        ,3      ,'like'     ,'0'            ,'itemattribute4' ,''                 ,'1'        ,'1'          		,'p4.CODE_ID'     ,'left join MS_ItemPeculiarity p with(nolock) on(a.ITEM_PECULIARITY=p.PECULIARITY_ID) left join MS_DataSet p4 with(nolock) on(p.ATTRIBUTE4_ID=p4.DATA_ID)'                      ,''         ,''		,''  ,'0','0')
		insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(120,'product'   ,'MS_Material'    ,'BLANK_OUT'       ,N'ʹñ־'     ,'1'        ,-1           ,'0'        ,'1'        ,4      ,'='        ,'0'            ,'blank_out'     ,''                  ,'0'        ,'1'              ,'isnull(a.BLANK_OUT,0)',''                                                                                   ,''         ,''		,''  ,'0','0')
	    insert into DataQueryMap(width,queryname  ,tablename  ,fieldname  ,displayname ,datatype ,displayseq ,iskey, isfilter ,ui_row ,filtertype ,isreturnfield ,f2_id ,action ,isouttable ,filterbyouttable ,filterfield ,joinsql,fix_filter,isorder,isdeptfilter,isuserfilter,issum)values(200,'product'   ,'MS_Material'    ,'ITEM_FORM'       ,N'ƷԴ'     ,'1'        ,-1           ,'0'        ,'1'        ,-1     ,''         ,'0'            ,''              ,''                  ,'0'        ,'1'              ,'isnull(a.ITEM_FORM,0)' ,''                                                                                   ,''         ,''		,''  ,'0','0')
