protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { QPS.NEW.BLL.Users user = new QPS.NEW.BLL.Users(); QPS.NEW.BLL.Integral Bint = new QPS.NEW.BLL.Integral(); if (Session["username"] != null) { //获取Uid string uname = Session["username"].ToString(); DataSet dsUser = user.GetList(uname); int uid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["UserID"]); DataSet dsInt = Bint.GetListlocalize("UserID='" + uid + "'"); GridView1.DataSource = dsInt; GridView1.DataBind(); // === modified by jeffery DataTable dt = Bint.GetSum(uid).Tables[0]; if (dt == null || dt.Rows.Count <= 0 || dt.Rows[0][0].ToString().Trim() == "") { lblSum.Text = " 0"; } else { lblSum.Text = Bint.GetSum(uid).Tables[0].Rows[0][0].ToString(); } // === } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.Calendar1.SelectedDate = DateTime.Now; this.Calendar2.SelectedDate = DateTime.Now; roomid = Int32.Parse(Request.QueryString["id"].Trim()); StringBuilder sb = new StringBuilder(); sb.Append("Id="); sb.Append(roomid); ds = room.GetList(sb.ToString()); DataList1.DataSource = ds; DataList1.DataBind(); if (Session["username"] != null) { string uname = Session["username"].ToString(); txbOrderPersonInfo.Text = uname; DataSet dsUser = user.GetList(uname); if (dsUser.Tables[0].Rows[0]["Phone"].ToString() != "") { txbPhone.Text = dsUser.Tables[0].Rows[0]["Phone"].ToString(); } userid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["UserID"]); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { QPS.NEW.BLL.Users user = new QPS.NEW.BLL.Users(); QPS.NEW.BLL.Integral Bint = new QPS.NEW.BLL.Integral(); if (Session["username"] != null) { //获取Uid string uname = Session["username"].ToString(); DataSet dsUser = user.GetList(uname); int uid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["UserID"]); DataSet dsInt = Bint.GetListlocalize("UserID='" + uid + "'"); GridView1.DataSource = dsInt; GridView1.DataBind(); // === modified by jeffery DataTable dt = Bint.GetSum(uid).Tables[0]; if (dt == null || dt.Rows.Count <= 0 || dt.Rows[0][0].ToString().Trim() == "") { lblSum.Text = " 0"; } else { lblSum.Text = Bint.GetSum(uid).Tables[0].Rows[0][0].ToString(); } // === } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] != null) { string uname = Session["username"].ToString(); dsUser = user.GetList(uname); txbname.Text = dsUser.Tables[0].Rows[0]["NickName"].ToString(); userid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["UserID"]); } }
public void BindShow() { DataSet dse = new DataSet(); QPS.NEW.BLL.Users Bus = new QPS.NEW.BLL.Users(); dse = Bus.GetList(tempID); this.txtId.Text = tempID.ToString(); this.txtName.Text = dse.Tables[0].Rows[0]["UserName"].ToString(); this.txtPhone.Text = dse.Tables[0].Rows[0]["Phone"].ToString(); }
public void BindShow() { DataSet dse = new DataSet(); QPS.NEW.BLL.Users Bus = new QPS.NEW.BLL.Users(); dse = Bus.GetList(tempID); this.txtId.Text = tempID.ToString(); this.txtName.Text = dse.Tables[0].Rows[0]["UserName"].ToString(); this.txtPhone.Text = dse.Tables[0].Rows[0]["Phone"].ToString(); }
/// <summary> /// 查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button1_Click(object sender, EventArgs e) { string name = this.txlinkman.Text; string xingm = this.txlogin.Text; QPS.NEW.BLL.Users user =new QPS.NEW.BLL.Users (); ds = user.GetList(name,xingm); dgExamProj.DataSource = ds; dgExamProj.DataBind(); //AboutBox方法,Refresh方法,SetFocus方法。 }
/// <summary> /// 查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button1_Click(object sender, EventArgs e) { string name = this.txlinkman.Text; string xingm = this.txlogin.Text; QPS.NEW.BLL.Users user = new QPS.NEW.BLL.Users(); ds = user.GetList(name, xingm); dgExamProj.DataSource = ds; dgExamProj.DataBind(); //AboutBox方法,Refresh方法,SetFocus方法。 }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["username"] != null) { string uname = Session["username"].ToString(); DataSet dsUser = user.GetList(uname); userid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["UserID"]); } else { Response.Write("<script>alert('请先登录')</script>"); return; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["username"] != null) { string uname = Session["username"].ToString(); txfUserName.Value = uname; DataSet dsUser = user.GetList(uname); txfPhone.Value = dsUser.Tables[0].Rows[0]["Phone"].ToString(); txfEmail.Value = dsUser.Tables[0].Rows[0]["Email"].ToString(); txfNickName.Value = dsUser.Tables[0].Rows[0]["NickName"].ToString(); txfAddress.Value = dsUser.Tables[0].Rows[0]["Address"].ToString(); userid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["UserID"]); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { QPS.NEW.BLL.Users user = new QPS.NEW.BLL.Users(); QPS.NEW.BLL.Leaveword Bleave = new QPS.NEW.BLL.Leaveword(); if (Session["username"] != null) { //获取Uid string uname = Session["username"].ToString(); DataSet dsUser = user.GetList(uname); int uid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["UserID"]); DataSet dsInt = Bleave.GetListLocalise("UserID='" + uid + "'"); GridView1.DataSource = dsInt; GridView1.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { QPS.NEW.BLL.Users user = new QPS.NEW.BLL.Users(); QPS.NEW.BLL.Leaveword Bleave= new QPS.NEW.BLL.Leaveword(); if (Session["username"] != null) { //获取Uid string uname = Session["username"].ToString(); DataSet dsUser = user.GetList(uname); int uid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["UserID"]); DataSet dsInt = Bleave.GetListLocalise("UserID='" + uid + "'"); GridView1.DataSource = dsInt; GridView1.DataBind(); } } }
public void databind(GridView gdv) { QPS.NEW.BLL.Users user = new QPS.NEW.BLL.Users(); QPS.NEW.Model.Room Mroom = new QPS.NEW.Model.Room(); QPS.NEW.BLL.Room Broom = new QPS.NEW.BLL.Room(); QPS.NEW.BLL.Orderform Border = new QPS.NEW.BLL.Orderform(); List<QPS.NEW.Model.Room> roomList = new List<QPS.NEW.Model.Room>(); if (Session["username"] != null) { string uname = Session["username"].ToString(); DataSet dsUser = user.GetList(uname); int uid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["UserID"]); List<QPS.NEW.Model.Orderform> orderlist = Border.GetModelList("Userid='" + uid + "'"); foreach (QPS.NEW.Model.Orderform o in orderlist) { int roomid = (int)o.Roomid; roomList.Add(Broom.GetModel(roomid)); } } gdv.DataSource = Gettable(roomList); gdv.DataBind(); }
public void databind(GridView gdv) { QPS.NEW.BLL.Users user = new QPS.NEW.BLL.Users(); QPS.NEW.Model.Room Mroom = new QPS.NEW.Model.Room(); QPS.NEW.BLL.Room Broom = new QPS.NEW.BLL.Room(); QPS.NEW.BLL.Orderform Border = new QPS.NEW.BLL.Orderform(); List <QPS.NEW.Model.Room> roomList = new List <QPS.NEW.Model.Room>(); if (Session["username"] != null) { string uname = Session["username"].ToString(); DataSet dsUser = user.GetList(uname); int uid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["UserID"]); List <QPS.NEW.Model.Orderform> orderlist = Border.GetModelList("Userid='" + uid + "'"); foreach (QPS.NEW.Model.Orderform o in orderlist) { int roomid = (int)o.Roomid; roomList.Add(Broom.GetModel(roomid)); } } gdv.DataSource = Gettable(roomList); gdv.DataBind(); }
public string getResult(string action) { switch (action) { case "register": if (validate("register")) { Muser.Username = ht["username"].ToString(); Muser.Nickname = ht["nickname"].ToString(); Muser.Password = ht["password"].ToString(); Muser.Sign = ""; Muser.Usertype = 0; if (Buser.Add(Muser) > 0) { return("true"); } else { return("false"); } } else { return("false"); } case "login": if (validate("login")) { if (Buser.Denglu(ht["username"].ToString(), ht["password"].ToString())) { Session["username"] = ht["username"].ToString(); return("true"); } else { return("false"); } } else { return("false"); } case "score": if (validate("score")) { string uname = ht["username"].ToString(); DataSet dsUser = Buser.GetList("Username='******'"); userid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["Id"]); QPS.NEW.Model.Integral u = BInt.GetModel(userid); if (u.TotalMoney == (int)ht["originalscore"]) { u.TotalMoney = +(int)ht["score"]; if (BInt.Update(u)) { return("true"); } else { return("fales"); } } else { return("false"); } } else { return("false"); } case "editpwd": if (validate("editpwd")) { string uname = ht["username"].ToString(); DataSet dsUser = Buser.GetList("Username='******'"); userid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["Id"]); QPS.NEW.Model.Users u = Buser.GetModel(userid); u.Password = ht["newpassword"].ToString(); if (Buser.Update(u)) { return("true"); } else { return("false"); } } else { return("false"); } case "logout": if (validate("logout")) { if (Session["username"] != null) { Session.Remove("username"); return("true"); } else { return("false"); } } else { return("false"); } default: return("false"); } }