/// <summary>
/// 返回响应结果
/// </summary>
/// <param name="context">Http数据报对象</param>
/// <param name="udata">数据库对象</param>
public void ResultResponse(HttpContext context, MySqlCmd.MySqlContext udata)
{
if (udata.res != 0)
{
string name = GetName(udata.context);
string identify = CheckIdentity(udata.context);
int sequences = GetSequences(udata.context);
HttpCookie cookie = new HttpCookie("user_data");
cookie["name"] = user.uname;
cookie["identify"] = identify;
cookie.Expires.AddHours(1.0);
context.Response.AppendCookie(cookie);
PlatformManage.User._user.Account = user.uname;
PlatformManage.User._user.Name = name;
PlatformManage.User._user.Identify = identify;
PlatformManage.User._user.Sequence = sequences;
PlatformManage.User._user.SetSelectString();
var res = new { msg = "1", data = name };
ResponseToClient(context, res);
}
else
{
var res = new { msg = "0", data = "not exists" };
ResponseToClient(context, res);
}
}
private void create_cmd(ref MySqlCmd.MySqlContext udata)
{
udata.context = "UPDATE ORDER_FORM SET `PRELIMINARY_SURVEY"
+ "`=\"" + this.preliminary_survey.Value + "\", `WATER_ELECTRIC_TIME"
+ "`=\"" + this.water_electric_time.Value + "\" WHERE `SEQUENCES`=\""
+ this.sequences.Value + "\"";
}
private void create_cmd(ref MySqlCmd.MySqlContext udata)
{
udata.context = "UPDATE ORDER_FORM SET `CLOTHES_BOARD_RESERVE_TIME"
+ "`=\"" + this.clothes_board_reserve_time.Value
+ "\", `CLOTHES_BOARD_ORDER_TIME"
+ "`=\"" + this.clothes_board_order_time.Value
+ "\" WHERE `SEQUENCES`=\"" + this.sequences.Value + "\"";
}
private void create_cmd(ref MySqlCmd.MySqlContext udata)
{
udata.context = "UPDATE ORDER_FORM SET `WATERCHANNEL_WIRING"
+ "`=\"" + this.waterchannel_wiring.Value
+ "\", `HARDWARE_FITTING"
+ "`=\"" + this.hardware_fitting.Value
+ "\" WHERE `SEQUENCES`=\"" + this.sequences.Value + "\"";
}
private void create_cmd(ref MySqlCmd.MySqlContext udata)
{
udata.context = "UPDATE ORDER_FORM SET `CONTRACT_NUMBERS`=\"" + this.contract_numbers.Value
+ "\", `CONTRACT_AFFIRM"
+ "`=\"" + this.contract_affirm.Value
+ "\", `CONTRACT_AFFIRM_TIME`=\""
+ Database.convert_dataTime(DateTime.Now) + "\" WHERE `SEQUENCES`=\"" + this.sequences.Value + "\"";
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
MySqlCmd.MySqlContext input_udata = new MySqlCmd.MySqlContext();
input_udata.conn = MySqlCmd.Connection(WebConfigurationManager.ConnectionStrings["senshang_database_connection_string"].ToString());
input_udata.status = MySqlRequest.UPDATE;
input_udata.create_cmd = create_cmd;
MySqlCmd.SetMySqlCommand(ref input_udata);
FilledCurrentDataGrid();
}
private void create_cmd(ref MySqlCmd.MySqlContext udata)
{
//udata.context = "UPDATE ORDER_FORM SET `" + Database.convert_columns_name(this.real_install_time.ID)
// + "`=\"" + this.real_install_time.Value
// + "\", `" + Database.convert_columns_name(this.last_install_issue.ID)
// + "`=\"" + this.last_install_issue.Value
// + "\", `" + Database.convert_columns_name(this.comment.ID)
// + "`=\"" + this.comment.Value
// + "\" WHERE `序号`=\"" + this.number.Value + "\"";
}
/// <summary>
/// 此方法提供了一个统一的提交按钮的实现模板
/// </summary>
/// <param name="create_cmd">自定义命令</param>
public static void UtilitySubmitButtonClick(MySqlRequest req_type, MySqlCmd.CreateCommand create_cmd)
{
MySqlCmd.MySqlContext input_udata = new MySqlCmd.MySqlContext();
input_udata.conn = MySqlCmd.Connection(WebConfigurationManager.ConnectionStrings["MySqlConnectionString"].ToString());
input_udata.status = req_type;
input_udata.create_cmd = create_cmd;
input_udata.res = 0;
MySqlCmd.SetMySqlCommand(ref input_udata);
}
private void create_cmd(ref MySqlCmd.MySqlContext udata)
{
udata.context = "UPDATE ORDER_FORM SET `REAL_INSTALL_TIME"
+ "`=\"" + this.real_install_time.Value
+ "\", `INSTALL_LEFT_ISSUE"
+ "`=\"" + this.install_left_issue.Value
+ "\", `COMMENT"
+ "`=\"" + this.comment.Value
+ "\" WHERE `SEQUENCES`=\"" + this.sequences.Value + "\"";
}
public void CheckUser(ref MySqlCmd.MySqlContext udata)
{
udata.context = "SELECT * FROM MANAGER WHERE `account`=?account AND `password`=?password\n" +
"UNION\n" +
"SELECT * FROM ROOT_MANAGER WHERE `account`=?account AND `password`=?password\n" +
"UNION\n" +
"SELECT * FROM USER_FORM WHERE `account`=?account AND `password`=?password";
udata.comm = new MySqlCommand(udata.context, udata.conn);
udata.comm.Parameters.AddWithValue("account", user.uname);
udata.comm.Parameters.AddWithValue("password", user.pwd);
}
private void create_cmd(ref MySqlCmd.MySqlContext udata)
{
udata.context = "UPDATE ORDER_FORM SET `BOARD_RESERVE_TIME"
+ "`=\"" + this.board_reserve_time.Value
+ "\", `BOARD_ORDER_TIME"
+ "`=\"" + this.board_order_time.Value
+ "\", `TABLE_BOARD"
+ "`=\"" + this.table_board.Value
+ "\", `BOARD_DOOR_TABLE"
+ "`=\"" + this.board_door_table.Value
+ "\" WHERE `SEQUENCES`=\"" + this.sequences.Value + "\"";
}
private void create_cmd(ref MySqlCmd.MySqlContext udata)
{
// 遍历页面找到HtmlInputText控件
PageSection <HtmlInputText> page = new PageSection <HtmlInputText>(this.modal_body.Controls);
// 遍历所有HtmlInputText控件， 填入数据
string context = "INSERT INTO `USER_FORM` (`";
for (int i = 0; i < page.ControlsContainer.Count; i++)
{
if (i < page.ControlsContainer.Count - 1)
{
if (page.ControlsContainer[i].Value != "" || page.ControlsContainer[i].Value != null)
{
context += page.ControlsContainer[i].Name + "`, `";
}
}
else
{
if (page.ControlsContainer[i].Value != "" || page.ControlsContainer[i].Value != null)
{
context += page.ControlsContainer[i].Name + "`) VALUES ('";
}
break;
}
}
for (int i = 0; i < page.ControlsContainer.Count; i++)
{
if (i < page.ControlsContainer.Count - 1)
{
if (page.ControlsContainer[i].Value != "" || page.ControlsContainer[i].Value != null)
{
context += page.ControlsContainer[i].Value + "', '";
}
}
else
{
if (page.ControlsContainer[i].Value != "" || page.ControlsContainer[i].Value != null)
{
context += page.ControlsContainer[i].Value + "');";
}
break;
}
}
udata.context = context;
}
public void ProcessRequest(HttpContext context)
{
user.uname = context.Request["uname"];
user.pwd = context.Request["password"];
MySqlCmd.MySqlContext udata = new MySqlCmd.MySqlContext();
try {
udata.conn = MySqlCmd.Connection(WebConfigurationManager.ConnectionStrings["MySqlConnectionString"].ToString());
udata.status = MySqlRequest.SEARCH;
udata.create_cmd = CheckUser;
udata.res = 0;
MySqlCmd.LoginCommand(ref udata);
}
catch (Exception ex) {
var res = new { msg = "2", data = ex.Message };
ResponseToClient(context, res);
return;
}
ResultResponse(context, udata);
}
private void create_cmd(ref MySqlCmd.MySqlContext udata)
{
udata.context = "UPDATE ORDER_FORM SET `" + this.other_cabinet.ID
+ "`=\"" + this.other_cabinet.Value + "\" WHERE `SEQUENCES`=\""
+ this.sequences.Value + "\"";
}
private void create_cmd(ref MySqlCmd.MySqlContext udata)
{
udata.context = "UPDATE ORDER_FORM SET `RESERVE_TIME`=\""
+ this.reserve_time.Value + "\" WHERE `SEQUENCES`=\""
+ this.sequences.Value + "\"";
}
private void create_cmd(ref MySqlCmd.MySqlContext udata)
{
udata.context = "DELETE FROM `user_form` WHERE user_form.sequences =\"" + sequences + "\";"
+ "DELETE FROM `order_form` WHERE `SEQUENCES`=\"" + sequences + "\";"
+ "ALTER TABLE order_form AUTO_INCREMENT=1";
}
