/// <summary>
/// 读取数据库前的回调方法
/// </summary>
/// <param name="udata"></param>
private void CreateSelectUserCmd(ref MySqlCmd.MySqlCmd.MySqlContext udata)
{
udata.context = "SELECT * FROM `" + this.DropDownList.SelectedValue + "` WHERE `账号`=?account and `密码`=?pwd LIMIT 1";
udata.comm = new MySqlCommand(udata.context, udata.conn);
udata.comm.Parameters.AddWithValue("account", this.NameTextBox.Text.Trim());
udata.comm.Parameters.AddWithValue("pwd", this.PwdTextBox.Text.Trim());
}
private void AfterExecuteCmd(MySqlCmd.MySqlCmd.MySqlContext udata)
{
if (udata.context.IndexOf("Error: ") >= 0)
{
ClientScript.RegisterStartupScript(Page.GetType(), "error", "<script>alert(\"You have an error!\")</script>");
}
return;
}
private void AddUserData()
{
conn = MySqlCmd.MySqlCmd.Connection(conn_str);
MySqlCmd.MySqlCmd.MySqlContext udata = new MySqlCmd.MySqlCmd.MySqlContext();
udata.conn = conn;
udata.status = MySqlCmd.MySqlRequest.INSERT;
udata.create_cmd = CreateCmd;
udata.callback = AfterExecuteCmd;
udata.res = -1;
MySqlCmd.MySqlCmd.SetMySqlCommand(ref udata);
}
private void UpdateData(int row_index)
{
conn = MySqlCmd.MySqlCmd.Connection(conn_str);
MySqlCmd.MySqlCmd.MySqlContext udata = new MySqlCmd.MySqlCmd.MySqlContext();
udata.conn = conn;
udata.status = MySqlCmd.MySqlRequest.UPDATE;
udata.res = -1;
udata.create_cmd = CreateCmd;
udata.callback = AfterExecuteCmd;
MySqlCmd.MySqlCmd.SetMySqlCommand(ref udata);
}
// 删除当前行
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
conn = MySqlCmd.MySqlCmd.Connection(conn_str);
MySqlCmd.MySqlCmd.MySqlContext udata = new MySqlCmd.MySqlCmd.MySqlContext();
udata.conn = conn;
udata.status = MySqlCmd.MySqlRequest.DELETE;
udata.create_cmd = CreateCmd;
udata.callback = AfterExecuteCmd;
udata.res = e.RowIndex;
MySqlCmd.MySqlCmd.SetMySqlCommand(ref udata);
FormViewBindData();
}
/// <summary>
/// 登录按钮事件,使用MySqlContext结构保存数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SubmitButton_OnClick(object sender, EventArgs e)
{
if (this.NameTextBox.Text == "" || this.PwdTextBox.Text == "")
{
ClientScript.RegisterStartupScript(this.Page.GetType(), "InfoSubmit", "<script type=\"text/javascript\">alert(\"账号或密码不能为空!\");</script>");
return;
}
MySqlConnection conn = MySqlCmd.MySqlCmd.Connection(conn_str);
MySqlCmd.MySqlCmd.MySqlContext udata = new MySqlCmd.MySqlCmd.MySqlContext();
udata.conn = conn;
udata.create_cmd = CreateSelectUserCmd;
udata.res = -1;
udata.status = MySqlCmd.MySqlRequest.SEARCH;
udata.callback = AfterSelect;
MySqlCmd.MySqlCmd.LoginCommand(ref udata);
}
/// <summary>
/// 读取数据库后的回调方法
/// </summary>
/// <param name="udata"></param>
private void AfterSelect(MySqlCmd.MySqlCmd.MySqlContext udata)
{
if (udata.res == 1)
{
Session["user_context"] = udata.context;
HttpCookie cookie = new HttpCookie("user");
cookie["log_act+?/"] = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(this.NameTextBox.Text.Trim(), "MD5").ToLower();
cookie["log_pwd+?/"] = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(this.PwdTextBox.Text.Trim(), "MD5").ToLower();
cookie.Expires.AddDays(7.0f);
Response.AppendCookie(cookie);
Response.Redirect("./OrderForm.aspx?compentence=+" + this.DropDownList.Text.Trim());
}
else
{
ClientScript.RegisterStartupScript(Page.GetType(), "NonData", "<script type=\"text/javascript\">alert(\"没有此账户!\")</script>");
return;
}
}
/// <summary>
/// 创建数据库操作字符串, 修改table_name使用不同的数据表
/// </summary>
/// <param name="udata">自定义数据</param>
private void CreateCmd(ref MySqlCmd.MySqlCmd.MySqlContext udata)
{
string table_name = "ORDER_FORM";
switch (udata.status)
{
case MySqlCmd.MySqlRequest.INSERT: {
string add_str = "INSERT INTO `" + table_name + "` (`";
for (int i = 1; i < this.GridView1.HeaderRow.Cells.Count; i++)
{
if (i < this.GridView1.Rows[0].Cells.Count - 1)
{
add_str += this.GridView1.HeaderRow.Cells[i].Text.Trim() + "`,`";
}
else
{
add_str += this.GridView1.HeaderRow.Cells[i].Text.Trim() + "`) VALUES (\"";
}
}
for (int i = 1; i < this.GridView1.HeaderRow.Cells.Count; i++)
{
string details_text = ((TextBox)(this.GridView1.FooterRow.Cells[i].Controls[0])).Text.Trim();
if (i < this.GridView1.Rows[0].Cells.Count - 1)
{
if (i < 3 && details_text == "")
{
break;
}
add_str += details_text + "\",\"";
}
else
{
add_str += details_text + "\");";
}
}
udata.context = add_str;
break;
}
case MySqlCmd.MySqlRequest.DELETE: {
string delete_str = "DELETE FROM `" + table_name + "` WHERE `" + this.GridView1.HeaderRow.Cells[1].Text.Trim()
+ "`=\"" + this.GridView1.Rows[udata.res].Cells[1].Text.Trim() + "\";";
udata.context = delete_str;
break;
}
case MySqlCmd.MySqlRequest.UPDATE: {
string update_str = "UPDATE `" + table_name + "` SET `";
for (int i = 1; i < this.GridView1.Rows[0].Cells.Count; i++)
{
if (i < this.GridView1.Rows[0].Cells.Count - 1)
{
update_str += this.GridView1.HeaderRow.Cells[i].Text.Trim() + "`=\""
+ ((TextBox)(this.GridView1.Rows[this.GridView1.EditIndex].Cells[i].Controls[0])).Text + "\",`";
}
else
{
update_str += this.GridView1.HeaderRow.Cells[i].Text.Trim() + "`=\""
+ ((TextBox)(this.GridView1.Rows[this.GridView1.EditIndex].Cells[i].Controls[0])).Text + "\"";
}
}
update_str += " WHERE `" + this.GridView1.HeaderRow.Cells[1].Text.Trim() + "`=\""
+ ((TextBox)(this.GridView1.Rows[this.GridView1.EditIndex].Cells[1].Controls[0])).Text + "\";";
udata.context = update_str;
break;
}
}
}
