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));
}
}
