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