/// <summary> /// 更新一条数据 /// </summary> public bool Update(BBS.Model.BBSTopic model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BBSTopic set "); if (model.tsid != null) { strSql.Append("tsid=" + model.tsid + ","); } if (model.tuid != null) { strSql.Append("tuid=" + model.tuid + ","); } if (model.treplycount != null) { strSql.Append("treplycount=" + model.treplycount + ","); } if (model.TTopic != null) { strSql.Append("TTopic='" + model.TTopic + "',"); } if (model.TContents != null) { strSql.Append("TContents='" + model.TContents + "',"); } if (model.TTime != null) { strSql.Append("TTime='" + model.TTime + "',"); } if (model.TClickCount != null) { strSql.Append("TClickCount=" + model.TClickCount + ","); } if (model.TLastClickT != null) { strSql.Append("TLastClickT='" + model.TLastClickT + "',"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where tid=" + model.tid + ""); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
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(); }
/// <summary> /// 得到一个对象实体 /// </summary> public BBS.Model.BBSTopic DataRowToModel(DataRow row) { BBS.Model.BBSTopic model = new BBS.Model.BBSTopic(); if (row != null) { if (row["tid"] != null && row["tid"].ToString() != "") { model.tid = int.Parse(row["tid"].ToString()); } if (row["tsid"] != null && row["tsid"].ToString() != "") { model.tsid = int.Parse(row["tsid"].ToString()); } if (row["tuid"] != null && row["tuid"].ToString() != "") { model.tuid = int.Parse(row["tuid"].ToString()); } if (row["treplycount"] != null && row["treplycount"].ToString() != "") { model.treplycount = int.Parse(row["treplycount"].ToString()); } if (row["TTopic"] != null) { model.TTopic = row["TTopic"].ToString(); } if (row["TContents"] != null) { model.TContents = row["TContents"].ToString(); } if (row["TTime"] != null && row["TTime"].ToString() != "") { model.TTime = DateTime.Parse(row["TTime"].ToString()); } if (row["TClickCount"] != null && row["TClickCount"].ToString() != "") { model.TClickCount = int.Parse(row["TClickCount"].ToString()); } if (row["TLastClickT"] != null && row["TLastClickT"].ToString() != "") { model.TLastClickT = DateTime.Parse(row["TLastClickT"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public BBS.Model.BBSTopic GetModel(int tid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" tid,tsid,tuid,treplycount,TTopic,TContents,TTime,TClickCount,TLastClickT "); strSql.Append(" from BBSTopic "); strSql.Append(" where tid=" + tid + ""); BBS.Model.BBSTopic model = new BBS.Model.BBSTopic(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public BBS.Model.BBSTopic GetModel(int tid) { string sqlupdateTClickCount = string.Format("update BBSTopic set TClickCount=TClickCount+1,TLastClickT='{0}' where tid={1}", DateTime.Now, tid); StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" tid,tsid,tuid,treplycount,TTopic,TContents,TTime,TClickCount,TLastClickT "); strSql.Append(" from BBSTopic "); strSql.Append(" where tid=" + tid + ""); BBS.Model.BBSTopic model = new BBS.Model.BBSTopic(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); DbHelperSQL.ExecuteSql(sqlupdateTClickCount);//更新点击量 if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
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 = "{'info':'增加数据失败'}"; //获取动作的类型 string action = context.Request.Form["Action"]; if (action == "add") { //获取GET方法传递参数:Request.QueryString["参数名称"]; //获取POST方法传递参数:Request.Form["参数名称"]; //保存文本框对象,提高效率 string ttopic = context.Request.Form["ttopic"]; //帖子标题 string tcontents = context.Request.Form["tcontents"]; //帖子内容 //string BBS.Model.BBSTopic model = new BBS.Model.BBSTopic(); model.TTopic = ttopic; //主题标题 model.TContents = tcontents; //主贴内容 model.tsid = 0; //板块编号 model.TTime = DateTime.Now; //发帖时间?暂时不知道是否要删 model.tuid = Convert.ToInt32(context.Session["ID"]); //发帖人编号 model.treplycount = 0; //帖子回复次数 model.TLastClickT = DateTime.Now; //最后点击时间?暂时不知道是否要删 model.TClickCount = 0; //点击次数 BBSTopic bll = new BBSTopic(); int n = bll.Add(model); //返回单个文字信息 if (n > 0) { json = "{'info':'增加数据成功,编号是:" + n + "'}"; } } 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"); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BBS.Model.BBSTopic model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.tsid != null) { strSql1.Append("tsid,"); strSql2.Append("" + model.tsid + ","); } if (model.tuid != null) { strSql1.Append("tuid,"); strSql2.Append("" + model.tuid + ","); } if (model.treplycount != null) { strSql1.Append("treplycount,"); strSql2.Append("" + model.treplycount + ","); } if (model.TTopic != null) { strSql1.Append("TTopic,"); strSql2.Append("'" + model.TTopic + "',"); } if (model.TContents != null) { strSql1.Append("TContents,"); strSql2.Append("'" + model.TContents + "',"); } if (model.TTime != null) { strSql1.Append("TTime,"); strSql2.Append("'" + model.TTime + "',"); } if (model.TClickCount != null) { strSql1.Append("TClickCount,"); strSql2.Append("" + model.TClickCount + ","); } if (model.TLastClickT != null) { strSql1.Append("TLastClickT,"); strSql2.Append("'" + model.TLastClickT + "',"); } strSql.Append("insert into BBSTopic("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { //更新版块表 帖子数 string sqlupdateTopicCount = string.Format("update BBSSection set STopicCount=STopicCount+1 where SID={0}", model.tsid); DbHelperSQL.ExecuteSql(sqlupdateTopicCount);//更新 return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BBS.Model.BBSTopic model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.tsid != null) { strSql1.Append("tsid,"); strSql2.Append("" + model.tsid + ","); } if (model.tuid != null) { strSql1.Append("tuid,"); strSql2.Append("" + model.tuid + ","); } if (model.treplycount != null) { strSql1.Append("treplycount,"); strSql2.Append("" + model.treplycount + ","); } if (model.TTopic != null) { strSql1.Append("TTopic,"); strSql2.Append("'" + model.TTopic + "',"); } if (model.TContents != null) { strSql1.Append("TContents,"); strSql2.Append("'" + model.TContents + "',"); } if (model.TTime != null) { strSql1.Append("TTime,"); strSql2.Append("'" + model.TTime.ToString("yyyy-MM-dd") + "',"); } if (model.TClickCount != null) { strSql1.Append("TClickCount,"); strSql2.Append("" + model.TClickCount + ","); } if (model.TLastClickT != null) { strSql1.Append("TLastClickT,"); strSql2.Append("'" + model.TLastClickT.ToString("yyyy-MM-dd") + "',"); } strSql.Append("insert into BBSTopic("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
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); }