如何将值从Query转储到文本框 [英] How can I dump the value from Query to textbox
问题描述
我有一个选项列表（弹出窗口）
我有一个select语句，我从查询中获得DEPARTMENT
我有一个ID为DEPARTMENT的文本框，另一个ID为OLD_DEPARTMENT的文本框
我想在两个文本框中转储值DEPARTMENT，这可能吗？
函数EMP_NO_POP_onclick（）{
popuptype =popuptype = employee_grade_change_pop&
search_string =search_string =&
a_pass_val =a_pass_val = deptchange_form&
a_ret_val = a_ret_val = PR_EMPLOYEE_MASTER_ID&a_ret_val = EMP_NO&a_ret_val = EMPLOYEE_NAME&a_ret_val = ADDRESS&a_ret_val = TELEPHONE&a_ret_val = EMAIL&a_ret_val = GRADE&a_ret_val = DESIGNATION&a_ret_val = CATEGORY&a_ret_val = DEPARTMENT&a_ret_val = SUBDEPARTMENT && a_ret_val = PR_GRADE_MASTER_ID&a_ret_val = PR_GRADE_MASTER_ID&a_ret_val = PR_DESIG_MASTER_ID&a_ret_val = PR_CATEGORY_MASTER_ID&a_ret_val = DEPARTMENT_MASTER_ID&a_ret_val = SUBDEPARTMENT_MASTER_ID&a_ret_va升= LOCATION_MASTER_ID&a_ret_val = OLD_BA_COST_CODE_MST_ID&a_ret_val = OLD_COST_CODE&a_ret_val = OLD_PR_BUSINES_FUNC_MASTER_ID&a_ret_val = OLD_BUSINESS_FUNCTION_NAME&a_ret_val = OLD_PR_JOB_FUNCTION_MASTER_ID&a_ret_val = OLD_JOB_FUNCTION_NAME&a_ret_val = OLD_PR_PRODUCT_MASTER_ID&a_ret_val = OLD_PRODUCT_NAME
window.open（ '的弹出窗口/ HRemployee_popup.aspx？' + popuptype + search_string + a_pass_val + a_ret_val，'empnamepop'，'scrollbars = yes，width = 650，height = 363，top = 0，left = 140'）
}
QUERY：
MySql =SELECT&_
PR_EMPLOYEE_MASTER.ID AS ID，& _
PR_EMPLOYEE_MASTER.EMP_NO AS EMP_NO，&_
FN_UD_CONCAT（PR_EMPLOYEE_MASTER.FIRST_NAME，PR_EMPLOYEE_MASTER.MIDDLE_NAME，PR_EMPLOYEE_MASTER.LAST_NAME，''）AS EMPLOYEE_NAME，& _
FN_UD_CONCAT（PR_EMPLOYEE_ADDRESS.ADDRESS1，PR_EMPLOYE E_ADDRESS.ADDRESS2，PR_EMPLOYEE_ADDRESS.ADDRESS3，''）AS ADDRESS，&_
FN_UD_CONCAT（PR_EMPLOYEE_MASTER.COUNTRY_CODE，PR_EMPLOYEE_MASTER.MOBILE_NO，''，''）作为电话，&_
FN_UD_NVLC（PR_EMPLOYEE_ADDRESS.EMAIL，''）AS EMAIL，&_
PR_GRADE_MASTER.NAME AS GRADE，&_
PR_DESIG_MASTER .NAME AS DESIGNATION，&_
PR_CATEGORY_MASTER.NAME AS CATEGORY，&_
DEPARTMENT_MASTER.NAME AS DEPARTMENT，&_
SUBDEPARTMENT_MASTER.NAME AS SUB_DEPARTMENT，&_
LOCATION_MASTER.LOCATION_NAME AS LOCATION，&_
PR_GRADE_MASTER.ID AS GRADE_ID，&_
PR_DESIG_MASTER.ID AS DESIG_ID，&_
PR_CATEGORY_MASTER.ID AS CATE_ID，&_
DEPARTMENT_MASTER.ID AS DEPT_ID，&_
SUBDEPARTMENT_MASTER.ID AS SUBDETP_ID，&_
LOCATION_MASTER.ID AS LOCATION_ID&_
FROM&_
COMPANY_MASTER INNER JOIN PR_EMPLOYEE_MASTER ON&_
COMPANY_MASTER.ID = PR_EMPLOYEE_MASTER.COMPANY_MASTER_ID INNER JOIN PR_EMPLOYEE_ADDRESS ON &_
PR_EMPLOYEE_MASTER.ID = PR_EMPLOYEE_ADDRESS.PR_EMPLOYEE_MASTER_ID AND PR_EMPLOYEE_ADDRESS.TYPE ='C'LEFT OUTER JOIN SUBDEPARTMENT_MASTER ON&_
PR_EMPLOYEE_MASTER.SUBDEPARTMENT_MASTER_ID = SUBDEPARTMENT_MASTER。 ID LEFT OUTER JOIN DEPARTMENT_MASTER ON&_
PR_EMPLOYEE_MASTER.DEPARTMENT_MASTER_ID = DEPARTMENT_MASTER.ID LEFT OUTER JOIN LOCATION_MASTER ON&_
PR_EMPLOYEE_MASTER.E MP_LOCATION_MASTER_ID = LOCATION_MASTER.ID LEFT OUTER加入PR_DESIG_MASTER&_
PR_EMPLOYEE_MASTER.PR_DESIG_MASTER_ID = PR_DESIG_MASTER.ID LEFT OUTER JOIN PR_CATEGORY_MASTER ON&_
PR_EMPLOYEE_MASTER.PR_CATEGORY_MASTER_ID = PR_CATEGORY_MASTER.ID LEFT OUTER JOIN PR_GRADE_MASTER ON&_
PR_EMPLOYEE_MASTER.PR_GRADE_MASTER_ID = PR_GRADE_MASTER.ID&_
WHERE&_
PR_EMPLOYEE_MASTER.COMPANY_MASTER_ID =&Trim（CompID）&_
AND PR_EMPLOYEE_MASTER.ACTIVE ='Y'&_
AND PR_EMPLOYEE_MASTER.EMP_APPROVED ='Y '&_
AND（PR_EMPLOYEE_MASTER.EMP_STATUS<> 'D'或PR_EMPLOYEE_MASTER.EMP_STATUS为空）&_
I have a picklist (popup) where
I have a select statement where i get DEPARTMENT from the query
I have 1 textbox with id as DEPARTMENT, and another textbox with id as OLD_DEPARTMENT
I want to dump the value DEPARTMENT in both Textbox, Is this possible?
function EMP_NO_POP_onclick() {
popuptype = "popuptype=employee_grade_change_pop&"
search_string = "search_string=&"
a_pass_val = "a_pass_val=deptchange_form&"
a_ret_val = "a_ret_val=PR_EMPLOYEE_MASTER_ID&a_ret_val=EMP_NO&a_ret_val=EMPLOYEE_NAME&a_ret_val=ADDRESS&a_ret_val=TELEPHONE&a_ret_val=EMAIL&a_ret_val=GRADE&a_ret_val=DESIGNATION&a_ret_val=CATEGORY&a_ret_val=DEPARTMENT&a_ret_val=SUBDEPARTMENT&&a_ret_val=PR_GRADE_MASTER_ID&a_ret_val=PR_GRADE_MASTER_ID&a_ret_val=PR_DESIG_MASTER_ID&a_ret_val=PR_CATEGORY_MASTER_ID&a_ret_val=DEPARTMENT_MASTER_ID&a_ret_val=SUBDEPARTMENT_MASTER_ID&a_ret_val=LOCATION_MASTER_ID&a_ret_val=OLD_BA_COST_CODE_MST_ID&a_ret_val=OLD_COST_CODE&a_ret_val=OLD_PR_BUSINES_FUNC_MASTER_ID&a_ret_val=OLD_BUSINESS_FUNCTION_NAME&a_ret_val=OLD_PR_JOB_FUNCTION_MASTER_ID&a_ret_val=OLD_JOB_FUNCTION_NAME&a_ret_val=OLD_PR_PRODUCT_MASTER_ID&a_ret_val=OLD_PRODUCT_NAME"
window.open('Popups/HRemployee_popup.aspx?' + popuptype + search_string + a_pass_val + a_ret_val, 'empnamepop', 'scrollbars=yes,width=650,height=363,top=0,left=140')
}
QUERY :
MySql = " SELECT " & _
" PR_EMPLOYEE_MASTER.ID AS ID, " & _
" PR_EMPLOYEE_MASTER.EMP_NO AS EMP_NO, " & _
" FN_UD_CONCAT(PR_EMPLOYEE_MASTER.FIRST_NAME, PR_EMPLOYEE_MASTER.MIDDLE_NAME, PR_EMPLOYEE_MASTER.LAST_NAME, '') AS EMPLOYEE_NAME, " & _
" FN_UD_CONCAT(PR_EMPLOYEE_ADDRESS.ADDRESS1, PR_EMPLOYEE_ADDRESS.ADDRESS2, PR_EMPLOYEE_ADDRESS.ADDRESS3, '') AS ADDRESS, " & _
" FN_UD_CONCAT(PR_EMPLOYEE_MASTER.COUNTRY_CODE, PR_EMPLOYEE_MASTER.MOBILE_NO, '', '') AS TELEPHONE, " & _
" FN_UD_NVLC(PR_EMPLOYEE_ADDRESS.EMAIL, '') AS EMAIL, " & _
" PR_GRADE_MASTER.NAME AS GRADE, " & _
" PR_DESIG_MASTER.NAME AS DESIGNATION, " & _
" PR_CATEGORY_MASTER.NAME AS CATEGORY, " & _
" DEPARTMENT_MASTER.NAME AS DEPARTMENT, " & _
" SUBDEPARTMENT_MASTER.NAME AS SUB_DEPARTMENT, " & _
" LOCATION_MASTER.LOCATION_NAME AS LOCATION, " & _
" PR_GRADE_MASTER.ID AS GRADE_ID, " & _
" PR_DESIG_MASTER.ID AS DESIG_ID, " & _
" PR_CATEGORY_MASTER.ID AS CATE_ID, " & _
" DEPARTMENT_MASTER.ID AS DEPT_ID, " & _
" SUBDEPARTMENT_MASTER.ID AS SUBDETP_ID, " & _
" LOCATION_MASTER.ID AS LOCATION_ID " & _
" FROM " & _
" COMPANY_MASTER INNER JOIN PR_EMPLOYEE_MASTER ON " & _
" COMPANY_MASTER.ID = PR_EMPLOYEE_MASTER.COMPANY_MASTER_ID INNER JOIN PR_EMPLOYEE_ADDRESS ON " & _
" PR_EMPLOYEE_MASTER.ID = PR_EMPLOYEE_ADDRESS.PR_EMPLOYEE_MASTER_ID AND PR_EMPLOYEE_ADDRESS.TYPE='C' LEFT OUTER JOIN SUBDEPARTMENT_MASTER ON " & _
" PR_EMPLOYEE_MASTER.SUBDEPARTMENT_MASTER_ID = SUBDEPARTMENT_MASTER.ID LEFT OUTER JOIN DEPARTMENT_MASTER ON " & _
" PR_EMPLOYEE_MASTER.DEPARTMENT_MASTER_ID = DEPARTMENT_MASTER.ID LEFT OUTER JOIN LOCATION_MASTER ON " & _
" PR_EMPLOYEE_MASTER.EMP_LOCATION_MASTER_ID = LOCATION_MASTER.ID LEFT OUTER JOIN PR_DESIG_MASTER ON " & _
" PR_EMPLOYEE_MASTER.PR_DESIG_MASTER_ID = PR_DESIG_MASTER.ID LEFT OUTER JOIN PR_CATEGORY_MASTER ON " & _
" PR_EMPLOYEE_MASTER.PR_CATEGORY_MASTER_ID = PR_CATEGORY_MASTER.ID LEFT OUTER JOIN PR_GRADE_MASTER ON " & _
" PR_EMPLOYEE_MASTER.PR_GRADE_MASTER_ID = PR_GRADE_MASTER.ID " & _
" WHERE " & _
" PR_EMPLOYEE_MASTER.COMPANY_MASTER_ID = " & Trim(CompID) & _
" AND PR_EMPLOYEE_MASTER.ACTIVE='Y' " & _
" AND PR_EMPLOYEE_MASTER.EMP_APPROVED ='Y' " & _
" AND (PR_EMPLOYEE_MASTER.EMP_STATUS <> 'D' or PR_EMPLOYEE_MASTER.EMP_STATUS is null) " & _
推荐答案
这篇关于如何将值从Query转储到文本框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
