protected void Page_Load(object sender, EventArgs e) { if (UsersInfo.UserID == "") { Response.Write("<script> alert('请先登录!'); window.location.href='../Login.aspx' </script>"); return; } if (!IsPostBack) { Maticsoft.Model.Users molUsers = Users_Bll.GetModel(UsersInfo.UserID); Maticsoft.Model.Orders molOrders = Orders_Bll.GetModel(Request.QueryString["OrderID"].ToString()); RadTextBox1.Text = molUsers.UserRealName; RadTextBox2.Text = molUsers.Address1; ddlcityLoad(molUsers.Province); ddlcity.SelectedValue = molUsers.City; Score1 = Convert.ToInt32(molOrders.TotalMoney * 100); if (RadTextBox5.Text == "") { RadTextBox5.Text = "0"; } if (Convert.ToInt32(Score1) > molUsers.UserScore) { Label1.Text = molUsers.UserScore.ToString(); } else { Label1.Text = Score1.ToString(); } RadTextBox4.Text = molUsers.Phone; RadDropDownList1.SelectedValue = "1"; RadDropDownList2.SelectedValue = "1"; } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsDateTime(txtBirthday.Text)) { strErr += "生日格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int Id = int.Parse(this.lblId.Text); string Name = this.lblName.Text; String Password = this.txtPassword.Text; String TrueName = this.txtTrueName.Text; String Sex = this.ddlSex.SelectedValue; String Phone = this.txtPhone.Text; string path = Server.MapPath("~/"); string Photo = ""; string filename = ""; string contentType = fuPhoto.PostedFile.ContentType; if (contentType == "image/pjpeg" || contentType == "image/bmp" || contentType == "image/gif") { string format = fuPhoto.FileName.Split('.')[1]; Photo = "Upload/" + Guid.NewGuid() + "." + format; filename = path + Photo; fuPhoto.PostedFile.SaveAs(filename); } else { Maticsoft.Common.MessageBox.Show(this, "请上传图片文件!"); return; } String Email = this.txtEmail.Text; DateTime Birthday = DateTime.Parse(this.txtBirthday.Text); bool IsActivity = this.chkIsActivity.Checked; int Fk_Roles_Id = int.Parse(this.ddlFk_Roles_Id.SelectedValue); Maticsoft.Model.Users model = new Maticsoft.Model.Users(); model.Id = Id; model.Name = Name; model.Password = Password; model.TrueName = TrueName; model.Sex = Sex; model.Phone = Phone; model.Photo = Photo; model.Email = Email; model.Birthday = Birthday; model.IsActivity = IsActivity; model.Fk_Roles_Id = Fk_Roles_Id; Maticsoft.BLL.Users bll = new Maticsoft.BLL.Users(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "usercenter.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Users DataRowToModel(DataRow row) { Maticsoft.Model.Users model = new Maticsoft.Model.Users(); if (row != null) { if (row["UserID"] != null && row["UserID"].ToString() != "") { model.UserID = int.Parse(row["UserID"].ToString()); } if (row["UserLName"] != null) { model.UserLName = row["UserLName"].ToString(); } if (row["UserLPWD"] != null) { model.UserLPWD = row["UserLPWD"].ToString(); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["RoleName"] != null) { model.RoleName = row["RoleName"].ToString(); } if (row["RoleID"] != null && row["RoleID"].ToString() != "") { model.RoleID = int.Parse(row["RoleID"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Users("); strSql.Append("UserLName,UserLPWD,UserName,RoleID)"); strSql.Append(" values ("); strSql.Append("@UserLName,@UserLPWD,@UserName,@RoleID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserLName", SqlDbType.VarChar, 50), new SqlParameter("@UserLPWD", SqlDbType.Char, 47), new SqlParameter("@UserName", SqlDbType.VarChar, 50), new SqlParameter("@RoleID", SqlDbType.Int, 4) }; parameters[0].Value = model.UserLName; parameters[1].Value = model.UserLPWD; parameters[2].Value = model.UserName; parameters[3].Value = model.RoleID; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Users set "); strSql.Append("UserLName=@UserLName,"); strSql.Append("UserLPWD=@UserLPWD,"); strSql.Append("UserName=@UserName,"); strSql.Append("RoleID=@RoleID"); strSql.Append(" where UserID=@UserID"); SqlParameter[] parameters = { new SqlParameter("@UserLName", SqlDbType.VarChar, 50), new SqlParameter("@UserLPWD", SqlDbType.Char, 47), new SqlParameter("@UserName", SqlDbType.VarChar, 50), new SqlParameter("@RoleID", SqlDbType.Int, 4), new SqlParameter("@UserID", SqlDbType.Int, 4) }; parameters[0].Value = model.UserLName; parameters[1].Value = model.UserLPWD; parameters[2].Value = model.UserName; parameters[3].Value = model.RoleID; parameters[4].Value = model.UserID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Users DataRowToModel(DataRow row) { Maticsoft.Model.Users model = new Maticsoft.Model.Users(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["Password"] != null) { model.Password = row["Password"].ToString(); } if (row["TrueName"] != null) { model.TrueName = row["TrueName"].ToString(); } if (row["Sex"] != null) { model.Sex = row["Sex"].ToString(); } if (row["Phone"] != null) { model.Phone = row["Phone"].ToString(); } if (row["Photo"] != null) { model.Photo = row["Photo"].ToString(); } if (row["Email"] != null) { model.Email = row["Email"].ToString(); } if (row["Birthday"] != null && row["Birthday"].ToString() != "") { model.Birthday = DateTime.Parse(row["Birthday"].ToString()); } if (row["IsActivity"] != null && row["IsActivity"].ToString() != "") { if ((row["IsActivity"].ToString() == "1") || (row["IsActivity"].ToString().ToLower() == "true")) { model.IsActivity = true; } else { model.IsActivity = false; } } if (row["Fk_Roles_Id"] != null && row["Fk_Roles_Id"].ToString() != "") { model.Fk_Roles_Id = int.Parse(row["Fk_Roles_Id"].ToString()); } } return(model); }
protected void RadListView1_ItemCommand(object sender, Telerik.Web.UI.RadListViewCommandEventArgs e) { string OrderID; OrderID = e.CommandArgument.ToString(); Maticsoft.Model.Users molUsers = Users_Bll.GetModel(UsersInfo.UserID); if (e.CommandName == "Pay") { Response.Write("<script>window.location.href='/ForeManagement/ForeOrdersDetail.aspx?OrderID=" + OrderID + "'</script>"); } if (e.CommandName == "Cancel") { Maticsoft.Model.Orders molOrders = Orders_Bll.GetModel(OrderID); molOrders.OrderState = "订单取消"; Orders_Bll.Update(molOrders); } if (e.CommandName == "Hurry") { Response.Write("<script> alert('催单成功!')</script>"); } if (e.CommandName == "Check") { Orders_Mol = Orders_Bll.GetModel(OrderID);//引用 DataSet ds = new DataSet(); ds = Orders_Bll.GetList2(0, " a.OrderID='" + OrderID + "' ", " OrderDate"); Users_Mol = Users_Bll.GetModel(UsersInfo.UserID);//引用 foreach (DataRow dr in ds.Tables[0].Rows) { //增加销售数量 Commodity_Mol = Commodity_Bll.GetModel(dr["CommodityID"].ToString()); Commodity_Mol.CommoditySaled = Commodity_Mol.CommoditySaled + Convert.ToInt32(dr["OrderNumber"]); Commodity_Bll.Update(Commodity_Mol);//更新 //增加积分点数 string str = dr["BuyScore"].ToString(); string shu = dr["OrderNumber"].ToString(); Users_Mol.UserScore += Convert.ToInt32(str) * Convert.ToInt32(shu); } Users_Mol.UserGrade = "VIP"; Orders_Mol.OrderState = "完成"; Orders_Bll.Update(Orders_Mol); //更新 Users_Bll.Update(Users_Mol); //更新 RadListView1.Rebind(); Maticsoft.Model.Orders molOrders = Orders_Bll.GetModel(OrderID); //Maticsoft.Model.Commodity molCommodity = Commodity_Bll.GetModel(OrderID); //int total = Orders_Bll.GetTotal(OrderID); //molUsers.UserScore += total; //molOrders.OrderState = "完成"; Orders_Bll.Update(molOrders); } if (e.CommandName == "Score") { } }
protected void RadLV_splb_ItemCommand(object sender, Telerik.Web.UI.RadListViewCommandEventArgs e) { string Collectid = e.CommandArgument.ToString(); if (e.CommandName == "Delete") { string AppriseID1; AppriseID1 = e.CommandArgument.ToString(); Appraise_Bll.DeleteList(e.CommandArgument.ToString()); RadLV_splb.Rebind();//删除 } if (e.CommandName == "Join") { string CommodityID1; CommodityID1 = e.CommandArgument.ToString(); Maticsoft.Model.Commodity modelCommodity = Commodity_Bll.GetModel(CommodityID1.ToString()); if (ShoppingCart_Bll.GetRecordCount(" CommodityID='" + CommodityID1 + "' and UserID='" + UsersInfo.UserID + "' ") > 0) { Maticsoft.Model.ShoppingCart modelShoppingCart = ShoppingCart_Bll.GetModel(CommodityID1.ToString()); string id = ShoppingCart_Bll.GetList(" CommodityID='" + CommodityID1 + "' and UserID='" + UsersInfo.UserID + "' ").Tables[0].Rows[0]["ShoppingCartID"].ToString(); modelShoppingCart = ShoppingCart_Bll.GetModel(id); modelShoppingCart.ShoppingCartID = modelShoppingCart.ShoppingCartID; modelShoppingCart.UserID = UsersInfo.UserID; modelShoppingCart.CommodityID = modelCommodity.CommodityID; modelShoppingCart.OrderNumber = modelShoppingCart.OrderNumber + 1; if (modelShoppingCart.OrderNumber > modelCommodity.Stock) { RadAjaxManager1.Alert("库存不足!"); return; } ShoppingCart_Bll.Update(modelShoppingCart); } else { Maticsoft.Model.Users modelusers = Users_Bll.GetModel(UsersInfo.UserID); decimal discount1; if (modelusers.UserGrade == "VIP") { discount1 = Convert.ToDecimal(0.95); } else { discount1 = Convert.ToDecimal(1); } ShoppingCart_Mol.ShoppingCartID = DateTime.Now.ToString("yyyyMMddhhmmss"); ShoppingCart_Mol.UserID = UsersInfo.UserID; ShoppingCart_Mol.CommodityID = CommodityID1; ShoppingCart_Mol.OrderNumber = 1; ShoppingCart_Mol.Subtotal = ((ShoppingCart_Mol.OrderNumber * modelCommodity.VIPPrice) * discount1).ToString(); ShoppingCart_Bll.Add(ShoppingCart_Mol); } RadAjaxManager1.Alert("已添加到购物车!"); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Users set "); strSql.Append("sBianHao=@sBianHao,"); strSql.Append("sBianMa=@sBianMa,"); strSql.Append("sZhuYuanHao=@sZhuYuanHao,"); strSql.Append("sName=@sName,"); strSql.Append("sSex=@sSex,"); strSql.Append("iAge=@iAge,"); strSql.Append("sZhiYe=@sZhiYe,"); strSql.Append("dRuYuanShiJian=@dRuYuanShiJian,"); strSql.Append("sPhone=@sPhone,"); strSql.Append("sMinZu=@sMinZu"); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@sBianHao", OleDbType.VarChar, 255), new OleDbParameter("@sBianMa", OleDbType.VarChar, 255), new OleDbParameter("@sZhuYuanHao", OleDbType.VarChar, 255), new OleDbParameter("@sName", OleDbType.VarChar, 255), new OleDbParameter("@sSex", OleDbType.VarChar, 255), new OleDbParameter("@iAge", OleDbType.VarChar, 255), new OleDbParameter("@sZhiYe", OleDbType.VarChar, 255), new OleDbParameter("@dRuYuanShiJian", OleDbType.Date), new OleDbParameter("@sPhone", OleDbType.VarChar, 20), new OleDbParameter("@sMinZu", OleDbType.VarChar, 255), new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = model.sBianHao; parameters[1].Value = model.sBianMa; parameters[2].Value = model.sZhuYuanHao; parameters[3].Value = model.sName; parameters[4].Value = model.sSex; parameters[5].Value = model.iAge; parameters[6].Value = model.sZhiYe; parameters[7].Value = model.dRuYuanShiJian; parameters[8].Value = model.sPhone; parameters[9].Value = model.sMinZu; parameters[10].Value = model.ID; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Users set "); strSql.Append("Password=@Password,"); strSql.Append("TrueName=@TrueName,"); strSql.Append("Sex=@Sex,"); strSql.Append("Phone=@Phone,"); strSql.Append("Photo=@Photo,"); strSql.Append("Email=@Email,"); strSql.Append("Birthday=@Birthday,"); strSql.Append("IsActivity=@IsActivity,"); strSql.Append("Fk_Roles_Id=@Fk_Roles_Id"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Password", SqlDbType.VarChar, 50), new SqlParameter("@TrueName", SqlDbType.VarChar, 50), new SqlParameter("@Sex", SqlDbType.VarChar, 10), new SqlParameter("@Phone", SqlDbType.VarChar, 50), new SqlParameter("@Photo", SqlDbType.VarChar, 100), new SqlParameter("@Email", SqlDbType.VarChar, 50), new SqlParameter("@Birthday", SqlDbType.DateTime), new SqlParameter("@IsActivity", SqlDbType.Bit, 1), new SqlParameter("@Fk_Roles_Id", SqlDbType.Int, 4), new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@Name", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Password; parameters[1].Value = model.TrueName; parameters[2].Value = model.Sex; parameters[3].Value = model.Phone; parameters[4].Value = model.Photo; parameters[5].Value = model.Email; parameters[6].Value = model.Birthday; parameters[7].Value = model.IsActivity; parameters[8].Value = model.Fk_Roles_Id; parameters[9].Value = model.Id; parameters[10].Value = model.Name; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Users DataRowToModel(DataRow row) { Maticsoft.Model.Users model = new Maticsoft.Model.Users(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["sBianHao"] != null) { model.sBianHao = row["sBianHao"].ToString(); } if (row["sBianMa"] != null) { model.sBianMa = row["sBianMa"].ToString(); } if (row["sZhuYuanHao"] != null) { model.sZhuYuanHao = row["sZhuYuanHao"].ToString(); } if (row["sName"] != null) { model.sName = row["sName"].ToString(); } if (row["sSex"] != null) { model.sSex = row["sSex"].ToString(); } if (row["iAge"] != null) { model.iAge = row["iAge"].ToString(); } if (row["sZhiYe"] != null) { model.sZhiYe = row["sZhiYe"].ToString(); } if (row["dRuYuanShiJian"] != null && row["dRuYuanShiJian"].ToString() != "") { model.dRuYuanShiJian = DateTime.Parse(row["dRuYuanShiJian"].ToString()); } if (row["sPhone"] != null) { model.sPhone = row["sPhone"].ToString(); } if (row["sMinZu"] != null) { model.sMinZu = row["sMinZu"].ToString(); } } return(model); }
protected void Button1_Click(object sender, EventArgs e) { string path = @"(^[a-zA-Z0-9_.-]+@[a-zA-Z0-9-]+(\.[a-zA-Z0-9-]+)*\.[a-zA-Z0-9]{2,6}$)"; Regex rx = new Regex(path); if (RadTextBox2.Text == "")//判断是否为空 { RadAjaxManager1.Alert("请输入姓名!"); } else if (RadTextBox3.Text == "")//判断是否为空 { RadAjaxManager1.Alert("请输入邮箱!"); } else if (ddlprovince.SelectedValue == "")//判断是否为空 { RadAjaxManager1.Alert("请输入所在地!"); } else if (ddlcity.SelectedValue == "")//判断是否为空 { RadAjaxManager1.Alert("请输入所在地!"); } else if (RadTextBox6.Text == "")//判断是否为空 { RadAjaxManager1.Alert("请输入详细地址!"); } else if (!rx.IsMatch(RadTextBox3.Text)) { RadTextBox3.Text = ""; RadAjaxManager1.Alert("邮箱格式错误!"); } else { User_Model = Users_Bll.GetModel(UsersInfo.UserID); User_Model.UserRealName = RadTextBox2.Text;//添加数据 User_Model.Province = ddlprovince.SelectedValue; User_Model.City = ddlcity.SelectedValue; User_Model.Address1 = RadTextBox6.Text;//添加数据 User_Model.UserEmail = RadTextBox3.Text; if (Rad_nan.Checked == true) { User_Model.UserSex = "男"; } else { User_Model.UserSex = "女"; } Users_Bll.Update(User_Model); Response.Write("<script>alert('修改成功!');window.location.href='ForeVIP.aspx'</script>"); } }
private void ShowInfo(int Id) { Maticsoft.BLL.Users bll = new Maticsoft.BLL.Users(); Maticsoft.Model.Users model = bll.GetModel(Id); this.lblId.Text = model.Id.ToString(); this.lblName.Text = model.Name; this.txtPassword.Text = model.Password; this.txtTrueName.Text = model.TrueName; this.ddlSex.SelectedValue = model.Sex; this.txtPhone.Text = model.Phone; //this.txtPhoto.Text=model.Photo; this.txtEmail.Text = model.Email; this.txtBirthday.Text = model.Birthday.ToString(); this.chkIsActivity.Checked = model.IsActivity; this.ddlFk_Roles_Id.SelectedValue = model.Fk_Roles_Id.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Users set "); strSql.Append("GUID=@GUID,"); strSql.Append("UserName=@UserName,"); strSql.Append("UserAccount=@UserAccount,"); strSql.Append("UserPassWord=@UserPassWord,"); strSql.Append("UserMail=@UserMail,"); strSql.Append("RegisterTime=@RegisterTime,"); strSql.Append("LoginTime=@LoginTime,"); strSql.Append("UsersState=@UsersState"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@GUID", SqlDbType.NVarChar, 50), new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@UserAccount", SqlDbType.NVarChar, 20), new SqlParameter("@UserPassWord", SqlDbType.NVarChar, 50), new SqlParameter("@UserMail", SqlDbType.NVarChar, 50), new SqlParameter("@RegisterTime", SqlDbType.DateTime), new SqlParameter("@LoginTime", SqlDbType.DateTime), new SqlParameter("@UsersState", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.GUID; parameters[1].Value = model.UserName; parameters[2].Value = model.UserAccount; parameters[3].Value = model.UserPassWord; parameters[4].Value = model.UserMail; parameters[5].Value = model.RegisterTime; parameters[6].Value = model.LoginTime; parameters[7].Value = model.UsersState; parameters[8].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(int Id) { Maticsoft.BLL.Users bll = new Maticsoft.BLL.Users(); Maticsoft.Model.Users model = bll.GetModel(Id); this.lblId.Text = model.Id.ToString(); this.lblName.Text = model.Name; this.lblTrueName.Text = model.TrueName; this.lblSex.Text = model.Sex; this.lblPhone.Text = model.Phone; this.iPhoto.ImageUrl = "~/" + model.Photo; this.lblEmail.Text = model.Email; this.lblBirthday.Text = model.Birthday.ToString(); BLL.Roles BLLRoles = new BLL.Roles(); Model.Roles ModelRoles = BLLRoles.GetModel((int)model.Fk_Roles_Id); this.lblFk_Roles_Id.Text = ModelRoles.Name; }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Users DataRowToModel(DataRow row) { Maticsoft.Model.Users model = new Maticsoft.Model.Users(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["GUID"] != null) { model.GUID = row["GUID"].ToString(); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["UserAccount"] != null) { model.UserAccount = row["UserAccount"].ToString(); } if (row["UserPassWord"] != null) { model.UserPassWord = row["UserPassWord"].ToString(); } if (row["UserMail"] != null) { model.UserMail = row["UserMail"].ToString(); } if (row["RegisterTime"] != null && row["RegisterTime"].ToString() != "") { model.RegisterTime = DateTime.Parse(row["RegisterTime"].ToString()); } if (row["LoginTime"] != null && row["LoginTime"].ToString() != "") { model.LoginTime = DateTime.Parse(row["LoginTime"].ToString()); } if (row["UsersState"] != null && row["UsersState"].ToString() != "") { model.UsersState = int.Parse(row["UsersState"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Users("); strSql.Append("Name,Password,TrueName,Sex,Phone,Photo,Email,Birthday,IsActivity,Fk_Roles_Id)"); strSql.Append(" values ("); strSql.Append("@Name,@Password,@TrueName,@Sex,@Phone,@Photo,@Email,@Birthday,@IsActivity,@Fk_Roles_Id)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.VarChar, 50), new SqlParameter("@Password", SqlDbType.VarChar, 50), new SqlParameter("@TrueName", SqlDbType.VarChar, 50), new SqlParameter("@Sex", SqlDbType.VarChar, 10), new SqlParameter("@Phone", SqlDbType.VarChar, 50), new SqlParameter("@Photo", SqlDbType.VarChar, 100), new SqlParameter("@Email", SqlDbType.VarChar, 50), new SqlParameter("@Birthday", SqlDbType.DateTime), new SqlParameter("@IsActivity", SqlDbType.Bit, 1), new SqlParameter("@Fk_Roles_Id", SqlDbType.Int, 4) }; parameters[0].Value = model.Name; parameters[1].Value = model.Password; parameters[2].Value = model.TrueName; parameters[3].Value = model.Sex; parameters[4].Value = model.Phone; parameters[5].Value = model.Photo; parameters[6].Value = model.Email; parameters[7].Value = model.Birthday; parameters[8].Value = model.IsActivity; parameters[9].Value = model.Fk_Roles_Id; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Users set "); strSql.Append("Name=@Name,"); strSql.Append("Sex=@Sex,"); strSql.Append("Code=@Code,"); strSql.Append("CardID=@CardID,"); strSql.Append("Position=@Position,"); strSql.Append("Salary=@Salary,"); strSql.Append("Remark=@Remark"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Sex", SqlDbType.NVarChar, 50), new SqlParameter("@Code", SqlDbType.NVarChar, 50), new SqlParameter("@CardID", SqlDbType.NVarChar, 50), new SqlParameter("@Position", SqlDbType.NVarChar, 50), new SqlParameter("@Salary", SqlDbType.Money, 8), new SqlParameter("@Remark", SqlDbType.NVarChar, -1), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.Name; parameters[1].Value = model.Sex; parameters[2].Value = model.Code; parameters[3].Value = model.CardID; parameters[4].Value = model.Position; parameters[5].Value = model.Salary; parameters[6].Value = model.Remark; parameters[7].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(string UserID) { Maticsoft.BLL.Users bll = new Maticsoft.BLL.Users(); Maticsoft.Model.Users model = bll.GetModel(UserID); this.lblUserID.Text = model.UserID; this.txtUsername.Text = model.Username; this.txtUserPassword.Text = model.UserPassword; this.txtUserRealName.Text = model.UserRealName; this.txtUserSex.Text = model.UserSex; this.txtUserEmail.Text = model.UserEmail; this.txtUserGrade.Text = model.UserGrade; this.txtUserScore.Text = model.UserScore.ToString(); this.txtProvince.Text = model.Province; this.txtCity.Text = model.City; this.txtAddress1.Text = model.Address1; this.txtUserIdentity.Text = model.UserIdentity; this.txtRegistTime.Text = model.RegistTime.ToString(); this.txtPhone.Text = model.Phone; }
protected void Btn_Check_Click(object sender, EventArgs e) { Maticsoft.Model.Users modelnew = Users_Bll.GetModel(UsersInfo.UserID);//引用id所在行的数据 string path = "^[a-zA-Z0-9_]{6,16}$"; Regex rx = new Regex(path); if (RadTextBox1.Text == "")//判断是否为空 { RadAjaxManager1.Alert("请输入原密码!"); } else if (RadTextBox1.Text != modelnew.UserPassword) { RadAjaxManager1.Alert("原密码错误!"); } else if (RadTextBox2.Text == modelnew.UserPassword) { RadAjaxManager1.Alert("不能与原密码相同!"); } else if (RadTextBox2.Text == "") { RadAjaxManager1.Alert("请输入新密码!"); } else if (!rx.IsMatch(RadTextBox2.Text)) { RadTextBox2.Text = ""; RadAjaxManager1.Alert("密码格式错误!"); } else if (RadTextBox3.Text == "") { RadAjaxManager1.Alert("请确认密码!"); } else if (RadTextBox2.Text != RadTextBox3.Text) { RadAjaxManager1.Alert("两次密码输入不一致!"); } else { User_Model = Users_Bll.GetModel(UsersInfo.UserID); User_Model.UserPassword = RadTextBox3.Text; //添加数据 Users_Bll.Update(User_Model); Response.Write("<script>alert('修改成功!');window.location.href='../Login.aspx'</script>"); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Users("); strSql.Append("sBianHao,sBianMa,sZhuYuanHao,sName,sSex,iAge,sZhiYe,dRuYuanShiJian,sPhone,sMinZu)"); strSql.Append(" values ("); strSql.Append("@sBianHao,@sBianMa,@sZhuYuanHao,@sName,@sSex,@iAge,@sZhiYe,@dRuYuanShiJian,@sPhone,@sMinZu)"); OleDbParameter[] parameters = { new OleDbParameter("@sBianHao", OleDbType.VarChar, 255), new OleDbParameter("@sBianMa", OleDbType.VarChar, 255), new OleDbParameter("@sZhuYuanHao", OleDbType.VarChar, 255), new OleDbParameter("@sName", OleDbType.VarChar, 255), new OleDbParameter("@sSex", OleDbType.VarChar, 255), new OleDbParameter("@iAge", OleDbType.VarChar, 255), new OleDbParameter("@sZhiYe", OleDbType.VarChar, 255), new OleDbParameter("@dRuYuanShiJian", OleDbType.Date), new OleDbParameter("@sPhone", OleDbType.VarChar, 20), new OleDbParameter("@sMinZu", OleDbType.VarChar, 255) }; parameters[0].Value = model.sBianHao; parameters[1].Value = model.sBianMa; parameters[2].Value = model.sZhuYuanHao; parameters[3].Value = model.sName; parameters[4].Value = model.sSex; parameters[5].Value = model.iAge; parameters[6].Value = model.sZhiYe; parameters[7].Value = model.dRuYuanShiJian; parameters[8].Value = model.sPhone; parameters[9].Value = model.sMinZu; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Users set "); strSql.Append("LoginPwd=@LoginPwd,"); strSql.Append("Name=@Name,"); strSql.Append("Address=@Address,"); strSql.Append("Phone=@Phone,"); strSql.Append("UserStateId=@UserStateId"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@LoginPwd", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Address", SqlDbType.NVarChar, 200), new SqlParameter("@Phone", SqlDbType.NVarChar, 100), new SqlParameter("@UserStateId", SqlDbType.Int, 4), new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@LoginId", SqlDbType.NVarChar, 50), new SqlParameter("@Mail", SqlDbType.NVarChar, 100) }; parameters[0].Value = model.LoginPwd; parameters[1].Value = model.Name; parameters[2].Value = model.Address; parameters[3].Value = model.Phone; parameters[4].Value = model.UserStateId; parameters[5].Value = model.Id; parameters[6].Value = model.LoginId; parameters[7].Value = model.Mail; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Users GetModel(string UserID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" UserID,Username,UserPassword,UserRealName,UserSex,UserEmail,UserGrade,UserScore,Province,City,Address1,UserIdentity,RegistTime,Phone "); strSql.Append(" from Users "); strSql.Append(" where UserID='" + UserID + "' "); Maticsoft.Model.Users model = new Maticsoft.Model.Users(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Users DataRowToModel(DataRow row) { Maticsoft.Model.Users model = new Maticsoft.Model.Users(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["Sex"] != null) { model.Sex = row["Sex"].ToString(); } if (row["Code"] != null) { model.Code = row["Code"].ToString(); } if (row["CardID"] != null) { model.CardID = row["CardID"].ToString(); } if (row["Position"] != null) { model.Position = row["Position"].ToString(); } if (row["Salary"] != null && row["Salary"].ToString() != "") { model.Salary = decimal.Parse(row["Salary"].ToString()); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Users DataRowToModel(DataRow row) { Maticsoft.Model.Users model = new Maticsoft.Model.Users(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["LoginId"] != null) { model.LoginId = row["LoginId"].ToString(); } if (row["LoginPwd"] != null) { model.LoginPwd = row["LoginPwd"].ToString(); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["Address"] != null) { model.Address = row["Address"].ToString(); } if (row["Phone"] != null) { model.Phone = row["Phone"].ToString(); } if (row["Mail"] != null) { model.Mail = row["Mail"].ToString(); } if (row["UserStateId"] != null && row["UserStateId"].ToString() != "") { model.UserStateId = int.Parse(row["UserStateId"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Users("); strSql.Append("GUID,UserName,UserAccount,UserPassWord,UserMail,RegisterTime,LoginTime,UsersState)"); strSql.Append(" values ("); strSql.Append("@GUID,@UserName,@UserAccount,@UserPassWord,@UserMail,@RegisterTime,@LoginTime,@UsersState)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@GUID", SqlDbType.NVarChar, 50), new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@UserAccount", SqlDbType.NVarChar, 20), new SqlParameter("@UserPassWord", SqlDbType.NVarChar, 50), new SqlParameter("@UserMail", SqlDbType.NVarChar, 50), new SqlParameter("@RegisterTime", SqlDbType.DateTime), new SqlParameter("@LoginTime", SqlDbType.DateTime), new SqlParameter("@UsersState", SqlDbType.Int, 4) }; parameters[0].Value = model.GUID; parameters[1].Value = model.UserName; parameters[2].Value = model.UserAccount; parameters[3].Value = model.UserPassWord; parameters[4].Value = model.UserMail; parameters[5].Value = model.RegisterTime; parameters[6].Value = model.LoginTime; parameters[7].Value = model.UsersState; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
protected void Page_Load(object sender, EventArgs e) { if (UsersInfo.UserID == "") { Response.Write("<script> alert('请先登录!'); window.location.href='/BackLogin.aspx' </script>"); return; } if (!IsPostBack) { if (!String.IsNullOrEmpty(Request.QueryString["ID"])) { if (Request.QueryString["ID"] != null) { Maticsoft.Model.Users modelnew = Users_Bll.GetModel(Request.QueryString["ID"].ToString()); //引用id所在行的数据 Label1.Text = modelnew.Username; //添加数据 RadTextBox2.Text = modelnew.UserRealName; //添加数据 ddlcityLoad(modelnew.Province); ddlcity.SelectedValue = modelnew.City; RadTextBox6.Text = modelnew.Address1;//添加数据 RadNumericTextBox1.Text = modelnew.UserScore.ToString(); RadTextBox3.Text = modelnew.UserEmail; if (modelnew.UserSex == "男") { Rad_nan.Checked = true; } else { Rad_nv.Checked = true; } RadDatePicker1.SelectedDate = modelnew.RegistTime; RadDropDownList1.SelectedValue = modelnew.UserGrade.ToString(); //添加数据 } } else { Response.Redirect("Backhygl.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if (UsersInfo.UserID == "") { Response.Write("<script> alert('请先登录!'); window.location.href='../Login.aspx' </script>"); return; } if (!IsPostBack) { if (!String.IsNullOrEmpty(UsersInfo.UserID)) { if (UsersInfo.UserID != null) { Maticsoft.Model.Users modelnew = Users_Bll.GetModel(UsersInfo.UserID); //引用id所在行的数据 Label1.Text = modelnew.Username; //添加数据 RadTextBox2.Text = modelnew.UserRealName; //添加数据 ddlcityLoad(modelnew.Province); ddlcity.SelectedValue = modelnew.City; RadTextBox6.Text = modelnew.Address1;//添加数据 RadTextBox3.Text = modelnew.UserEmail; if (modelnew.UserSex == "男") { Rad_nan.Checked = true; } else { Rad_nv.Checked = true; } Label2.Text = modelnew.RegistTime.ToString(); Label3.Text = modelnew.UserScore.ToString(); } } else { Response.Redirect("~/HomePage.aspx"); } } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Users("); strSql.Append("LoginId,LoginPwd,Name,Address,Phone,Mail,UserStateId)"); strSql.Append(" values ("); strSql.Append("@LoginId,@LoginPwd,@Name,@Address,@Phone,@Mail,@UserStateId)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@LoginId", SqlDbType.NVarChar, 50), new SqlParameter("@LoginPwd", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Address", SqlDbType.NVarChar, 200), new SqlParameter("@Phone", SqlDbType.NVarChar, 100), new SqlParameter("@Mail", SqlDbType.NVarChar, 100), new SqlParameter("@UserStateId", SqlDbType.Int, 4) }; parameters[0].Value = model.LoginId; parameters[1].Value = model.LoginPwd; parameters[2].Value = model.Name; parameters[3].Value = model.Address; parameters[4].Value = model.Phone; parameters[5].Value = model.Mail; parameters[6].Value = model.UserStateId; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.Users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Users("); strSql.Append("Name,Sex,Code,CardID,Position,Salary,Remark)"); strSql.Append(" values ("); strSql.Append("@Name,@Sex,@Code,@CardID,@Position,@Salary,@Remark)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Sex", SqlDbType.NVarChar, 50), new SqlParameter("@Code", SqlDbType.NVarChar, 50), new SqlParameter("@CardID", SqlDbType.NVarChar, 50), new SqlParameter("@Position", SqlDbType.NVarChar, 50), new SqlParameter("@Salary", SqlDbType.Money, 8), new SqlParameter("@Remark", SqlDbType.NVarChar, -1) }; parameters[0].Value = model.Name; parameters[1].Value = model.Sex; parameters[2].Value = model.Code; parameters[3].Value = model.CardID; parameters[4].Value = model.Position; parameters[5].Value = model.Salary; parameters[6].Value = model.Remark; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }