Advertisement
Guest User

xml from generated code

a guest
Aug 12th, 2010
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 4.99 KB | None | 0 0
  1. <?xml version="1.0" encoding="UTF-8"?>
  2.  
  3. <ReportMetadataExt>
  4.   <SQLSelect>
  5. select CAR_ID, CAR_CST_ID, Cst_Name, CAR_NOREFUEL, CAR_GARNO, CAR_GOSNO, CAR_MODEL, CAR_BALLTYPE, CAR_BALLCOUNT,
  6.        CAR_VOLUME, CAR_DATECERT, CAR_COMMENT, CST_DEPT, DEPT_NAME
  7. from Cars
  8.  join Customers on Cst_ID=Car_Cst_ID
  9.  join Depts on Dept_ID=Cst_Dept
  10.  
  11. where CAR_DELETED=0 and (Cst_Dept=@dept or @dept=0) and (CAR_CST_ID=@CST_ID or @CST_ID=0)
  12. order by Car_Cst_ID,Car_GarNo</SQLSelect>
  13.   <SQLInsert>
  14. insert into Cars(CAR_ID, CAR_CST_ID, CAR_NOREFUEL, CAR_GARNO, CAR_GOSNO, CAR_MODEL,
  15.                  CAR_BALLTYPE, CAR_BALLCOUNT, CAR_VOLUME, CAR_DATECERT, CAR_COMMENT)
  16. values(@CAR_ID, @CAR_CST_ID, @CAR_NOREFUEL, @CAR_GARNO, @CAR_GOSNO, @CAR_MODEL,
  17.        @CAR_BALLTYPE, @CAR_BALLCOUNT, @CAR_VOLUME, @CAR_DATECERT, @CAR_COMMENT)
  18. returning CAR_ID</SQLInsert>
  19.   <SQLUpdate>
  20. update Cars
  21. set CAR_CST_ID=@CAR_CST_ID,
  22.     CAR_NOREFUEL=@CAR_NOREFUEL,
  23.     CAR_GARNO=@CAR_GARNO,
  24.     CAR_GOSNO=@CAR_GOSNO,
  25.     CAR_MODEL=@CAR_MODEL,
  26.     CAR_BALLTYPE=@CAR_BALLTYPE,
  27.     CAR_BALLCOUNT=@CAR_BALLCOUNT,
  28.     CAR_VOLUME=@CAR_VOLUME,
  29.     CAR_DATECERT=@CAR_DATECERT,
  30.     CAR_COMMENT=@CAR_COMMENT
  31. where Car_ID=@old_Car_ID</SQLUpdate>
  32.   <SQLDelete>
  33. delete from Cars
  34. where Car_ID=@old_Car_ID</SQLDelete>
  35.   <SQLRefresh>
  36. select CAR_ID, CAR_CST_ID, Cst_Name, CAR_NOREFUEL, CAR_GARNO, CAR_GOSNO, CAR_MODEL, CAR_BALLTYPE, CAR_BALLCOUNT,
  37.        CAR_VOLUME, CAR_DATECERT, CAR_COMMENT, CST_DEPT, DEPT_NAME
  38. from Cars
  39.  join Customers on Cst_ID=Car_Cst_ID
  40.  join Depts on Dept_ID=Cst_Dept
  41.  
  42. where Car_ID=@old_Car_ID</SQLRefresh>
  43.   <Metadata __type="KahesSoft.Data.ReportMetadata, KahesSoft.Data" Name="Cars" IsReadOnly="n">
  44.     <Params>
  45.       <o __type="KahesSoft.Data.ReportMetadataParam, KahesSoft.Data" Name="dept" Type="int" DbType="Int32" RefTable="Depts" UserName="Подразделение" Format="" DefaultValue_type="int" DefaultValue="0" Mask="" AllStr="0" />
  46.       <o __type="KahesSoft.Data.ReportMetadataParam, KahesSoft.Data" Name="cst_id" Type="int" DbType="Int32" RefTable="Customers" UserName="Клиент" Format="" DefaultValue_type="int" DefaultValue="0" Mask="" AllStr="0" />
  47.     </Params>
  48.     <Fields>
  49.       <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_ID" Type="int" DbType="Int32" UserName="ID" Format="" Visible="y" Order="0" InPrimaryKey="y" />
  50.       <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_CST_ID" Type="int" DbType="Int32" UserName="ID клиента" Format="" Visible="y" Order="1" InPrimaryKey="n" />
  51.       <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CST_NAME" Type="string" DbType="String" UserName="Название клиента" Format="" Visible="y" Order="2" InPrimaryKey="n" />
  52.       <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_NOREFUEL" Type="bool" DbType="Boolean" UserName="Запрет заправки" Format="" Visible="y" Order="3" InPrimaryKey="n" />
  53.       <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_GARNO" Type="int" DbType="Int32" UserName="Гар.№" Format="" Visible="y" Order="4" InPrimaryKey="n" />
  54.       <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_GOSNO" Type="string" DbType="String" UserName="Гос.№" Format="" Visible="y" Order="5" InPrimaryKey="n" />
  55.       <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_MODEL" Type="string" DbType="String" UserName="Марка" Format="" Visible="y" Order="6" InPrimaryKey="n" />
  56.       <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_BALLTYPE" Type="int" DbType="Int32" UserName="Тип баллонов" Format="" Visible="y" Order="7" InPrimaryKey="n" />
  57.       <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_BALLCOUNT" Type="int" DbType="Int32" UserName="Кол-во баллонов" Format="" Visible="y" Order="8" InPrimaryKey="n" />
  58.       <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_VOLUME" Type="int" DbType="Int32" UserName="Объем" Format="" Visible="y" Order="9" InPrimaryKey="n" />
  59.       <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_DATECERT" Type="System.DateTime" DbType="Date" UserName="Дата освидетельствования" Format="dd.mm.yyyy" Visible="y" Order="10" InPrimaryKey="n" />
  60.       <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_COMMENT" Type="string" DbType="String" UserName="Комментарий" Format="" Visible="y" Order="11" InPrimaryKey="n" />
  61.       <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CST_DEPT" Type="int" DbType="Int32" UserName="ID подразделения" Format="" Visible="y" Order="12" InPrimaryKey="n" />
  62.       <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="DEPT_NAME" Type="string" DbType="String" UserName="Подразделение" Format="" Visible="y" Order="13" InPrimaryKey="n" />
  63.     </Fields>
  64.   </Metadata>
  65. </ReportMetadataExt>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement