public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string json = "{}";
string action = context.Request.Form["Action"];
if (action == "Show")
{
BBS.BLL.BBSTopic bll = new BBS.BLL.BBSTopic();
DataSet ds = bll.GetList(10, "", "TClickCount"); //获取点击率最高的
ds.Tables[0].TableName = "hotArticles"; //修改数据表的名字
DataSet dstop5 = bll.GetList(10, "", "TTime"); //获取最新的
DataTable top5 = dstop5.Tables[0].Copy(); //获取数据表
top5.TableName = "newArticles"; //改名
ds.Tables.Add(top5); //把前5个用户的数据表，加到数据集ds中
//返回列表
json = Web.DataConvertJson.Dataset2Json(ds);//转换
}
context.Response.Write(json);
}
public string BindSource(int pagesize, int page, string sqlwhere)
{
BBS.BLL.BBSTopic bll = new BBS.BLL.BBSTopic();
//获取分页数据
DataSet ds = bll.GetListByPage(sqlwhere, "", pagesize * page + 1, pagesize * (page + 1)); //获取数据源的ds会吧。
ds.Tables[0].TableName = "List";
return(Web.DataConvertJson.DataTable2Json(ds.Tables[0]));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string sqlwhere = context.Request["sqlwhere"];
string json = "{'info':'0'}";
BBS.BLL.BBSTopic bll = new BBS.BLL.BBSTopic();
int n = bll.GetRecordCount(sqlwhere);
json = "{'info':'" + n + "'}";
context.Response.Write(json);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BBS.BLL.BBSTopic bll = new BBS.BLL.BBSTopic();
if (Request.Params["id"] != null && Request.Params["id"].Trim() != "")
{
int tid = (Convert.ToInt32(Request.Params["id"]));
bll.Delete(tid);
Response.Redirect("list.aspx");
}
}
}
private void ShowInfo(int tid)
{
BBS.BLL.BBSTopic bll = new BBS.BLL.BBSTopic();
BBS.Model.BBSTopic model = bll.GetModel(tid);
this.lbltid.Text = model.tid.ToString();
this.lbltsid.Text = model.tsid.ToString();
this.lbltuid.Text = model.tuid.ToString();
this.lbltreplycount.Text = model.treplycount.ToString();
this.lblTTopic.Text = model.TTopic;
this.lblTContents.Text = model.TContents;
this.lblTTime.Text = model.TTime.ToString();
this.lblTClickCount.Text = model.TClickCount.ToString();
this.lblTLastClickT.Text = model.TLastClickT.ToString();
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string json = "{}";
string action = context.Request.Form["Action"];
if (action == "Del") //删除操作
{
string DelNumS = context.Request.Form["DelNumS"]; //获取批量删除的编号
BBS.BLL.BBSTopic bll = new BBS.BLL.BBSTopic();
if (bll.DeleteList(DelNumS))
{
json = "{'info':'删除成功'}";
}
else
{
json = "{'info':'删除失败'}";
}
}
context.Response.Write(json);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string ID = context.Request.Form["ID"];
BBS.BLL.BBSTopic bll = new BBS.BLL.BBSTopic();
// Model.Admin前必须加 [Serializable]
BBS.Model.BBSTopic model = bll.GetModel(int.Parse(ID));
//返回一个类的对象
string jsonString;
if (model == null)
{
jsonString = "{}";
}
else
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
jsonString = serializer.Serialize(model);
}
context.Response.Write(jsonString);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string json = "{}";
string action = context.Request.Form["Action"];
int uid = int.Parse(context.Request["UID"]);
int displayStart = int.Parse(context.Request["offset"]); //起始页
int displayLength = int.Parse(context.Request["limit"]); //每页数量
string strwhere = "";
if (uid != 0)
{
strwhere = "tuid=" + uid;
}
BBS.BLL.BBSTopic bll = new BBS.BLL.BBSTopic();
int total = bll.GetRecordCount(strwhere);
DataSet ds = bll.GetListByPage(strwhere, "", displayStart + 1, displayStart + displayLength);
ds.Tables[0].TableName = "rows";
//返回列表
json = Web.DataConvertJson.DataTable2Json(ds.Tables[0]);
//??服务器端返回的数据中还要包括rows，total（数据总量）两个字段，前端要根据这两个字段分页。
json = "{\"total\":" + total + "," + json.Substring(1);
/*
* 返回数据格式
* {"total":100,"rows":....}
*
*/
context.Response.Write(json);
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (!PageValidate.IsNumber(txttsid.Text))
{
strErr += "tsid格式错误！\\n";
}
if (!PageValidate.IsNumber(txttuid.Text))
{
strErr += "tuid格式错误！\\n";
}
if (!PageValidate.IsNumber(txttreplycount.Text))
{
strErr += "treplycount格式错误！\\n";
}
if (this.txtTTopic.Text.Trim().Length == 0)
{
strErr += "TTopic不能为空！\\n";
}
if (this.txtTContents.Text.Trim().Length == 0)
{
strErr += "TContents不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtTTime.Text))
{
strErr += "TTime格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTClickCount.Text))
{
strErr += "TClickCount格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtTLastClickT.Text))
{
strErr += "TLastClickT格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int tsid = int.Parse(this.txttsid.Text);
int tuid = int.Parse(this.txttuid.Text);
int treplycount = int.Parse(this.txttreplycount.Text);
string TTopic = this.txtTTopic.Text;
string TContents = this.txtTContents.Text;
DateTime TTime = DateTime.Parse(this.txtTTime.Text);
int TClickCount = int.Parse(this.txtTClickCount.Text);
DateTime TLastClickT = DateTime.Parse(this.txtTLastClickT.Text);
BBS.Model.BBSTopic model = new BBS.Model.BBSTopic();
model.tsid = tsid;
model.tuid = tuid;
model.treplycount = treplycount;
model.TTopic = TTopic;
model.TContents = TContents;
model.TTime = TTime;
model.TClickCount = TClickCount;
model.TLastClickT = TLastClickT;
BBS.BLL.BBSTopic bll = new BBS.BLL.BBSTopic();
bll.Add(model);
Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
public void ProcessRequest(HttpContext context)
{
// context.Response.ContentType = "text/plain";
context.Response.ContentType = "text/html";
string action = context.Request.Form["Action"];
string json = "{\"info\":\"已登录\"}";
if (action == "Load")
{
if (context.Session["ID"] == null)
{
json = "{\"info\":\"未登录\"}";
}
else
{
BBS.BLL.BBSSection bll0 = new BBS.BLL.BBSSection();
DataSet ds = bll0.GetList("");
ds.Tables[0].TableName = "BBSSection";
string json1 = Web.DataConvertJson.DataTable2Json(ds.Tables[0]);
json = "{\"info\":\"已登录\"," + json1.Substring(1);
}
}
else if (action == "Add")
{
json = "{\"info\":\"发表失败\"}";
string content = context.Request.Form["Content"]; //保存文本框对象，提高效率
content = HttpContext.Current.Server.UrlDecode(content); //反编码
int tsid = int.Parse(context.Request.Form["section"]);
int tuid = int.Parse(context.Session["ID"].ToString());
int treplycount = 0;
string TTopic = context.Request.Form["title"];
string TContents = content;
DateTime TTime = DateTime.Now;
int TClickCount = 0;
DateTime TLastClickT = DateTime.Now;
BBS.Model.BBSTopic model = new BBS.Model.BBSTopic();
model.tsid = tsid;
model.tuid = tuid;
model.treplycount = treplycount;
model.TTopic = TTopic;
model.TContents = TContents;
model.TTime = TTime;
model.TClickCount = TClickCount;
model.TLastClickT = TLastClickT;
BBS.BLL.BBSTopic bll = new BBS.BLL.BBSTopic();
int n = bll.Add(model);
//返回单个文字信息
if (n > 0)
{
json = "{\"info\":\"增加数据成功\",\"UID\":\"" + tuid + "\"}";
}
}
context.Response.Write(json);
}
