Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="UTF-8"?>
- <ReportMetadataExt>
- <SQLSelect>
- select CAR_ID, CAR_CST_ID, Cst_Name, CAR_NOREFUEL, CAR_GARNO, CAR_GOSNO, CAR_MODEL, CAR_BALLTYPE, CAR_BALLCOUNT,
- CAR_VOLUME, CAR_DATECERT, CAR_COMMENT, CST_DEPT, DEPT_NAME
- from Cars
- join Customers on Cst_ID=Car_Cst_ID
- join Depts on Dept_ID=Cst_Dept
- where CAR_DELETED=0 and (Cst_Dept=@dept or @dept=0) and (CAR_CST_ID=@CST_ID or @CST_ID=0)
- order by Car_Cst_ID,Car_GarNo</SQLSelect>
- <SQLInsert>
- insert into Cars(CAR_ID, CAR_CST_ID, CAR_NOREFUEL, CAR_GARNO, CAR_GOSNO, CAR_MODEL,
- CAR_BALLTYPE, CAR_BALLCOUNT, CAR_VOLUME, CAR_DATECERT, CAR_COMMENT)
- values(@CAR_ID, @CAR_CST_ID, @CAR_NOREFUEL, @CAR_GARNO, @CAR_GOSNO, @CAR_MODEL,
- @CAR_BALLTYPE, @CAR_BALLCOUNT, @CAR_VOLUME, @CAR_DATECERT, @CAR_COMMENT)
- returning CAR_ID</SQLInsert>
- <SQLUpdate>
- update Cars
- set CAR_CST_ID=@CAR_CST_ID,
- CAR_NOREFUEL=@CAR_NOREFUEL,
- CAR_GARNO=@CAR_GARNO,
- CAR_GOSNO=@CAR_GOSNO,
- CAR_MODEL=@CAR_MODEL,
- CAR_BALLTYPE=@CAR_BALLTYPE,
- CAR_BALLCOUNT=@CAR_BALLCOUNT,
- CAR_VOLUME=@CAR_VOLUME,
- CAR_DATECERT=@CAR_DATECERT,
- CAR_COMMENT=@CAR_COMMENT
- where Car_ID=@old_Car_ID</SQLUpdate>
- <SQLDelete>
- delete from Cars
- where Car_ID=@old_Car_ID</SQLDelete>
- <SQLRefresh>
- select CAR_ID, CAR_CST_ID, Cst_Name, CAR_NOREFUEL, CAR_GARNO, CAR_GOSNO, CAR_MODEL, CAR_BALLTYPE, CAR_BALLCOUNT,
- CAR_VOLUME, CAR_DATECERT, CAR_COMMENT, CST_DEPT, DEPT_NAME
- from Cars
- join Customers on Cst_ID=Car_Cst_ID
- join Depts on Dept_ID=Cst_Dept
- where Car_ID=@old_Car_ID</SQLRefresh>
- <Metadata __type="KahesSoft.Data.ReportMetadata, KahesSoft.Data" Name="Cars" IsReadOnly="n">
- <Params>
- <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" />
- <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" />
- </Params>
- <Fields>
- <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_ID" Type="int" DbType="Int32" UserName="ID" Format="" Visible="y" Order="0" InPrimaryKey="y" />
- <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_CST_ID" Type="int" DbType="Int32" UserName="ID клиента" Format="" Visible="y" Order="1" InPrimaryKey="n" />
- <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CST_NAME" Type="string" DbType="String" UserName="Название клиента" Format="" Visible="y" Order="2" InPrimaryKey="n" />
- <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_NOREFUEL" Type="bool" DbType="Boolean" UserName="Запрет заправки" Format="" Visible="y" Order="3" InPrimaryKey="n" />
- <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_GARNO" Type="int" DbType="Int32" UserName="Гар.№" Format="" Visible="y" Order="4" InPrimaryKey="n" />
- <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_GOSNO" Type="string" DbType="String" UserName="Гос.№" Format="" Visible="y" Order="5" InPrimaryKey="n" />
- <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_MODEL" Type="string" DbType="String" UserName="Марка" Format="" Visible="y" Order="6" InPrimaryKey="n" />
- <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_BALLTYPE" Type="int" DbType="Int32" UserName="Тип баллонов" Format="" Visible="y" Order="7" InPrimaryKey="n" />
- <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_BALLCOUNT" Type="int" DbType="Int32" UserName="Кол-во баллонов" Format="" Visible="y" Order="8" InPrimaryKey="n" />
- <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_VOLUME" Type="int" DbType="Int32" UserName="Объем" Format="" Visible="y" Order="9" InPrimaryKey="n" />
- <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" />
- <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CAR_COMMENT" Type="string" DbType="String" UserName="Комментарий" Format="" Visible="y" Order="11" InPrimaryKey="n" />
- <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="CST_DEPT" Type="int" DbType="Int32" UserName="ID подразделения" Format="" Visible="y" Order="12" InPrimaryKey="n" />
- <o __type="KahesSoft.Data.ReportMetadataField, KahesSoft.Data" Name="DEPT_NAME" Type="string" DbType="String" UserName="Подразделение" Format="" Visible="y" Order="13" InPrimaryKey="n" />
- </Fields>
- </Metadata>
- </ReportMetadataExt>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement