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();
}
