Files
KIN/project/cp_new_ok.asp
2025-09-29 17:55:08 +09:00

66 lines
1.9 KiB
Plaintext

<!-- #include virtual = "lib/config.asp" -->
<%
p_cli_code = request("p_cli_code") '이름 검색에 사용된 Client code
cp_name = request("cp_name") '새로 추가될 Client 담당자
cp_depart = request("cp_depart") '새로 추가될 Client 부서
cp_tel = request("cp_tel")
cp_mobile = request("cp_mobile")
cp_email = request("cp_email")
cp_position = request("cp_position")
cp_master = request("cp_master")
cp_mposition= request("cp_mposition")
query = "SELECT MAX(cp_code) as cp_code "
query = query & "FROM Client_People "
query = query & "WHERE c_code = '" & p_cli_code & "' "
rsc.Open query, adoConn, 1
if rsc("cp_code") = "" or isnull(rsc("cp_code")) then
tmp_cpcode = 1
else
tmp_cpcode = int(rsc("cp_code")) + 1
end if
rsc.Close
query = "INSERT INTO Client_People "
query = query & "(cp_code, c_code, cp_name, cp_depart, cp_tel, cp_mobile, cp_email, cp_position, cp_master, cp_mposition) "
query = query & "VALUES "
query = query & "('" & tmp_cpcode & "', "
query = query & "'" & p_cli_code & "', "
query = query & "'" & cp_name & "', "
query = query & "'" & cp_depart & "', "
query = query & "'" & cp_tel & "', "
query = query & "'" & cp_mobile & "', "
query = query & "'" & cp_email & "', "
query = query & "'" & cp_position & "', "
query = query & "'" & cp_master & "', "
query = query & "'" & cp_mposition & "')"
'Response.Write query
set dbin = server.CreateObject("ADODB.CONNECTION")
dbin.Open adoConn
dbin.Execute query
dbin.Close
%>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=euc-kr">
<LINK rel="stylesheet" type="text/css" href="/lib/text.css">
<title>
클라이언트 담당자 추가
</title>
<script language=javascript>
function goit(a) {
document.pms.action = 'cp_search.asp?v=1';
document.pms.submit();
}
</script>
</head>
<body onLoad="goit()">
<form name="pms" method="post">
<input type="hidden" name="p_cli_code" value="<%=p_cli_code%>">
<%
set rsc = nothing
%>