001.<%@ Page
002. Title="FGS : TAG Information"
003. Language="C#"
004. MasterPageFile="~/Theme.Master"
005. AutoEventWireup="true"
006. CodeBehind="index.aspx.cs"
007. Inherits="Check_Stock.index" %>
008.
009.<asp:Content
010. ID="Body"
011. ContentPlaceHolderID="Body"
012. runat="server">
013.
014. <telerik:RadScriptManager
015. ID="RadScriptManager"
016. runat="server">
017. </telerik:RadScriptManager>
018.
019. <telerik:RadAjaxManager
020. ID="RadAjaxManager"
021. runat="server">
022.
023. <AjaxSettings>
024. <telerik:AjaxSetting
025. AjaxControlID="btn_search">
026.
027. <UpdatedControls>
028. <telerik:AjaxUpdatedControl
029. ControlID="RadGrid_Temp"
030. LoadingPanelID="RadAjaxLoadingPanel" />
031. <telerik:AjaxUpdatedControl
032. ControlID="RadGrid_Stock"
033. LoadingPanelID="RadAjaxLoadingPanel" />
034. <telerik:AjaxUpdatedControl
035. ControlID="RadGrid_Sale"
036. LoadingPanelID="RadAjaxLoadingPanel" />
037. </UpdatedControls>
038. </telerik:AjaxSetting>
039. </AjaxSettings>
040. </telerik:RadAjaxManager>
041.
042. <telerik:RadAjaxLoadingPanel
043. ID="RadAjaxLoadingPanel"
044. runat="server"
045. Skin="Default">
046. </telerik:RadAjaxLoadingPanel>
047.
048. <center>
049. <div>
050. <table style="font-family:Tahoma; font-size:14px; text-align:center;">
051. <tr >
052. <td style="height: 30px">
053. <asp:Label ID="Label1" runat="server" Text="รูปแบบการค้นหาข้อมูล"></asp:Label>
054. </td>
055. </tr>
056.
057. <tr style="height:50px; text-align:center;">
058. <td>
059. <asp:RadioButtonList ID="radSearchType" runat="server" CellPadding="5"
060. CellSpacing="5" RepeatLayout="Flow">
061. <asp:ListItem Value="Pallet" Text="หมายเลข TAG" Selected="True"></asp:ListItem>
062. <asp:ListItem Value="Serial" Text="หมายเลข Serial"></asp:ListItem>
063. <asp:ListItem Value="Mix" Text="ข้อมูลการ Mix"></asp:ListItem>
064. </asp:RadioButtonList>
065. </td>
066. </tr>
067.
068. <tr style="height:20px; text-align:center;" >
069. <td>
070. </td>
071. </tr>
072.
073. <tr style="height:40px; text-align:center;" >
074. <td>
075. <telerik:RadTextBox ID="txt_palletcode" runat="server" Width="200px"></telerik:RadTextBox>
076. </td>
077. </tr>
078.
079. <tr style="height:50px;">
080. <td>
081. <asp:Button ID="btn_search" runat="server" Width="80px" Text="ค้นหา" onclick="btn_search_Click" />
082. </td>
083. </tr>
084. </table>
085. </div>
086.
087. <br />
088. <table style="font-family:Tahoma; font-size:14px; text-align:left;">
089. <tr style="height:25px;">
090. <td><asp:Label ID="lbl_temp" runat="server" Text="ข้อมูล TAG ที่ส่งมาจาก RNT"></asp:Label></td>
091. <td><asp:Label ID="lbl_stock" runat="server" Text="ข้อมูลปัจจุบันใน Stock FG"></asp:Label></td>
092. <td><asp:Label ID="lbl_issue" runat="server" Text="ข้อมูลการขาย"></asp:Label></td>
093. </tr>
094.
095. <tr>
096. <td style="text-align:left; vertical-align:top; width:300px;">
097. <div>
098. <telerik:RadGrid
099. ID="RadGrid_Temp"
100. runat=server
101. AutoGenerateColumns="False"
102. DataSourceID="DS_Temp_Header"
103. GridLines="None"
104. Skin="Web20"
105. Width="265px">
106.
107. <MasterTableView
108. DataSourceID="DS_Temp_Header"
109. DataKeyNames="PalletCode">
110.
111. <Columns>
112. <telerik:GridBoundColumn
113. DataField="PalletCode"
114. HeaderText="PalletCode"
115. SortExpression="PalletCode"
116. UniqueName="PalletCode">
117.
118. <HeaderStyle Width="80px" />
119. <ItemStyle HorizontalAlign="Left" />
120. </telerik:GridBoundColumn>
121.
122. <telerik:GridBoundColumn
123. DataField="Qty"
124. DataType="System.Int32"
125. HeaderText="Qty"
126. ReadOnly="True"
127. SortExpression="Qty"
128. UniqueName="Qty">
129.
130. <HeaderStyle Width="80px" />
131. <ItemStyle HorizontalAlign="Right" />
132. </telerik:GridBoundColumn>
133.
134. <telerik:GridBoundColumn
135. DataField="LogDate"
136. HeaderText="LogDate"
137. SortExpression="LogDate"
138. UniqueName="LogDate">
139.
140. <HeaderStyle Width="80px" />
141. <ItemStyle HorizontalAlign="Center" />
142. </telerik:GridBoundColumn>
143. </Columns>
144.
145. <DetailTables>
146. <telerik:GridTableView
147. runat="server"
148. DataKeyNames="SerialCode"
149. DataSourceID="DS_Temp_Item"
150. Name="Detail">
151.
152. <ParentTableRelation>
153. <telerik:GridRelationFields
154. DetailKeyField="PalletCode"
155. MasterKeyField="PalletCode" />
156. </ParentTableRelation>
157.
158. <Columns>
159. <telerik:GridBoundColumn
160. DataField="No"
161. HeaderText="ลำดับที่"
162. SortExpression="No"
163. UniqueName="No">
164.
165. <HeaderStyle Width="80px" />
166. <ItemStyle HorizontalAlign="Left" />
167. </telerik:GridBoundColumn>
168.
169. <telerik:GridBoundColumn
170. DataField="SerialCode"
171. HeaderText="SerialCode"
172. SortExpression="SerialCode"
173. UniqueName="SerialCode">
174.
175. <HeaderStyle Width="160px" />
176. <ItemStyle HorizontalAlign="Left" />
177. </telerik:GridBoundColumn>
178. </Columns>
179. </telerik:GridTableView>
180. </DetailTables>
181. </MasterTableView>
182. </telerik:RadGrid>
183.
184. <asp:SqlDataSource
185. ID="DS_Temp_Header"
186. runat="server"
187. ConnectionString="<%$ ConnectionStrings:ConSOH_SD_SD %>">
188. </asp:SqlDataSource>
189.
190. <asp:SqlDataSource
191. ID="DS_Temp_Item"
192. runat="server"
193. ConnectionString="<%$ ConnectionStrings:ConSOH_SD_SD %>"
194. SelectCommand="SELECT ROW_NUMBER() OVER(ORDER BY SerialCode) AS No, SerialCode FROM t_JobRunningTmp WHERE (PalletCode = @PalletCode) ORDER BY SerialCode">
195.
196. <SelectParameters>
197. <asp:Parameter Name="PalletCode" />
198. </SelectParameters>
199. </asp:SqlDataSource>
200. </div>
201. </td>
202.
203. <td style="text-align:center; vertical-align:top; width:300px;">
204. <div>
205. <telerik:RadGrid
206. ID="RadGrid_Stock"
207. runat=server
208. AutoGenerateColumns="False"
209. DataSourceID="DS_Stock_Header"
210. GridLines="None"
211. Skin="Hay"
212. Width="265px">
213.
214. <MasterTableView
215. DataSourceID="DS_Stock_Header"
216. DataKeyNames="PalletCode" >
217.
218. <Columns>
219. <telerik:GridBoundColumn
220. DataField="PalletCode"
221. HeaderText="PalletCode"
222. SortExpression="PalletCode"
223. UniqueName="PalletCode">
224.
225. <HeaderStyle Width="80px" />
226. <ItemStyle HorizontalAlign="Left" />
227. </telerik:GridBoundColumn>
228.
229. <telerik:GridBoundColumn
230. DataField="Qty"
231. DataType="System.Int32"
232. HeaderText="Qty"
233. ReadOnly="True"
234. SortExpression="Qty"
235. UniqueName="Qty">
236.
237. <HeaderStyle Width="80px" />
238. <ItemStyle HorizontalAlign="Right" />
239. </telerik:GridBoundColumn>
240.
241. <telerik:GridBoundColumn
242. DataField="LogDate"
243. HeaderText="LogDate"
244. ReadOnly="True"
245. SortExpression="LogDate"
246. UniqueName="LogDate">
247.
248. <HeaderStyle Width="80px" />
249. <ItemStyle HorizontalAlign="Center" />
250. </telerik:GridBoundColumn>
251. </Columns>
252.
253. <DetailTables>
254. <telerik:GridTableView
255. runat="server"
256. DataKeyNames="SerialCode"
257. DataSourceID="DS_Stock_Item"
258. Name="Detail">
259.
260. <ParentTableRelation>
261. <telerik:GridRelationFields
262. DetailKeyField="PalletCode"
263. MasterKeyField="PalletCode" />
264. </ParentTableRelation>
265.
266. <Columns>
267. <telerik:GridBoundColumn
268. DataField="No"
269. HeaderText="ลำดับที่"
270. SortExpression="No"
271. UniqueName="No">
272.
273. <HeaderStyle Width="80px" />
274. <ItemStyle HorizontalAlign="Left" />
275. </telerik:GridBoundColumn>
276.
277. <telerik:GridBoundColumn
278. DataField="SerialCode"
279. HeaderText="SerialCode"
280. SortExpression="SerialCode"
281. UniqueName="SerialCode">
282.
283. <HeaderStyle Width="160px" />
284. <ItemStyle HorizontalAlign="Left" />
285. </telerik:GridBoundColumn>
286. </Columns>
287. </telerik:GridTableView>
288. </DetailTables>
289. </MasterTableView>
290. </telerik:RadGrid>
291.
292. <asp:SqlDataSource
293. ID="DS_Stock_Header"
294. runat="server"
295. ConnectionString="<%$ ConnectionStrings:ConSOH_SD_SD %>" >
296. </asp:SqlDataSource>
297.
298. <asp:SqlDataSource
299. ID="DS_Stock_Item"
300. runat="server"
301. ConnectionString="<%$ ConnectionStrings:ConSOH_SD_SD %>"
302.
303. SelectCommand="SELECT ROW_NUMBER() OVER(ORDER BY SerialCode) AS No, SerialCode FROM t_StockOnHand WHERE (PalletCode = @palletcode) ORDER BY SerialCode">
304.
305. <SelectParameters>
306. <asp:Parameter Name="PalletCode" />
307. </SelectParameters>
308. </asp:SqlDataSource>
309. </div>
310. </td>
311.
312. <td style="text-align:center; vertical-align:top; width:300px;">
313. <div>
314. <telerik:RadGrid
315. ID="RadGrid_Sale"
316. runat=server
317. AutoGenerateColumns="False"
318. DataSourceID="DS_Sale_Header"
319. GridLines="None"
320. Skin="Sunset"
321. Width="265px">
322.
323. <MasterTableView
324. DataSourceID="DS_Sale_Header"
325. DataKeyNames="PalletCode">
326.
327. <Columns>
328. <telerik:GridBoundColumn
329. DataField="PalletCode"
330. HeaderText="PalletCode"
331. SortExpression="PalletCode"
332. UniqueName="PalletCode">
333.
334. <HeaderStyle Width="80px" />
335. <ItemStyle HorizontalAlign="Left" />
336. </telerik:GridBoundColumn>
337.
338. <telerik:GridBoundColumn
339. DataField="Qty"
340. DataType="System.Int32"
341. HeaderText="Qty"
342. ReadOnly="True"
343. SortExpression="Qty"
344. UniqueName="Qty">
345.
346. <HeaderStyle Width="70px" />
347. <ItemStyle HorizontalAlign="Right" />
348. </telerik:GridBoundColumn>
349.
350. <telerik:GridBoundColumn
351. DataField="LogDate"
352. HeaderText="LogDate"
353. ReadOnly="True"
354. SortExpression="LogDate"
355. UniqueName="LogDate">
356.
357. <HeaderStyle Width="70px" />
358. <ItemStyle HorizontalAlign="Center" />
359. </telerik:GridBoundColumn>
360.
361. <telerik:GridBoundColumn
362. DataField="ZoneCode"
363. HeaderText="ZoneCode"
364. ReadOnly="True"
365. SortExpression="ZoneCode"
366. UniqueName="ZoneCode">
367.
368. <HeaderStyle Width="70px" />
369. <ItemStyle HorizontalAlign="Center" />
370. </telerik:GridBoundColumn>
371. </Columns>
372.
373. <DetailTables>
374. <telerik:GridTableView
375. runat="server"
376. DataKeyNames="SerialCode"
377. DataSourceID="DS_Sale_Item"
378. Name="Detail">
379.
380. <ParentTableRelation>
381. <telerik:GridRelationFields
382. DetailKeyField="PalletCode"
383. MasterKeyField="PalletCode" />
384. </ParentTableRelation>
385.
386. <Columns>
387. <telerik:GridBoundColumn
388. DataField="No"
389. HeaderText="ลำดับที่"
390. SortExpression="No"
391. UniqueName="No">
392.
393. <HeaderStyle Width="80px" />
394. <ItemStyle HorizontalAlign="Left" />
395. </telerik:GridBoundColumn>
396.
397. <telerik:GridBoundColumn
398. DataField="DocNo"
399. HeaderText="DocNo"
400. SortExpression="DocNo"
401. UniqueName="DocNo">
402.
403. <HeaderStyle Width="160px" />
404. <ItemStyle HorizontalAlign="Left" />
405. </telerik:GridBoundColumn>
406. </Columns>
407. </telerik:GridTableView>
408. </DetailTables>
409. </MasterTableView>
410. </telerik:RadGrid>
411.
412. <asp:SqlDataSource
413. ID="DS_Sale_Header"
414. runat="server"
415. ConnectionString="<%$ ConnectionStrings:ConSOH_SD_SD %>" >
416. </asp:SqlDataSource>
417.
418. <asp:SqlDataSource
419. ID="DS_Sale_Item"
420. runat="server"
421. ConnectionString="<%$ ConnectionStrings:ConSOH_SD_SD %>"
422. SelectCommand="SELECT ROW_NUMBER() OVER(ORDER BY SerialCode) AS No, SerialCode FROM t_GiDetail WHERE (PalletCode = @palletcode) ORDER BY SerialCode ">
423.
424. <SelectParameters>
425. <asp:Parameter Name="PalletCode" />
426. </SelectParameters>
427. </asp:SqlDataSource>
428. </div>
429. </td>
430. </tr>
431. </table>
432. </center>
433.</asp:Content>
