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(); } }
protected void butt_ok_Click(object sender, EventArgs e) { string sql = ""; obj = new db_help(); sql = "insert into stk (stlx,stnr,stda,stnd,zj,stfz,txbz) values('" + Text_tx.Text.ToString() + "','" + Text_nr.Text.ToString() + "','" + Text_da.Text.ToString() + "','" + Text_nd.Text.ToString() + "','" + Text_zj.Text.ToString() + "', '" + System.Convert.ToInt32(Text_fz.Text) + "' ,'" + Text_bz.Text.ToString() + "')"; obj.ExecNonSql(sql); obj.Close(); function_all.TiaoZhuan("更新成功", "stgl_edit.aspx", 0); }
protected void Rep_list_ItemCommand(object source, RepeaterCommandEventArgs e) { function_all.adminLoginChack(0, "Default.aspx"); if (e.CommandName == "dele") { obj = new db_help(); sql = "delete from stk where(stID=" + e.CommandArgument + ")"; obj.ExecNonSql(sql); obj.Close(); function_all.TiaoZhuan("删除成功", "stgl.aspx?p=" + p + "&c=" + c, 0); } }
//用户密码注册 protected void butt_ok_Click1(object sender, System.EventArgs e) { string sql = ""; string adm = System.Convert.ToString(text_adm.Text); string npw = System.Convert.ToString(text_npw.Text); obj = new db_help(); //sql = "insert into T_user (U_name,U_password) values ( '"+ adm+ "','" + npw + "')"; sql = "Insert into T_user(U_name, U_password) values('" + adm + "','" + npw + "')"; obj.ExecNonSql(sql); obj.Close(); function_all.TiaoZhuan("注册成功,请登录!", "Default.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(); } }