protected void AddStaff_But_OnClick(object sender, EventArgs e)
{
this.Timer1.Enabled = false;
if (!string.IsNullOrEmpty(this.StaffName.Text) && !string.IsNullOrEmpty(this.StaffPass.Text) && !string.IsNullOrEmpty(this.StaffTel.Text))
{
if (this.StaffPass.Text.Trim() == this.SureStaffPass.Text.Trim())
{
string mySql = "select PhoneNumber from UserInfo where PhoneNumber='" + this.StaffTel.Text.Trim() + "'";
DataSet Sr = DataBase.RunDataSet(mySql);
DataTable s = Sr.Tables[0];
if (s.Rows.Count > 0)
{
MessageTxt.Value = "此号码已存在！";
this.StaffTel.Text = "";
}
else
{
string sqlconnection = "select * from UserInfo where 0=1";
DataSet mySet = DataBase.RunDataSet(sqlconnection);
DataTable myTable = mySet.Tables[0];
DataRow myRow = myTable.NewRow();
myRow["UserName"] = this.StaffName.Text.Trim();
try
{
myRow["Sex"] = this.Sex.SelectedItem.Value;
}
catch (Exception)
{ }
myRow["RegisterTime"] = System.DateTime.Now;
myRow["PhoneNumber"] = this.StaffTel.Text.Trim();
myRow["UserRecID"] = 0;
myRow["Password"] = this.StaffPass.Text.Trim();
myRow["UserType"] = 3;
myTable.Rows.Add(myRow);
try
{
DataBase.update("UserInfo", "UserRecID", myTable);
this.Page.RegisterStartupScript("", "<script>alert('员工账号添加成功！');window.location.href= 'BossWeb.aspx'</script>");
this.StaffName.Text = "";
this.StaffTel.Text = "";
}
catch (Exception)
{
throw;
}
}
}
else
{
MessageTxt.Value = "密码与确认密码不符合，请重新输入！";
}
}
else
{
MessageTxt.Value = "用户名或电话号码或密码不能为空！";
}
}
//获取打印类型价格！
private string GetPrintMoney(string PrintName)
{
string sql = "select SinglePagePrice from PrintType where PrintName='" + PrintName + "'";
DataSet st = DataBase.RunDataSet(sql);
DataTable s = st.Tables[0];
string sa = s.Rows[0]["SinglePagePrice"].ToString();
return(sa);
}
protected void UserList_EditCommand(object source, DataListCommandEventArgs e)
{
this.Timer1.Enabled = false;
this.UserList.EditItemIndex = e.Item.ItemIndex;
string ID = this.UserList.DataKeys[e.Item.ItemIndex].ToString();
string mySql = "select UserName,Password,PhoneNumber from UserInfo where PhoneNumber='" + ID + "'";
DataSet MySet = DataBase.RunDataSet(mySql);
DataTable MyTable = MySet.Tables[0];
UserList.DataSource = MyTable;
UserList.DataBind();
}
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Label lab = e.Item.FindControl("OrderNumber") as Label;
string mySql = "select DocName,PrintName from Orders a join Doc b on a.OrderNumber=b.OrderNumber join PrintType c on b.PrintTypeID=c.PrintTypeID where a.OrderNumber='" + lab.Text + "'";
DataSet ST = DataBase.RunDataSet(mySql);
DataList DataList2 = e.Item.FindControl("DataList2") as DataList;
DataList2.DataSource = ST.Tables[0].DefaultView;
DataList2.DataBind();
}
}
//忘记密码时确定按钮
protected void OK_Click(object sender, EventArgs e)
{
phoneNumber = this.UserTel.Value.ToString().Trim();
if (String.IsNullOrEmpty(phoneNumber))
{
MessageTxt.Value = "请输入电话号码！";
return;
}
if (String.IsNullOrEmpty(this.UserNewpassword.Value.ToString().Trim()))
{
MessageTxt.Value = "请输入密码！";
return;
}
else
{
if (this.Sure_Userpassword.Value.ToString().Trim() != this.UserNewpassword.Value.ToString().Trim())
{
MessageTxt.Value = "两次输入密码不一致！";
return;
}
}
if (MetarnetRegex.IsMobilePhone(phoneNumber))
{
if (IsHaveSend && (IdentCode.Value.ToString().Trim() == SecurityCode.ToString())) //判断验证码是否正确
{
string pass = this.UserNewpassword.Value.ToString().Trim();
DataSet ds =
DataBase.RunDataSet("select * from UserInfo where PhoneNumber='" + phoneNumber + "'");
DataTable dt = ds.Tables[0];
dt.Rows[0]["Password"] = pass;
int k = DataBase.update("UserInfo", "UserRecID", dt);
if (k > 0)
{
MessageTxt.Value = "密码修改成功！";
//还原
IsHaveSend = false;
SecurityCode = 0;
return;
}
}
else
{
MessageTxt.Value = "验证码不正确！";
return;
}
}
else
{
MessageTxt.Value = "手机号格式不正确！";
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
TimeTxt.Text = DateTime.Now.ToString("yyyy-M-d dddd");
DataTable dt = Session["UserTable"] as DataTable;
if (dt == null)
{
return;
}
this.UserName.Text = dt.Rows[0]["UserName"].ToString();
this.userName1.Text = this.UserName.Text;
this.UserTelNumber.Text = dt.Rows[0]["PhoneNumber"].ToString();
this.College.Text = dt.Rows[0]["College"].ToString();
this.Major.Text = dt.Rows[0]["Major"].ToString();
this.UserCollge.Text = dt.Rows[0]["College"].ToString();
this.UserMajor.Text = dt.Rows[0]["Major"].ToString();
this.UserQQMail.Text = dt.Rows[0]["Email"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["Sex"].ToString()))
{
this.Sex.SelectedIndex = Convert.ToInt16(dt.Rows[0]["Sex"].ToString());
if (dt.Rows[0]["Sex"].ToString().Equals("0"))
{
this.SexTxt.Text = "男";
}
else
{
this.SexTxt.Text = "女";
}
}
else
{
this.SexTxt.Text = null;
}
string sql = "select AddressName from Address where UserRecID='" + dt.Rows[0]["UserRecID"].ToString() + "'";
DataSet st = DataBase.RunDataSet(sql);
DataTable s = st.Tables[0];
if (s.Rows.Count > 0)
{
Repeater1.DataSource = s;
Repeater1.DataBind();
}
}
else
{
return;
}
}
/// <summary>
/// 获取表
/// </summary>
/// <returns></returns>
public DataTable getDatable(EnUserInfo obj)
{
string sql = "select * from UserInfo where 0=1";
DataSet ds = DataBase.RunDataSet(sql);
DataTable user = ds.Tables[0];
DataRow dr = user.NewRow();
dr["UserRecID"] = 0;
dr["UserName"] = obj.uerName;
dr["Password"] = obj.password;
dr["RegisterTime"] = obj.registerTime;
dr["PhoneNumber"] = obj.phoneNumber;
dr["UserType"] = 1;
user.Rows.Add(dr);
return(user);
}
private void SelectInfo(string StartTime, string EndTime)
{
string SqlOrder = "select OrderNumber,OrderTypeID,UserName,PlaceOrderTime,PhoneNumber,AddressName,Coment,ToalPrice from Orders a join UserInfo b on a.UserRecID=b.UserRecID join Address c on a.AddressRecID=c.AddressRecID where PlaceOrderTime between'" + StartTime + "' and '" + EndTime + "' order by('OrderNumber') desc";
DataSet st = DataBase.RunDataSet(SqlOrder);
DataTable s = st.Tables[0];
if (s.Rows.Count > 0)
{
DataList1.DataSource = s;
DataList1.DataBind();
}
else
{
DataList1.DataBind();
}
}
protected void OrderBtu_Click(object sender, EventArgs e)
{
EnOrder en = Session["OrderInfo"] as EnOrder;
CnOrders cn = new CnOrders();
DataTable dt = cn.getDataTable("select * from Orders where OrderNumber='" + en.orderNumber.Trim() + "'");
dt.Rows[0]["Coment"] = Coments.Text.Trim();
DataSet ds = DataBase.RunDataSet("select * from Doc where 0=1");
DataTable DocTable = ds.Tables[0];
try
{
dt.Rows[0]["OrderTypeID"] = int.Parse(SendMothedList.SelectedItem.Value.Trim());
dt.Rows[0]["AddressRecID"] = int.Parse(AddressList.SelectedItem.Value.Trim());
dt.Rows[0]["ToalPrice"] = this.Money.Text;
int k = DataBase.update("Orders", "OrderNumber", dt);
List <EnDoc> docslist = en.docs;
foreach (var item in docslist)
{
DataRow dr = DocTable.NewRow();
dr["DocID"] = 0;
dr["OrderNumber"] = en.orderNumber.Trim();
dr["Comment"] = Coments.Text.Trim();
dr["DocName"] = item.docName;
dr["DocPath"] = item.docPath;
dr["DocTypeID"] = item.docTypeID;
dr["UploadTime"] = en.placeOrderTime;
dr["TotalPages"] = item.totalPages;
dr["PrintTypeID"] = item.printTypeID;
DocTable.Rows.Add(dr);
}
int j = DataBase.update("Doc", "DocID", DocTable);
this.Page.RegisterStartupScript("",
"<script>alert('下单成功！');window.location.href= 'UserCenter.aspx'</script>");
}
catch (Exception)
{
int k =
DataBase.ExecuteNonQuery("delete Orders where OrderNumber='" +
en.orderNumber + "'");
int l = DataBase.ExecuteNonQuery("delete Doc where OrderNumber='" +
en.orderNumber + "'");
this.Page.RegisterStartupScript("",
"<script>alert('下单失败！');window.location.href= 'UserCenter.aspx'</script>");
}
}
protected void Get_IdentifyCode_Click(object sender, EventArgs e)
{
phoneNumber = this.UserTelNumber.Text.Trim();
DataSet ds = DataBase.RunDataSet("select * from UserInfo where PhoneNumber='" + phoneNumber + "' and UserName='******'");
if (ds.Tables[0].Rows.Count > 0 && MetarnetRegex.IsMobilePhone(phoneNumber))
{
MessageTxt.Value = "请检查你的手机号是否已修改！";
}
else
{
Random rd = new Random();
SecurityCode = rd.Next(1234, 9879); //生成验证码
SendSecurityCode(SecurityCode.ToString()); //发送验证码，后面还要根据返回的值判断是否发送成功
IsHaveSend = true;
}
}
//注册时发送验证码
protected void Get_IdentifyCode_Click(object sender, EventArgs e)
{
phoneNumber = this.user_PhoneNumber.Value.ToString().Trim();
DataSet ds = DataBase.RunDataSet("select * from UserInfo where PhoneNumber='" + phoneNumber + "'");
if (ds.Tables[0].Rows.Count > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('此手机号已注册！')", true);
this.user_PhoneNumber.Focus();
}
else
{
Random rd = new Random();
SecurityCode = rd.Next(1234, 9879); //生成验证码
SendSecurityCode(SecurityCode.ToString()); //发送验证码，后面还要根据返回的值判断是否发送成功
IsHaveSend = true;
}
}
//忘记密码时发送验证码
protected void GetIdentCode_Click(object sender, EventArgs e)
{
phoneNumber = this.UserTel.Value.ToString().Trim();
DataSet ds = DataBase.RunDataSet("select * from UserInfo where PhoneNumber='" + phoneNumber + "'");
try
{
if (ds.Tables[0].Rows.Count > 0)
{
Random rd = new Random();
SecurityCode = rd.Next(1234, 9879); //生成验证码
SendSecurityCode(SecurityCode.ToString()); //发送验证码，后面还要根据返回的值判断是否发送成功
IsHaveSend = true;
}
}
catch (Exception)
{
MessageTxt.Value = "此手机号未注册，请先注册！";
}
}
protected void UserList_UpdateCommand(object source, DataListCommandEventArgs e)
{
this.Timer1.Enabled = false;
string ID = this.UserList.DataKeys[e.Item.ItemIndex].ToString();
string mySql = "select UserRecID,UserName,Password,PhoneNumber from UserInfo where PhoneNumber='" + ID + "'";
DataSet MySet = DataBase.RunDataSet(mySql);
DataTable MyTable = MySet.Tables[0];
try
{
MyTable.Rows[0]["UserName"] = ((TextBox)e.Item.FindControl("userText")).Text.Trim();
MyTable.Rows[0]["Password"] = ((TextBox)e.Item.FindControl("pwdText")).Text.Trim();
MyTable.Rows[0]["PhoneNumber"] = ((TextBox)e.Item.FindControl("phoneNumText")).Text.Trim();
DataBase.update("UserInfo", "UserRecID", MyTable);
ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('更新成功！');window.location.href= 'BossWeb.aspx'", true);
}
catch (Exception)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = Session["UserTable"] as DataTable;
EnOrder en = Session["OrderInfo"] as EnOrder;
if (dt == null || en == null)
{
return;
}
this.UserName.Text = dt.Rows[0]["UserName"].ToString();
OrderNumber.Text = en.orderNumber.ToString();
OrderTime.Text = en.placeOrderTime.ToString();
Coments.Text = "";
List <EnDoc> docslist = en.docs;
Repeater1.DataSource = docslist;
Repeater1.DataBind();
string Sql = "select * from Address where UserRecID='" + dt.Rows[0]["UserRecID"].ToString() + "'";
DataSet ST = DataBase.RunDataSet(Sql);
DataTable S = ST.Tables[0];
AddressList.DataSource = S;
AddressList.DataValueField = "AddressRecID";
AddressList.DataTextField = "AddressName";
AddressList.DataBind();
string mySql = "select * from OrderType";
DataSet st = DataBase.RunDataSet(mySql);
DataTable s = st.Tables[0];
SendMothedList.DataSource = s;
SendMothedList.DataValueField = "OrderTypeID";
SendMothedList.DataTextField = "OrderTypeName";
SendMothedList.DataBind();
this.SendMothedList.SelectedIndex = 0;
double addmoney = Convert.ToSingle(s.Rows[0]["SendPrice"].ToString()) * 1.0;
this.AddMoney.Text = addmoney.ToString();
float All = Convert.ToSingle(en.toalPrice.ToString()) + Convert.ToSingle(s.Rows[0]["SendPrice"].ToString());
Money.Text = All.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
TimeTxt.Text = DateTime.Now.ToString("yyyy-MM-dd");
string AddTime = System.DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
if (!IsPostBack)
{
DataTable dt = Session["UserTable"] as DataTable;
if (dt.Rows[0]["UserType"].ToString() == "3")
{
this.shop.Visible = false;
this.num.Visible = false;
}
SelectInfo(TimeTxt.Text, AddTime);
string Sql = "select UserName,Password,PhoneNumber from UserInfo where UserType=3";
DataSet ST = DataBase.RunDataSet(Sql);
DataTable S = ST.Tables[0];
UserList.DataSource = S;
UserList.DataBind();
Timer Timer1 = new Timer();
Timer1.Enabled = true; //启动计时器
}
}
protected void SureAdress_Click(object sender, EventArgs e)
{
DataTable dt = Session["UserTable"] as DataTable;
string Sql = "select * from Address where UserRecID='" + dt.Rows[0]["UserRecID"].ToString() + "'";
DataSet ST = DataBase.RunDataSet(Sql);
DataTable S = ST.Tables[0];
try
{
DataRow dr = S.NewRow();
dr["AddressRecID"] = 0;
dr["UserRecID"] = dt.Rows[0]["UserRecID"].ToString();
dr["AddressName"] = this.AdressTex.Text.Trim();
dr["IsUsuallyAddress"] = "0";
S.Rows.Add(dr);
int k = DataBase.update("Address", "AddressRecID", S);
this.Page.RegisterStartupScript("", "<script>alert('增加成功！');window.location.href= 'Order.aspx'</script>");
}
catch (Exception)
{
this.Page.RegisterStartupScript("", "<script>alert('增加失败！');window.location.href= 'Order.aspx'</script>");
this.SureAdress.Text = "";
}
}
protected void SaveBtu_Click(object sender, EventArgs e)
{
int count, k, j, m, n;
//修改打印类型每页单价
string Sql = "select * from PrintType ";
DataSet ST = DataBase.RunDataSet(Sql);
DataTable S = ST.Tables[0];
S.Rows[0]["SinglePagePrice"] = this.BWPrice.Text.Trim();
S.Rows[1]["SinglePagePrice"] = this.ColorPrice.Text.Trim();
try
{
k = DataBase.update("PrintType", "PrintTypeID", S);
}
catch (Exception)
{
throw;
}
//修改配送方式价格
string mySql = "select * from OrderType";
DataSet mySet = DataBase.RunDataSet(mySql);
DataTable myTable = mySet.Tables[0];
myTable.Rows[0]["SendPrice"] = this.SendModePrice0.Text.Trim();
myTable.Rows[1]["SendPrice"] = this.SendModePrice1.Text.Trim();
myTable.Rows[2]["SendPrice"] = this.SendModePrice2.Text.Trim();
try
{
j = DataBase.update("OrderType", "OrderTypeID", myTable);
}
catch (Exception)
{
throw;
}
//修改电话号码、地址
DataTable dt = Session["UserTable"] as DataTable;
dt.Rows[0]["PhoneNumber"] = this.PhoneNumberTXT.Text.Trim();
try
{
m = DataBase.update("UserInfo", "UserRecID", dt);
}
catch (Exception)
{
throw;
}
string SqlConnection = "select * from Address where UserRecID=" +
dt.Rows[0]["UserRecID"].ToString();
DataSet myDataSet = DataBase.RunDataSet(SqlConnection);
DataTable myDataTable = myDataSet.Tables[0];
myDataTable.Rows[0]["AddressName"] = this.AddressTXT.Text.Trim();
try
{
n = DataBase.update("Address", "AddressRecID", myDataTable);
}
catch (Exception)
{
throw;
}
count = k + j + m + n;
if (count > 0)
{
this.Response.Write(" <script language=javascript>alert('修改成功！'); window.location.href= 'ShopManagement.aspx'</script> ");
}
else
{
MessageTxt.Value = "修改失败！";
}
}
//登录
protected void LoginClick(object sender, EventArgs e)
{
DataTable UserTable = new DataTable();
string NameOrNumber = UserTextBox.Text.Trim();
string Password = PasswarTextBox.Text.Trim();
if (String.IsNullOrEmpty(NameOrNumber))
{
MessageTxt.Value = "请输入用户名！";
return;
}
try //电话号码登录
{
DataSet ds = DataBase.RunDataSet("select * from UserInfo where PhoneNumber='" + NameOrNumber + "'");
Convert.ToInt64(NameOrNumber);
if (NameOrNumber.Length == 11)
{
UserTable = user.getUserByPhoneNumber(NameOrNumber);
if (UserTable.Rows.Count == 0)
{
MessageTxt.Value = "用户名不正确！";
return;
}
if (UserTable.Rows[0]["Password"].ToString() == Password) //Common.StringToMD5(Password)
{
int s = Convert.ToInt32(ds.Tables[0].Rows[0]["UserType"].ToString());
if (s == 1)
{
Session["UserTable"] = new DataTable();
Session["UserTable"] = UserTable;
HttpCookie cookie = new HttpCookie("User");
if (this.AutoLogin.Checked)
{
System.Text.Encoding enc = System.Text.Encoding.GetEncoding("gb2312");
string LoginName = HttpUtility.UrlEncode(this.UserTextBox.Text.Trim(), enc);
string LoginPass = HttpUtility.UrlEncode(this.PasswarTextBox.Text.Trim(), enc);
////所有的验证信息检测之后，如果用户选择的记住密码，则将用户名和密码写入Cookie里面保存起来。
cookie.Values.Add("UserName", LoginName);
cookie.Values.Add("UserPassword", LoginPass);
////这里是设置Cookie的过期时间，这里设置一个星期的时间，过了一个星期之后状态保持自动清空。
cookie.Expires = System.DateTime.Now.AddDays(7.0);
HttpContext.Current.Response.Cookies.Add(cookie);
}
else
{
if (cookie != null)
{
//如果用户没有选择记住密码，那么立即将Cookie里面的信息情况，并且设置状态保持立即过期。
cookie.Values.Clear();
cookie.Values.Remove("UserName");
TimeSpan ts = new TimeSpan(-1, 0, 0, 0);
cookie.Expires = DateTime.Now.Add(ts); //删除整个Cookie，只要把过期时间设置为现在
Response.AppendCookie(cookie);
}
}
Response.Redirect("UserMain.aspx");
}
else
{
Session["UserTable"] = new DataTable();
Session["UserTable"] = UserTable;
HttpCookie cookie = new HttpCookie("User");
if (this.AutoLogin.Checked)
{
System.Text.Encoding enc = System.Text.Encoding.GetEncoding("gb2312");
string LoginName = HttpUtility.UrlEncode(this.UserTextBox.Text.Trim(), enc);
string LoginPass = HttpUtility.UrlEncode(this.PasswarTextBox.Text.Trim(), enc);
////所有的验证信息检测之后，如果用户选择的记住密码，则将用户名和密码写入Cookie里面保存起来。
cookie.Values.Add("UserName", LoginName);
cookie.Values.Add("UserPassword", LoginPass);
////这里是设置Cookie的过期时间，这里设置一个星期的时间，过了一个星期之后状态保持自动清空。
cookie.Expires = System.DateTime.Now.AddDays(7.0);
HttpContext.Current.Response.Cookies.Add(cookie);
}
else
{
if (cookie != null)
{
//如果用户没有选择记住密码，那么立即将Cookie里面的信息情况，并且设置状态保持立即过期。
cookie.Values.Clear();
cookie.Values.Remove("UserName");
TimeSpan ts = new TimeSpan(-1, 0, 0, 0);
cookie.Expires = DateTime.Now.Add(ts); //删除整个Cookie，只要把过期时间设置为现在
Response.AppendCookie(cookie);
}
}
Response.Redirect("BossWeb.aspx");
}
}
else
{
MessageTxt.Value = "密码不正确，请重新输入！";
}
}
}
catch (Exception ex) //用户名登陆
{
DataSet ds = DataBase.RunDataSet("select * from UserInfo where UserName='******'");
UserTable = user.getUserByUserName(NameOrNumber);
if (UserTable.Rows.Count == 0)
{
MessageTxt.Value = "用户名不正确！";
this.UserTextBox.Text = "";
return;
}
else
{
if (UserTable.Rows[0]["Password"].ToString() == Password) //Common.StringToMD5(Password)
{
int s = Convert.ToInt32(ds.Tables[0].Rows[0]["UserType"].ToString());
if (s == 1)
{
Session["UserTable"] = new DataTable();
Session["UserTable"] = UserTable;
HttpCookie cookie = new HttpCookie("User");
if (this.AutoLogin.Checked)
{
System.Text.Encoding enc = System.Text.Encoding.GetEncoding("gb2312");
string LoginName = HttpUtility.UrlEncode(this.UserTextBox.Text.Trim(), enc);
string LoginPass = HttpUtility.UrlEncode(this.PasswarTextBox.Text.Trim(), enc);
////所有的验证信息检测之后，如果用户选择的记住密码，则将用户名和密码写入Cookie里面保存起来。
cookie.Values.Add("UserName", LoginName);
cookie.Values.Add("UserPassword", LoginPass);
////这里是设置Cookie的过期时间，这里设置一个星期的时间，过了一个星期之后状态保持自动清空。
cookie.Expires = System.DateTime.Now.AddDays(7.0);
HttpContext.Current.Response.Cookies.Add(cookie);
}
else
{
if (cookie != null)
{
//如果用户没有选择记住密码，那么立即将Cookie里面的信息情况，并且设置状态保持立即过期。
cookie.Values.Clear();
cookie.Values.Remove("UserName");
TimeSpan ts = new TimeSpan(-1, 0, 0, 0);
cookie.Expires = DateTime.Now.Add(ts); //删除整个Cookie，只要把过期时间设置为现在
Response.AppendCookie(cookie);
}
}
Response.Redirect("UserMain.aspx");
}
else
{
Session["UserTable"] = new DataTable();
Session["UserTable"] = UserTable;
HttpCookie cookie = new HttpCookie("User");
if (this.AutoLogin.Checked)
{
System.Text.Encoding enc = System.Text.Encoding.GetEncoding("gb2312");
string LoginName = HttpUtility.UrlEncode(this.UserTextBox.Text.Trim(), enc);
string LoginPass = HttpUtility.UrlEncode(this.PasswarTextBox.Text.Trim(), enc);
////所有的验证信息检测之后，如果用户选择的记住密码，则将用户名和密码写入Cookie里面保存起来。
cookie.Values.Add("UserName", LoginName);
cookie.Values.Add("UserPassword", LoginPass);
////这里是设置Cookie的过期时间，这里设置一个星期的时间，过了一个星期之后状态保持自动清空。
cookie.Expires = System.DateTime.Now.AddDays(7.0);
HttpContext.Current.Response.Cookies.Add(cookie);
}
else
{
if (cookie != null)
{
//如果用户没有选择记住密码，那么立即将Cookie里面的信息情况，并且设置状态保持立即过期。
cookie.Values.Clear();
cookie.Values.Remove("UserName");
TimeSpan ts = new TimeSpan(-1, 0, 0, 0);
cookie.Expires = DateTime.Now.Add(ts); //删除整个Cookie，只要把过期时间设置为现在
Response.AppendCookie(cookie);
}
}
Response.Redirect("BossWeb.aspx");
}
}
else
{
MessageTxt.Value = "密码不正确，请重新输入！";
}
}
}
}
//增加、删除地址
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
DataTable dt = Session["UserTable"] as DataTable;
int i = Convert.ToInt32(dt.Rows[0]["UserRecID"]);
string AdressNum = "select AddressName from Address where UserRecID=" + i;
DataSet AdressN = DataBase.RunDataSet(AdressNum);
if (e.CommandName.Equals("del"))
{
if (AdressN.Tables[0].Rows.Count > 1)
{
string mycon = "delete from Address where AddressName='" + e.CommandArgument + "'";
int k = DataBase.ExecuteNonQuery(mycon);
if (k > 0)
{
MessageTxt.Value = "删除成功！";
}
Response.Redirect("UserCenter.aspx");
}
else
{
MessageTxt.Value = "必须要有一个地址！删除失败！";
}
}
if (e.CommandName == "insert")
{
TextBox tbx = (TextBox)e.Item.FindControl("UserAdressAdd");
if (tbx.Text != "")
{
if (AdressN.Tables[0].Rows.Count < 3)
{
for (int k = 0; k < AdressN.Tables[0].Rows.Count; k++)
{
if (tbx.Text != AdressN.Tables[0].Rows[k]["AddressName"].ToString())
{
string sql = "select * from Address where 0=1";
DataSet AdressForm = DataBase.RunDataSet(sql);
DataTable AdresTable = new DataTable();
AdresTable = AdressForm.Tables[0];
DataRow dr = AdresTable.NewRow();
dr["AddressRecID"] = 0;
dr["UserRecID"] = i;
dr["AddressName"] = tbx.Text;
dr["IsUsuallyAddress"] = 1;
AdresTable.Rows.Add(dr);
int p = DataBase.update("Address", "AddressRecID", AdresTable);
if (p > 0)
{
MessageTxt.Value = "增添成功！";
tbx.Text = "";
}
Response.Redirect("UserCenter.aspx");
}
else
{
MessageTxt.Value = "此地址已存在！请重新输入！";
tbx.Text = "";
}
}
}
else
{
MessageTxt.Value = "地址不能超过三个！添加失败！";
tbx.Text = "";
}
}
else
{
MessageTxt.Value = "不能增添地址，请重新输入地址！";
}
}
}
