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 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 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 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 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 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 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 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(); }
protected void Page_Load(object sender, EventArgs e) { btnLogoff.Attributes.Add("onclick", "return confirm('你要执行这个操作吗?')"); #region 取得links表中的数据 try { strSqlCmd = "select * from links"; // 查询语字符串 DS = DatabaseOperating.fillDataSet(strSqlCmd, "links"); grdViwLinks.DataSource = DS; grdViwLinks.DataBind(); } catch (Exception excpLinksError) { lblErrorMessage.Text = excpLinksError.Message.ToString(); } #endregion #region 取得news表中的数据 try { strSqlCmd = "select * from news"; DS = DatabaseOperating.fillDataSet(strSqlCmd, "news"); grdViwNews.DataSource = DS; grdViwNews.DataBind(); } catch (Exception excpNewsError) { lblErrorMessage.Text = excpNewsError.Message.ToString(); lblErrorMessage.Text = ""; } #endregion }
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["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 dye "; strTblName = "dye"; DS = DatabaseOperating.fillDataSet(strSqlCmd, strTblName); grdViwDye.DataSource = DS; grdViwDye.DataBind(); }
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(); } if (Session["keyword"] != null) { lblSearchNoResult.Visible = false; if (Session["inforSort"].ToString().Equals("infor")) { if (Session["goodsSort"].ToString().Equals("dye")) { strSqlCmd = "select * from dye where dyeName like '%" + Session["keyword"].ToString() + "%'"; DS = DatabaseOperating.fillDataSet(strSqlCmd, "searchResult"); if (DS.Tables["searchResult"].Rows.Count > 0) { grdViwDye.DataSource = DS; grdViwDye.DataBind(); grdViwDye.Visible = true; } else { lblSearchNoResult.Visible = true; lblSearchNoResult.Text = "对不起,没有任何记录。"; } } else { strSqlCmd = "select * from fertilizer where fertilizerName like '%" + Session["keyword"].ToString() + "%'"; DS = DatabaseOperating.fillDataSet(strSqlCmd, "searchResult"); if (DS.Tables["searchResult"].Rows.Count > 0) { grdViwDye.DataSource = DS; grdViwDye.DataBind(); grdViwDye.Visible = true; } else { lblSearchNoResult.Visible = true; lblSearchNoResult.Text = "对不起,没有任何记录。"; } } } else { if (Session["goodsSort"].ToString().Equals("dye")) { strSqlCmd = "select * from consult where consultSort = '染料' and consultPrivate = '0' and consultContent like '%" + Session["keyword"].ToString() + "%'or consultTitle like '%" + Session["keyword"].ToString() + "%'or consultAnswer like '%" + Session["keyword"].ToString() + "%'"; DS = DatabaseOperating.fillDataSet(strSqlCmd, "searchResult"); if (DS.Tables["searchResult"].Rows.Count > 0) { grdViwDye.DataSource = DS; grdViwDye.DataBind(); grdViwDye.Visible = true; } else { lblSearchNoResult.Visible = true; lblSearchNoResult.Text = "对不起,没有任何记录。"; } } else { strSqlCmd = "select * from consult where consultSort = '肥料' and consultPrivate = '0' and consultContent like '%" + Session["keyword"].ToString() + "%'or consultTitle like '%" + Session["keyword"].ToString() + "%'or consultAnswer like '%" + Session["keyword"].ToString() + "%'"; DS = DatabaseOperating.fillDataSet(strSqlCmd, "searchResult"); if (DS.Tables["searchResult"].Rows.Count > 0) { grdViwDye.DataSource = DS; grdViwDye.DataBind(); grdViwDye.Visible = true; } else { lblSearchNoResult.Visible = true; lblSearchNoResult.Text = "对不起,没有任何记录。"; } } } } }
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(); }