仿京东收获

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;

public partial class shoppinglist : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
province();
}
}
protected void province()
{
string str = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
using(SqlConnection con=new SqlConnection(str))
{
using (SqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "select * from province";
SqlDataReader reader = null;
try
{
con.Open();
reader = cmd.ExecuteReader();
ListItem li;
this.DropDownList1.Items.Add(new ListItem("-请选择-", "0"));
while (reader.Read())
{
li = new ListItem(reader[1].ToString(), reader["id"].ToString());
this.DropDownList1.Items.Add(li);
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{

string str = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
using (SqlConnection con = new SqlConnection(str))
{
using (SqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "select id,name from city where provinceid=@pid";
SqlParameter parm = new SqlParameter("@pid", System.Data.SqlDbType.Int);
parm.Value = DropDownList1.SelectedValue;
cmd.Parameters.Add(parm);
//SqlDataReader reader = null;
try
{
con.Open();

//reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dt);
this.DropDownList2.DataSource = dt;
this.DropDownList2.DataTextField = "name";
this.DropDownList2.DataValueField = "id";
this.DropDownList2.Items.Clear();
this.DropDownList2.Items.Add(new ListItem("-请选择-", "0"));
this.DropDownList2.DataBind();


}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
}
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
string str = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
using (SqlConnection con = new SqlConnection(str))
{
using (SqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "select id,name from countryside where cityid=@pid";
SqlParameter parm = new SqlParameter("@pid", System.Data.SqlDbType.Int);
parm.Value = DropDownList2.SelectedValue;
cmd.Parameters.Add(parm);
try
{
con.Open();
DataTable dt = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dt);
this.DropDownList3.DataSource = dt;
this.DropDownList3.DataTextField = "name";
this.DropDownList3.DataValueField = "id";
this.DropDownList3.Items.Clear();
this.DropDownList3.Items.Add(new ListItem("-请选择-", "0"));
this.DropDownList3.DataBind();

}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
}
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
string str = "insert shopping values(@name,@prove,@adress,@call,@email,@code,@pname,@pnum,@pprice,@pdate)";
Class1.executenum(str
,new SqlParameter("@name",TextBox1.Text)
,new SqlParameter("@prove",DropDownList1.SelectedItem.Text+DropDownList2.SelectedItem.Text+DropDownList3.SelectedItem.Text)
,new SqlParameter("@adress",TextBox2.Text)
,new SqlParameter();
);


}

}

<!--[if gte mso 9]><![endif]-->

usingSystem;

usingSystem.Collections.Generic;

usingSystem.Linq;

usingSystem.Web;

usingSystem.Web.UI;

usingSystem.Web.UI.WebControls;

usingSystem.Data.SqlClient;

publicpartialclassbusiness:System.Web.UI.Page

{

protectedvoidPage_Load(objectsender,EventArgse)

{

}

protectedvoidImageButton1_Click(objectsender,ImageClickEventArgse)

{

if(Session["msg"].ToString()==TextBox4.Text)//这里是判断用记输入的验证码

{

Label1.Text="";

stringsr="select*fromusertable";

stringstr=Convert.ToString(Class1.checkrecord(TextBox1.Text,sr));

if(str=="OK")

{

Label1.Text="用户名已经存在!";

}

else

{

InsertRecord();//调用写信息函数

}

}

else

{

Label1.Text="验证码有误!";

}

}

privatevoidInsertRecord()

{

using(SqlConnectioncon=newSqlConnection(Class1.cnnstring))

{

using(SqlCommandcmd=newSqlCommand("insertUserTablevalues(@name,@pwd,@mail,@category,@tjperson);select@@IDENTITY",con))

{

cmd.Parameters.Add("@name",System.Data.SqlDbType.VarChar,20).Value=TextBox1.Text;

cmd.Parameters.Add("@pwd",System.Data.SqlDbType.VarChar,20).Value=TextBox2.Text;

cmd.Parameters.Add("@mail",System.Data.SqlDbType.VarChar,50).Value=TextBox8.Text;

cmd.Parameters.Add("@category",System.Data.SqlDbType.TinyInt).Value="3";

cmd.Parameters.Add("@tjperson",System.Data.SqlDbType.VarChar,20).Value="本公司";

con.Open();

SqlTransactionstran=con.BeginTransaction();

cmd.Transaction=stran;

try

{

intuserid=Convert.ToInt32(cmd.ExecuteScalar());

cmd.Parameters.Clear();

stringleibie="";

foreach(ListItemiteminCheckBoxList1.Items)

{

if(item.Selected)

{

leibie+=","+item.Value.ToString();

}

}

stringstr="insertbusinessvalues(@uid,@truename,@department,@call,@phone,@companyname,@companyszd,@companyadress,@buycategory,@webadress,@companypersons,@companywork,@companyquality)";

Class1.executenum(str

,newSqlParameter("@uid",userid)

,newSqlParameter("@truename",TextBox5.Text)

,newSqlParameter("@department",DropDownList1.SelectedItem.Text)

,newSqlParameter("@call",TextBox6.Text)

,newSqlParameter("@phone",TextBox7.Text)

,newSqlParameter("@companyname",TextBox9.Text)

,newSqlParameter("@companyszd",DropDownList2.SelectedItem.Text+DropDownList3.SelectedItem.Text+DropDownList4.SelectedItem.Text)

,newSqlParameter("@companyadress",TextBox10.Text)

,newSqlParameter("@buycategory",leibie.Substring(1))

,newSqlParameter("@webadress",TextBox11.Text)

,newSqlParameter("@companypersons",DropDownList5.SelectedItem.Text)

,newSqlParameter("@companywork",DropDownList6.SelectedItem.Text)

,newSqlParameter("@companyquality",DropDownList7.SelectedItem.Text)

);

stran.Commit();//提交事物

}

catch(Exceptionex)

{

Response.Write(ex.Message);

stran.Rollback();//回滚事物

}

}

}

}//向数据库中写用户的注册信息

}