private void chksADmin()
{
if (TxtUserName.Text == "" && TxtPassword.Text == "")
{
Alert.AlertAndRedirect("请输入账号密码！", "Login.aspx");
}
else
{
dr = data.GetDataReader("select * from superadmin where name='" + TxtUserName.Text.Trim() + "'and password='******'");
if (dr.Read())
{
Session["superadminid"] = dr["id"].ToString();
Session["superadmin"] = dr["name"].ToString();
Response.Redirect("superadmin/main.html");
}
else
{
Alert.AlertAndRedirect("账号或密码错误，请重新登录！", "Login.aspx");
}
}
}
private void chkADmin()
{
if (TxtUserName.Text == "" && TxtPassword.Text == "")
{
Alert.AlertAndRedirect("没有输入账号和密码！", "Login.aspx");
}
else
{
dr = data.GetDataReader("select * from admin where admin='" + TxtUserName.Text.Trim() + "'and password='******' ");
if (dr.Read())
{
Session["admin"] = dr["admin"].ToString();
Response.Redirect("index.html");
}
else
{
Alert.AlertAndRedirect("管理员的账号或者密码不对请重新登陆！", "login.aspx");
}
}
}
private void chkTeacUser()
{
if (UserName.Text == "" && PassWord.Text == "")
{
Alert.AlertAndRedirect("没有输入账号和密码！", "Login.aspx");
}
else
{
dr = data.GetDataReader("select * from [Teachter] where Name='" + UserName.Text.Trim() + "'and Pwd='" + PassWord.Text.Trim() + "'");
if (dr.Read())
{
Session["User"] = dr["Name"].ToString();
Session["UserId"] = dr["id"].ToString();
Response.Redirect("Teachter/Default.aspx");
}
else
{
Alert.AlertAndRedirect("账号或者密码不对请重新登陆！", "Login.aspx");
}
}
}
private void chkADmin()
{
if (TxtUserName.Text == "" && TxtPassword.Text == "")
{
Alert.AlertAndRedirect("没有输入账号和密码！", "Login.aspx");
}
else
{
dr = data.GetDataReader("select * from admin where name='" + TxtUserName.Text.Trim() + "'and Pwd='" + TxtPassword.Text.Trim() + "'");
if (dr.Read())
{
Session["adminid"] = dr["id"].ToString();
Session["admin"] = dr["name"].ToString();
Response.Redirect("Admin/main.html");
}
else
{
Alert.AlertAndRedirect("管理员的账号或者密码不对请重新登陆！", "Login.aspx");
}
}
}
protected void buyNow_Click(object sender, EventArgs e)
{
if (float.Parse(Label5.Text) < float.Parse(sellCount.Text))
{
Alert.AlertAndRedirect("对不起您购买的商品不能大于库存数量", "ShowShangPin.aspx?id=" + Request.QueryString["id"].ToString());
return;
}
int i;
Hashtable Hash;
//如果用户没有购物车，新生成一个
if (Session["ShoppingCar"] == null)
{
Hash = new Hashtable();
}
else
{
//若用户已有购物车，则获取购物车对象
Hash = (Hashtable)Session["ShoppingCar"];
}
string tb = sellCount.Text;
string lb = Request.QueryString["id"].ToString();
if (Int32.Parse(tb) > 0)
{
//如果购物车没有此商品，则新添加一个项
if (!Hash.ContainsKey(lb))
{
//MyHashTable.add(index,object) index为hash表的关键字，Object为具体的内容
Hash.Add(lb, Int32.Parse(tb));
}
//若购车车已存在该商品，则该商品数量+1
else
{
Hash[lb] = (int)Hash[lb] + Convert.ToInt32(tb);
}
}
Session["ShoppingCar"] = Hash;
Response.Redirect("ByNow.aspx");
}
protected void Button2_Click(object sender, EventArgs e)
{
if (Request.QueryString["Type"].ToString() == "单选题")
{
string Title = content1.Value;
string AnswerA = txtAnswerA.Text;
string AnswerB = txtAnswerB.Text;
string AnswerC = txtAnswerC.Text;
string AnswerD = txtAnswerD.Text;
string Answer = ddlAnswer.SelectedItem.Text;
TD6.Visible = false;
TD1.Visible = true;
TD2.Visible = true;
TD3.Visible = true;
TD4.Visible = true;
TD5.Visible = true;
mydata.RunSql("update TiMu set Title='" + Title + "',AnswerA='" + AnswerA + "',AnswerB='" + AnswerB + "',AnswerC='" + AnswerC + "',AnswerD='" + AnswerD + "',Answer='" + Answer + "',Mark='" + txtScore.Text + "' where id=" + Request.QueryString["id"].ToString());
Alert.AlertAndRedirect("修改成功！", "TiMuLists.aspx");
}
else
{
string Title = content1.Value;
TD6.Visible = true;
TD1.Visible = false;
TD2.Visible = false;
TD3.Visible = false;
TD4.Visible = false;
TD5.Visible = false;
mydata.RunSql("update TiMu set Title='" + Title + "',Answer='" + TextBox1.Text + "',Mark='" + txtScore.Text + "' where id=" + Request.QueryString["id"].ToString());
Alert.AlertAndRedirect("修改成功！", "TiMuLists.aspx");
}
}
protected void btnShop_Click(object sender, EventArgs e)
{
if (float.Parse(Label5.Text) < float.Parse(TextBox1.Text))
{
Alert.AlertAndRedirect("对不起您购买的服装不能大于库存数量", "ShowShangPin.aspx?id=" + Request.QueryString["id"].ToString());
}
else
{
string Orderid;
if (Session["UserName"] == null)
{
Alert.AlertAndRedirect("您还没有登录，请登录后再购买，谢谢合作！", "Default.aspx");
}
else
{
SqlDataReader dr = data.GetDataReader("select top 1 * from ZhuDingDan where IsCheckout='否' and Ordeuser='******' order by id desc ");
if (dr.Read())
{
Orderid = dr["Orderid"].ToString();
}
else
{
Orderid = DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString();
string sqlOrder = "insert into ZhuDingDan(Orderid,Ordeuser,OrderStite,ShangPinId,shuliang)values('" + Orderid + "','" + Session["UserName"].ToString() + "','未发货','" + Request.QueryString["id"].ToString() + "','" + TextBox1.Text + "')";
data.RunSql(sqlOrder);
}
sqlconn.Open();
string strid = Page.Request.QueryString["ShangPinID"];
float Newdanjia = float.Parse(Label4.Text) * (float.Parse(Session["ZheKou"].ToString()) / 100);
string sqlstr = "insert into XiaShouDD"
+ "(OrderID,OrderMember,ShangPinID,ShangPinName,ShangPinTypeID,ShangPinTypeName,ShangPinPrice,IsCheckout,shuliang)"
+ " values('" + Orderid + "','" + Session["UserName"].ToString() + "','" + Request.QueryString["id"].ToString() + "','"
+ Label2.Text + "','" + Hidden1.Value + "','" + Label3.Text
+ "','" + Newdanjia + "','否','" + TextBox1.Text + "')";
data.RunSql(sqlstr);
Response.Redirect("Shopping.aspx");
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlDataReader dr = data.GetDataReader("select * from Users where UserName='******' ");
if (dr.Read())
{
Label2.Text = "账号已经存在";
return;
}
SqlDataReader dr1 = data.GetDataReader("select * from Users where emal='" + txtemal.Text + "' ");
if (dr1.Read())
{
Label2.Text = "注册邮箱已经存在"; return;
}
else
{
data.RunSql("insert into Users(emal,UserName,Sex,Age,Ds,pwd,UserType,XueXiao,XingMing,Photo,Tel)values('" + txtemal.Text + "','" + txtname.Text + "','" + DropDownList1.SelectedItem.Text + "','" + Age.Text + "','" + txtds.Text + "','" + TextBox1.Text + "','学生','" + XueXiao.Text + "','" + XingMing.Text + "','" + pic.Text + "','" + Tel.Text + "')");
Alert.AlertAndRedirect("注册成功！", "Default.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.Title = "网上购物平台";
if (!IsPostBack)
{
if (Session["UserName"].ToString() == "")
{
Alert.AlertAndRedirect("您没有登陆不能充值", "Default.aspx");
}
else
{
SqlDataReader dr;
dr = data.GetDataReader("select * from Users where id='" + Session["UserId"].ToString() + "'");
if (dr.Read())
{
Label1.Text = dr["MemberMoney"].ToString();
Label2.Text = dr["JiFen"].ToString();
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (int.Parse(txtSL.Text) < int.Parse(TextBox1.Text))
{
alert.Alertjs("数量不能大于库存数量！");
}
else
{
SqlDataReader dr;
dr = data.GetDataReader("select * from YaoPinKucun where YaoPinId='" + DropDownList2.SelectedValue + "' ");
if (dr.Read())
{
string sql = "update YaoPinKucun set shuliang=shuliang-" + float.Parse(TextBox1.Text) + " where YaoPinId=" + DropDownList2.SelectedValue;
data.RunSql(sql);
}
data.RunSql("insert into dbo.XiaoShou(GoodID,ShuLiang,UserID,YuanYin,CManger,XiaoShouJia,JinHuoJia)values('" + DropDownList2.SelectedValue + "','" + TextBox1.Text + "','" + Session["adminid"].ToString() + "','" + TextBox3.Text.Trim() + "','" + TextBox2.Text + "','" + Label1.Text + "','" + Label2.Text + "')");
Alert.AlertAndRedirect("操作成功！", "XiaoShouManger.aspx");
}
}
private void chkstudent()
{
if (TxtUserName.Text == "" && TxtPassword.Text == "")
{
Alert.AlertAndRedirect("没有输入账号和密码！", "Login.aspx");
}
else
{
dr = data.GetDataReader("select * from [StudentInfo] where xuehao='" + TxtUserName.Text.Trim() + "'and Pwd='" + TxtPassword.Text.Trim() + "'");
if (dr.Read())
{
Session["user"] = dr["name"].ToString();
Session["userid"] = dr["id"].ToString();
Response.Redirect("Guest/main.html");
}
else
{
Alert.AlertAndRedirect("账号或者密码不对请重新登陆！", "Login.aspx");
}
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
SqlHelper data = new SqlHelper();
SqlDataReader dr;
dr = data.GetDataReader("select * from [huiyuan] where username='******'and password='******'");
if (dr.Read())
{
Session["username"] = dr["username"].ToString();
Session["userid"] = dr["id"].ToString();
Response.Redirect("Default.aspx");
}
else
{
Alert.AlertAndRedirect("UserName and Password don't match,try again！", "Login.aspx");
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if (DropDownList1.SelectedValue == "单选题")
{
TD6.Visible = false;
TD1.Visible = true;
TD2.Visible = true;
TD3.Visible = true;
TD4.Visible = true;
TD5.Visible = true;
string Title = content1.Value;
string AnswerA = txtAnswerA.Text;
string AnswerB = txtAnswerB.Text;
string AnswerC = txtAnswerC.Text;
string AnswerD = txtAnswerD.Text;
string Answer = ddlAnswer.SelectedItem.Text;
mydata.RunSql("insert into TiMu(Title,AnswerA,AnswerB,AnswerC,AnswerD,Answer,Mark,Type)values('" + content1.Value + "','" + txtAnswerA.Text + "','" + txtAnswerB.Text + "','" + txtAnswerC.Text + "','" + txtAnswerD.Text + "','" + ddlAnswer.SelectedItem.Text + "','" + txtScore.Text + "','" + DropDownList1.SelectedValue + "')");
Alert.AlertAndRedirect("添加成功！", "TiMuLists.aspx");
}
else
{
TD6.Visible = true;
TD1.Visible = false;
TD2.Visible = false;
TD3.Visible = false;
TD4.Visible = false;
TD5.Visible = false;
string Title = content1.Value;
string Answer = TextBox1.Text;
mydata.RunSql("insert into TiMu(Title,Answer,Mark,Type)values('" + content1.Value + "','" + Answer + "','" + txtScore.Text + "','" + DropDownList1.SelectedValue + "')");
Alert.AlertAndRedirect("添加成功！", "TiMuLists.aspx");
}
}
private void chkADmin()
{
if (accounts.Value == "" && pwd.Value == "")
{
Alert.AlertAndRedirect("没有输入账号和密码！", "Login.aspx");
}
else
{
dr = data.GetDataReader("select * from UsersInfo where Name='" + accounts.Value.Trim() + "'and Password='******' and Roule='" + DropDownList1.SelectedValue + "'");
if (dr.Read())
{
Session["adminid"] = dr["id"].ToString();
Session["admin"] = dr["name"].ToString();
Session["UserName"] = dr["TName"].ToString();
Session["Roule"] = dr["Roule"].ToString();
Session["Bumen"] = dr["Bumen"].ToString();
if (Session["Roule"].ToString() == "系统管理员")
{
Response.Redirect("Admin/index.html");
}
if (Session["Roule"].ToString() == "员工")
{
Response.Redirect("YaoPinManger/index.html");
}
}
else
{
Alert.AlertAndRedirect("用户的账号或者密码不对请重新登陆！", "login.aspx");
}
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
if (DropDownList1.SelectedValue == "管理员")
{
chkADmin();
}
else
{
SqlDataReader dr = data.GetDataReader("select * from [UserInfo] where zhigonghao='" + TxtUserName.Text.Trim() + "'and Pwd='" + TxtPassword.Text.Trim() + "' ");
if (dr.Read())
{
Session["user"] = dr["zhigonghao"].ToString();
Session["username"] = dr["UserTruename"].ToString();
Session["hetong"] = dr["hetong"].ToString();
//Session["userid"] = dr["Userid"].ToString();
Response.Redirect("UserManger/Default.aspx");
}
else
{
Alert.AlertAndRedirect("账号或者密码不对请重新登录！", "Login.aspx");
}
}
}
protected void Submit1_ServerClick(object sender, EventArgs e)
{
if (lblyanzheng.Text != txtyan.Text)
{
js.Alertjs("验证码错误");
return;
}
else
{
SqlDataReader sdr1;
sdr1 = data.GetDataReader("select * from Admin where name='" + this.txtUserID.Text.Trim() + "' and pwd='" + this.txtPwd.Text.Trim() + "'");
if (sdr1.Read())
{
Session["admin"] = sdr1["name"].ToString();
Alert.AlertAndRedirect("恭喜您登录成功！", "index.htm");
}
else
{
Alert.AlertAndRedirect("登录失败！", "login.aspx");
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (int.Parse(txtSL.Text) < int.Parse(TextBox1.Text))
{
alert.Alertjs("数量不能大于库存数量！");
}
else
{
SqlDataReader dr;
dr = data.GetDataReader("select * from YaoPinKucun where YaoPinId='" + DropDownList2.SelectedValue + "' ");
if (dr.Read())
{
data.RunSql("update YaoPinKucun set shuliang=shuliang-" + float.Parse(TextBox1.Text) + " where YaoPinId='" + DropDownList2.SelectedValue + "'");
data.RunSql("insert into YaoPinChuKu(shuliang,CManger,YaoPinId,YuanYin)values(" + TextBox1.Text.Trim() + ",'" + Session["UserName"].ToString() + "','" + DropDownList2.SelectedValue + "','" + TextBox3.Text + "')");
Alert.AlertAndRedirect("出库成功！", "ChuKuList.aspx");
}
else
{
Alert.AlertAndRedirect("当前库存不存在不能申请出库！", "ChuKuList.aspx");
}
}
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
//判断用户是否已登录，若未登录，则跳转到登录页面
if (Session["UserName"] == null)
{
Alert.AlertAndRedirect("您还没有登录，请登录后再购买，谢谢合作！", "UserLogin.aspx");
}
//已登录，把商品信息持久化到ShoppingCart数据表中
else
{
Label ShangPinID = (Label)e.Item.FindControl("ShangPinID");
SqlDataReader dr = sqloperate.GetDataReader("select * from ShoppingCart where pid='" + Convert.ToInt32(ShangPinID.Text) + "'and userid='" + Convert.ToInt32(Session["UserId"]) + "'");
int shuliang;
string mysql;
int n;
//判断该商品是否已经存在于ShopingCart数据中
if (dr.Read())
{
//已存在，原来的数量+1
shuliang = Convert.ToInt32(dr["shuliang"].ToString());
shuliang = shuliang + 1;
mysql = "update ShoppingCart set shoutime='" + System.DateTime.Now + "',shuliang='" + shuliang + "'where pid ='" + Convert.ToInt32(ShangPinID.Text) + "'";
}
else
{
//未存在，新插入商品信息
shuliang = 1;
mysql = "insert into ShoppingCart(pid,userid,shoutime,shuliang)values('" + Convert.ToInt32(ShangPinID.Text) + "','" + Convert.ToInt32(Session["UserId"]) + "','" + System.DateTime.Now + "','" + shuliang + "')";
}
n = SqlHelper.exexu(mysql);
//操作完成，输出提示信息
if (n > 0)
{
Page.RegisterClientScriptBlock("e", "<script>alert('加入购物车成功!')</script>");
}
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
DataSet ds_UserRegister = bll_UserRegister.GetList("UserName = '******'");
if (txt_Username.Text == "" || txt_Password.Text == "")
{
Alert.AlertAndRedirect("用户名或密码不能为空！", "Login.aspx");
}
try
{
if (ds_UserRegister.Tables[0].Rows[0]["UserPassword"].ToString() == txt_Password.Text)
{
Session["admin_id"] = ds_UserRegister.Tables[0].Rows[0]["UserID"].ToString();
Session["Type"] = ds_UserRegister.Tables[0].Rows[0]["UserType"].ToString();
if (Session["type"].Equals("1"))
{
Alert.AlertAndRedirect("登录成功！", "OldMan.aspx");
}
if (Session["type"].Equals("2"))
{
Alert.AlertAndRedirect("登录成功！", "Doctor.aspx");
}
if (Session["type"].Equals("3"))
{
Alert.AlertAndRedirect("登录成功！", "Announcement.aspx");
}
}
else
{
Alert.AlertAndRedirect("登录失败，用户名或密码错误！", "Login.aspx");
}
}
catch (Exception)
{
Alert.AlertAndRedirect("登录失败，用户名或密码错误！", "Login.aspx");
}
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
if (Session["UserName"] == null)
{
Alert.AlertAndRedirect("您还没有登录，请登录后再购买，谢谢合作！", "UserLogin.aspx");
}
else
{
int i;
Hashtable Hash;
if (Session["ShoppingCar"] == null)
{
//如果用户没有分配购物车 新生成一个购物车
Hash = new Hashtable();
}
else
{
//用户已有购物车
Hash = (Hashtable)Session["ShoppingCar"];
}
//如果购物车已经有此宠物，宠物数量加1
if (!Hash.Contains(e.CommandArgument))
{
Hash.Add(e.CommandArgument, 1);
}
else
{
int addBefore = Convert.ToInt32(Hash[e.CommandArgument].ToString()); //得到宠物数量
Hash[e.CommandArgument] = (addBefore + 1); //宠物数量加1
}
Session["ShoppingCar"] = Hash;
}
}
//验证用户登录
protected void Button2_Click(object sender, EventArgs e)
{
if (TxtUserName.Text == "" && TxtPassword.Text == "")
{
Alert.AlertAndRedirect("没有输入账号和密码！", "Default.aspx");
}
else
{
SqlDataReader dr;
dr = SystemMgr.BLL.Common.GetDataReader("select * from Users where UserName='******'and pwd='" + TxtPassword.Text.Trim() + "' ");
if (dr.Read())
{
Session["UserId"] = dr["id"].ToString();
Session["UserName"] = dr["UserName"].ToString();
Session["XingMing"] = dr["XingMing"].ToString();
Session["roule"] = dr["UserType"].ToString();
Response.Redirect("Default.aspx");
}
else
{
Alert.AlertAndRedirect("账号或者密码不对请重新登陆！", "Default.aspx");
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
int id = int.Parse(Request.QueryString["id"].ToString());
string Sname = txtTitle.Text;
string SPath = pic.Text;
string Student = Session["User"].ToString();
//int Skemu = int.Parse(Label5.Text);
int SClassId = int.Parse(Label6.Text);
string SClassName = Label4.Text;
//string SkemuName = Label3.Text;
string sds = txtDs.Text;
DateTime Saddtime = DateTime.Now;
data.RunSql("insert into TJzuoye(id,SClassId,Sname,SClassName,SPath,Student,Saddtime,SDs) values(" + id + "," + SClassId + ",'" + Sname + "','" + SClassName + "','" + SPath + "','" + Student + "','" + Saddtime + "','" + sds + "')");
Alert.AlertAndRedirect("提交作业成功！", "Mychenji.aspx");
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int sucCount = 0; //成功删除数量
int errorCount = 0; //删除出错数量
for (int i = 0; i < rptList.Items.Count; i++)
{
long id = long.Parse(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
if (Delete(id))
{
sucCount += 1;
}
else
{
errorCount += 1;
}
}
}
Alert.AlertAndRedirect("删除成功！", Utils.CombUrlTxt("HealthDetails.aspx", "keywords={0}", this.keywords));
}
protected void Page_Load(object sender, EventArgs e)
{
this.Title = "充值中心";
if (Session["UserName"] == null)
{
Response.Redirect("ssnotice.aspx");
}
if (!IsPostBack)
{
if (Session["UserName"].ToString() == "")
{
Alert.AlertAndRedirect("您没有登陆不能充值", "UserLogin.aspx");
}
else
{
SqlDataReader dr;
dr = data.GetDataReader("select * from Users where id='" + Session["UserId"].ToString() + "'");
if (dr.Read())
{
Label1.Text = dr["MemberMoney"].ToString();
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (lblyanzheng.Text != txtyan.Text)
{
Response.Write("<script>alert('验证码错误!');history.go(-1);</script>");
return;
}
else
{
SqlDataReader dr = data.GetDataReader("select * from Users where UserName='******'");
if (dr.Read())
{
Label1.Text = "已经存在账号了";
}
else
{
//data.RunSql("insert into Users(emal,UserName,Sex,pwd,XingMing,Tel,Address,ShengRi)values('" + txtemal.Text + "','" + txtname.Text + "','" + DropDownList1.SelectedItem.Text + "','" + PwdEncrypt.MD5Encrypt64(TextBox1.Text) + "','" + XingMing.Text + "','" + Tel.Text + "','" + Address.Text + "','" + txttime.Value + "')");
data.RunSql("insert into Users(UserName,pwd,Tel)values('" + txtname.Text + "','" + PwdEncrypt.MD5Encrypt64(TextBox1.Text) + "','" + Tel.Text + "')");
Alert.AlertAndRedirect("注册成功！", "UserLogin.aspx");
}
}
}
protected void ImageButtonSave_Click(object sender, ImageClickEventArgs e)
{
data.RunSql("insert into admin(name,pwd)values('" + txtname.Text + "','" + TextBox1.Text + "')");
Alert.AlertAndRedirect("添加成功", "admin.aspx");
InitData();
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
data.RunSql("update News set Name='" + txtname.Text + "', Contents='" + txtcontents.Value + "' where id=" + Request.QueryString["id"].ToString());
Alert.AlertAndRedirect("修改成功", "NewsManger.aspx");
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
data.RunSql("insert into HostelInfo(Bid,BName,Num,Floor,Sex,Ds,RenShu,FeiYong,Kong)values('" + DropDownList1.SelectedValue + "','" + DropDownList1.SelectedItem.Text + "','" + TextBox1.Text + "','" + TextBox2.Text + "','" + DropDownList2.SelectedValue + "','" + this.TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox4.Text + "')");
Alert.AlertAndRedirect("AddSuccess", "AddHostelInfo.aspx");
}
protected void ImageButtonSave_Click(object sender, ImageClickEventArgs e)
{
data.RunSql("insert into TeachterInfo(xuehao,name,nianling,sex,jiguan,tel,Emal)values('" + txtxuehao.Text + "','" + txtUser.Text + "','" + txtnianling.Text + "','" + drsex.SelectedItem.Text + "','" + txtjg.Text + "','" + txttel.Text + "','" + txtEmal.Text + "')");
Alert.AlertAndRedirect("添加成功请继续添加", "Addteachter2.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
dr = data.GetDataReader("select * from [pic] where upload='是'");
if (dr.Read())
{
using (SqlConnection con = new SqlConnection("Data Source=qds164713652.my3w.com;Initial Catalog=qds164713652_db;Persist Security Info=True;User ID=qds164713652;Password=zhangwujun666"))
{
//根据输入的名称去匹配获取数据
string strSQL = "select hp from pic where name='" + Session["danwei"].ToString() + "'";
SqlDataAdapter da = new SqlDataAdapter(strSQL, con);
DataSet ds = new DataSet();
da.Fill(ds);
//将取得的路径设置到Image控件的ImageUrl属性中去
this.Image1.ImageUrl = "../" + ds.Tables[0].Rows[0]["hp"].ToString();
this.demo.Text = "../" + ds.Tables[0].Rows[0]["hp"].ToString();
}
using (SqlConnection con = new SqlConnection("Data Source=qds164713652.my3w.com;Initial Catalog=qds164713652_db;Persist Security Info=True;User ID=qds164713652;Password=zhangwujun666"))
{
//根据输入的名称去匹配获取数据
string strSQL = "select zz from pic where name='" + Session["danwei"].ToString() + "'";
SqlDataAdapter da = new SqlDataAdapter(strSQL, con);
DataSet ds = new DataSet();
da.Fill(ds);
//将取得的路径设置到Image控件的ImageUrl属性中去
this.Image2.ImageUrl = "../" + ds.Tables[0].Rows[0]["zz"].ToString();
this.demo2.Text = "../" + ds.Tables[0].Rows[0]["zz"].ToString();
}
using (SqlConnection con = new SqlConnection("Data Source=qds164713652.my3w.com;Initial Catalog=qds164713652_db;Persist Security Info=True;User ID=qds164713652;Password=zhangwujun666"))
{
//根据输入的名称去匹配获取数据
string strSQL = "select zs from pic where name='" + Session["danwei"].ToString() + "'";
SqlDataAdapter da = new SqlDataAdapter(strSQL, con);
DataSet ds = new DataSet();
da.Fill(ds);
//将取得的路径设置到Image控件的ImageUrl属性中去
this.Image3.ImageUrl = "../" + ds.Tables[0].Rows[0]["zs"].ToString();
this.demo3.Text = "../" + ds.Tables[0].Rows[0]["zs"].ToString();
}
using (SqlConnection con = new SqlConnection("Data Source=qds164713652.my3w.com;Initial Catalog=qds164713652_db;Persist Security Info=True;User ID=qds164713652;Password=zhangwujun666"))
{
//根据输入的名称去匹配获取数据
string strSQL = "select zl from pic where name='" + Session["danwei"].ToString() + "'";
SqlDataAdapter da = new SqlDataAdapter(strSQL, con);
DataSet ds = new DataSet();
da.Fill(ds);
//将取得的路径设置到Image控件的ImageUrl属性中去
this.Image4.ImageUrl = "../" + ds.Tables[0].Rows[0]["zl"].ToString();
this.demo4.Text = "../" + ds.Tables[0].Rows[0]["zl"].ToString();
}
}
else
{
Alert.AlertAndRedirect("您还没有上传您的公司证件信息，请上传！", "pic.aspx");
}
}
