protected void btnSearchNews_Click(object sender, EventArgs e) { grdViwConsult.Visible = false; grdViwDye.Visible = false; grdViwFertilizer.Visible = false; grdViwNews.Visible = false; grdViwUsers.Visible = false; if (radBtnSearchNewsID.Checked) { strSqlCmd = "select * from news where newsID = '" + txtKeyword.Text + "'"; } else if (radBtnSearchNewsTitle.Checked) { strSqlCmd = "select * from news where newsTitle like '%" + txtKeyword.Text + "%'"; } else { strSqlCmd = "select * from news where newsContent like '%" + txtKeyword.Text + "%'"; } DS = DatabaseOperating.fillDataSet(strSqlCmd, "searchResultNews"); grdViwNews.DataSource = DS; grdViwNews.DataBind(); grdViwNews.Visible = true; }
protected void btnDyeAddModify_Click(object sender, EventArgs e) { if (btnDyeAddModify.Text.Equals("修改")) { strSqlCmd = "update dye set dyeName = '" + txtDyeName.Text + "',dyeColor = '" + txtDyeColor.Text + "',dyeStock = '" + txtDyeStock.Text + "' where dyeID = '" + lblDyeID.Text + "'"; DatabaseOperating.sqlCmdInsertDeleteUpdate(strSqlCmd); } else if (btnDyeAddModify.Text.Equals("添加")) { strSqlCmd = "insert into dye(dyeName,dyeColor,dyeStock) values('" + txtDyeName.Text + "','" + txtDyeColor.Text + "','" + txtDyeStock.Text + "')"; DatabaseOperating.sqlCmdInsertDeleteUpdate(strSqlCmd); } Page_Load(sender, e); txtDyeName.Text = ""; txtDyeColor.Text = ""; txtDyeStock.Text = ""; }
protected void btnUserDelete_Click(object sender, EventArgs e) { Button btnUserID = (Button)sender; string strSqlCmd = "delete from users where userID = '" + btnUserID.CommandArgument.ToString() + "'"; DatabaseOperating.sqlCmdInsertDeleteUpdate(strSqlCmd); Page_Load(sender, e); }
protected void btnLinkDelete_Click(object sender, EventArgs e) { Button btnLinkDelete = (Button)sender; strSqlCmd = "delete from links where linkID = '" + btnLinkDelete.CommandArgument.ToString() + "'"; DatabaseOperating.sqlCmdInsertDeleteUpdate(strSqlCmd); this.Page_Load(sender, e); }
protected void Page_Load(object sender, EventArgs e) { if (Session["userRight"] == null || !Session["userRight"].ToString().Equals("1")) { Response.Write(" <script language=\"javascript\"> alert(\"对不起,你无此权限。请返回首页登录。\");window.location.href='Default.aspx'</script> "); } else { this.Master.pnlLoginDoneState.Visible = true; this.Master.pnlLoginState.Visible = false; this.Master.lblUserNameState.Text = Session["userName"].ToString(); } if (Session["consultID"] != null) { strSqlCmd = "select * from consult where consultID = '" + Session["consultID"].ToString() + "'"; SqlDataReader sqlDR = DatabaseOperating.sqlDataReaderRead(strSqlCmd); lblConsultTitle.Text = sqlDR["consultTitle"].ToString(); lblConsultID.Text = Session["consultID"].ToString(); lblConsultDate.Text = sqlDR["consultDate"].ToString(); txtConsultContent.Text = sqlDR["consultContent"].ToString(); txtConsultAnswer.Enabled = true; sqlDR.Close(); } strSqlCmd = "select * from consult"; strTblName = "consult"; DS = DatabaseOperating.fillDataSet(strSqlCmd, strTblName); for (int i = 0; i < DS.Tables["consult"].Rows.Count; i++) { if (DS.Tables["consult"].Rows[i][2].ToString().Equals("0")) { DS.Tables["consult"].Rows[i][2] = (string)"公开"; } else { DS.Tables["consult"].Rows[i][2] = (string)"私有"; } if (DS.Tables["consult"].Rows[i][7].ToString().Equals("1"))//Rows[i][7]是“7”还是别的什么要看原始数据表里是第几列 { DS.Tables["consult"].Rows[i][7] = (string)"已回答"; } else { DS.Tables["consult"].Rows[i][7] = (string)"未回答"; } } grdViwConsult.DataSource = DS; grdViwConsult.DataBind(); }
protected void btnConsultAnswerSubmit_Click(object sender, EventArgs e) { strSqlCmd = "update consult set consultAnswer = '" + txtConsultAnswer.Text + "',consultAnswered = '1' where consultID = '" + lblConsultID.Text + "'"; DatabaseOperating.sqlCmdInsertDeleteUpdate(strSqlCmd); Response.Write("<script>alert('回答成功')</script>"); Page_Load(sender, e); }
protected void Page_Load(object sender, EventArgs e) { if (Session["userName"] == null) { this.Master.pnlLoginDoneState.Visible = false; this.Master.pnlLoginState.Visible = true; } else { this.Master.lblUserNameState.Text = Session["userName"].ToString(); this.Master.pnlLoginDoneState.Visible = true; this.Master.pnlLoginState.Visible = false; } strSqlCmd = "select * from fertilizer"; strTblName = "fertilizer"; DS = DatabaseOperating.fillDataSet(strSqlCmd, strTblName); for (int i = 0; i < DS.Tables["fertilizer"].Rows.Count; i++) { if (DS.Tables["fertilizer"].Rows[i][2].ToString().Equals("0")) { DS.Tables["fertilizer"].Rows[i][2] = (string)"否"; } else { DS.Tables["fertilizer"].Rows[i][2] = (string)"是"; } if (DS.Tables["fertilizer"].Rows[i][3].ToString().Equals("0")) { DS.Tables["fertilizer"].Rows[i][3] = (string)"否"; } else { DS.Tables["fertilizer"].Rows[i][3] = (string)"是"; } if (DS.Tables["fertilizer"].Rows[i][4].ToString().Equals("0")) { DS.Tables["fertilizer"].Rows[i][4] = (string)"否"; } else { DS.Tables["fertilizer"].Rows[i][4] = (string)"是"; } } grdViwFertilizer.DataSource = DS; grdViwFertilizer.DataBind(); }
protected void btnConsultDelete_Click(object sender, EventArgs e) { Button btnConsultID = (Button)sender; string strSqlCmd = "delete from consult where consultID = '" + btnConsultID.CommandArgument.ToString() + "'"; DatabaseOperating.sqlCmdInsertDeleteUpdate(strSqlCmd); Response.Write("<script>alert('删除成功')</script>"); Page_Load(sender, e); }
protected void btnLinkModify_Click(object sender, EventArgs e) { btnLinkModifyAddSubmit.Text = "修改"; Button btnLinkModify = (Button)sender; strSqlCmd = "select * from links where linkID = '" + btnLinkModify.CommandArgument.ToString() + "' order by linkID"; sqlDR = DatabaseOperating.sqlDataReaderRead(strSqlCmd); lblLinkID.Text = btnLinkModify.CommandArgument.ToString(); txtLinkURL.Text = sqlDR["linkURL"].ToString(); txtLinkName.Text = sqlDR["linkName"].ToString(); txtLinkContent.Text = sqlDR["linkContent"].ToString(); }
protected void btnSearchFertilizer_Click(object sender, EventArgs e) { grdViwConsult.Visible = false; grdViwDye.Visible = false; grdViwFertilizer.Visible = false; grdViwNews.Visible = false; grdViwUsers.Visible = false; if (radBtnSearchFertilizerID.Checked) { strSqlCmd = "select * from fertilizer where fertilizerID = '" + txtKeyword.Text + "'"; } else { strSqlCmd = "select * from fertilizer where fertilizerName like '%" + txtKeyword.Text + "%'"; } DS = DatabaseOperating.fillDataSet(strSqlCmd, "searchResultFertilizer"); for (int i = 0; i < DS.Tables["fertilizer"].Rows.Count; i++) { if (DS.Tables["fertilizer"].Rows[i][2].ToString().Equals("0")) { DS.Tables["fertilizer"].Rows[i][2] = (string)"否"; } else { DS.Tables["fertilizer"].Rows[i][2] = (string)"是"; } if (DS.Tables["fertilizer"].Rows[i][3].ToString().Equals("0")) { DS.Tables["fertilizer"].Rows[i][3] = (string)"否"; } else { DS.Tables["fertilizer"].Rows[i][3] = (string)"是"; } if (DS.Tables["fertilizer"].Rows[i][4].ToString().Equals("0")) { DS.Tables["fertilizer"].Rows[i][4] = (string)"否"; } else { DS.Tables["fertilizer"].Rows[i][4] = (string)"是"; } } grdViwFertilizer.DataSource = DS; grdViwFertilizer.DataBind(); grdViwFertilizer.Visible = true; }
protected void btnFertilizerModify_Click(object sender, EventArgs e) { btnFertilizerAddModify.Text = "修改"; Button btnFertilizerModify = (Button)sender; string strFertilizerID = btnFertilizerModify.CommandArgument.ToString(); strSqlCmd = "select * from fertilizer where fertilizerID = '" + strFertilizerID + "'"; SqlDataReader sqlDR = DatabaseOperating.sqlDataReaderRead(strSqlCmd); lblFertilizerID.Text = strFertilizerID; txtFertilizerName.Text = sqlDR["fertilizerName"].ToString(); if (sqlDR["fertilizerCompound"].ToString().Equals("0")) { radBtnFertilizerCompound0.Checked = true; radBtnFertilizerCompound1.Checked = false; } else { radBtnFertilizerCompound0.Checked = false; radBtnFertilizerCompound1.Checked = true; } if (sqlDR["fertilizerOrganic"].ToString().Equals("0")) { radBtnFertilizerOrganic0.Checked = true; radBtnFertilizerOrganic1.Checked = false; } else { radBtnFertilizerOrganic0.Checked = false; radBtnFertilizerOrganic1.Checked = true; } if (sqlDR["fertilizerAfter"].ToString().Equals("0")) { radBtnFertilizerAfter0.Checked = true; radBtnFertilizerAfter1.Checked = false; } else { radBtnFertilizerAfter0.Checked = false; radBtnFertilizerAfter1.Checked = true; } txtFertilizerDilute.Text = sqlDR["fertilizerDilute"].ToString(); txtFertilizerIngredient.Text = sqlDR["fertilizerIngredient"].ToString(); drpDwnLstFertilizerSoil.SelectedValue = sqlDR["fertilizerSoil"].ToString(); txtFertilizerFrequency.Text = sqlDR["fertilizerFrequency"].ToString(); txtFertilizerStock.Text = sqlDR["fertilizerStock"].ToString(); }
}// 新建SqlDataReader并read数据 public static void sqlCmdInsertDeleteUpdate(string strSqlCmd) { try { SqlConnection sqlCnn = DatabaseOperating.creatDBConnect(); SqlCommand sqlCmd = new SqlCommand(strSqlCmd, sqlCnn); sqlCmd.ExecuteNonQuery(); sqlCnn.Close(); } catch { } return; }// 数据库增,删,改命令
protected void btnConsultAnswer_Click(object sender, EventArgs e) { Button btnConsultAnswer = (Button)sender; strConsultID = btnConsultAnswer.CommandArgument.ToString(); strSqlCmd = "select * from consult where consultID = '" + strConsultID + "'"; SqlDataReader sqlDR = DatabaseOperating.sqlDataReaderRead(strSqlCmd); lblConsultTitle.Text = sqlDR["consultTitle"].ToString(); lblConsultID.Text = btnConsultAnswer.CommandArgument.ToString(); lblConsultDate.Text = sqlDR["consultDate"].ToString(); txtConsultContent.Text = sqlDR["consultContent"].ToString(); txtConsultAnswer.Enabled = true; }
protected void btnConsultView_Click(object sender, EventArgs e) { Button btnConsultID = (Button)sender; strSqlCmd = "select * from consult where consultID = '" + btnConsultID.CommandArgument.ToString() + "'"; sqlDR = DatabaseOperating.sqlDataReaderRead(strSqlCmd); pnlConsultView.Visible = true; lblConsultTitle.Text = sqlDR["consultTitle"].ToString(); lblConsultSort.Text = sqlDR["consultSort"].ToString(); lblConsultDate.Text = sqlDR["consultDate"].ToString(); txtConsultContent.Text = sqlDR["consultContent"].ToString(); txtConsultAnswer.Text = sqlDR["consultAnswer"].ToString(); }
protected void btnModify_Click(object sender, EventArgs e) { sqlCnn = DatabaseOperating.creatDBConnect(); string strResult; if (txtUserOldPassword.Text.ToString().Equals("")) { lblErrorMessage.Text = "请输入旧密码。"; } else { try { string strSqlCmdLoginCheck = "select count(*) from users where userName = '******'and userPassword = '******'"; SqlCommand sqlCmd = new SqlCommand(strSqlCmdLoginCheck, sqlCnn); strResult = sqlCmd.ExecuteScalar().ToString(); if (strResult.Equals("1")) { if (txtUserNewPassword.Text.Equals("") || txtUserNewPasswordConfig.Text.Equals("")) { lblErrorMessage.Text = "新密码和新密码确认不能为空。"; } else if (!txtUserNewPassword.Text.Equals(txtUserNewPasswordConfig.Text)) { lblErrorMessage.Text = "两次输入的新密码不一致。"; } else { string strSqlCmd = "update users set userPassword = '******' ,userZone = '" + DrpDwnLstZone.SelectedItem.Text + " ' where userName = '******'"; DatabaseOperating.sqlCmdInsertDeleteUpdate(strSqlCmd); Response.Write("<script language=javascript>alert('恭喜您,修改成功!')</script>"); Response.Write("<script language=javascript>window.location.href='Login_Register_Done.aspx'</script>"); } } else { lblErrorMessage.Text = "旧密码错误,请重新输入。"; } } catch {} } }
protected void lnkBtnNewsTitle_Click(object sender, EventArgs e) { LinkButton lnkBtnNewsTitle = (LinkButton)sender; string strNewsTitle = lnkBtnNewsTitle.Text; strSqlCmd = "select * from news where newsTitle = '" + strNewsTitle + "'"; sqlDR = DatabaseOperating.sqlDataReaderRead(strSqlCmd); lblNewsTitle.Text = strNewsTitle; lblNewsDate.Text = sqlDR["newsDate"].ToString(); txtNewsContent.Text = sqlDR["newsContent"].ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["userRight"] == null) { Response.Write(" <script language=\"javascript\"> alert(\"对不起,你无此权限。请返回首页登录。\");window.location.href='Default.aspx'</script> "); } else { this.Master.pnlLoginDoneState.Visible = true; this.Master.pnlLoginState.Visible = false; this.Master.lblUserNameState.Text = Session["userName"].ToString(); strSqlCmd = "select * from consult where userID = '" + Session["userID"].ToString() + "'"; string strTblName = "consultResult"; DataSet DS = DatabaseOperating.fillDataSet(strSqlCmd, strTblName); for (int i = 0; i < DS.Tables["consultResult"].Rows.Count; i++) { if (DS.Tables["consultResult"].Rows[i][2].ToString() == "0") { DS.Tables["consultResult"].Rows[i][2] = (string)"公开"; } else { DS.Tables["consultResult"].Rows[i][2] = (string)"私有"; } } for (int i = 0; i < DS.Tables["consultResult"].Rows.Count; i++) { if (DS.Tables["consultResult"].Rows[i][7].ToString() == "0") { DS.Tables["consultResult"].Rows[i][7] = (string)"未回答"; } else { DS.Tables["consultResult"].Rows[i][7] = (string)"已回答"; } } grdViwConsultResult.DataSource = DS; grdViwConsultResult.DataBind(); } }
protected void btnDyeModify_Click(object sender, EventArgs e) { btnDyeAddModify.Text = "修改"; Button btnDyeModify = (Button)sender; string strDyeID = btnDyeModify.CommandArgument.ToString(); strSqlCmd = "select * from dye where dyeID = '" + strDyeID + "'"; SqlDataReader sqlDR = DatabaseOperating.sqlDataReaderRead(strSqlCmd); lblDyeID.Text = strDyeID; txtDyeName.Text = sqlDR["dyeName"].ToString(); txtDyeColor.Text = sqlDR["dyeColor"].ToString(); txtDyeStock.Text = sqlDR["dyeStock"].ToString(); }
protected void btnLinkModifyAddSubmit_Click(object sender, EventArgs e) { if (btnLinkModifyAddSubmit.Text.Equals("修改")) { strSqlCmd = "update links set linkName = '" + txtLinkName.Text + "', linkURL = '" + txtLinkURL.Text + "', linkContent = '" + txtLinkContent.Text + "' where linkID = '" + lblLinkID.Text + "'"; DatabaseOperating.sqlCmdInsertDeleteUpdate(strSqlCmd); lblLinkID.Text = ""; txtLinkURL.Text = "http://"; txtLinkName.Text = ""; txtLinkContent.Text = ""; this.Page_Load(sender, e); } else { SqlConnection sqlCnn = DatabaseOperating.creatDBConnect(); SqlCommand sqlCmd = new SqlCommand("linkInsert", sqlCnn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@linkURl", SqlDbType.VarChar, 200); sqlCmd.Parameters["@linkURL"].Value = txtLinkURL.Text; sqlCmd.Parameters.Add("@linkName", SqlDbType.VarChar, 20); sqlCmd.Parameters["@linkName"].Value = txtLinkName.Text; sqlCmd.Parameters.Add("@linkContent", SqlDbType.VarChar, 200); sqlCmd.Parameters["@linkContent"].Value = txtLinkContent.Text; sqlCmd.ExecuteNonQuery(); sqlCnn.Close(); //strSqlCmd = "insert into links (linkURL,linkName,linkContent) values ('" + txtLinkURL.Text + "','" + txtLinkName.Text + "','" + txtLinkContent.Text + "')"; //DatabaseOperating.sqlCmdInsertDeleteUpdate(strSqlCmd); Response.Write("<script>alert('添加成功')</script>"); lblLinkID.Text = ""; txtLinkURL.Text = "http://"; txtLinkName.Text = ""; txtLinkContent.Text = ""; this.Page_Load(sender, e); } Response.Write("<script>alert('操作成功')</script>"); }
protected void btnUserAdd_Click(object sender, EventArgs e) { strSqlCmd = "insert into users(userName, userPassword, userZone, userEmail, userRegisterDate, userRight) values( " + "'" + txtUserName.Text.ToString() + "'" + "," + "'" + txtUserPassword.Text.ToString() + "'" + "," + "'" + DrpDwnLstUserZone.SelectedValue.ToString() + "'" + "," + "'" + txtUserEmail.Text.ToString() + "'" + "," + "'" + DateTime.Today.ToShortDateString().ToString() + "'" + "," + "'" + drpDwnLstUserRight.SelectedValue.ToString() + "'" + ")"; DatabaseOperating.sqlCmdInsertDeleteUpdate(strSqlCmd); Response.Write(" <script language=\"javascript\"> alert(\"注册成功\")</script> "); }
protected void btnUserRightModify_Click(object sender, EventArgs e) { Button btnUserRightModify = (Button)sender; string strUserID = btnUserRightModify.CommandName.ToString(); string strUserRight = btnUserRightModify.CommandArgument.ToString(); if (strUserRight.Equals("用户")) { strSqlCmd = "update users set userRight = '1' where userID = '" + strUserID + "'"; DatabaseOperating.sqlCmdInsertDeleteUpdate(strSqlCmd); Response.Write("<script language='javascript'>alert('修改成功!')</script>"); Page_Load(sender, e); } else { Response.Write("<script language='javascript'>alert('此用户已为管理员')</script>"); } }
protected void btnNewsModify_Click(object sender, EventArgs e) { txtNewsTitle.ReadOnly = false; txtNewsContent.ReadOnly = false; btnNewsModifyAddSubmit.Text = "修改"; Button btnNewsAnswer = (Button)sender; strNewsID = btnNewsAnswer.CommandArgument.ToString(); strSqlCmd = "select * from news where newsID = '" + strNewsID + "'"; sqlDR = DatabaseOperating.sqlDataReaderRead(strSqlCmd); txtNewsTitle.Text = sqlDR["newsTitle"].ToString(); lblNewsID.Text = btnNewsAnswer.CommandArgument.ToString(); lblNewsDate.Text = sqlDR["newsDate"].ToString(); txtNewsContent.Text = sqlDR["newsContent"].ToString(); }
protected void btnNewsModifyAddSubmit_Click(object sender, EventArgs e) { if (btnNewsModifyAddSubmit.Text.Equals("添加")) { strSqlCmd = "insert into news(newsTitle,newsDate,newsContent) values('" + txtNewsTitle.Text + "','" + DateTime.Today.ToShortDateString().ToString() + "','" + txtNewsContent.Text + "')"; DatabaseOperating.sqlCmdInsertDeleteUpdate(strSqlCmd); Response.Write("<script>alert('添加成功')</script>"); } else { strSqlCmd = "update news set newsTitle = '" + txtNewsTitle.Text + "',newsContent = '" + txtNewsContent.Text + "' where newsID = '" + lblNewsID.Text + "'"; DatabaseOperating.sqlCmdInsertDeleteUpdate(strSqlCmd); Response.Write("<script>alert('编辑成功')</script>"); } Page_Load(sender, e); }
}// 创建数据库连接 public static DataSet fillDataSet(string strSqlCmd, string strTblName) { try { SqlConnection sqlCnn = DatabaseOperating.creatDBConnect(); SqlDataAdapter sqlDA = new SqlDataAdapter(strSqlCmd, sqlCnn); DataSet DS = new DataSet(); sqlDA.Fill(DS, strTblName); sqlCnn.Close(); return(DS); } catch { } return(null); }// 新建DataSet并填充
protected void Page_Load(object sender, EventArgs e) { if (Session["userRight"] == null || !Session["userRight"].ToString().Equals("1")) { Response.Write(" <script language=\"javascript\"> alert(\"对不起,你无此权限。请返回首页登录。\");window.location.href='Default.aspx'</script> "); } else { this.Master.pnlLoginDoneState.Visible = true; this.Master.pnlLoginState.Visible = false; this.Master.lblUserNameState.Text = Session["userName"].ToString(); } strSqlCmd = "select * from links"; DS = DatabaseOperating.fillDataSet(strSqlCmd, "links"); grdViwLinks.DataSource = DS; grdViwLinks.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["userRight"] == null || !Session["userRight"].ToString().Equals("1")) { Response.Write(" <script language=\"javascript\"> alert(\"对不起,你无此权限。请返回首页登录。\");window.location.href='Default.aspx'</script> "); } else { this.Master.pnlLoginDoneState.Visible = true; this.Master.pnlLoginState.Visible = false; this.Master.lblUserNameState.Text = Session["userName"].ToString(); } if (Session["dyeID"] != null) { btnDyeAddModify.Text = "修改"; strSqlCmd = "select * from dye where dyeID = '" + Session["dyeID"].ToString() + "'"; SqlDataReader sqlDR = DatabaseOperating.sqlDataReaderRead(strSqlCmd); lblDyeID.Text = Session["dyeID"].ToString(); txtDyeName.Text = sqlDR["dyeName"].ToString(); txtDyeColor.Text = sqlDR["dyeColor"].ToString(); txtDyeStock.Text = sqlDR["dyeStock"].ToString(); sqlDR.Close(); } strSqlCmd = "select * from dye"; strTblName = "dye"; DS = DatabaseOperating.fillDataSet(strSqlCmd, strTblName); grdViwDye.DataSource = DS; grdViwDye.DataBind(); }
protected void btnConsultSubmit_Click(object sender, EventArgs e) { string strConsultSort; string strConsultPrivate; if (radBtnConsultSortDye.Checked) { strConsultSort = "染料"; } else { strConsultSort = "肥料"; } if (radBtnConsultPrivate0.Checked) { strConsultPrivate = "0"; } else { strConsultPrivate = "1"; } sqlCnn = DatabaseOperating.creatDBConnect(); strSqlCmd = "insert into consult(consultTitle,consultSort,consultPrivate,consultDate,consultContent,consultAnswered,userID) values('" + txtConsultTitle.Text + "','" + strConsultSort + "','" + strConsultPrivate + "','" + DateTime.Today.ToShortDateString().ToString() + "','" + txtConsultContent.Text + "','" + "0" + "','" + Session["userID"].ToString() + "')"; sqlCmd = new SqlCommand(strSqlCmd, sqlCnn); sqlCmd.ExecuteNonQuery(); Response.Write("<script language=javascript>alert('提问成功!')</script>"); sqlCnn.Close(); }
protected void btnSearchUser_Click(object sender, EventArgs e) { grdViwConsult.Visible = false; grdViwDye.Visible = false; grdViwFertilizer.Visible = false; grdViwNews.Visible = false; grdViwUsers.Visible = false; if (radBtnSearchConsultUserID.Checked) { strSqlCmd = "select * from users where userID = '" + txtKeyword.Text + "'"; } else if (RadBtnSearchUserName.Checked) { strSqlCmd = "select * from users where userName = '******'"; } else { strSqlCmd = "select * from users where userEmail = '" + txtKeyword.Text + "'"; } DS = DatabaseOperating.fillDataSet(strSqlCmd, "searchResultUsers"); for (int i = 0; i < DS.Tables["searchResultUsers"].Rows.Count; i++) { if (DS.Tables["searchResultUsers"].Rows[i][6].ToString().Equals("0")) { DS.Tables["searchResultUsers"].Rows[i][6] = (string)"用户"; } else { DS.Tables["searchResultUsers"].Rows[i][6] = (string)"管理员"; } } grdViwUsers.DataSource = DS; grdViwUsers.DataBind(); grdViwUsers.Visible = true; }
protected void lnkBtnLogin_Click(object sender, EventArgs e) { lblErrorMessage.Text = ""; if (txtUserName.Text.ToString().Equals("") || txtUserPassword.Text.ToString().Equals("")) { lblErrorMessage.Text = "用户名及密码不能为空。"; } else { try { string strSqlCmd = "select * from users where userName = '******'and userPassword = '******'"; sqlDR = DatabaseOperating.sqlDataReaderRead(strSqlCmd); if (sqlDR != null) { Session["userName"] = txtUserName.Text; Session["userRight"] = sqlDR["userRight"].ToString(); Session["userID"] = sqlDR["userID"].ToString(); if (sqlDR["userRight"].ToString().Equals("0")) { Response.Redirect("Login_Register_Done.aspx"); } else { Response.Redirect("management.aspx"); } } else { lblErrorMessage.Text = "登录失败,请确认用户名和密码正确。"; } } catch {} } }
protected void Page_Load(object sender, EventArgs e) { if (Session["userRight"] == null || !Session["userRight"].ToString().Equals("1")) { Response.Write(" <script language=\"javascript\"> alert(\"对不起,你无此权限。请返回首页登录。\");window.location.href='Default.aspx'</script> "); } else { this.Master.pnlLoginDoneState.Visible = true; this.Master.pnlLoginState.Visible = false; this.Master.lblUserNameState.Text = Session["userName"].ToString(); } //btnUserAdd.Attributes.Add("onclick", "return confirm('确定添加用户吗?')"); strSqlCmd = "select * from users"; DataSet DSUsers = DatabaseOperating.fillDataSet(strSqlCmd, "users"); for (int i = 0; i < DSUsers.Tables["users"].Rows.Count; i++) { if (DSUsers.Tables["users"].Rows[i][6].ToString().Equals("0")) { DSUsers.Tables["users"].Rows[i][6] = (string)"用户"; } else { DSUsers.Tables["users"].Rows[i][6] = (string)"管理员"; } } grdViwUsers.DataSource = DSUsers; grdViwUsers.DataBind(); }