⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 jyzl_zlxg_xg.asp

📁 asp+Access开发的客户资源管理系统,用户名:admin,密码:
💻 ASP
📖 第 1 页 / 共 2 页
字号:
	for (j=vFirstDay; j<7; j++) {
		vCode = vCode + "<TD WIDTH='14%'" + this.write_weekend_string(j) + "><FONT SIZE='2' FACE='" + fontface + "'>" + 
			"<A HREF='#' " + 
				"onClick=\"self.opener.document." + this.gReturnItem + ".value='" + 
				this.format_data(vDay) + 
				"';window.close();\">" + 
				this.format_day(vDay) + 
			"</A>" + 
			"</FONT></TD>";
		vDay=vDay + 1;
	}
	vCode = vCode + "</TR>";

	// Write the rest of the weeks
	for (k=2; k<7; k++) {
		vCode = vCode + "<TR>";

		for (j=0; j<7; j++) {
			vCode = vCode + "<TD WIDTH='14%'" + this.write_weekend_string(j) + "><FONT SIZE='2' FACE='" + fontface + "'>" + 
				"<A HREF='#' " + 
					"onClick=\"self.opener.document." + this.gReturnItem + ".value='" + 
					this.format_data(vDay) + 
					"';window.close();\">" + 
				this.format_day(vDay) + 
				"</A>" + 
				"</FONT></TD>";
			vDay=vDay + 1;

			if (vDay > vLastDay) {
				vOnLastDay = 1;
				break;
			}
		}

		if (j == 6)
			vCode = vCode + "</TR>";
		if (vOnLastDay == 1)
			break;
	}
	
	// Fill up the rest of last week with proper blanks, so that we get proper square blocks
	for (m=1; m<(7-j); m++) {
		if (this.gYearly)
			vCode = vCode + "<TD WIDTH='14%'" + this.write_weekend_string(j+m) + 
			"><FONT SIZE='2' FACE='" + fontface + "' COLOR='gray'> </FONT></TD>";
		else
			vCode = vCode + "<TD WIDTH='14%'" + this.write_weekend_string(j+m) + 
			"><FONT SIZE='2' FACE='" + fontface + "' COLOR='gray'>" + m + "</FONT></TD>";
	}
	
	return vCode;
}

Calendar.prototype.format_day = function(vday) {
	var vNowDay = gNow.getDate();
	var vNowMonth = gNow.getMonth();
	var vNowYear = gNow.getFullYear();

	if (vday == vNowDay && this.gMonth == vNowMonth && this.gYear == vNowYear)
		return ("<FONT COLOR=\"RED\"><B>" + vday + "</B></FONT>");
	else
		return (vday);
}

Calendar.prototype.write_weekend_string = function(vday) {
	var i;

	// Return special formatting for the weekend day.
	for (i=0; i<weekend.length; i++) {
		if (vday == weekend[i])
			return (" BGCOLOR=\"" + weekendColor + "\"");
	}
	
	return "";
}

Calendar.prototype.format_data = function(p_day) {
	var vData;
	var vMonth = 1 + this.gMonth;
	vMonth = (vMonth.toString().length < 2) ? "0" + vMonth : vMonth;
	var vMon = Calendar.get_month(this.gMonth).substr(0,3).toUpperCase();
	var vFMon = Calendar.get_month(this.gMonth).toUpperCase();
	var vY4 = new String(this.gYear);
	var vY2 = new String(this.gYear.substr(2,2));
	var vDD = (p_day.toString().length < 2) ? "0" + p_day : p_day;

	switch (this.gFormat) {
		case "MM\/DD\/YYYY" :
			vData = vMonth + "\/" + vDD + "\/" + vY4;
			break;
		case "MM\/DD\/YY" :
			vData = vMonth + "\/" + vDD + "\/" + vY2;
			break;
		case "MM-DD-YYYY" :
			vData = vMonth + "-" + vDD + "-" + vY4;
			break;
		case "MM-DD-YY" :
			vData = vMonth + "-" + vDD + "-" + vY2;
			break;

		case "DD\/MON\/YYYY" :
			vData = vDD + "\/" + vMon + "\/" + vY4;
			break;
		case "DD\/MON\/YY" :
			vData = vDD + "\/" + vMon + "\/" + vY2;
			break;
		case "DD-MON-YYYY" :
			vData = vDD + "-" + vMon + "-" + vY4;
			break;
		case "DD-MON-YY" :
			vData = vDD + "-" + vMon + "-" + vY2;
			break;

		case "DD\/MONTH\/YYYY" :
			vData = vDD + "\/" + vFMon + "\/" + vY4;
			break;
		case "DD\/MONTH\/YY" :
			vData = vDD + "\/" + vFMon + "\/" + vY2;
			break;
		case "DD-MONTH-YYYY" :
			vData = vDD + "-" + vFMon + "-" + vY4;
			break;
		case "DD-MONTH-YY" :
			vData = vDD + "-" + vFMon + "-" + vY2;
			break;

		case "DD\/MM\/YYYY" :
			vData = vDD + "\/" + vMonth + "\/" + vY4;
			break;
		case "DD\/MM\/YY" :
			vData = vDD + "\/" + vMonth + "\/" + vY2;
			break;
		case "DD-MM-YYYY" :
			vData = vDD + "-" + vMonth + "-" + vY4;
			break;
		case "DD-MM-YY" :
			vData = vDD + "-" + vMonth + "-" + vY2;
			break;

		default :
			vData = vMonth + "\/" + vDD + "\/" + vY4;
	}

	return vData;
}

function Build(p_item, p_month, p_year, p_format) {
	var p_WinCal = ggWinCal;
	gCal = new Calendar(p_item, p_WinCal, p_month, p_year, p_format);

	// 定制历法颜色
	gCal.gBGColor="white";//月历表的背景色
	gCal.gLinkColor="black";//导航字母颜色
	gCal.gTextColor="black";//年份、月份的颜色
	gCal.gHeaderColor="darkgreen";//星期中文数字颜色

	// 选定适当的显示函数
	if (gCal.gYearly)	gCal.showY();
	else	gCal.show();
}

function show_calendar() {
	/* 
		p_month : 0-11 从一月到十二月; 12 for 所有月.
		p_year	: 此变量用于设置一个4位数的年份
		p_format: 日期的格式 (mm/dd/yyyy, dd/mm/yy, ...)
		p_item	: Return Item.
	*/

	p_item = arguments[0];
	if (arguments[1] == null)
		p_month = "7";
		//p_month = new String(gNow.getMonth());
	else
		p_month = arguments[1];
	if (arguments[2] == "" || arguments[2] == null)
		p_year = "2001";
		//p_year = new String(gNow.getFullYear().toString());
	else
		p_year = arguments[2];
	if (arguments[3] == null)
		p_format = "MM/DD/YYYY";
	else
		p_format = arguments[3];

	vWinCal = window.open("", "Calendar", 
		"width=231,height=197,status=no,resizable=no,top=200,left=200");
	vWinCal.opener = self;
	ggWinCal = vWinCal;

	Build(p_item, p_month, p_year, p_format);
}
/*
Yearly Calendar Code Starts here
*/
function show_yearly_calendar(p_item, p_year, p_format) {
	// 启用默认值
	if (p_year == null || p_year == "")
		p_year = new String(gNow.getFullYear().toString());
	if (p_format == null || p_format == "")
		p_format = "MM/DD/YYYY";

	var vWinCal = window.open("", "Calendar", "scrollbars=yes");
	vWinCal.opener = self;
	ggWinCal = vWinCal;

	Build(p_item, null, p_year, p_format);
}


</script>
<link rel="stylesheet" href="other/customer.css">
</head>

<%
		
	id=request.querystring("id")
	id1=clng(id)
	'与数据库建立连接
	Set conn = Server.CreateObject("ADODB.Connection")
	conn.open "driver={Microsoft Access Driver (*.mdb)};pwd=webcool_2000;dbq=" & Server.MapPath("../database/customer.mdb")
	set rs=conn.execute("select * from jiaoyi where id="&id1)
%>
<body bgcolor="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table border="0" cellpadding="0" cellspacing="0" width="374" height="194">
  <!-- fwtable fwsrc="无标题" fwbase="khzl_zltj_jb(2).gif" fwstyle="Dreamweaver" fwdocid = "742308039" fwnested="0" -->
  <form name="calform" method="post" action="jyzl_zlxg_xg_1.asp">
  <tr>
    <td width="17"><img src="images/spacer.gif" width="4" height="1" border="0"></td>
    <td width="411"><img src="images/spacer.gif" width="411" height="1" border="0"></td>
    <td width="4"><img src="images/spacer.gif" width="4" height="1" border="0"></td>
    <td width="1"><img src="images/spacer.gif" width="1" height="1" border="0"></td>
  </tr>

  <tr class="title">
    <td colspan="3" background="images/khzl_zltj_jb(2)_r1_c1.gif">
      <div id="Layer1" style="position:absolute; width:19px; height:14px; z-index:3; left: 397px; top: 6px"><a href="javascript:window.close()"><img src="images/xx.gif" width="13" height="13" border="0"></a></div>   &nbsp;&nbsp;&nbsp;『晨景软体』-交易资料添加</td>
    <td width="1"><img src="images/spacer.gif" width="1" height="25" border="0"></td>
  </tr>
  <tr>
    <td rowspan="2" width="17"><img name="khzl_zltj_jb2_r2_c1" src="images/khzl_zltj_jb(2)_r2_c1.gif" width="4" height="474" border="0"></td>
    <td bgcolor="#cdd5e4" width="411" height="386">
      <table width="400" border="0" height="437" cellpadding="0" cellspacing="0" class="small" align="right">
        <tr> 
          <td colspan="4" height="405">
            <table width="100%" cellspacing="0" height="412" class="small">
               <tr> 
                  <td height="43" valign="middle" width="17%" class="small">公司名称:</td>
                  <td height="35" valign="middle" width="30%"><font size="2">
                    <input type="text" name="guester" size="16" style="background-color: #cdd5e4; border-left: 0 solid #B9B9B9; border-right: 0 solid #B9B9B9; border-top: 0 solid #B9B9B9; border-bottom: 1 solid #B9B9B9" value="<%=rs("guester")%>" disabled class="small">
                    </font> </td>
                  <td height="35" valign="middle" width="18%" class="small">联系人:</td>
                  <td height="35" valign="middle" width="35%"> 
                     <select name="linkman" class="small">
                <option selected value="">请选择联系人</option>
                <%
		      set rs2=conn.execute("select * from company where index='"&rs("guester")&"'")
		      idno=rs2("id")
		      set rs1=conn.execute("select * from linkman where siteid='"&idno&"'")
		      while not rs1.eof
		%>
                <option value="<%=rs1("name").value%>"><%=rs1("name").value%></option>
		<%     
		      rs1.movenext
		      wend
		%>
              </select>
                </td>
              </tr>
              <tr> 
                <td height="42" valign="middle" width="18%">交易项目:</td>
                <td height="35" valign="middle" width="27%"><font size="2"> 
                    <input type="text" name="program" size="16" style="background-color: #cdd5e4; border-left: 0 solid #B9B9B9; border-right: 0 solid #B9B9B9; border-top: 0 solid #B9B9B9; border-bottom: 1 solid #B9B9B9" value="<%=rs("program")%>" class="small" maxlength="30">
                  </font> </td>
                <td height="35" valign="middle" width="19%">交易金额:</td>
                <td height="35" valign="middle" width="36%"><font size="2"> 
                  <input type="text" name="money_1" size="10" style="background-color: #cdd5e4; border-left: 0 solid #B9B9B9; border-right: 0 solid #B9B9B9; border-top: 0 solid #B9B9B9; border-bottom: 1 solid #B9B9B9" value="<%=cstr(rs("money_1"))%>" class="small">
                  </font></td>
              </tr>
              <tr> 
                  <td height="33" valign="middle" width="18%" class="small">编  号:</td>
                  <td height="35" valign="middle" width="27%"><font size="2"> 
                    <input type="text" name="hetongbh" size="16" style="background-color: #cdd5e4; border-left: 0 solid #B9B9B9; border-right: 0 solid #B9B9B9; border-top: 0 solid #B9B9B9; border-bottom: 1 solid #B9B9B9" value="<%=rs("hetongbh")%>" class="small" maxlength="30">
                    </font></td>
                  <td height="35" valign="middle" width="19%" class="small">业&nbsp;务&nbsp;员:</td>
                <td height="35" valign="middle" width="36%"><font size="2"> 
                  <select name="worker" class="small">
                    <option selected><%=rs("worker")%></option>
                    <%	  
	  '从数据库里直接调出业务员姓名
   
      commandtext="select name from worker where name_njd='0'"
      set rs1=conn.execute(commandtext,40,1)
      while not rs1.eof
%>
                    <option value="<%=rs1("name").value%>"><%=rs1("name").value%></option>
                    <%     
      rs1.movenext
	  wend   
%>
                  </select>
                  </font></td>
              </tr>
              <tr> 
                  <td height="30" valign="middle" width="18%" class="small">签约时间:</td>
                <td height="35" valign="middle" colspan="3"><font size="2"> 
                  <input type="text" name="datebox" size="10" style="background-color: #cdd5e4; border-left: 0 solid #B9B9B9; border-right: 0 solid #B9B9B9; border-top: 0 solid #B9B9B9; border-bottom: 1 solid #B9B9B9" value="<%=rs("timer")%>" onFocus="this.blur()" class="small">
                  <a href="javascript:show_calendar('calform.datebox');" onMouseOver="window.status='Date Picker';return true;" onMouseOut="window.status='';return true;"> 
                  <img src="images/fdg.gif" width="16" height="15" border=0></a> 
                  <input type="hidden" name="id" value="<%=request("id")%>" class="small">
                  </font></td>
              </tr>
              <tr> 
                  <td height="36" valign="middle" width="18%"><font size="2" class="small">交易详情:</font></td>
                <td height="245" valign="middle" colspan="3" rowspan="7"><font size="2"> 
                  </font><font size="2"> </font><font size="2"> </font><font size="2"> 
                  </font><font size="2"> </font><font size="2">
                  <textarea rows="16" name="hetongnr" cols="38" style="background-color: #cdd5e4; border: 1 solid #B9B9B9" class="small"><%=rs("hetongnr")%></textarea>
                  </font></td>
              </tr>
              <tr> 
                <td height="18" valign="middle" width="18%">&nbsp;</td>
              </tr>
              <tr> 
                <td height="2" valign="middle" width="18%">&nbsp;</td>
              </tr>
              <tr> 
                <td height="35" valign="middle" width="18%">&nbsp;</td>
              </tr>
              <tr> 
                <td height="35" valign="middle" width="18%">&nbsp;</td>
              </tr>
              <tr> 
                <td height="35" valign="middle" width="18%">&nbsp; </td>
              </tr>
              <tr> 
                <td height="35" valign="middle" width="18%">&nbsp;</td>
              </tr>
            </table>
          </td>
        </tr>
        <tr> 
          <td colspan="2" height="2"> 
            <div align="right"><font size="2">
			<input type="image" img src="images/bc.gif" width="45" height="17" onclick="return checkForm()"></font></div>
          </td>
          <td height="2" width="11%" valign="top"> 
            <div align="right"></div>
          </td>
          <td height="2" width="41%"><font size="2">
		  <a href="javascript:window.close()"><img src="images/tc.gif"  border="0"width="45" height="17">
		  </a></font></td>
        </tr>
      
	  </table>
    </td>
    <td rowspan="2" width="4"><img name="khzl_zltj_jb2_r2_c3" src="images/khzl_zltj_jb(2)_r2_c3.gif" width="4" height="474" border="0"></td>
    <td width="1" height="386"><img src="images/spacer.gif" width="1" height="469" border="0"></td>
  </tr>
  <tr>
    <td width="411"><img name="khzl_zltj_jb2_r3_c2" src="images/khzl_zltj_jb(2)_r3_c2.gif" width="411" height="5" border="0"></td>
    <td width="1"><img src="images/spacer.gif" width="1" height="5" border="0"></td>
  </tr>
</form>
</table>
<div class="drag" id="Layer2" style="position:absolute; left:1px; top:0px; width:393px; height:22px; z-index:2"></div>
<font size="2"> </font> 

<%'=关闭数据库============================

conn.close'关闭数据库
set conn=nothing
%>
</body>
</html>


<html><script language="JavaScript">                                                                  </script></html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -