WebDesign 心得綜整

2023年6月20日星期二

V20302 - 判斷 cur_rec={} 為空 Object

目的: V20302 - 判斷 cur_rec={} 為空 Object

處理方法: 1>var cur_rec={} , cur_rec.keys(cur_rec --> [] 傳回 array

if (cur_rec.keys(cur_rec).length==0){}

2>JSON.

V120202E 清除 store 所有資料 - removeAll - clearData

目的: V120202E 清除 store 所有資料

處理說明: 1> var Tmp_gridstore = Ext.getCmp("sub_Grid").store;
Tmp_gridstore.clearData();
Tmp_gridstore.removeAll();

1>*.js

Tmp_Str = Tmp_Str
+ "申請單號(" + cur_rec.data["APNO"].toString() + ") "
+ "退庫歸儲完成!! ";
Ext.Msg.alert('確認', Tmp_Str, ok2go);
function ok2go(id) {
console.log("id:", id);
if (id == 'ok') {
//mysuccessalert("退庫歸儲完成 !!");
//清空 [點料人員][退庫原因] & grid 資料
Ext.getCmp("sub_BKMG").setValue("");
Ext.getCmp("sub_APNO").setValue("");
Ext.getCmp("sub_CAUSE_REMARK").setValue("");
var Tmp_gridstore = Ext.getCmp("sub_Grid").store;
Tmp_gridstore.clearData();
Tmp_gridstore.removeAll();
}// end of if(id=='yes')
} //end of callbackfunc

V120202E – 確定後,才繼續往下執行 – Ext.Msg.alert –Ext.Msg.confirm - [退庫歸儲]鈕 , 詢問

目的: V120202E – 確定後,才繼續往下執行 – Ext.Msg.alert –Ext.Msg.confirm - [退庫歸儲]鈕

處理說明: 1> Ext.Msg.confirm('是&否', me.delMessage, yes2go);
function yes2go(id)

{ if (id == 'yes') { }}

2> Ext.Msg.alert('確定', me.delMessage, ok2go);
function ok2go(id)

{ if (id == 'ok') { }}

1>*.js

- Ext.Msg.alert - ok

Tmp_Str = Tmp_Str

+ "申請單號(" + cur_rec.data["APNO"].toString() + ") "

+ "退庫歸儲完成!! ";

Ext.Msg.alert('確認', Tmp_Str, ok2go);

function ok2go(id) {

console.log("id:", id);

if (id == 'ok') {

//mysuccessalert("退庫歸儲完成 !!");

//清空 [點料人員][退庫原因] & grid 資料

Ext.getCmp("sub_BKMG").setValue("");

Ext.getCmp("sub_APNO").setValue("");

Ext.getCmp("sub_CAUSE_REMARK").setValue("");

var Tmp_gridstore = Ext.getCmp("sub_Grid").store;

Tmp_gridstore.clearData();

Tmp_gridstore.removeAll();

}// end of if(id=='yes')

} //end of callbackfunc

}

-Ext.Msg.confirm - Yes & No

me.delMessage = "確定刪除勾選的資料嗎?";

Ext.Msg.confirm('提醒', me.delMessage, callBackFunc);

function callBackFunc(id) {

if (id == 'yes') {

console.log("cur_recs.length:", cur_recs.length);

var gridstore = Ext.getCmp('grid_Single').store;

for (let i = 0; i <= cur_recs.length - 1; i++) {

console.log("i:", i);

Ext.getCmp('grid_Single').getSelectionModel().select(cur_recs[i]); //grid select指向所選的資料

cur_rec = Ext.getCmp('grid_Single').getSelectionModel().getSelection();

console.log("cur_rec: ", cur_rec);

if (Ext.getCmp('btn_del').afterDel() == false) {

return;

}

} // end of for (let i=0,)

//資料庫均刪除完成後, 才由 gridstore 移除資料

for (let i = 0; i <= cur_recs.length - 1; i++) {

gridstore.remove(cur_recs[i]); //畫面上隱藏刪除列

} // end of for (let i=0,)

Ext.getCmp('grid_Single').getView().refresh();

buttonModel.modelType = 0;

} // end if (id == 'yes')

} // end of callbackfunc

2023年6月18日星期日

V120202E - 版面配置 - border – [north,center] – [east,center] - region

目的: V120202E 版面配置 - border – [north,center] – [east,center]

處理說明: 1>第1層 : [north,center] , north: 必需設 height
2>第2層 : [east,center] , east: 必需設 width

1>*.js

var sub_V120202E_Flds = [

{

type: 'panel', bodyStyle: "background-color:transparent;", border: 5, padding: "1",

items: [

{ // panel1: 過濾條件 : north , 必需設 height

xtype: 'panel',

id: 'sub_panel1',

//title: 'sub_panel1',

region: 'north',

height: 90,

items: [

{ // panel11 : 退庫人員 , center

xtype: 'panel',

id: 'sub_panel11',

region: 'center',

type: 'vbox',

//align: 'stretch'

items: [

{

xtype: "fieldcontainer", fieldLabel: "退庫人員", labelWidth: 70, flex: 5, border: 2,

type: 'hbox',

//align: 'stretch'

items: [

{ id: "sub_COMPER", name: "sub_COMPER", xtype: "textfield", width: 120, padding: "0 4 0 0", },

{ id: "sub_COMPER_", name: "sub_COMPER_", xtype: "textfield", width: 80, padding: "0 4 0 0", readOnly: true, fieldCls: "readonly", },

{: },

]

}, // end of 退庫人員

{: }, // end of 點料人員

{: },

]

}, //end of sub_panel11 , 退庫人員/點料人員

{ // panel12 : 退庫說明 , east , 必需設 width

xtype: 'panel',

id: 'sub_panel12',

//title: 'sub_panel12',

//flex: 4,

region: 'east',

width: 350,

type: 'fit',

//align: 'stretch'

items: [

{

xtype: "fieldcontainer", fieldLabel: "退庫說明", labelWidth: 60, flex: 5, border: 0,

type: 'fit',

//align: 'stretch'

items: [

{ id: "sub_CAUSE_REMDK", name: "sub_CAUSE_REMDK", xtype: "textareafield", width: 120, padding: "0 4 0 0", },

]

}, //退庫說明

]

}, // end of sub_panel12 , 退庫說明

},//end of sub_panel1

{ // panel2 : grid , center

xtype: 'panel',

id: 'sub_panel2',

region: 'center',

flex: 5,

border: 1,

items: [sub_Grid]

] // end of layout: "vbox", padding: "5", items: [

} //end of sub_ShowPN_Flds , items[{

] //end of var sub_ShowPN_Flds

V120202D -getUrlStr - 傳回ds - foreach(DataRow dr -checkRtnOk - - 挑選[申請單號]後,自動加入 store - dt2JSON - Ext.decode

目的: V120202D - 領料登記 - 挑選[申請單號]後,自動加入 store

處理說明: 1>開啟畫面, store : where 1=2
2>利用隱藏按鈕 [加入資料], 挑選完資料(onchange)後,執行[加入資料]鈕
3>[挑選資料]後,將所挑選資料轉成 dt2JSON String傳至前端,

4>由 Ext.decode 解碼成 Object (Tmp_recs)

5>將 Tmp_rec=Tmp_recs[i], 將 Tmp_rec 加入 store

1>*.js

xtype: "button", id: "btn_APNO", name: "btn_APNO", text: "...",
handler: function () {
//不分頁 & 不 suspendevent - 以便觸發 change event
var win = EditPickx('申請單號', '../api/V120202DAPI/get_APNOPick', ['APNO'],
['sub_APNO'], J_pickstore_sub_APNO, J_pickcolumns_sub_APNO, false,false);
win.show();
}
},
{ //加入資料
xtype: "button", text: "加入資料", width: 120, border: 2, margin: { left: 10, },
hidden: true,
id: "sub_btn_Add",
handler: function () {
console.log("insider handler of sub_btn_Add");
var Tmp_APNO = Ext.getCmp("sub_APNO").getValue();
var Tmp_Str = "";
if (checkisnull(Tmp_APNO)) {
Tmp_Str = "請先輸入[申請單號] !!"
mywarnalert(Tmp_Str);
return;
}
var np = {};
np["sub_APNO"] = Tmp_APNO;
var Tmp_url = "../../api/V120202DAPI/get_sub_data1";

//取得挑選資料的 dt2JSON 字串

//getUrlStr : 必需傳回字串( dt.JSON字串) , 非 ds
var rtn_Str = getUrlStr(Tmp_url, np, "加入資料");
console.log("rtn_Str:", rtn_Str);

if (checkRtnOK(rtn_Str)) {
var Tmp_recs = Ext.decode(rtn_Str);
var Tmp_rec;
for (i = 0; i < Tmp_recs.length; i++) {
Tmp_rec = Tmp_recs[0];
console.log("Tmp_rec:", Tmp_rec);
if (Ext.getCmp("sub_Grid").store.find("APNO", Tmp_rec["APNO"]) == -1) {
console.log("add store Tmp_rec:", Tmp_rec);
Ext.getCmp("sub_Grid").store.add(Tmp_rec);
Ext.getCmp("sub_APNO").setValue("");
}
} //end of for
console.log("store :", Ext.getCmp("sub_Grid").store);
} // end of if (checkRtnOK(rtn_Str)) {
} // end of handler
}, // end of 加入資料

//開啟畫面

var win1 = getMyWindow("領料登記", sub_V120202D_Flds, sub_V120202D_Btns, "D");

win1.x = 100;

win1.setWidth(500);

win1.setHeight(400);

var np = {};

//np["sub_APNO"] = Ext.getCmp("sub_APNO").getValue();

var Tmp_url = "../../api/V120202DAPI/get_sub_data"; //

Ext.getCmp("sub_Grid").store.getProxy().url = Tmp_url;

Ext.getCmp("sub_Grid").store.getProxy().extraParams = np;　//分頁OK,篩選條件OK

Ext.getCmp("sub_Grid").store.load();

win1.show();

2>*.cs

//[顯示資料]鈕 - store.資料 - where 1=2

[HttpPost]

//public HttpResponseMessage get_sub_Data()

public dynamic get_sub_Data()

{

var c = HttpContext.Current;

NameValueCollection nvc = c.Request.Form;

OracleCommand cmd = new OracleCommand();

var response = this.Request.CreateResponse();

* { name: "APNO" },

{ name: "MATNR" },

{ name: "MAKTX" },

{

convert: function (value, record) { return Ext.util.Format.round(value, 2); }

{ name: "UNIT" },

string Tmp_Sql1 = ""; //for 日期起迄

string Tmp_Sql = " SELECT RNK,APNO,APER,APDT,PN,MATNR,MAKTX,QTY,UNIT,MPKUPP,MPKUPDT,STAT "

+ " FROM ( SELECT dense_rank() over(order by APNO) as RNK,"

+ " APNO,APER,APDT,PN,MATNR,MAKTX,QTY,UNIT,MPKUPP,MPKUPDT,STAT "

+ " FROM AMM_COMQ "

+ " WHERE 1=2 ";

Tmp_Sql = Tmp_Sql + ")";

cmd.CommandText = Tmp_Sql;

string countSql = " SELECT COUNT(*) as total FROM (" + Tmp_Sql + ")";

//不分頁

DataSet ds = getDataTable(cmd, countSql, false);

//- [單況(STAT) ]

Tmp_Sql = " select KEY_CODE as STAT, DESCPT "

+ " from KEYCODE "

+ " where TBL_NAME = 'AMM_COMQ' "

+ " and KEY_NAME = 'STAT' ";

getKeyCode("STAT", ref ds, Tmp_Sql);

int Tmp_TOTAL = int.Parse(ds.Tables["T1C"].Rows[0]["TOTAL"].ToString());

string Tmp_Str = "";

string Tmp_RtnMsg = "";

//自訂 CaluField 欄位 - [儲位(SP_)]

ds.Tables["T1"].Columns.Add("WH_", typeof(object));

ds.Tables["T1"].Columns.Add("SP_", typeof(object));

ds.Tables["T1"].Columns.Add("APER_", typeof(object));

ds.Tables["T1"].Columns.Add("MPKUPP_", typeof(object));

OracleConnection conn = new OracleConnection(DBService.ConnectionString(DBLINK));

OracleCommand cmd1 = new OracleCommand();

OracleDataReader reader;

string Tmp_dt2JSON;

try

{

conn.Open();

conn.ClientInfo = User.Identity.Name;

conn.ModuleName = BaseSYS + "_" + BaseMODID;

conn.ActionName = ActionName;

cmd1.Connection = conn;

string Tmp_cur_APNO = "";

string Tmp_WH_ = "";

string Tmp_SP_ = "";

string Tmp_APER_ = "";

string Tmp_MPKUPP_ = "";

foreach (DataRow dr in ds.Tables["T1"].Rows)

{

Tmp_WH_ = "";

Tmp_SP_ = "";

Tmp_APER_ = "";

Tmp_MPKUPP_ = "";

Tmp_cur_APNO = dr["APNO"].ToString();

if (Tmp_cur_APNO.Length > 0)

{

Tmp_Sql = " SELECT WH,SP "

+ " FROM AMM_COMPQTY "

+ " WHERE APNO=" + myfunc.AA(Tmp_cur_APNO)

+ " AND rownum=1 "

+ " ORDER BY APNO DESC ";

Tmp_Str = myfunc.SqlValue(Tmp_Sql);

if (Tmp_Str.Length > 0)

{

Tmp_WH_ = myfunc.StrExtract(Tmp_Str, 1, ";");

Tmp_SP_ = myfunc.StrExtract(Tmp_Str, 2, ";");

}

Tmp_Sql = " SELECT EMPLYNM "

+ " FROM HR_EMPLYM "

+ " WHERE EMPLYID=" + myfunc.AA(dr["APER"].ToString());

Tmp_Str = myfunc.SqlValue(Tmp_Sql);

if (Tmp_Str.Length > 0)

{

Tmp_APER_ = myfunc.StrExtract(Tmp_Str, 1, ";");

}

dr["APER_"] = Tmp_APER_;

Tmp_Sql = " SELECT EMPLYNM "

+ " FROM HR_EMPLYM "

+ " WHERE EMPLYID=" + myfunc.AA(dr["MPKUPP"].ToString());

Tmp_Str = myfunc.SqlValue(Tmp_Sql);

if (Tmp_Str.Length > 0)

{

Tmp_MPKUPP_ = myfunc.StrExtract(Tmp_Str, 1, ";");

}

dr["MPKUPP_"] = Tmp_MPKUPP_;

} // end of foreach (DataRow row in ds.Tables["T1"].Rows)

} //end of foreach (dr

//如何將 ds 的 T1包成 JSON格式, 傳回前遄

return ds;

} // end of try

finally

{

conn.Close();

}

//[加入資料]鈕 - 將所挑選的申請單號, 加入子畫面.grid

[HttpPost]

//public HttpResponseMessage get_sub_Data1()

public dynamic get_sub_Data1()

{

var c = HttpContext.Current;

NameValueCollection nvc = c.Request.Form;

string Tmp_APNO = nvc["sub_APNO"];

OracleCommand cmd = new OracleCommand();

var response = this.Request.CreateResponse();

* { name: "APNO" },

{ name: "MATNR" },

{ name: "MAKTX" },

{

convert: function (value, record) { return Ext.util.Format.round(value, 2); }

{ name: "UNIT" },

string Tmp_Sql1 = ""; //for 日期起迄

string Tmp_Sql = " SELECT RNK,APNO,APER,APDT,PN,MATNR,MAKTX,QTY,UNIT,MPKUPP,MPKUPDT,STAT "

+ " FROM ( SELECT dense_rank() over(order by APNO) as RNK,"

+ " APNO,APER,APDT,PN,MATNR,MAKTX,QTY,UNIT,MPKUPP,MPKUPDT,STAT "

+ " FROM AMM_COMQ "

+ " WHERE 1=1 ";

//panel11

//申請編號

if (!myfunc.checkisnull(Tmp_APNO))

{

Tmp_Sql = Tmp_Sql + " AND APNO= " + myfunc.AA(Tmp_APNO);

};

Tmp_Sql = Tmp_Sql + ")";

cmd.CommandText = Tmp_Sql;

string countSql = " SELECT COUNT(*) as total FROM (" + Tmp_Sql + ")";

//不分頁

DataSet ds = getDataTable(cmd, countSql, false);

int Tmp_TOTAL = int.Parse(ds.Tables["T1C"].Rows[0]["TOTAL"].ToString());

string Tmp_Str = "";

string Tmp_RtnMsg = "";

//- [單況(STAT) ]

Tmp_Sql = " select KEY_CODE as STAT, DESCPT "

+ " from KEYCODE "

+ " where TBL_NAME = 'AMM_COMQ' "

+ " and KEY_NAME = 'STAT' ";

getKeyCode("STAT", ref ds, Tmp_Sql);

//自訂 CaluField 欄位 - [儲位(SP_)]

ds.Tables["T1"].Columns.Add("WH_", typeof(object));

ds.Tables["T1"].Columns.Add("SP_", typeof(object));

string Tmp_WH_ = "";

string Tmp_SP_ = "";

OracleConnection conn = new OracleConnection(DBService.ConnectionString(DBLINK));

OracleCommand cmd1 = new OracleCommand();

OracleDataReader reader;

string Tmp_dt2JSON;

try

{

conn.Open();

conn.ClientInfo = User.Identity.Name;

conn.ModuleName = BaseSYS + "_" + BaseMODID;

conn.ActionName = ActionName;

cmd1.Connection = conn;

var Tmp_cur_APNO = "";

foreach (DataRow dr in ds.Tables["T1"].Rows)

{

Tmp_cur_APNO = dr["APNO"].ToString();

if (Tmp_cur_APNO.Length > 0)

{

//自訂 SQL , 取得 CaluField 欄位值

Tmp_Sql = " SELECT WH,SP "

+ " FROM AMM_COMPQTY "

+ " WHERE 1=1 "

+ " AND APNO=" + myfunc.AA(Tmp_cur_APNO)

+" AND rownum=1 "

+ " ORDER BY SP ";

Tmp_Str = myfunc.SqlValue(Tmp_Sql);

if (Tmp_Str.Length > 0)

{

Tmp_WH_ = myfunc.StrExtract(Tmp_Str, 1, ";");

Tmp_SP_ = myfunc.StrExtract(Tmp_Str, 2, ";");

}

dr["WH_"] = Tmp_WH_;

dr["SP_"] = Tmp_SP_;

} // end of if (Tmp_NATIXX.Length > 0)

} // end of foreach (DataRow row in ds.Tables["T1"].Rows)

//如何將 ds 的 T1包成 JSON格式, 傳回前遄

Tmp_dt2JSON = myfunc.dt2JSON(ds.Tables["T1"]);

Tmp_RtnMsg = Tmp_dt2JSON;

return Tmp_RtnMsg;

} // end of try

catch (Exception e)

{

var Tmp_ErrMsg = myfunc.Get1ORA(e.Message);

Tmp_RtnMsg = "錯誤: 取得[條碼編號]的資料失敗 (get_sub_data1) !! "

+ Tmp_ErrMsg;

return Tmp_RtnMsg;

}

finally

{

conn.Close();

}

//return ds;

}// end of get_sub_Data1();

2023年6月16日星期五

V120202D - model -如何看 store.model的欄位值 - 子畫面.store 未顯示資料

目的: V120202D - 子畫面.store 未顯示資料 - model -如何看 store.model的欄位值

處理說明: 1>後端.store 有傳回 ds (含 T1 & T1C) , 但是前端未顯示資料
2>如何看 store.model 欄位值 ,
--> Store.model.setFields.[[Scopes]].0.J_gridmodel.Array(14)

1>*.js - grid 未顯示資料 - 因為 store.model --> sub_model 多一[ ] , 修正即可

var sub_model = [

[

{ name: "APNO" },

{ name: "APER" },

{ name: "APDT" },

{

convert: function (value, record) { return Ext.util.Format.round(value, 2); }

{ name: "UNIT" },

{ name: "PN" },

{ name: "MATNR" },

{ name: "WH_" },

{ name: "SP_" },

{ name: "MAKTX" },

{ name: "MPKUPP" },

{ name: "MPKUPDT" },

{ name: "STAT" },

{ name: "STAT_" },

]

];

2023年6月8日星期四

V20302 - 交修件除帳 - 勾選 – 保留分頁勾選資料 - checkbox - cbxArr

目的: V20303 - 交修件除帳 - 勾選 – 保留分頁勾選資料

處理說明: 1>利用 cbxArr : 記錄目前挑選資料.PK ,

cbxIdx++;
cbxArr[cbxIdx] = record.get('FMNO');
2>勾選時, 會觸發 columns renderler event

按[ ]時,若目前未勾選

cbxIdx++;

cbxArr[cbxIdx] = record.get('FMNO');

若已勾選

chkd = '';

cbxArr[i] = '';

3>利用 cbxArr1[ ] 儲存目前勾選資料內容 - Object { FMNO: xxxx, TYPEAF: xxxx}

cbxArr1[cbxIdx] = {

FMNO: record.get('FMNO'),

TYPEAF: record.get('TYPEAF'),

AMMNO: record.get('AMMNO'), OGONOAF: record.get('OGONOAF'), NGONOAF: record.get('NGONOAF'),

SAPNO_: record.get('SAPNO_'), PN_: record.get('PN_'),

C_NM: record.get('C_NM'), SEQOAF: record.get('SEQOAF'), MB1A: record.get('MB1A'), RBTHAF: record.get('RBTHAF'), RPNOAF: record.get('RPNOAF'), MRPNOAF: record.get('MRPNOAF'),

WBSNO: record.get('WBSNO'), DTSOR: record.get('DTSOR'), RQTYAF: record.get('RQTYAF'), NSN: record.get('NSN'), EIAC_CUS: record.get('EIAC_CUS'),

FACWC: record.get('FACWC'), FRTP: record.get('FRTP'), STATFM: record.get('STATFM'), STATFM_: record.get('STATFM_'),

};

1>*.js

NGONOAF: record.get('NGONOAF'), SAPNO_: record.get('SAPNO_'),

PN_: record.get('PN_'),C_NM: record.get('C_NM'),

SEQOAF: record.get('SEQOAF'), MB1A: record.get('MB1A'),

RBTHAF: record.get('RBTHAF'), RPNOAF: record.get('RPNOAF'),

MRPNOAF: record.get('MRPNOAF'), WBSNO: record.get('WBSNO'),

DTSOR: record.get('DTSOR'), RQTYAF: record.get('RQTYAF'),

NSN: record.get('NSN'), EIAC_CUS: record.get('EIAC_CUS'),

FACWC: record.get('FACWC'), FRTP: record.get('FRTP'),

STATFM: record.get('STATFM'), STATFM_: record.get('STATFM_'),
};
console.log("cbxArr[cbxIdx]=", record.get('FMNO'));
}
else {
chkd = '';
cbxArr[i] = '';
cbxArr1[i] = {};
}
}
else {
if (i >= 0) {
chkd = '';
cbxArr[i] = '';
cbxArr1[i] = {};
}
}
}
var cbx = "<input type='checkbox' name='" + (record.get('FMNO') + "_V20302") + "' " + chkd + " >";
return cbx;
},
},

訂閱：文章 (Atom)

2023年6月20日星期二

V20302 - 判斷 cur_rec={} 為空 Object

V120202E 清除 store 所有資料 - removeAll - clearData

V120202E – 確定後,才繼續往下執行 – Ext.Msg.alert –Ext.Msg.confirm - [退庫歸儲]鈕 , 詢問

2023年6月18日星期日

V120202E - 版面配置 - border – [north,center] – [east,center] - region

V120202D -getUrlStr - 傳回ds - foreach(DataRow dr -checkRtnOk - - 挑選[申請單號]後,自動加入 store - dt2JSON - Ext.decode

2023年6月16日星期五

V120202D - model -如何看 store.model的欄位值 - 子畫面.store 未顯示資料

2023年6月8日星期四

V20302 - 交修件除帳 - 勾選 – 保留分頁勾選資料 - checkbox - cbxArr

WebDesign 心得綜整

追蹤者

網誌存檔

關於我自己

2023年6月20日 星期二

2023年6月18日 星期日

2023年6月16日 星期五

2023年6月8日 星期四

追蹤者

網誌存檔

關於我自己

2023年6月20日星期二

2023年6月18日星期日

2023年6月16日星期五

2023年6月8日星期四