public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; //context.Response.Write("Hello World"); Model.HKSJ_Employees model = new Model.HKSJ_Employees(); //Position: Position, //Content: Content, //Demand: Demand, //State: State, //DateTime: DateTime, //People: People model.content = context.Request["Content"]; model.title = context.Request["Position"]; model.status = int.Parse(context.Request["State"]); model.MainPeople = context.Request["People"]; model.people = context.Request["Demand"]; model.date = Convert.ToDateTime(context.Request["DateTime"]); if (bll.Add(model) > 0) { context.Response.Write("OK"); } else { context.Response.Write("error"); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; //context.Response.Write("Hello World"); Model.HKSJ_Employees model = new Model.HKSJ_Employees(); int id = context.Request["relationID"] == null ? 0 : int.Parse(context.Request["relationID"]); model = bll.GetModel(id); System.Web.Script.Serialization.JavaScriptSerializer ja = new System.Web.Script.Serialization.JavaScriptSerializer(); context.Response.Write(ja.Serialize(model)); }
//使用存储过程进行分页, public List <Model.HKSJ_Employees> GetPageNavEmployees(int pageIndex, int pageSize, out int totalCount) { using (SqlDataAdapter adapter = new SqlDataAdapter()) { using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { //创建并且执行数据源; adapter.SelectCommand = conn.CreateCommand(); //执行存储过程代码; adapter.SelectCommand.CommandText = "p_GetPageEmployees"; adapter.SelectCommand.CommandType = CommandType.StoredProcedure; //设置输入参数 adapter.SelectCommand.Parameters.Add(new SqlParameter("@pageIndex", pageIndex)); adapter.SelectCommand.Parameters.Add(new SqlParameter("@pageSize", pageSize)); //设置输出参数 SqlParameter parameterout = new SqlParameter("@totalCount", SqlDbType.Int); parameterout.Direction = ParameterDirection.Output; adapter.SelectCommand.Parameters.Add(parameterout); //将数据源填充到表中 DataTable dt = new DataTable(); adapter.Fill(dt); //获取输入总数 totalCount = Convert.ToInt32(parameterout.Value); //循环遍历; List <Model.HKSJ_Employees> modelist = new List <Model.HKSJ_Employees>(); foreach (DataRow row in dt.Rows) { //ID, title, content, people, date, status, MainPeople Model.HKSJ_Employees model = new Model.HKSJ_Employees(); model.ID = int.Parse(row["ID"].ToString()); model.title = row["title"] == DBNull.Value ? "" : row["title"].ToString(); model.content = row["content"] == DBNull.Value ? "" : row["content"].ToString(); model.people = row["people"] == DBNull.Value ? "" : row["people"].ToString(); model.status = int.Parse(row["status"].ToString()); model.date = row["date"] == DBNull.Value ? Convert.ToDateTime("2012-11-09") : Convert.ToDateTime(row["date"].ToString()); model.MainPeople = row["MainPeople"] == DBNull.Value ? "" : row["MainPeople"].ToString(); modelist.Add(model); } return(modelist); } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; //context.Response.Write("Hello World"); int id = context.Request["relationShipID"] == null ? 0 : int.Parse(context.Request["relationShipID"]); BLL.HKSJ_Employees bll = new BLL.HKSJ_Employees(); Model.HKSJ_Employees model = new Model.HKSJ_Employees(); if (bll.Delete(id)) { context.Response.Write("OK"); } else { context.Response.Write("error"); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; //context.Response.Write("Hello World"); BLL.HKSJ_Employees bll = new BLL.HKSJ_Employees(); Model.HKSJ_Employees model = new Model.HKSJ_Employees(); //ID, title, content, people, date, status, MainPeople //构造修改的参数 //var updateEmployeesDate = { //ID: RowUpdateEmployeesID[0].ID, //title: $("#txtUpdatePosition").val(), //content: $("#txtUpdatePositionContent").val(), //people: $("#txtUpdateDemand").val(), //status: $("#txtUpdateState").val(), //Date: $('#txtUpdateDate').datebox('getValue'), //MainPeople: $("#txtUpdatePeople").val(), model.ID = int.Parse(context.Request["ID"]); model.title = context.Request["title"]; model.content = context.Request["content"]; model.people = context.Request["people"]; model.status = int.Parse(context.Request["status"]); model.MainPeople = context.Request["MainPeople"]; model.date = Convert.ToDateTime(context.Request["Date"]); if (bll.Update(model)) { context.Response.Write("OK"); } else { context.Response.Write("error"); } }