仿京东收获
来源：互联网 发布：入门手柄 知乎 编辑：程序博客网 时间：2024/05/23 13:53
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]-->
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
public partial class business : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
if (Session["msg"].ToString() == TextBox4.Text) //这里是判断用记输入的验证码
{
Label1.Text = "";
string sr = "select * from usertable";
string str = Convert.ToString(Class1.checkrecord(TextBox1.Text, sr));
if (str == "OK")
{
Label1.Text = "用户名已经存在!";
}
else
{
InsertRecord(); //调用写信息函数
}
}
else
{
Label1.Text = "验证码有误!";
}
}
private void InsertRecord()
{
using (SqlConnection con = new SqlConnection(Class1.cnnstring))
{
using (SqlCommand cmd = new SqlCommand("insert UserTable values(@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();
SqlTransaction stran = con.BeginTransaction();
cmd.Transaction = stran;
try
{
int userid = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Parameters.Clear();
string leibie = "";
foreach (ListItem item in CheckBoxList1.Items)
{
if (item.Selected)
{
leibie += "," + item.Value.ToString();
}
}
string str = "insert business values(@uid,@truename,@department,@call,@phone,@companyname,@companyszd,@companyadress,@buycategory,@webadress,@companypersons,@companywork,@companyquality)";
Class1.executenum(str
, new SqlParameter("@uid", userid)
, new SqlParameter("@truename", TextBox5.Text)
,new SqlParameter("@department", DropDownList1.SelectedItem.Text)
, new SqlParameter("@call", TextBox6.Text)
, new SqlParameter("@phone", TextBox7.Text)
, new SqlParameter("@companyname", TextBox9.Text)
, new SqlParameter("@companyszd", DropDownList2.SelectedItem.Text + DropDownList3.SelectedItem.Text + DropDownList4.SelectedItem.Text)
, new SqlParameter("@companyadress", TextBox10.Text)
, new SqlParameter("@buycategory", leibie.Substring(1))
, new SqlParameter("@webadress", TextBox11.Text)
, new SqlParameter("@companypersons", DropDownList5.SelectedItem.Text)
, new SqlParameter("@companywork", DropDownList6.SelectedItem.Text)
, new SqlParameter("@companyquality", DropDownList7.SelectedItem.Text)
);
stran.Commit();//提交事物
}
catch (Exception ex)
{
Response.Write(ex.Message);
stran.Rollback();//回滚事物
}
}
}
} //向数据库中写用户的注册信息
}
