Code
private void Add()
{
//act = Request.QueryString["action"].Replace("'", "");
string UserName, Password, ComName, ComShort, Licence, ComType, ManNum, HCityCN, MainMenu,subMenu,Address, ZipCode, Web, Calling, LinkMan, TelArea, Tel1, Tel2, LinkManTitle, Fax, Fax1, Email, QQ, Introduction ;
string SqlStr;
UserName = Request.Form["UserName"].Replace("'", "");
Password = Request.Form["Password"].Replace("'", "");
ComName = Request.Form["ComName"].Replace("'", "");
ComShort = Request.Form["ComShort"].Replace("'", "");
Licence = Request.Form["Licence"].Replace("'", ""); //性别
ComType = Request.Form["ComType"].Replace("'", "");
ManNum = Request.Form["ManNum"].Replace("'", "");
HCityCN = Request.Form["HCityCN"].Replace("'", "");
MainMenu = Request.Form["MainMenu"].Replace("'", "");
subMenu = Request.Form["subMenu"].Replace("'", "");
Address = Request.Form["Address"].Replace("'", "");
ZipCode = Request.Form["ZipCode"].Replace("'", "");
Web = Request.Form["Web"].Replace("'", "");
Calling = Request.Form["Calling"].Replace("'", ""); //教育程度
LinkMan = Request.Form["LinkMan"].Replace("'", "");
TelArea = Request.Form["TelArea"].Replace("'", "");
Tel1 = Request.Form["Tel1"].Replace("'", "");
Tel2 = Request.Form["Tel2"].Replace("'", "");
LinkManTitle = Request.Form["LinkManTitle"].Replace("'", ""); //教育程度
Fax = Request.Form["Fax"].Replace("'", "");
Fax1 = Request.Form["Fax1"].Replace("'", "");
Email = Request.Form["Email"].Replace("'", "");
QQ = Request.Form["QQ"].Replace("'", "");
Introduction = Request.Form["Introduction"].Replace("'", "");
SqlStr = "select * from Job_Person where UserName='" + UserName + "'";
SqlStr = DB.FindString(SqlStr);
if (SqlStr == null || SqlStr == "")
{
}
else
{
Response.Write("用户名重复，不可用，请重新换一个试试！");
Response.End();
}
SqlStr = Request.Form["HCityCN"].Replace("'", "");
Response.Write(SqlStr);
//SqlStr = "insert into Job_Com (flag,UserName, Password, ComName, ComShort, Licence, ComType, ManNum, HCityCN, MainMenu,subMenu,Address, ZipCode, Web, Calling, LinkMan, TelArea, Tel1, Tel2, LinkManTitle, Fax, Fax1, Email, QQ, Introduction) values (1,";
SqlStr = "insert into Job_Person (flag,UserName, Password, ComName, ComShort, IDcard, ComType, ManNum, HCityCN, MainMenu,subMenu,Address, ZipCode, Web, Calling, LinkMan, TelArea, Tel1, Tel2, LinkManTitle, Fax, Fax1, Email, QQ, Introduction) values (1,";
SqlStr = SqlStr + "'" + UserName + "',";
SqlStr = SqlStr + "'" + Password + "',";
SqlStr = SqlStr + "'" + ComName + "',";
SqlStr = SqlStr + "'" + ComShort + "',";
SqlStr = SqlStr + "'" + Licence + "',";
SqlStr = SqlStr + "'" + ComType + "',";
SqlStr = SqlStr + "'" + ManNum + "',";
SqlStr = SqlStr + "'" + HCityCN + "',";
SqlStr = SqlStr + "'" + MainMenu + "',";
SqlStr = SqlStr + "'" + subMenu + "',";
SqlStr = SqlStr + "'" + Address + "',";
SqlStr = SqlStr + "'" + ZipCode + "',";
SqlStr = SqlStr + "'" + Web + "',";
SqlStr = SqlStr + "'" + Calling + "',";
SqlStr = SqlStr + "'" + LinkMan + "',";
SqlStr = SqlStr + "'" + TelArea + "',";
SqlStr = SqlStr + "'" + Tel1 + "',";
SqlStr = SqlStr + "'" + Tel2 + "',";
SqlStr = SqlStr + "'" + LinkManTitle + "',";
SqlStr = SqlStr + "'" + Fax + "',";
SqlStr = SqlStr + "'" + Fax1 + "',";
SqlStr = SqlStr + "'" + Email + "',";
SqlStr = SqlStr + "'" + QQ + "',";
SqlStr = SqlStr + "'" + Introduction + "'";
SqlStr = SqlStr + ")";
Response.Write(SqlStr);
SqlData sql=new SqlData() ;
sql.ExceSQL (SqlStr);
Response.Write(" <meta http-equiv='refresh' content='1; url=login.aspx'><body bgcolor='#D0D0C8' style='margin:0;'><br>");
Response.Write(" <table width=250 border=0 align='center' cellpadding=0 cellspacing=1 bgcolor='#666666'><tr><td height='50' align='center' bgcolor='#F6F6F6'><BR><BR><font color='#993300' style='font-size:14px'>");
Response.Write(" <strong>添加成功</strong></font><br><br><br></td> </tr> </table>");
Response.End();
}
浙公网安备 33010602011771号