目的: V60202G-[物料盤點]鈕- 欄位值挑選 – 傳回多欄位 – 依欄位值挑選
處理說明:1>依欄位值挑選的按鈕, 設為一般按鈕(get_cmp_btn1),非 get_pick_btn1
--> 必免 btn.handler 和 btn.on('click', function(){}); 重覆
--> 或是將 .handler=null ,避色重覆觸發
var cmp_sub_MATNR = get_cmp_txt1('物料號碼', 'sub_MATNR', 120, 130);
var cmp_pick_sub_MATNR = get_cmp_btn1('..', 'btn_sub_MATNR',);
cmp_sub_MATNR.items.push(cmp_pick_sub_MATNR);
1.1>或是將 .handler=null , 以免重覆觸發
= get_pick_btn0('物料號碼','sub_MATNR',
''../api/V60202GAPI/get_sub_MATNRPick?isComplete=0',
['MATNR', 'WH', 'SP', 'QTY_'],
['sub_MATNR', 'sub_WH', 'sub_SP', 'sub_QTY_'],
J_pickstore_sub_MATNR, J_pickcolumns_sub_MATNR);
--> Ext.getCmp("sub_MATNR").handler=null;
2>Runtime 設定按鈕的url , &WH=encodeURIComponent(Tmp_WH)
-->若WH欄位值有特殊字元(#%$..),會錯誤,所以需加encodeURIComponent
--> 傳回多欄位,以 , 分隬
Ext.getCmp("btn_sub_MATNR").on("click", function (me, e, eOpts) {
var Tmp_WH = Ext.getCmp("sub_WH").getValue();
var Tmp_SP = Ext.getCmp("sub_SP").getValue();
var Tmp_URL = '../api/V60202GAPI/get_sub_MATNRPick?isComplete=0'
+ '&WH=' + encodeURIComponent(Tmp_WH)
+ '&SP=' + encodeURIComponent(Tmp_SP);
var win = EditPickx('物料編號', Tmp_URL,
['MATNR', 'WH', 'SP', 'QTY_'],
['sub_MATNR', 'sub_WH', 'sub_SP', 'sub_QTY_'],
J_pickstore_sub_MATNR,
J_pickcolumns_sub_MATNR);
win.show();
});

1>*.js
//挑選[物料編號] - 依[庫房]+[儲存位置] 過濾資料
Ext.getCmp("btn_sub_MATNR").on("click", function (me, e, eOpts) {
var Tmp_WH = Ext.getCmp("sub_WH").getValue();
var Tmp_SP = Ext.getCmp("sub_SP").getValue();
var Tmp_URL = '../api/V60202GAPI/get_sub_MATNRPick?isComplete=0'
+ '&WH=' + encodeURIComponent(Tmp_WH)
+ '&SP=' + encodeURIComponent(Tmp_SP);
var win = EditPickx('物料編號', Tmp_URL,
['MATNR', 'WH', 'SP', 'QTY_'],
['sub_MATNR', 'sub_WH', 'sub_SP', 'sub_QTY_'],
J_pickstore_sub_MATNR, J_pickcolumns_sub_MATNR);
win.show();
});
//挑選[儲存位置] - 依[庫房]過濾資料
Ext.getCmp("btn_sub_SP").on("click", function (me, e, eOpts) {
var Tmp_WH = Ext.getCmp("sub_WH").getValue();
var Tmp_MATNR = Ext.getCmp("sub_MATNR").getValue();
var Tmp_URL = '../api/V60202GAPI/get_sub_SPPick?isComplete=0'
+ '&WH=' + encodeURIComponent(Tmp_WH)
+ '&MATNR=' + encodeURIComponent(Tmp_MATNR)
;
var win = EditPickx('儲存位置', Tmp_URL, ['SP'], ['sub_SP'], J_pickstore_sub_SP, J_pickcolumns_sub_SP);
win.show();
});
2>*.cs//過濾條件 [物料號碼(MATNR)]挑選 - 依 WH+SP 過濾資料
//前端 encodeURIComponent(Tmp_WH) + encodeURIComponent(Tmp_SP)
//後端自己會解釋成正確的 WH+SP
[HttpPost]
public dynamic get_sub_MATNRPick(string MATNR = "",string WH="", string SP = "", int isComplete = 0)
{
//取得目前 AMM_COMP.MATNR
string Tmp_Sql = "", Tmp_Str = "";
string Tmp_MATNR;
Tmp_Sql = " SELECT MATNR, WH, SP, SUM(SQTY) AS QTY_ "
+ " FROM "
+ " (SELECT A.MATNR, A.WH, A.SP, "
+ "(A.QTY - (SELECT NVL(SUM(QTY), 0) FROM AMM_COMPQTY WHERE EFF = 'Y' AND CPNO = A.CPNO AND MATNR = A.MATNR)) AS SQTY "
+ " FROM AMM_COMP A "
+ " WHERE 1=1 ";
if (!myfunc.checkisnull(WH))
Tmp_Sql = Tmp_Sql + " AND WH=" + myfunc.AA(WH);
if (!myfunc.checkisnull(SP))
Tmp_Sql = Tmp_Sql + " AND SP=" + myfunc.AA(SP);
Tmp_Sql = Tmp_Sql
+ " ) "
+ " GROUP BY MATNR, WH, SP "
+ " ORDER BY MATNR, WH, SP ";
//Tmp_Sql = " SELECT DISTINCT MATNR,WH,SP "
// + " FROM AMM_COMP "
// + " WHERE 1=1 "
// + " AND MATNR IS NOT NULL ";
//if (!myfunc.checkisnull(WH))
// Tmp_Sql = Tmp_Sql + " AND WH=" + myfunc.AA(WH);
//if (!myfunc.checkisnull(SP))
// Tmp_Sql = Tmp_Sql + " AND SP=" + myfunc.AA(SP);
//Tmp_Sql = Tmp_Sql+ " ORDER BY MATNR ";
string n = funId + "_sub_MATNR";
DataSet ds = setupPickDs(n, Tmp_Sql, new string[] { "AMM_COMP" },true,true);
if (MATNR != null && !MATNR.Equals(""))
{
if (isComplete == 1)
{
ds = getPickDsbyCondi(n, "MATNR='" + MATNR + "'");
}
else
{
ds = getPickDsbyCondi(n, "MATNR LIKE '%" + MATNR + "%'");
}
}
return ds;
} // end of get_sub_MATNRPick
//過濾條件 [儲存位置(SP)]挑選 - 依 WH 過濾資料
[HttpPost]
public dynamic get_sub_SPPick(string SP = "", string WH = "", string MATNR = "", int isComplete = 0)
{
//取得目前 AMM_COMP.SP
string Tmp_Sql = "", Tmp_Str = "";
string Tmp_SP;
Tmp_Sql = " SELECT DISTINCT SP "
+ " FROM AMM_COMP "
+ " WHERE 1=1 "
+ " AND SP IS NOT NULL ";
if (!myfunc.checkisnull(WH))
Tmp_Sql = Tmp_Sql + " AND WH=" + myfunc.AA(WH);
//if (!myfunc.checkisnull(MATNR))
// Tmp_Sql = Tmp_Sql + " AND MATNR=" + myfunc.AA(MATNR);
Tmp_Sql = Tmp_Sql + " ORDER BY SP ";
string n = funId + "_sub_SP";
//realtime 取值
DataSet ds = setupPickDs(n, Tmp_Sql, new string[] { "AMM_COMP" }, true, true);
if (SP != null && !SP.Equals(""))
{
if (isComplete == 1)
{
ds = getPickDsbyCondi(n, "SP='" + SP + "'");
}
else
{
ds = getPickDsbyCondi(n, "SP LIKE '%" + SP + "%'");
}
}
return ds;
} // end of get_sub_SPPick