/// <summary> /// 绑定用户信息 /// </summary> /// <param name="username"></param> private void BindUser() { UserParamManager upmg=new UserParamManager(); userparam up = upmg.GetUser(Session["username"].ToString()); realname.Text = up.Truename; telephone.Text = up.Phone; mobile.Text = up.Mobile; address.Text = up.Address; }
protected void Button2_Click(object sender, EventArgs e) { UserParamManager upmg=new UserParamManager(); GridView1.DataSource = upmg.GetAllUser(); GridView1.DataBind(); TabWebControl1.SelectedTabIndex = 1; Response.Clear(); Response.Buffer = true; Response.Charset = "GB2312"; Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls"); Response.ContentEncoding = System.Text.Encoding.UTF7; Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。 System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); this.GridView1.RenderControl(oHtmlTextWriter); Response.Output.Write(oStringWriter.ToString()); Response.Flush(); Response.End(); }
protected void Button1_Click(object sender, EventArgs e) { UserParamManager upmg=new UserParamManager(); if (username.Text.ToString().Trim() == "" || password.Text.ToString().Trim() == "") { ClientScript.RegisterStartupScript(this.GetType(), "提示", "<script>alert('用户名或密码必填')</script>"); } else { if (upmg.login(username.Text.ToString().Trim(), password.Text.ToString().Trim())) { Session["username"] = username.Text.ToString().Trim(); WebReportLogManager.AddNesWebReportLog(username.Text.ToString().Trim(), true); Response.Redirect("main.aspx"); } else { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('用户名或密码错误')</script>"); password.Text = ""; WebReportLogManager.AddNesWebReportLog(username.Text.ToString().Trim(), false); } } }
/// <summary> /// ���ض���ʱ�䵼������ /// </summary> /// <param name="timesring"></param> /// <param name="timenow"></param> private void ImportData(string timesring, string timenow) { bool flag = false; UserParamManager upg = new UserParamManager(); string[] a = timesring.Split(' '); if (a.Length == 0) { if (timesring == timenow&&flag==false) { upg.DelAll(); listBox1.Items.Add("UserParam���ѳɹ����"); DataTable dt = new DataTable(); dt = GetDataTableFromMySql(); for (int j = 0; j < dt.Rows.Count; j++) { upg.AddUser(dt.Rows[j]["username"].ToString(), Function.PasswordMD5(dt.Rows[j]["password"].ToString()), ISO8859_GB2312(dt.Rows[j]["realname"].ToString()), ISO8859_GB2312(dt.Rows[j]["address"].ToString()), dt.Rows[j]["telephone"].ToString(), dt.Rows[j]["mobile"].ToString()); //listBox1.Items.Add(ISO8859_GB2312(dt.Rows[j]["address"].ToString())); } dt.Dispose(); listBox1.Items.Add("���ݿ��ѳɹ�����"); flag = true; } } else { string[] time = timesring.Split(' '); for (int i = 0; i < time.Length; i++) { if (time[i] == timenow&&flag==false) { upg.DelAll(); listBox1.Items.Add("UserParam���ѳɹ����"); DataTable dt = new DataTable(); dt = GetDataTableFromMySql(); for (int j = 0; j < dt.Rows.Count; j++) { upg.AddUser(dt.Rows[j]["username"].ToString(), Function.PasswordMD5(dt.Rows[j]["password"].ToString()), ISO8859_GB2312(dt.Rows[j]["realname"].ToString()), ISO8859_GB2312(dt.Rows[j]["address"].ToString()), dt.Rows[j]["telephone"].ToString(), dt.Rows[j]["mobile"].ToString()); //listBox1.Items.Add(ISO8859_GB2312(dt.Rows[j]["address"].ToString())); } dt.Dispose(); listBox1.Items.Add("���ݿ��ѳɹ�����"); flag = true; } } } }