<tr><td align="right" height="30">房号：</td>
<td class="category"><input type="text" name="fanghao" style="width:110px" value="<%=rs("fanghao")%>">
<font color="#ff0000">*</font></td>
<td height="30" align="right">业主姓名：</td>
<td class="category"><input type="text" name="username" style="width:80px" value="<%=rs("username")%>"> <font color="#ff0000">*</font></td></tr>
<tr><td align="right" height="30">业主性别：</td>
<td class="category">
<input type="radio" name="xingbie" value="男"<%if rs("xingbie")="男" then%> checked="checked"<%end if%>> 男
<input type="radio" name="xingbie" value="女"<%if rs("xingbie")="女" then%> checked="checked"<%end if%>> 女</td>
<td align="right" height="30">联系电话：</td>
<td class="category"><input type="text" name="tel" style="width:200px" value="<%=rs("tel")%>"></td></tr>
<tr><td align="right" height="30">QQ：</td>
<td class="category"><input type="text" name="qq" style="width:110px" value="<%=rs("qq")%>" onKeyUp="this.value=this.value.replace(/\D/g,'')" onafterpaste="this.value=this.value.replace(/\D/g,'')"></td>
<td align="right" height="30">Email：</td>
<td class="category"><input type="text" name="email" style="width:160px" value="<%=rs("email")%>"></td></tr>
<tr><td align="right" height="30">家庭住址：</td>
<td class="category"><input type="text" name="address" style="width:250px" value="<%=rs("address")%>"></td>
<td align="right" height="30">身份证号：</td>
<td class="category"><input type="text" name="zhenghao" style="width:160px" value="<%=rs("zhenghao")%>"></td></tr>
<tr><td align="right" height="30">介绍人：</td>
<td class="category">
<%
if rs("jieshao")=0 then
nowjieshao="无"
else
sql="select * from yezhu where id="&rs("jieshao")
set rs_jieshao=conn.execute(sql)
nowjieshao=rs_jieshao("username")
end if
%>
<%=nowjieshao%></td>
<td align="right" height="30">经办人：</td>
<td class="category">
<%
if request.Cookies("shiwei_id")=1 then
sql="select * from login order by bumen,id"
set rs_login=conn.execute(sql)
else
sql="select * from login where id="&request.Cookies("shiwei_id")
set rs_login=conn.execute(sql)
end if
if rs_login.eof then
%>
<script language="javascript">
alert("请先添加员工！")
window.location.href="../system/user_add.asp"
</script>
<%
response.end
else
%>
<select name="jingban">
<%do while rs_login.eof=false%>
<option value="<%=rs_login("id")%>"<%if rs_login("id")=rs("jingban") then%> selected="selected"<%end if%>><%=rs_login("username")%> (<%=rs_login("gonghao")%>)</option>
<%
rs_login.movenext
loop
%>
</select>
<%end if%></td></tr>
<tr><td align="right" height="30">业主生日：</td>
<td class="category"><input name="shengri" value="<%=rs("shengri")%>" readonly style="width:100px"><img src="../images/date.gif" align="absmiddle" style="cursor:pointer;" onClick="JavaScript:window.open('day.asp?form=form1&field=shengri&oldDate='+shengri.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=470,left=520');">
<select name="yinyang">
<option value="阴"<%if rs("yinyang")="阴" then%> selected="selected"<%end if%>>阴历</option>
<option value="阳"<%if rs("yinyang")="阳" then%> selected="selected"<%end if%>>阳历</option>
</select></td>
<td align="right" height="30">业主积分：</td>
<td class="category"><input type="text" name="jifen" style="width:100px" value="<%=rs("jifen")%>" onKeyUp="value=value.replace(/[^\d.]/g,'')" onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d.]/g,''))"></td></tr>
<tr><td align="right" height="30">入住时间：</td>
<td class="category"><input name="startdate" value="<%=rs("startdate")%>" readonly style="width:100px"><img src="../images/date.gif" align="absmiddle" style="cursor:pointer;" onClick="JavaScript:window.open('day.asp?form=form1&field=startdate&oldDate='+startdate.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=150,left=590');"> </td>
<td align="right" height="30">到期时间：</td>
<td class="category"><input name="enddate" value="<%=rs("enddate")%>" readonly style="width:100px"><img src="../images/date.gif" align="absmiddle" style="cursor:pointer;" onClick="JavaScript:window.open('day.asp?form=form1&field=enddate&oldDate='+enddate.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=150,left=590');"> </td></tr>
<tr><td align="right" height="30">缴水费日：</td>
<td class="category"><input name="shui" value="<%=rs("shui")%>" readonly style="width:100px"><img src="../images/date.gif" align="absmiddle" style="cursor:pointer;" onClick="JavaScript:window.open('day.asp?form=form1&field=shui&oldDate='+shui.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=470,left=520');"></td>
<td align="right" height="30">缴电费日：</td>
<td class="category"><input name="dian" value="<%=rs("dian")%>" readonly style="width:100px"><img src="../images/date.gif" align="absmiddle" style="cursor:pointer;" onClick="JavaScript:window.open('day.asp?form=form1&field=dian&oldDate='+dian.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=470,left=520');"></td></tr>
<tr><td align="right" height="30">缴物管费日：</td>
<td class="category"><input name="wuye" value="<%=rs("wuye")%>" readonly style="width:100px"><img src="../images/date.gif" align="absmiddle" style="cursor:pointer;" onClick="JavaScript:window.open('day.asp?form=form1&field=wuye&oldDate='+wuye.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=470,left=520');"></td>
<td align="right" height="30">缴其他费日：</td>
<td class="category"><input name="qita" value="<%=rs("qita")%>" readonly style="width:100px"><img src="../images/date.gif" align="absmiddle" style="cursor:pointer;" onClick="JavaScript:window.open('day.asp?form=form1&field=qita&oldDate='+qita.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=470,left=520');"></td></tr>
<tr><td align="right" height="30">备注：</td>
<td class="category"><textarea name="beizhu" cols="70" rows="4"><%=rs("beizhu")%></textarea></td></tr>
<tr><td height="30"> </td>
<td class="category"><input type="submit" value="确认修改" onClick="return check()" class="button"> <input type="reset" value="重置" class="button"> <input type="button" value="放弃修改返回" onClick="window.history.go(-1)" class="button"><input type="hidden" name="hid1" value="ok"><input type="hidden" name="id" value="<%=request("id")%>"></td></tr>
</table></td>
<td></td>
</tr>
<tr><td><img src="../images/r_4.gif" alt="" /></td>
<td></td>
<td><img src="../images/r_3.gif" alt="" /></td>
</tr></table></form>
<%
else
nowqq=request("qq")
nowemail=request("email")
nowlouyu=request("louyu")
nowusername=request("username")
nowxingbie=request("xingbie")
nowtel=request("tel")
nowaddress=request("address")
nowzhenghao=request("zhenghao")
nowfanghao=request("fanghao")
nowjingban=request("jingban")
nowjifen=request("jifen")
nowbeizhu=request("beizhu")
nowstartdate=request("startdate")
nowenddate=request("enddate")
nowshengri=request("shengri")
nowyinyang=request("yinyang")
nowxiaoqu=request("xiaoqu")
nowshui=request("shui")
nowdian=request("dian")
nowwuye=request("wuye")
nowqita=request("qita")
sql="select * from yezhu where fanghao='"&nowfanghao&"' and id<>"&request("id")
set rs=conn.execute(sql)
if rs.eof=false then
%>
<script language="javascript">
alert("您输入的房号已经存在,请重新输入！")
window.history.go(-1)
</script>
<%
response.end
end if
set rs_login=conn.execute("select * from login where id="&nowjingban)
nowlogin=rs_login("username")
set rs=server.createobject("ADODB.RecordSet")
sql="select * from yezhu where id="&request("id")
rs.open sql,conn,1,3
rs("fanghao")=nowfanghao
rs("username")=nowusername
rs("xingbie")=nowxingbie
rs("tel")=nowtel
rs("address")=nowaddress
rs("zhenghao")=nowzhenghao
rs("jingban")=nowjingban
rs("fuzeren")=nowfuzeren
rs("jifen")=nowjifen
rs("beizhu")=nowbeizhu
rs("startdate")=nowstartdate
rs("enddate")=nowenddate
rs("shengri")=nowshengri
rs("yinyang")=nowyinyang
rs("qq")=nowqq
rs("email")=nowemail
rs("louyu")=nowlouyu <-------第280行
rs("xiaoqu")=nowxiaoqu
rs("shui")=nowshui
rs("dian")=nowdian
rs("wuye")=nowwuye
rs("qita")=nowqita
rs.update
%>
<script language="javascript">
alert("业主资料修改成功！")
window.location.href="yezhu.asp?form=<%=request("form")%>&field=<%=request("field")%>&field2=<%=request("field2")%>&field3=<%=request("field3")%>&page=<%=request("page")%>&louyu=<%=request("louyu")%>&keyword=<%=request("keyword")%>&order1=<%=request("order1")%>&order2=<%=request("order2")%>&order3=<%=request("order3")%>&order4=<%=request("order4")%>&order5=<%=request("order5")%>&order6=<%=request("order6")%>&order7=<%=request("order7")%>&order8=<%=request("order8")%>&order9=<%=request("order9")%>&order10=<%=request("order10")%>&order11=<%=request("order11")%>&order12=<%=request("order12")%>&order13=<%=request("order13")%>&order14=<%=request("order14")%>&order15=<%=request("order15")%>"
</script>
<%end if%>
</body></html>================================代码结束
[
本帖最后由 天蝎风 于 2010-11-17 12:06 编辑 ]
