public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
if (context.Session["Admin"] == null || context.Session["Admin"].ToString() == "")
{
context.Response.Redirect("/html/adminLogin.html");
}
string action = context.Request["Action"];
string adminName = context.Session["Admin"].ToString();
string adminId = "";
DataTable dts =
SqlHelper.ExecuteDataTable("select * from Admin where Account = " + adminName);
foreach (DataRow dr in dts.Rows)
{
adminId = dr["Admin_ID"].ToString();
}
//查询学生
if (action == "Search")
{
string requestNum = context.Request["PageNumber"];
string html = FenYe.FY("FAQs.ashx", "searchFAQs.html", "V_F", requestNum, "FAQ_ID", adminId);
context.Response.Write(html);
}
else if (action == "add")
{
string html = CommonHelper.RenderHtml("addFAQs.html", "");
context.Response.Write(html);
}
else if (action == "Add")
{
string aid = context.Request["Admin_ID"];
string title = context.Request["Title"];
string content = context.Request["Content"];
string is_delete = context.Request["IS_DELETE"];
SqlHelper.ExecuteNonQuery("Insert into FAQs(Admin_ID,Title,Content,IS_DELETE) values(@Admin_ID,@Title,@Content,@IS_DELETE)",
new SqlParameter("@Admin_ID", aid)
, new SqlParameter("@Title", title)
, new SqlParameter("@Content", content)
, new SqlParameter("@IS_DELETE", is_delete)
);
context.Response.Redirect("http://*****:*****@User_ID,@Admin_ID,@C_Name,@C_Email,@C_Subject,@Message,@IS_DELETE)",
new SqlParameter("@User_ID", uid)
, new SqlParameter("@Admin_ID", aid)
, new SqlParameter("@C_Name", cname)
, new SqlParameter("@C_Email", cemail)
, new SqlParameter("@C_Subject", csubject)
, new SqlParameter("@Message", message)
, new SqlParameter("@IS_DELETE", is_delete)
);
context.Response.Redirect("http://*****:*****@Admin_ID,Title=@Title,Content=@Content,IS_DELETE=@IS_DELETE where FAQ_ID=@FAQ_ID"
, new SqlParameter("@Admin_ID", aid)
, new SqlParameter("@Title", title)
, new SqlParameter("@Content", content)
, new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@FAQ_ID", id)
);
context.Response.Redirect("http://*****:*****@IS_DELETE where FAQ_ID=@FAQ_ID",
new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@FAQ_ID", id)
);
context.Response.Redirect("http://localhost:54436/FAQs.ashx?Action=Search");
}
else
{
context.Response.Redirect("http://localhost:54436/FAQs.ashx?Action=Search");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
if (context.Session["Admin"] == null || context.Session["Admin"].ToString() == "")
{
context.Response.Redirect("/html/adminLogin.html");
}
string action = context.Request["Action"];
string adminName = context.Session["Admin"].ToString();
string adminId = "";
DataTable dts =
SqlHelper.ExecuteDataTable("select * from Admin where Account = " + adminName);
foreach (DataRow dr in dts.Rows)
{
adminId = dr["Admin_ID"].ToString();
}
//查询学生
if (action == "Search")
{
string requestNum = context.Request["PageNumber"];
string html = FenYe.FY("backAbout.ashx", "searchAbout.html", "V_About", requestNum, "Article_ID", adminId);
context.Response.Write(html);
}
else if (action == "add")
{
string html = CommonHelper.RenderHtml("addAbout.html", "");
context.Response.Write(html);
}
else if (action == "Add")
{
string aid = context.Request["Admin_ID"];
string title = context.Request["Title"];
string content = context.Request["Content"];
string judgeTime = context.Request["Time"];
string time = null;
string is_delete = context.Request["IS_DELETE"];
int judgeTimee = 1;
judgeTimee = int.Parse(judgeTime);
if (judgeTimee == 1)
{
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
time = currentTime.ToString("f");
}
SqlHelper.ExecuteNonQuery("Insert into Article(Admin_ID,Title,Content,Time,IS_DELETE) values(@Admin_ID,@Title,@Content,@Time,@IS_DELETE)",
new SqlParameter("@Admin_ID", aid)
, new SqlParameter("@Title", title)
, new SqlParameter("@Content", content)
, new SqlParameter("@Time", time)
, new SqlParameter("@IS_DELETE", is_delete)
);
context.Response.Redirect("http://*****:*****@User_ID,@Admin_ID,@C_Name,@C_Email,@C_Subject,@Message,@IS_DELETE)",
new SqlParameter("@User_ID", uid)
, new SqlParameter("@Admin_ID", aid)
, new SqlParameter("@C_Name", cname)
, new SqlParameter("@C_Email", cemail)
, new SqlParameter("@C_Subject", csubject)
, new SqlParameter("@Message", message)
, new SqlParameter("@IS_DELETE", is_delete)
);
context.Response.Redirect("http://*****:*****@Admin_ID,Title=@Title,Content=@Content,Time=@Time,IS_DELETE=@IS_DELETE where Article_ID=@Article_ID"
, new SqlParameter("@Admin_ID", aid)
, new SqlParameter("@Title", title)
, new SqlParameter("@Content", content)
, new SqlParameter("@Time", time)
, new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@Article_ID", id)
);
context.Response.Redirect("http://*****:*****@IS_DELETE where Article_ID=@Article_ID",
new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@Article_ID", id)
);
context.Response.Redirect("http://localhost:54436/backAbout.ashx?Action=Search");
}
else
{
context.Response.Redirect("http://localhost:54436/backAbout.ashx?Action=Search");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
if (context.Session["Admin"] == null || context.Session["Admin"].ToString() == "")
{
context.Response.Redirect("/html/adminLogin.html");
}
string action = context.Request["Action"];
string adminName = context.Session["Admin"].ToString();
string adminId = "";
DataTable dts =
SqlHelper.ExecuteDataTable("select * from Admin where Account = " + adminName);
foreach (DataRow dr in dts.Rows)
{
adminId = dr["Admin_ID"].ToString();
}
//查询学生
if (action == "Search")
{
string requestNum = context.Request["PageNumber"];
string html = FenYe.FY("Category.ashx", "Category.html", "Category", requestNum, "Category_ID", adminId);
context.Response.Write(html);
}
else if (action == "add")
{
string html = CommonHelper.RenderHtml("addCategory.html", "");
context.Response.Write(html);
}
else if (action == "Add")
{
string name = context.Request["Name"];
int is_delete = 0;
SqlHelper.ExecuteNonQuery("Insert into Category(Admin_ID,C_Name,IS_DELETE) values(@Admin_ID,@C_Name,@IS_DELETE)",
new SqlParameter("@Admin_ID", adminId)
, new SqlParameter("@C_Name", name)
, new SqlParameter("@IS_DELETE", is_delete)
);
context.Response.Redirect("http://*****:*****@C_Name,IS_DELETE=@IS_DELETE where Category_ID=@Category_ID"
, new SqlParameter("@C_Name", name)
, new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@Category_ID", id)
);
context.Response.Redirect("http://*****:*****@IS_DELETE where Category_ID=@Category_ID",
new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@Category_ID", id)
);
context.Response.Redirect("http://localhost:54436/category.ashx?Action=Search");
}
else
{
context.Response.Redirect("http://localhost:54436/category.ashx?Action=Search");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
if (context.Session["Admin"] == null || context.Session["Admin"].ToString() == "")
{
context.Response.Redirect("/html/adminLogin.html");
}
string action = context.Request["Action"];
string adminName = context.Session["Admin"].ToString();
string adminId = "";
DataTable dts =
SqlHelper.ExecuteDataTable("select * from Admin where Account = " + adminName);
foreach (DataRow dr in dts.Rows)
{
adminId = dr["Admin_ID"].ToString();
}
//查询学生
if (action == "Search")
{
string requestNum = context.Request["PageNumber"];
string html = FenYe.FY("Product.ashx", "product.html", "V_P", requestNum, "Product_ID", adminId);
context.Response.Write(html);
}
else if (action == "add")
{
DataTable dt =
SqlHelper.ExecuteDataTable("select * from Category where IS_DELETE = 0 and Admin_ID = " + adminId + "");
string html = CommonHelper.RenderHtml("addProduct.html", dt.Rows);
context.Response.Write(html);
}
else if (action == "Add")
{
HttpServerUtility server = context.Server;
HttpRequest request = context.Request;
HttpResponse response = context.Response;
HttpPostedFile file = context.Request.Files[0];
string fullName = "";
if (file.ContentLength > 0)
{
string extName = Path.GetExtension(file.FileName);
string fileName = Guid.NewGuid().ToString();
fullName = fileName + extName;
string imageFilter = ".jpg|.png|.gif|.ico";// 随便模拟几个图片类型
if (imageFilter.Contains(extName.ToLower()))
{
string phyFilePath = server.MapPath("~/Upload/Image/") + fullName;
file.SaveAs(phyFilePath);
//response.Write("上传成功！文件名：" + fullName + "<br />");
//response.Write(string.Format("<img src='Upload/Image/{0}'/>", fullName));
}
}
string P_Name = context.Request["P_Name"];
string Category_ID = context.Request["Category_ID"];
string Availability = context.Request["Availability"];
string P_Price = context.Request["P_Price"];
string Model = context.Request["Model"];
string Manufacturer = context.Request["Manufacturer"];
string Quantity = context.Request["Quantity"];
string P_Detail = context.Request["P_Detail"];
string IS_TJ = context.Request["IS_TJ"];
string P_Pic = string.Format("http://*****:*****@Category_ID," +
"@Admin_ID,@P_Name,@P_Price,@P_Pic,@Availability,@Model," +
"@Manufacturer,@P_Detail,@IS_DELETE,@Quantity,@IS_TJ)",
new SqlParameter("@Category_ID", Category_ID)
, new SqlParameter("@Admin_ID", adminId)
, new SqlParameter("@P_Name", P_Name)
, new SqlParameter("@P_Price", P_Price)
, new SqlParameter("@P_Pic", P_Pic)
, new SqlParameter("@Availability", Availability)
, new SqlParameter("@Model", Model)
, new SqlParameter("@Manufacturer", Manufacturer)
, new SqlParameter("@P_Detail", P_Detail)
, new SqlParameter("@IS_DELETE", IS_DELETE)
, new SqlParameter("@Quantity", Quantity)
, new SqlParameter("@IS_TJ", IS_TJ)
);
context.Response.Redirect("http://*****:*****@Category_ID," +
"Admin_ID=@Admin_ID,P_Name=@P_Name,P_Price=@P_Price,P_Pic=@P_Pic" +
",Availability=@Availability,Model=@Model,Manufacturer=@Manufacturer," +
"P_Detail=@P_Detail,IS_DELETE=@IS_DELETE,Quantity=@Quantity,IS_TJ=@IS_TJ " +
" where Product_ID=@Product_ID",
new SqlParameter("@Category_ID", Category_ID)
, new SqlParameter("@Admin_ID", adminId)
, new SqlParameter("@P_Name", P_Name)
, new SqlParameter("@P_Price", P_Price)
, new SqlParameter("@P_Pic", P_Pic)
, new SqlParameter("@Availability", Availability)
, new SqlParameter("@Model", Model)
, new SqlParameter("@Manufacturer", Manufacturer)
, new SqlParameter("@P_Detail", P_Detail)
, new SqlParameter("@IS_DELETE", IS_DELETE)
, new SqlParameter("@Quantity", Quantity)
, new SqlParameter("@IS_TJ", IS_TJ)
, new SqlParameter("@Product_ID", Product_ID)
);
context.Response.Redirect("http://*****:*****@IS_DELETE where Product_ID=@Product_ID",
new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@Product_ID", id)
);
context.Response.Redirect("http://localhost:54436/product.ashx?Action=Search");
}
else
{
context.Response.Redirect("http://localhost:54436/product.ashx?Action=Search");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
if (context.Session["User"] == null || context.Session["User"].ToString() == "")
{
context.Response.Redirect("/html/login.html");
}
string action = context.Request["Action"];
//查询学生
if (action == "Search")
{
string requestNum = context.Request["PageNumber"];
string html = FenYe.FY("Teacher.ashx", "teacher.html", "Teacher", requestNum, "T_ID", "");
context.Response.Write(html);
}
else if (action == "Add")
{
string name = context.Request["Name"];
string phone = context.Request["Phone"];
string bir = context.Request["Bir"];
string email = context.Request["Email"];
int is_delete = 0;
SqlHelper.ExecuteNonQuery("Insert into Teacher(T_NAME,T_PHONE,T_EMAIL,T_BR,IS_DELETE) values(@T_NAME,@T_PHONE,@T_EMAIL,@T_BR,@IS_DELETE)",
new SqlParameter("@T_NAME", name)
, new SqlParameter("@T_PHONE", phone)
, new SqlParameter("@T_EMAIL", email)
, new SqlParameter("@T_BR", bir)
, new SqlParameter("@IS_DELETE", is_delete)
);
context.Response.Redirect("http://*****:*****@T_NAME,@T_PHONE,@T_EMAIL,@T_BR,@IS_DELETE)",
new SqlParameter("@T_NAME", name)
, new SqlParameter("@T_PHONE", phone)
, new SqlParameter("@T_EMAIL", email)
, new SqlParameter("@T_BR", bir)
, new SqlParameter("@IS_DELETE", is_delete)
);
context.Response.Write("");
}
else if (action == "Edit")
{
string id = context.Request["Id"];
DataTable dt =
SqlHelper.ExecuteDataTable("select * from Teacher where T_ID = " + id);
string html = CommonHelper.RenderHtml("editTeacher.html", dt.Rows);
context.Response.Write(html);
}
else if (action == "edit")
{
string id = context.Request["Id"];
string name = context.Request["Name"];
string phone = context.Request["Phone"];
string bir = context.Request["Bir"];
string email = context.Request["Email"];
int is_delete = 0;
SqlHelper.ExecuteNonQuery("update Teacher set T_NAME=@T_NAME,T_PHONE=@T_PHONE,T_EMAIL=@T_EMAIL,T_BR=@T_BR,IS_DELETE=@IS_DELETE where T_ID=@T_ID",
new SqlParameter("@T_NAME", name)
, new SqlParameter("@T_PHONE", phone)
, new SqlParameter("@T_EMAIL", email)
, new SqlParameter("@T_BR", bir)
, new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@T_ID", id)
);
context.Response.Redirect("http://*****:*****@IS_DELETE where T_ID=@T_ID",
new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@T_ID", id)
);
context.Response.Redirect("http://*****:*****@IS_DELETE where T_ID=@T_ID",
new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@T_ID", id)
);
context.Response.Write("");
}
else
{
context.Response.Redirect("http://localhost:54436/teacher.ashx?Action=Search");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
if (context.Session["User"] == null || context.Session["User"].ToString() == "")
{
context.Response.Redirect("/html/loginContact.html");
}
string User_ID = context.Session["Id"].ToString();
string action = context.Request["Action"];
/*
* context.Response.ContentType = "text/html";
* if (context.Session["Admin"] == null || context.Session["Admin"].ToString() == "")
* {
* context.Response.Redirect("/html/adminLogin.html");
* }
*
* string action = context.Request["Action"];
*/
/*
* string adminName = context.Session["Admin"].ToString();
* string adminId = "";
* DataTable dts =
* SqlHelper.ExecuteDataTable("select * from Admin where Account = " + adminName);
* foreach (DataRow dr in dts.Rows)
* {
* adminId = dr["Admin_ID"].ToString();
* }
*/
//查询学生
if (action == "Search")
{
string requestNum = context.Request["PageNumber"];
string html = FenYe.FY("Contact.ashx", "searchContact.html", "V_C", requestNum, "Contact_ID", "");
context.Response.Write(html);
}
else if (action == "add")
{
string html = CommonHelper.RenderHtml("addContact.html", "");
context.Response.Write(html);
}
else if (action == "Add")
{
/*
* id="User_ID" name="User_ID"
* id="Admin_ID" name="Admin_ID
* id="C_Name" name="C_Name"
* id="C_Email" name="C_Email"
* id="C_Subject" name="C_Subject"
* id="Message" name="Message"
*/
string uid = context.Request["User_ID"];
string aid = context.Request["Admin_ID"];
string cname = context.Request["C_Name"];
string cemail = context.Request["C_Email"];
string csubject = context.Request["C_Subject"];
string message = context.Request["Message"];
int is_delete = 0;
SqlHelper.ExecuteNonQuery("Insert into Contact(User_ID,Admin_ID,C_Name,C_Email,C_Subject,Message,IS_DELETE) values(@User_ID,@Admin_ID,@C_Name,@C_Email,@C_Subject,@Message,@IS_DELETE)",
new SqlParameter("@User_ID", uid)
, new SqlParameter("@Admin_ID", aid)
, new SqlParameter("@C_Name", cname)
, new SqlParameter("@C_Email", cemail)
, new SqlParameter("@C_Subject", csubject)
, new SqlParameter("@Message", message)
, new SqlParameter("@IS_DELETE", is_delete)
);
context.Response.Redirect("http://*****:*****@User_ID,@Admin_ID,@C_Name,@C_Email,@C_Subject,@Message,@IS_DELETE)",
new SqlParameter("@User_ID", uid)
, new SqlParameter("@Admin_ID", aid)
, new SqlParameter("@C_Name", cname)
, new SqlParameter("@C_Email", cemail)
, new SqlParameter("@C_Subject", csubject)
, new SqlParameter("@Message", message)
, new SqlParameter("@IS_DELETE", is_delete)
);
context.Response.Redirect("http://*****:*****@C_Name,IS_DELETE=@IS_DELETE where Category_ID=@Category_ID"
, new SqlParameter("@C_Name", name)
, new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@Category_ID", id)
);
context.Response.Redirect("http://*****:*****@IS_DELETE where Category_ID=@Category_ID",
new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@Category_ID", id)
);
context.Response.Redirect("http://localhost:54436/category.ashx?Action=Search");
}
else
{
context.Response.Redirect("http://localhost:54436/category.ashx?Action=Search");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
if (context.Session["User"] == null || context.Session["User"].ToString() == "")
{
context.Response.Redirect("/html/login.html");
}
string action = context.Request["Action"];
//查询学生
if (action == "Search")
{
string requestNum = context.Request["PageNumber"];
string html = FenYe.FY("Student.ashx", "student.html", "V_S", requestNum, "S_ID", "");
context.Response.Write(html);
}
else if (action == "add")
{
DataTable dt =
SqlHelper.ExecuteDataTable("select * from BanJi where IS_DELETE = 0");
string html = CommonHelper.RenderHtml("addStudent.html", dt.Rows);
context.Response.Write(html);
}
else if (action == "Add")
{
string name = context.Request["Name"];
string sex = context.Request["Sex"];
string bir = context.Request["Bir"];
string high = context.Request["High"];
string tc = context.Request["TC"];
string bj = context.Request["BJ"];
int is_delete = 0;
SqlHelper.ExecuteNonQuery("Insert into Student(S_NAME,B_ID,S_SEX,S_HIGH,IS_TC,IS_DELETE,S_BIR) values(@S_NAME,@B_ID,@S_SEX,@S_HIGH,@IS_TC,@IS_DELETE,@S_BIR)",
new SqlParameter("@S_NAME", name)
, new SqlParameter("@B_ID", bj)
, new SqlParameter("@S_SEX", sex)
, new SqlParameter("@S_HIGH", high)
, new SqlParameter("@IS_TC", tc)
, new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@S_BIR", bir)
);
context.Response.Redirect("http://*****:*****@S_NAME,@B_ID,@S_SEX,@S_HIGH,@IS_TC,@IS_DELETE,@S_BIR)",
new SqlParameter("@S_NAME", name)
, new SqlParameter("@B_ID", bj)
, new SqlParameter("@S_SEX", sex)
, new SqlParameter("@S_HIGH", high)
, new SqlParameter("@IS_TC", tc)
, new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@S_BIR", bir)
);
context.Response.Write("");
}
else if (action == "Edit")
{
string id = context.Request["Id"];
DataTable dt =
SqlHelper.ExecuteDataTable("select * from V_S where S_ID = " + id);
DataTable dt2 =
SqlHelper.ExecuteDataTable("select * from BanJi where IS_DELETE = 0");
string html = CommonHelper2.RenderHtml("editStudent.html", dt.Rows, dt2.Rows);
context.Response.Write(html);
}
else if (action == "edit")
{
string id = context.Request["Id"];
string name = context.Request["Name"];
string sex = context.Request["Sex"];
string bir = context.Request["Bir"];
string high = context.Request["High"];
string tc = context.Request["TC"];
string bj = context.Request["BJ"];
int is_delete = 0;
SqlHelper.ExecuteNonQuery("update Student set B_ID=@B_ID,S_NAME=@S_NAME,S_SEX=@S_SEX,S_HIGH=@S_HIGH,IS_TC=@IS_TC,IS_DELETE=@IS_DELETE,S_BIR=@S_BIR where S_ID=@S_ID",
new SqlParameter("@B_ID", bj)
, new SqlParameter("@S_NAME", name)
, new SqlParameter("@S_SEX", sex)
, new SqlParameter("@S_HIGH", high)
, new SqlParameter("@IS_TC", tc)
, new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@S_BIR", bir)
, new SqlParameter("@S_ID", id)
);
context.Response.Redirect("http://*****:*****@IS_DELETE where S_ID=@S_ID",
new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@S_ID", id)
);
context.Response.Redirect("http://*****:*****@IS_DELETE where S_ID=@S_ID",
new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@S_ID", id)
);
context.Response.Write("");
}
else
{
context.Response.Redirect("http://localhost:54436/student.ashx?Action=Search");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
if (context.Session["User"] == null || context.Session["User"].ToString() == "")
{
context.Response.Redirect("/html/login.html");
}
string action = context.Request["Action"];
//查询学生
if (action == "Search")
{
string requestNum = context.Request["PageNumber"];
string html = FenYe.FY("BanJi.ashx", "bJ.html", "V_BJ", requestNum, "B_ID", "");
context.Response.Write(html);
}
else if (action == "add")
{
DataTable dt =
SqlHelper.ExecuteDataTable("select * from Teacher where IS_DELETE = 0");
string html = CommonHelper.RenderHtml("addBJ.html", dt.Rows);
context.Response.Write(html);
}
else if (action == "Add")
{
string name = context.Request["Name"];
string t_id = context.Request["Teacher"];
string num = context.Request["Num"];
int is_delete = 0;
SqlHelper.ExecuteNonQuery("Insert into BanJi(T_ID,B_NAME,B_NUM,IS_DELETE) values(@T_ID,@B_NAME,@B_NUM,@IS_DELETE)",
new SqlParameter("@T_ID", t_id)
, new SqlParameter("@B_NAME", name)
, new SqlParameter("@B_NUM", num)
, new SqlParameter("@IS_DELETE", is_delete)
);
context.Response.Redirect("http://*****:*****@T_ID,@B_NAME,@B_NUM,@IS_DELETE)",
new SqlParameter("@T_ID", t_id)
, new SqlParameter("@B_NAME", name)
, new SqlParameter("@B_NUM", num)
, new SqlParameter("@IS_DELETE", is_delete)
);
context.Response.Write("");
}
else if (action == "Edit")
{
string id = context.Request["Id"];
DataTable dt =
SqlHelper.ExecuteDataTable("select * from V_BJ where B_ID = " + id);
DataTable dt2 =
SqlHelper.ExecuteDataTable("select * from Teacher where IS_DELET = 0");
string html = CommonHelper2.RenderHtml("editBJ.html", dt.Rows, dt2.Rows);
context.Response.Write(html);
}
else if (action == "edit")
{
string id = context.Request["Id"];
string name = context.Request["Name"];
string t_id = context.Request["Teacher"];
string num = context.Request["Num"];
int is_delete = 0;
SqlHelper.ExecuteNonQuery("update BanJi set T_ID=@T_ID,B_NAME=@B_NAME,B_NUM=@B_NUM,IS_DELETE=@IS_DELETE where B_ID=@B_ID",
new SqlParameter("@T_ID", t_id)
, new SqlParameter("@B_NAME", name)
, new SqlParameter("@B_NUM", num)
, new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@B_ID", id)
);
context.Response.Redirect("http://*****:*****@IS_DELETE where B_ID=@B_ID",
new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@B_ID", id)
);
context.Response.Redirect("http://*****:*****@IS_DELETE where B_ID=@B_ID",
new SqlParameter("@IS_DELETE", is_delete)
, new SqlParameter("@B_ID", id)
);
context.Response.Write("");
}
else
{
context.Response.Redirect("http://localhost:54436/banji.ashx?Action=Search");
}
}
