SMRST01700_실재고전산재고차이리스트(약국).xfdl 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRST01700" position="absolute 0 0 1201 777" titletext="실재고전산재고 차이리스트" oninit="SMRST01700_oninit" onload="SMRST01700_onload">
  5. <Layouts>
  6. <Layout>
  7. <Shape position="absolute 0 48 1195 109" id="roundrect1" type="roundrectangle"/>
  8. <Shape position="absolute 0 133 965 139" linetype="horizontal" id="line1" class="line_10"/>
  9. <Grid position="absolute 0 138 965 772" id="grd_rsthssstdifflist" binddataset="ds_main_rsthssstdifflist" oncellclick="grd_rsthssstdifflist_oncellclick">
  10. <Formats>
  11. <Format id="default">
  12. <Columns>
  13. <Column size="24"/>
  14. <Column size="78"/>
  15. <Column size="202"/>
  16. <Column size="98"/>
  17. <Column size="62"/>
  18. <Column size="60"/>
  19. <Column size="56"/>
  20. <Column size="72"/>
  21. <Column size="56"/>
  22. <Column size="74"/>
  23. <Column size="64"/>
  24. <Column size="78"/>
  25. <Column size="0"/>
  26. <Column size="0"/>
  27. <Column size="0"/>
  28. <Column size="0"/>
  29. </Columns>
  30. <Rows>
  31. <Row size="24" band="head"/>
  32. <Row size="24"/>
  33. </Rows>
  34. <Band id="head">
  35. <Cell/>
  36. <Cell col="1" text="약품코드"/>
  37. <Cell col="2" text="약품명칭"/>
  38. <Cell col="3" text="규격"/>
  39. <Cell col="4" text="단위"/>
  40. <Cell col="5" text="단가"/>
  41. <Cell col="6" text="재고량"/>
  42. <Cell col="7" text="재고금액"/>
  43. <Cell col="8" text="실사량"/>
  44. <Cell col="9" text="실사금액"/>
  45. <Cell col="10" text="차이수량"/>
  46. <Cell col="11" text="차이금액"/>
  47. <Cell col="12" text="기관코드"/>
  48. <Cell col="13" text="실사년월"/>
  49. <Cell col="14" text="부서"/>
  50. <Cell col="15" text="대분류"/>
  51. </Band>
  52. <Band id="body">
  53. <Cell celltype="head" expr="currow + 1"/>
  54. <Cell col="1" style="align:left top;padding:5 2 1 2;" text="bind:goodcd" wordwrap="word"/>
  55. <Cell col="2" style="align:left top;padding:5 2 1 2;" text="bind:goodnm" wordwrap="word"/>
  56. <Cell col="3" style="align:left top;padding:5 2 1 2;" text="bind:goodspec" wordwrap="word"/>
  57. <Cell col="4" text="bind:deliveunit" enable="false"/>
  58. <Cell col="5" displaytype="number" style="align:right middle;" text="bind:goodunitcost"/>
  59. <Cell col="6" displaytype="number" style="align:right middle;" text="bind:stocqty"/>
  60. <Cell col="7" displaytype="number" style="align:right middle;" text="bind:stocamt"/>
  61. <Cell col="8" displaytype="number" style="align:right middle;" text="bind:orginspqty"/>
  62. <Cell col="9" displaytype="number" style="align:right middle;" text="bind:orginspamt"/>
  63. <Cell col="10" displaytype="number" style="align:right middle;" text="bind:diffqty"/>
  64. <Cell col="11" displaytype="number" style="align:right middle;" text="bind:diffamt"/>
  65. <Cell col="12"/>
  66. <Cell col="13"/>
  67. <Cell col="14"/>
  68. <Cell col="15"/>
  69. </Band>
  70. </Format>
  71. </Formats>
  72. </Grid>
  73. <Calendar position="absolute 440 56 590 75" align="align:center middle;" id="ipt_orginspdd" class="input_essential" mask="yyyy-mm-dd"/>
  74. <Static text="실재고 전산재고 차이리스트" position="absolute 1 117 188 134" id="caption3" class="tit_2"/>
  75. <Button position="absolute 1125 67 1181 89" id="btn_search" class="btn1" text="조회" onclick="btn_search_onclick"/>
  76. <Shape position="absolute 1107 54 1113 99" linetype="vertical" id="line13" class="line_4"/>
  77. <Static text="대 분 류 :" position="absolute 345 113 443 130" id="cap_lrgcd" class="search_name" visible="false"/>
  78. <Static text="기관코드 :" position="absolute 15 57 101 74" id="cap_instcd" class="search_name"/>
  79. <Static text="실사 일자 :" position="absolute 345 57 446 74" id="cap_orginspdd" class="search_name"/>
  80. <Static text="부 서 :" position="absolute 15 83 114 100" id="cap_stocdeptcd" class="search_name"/>
  81. <Combo position="absolute 101 83 251 102" id="cmb_stocdeptcd" class="combo_essential"/>
  82. <Combo position="absolute 440 113 590 132" id="cmb_lrgcd" class="combo_essential" visible="false"/>
  83. <Edit readonly="true" position="absolute 100 56 250 75" align="align:center middle;" id="opt_instcdnm" class="output"/>
  84. <Edit readonly="true" position="absolute 300 78 320 97" id="opt_instcd" visible="false" class="output"/>
  85. <Static text="실사내역" position="absolute 970 117 1153 133" id="caption1" class="tit_2"/>
  86. <Shape position="absolute 970 133 1190 139" linetype="horizontal" id="line2" class="line_10"/>
  87. <Grid position="absolute 970 138 1191 773" id="grd_rsthssstlist" binddataset="ds_main_rsthssstlist" autoenter="select">
  88. <Formats>
  89. <Format id="default">
  90. <Columns>
  91. <Column size="24"/>
  92. <Column size="72"/>
  93. <Column size="60"/>
  94. <Column size="0"/>
  95. <Column size="0"/>
  96. <Column size="0"/>
  97. <Column size="0"/>
  98. <Column size="0"/>
  99. <Column size="0"/>
  100. <Column size="0"/>
  101. <Column size="0"/>
  102. <Column size="0"/>
  103. <Column size="0"/>
  104. <Column size="0"/>
  105. <Column size="77"/>
  106. </Columns>
  107. <Rows>
  108. <Row size="24" band="head"/>
  109. <Row size="24"/>
  110. </Rows>
  111. <Band id="head">
  112. <Cell/>
  113. <Cell col="1" text="실사자"/>
  114. <Cell col="2" text="실사량"/>
  115. <Cell col="3" text="기관코드"/>
  116. <Cell col="4" text="재고부서코드"/>
  117. <Cell col="5" text="실사년월"/>
  118. <Cell col="6" text="물품코드"/>
  119. <Cell col="7" text="입고단가"/>
  120. <Cell col="8" text="물품구분"/>
  121. <Cell col="9" text="대분류코드"/>
  122. <Cell col="10" text="재고수량"/>
  123. <Cell col="11" text="재고금액"/>
  124. <Cell col="12" text="재고조정처리여부"/>
  125. <Cell col="13" text="실사자ID"/>
  126. <Cell col="14" text="실사일자"/>
  127. </Band>
  128. <Band id="body">
  129. <Cell celltype="head"/>
  130. <Cell col="1" text="bind:orginspidnm"/>
  131. <Cell col="2" displaytype="number" edittype="masknumber" style="align:right;" text="bind:orginspqty" mask="#,##0"/>
  132. <Cell col="3" text="bind:instcd"/>
  133. <Cell col="4" text="bind:stocdeptcd"/>
  134. <Cell col="5" text="bind:orginspym"/>
  135. <Cell col="6" text="bind:goodcd"/>
  136. <Cell col="7" text="bind:stocseqno"/>
  137. <Cell col="8" text="bind:goodflag"/>
  138. <Cell col="9" text="bind:lrgcd"/>
  139. <Cell col="10" text="bind:stocqty"/>
  140. <Cell col="11" text="bind:stocamt"/>
  141. <Cell col="12" text="bind:stocadjttretyn"/>
  142. <Cell col="13" text="bind:orginspid"/>
  143. <Cell col="14" displaytype="date" text="bind:orginspdd" calendardisplaynulltype="none"/>
  144. </Band>
  145. </Format>
  146. </Formats>
  147. </Grid>
  148. <Button position="absolute 900 113 964 132" id="btn_excel_all" class="btn2" text="엑셀저장" onclick="btn_excel_all_onclick"/>
  149. <Edit readonly="true" position="absolute 280 53 330 72" id="opt_goodflag" visible="false"/>
  150. <Button position="absolute 1148 113 1190 132" id="btn_save" class="btn2" text="저장" onclick="btn_save_onclick"/>
  151. <Button position="absolute 825 83 841 99" id="btn_searchgoodcd" class="icon_search" text="" onclick="btn_searchgoodcd_onclick"/>
  152. <Edit position="absolute 844 82 1059 101" id="ipt_goodnm" class="input_fix" onkeydown="ipt_goodnm_onkeydown"/>
  153. <Edit position="absolute 710 82 821 101" id="ipt_goodcd" class="input_essential" onkeydown="ipt_goodcd_onkeydown"/>
  154. <Static text="약품코드 :" position="absolute 625 83 720 100" id="caption2" class="search_name"/>
  155. <Div position="absolute 640 111 1055 276" id="group2" visible="false" style="background:beige;">
  156. <Layouts>
  157. <Layout>
  158. <Grid position="absolute 2 25 412 164" id="grd_goodlist" visible="true" binddataset="ds_hidden_main_goodlist" anchor="default" oncelldblclick="group2_grd_goodlist_oncelldblclick">
  159. <Formats>
  160. <Format id="default">
  161. <Columns>
  162. <Column size="24"/>
  163. <Column size="102"/>
  164. <Column size="265"/>
  165. <Column size="0"/>
  166. <Column size="0"/>
  167. </Columns>
  168. <Rows>
  169. <Row size="24" band="head"/>
  170. <Row size="24"/>
  171. </Rows>
  172. <Band id="head">
  173. <Cell/>
  174. <Cell col="1" text="약품코드"/>
  175. <Cell col="2" text="약품명"/>
  176. <Cell col="3" text="기관코드"/>
  177. <Cell col="4" text="물품구분"/>
  178. </Band>
  179. <Band id="body">
  180. <Cell celltype="head"/>
  181. <Cell col="1" displaytype="text" edittype="none" text="bind:goodcd"/>
  182. <Cell col="2" displaytype="text" edittype="none" text="bind:goodnm"/>
  183. <Cell col="3" text="bind:instcd"/>
  184. <Cell col="4" text="bind:goodflag"/>
  185. </Band>
  186. </Format>
  187. </Formats>
  188. </Grid>
  189. <Button position="absolute 340 4 393 23" id="button5" class="btn2" text="숨기기" anchor="default" onclick="group2_button5_onclick"/>
  190. </Layout>
  191. </Layouts>
  192. </Div>
  193. <Button position="absolute 235 111 331 133" id="btn_scroll" class="btn1" visible="false" text="스크롤 버튼" onclick="btn_scroll_onclick"/>
  194. <Calendar position="absolute 710 57 821 76" align="align:center middle;" id="ipt_orginspym" class="input_essential" mask="yyyy-mm"/>
  195. <Static text="재고년월 :" position="absolute 625 58 727 75" id="cap_orginspym" class="search_name"/>
  196. <Combo position="absolute 440 83 590 102" id="cmb_mngtcls" class="combo_essential"/>
  197. <Static text="관리분류 :" position="absolute 345 83 433 100" id="caption4" class="search_name"/>
  198. <Static id="caption6" text="실재고전산재고 차이리스트(약국)" class="tit_1" position="absolute 0 0 243 25"/>
  199. <Button id="btn_print" taborder="1" text="리스트출력" class="btn6" visible="false" position="absolute 0 26 92 48"/>
  200. <Button id="btn_init" taborder="2" text="초기화" class="btn4" position="absolute 1127 26 1195 48" onclick="btn_init_onclick"/>
  201. </Layout>
  202. </Layouts>
  203. <Objects>
  204. <Dataset id="ds_main_rsthssstdifflist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  205. <Dataset id="ds_main_rsthssstlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  206. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_oncolumnchanged">
  207. <ColumnInfo>
  208. <Column id="instcd" type="STRING" size="256"/>
  209. <Column id="goodflag" type="STRING" size="256"/>
  210. <Column id="orginspdd" type="STRING" size="256"/>
  211. <Column id="stocdeptcd" type="STRING" size="256"/>
  212. <Column id="lrgcd" type="STRING" size="256"/>
  213. <Column id="instcdnm" type="STRING" size="256"/>
  214. <Column id="goodcd" type="STRING" size="256"/>
  215. <Column id="rsthssstlist" type="STRING" size="256"/>
  216. <Column id="orginspym" type="STRING" size="256"/>
  217. <Column id="mngtcls" type="STRING" size="256"/>
  218. </ColumnInfo>
  219. <Rows>
  220. <Row>
  221. <Col id="instcd"/>
  222. <Col id="goodflag"/>
  223. <Col id="orginspdd"/>
  224. <Col id="stocdeptcd"/>
  225. <Col id="lrgcd"/>
  226. <Col id="instcdnm"/>
  227. <Col id="goodcd"/>
  228. <Col id="rsthssstlist"/>
  229. <Col id="orginspym"/>
  230. <Col id="mngtcls"/>
  231. </Row>
  232. </Rows>
  233. </Dataset>
  234. <Dataset id="ds_goodinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  235. <ColumnInfo>
  236. <Column id="goodcd" type="STRING" size="256"/>
  237. <Column id="goodnm" type="STRING" size="256"/>
  238. </ColumnInfo>
  239. <Rows>
  240. <Row>
  241. <Col id="goodcd"/>
  242. <Col id="goodnm"/>
  243. </Row>
  244. </Rows>
  245. </Dataset>
  246. <Dataset id="ds_hidden_main_goodlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  247. <Dataset id="ds_tmp_chkinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  248. <ColumnInfo>
  249. <Column id="goodcd" type="STRING" size="256"/>
  250. </ColumnInfo>
  251. <Rows>
  252. <Row>
  253. <Col id="goodcd"/>
  254. </Row>
  255. </Rows>
  256. </Dataset>
  257. <Dataset id="ds_send_rsthssstlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  258. <Dataset id="ds_cond_goodiolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  259. </Objects>
  260. <Bind>
  261. <BindItem id="item0" compid="opt_instcdnm" propid="value" datasetid="ds_send" columnid="instcdnm"/>
  262. <BindItem id="item1" compid="opt_goodflag" propid="value" datasetid="ds_send" columnid="goodflag"/>
  263. <BindItem id="item2" compid="ipt_orginspdd" propid="value" datasetid="ds_send" columnid="orginspdd"/>
  264. <BindItem id="item3" compid="ipt_orginspym" propid="value" datasetid="ds_send" columnid="orginspym"/>
  265. <BindItem id="item4" compid="cmb_stocdeptcd" propid="value" datasetid="ds_send" columnid="stocdeptcd"/>
  266. <BindItem id="item5" compid="opt_instcd" propid="value" datasetid="ds_send" columnid="instcd"/>
  267. <BindItem id="item6" compid="cmb_mngtcls" propid="value" datasetid="ds_send" columnid="mngtcls"/>
  268. <BindItem id="item7" compid="ipt_goodcd" propid="value" datasetid="ds_goodinfo" columnid="goodcd"/>
  269. <BindItem id="item8" compid="ipt_goodnm" propid="value" datasetid="ds_goodinfo" columnid="goodnm"/>
  270. <BindItem id="item9" compid="cmb_lrgcd" propid="value" datasetid="ds_send" columnid="lrgcd"/>
  271. </Bind>
  272. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  273. * System Name :
  274. * Job Name :
  275. * Creator :
  276. * Make Date : 2017-06-19
  277. * Description :
  278. *---------------------------------------------------------------------------------------
  279. * Modify Date Modifier Modify Description
  280. *---------------------------------------------------------------------------------------
  281. * 2017-06-19 Live Converter TF->XP
  282. *
  283. *---------------------------------------------------------------------------------------
  284. ****************************************************************************************/
  285. include "com_commonxp::comm_main.xjs";
  286. include "mis_miscommonxp::MIS.xjs";
  287. include "mis_miscommonxp::PIC002.xjs";
  288. include "mis_miscommonxp::RAC001.xjs";
  289. include "mis_miscommonxp::RBC001.xjs";
  290. include "mis_miscommonxp::RSZ001.xjs";
  291. var arErrorCode = new HashArray();
  292. function SMRST01700_oninit(obj:Form, e:InitEventInfo)
  293. {
  294. frmf_initForm(obj); //폼 초기화
  295. grdf_setRowTypeIcon(grd_rsthssstlist, 0);
  296. grdf_setRowTypeIcon(group2.grd_goodlist, 0);
  297. }
  298. function SMRST01700_onload(obj:Form, e:LoadEventInfo)
  299. {
  300. //화면 Control을 초기화한다
  301. fInitialize();
  302. }
  303. // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
  304. function fInitialize()
  305. {
  306. misfGridInit(grd_rsthssstdifflist);
  307. misfGridInit(grd_rsthssstlist);
  308. // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
  309. misfComboComCdList("030M0003",cmb_mngtcls,"Y");
  310. rszfComboStockArthDeptcdList("cmb_stocdeptcd", sysf_getUserInfo("dutplceinstcd"),"PH" );
  311. //misfMsterDetailSet(grd_rsthssstlist, null, "TRRST00201", "Y");
  312. opt_instcd.value = sysf_getUserInfo("dutplceinstcd");
  313. opt_instcdnm.value = sysf_getUserInfo("dutplceinstnm");
  314. // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
  315. opt_goodflag.value = "PH";
  316. var curdd = utlf_getCurrentDate();
  317. ipt_orginspdd.value = curdd;
  318. ipt_orginspym.value = curdd.substr(0,6);
  319. // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
  320. rszfGridComboLrgcdList("PH", "cmb_lrgcd", "lrgcd","N");
  321. }
  322. function btn_search_onclick(obj:Button, e:ClickEventInfo)
  323. {
  324. misfGridInit(grd_rsthssstdifflist);
  325. misfGridInit(grd_rsthssstlist);
  326. if(fCheckRetrieveData(false) == false)return;
  327. ds_send.setColumn(0, "goodcd", ds_goodinfo.getColumn(0, "goodcd"));
  328. ds_send.setColumn(0, "orginspym", ds_send.getColumn(0, "orginspym").substr(0,6));
  329. var oParam = {};
  330. oParam.id = "TRRST01701";
  331. oParam.service = "stocsumapp.StocSumMngt";
  332. oParam.method = "reqGetRsthssstDiffList";
  333. oParam.inds = "req=ds_send";
  334. oParam.outds = "ds_main_rsthssstdifflist=rsthssstdifflist";
  335. oParam.async = false;
  336. tranf_submit(oParam);
  337. if(utlf_isNull(ds_tmp_chkinfo.getColumn(0, "goodcd"))){
  338. ds_main_rsthssstdifflist.rowposition = 0;
  339. }else{
  340. for(var i = 0; i < ds_main_rsthssstdifflist.rowcount; i++) {
  341. if( ds_main_rsthssstdifflist.getColumn(i, "goodcd") == ds_tmp_chkinfo.getColumn(0, "goodcd") ) {
  342. ds_main_rsthssstdifflist.rowposition = i;
  343. break;
  344. }
  345. }
  346. btn_scroll_onclick();
  347. }
  348. grd_rsthssstdifflist_oncellclick();
  349. }
  350. function fCheckRetrieveData()
  351. {
  352. if(!frmf_isRequiredControls("opt_goodflag") )return false; // 물품구분
  353. if(!frmf_isRequiredControls("ipt_orginspdd") )return false; // 실사일자
  354. if(!frmf_isRequiredControls("cmb_stocdeptcd") )return false; // 부서코드
  355. //if(!isRequiredControls("cmb_lrgcd") )return false; // 대분류
  356. }
  357. function btn_scroll_onclick(obj:Button, e:ClickEventInfo)
  358. {
  359. var iRow = ds_main_rsthssstdifflist.rowcount - 1;
  360. grd_rsthssstdifflist.setFocus();
  361. ds_main_rsthssstdifflist.selectRow(iRow, true);
  362. }
  363. function grd_rsthssstdifflist_oncellclick(obj:Grid, e:GridClickEventInfo)
  364. {
  365. misfGridInit(grd_rsthssstlist);
  366. if (ds_main_rsthssstdifflist.rowcount == 0) return;
  367. ds_tmp_chkinfo.setColumn(0, "goodcd");
  368. dsf_makeValue(ds_tmp_chkinfo, "goodcd", "string", ds_main_rsthssstdifflist.getColumn(ds_main_rsthssstdifflist.rowposition, "goodcd"));
  369. ds_send.setColumn(0, "goodcd", ds_main_rsthssstdifflist.getColumn(ds_main_rsthssstdifflist.rowposition, "goodcd"));
  370. var oParam = {};
  371. oParam.id = "TRRST00201";
  372. oParam.service = "stocsumapp.StocSumMngt";
  373. oParam.method = "reqGetRsthssstList";
  374. oParam.inds = "req=ds_send";
  375. oParam.outds = "ds_main_rsthssstlist=rsthssstlist";
  376. oParam.async = false;
  377. tranf_submit(oParam);
  378. }
  379. function btn_excel_all_onclick(obj:Button, e:ClickEventInfo)
  380. {
  381. grdf_exportExcel(grd_rsthssstdifflist, "실재고전산재고 차이리스트" + utlf_getCurrentDate(), "sheetname1" , true, "" , "" , true);
  382. }
  383. function btn_save_onclick(obj:Button, e:ClickEventInfo)
  384. {
  385. for(var fRow = 0; fRow < ds_main_rsthssstlist.rowcount; fRow++)
  386. {
  387. if(utlf_isNull(ds_main_rsthssstlist.getColumn(fRow, "orginspqty")))
  388. {
  389. sysf_messageBox("실사량은","I003");
  390. return;
  391. }
  392. }
  393. var data = grdf_getGridUpdateData(grd_rsthssstlist);
  394. grdf_setStatusColumn(data, "status");
  395. if(data.rowcount == 0)
  396. {
  397. sysf_messageBox("저장할 내용이","I004");
  398. return;
  399. }
  400. ds_send_rsthssstlist.copyData(data, true);
  401. ds_send_rsthssstlist.enableevent = false;
  402. ds_send_rsthssstlist.updatecontrol = false;
  403. dsf_setDefaultVal(ds_send_rsthssstlist, "orginspid:-");
  404. ds_send_rsthssstlist.updatecontrol = true;
  405. ds_send_rsthssstlist.enableevent = true;
  406. var oParam = {};
  407. oParam.id = "TXRST00201";
  408. oParam.service = "stocsumapp.StocSumMngt";
  409. oParam.method = "reqExeRsthssstList";
  410. oParam.inds = "req=ds_send_rsthssstlist";
  411. oParam.outds = "";
  412. oParam.async = false;
  413. tranf_submit(oParam);
  414. //btn_scroll_onclick();
  415. ds_tmp_chkinfo.setColumn(0, "goodcd");
  416. }
  417. function btn_searchgoodcd_onclick(obj:Button, e:ClickEventInfo)
  418. {
  419. dsf_makeValue(ds_cond_goodiolist, "instcd" , "string", ds_send.getColumn(0, "instcd"));
  420. dsf_makeValue(ds_cond_goodiolist, "goodflag", "string", "PH");
  421. dsf_makeValue(ds_cond_goodiolist, "goodcd" , "string", ds_goodinfo.getColumn(0, "goodcd"));
  422. var oParam = {};
  423. oParam.id = "TRRSD00192";
  424. oParam.service = "purccommonapp.PurcCommon";
  425. oParam.method = "reqGetPhamGoodListByCond";
  426. oParam.inds = "req=ds_cond_goodiolist";
  427. oParam.outds = "ds_hidden_main_goodlist=goodlist";
  428. oParam.async = false;
  429. oParam.callback = "cf_TRRSD00192";
  430. tranf_submit(oParam);
  431. if (arErrorCode.pop("TRRSD00192") > -1) {
  432. var nodecnts = ds_hidden_main_goodlist.rowcount;
  433. if (nodecnts > 1) {
  434. group2.visible = true;
  435. } else if (nodecnts == 1) {
  436. var goodcd = ds_hidden_main_goodlist.getColumn(0, "goodcd");
  437. var goodnm = ds_hidden_main_goodlist.getColumn(0, "goodnm");
  438. ds_goodinfo.setColumn(0, "goodcd" , goodcd)
  439. ds_goodinfo.setColumn(0, "goodnm" , goodnm)
  440. } else {
  441. sysf_messageBox("검색된 코드가 없습니다.", "I");
  442. }
  443. }
  444. }
  445. function cf_TRRSD00192(sSvcId, nErrorCode, sErrorMsg) {
  446. arErrorCode.push(sSvcId, nErrorCode);
  447. }
  448. function ds_send_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
  449. {
  450. if(e.columnid == "goodnm"){
  451. if(utlf_transNullToEmpty(ipt_goodnm.value).length == 0)
  452. {
  453. ipt_goodcd.value = "";
  454. }
  455. else {
  456. ds_goodinfo.setColumn(0, "goodcd", "")
  457. btn_searchgoodcd_onclick();
  458. }
  459. }
  460. }
  461. function ipt_goodnm_onkeydown(obj:Edit, e:KeyEventInfo)
  462. {
  463. if(e.keycode == 13){
  464. obj.updateToDataset();
  465. if(utlf_transNullToEmpty(ipt_goodnm.value).length == 0)
  466. {
  467. ipt_goodcd.value = "";
  468. }
  469. else {
  470. ds_goodinfo.setColumn(0, "goodcd", "");
  471. btn_searchgoodcd_onclick();
  472. }
  473. }
  474. }
  475. function ipt_goodcd_onkeydown(obj:Edit, e:KeyEventInfo)
  476. {
  477. if(e.keycode == 13){
  478. obj.updateToDataset();
  479. if(utlf_transNullToEmpty(ipt_goodcd.value).length == 0)
  480. {
  481. ipt_goodnm.value = "";
  482. }
  483. else {
  484. ds_goodinfo.setColumn(0, "goodnm", "");
  485. btn_searchgoodcd_onclick();
  486. }
  487. }
  488. }
  489. function group2_grd_goodlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
  490. {
  491. if (e.row >= 0 && e.col >= 0) {
  492. var goodcd = ds_hidden_main_goodlist.getColumn(ds_hidden_main_goodlist.rowposition, "goodcd");e
  493. var goodnm = ds_hidden_main_goodlist.getColumn(ds_hidden_main_goodlist.rowposition, "goodnm");
  494. ds_goodinfo.setColumn(0, "goodcd" , goodcd);
  495. ds_goodinfo.setColumn(0, "goodnm" , goodnm);
  496. group2.visible = false;
  497. }
  498. }
  499. function group2_button5_onclick(obj:Button, e:ClickEventInfo)
  500. {
  501. group2.visible = false
  502. }
  503. function btn_init_onclick(obj:Button, e:ClickEventInfo)
  504. {
  505. fInitialize();
  506. }
  507. ]]></Script>
  508. </Form>
  509. </FDL>