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