protected void Rep_list_ItemCommand(object source, RepeaterCommandEventArgs e) { function_all.adminLoginChack(0, "Default.aspx"); obj = new db_help(); if (e.CommandName == "dele") { sql = "delete from stk where(stID=" + e.CommandArgument + ")"; obj.ExecNonSql(sql); function_all.TiaoZhuan("删除成功", "shoudonng.aspx?p=" + p + "&c=" + c, 0); } if (e.CommandName == "tianjia") { //可以用if语句来实现分类查询 sql = "select stnr from stk where(stID=" + e.CommandArgument + ")"; rds = obj.ExecReaderSql(sql); if (rds.Read()) { if (!Convert.IsDBNull(rds["stnr"])) { // Text_nr.Text = "First Line\r\nSecond Line\r\nThird Line"; Text_nr.Text = rds["stnr"].ToString(); //Server.HtmlEncode(br); } } Text_nr.Text = rds["stnr"].ToString(); } }
/// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> protected void butt_log_Click(object sender, EventArgs e) { string sql = ""; db_help obj = new db_help(); SqlDataReader rds = default(SqlDataReader); string gadm = ""; string gpwd = ""; gadm = System.Convert.ToString(text_adm.Text); gpwd = System.Convert.ToString(text_pwd.Text); //判断用户输出是否为空或者过长 if (gadm.Length <= 0 || gpwd.Length <= 0) { function_all.TiaoZhuan("用户名/密码不能为空", "Default.aspx", 0); Response.End(); } int bdid = 0; string dbpwd = ""; sql = "Select * from T_user where U_name ='" + gadm + "' and U_password ='******'"; rds = obj.ExecReaderSql(sql); if (rds.Read()) { Session["aid"] = rds.GetValue(rds.GetOrdinal("U_name")); //获取该用户名 Session["aid"] = rds.GetValue(rds.GetOrdinal("U_password")); //获取该用户密码 Page.Response.Redirect("welcome.aspx"); rds.Close(); rds.Close(); } else { function_all.TiaoZhuan("账号/密码错误", "Default.aspx", 0);//提示 Response.End(); } //文本框中输入的账号和密码与session存储的数据比对 if (gpwd == dbpwd) { Session["aid"] = bdid; HttpCookieCollection myCookieCollection = new HttpCookieCollection(); //HttpCookie类专门由C#用于读取和写入Cookie的类。 HttpCookie cstgl = new HttpCookie("cstgl"); cstgl.Value = DateTime.Now.ToString(); myCookieCollection.Add(cstgl); Response.AppendCookie(cstgl); } else { function_all.TiaoZhuan("账号/密码错误", "Default.aspx", 0); Response.End(); } }
//用户名匹配 public void controls_bind() { obj = new db_help(); sql = "SELECT UserName FROM admin "; rds = obj.ExecReaderSql(sql); if (rds.Read()) { if (Convert.IsDBNull(rds["UserName"]) == null) { text_adm.Text = System.Convert.ToString(rds["UserName"]); } } rds.Close(); obj.Close(); }
private void InputExcel(string pPath) { string conn = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =" + pPath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'"; OleDbConnection oleCon = new OleDbConnection(conn); oleCon.Open(); string Sql = "select * from [Sheet1$]"; OleDbDataAdapter mycommand = new OleDbDataAdapter(Sql, oleCon); DataSet ds = new DataSet(); mycommand.Fill(ds, "[Sheet1$]"); oleCon.Close(); int count = ds.Tables["[Sheet1$]"].Rows.Count; for (int i = 0; i < count; i++) { string stlx, stnr, stda, stnd, zj, stfz, txbz; stlx = ds.Tables["[Sheet1$]"].Rows[i]["stlx"].ToString().Trim(); stnr = ds.Tables["[Sheet1$]"].Rows[i]["stnr"].ToString().Trim(); stda = ds.Tables["[Sheet1$]"].Rows[i]["stda"].ToString().Trim(); stnd = ds.Tables["[Sheet1$]"].Rows[i]["stnd"].ToString().Trim(); zj = ds.Tables["[Sheet1$]"].Rows[i]["zj"].ToString().Trim(); stfz = ds.Tables["[Sheet1$]"].Rows[i]["stfz"].ToString().Trim(); txbz = ds.Tables["[Sheet1$]"].Rows[i]["txbz"].ToString().Trim(); string excelsql = "insert into stk(stlx, stnr, stda,stnd,zj,stfz,txbz) values ('" + stlx + "','" + stnr + "','" + stda + "','" + stnd + "','" + zj + "','" + stfz + "','" + txbz + "')"; try { //导入到SQL Server中 db_help dm = new db_help(); dm.ExecReaderSql(excelsql); // Response.Write("<script language='javascript'>Alert('数据导入成功!');window.location='stgl_edit.aspx'</script>"); function_all.TiaoZhuan("数据导入成功", "stgl_edit.aspx", 0); } catch (Exception) { //Response.Write("<script language='javascript'>Alert('数据导入失败!');window.location='stgl_edit.aspx'</script>"); function_all.TiaoZhuan("数据导入失败", "stgl_sdit.aspx", 0); } } }
//用户密码匹配与密码修改 protected void butt_ok_Click1(object sender, System.EventArgs e) { function_all.adminLoginChack(0, "Default.aspx"); string ers = null; string adm = System.Convert.ToString(text_adm.Text.Trim()); string opw = System.Convert.ToString(text_opw.Text); string npw = System.Convert.ToString(text_npw.Text); string spw = System.Convert.ToString(text_spw.Text); Regex umReg = new Regex("^[A-Za-z0-9]{1,50}$"); if (!umReg.IsMatch(adm)) { ers = "管理员账号不能为空,最大支持50个字符,可以是0-9、a-z、A-Z的组合"; } if (string.IsNullOrEmpty(ers)) { if (opw.Length <= 0 || npw.Length <= 0 || spw.Length <= 0) { ers = "密码不能为空"; } else { if (npw != spw) { ers = "两次输入的新密码不一样"; } } } if (string.IsNullOrEmpty(ers)) { string dbpwd = ""; obj = new db_help(); sql = "SELECT PassWord FROM admin"; rds = obj.ExecReaderSql(sql); if (rds.Read()) { if (!Convert.IsDBNull(rds["PassWord"])) { dbpwd = System.Convert.ToString(rds["PassWord"]); } } rds.Close(); obj.Close(); if (opw != dbpwd) { ers = "原密码不正确"; } } if (string.IsNullOrEmpty(ers)) { obj = new db_help(); sql = "UPDATE admin SET UserName = '******', PassWord = '******' "; obj.ExecNonSql(sql); obj.Close(); function_all.TiaoZhuan("密码修改成功,下次登录生效!", "welcome.aspx", 0); Response.End(); } else { function_all.TiaoZhuan(ers, "password.aspx", 0); Response.End(); } }
protected void butt_ok_Click(object sender, EventArgs e) { int a = System.Convert.ToInt32(Txt_1.Text); obj = new db_help(); if (System.Convert.ToUInt32(c) == 1) { sql = "select top " + a + " [X_nr] from xzt where X_zj= " + Txt_3.Text + " and X_nd= '" + Txt_2.Text.ToString() + "'"; rds = obj.ExecReaderSql(sql); if (rds.Read()) { if (!Convert.IsDBNull(rds["X_nr"])) { Text_nr.Text = rds["X_nr"].ToString(); } } } if (System.Convert.ToUInt32(c) == 2) { sql = "select top " + a + " p_nr from pdt where p_zj=" + Txt_3.Text + "and p_nd='" + Txt_2.Text.ToString() + "'"; rds = obj.ExecReaderSql(sql); if (rds.Read()) { if (!Convert.IsDBNull(rds["p_nr"])) { Text_nr.Text = rds["p_nr"].ToString(); } } } if (System.Convert.ToUInt32(c) == 3) { sql = "select top " + a + " d_nr from dcx where d_zj=" + Txt_3.Text + "and d_nd='" + Txt_2.Text.ToString() + "'"; rds = obj.ExecReaderSql(sql); if (rds.Read()) { if (!Convert.IsDBNull(rds["d_nr"])) { Text_nr.Text = rds["d_nr"].ToString(); } } } if (System.Convert.ToUInt32(c) == 4) { sql = "select top " + a + " j_nr from jdt where j_zj=" + Txt_3.Text + "and j_nd='" + Txt_2.Text.ToString() + "'"; rds = obj.ExecReaderSql(sql); if (rds.Read()) { if (!Convert.IsDBNull(rds["j_nr"])) { Text_nr.Text = rds["j_nr"].ToString(); } } } if (System.Convert.ToUInt32(c) == 5) { sql = "select top " + a + " b_nr from bct where b_zj=" + Txt_3.Text + "and b_nd='" + Txt_2.Text.ToString() + "'"; rds = obj.ExecReaderSql(sql); if (rds.Read()) { if (!Convert.IsDBNull(rds["b_nr"])) { Text_nr.Text = rds["b_nr"].ToString(); } } } }