目的: V20305 – 零件需求登錄 –[編輯]鈕 - 前端取得 KEYCODE 名稱 - 取得人員姓名
處理說明: 1> 前端取得 KEYCODE 名稱
Tmp_RSTHAH = nulltoStr(cur_rec.data['RSTHAH']).toString();
Tmp_RSTHAH_ = get_KEY_CODE_NM("AMM_UOCD","RSTHAH",Tmp_RSTHAH);
Tmp_RSTHAH = nulltoStr(cur_rec.data['RSTHAH']).toString();
Tmp_RSTHAH_ = get_KEY_CODE_NM("AMM_UOCD","RSTHAH",Tmp_RSTHAH);
2> 前端取得 人員姓名
Tmp_LoginId = loginInfo.id;
Tmp_LoginNM = getEmp_NM(loginInfo.id);
Tmp_LoginId = loginInfo.id;
Tmp_LoginNM = getEmp_NM(loginInfo.id);
1>*.js
//V20305A.js
Tmp_RSTHAH = nulltoStr(cur_rec.data['RSTHAH']).toString();
Tmp_RSTHAH_ = get_KEY_CODE_NM("AMM_UOCD","RSTHAH",Tmp_RSTHAH);
Tmp_RSTHAH = nulltoStr(cur_rec.data['RSTHAH']).toString();
Tmp_RSTHAH_ = get_KEY_CODE_NM("AMM_UOCD","RSTHAH",Tmp_RSTHAH);
//V120202A.js
Tmp_LoginId = loginInfo.id;
Tmp_LoginNM = getEmp_NM(loginInfo.id);
2>myfunc.js - get_KEY_CODE_NM - getEmp_NM
* 傳入參數: par_TBL_NAME: Table名稱
* par_KEY_NAME: KEYCODE欄位名稱
* par_KEY_CODE: KEYCODE欄位值
SELECT KEY_CODE, DESCPT
FROM KEYCODE
WHERE TBL_NAME = 'AMM_UOCD'
AND KEY_NAME = 'RSTHAH'
AND KEY_CODE = 'A';
*/
function get_KEY_CODE_NM(par_TBL_NAME,par_KEY_NAME,par_KEY_CODE) {
var obj = '';
var Tmp_KEY_CODE_NM = "";
if ( (par_TBL_NAME.length > 0) && (par_KEY_NAME.length > 0) && (par_KEY_CODE.length > 0) ){
Ext.Ajax.request({
method: "POST",
//url: "../api/V20302AAPI/getEmp_NM?EMPLYID=" + par_EMPLYID,
url: "../api/myAPI/get_KEY_CODE_NM?TBL_NAME=" + par_TBL_NAME+"&KEY_NAME="+par_KEY_NAME+"&KEY_CODE="+par_KEY_CODE,
async: false,
success: function (response, opts) {
obj_Temp = Ext.decode(response.responseText);
//console.log("obj_Temp:", obj_Temp);
if (obj_Temp.T1.length > 0) {
obj = obj_Temp;
Tmp_KEY_CODE_NM = obj.T1[0]["DESCPT"].toString();
return Tmp_KEY_CODE_NM;
}
}
}
)
}
return Tmp_KEY_CODE_NM;
};
// function名稱 : getEMP_NM
// 參數 : par_EMPLYID : 員工編號
// 傳回值: 傳入員工.姓名
function getEmp_NM(par_EMPLYID) {
var obj = '';
var Tmp_EMPLYNM = "";
if (par_EMPLYID.length > 0) {
Ext.Ajax.request({
method: "POST",
//url: "../api/V20302AAPI/getEmp_NM?EMPLYID=" + par_EMPLYID,
url: "../api/myAPI/getEmp_NM?EMPLYID=" + par_EMPLYID,
async: false,
success: function (response, opts) {
obj_Temp = Ext.decode(response.responseText);
//console.log("obj_Temp:", obj_Temp);
if (obj_Temp.T1.length > 0) {
obj = obj_Temp;
Tmp_EMPLYNM = obj.T1[0]["EMPLYNM"].toString();
return Tmp_EMPLYNM;
}
}
}
)
}
return Tmp_EMPLYNM;
};
3>myAPI.cs - get_KEY_CODE_NM
//取得 TABLE.KEYCODE 的名稱
[HttpPost]
public dynamic get_KEY_CODE_NM(string TBL_NAME,string KEY_NAME, string KEY_CODE)
{
var c = HttpContext.Current;
NameValueCollection nvc = c.Request.Form;
string Tmp_Sql = " SELECT KEY_CODE,DESCPT "
+ " FROM KEYCODE "
+ " WHERE 1=1 "
+" AND TBL_NAME="+myfunc.AA(TBL_NAME)
+" AND KEY_NAME=" + myfunc.AA(KEY_NAME)
+ " AND KEY_CODE=" + myfunc.AA(KEY_CODE);
if (myfunc.checkisnull(TBL_NAME) || myfunc.checkisnull(KEY_NAME) || myfunc.checkisnull(KEY_CODE))
{ return null; }
//else
//{ Tmp_Sql = Tmp_Sql + " AND EMPLYID=" + myfunc.AA(EMPLYID); }
try
{
OracleConnection conn = new OracleConnection(DBService.ConnectionString("AMMEU"));
OracleCommand cmd = new OracleCommand(Tmp_Sql, conn);
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataSet ds = new DataSet();
conn.Open();
da.Fill(ds, "T1");
conn.Close();
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
} // end of GetEmp_NM
