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 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 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(); }
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 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 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 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 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 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 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(); } if (Session["newsID"] != null) { txtNewsTitle.ReadOnly = false; txtNewsContent.ReadOnly = false; btnNewsModifyAddSubmit.Text = "修改"; strSqlCmd = "select * from news where newsID = '" + Session["newsID"].ToString() + "'"; sqlDR = DatabaseOperating.sqlDataReaderRead(strSqlCmd); txtNewsTitle.Text = sqlDR["newsTitle"].ToString(); lblNewsID.Text = Session["newsID"].ToString(); lblNewsDate.Text = sqlDR["newsDate"].ToString(); txtNewsContent.Text = sqlDR["newsContent"].ToString(); sqlDR.Close(); } strSqlCmd = "select * from news"; DS = DatabaseOperating.fillDataSet(strSqlCmd, "news"); grdViwNews.DataSource = DS; grdViwNews.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["fertilizerID"] != null) { btnFertilizerAddModify.Text = "修改"; strSqlCmd = "select * from fertilizer where fertilizerID = '" + Session["fertilizerID"].ToString() + "'"; SqlDataReader sqlDR = DatabaseOperating.sqlDataReaderRead(strSqlCmd); lblFertilizerID.Text = Session["fertilizerID"].ToString(); 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(); sqlDR.Close(); } strSqlCmd = "select * from fertilizer"; DS = DatabaseOperating.fillDataSet(strSqlCmd, "fertilizer"); 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 btnRegister_Click(object sender, EventArgs e) { SqlConnection sqlCnn = DatabaseOperating.creatDBConnect(); Regex regUserName = new Regex(@"^\w+$"); // 只能输入由数字、26个英文字母或者下划线组成的字符串 Regex regUserpassword = new Regex(@"^[a-zA-Z]\w{5,17}$"); // 以字母开头,长度在6~18之间,只能包含字符、数字和下划线 Regex regMail = new Regex(@"\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"); // 验证Email地址格式 strSqlCmd = "select count(*) from users where userName = '******'"; // 验证是否已存在此用户 sqlCmd = new SqlCommand(strSqlCmd, sqlCnn); string strResultUserNameCheck = sqlCmd.ExecuteScalar().ToString(); strSqlCmd = "select count(*) from users where userEmail = '" + txtUserEmail.Text.ToString() + "'"; // 验证是否已有用户使用此邮箱 sqlCmd = new SqlCommand(strSqlCmd, sqlCnn); string strResultUserEmailCheck = sqlCmd.ExecuteScalar().ToString(); #region 验证注册信息 if (txtUserName.Text.Equals("")) { lblErrorMessage.Text = "用户名不能为空。"; } else if (!regUserName.IsMatch(txtUserName.Text.ToString())) { lblErrorMessage.Text = "用户名格式不正确。只能输入由数字、26个英文字母或者下划线组成的字符串"; } else if (strResultUserNameCheck == "1") { lblErrorMessage.Text = "此用户名已被注册,请您另择其他。"; } else if (txtUserPassword.Text.Equals("")) { lblErrorMessage.Text = "密码不能为空。"; } else if (!regUserpassword.IsMatch(txtUserPassword.Text.ToString())) { lblErrorMessage.Text = "密码格式不正确。只能以字母开头,长度在6~18之间,只能包含字符、数字和下划线"; } else if (txtUserPasswordConfig.Text.Equals("")) { lblErrorMessage.Text = "密码确认不能为空。"; } else if (!txtUserPassword.Text.ToString().Equals(txtUserPasswordConfig.Text.ToString())) { lblErrorMessage.Text = "两次输入的密码不一致,请重新输入。"; } else if (txtUserEmail.Text.Equals("")) { lblErrorMessage.Text = "邮件地址不能为空。"; } else if (!regMail.IsMatch(txtUserEmail.Text.ToString())) { lblErrorMessage.Text = "邮件格式不正确。"; } else if (strResultUserEmailCheck == "1") { lblErrorMessage.Text = "此邮箱已被注册,请您另择其他。"; } #endregion #region 添加新用户 else { strSqlCmd = "insert into users(userName, userPassword, userZone, userEmail, userRegisterDate, userRight) values( " + "'" + txtUserName.Text.ToString() + "'" + "," + "'" + txtUserPassword.Text.ToString() + "'" + "," + "'" + DrpDwnLstZone.SelectedItem.Text.ToString() + "'" + "," + "'" + txtUserEmail.Text.ToString() + "'" + "," + "'" + DateTime.Today.ToShortDateString().ToString() + "'" + "," + "'" + "0" + "'" + ")"; DatabaseOperating.sqlCmdInsertDeleteUpdate(strSqlCmd); string strUserID; strSqlCmd = "select userID from users where userName = '******'"; sqlDR = DatabaseOperating.sqlDataReaderRead(strSqlCmd); strUserID = sqlDR["userID"].ToString(); Session["userName"] = txtUserName.Text; Session["userRight"] = "0"; Session["userID"] = strUserID; Response.Write(" <script language=\"javascript\"> alert(\"注册成功\");window.location.href='Login_Register_Done.aspx'</script> "); } #endregion sqlCnn.Close(); }