/// <summary> /// 重写虚方法,此方法在Init事件执行 /// </summary> protected override void InitPage() { action = DTRequest.GetQueryString("action"); page = DTRequest.GetQueryInt("page", 1); modelUserExtended = new ForumPage().GetOnlineUser(); }
public void ProcessRequest(HttpContext context) { //取得处事类型 string action = DTRequest.GetQueryString("action"); modelUser = new Page.ForumPage().GetOnlineUser(); aid = DTRequest.GetQueryInt("aid", 0); thumb = DTRequest.GetQueryInt("thumb", 0); sitepath = DTRequest.GetQueryString("site"); if (string.IsNullOrEmpty(sitepath)) { context.Response.Write("出错了,站点传输参数不正确!"); return; } switch (action) { //下载 case "down": down(context); break; //编主题 case "delete": delete(context); break; } }
//提交 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("plugin_forum_userextended", DTEnums.ActionEnum.Delete.ToString()); //检查权限 BLL.Forum_UserExtended bll = new BLL.Forum_UserExtended(); model = new BLL.Forum_UserExtended().GetModel(this.id); string ids = "0"; for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { ids += "," + id.ToString(); } } model.Medal = ids; bll.Update(model); AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改管理员:" + model.Nickname); //记录日志 JscriptMsg("修改信息成功!", hfTurl.Value); }
/// <summary> /// 方法自动计算积分并归组 /// </summary> /// <param name="id"></param> /// <returns></returns> public Model.Forum_UserExtended SetGroupId(Model.Forum_UserExtended modelUser) { //因为传过来的值不是最新的,需要重新获取 Model.Forum_UserExtended model = GetModel(modelUser.UserId); Model.Forum_Group modelGroup = new BLL.Forum_Group().GetModel(model.GroupId); //作用升级的组 if (modelGroup.Type == 5) { Model.Forum_Group newGroup = new BLL.Forum_Group().GetModel("Type=5 and CreditLower<=" + model.Credit + " and CreditHigher>=" + model.Credit); if (newGroup != null) { model.GroupId = newGroup.Id; model.GroupName = newGroup.Name; model.UserName = modelUser.UserName; Update(model); } else { newGroup = new BLL.Forum_Group().GetModel("IsDefault=1"); model.GroupId = newGroup.Id; model.GroupName = newGroup.Name; model.UserName = modelUser.UserName; } } return(model); }
private void ShowInfo(int _id) { BLL.Forum_UserExtended bll = new BLL.Forum_UserExtended(); Model.Forum_UserExtended model = bll.GetModel(_id); modelUser = new DTcms.BLL.users().GetModel(model.UserId); //编写赋值操作Begin //txtUserId.Text = model.UserId; //txtQQ.Text = model.QQ; //txtMSN.Text = model.MSN; rblGender.SelectedValue = model.Gender.ToString(); //txtBirthday.Text = model.Birthday; //txtBio.Text = model.Bio; //txtAddress.Text = model.Address; //txtSite.Text = model.Site; //txtSignature.Text = model.Signature; txtNickname.Text = model.Nickname; //txtLastPostDateTime.Text = model.LastPostDateTime; ddlGroupId.SelectedValue = model.GroupId.ToString(); //txtLastActivity.Text = model.LastActivity; //txtTopicCount.Text = model.TopicCount; //txtPostCount.Text = model.PostCount; //txtPostDigestCount.Text = model.PostDigestCount; //txtMedal.Text = model.Medal; //txtOnlineTime.Text = model.OnlineTime; //txtOnlineUpdateTime.Text = model.OnlineUpdateTime; //txtVerify.Text = model.Verify; //txtHometown.Text = model.Hometown; //txtNonlocal.Text = model.Nonlocal; //txtSpecialty.Text = model.Specialty; txtCredit.Text = model.Credit.ToString(); if (!string.IsNullOrEmpty(model.Medal)) { List <Model.Forum_Medal> modelList = new BLL.Forum_Medal().GetModelList(" id in (" + model.Medal + ") "); medalHtml = ""; foreach (Model.Forum_Medal item in modelList) { medalHtml += "<img <img src='" + item.Image + "' style=' max-width:100px; margin:8px 8px 0px 0px;vertical-align: top;' />"; } } //编写赋值操作End }
/// <summary> /// 将原 Cms User表中的用户,对应在论坛Forum_UserExtended副表中生成 /// </summary> public void SysUserAdd() { string strSql = "SELECT * FROM [dbo].[" + databaseprefix + "users] where id not in (select UserId from [dbo].[" + databaseprefix + "Forum_UserExtended])"; System.Data.DataTable dtUsers = DbHelperSQL.Query(strSql).Tables[0]; Model.Forum_Group modelGroup = new BLL.Forum_Group().GetModel("IsDefault=1"); if (dtUsers.Rows.Count != 0) { foreach (System.Data.DataRow row in dtUsers.Rows) { Model.Forum_UserExtended model = UsersDataRowToModel(row); model.GroupId = modelGroup.Id; model.GroupName = modelGroup.Name; Add(model); } } }
private bool DoEdit(int _id) { bool result = false; BLL.Forum_UserExtended bll = new BLL.Forum_UserExtended(); Model.Forum_UserExtended model = bll.GetModel(_id); //编写编辑操作Begin //model.UserId = txtUserId.Text; //model.QQ = txtQQ.Text; //model.MSN = txtMSN.Text; model.Gender = Convert.ToInt32(rblGender.SelectedValue); //model.Birthday = txtBirthday.Text; //model.Bio = txtBio.Text; //model.Address = txtAddress.Text; //model.Site = txtSite.Text; //model.Signature = txtSignature.Text; //model.Nickname = txtNickname.Text; //model.LastPostDateTime = txtLastPostDateTime.Text; model.GroupId = Convert.ToInt32(ddlGroupId.SelectedValue); //model.LastActivity = txtLastActivity.Text; //model.TopicCount = txtTopicCount.Text; //model.PostCount = txtPostCount.Text; //model.PostDigestCount = txtPostDigestCount.Text; //model.Medal = txtMedal.Text; //model.OnlineTime = txtOnlineTime.Text; //model.OnlineUpdateTime = txtOnlineUpdateTime.Text; //model.Verify = txtVerify.Text; //model.Hometown = txtHometown.Text; //model.Nonlocal = txtNonlocal.Text; //model.Specialty = txtSpecialty.Text; model.Credit = Convert.ToInt32(txtCredit.Text); //编写编辑操作End if (bll.Update(model)) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改管理员:" + model.Nickname); //记录日志 result = true; } return(result); }
/// <summary> /// 当前用户是否对标题有权限操作 /// </summary> /// <returns></returns> public bool CheckOperate(int BoardId) { bool bol = false; Model.Forum_UserExtended model = GetOnlineUser(); if (model != null) { Model.Forum_Group modelGroup = new BLL.Forum_Group().GetModel(model.GroupId); if (modelGroup.Type <= 2) { bol = true; } else { bol = new BLL.Forum_Moderator().Exists(BoardId, model.UserId); } } return(bol); }
private bool DoAdd() { Model.Forum_UserExtended model = new Model.Forum_UserExtended(); BLL.Forum_UserExtended bll = new BLL.Forum_UserExtended(); //编写添加操作Begin //model.UserId = txtUserId.Text; //model.QQ = txtQQ.Text; //model.MSN = txtMSN.Text; //model.Gender = txtGender.Text; //model.Birthday = txtBirthday.Text; //model.Bio = txtBio.Text; //model.Address = txtAddress.Text; //model.Site = txtSite.Text; //model.Signature = txtSignature.Text; //model.Nickname = txtNickname.Text; //model.LastPostDateTime = txtLastPostDateTime.Text; //model.GroupId = txtGroupId.Text; //model.LastActivity = txtLastActivity.Text; //model.TopicCount = txtTopicCount.Text; //model.PostCount = txtPostCount.Text; //model.PostDigestCount = txtPostDigestCount.Text; //model.Medal = txtMedal.Text; //model.OnlineTime = txtOnlineTime.Text; //model.OnlineUpdateTime = txtOnlineUpdateTime.Text; //model.Verify = txtVerify.Text; //model.Hometown = txtHometown.Text; //model.Nonlocal = txtNonlocal.Text; //model.Specialty = txtSpecialty.Text; //model.Credit = txtCredit.Text; //编写添加操作End if (bll.Add(model)) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加dt_Forum_UserExtended:" + model.Nickname); //记录日志 return(true); } return(false); }
protected void Page_Load(object sender, EventArgs e) { ChkAdminLevel("plugin_forum_userextended", DTEnums.ActionEnum.View.ToString()); //检查权限 //Model.manager model = GetAdminInfo(); //取得当前管理员信息 if (!int.TryParse(Request.QueryString["id"] as string, out this.id)) { JscriptMsg("传输参数不正确!", "back"); return; } if (!new BLL.Forum_UserExtended().Exists(this.id)) { JscriptMsg("记录不存在或已被删除!", "back"); return; } if (!Page.IsPostBack) { model = new BLL.Forum_UserExtended().GetModel(id); hfTurl.Value = Request.UrlReferrer.ToString(); RptBind();//添加where子句和order子句 } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Forum_UserExtended UsersDataRowToModel(DataRow row) { Model.Forum_UserExtended model = new Model.Forum_UserExtended(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.UserId = int.Parse(row["id"].ToString()); } if (row["nick_name"] != null) { model.Nickname = row["nick_name"].ToString(); } if (row["sex"] != null) { model.Gender = (row["sex"].ToString() == "男" ? 1 : row["sex"].ToString() == "女" ? 0 : -1); } if (row["birthday"] != null && row["birthday"].ToString() != "") { model.Birthday = row["birthday"].ToString(); } if (row["address"] != null) { model.Address = row["address"].ToString(); } if (row["qq"] != null) { model.QQ = row["qq"].ToString(); } if (row["msn"] != null) { model.MSN = row["msn"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Forum_UserExtended model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "Forum_UserExtended set "); strSql.Append(" UserId = @UserId , "); strSql.Append(" QQ = @QQ , "); strSql.Append(" MSN = @MSN , "); strSql.Append(" Gender = @Gender , "); strSql.Append(" Birthday = @Birthday , "); strSql.Append(" Bio = @Bio , "); strSql.Append(" Address = @Address , "); strSql.Append(" Site = @Site , "); strSql.Append(" Signature = @Signature , "); strSql.Append(" Nickname = @Nickname , "); strSql.Append(" LastPostDateTime = @LastPostDateTime , "); strSql.Append(" GroupId = @GroupId , "); strSql.Append(" LastActivity = @LastActivity , "); strSql.Append(" TopicCount = @TopicCount , "); strSql.Append(" PostCount = @PostCount , "); strSql.Append(" PostDigestCount = @PostDigestCount , "); strSql.Append(" Medal = @Medal , "); strSql.Append(" OnlineTime = @OnlineTime , "); strSql.Append(" OnlineUpdateTime = @OnlineUpdateTime , "); strSql.Append(" Verify = @Verify , "); strSql.Append(" Hometown = @Hometown , "); strSql.Append(" Nonlocal = @Nonlocal , "); strSql.Append(" Specialty = @Specialty , "); strSql.Append(" Credit = @Credit, "); strSql.Append(" CreditTotal = @CreditTotal "); strSql.Append(" where UserId=@UserId "); SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@QQ", SqlDbType.NVarChar, 16), new SqlParameter("@MSN", SqlDbType.NVarChar, 32), new SqlParameter("@Gender", SqlDbType.Int, 4), new SqlParameter("@Birthday", SqlDbType.NVarChar, 16), new SqlParameter("@Bio", SqlDbType.NVarChar, 128), new SqlParameter("@Address", SqlDbType.NVarChar, 64), new SqlParameter("@Site", SqlDbType.NVarChar, 128), new SqlParameter("@Signature", SqlDbType.NVarChar, 128), new SqlParameter("@Nickname", SqlDbType.NVarChar, 50), new SqlParameter("@LastPostDateTime", SqlDbType.DateTime), new SqlParameter("@GroupId", SqlDbType.Int, 4), new SqlParameter("@LastActivity", SqlDbType.DateTime), new SqlParameter("@TopicCount", SqlDbType.Int, 4), new SqlParameter("@PostCount", SqlDbType.Int, 4), new SqlParameter("@PostDigestCount", SqlDbType.Int, 4), new SqlParameter("@Medal", SqlDbType.NText), new SqlParameter("@OnlineTime", SqlDbType.Int, 4), new SqlParameter("@OnlineUpdateTime", SqlDbType.DateTime), new SqlParameter("@Verify", SqlDbType.TinyInt, 1), new SqlParameter("@Hometown", SqlDbType.NVarChar, 128), new SqlParameter("@Nonlocal", SqlDbType.NVarChar, 128), new SqlParameter("@Specialty", SqlDbType.NVarChar, 50), new SqlParameter("@Credit", SqlDbType.Money, 8), new SqlParameter("@CreditTotal", SqlDbType.Money, 8) }; parameters[0].Value = model.UserId; parameters[1].Value = model.QQ; parameters[2].Value = model.MSN; parameters[3].Value = model.Gender; parameters[4].Value = model.Birthday; parameters[5].Value = model.Bio; parameters[6].Value = model.Address; parameters[7].Value = model.Site; parameters[8].Value = model.Signature; parameters[9].Value = model.Nickname; parameters[10].Value = model.LastPostDateTime; parameters[11].Value = model.GroupId; parameters[12].Value = model.LastActivity; parameters[13].Value = model.TopicCount; parameters[14].Value = model.PostCount; parameters[15].Value = model.PostDigestCount; parameters[16].Value = model.Medal; parameters[17].Value = model.OnlineTime; parameters[18].Value = model.OnlineUpdateTime; parameters[19].Value = model.Verify; parameters[20].Value = model.Hometown; parameters[21].Value = model.Nonlocal; parameters[22].Value = model.Specialty; parameters[23].Value = model.Credit; parameters[24].Value = model.CreditTotal; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Forum_UserExtended model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.Forum_UserExtended model) { return(dal.Add(model)); }
/// <summary> /// 获取当前在线会员 /// </summary> /// <returns></returns> public Model.Forum_UserExtended GetOnlineUser() { DTcms.Model.users model = GetUserInfo(); if (model != null) { //论坛扩展当前在线用户是否存在 if (HttpContext.Current.Session["SESSION_USER_EXTENDED"] != null) { modelUserExtended = (Model.Forum_UserExtended)HttpContext.Current.Session["SESSION_USER_EXTENDED"]; //论坛与DTcms 是否一致 if (modelUserExtended.UserId != model.id) { modelUserExtended = null; } } if (modelUserExtended == null) { modelUserExtended = new BLL.Forum_UserExtended().GetModel(model.id); if (modelUserExtended != null) { //组名提取 modelUserExtended.GroupName = new BLL.Forum_Group().GetModel(modelUserExtended.GroupId).Name; modelUserExtended.UserName = model.user_name; } else { //新增 modelUserExtended = new Model.Forum_UserExtended(); modelUserExtended.UserId = model.id; modelUserExtended.UserName = model.user_name; modelUserExtended.Nickname = string.IsNullOrEmpty(model.nick_name) ? model.user_name : model.nick_name; modelUserExtended.Birthday = model.birthday.ToString(); modelUserExtended.Credit = 0; modelUserExtended.CreditTotal = 0; modelUserExtended.Gender = ChangeSex(model.sex); modelUserExtended.QQ = model.qq; modelUserExtended.Photo = model.avatar; modelUserExtended.MSN = model.msn; modelUserExtended.GroupId = 0; modelUserExtended.OnlineUpdateTime = System.DateTime.Now; modelUserExtended.OnlineTime = 1; System.Data.DataTable dt = new BLL.Forum_Group().GetList("IsDefault=1").Tables[0]; if (dt.Rows.Count != 0) { modelUserExtended.GroupId = Convert.ToInt32(dt.Rows[0]["id"]); modelUserExtended.GroupName = dt.Rows[0]["Name"].ToString(); } new BLL.Forum_UserExtended().Add(modelUserExtended); Model.Statistic.LastUserNickname = string.IsNullOrEmpty(model.nick_name) ? model.user_name : model.nick_name; Model.Statistic.LastUserId = model.id; } } int _sex = ChangeSex(model.sex); bool bol = false; //性别有改动 if (modelUserExtended.Gender != _sex) { modelUserExtended.Gender = _sex; bol = true; } //昵称有改动 if (modelUserExtended.Nickname != model.nick_name) { if (!string.IsNullOrEmpty(model.nick_name)) { modelUserExtended.Nickname = model.nick_name; bol = true; } } if (bol) { new BLL.Forum_UserExtended().Update(modelUserExtended); } HttpContext.Current.Session["SESSION_USER_EXTENDED"] = modelUserExtended; } else { HttpContext.Current.Session["SESSION_USER_EXTENDED"] = null; modelUserExtended = null; } return(modelUserExtended); }
private void EditorHandler(HttpContext context, string name) { //检查用户是否登录 modelUser = new Page.ForumPage().GetOnlineUser(); if (modelUser == null) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,用户尚未登录或已超时!\"}"); return; } string fieldName = "upfile"; string[] allowExtensions = null; int sizeLimit = 0; switch (name) { case "image": sizeLimit = siteConfig.imgsize; allowExtensions = siteConfig.fileextension.Split(','); break; case "scrawl": sizeLimit = 2048000; allowExtensions = new string[] { ".png" }; break; case "video": sizeLimit = siteConfig.videosize; allowExtensions = siteConfig.videoextension.Split(','); break; case "file": sizeLimit = siteConfig.attachsize; allowExtensions = siteConfig.fileextension.Split(','); break; default: JsonHelper.WriteJson(context, new { status = "参数传输错误!" }); return; } if (sizeLimit <= 0 || allowExtensions.Length == 0) { JsonHelper.WriteJson(context, new { status = "参数传输错误!" }); return; } if (name == "scrawl") { string uploadFileName = Utils.GetRamCode() + ".png"; byte[] uploadFileBytes = Convert.FromBase64String(context.Request[fieldName]); string Url = new UpLoad().GetUpLoadPath() + uploadFileName; string localPath = Utils.GetMapPath(Url); string ErrorMessage = string.Empty; DTEnums.ResultState State = DTEnums.ResultState.Success; try { if (!Directory.Exists(Path.GetDirectoryName(localPath))) { Directory.CreateDirectory(Path.GetDirectoryName(localPath)); } File.WriteAllBytes(localPath, uploadFileBytes); State = DTEnums.ResultState.Success; } catch (Exception e) { State = DTEnums.ResultState.FileAccessError; ErrorMessage = e.Message; } JsonHelper.WriteJson(context, new { state = Utils.GetStateString(State), url = Url, title = uploadFileName, original = uploadFileName, error = ErrorMessage }); } else { context.Response.ContentType = "text/plain"; HttpPostedFile _upfile = context.Request.Files[fieldName]; Model.upLoad model = new UpLoad().fileSaveAs(_upfile, allowExtensions, sizeLimit, false, false, 0, 0); if (model.status > 0) { //{"aid":374,"name":"27.gif","filename":"2016/11/02/4225885467939.gif","isimage":true} Model.Forum_Attachment attModel = new Model.Forum_Attachment(); attModel.IsImage = 1; attModel.Name = model.name; attModel.BoardId = board_id; attModel.TopicId = topic_id; attModel.PostId = post_id; attModel.FileName = model.path; attModel.FileSize = model.size / 1024;; attModel.FileType = model.ext.Replace(".", ""); attModel.UserId = modelUser.UserId; attModel.Id = new BLL.Forum_Attachment().Add(attModel); string callback = context.Request["callback"]; string editorId = context.Request["editorid"]; JsonHelper.WriteJson(context, new { state = "SUCCESS", type = "." + model.ext, size = model.size / 1024, url = model.path, name = model.name, originalName = model.name }); } else { JsonHelper.WriteJson(context, new { status = model.msg }); } } }
public void ProcessRequest(HttpContext context) { //取得处事类型 string action = DTRequest.GetQueryString("action"); modelUser = new Page.ForumPage().GetOnlineUser(); //除了获取会员信息外,所有都需登陆 if (action.ToLower() != "users") { if (modelUser == null) { JsonHelper.WriteJson(context, new { error = 1, description = "超时了,请重新登陆!" }); return; } } //公用 turl = DTRequest.GetString("turl"); board_id = DTRequest.GetFormIntValue("board_id", 0); topic_id = DTRequest.GetFormIntValue("topic_id", 0); post_id = DTRequest.GetFormIntValue("post_id", 0); vc = DTRequest.GetString("vc"); //发贴回贴编辑贴 title = DTRequest.GetString("title"); message = DTRequest.GetString("message"); attachment_ids = DTRequest.GetString("attachment_ids"); signature = DTRequest.GetFormIntValue("signature", 0); autoUrl = DTRequest.GetFormIntValue("AutoUrl", 0); //管理贴 tids = DTRequest.GetString("tids"); rids = DTRequest.GetString("rids"); send_message = DTRequest.GetFormIntValue("send_message", 0); reason = DTRequest.GetString("reason"); user_ids = DTRequest.GetString("user_ids").Replace("'", ""); switch (action) { //新主题 case "create": create(context); break; //编主题 case "update": update(context); break; //新回复 case "reply": reply(context); break; //编回复 case "editor": editor(context); break; //个人删除回复 case "selfdelete": selfdelete(context); break; //个人删除主题 case "selftopicdelete": selftopicdelete(context); break; //获取会员列表 case "users": users(context); break; //金币兑换 case "user_credit_convert": user_credit_convert(context); break; //主题置顶--------------分隔线------------- case "top": top(context); break; //精华设置 case "digest": digest(context); break; //主题设置 case "close": close(context); break; //主题高亮 case "highlight": highlight(context); break; //主题屏蔽 case "ban": ban(context); break; //删除主题 case "delete": delete(context); break; //移动主题 case "move": move(context); break; //主题分类 case "type": type(context); break; //屏蔽回复 case "banreply": banreply(context); break; //批删除回复 case "deletereply": deletereply(context); break; } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Forum_UserExtended DataRowToModel(DataRow row) { if (row != null) { Model.Forum_UserExtended model = new Model.Forum_UserExtended(); if (row["UserId"].ToString() != "") { model.UserId = int.Parse(row["UserId"].ToString()); } model.QQ = row["QQ"].ToString(); model.MSN = row["MSN"].ToString(); if (row["Gender"].ToString() != "") { model.Gender = int.Parse(row["Gender"].ToString()); } model.Birthday = row["Birthday"].ToString(); model.Bio = row["Bio"].ToString(); model.Address = row["Address"].ToString(); model.Site = row["Site"].ToString(); model.Signature = row["Signature"].ToString(); model.Nickname = row["Nickname"].ToString(); if (row["LastPostDateTime"].ToString() != "") { model.LastPostDateTime = DateTime.Parse(row["LastPostDateTime"].ToString()); } if (row["GroupId"].ToString() != "") { model.GroupId = int.Parse(row["GroupId"].ToString()); } if (row["LastActivity"].ToString() != "") { model.LastActivity = DateTime.Parse(row["LastActivity"].ToString()); } if (row["TopicCount"].ToString() != "") { model.TopicCount = int.Parse(row["TopicCount"].ToString()); } if (row["PostCount"].ToString() != "") { model.PostCount = int.Parse(row["PostCount"].ToString()); } if (row["PostDigestCount"].ToString() != "") { model.PostDigestCount = int.Parse(row["PostDigestCount"].ToString()); } model.Medal = row["Medal"].ToString(); if (row["OnlineTime"].ToString() != "") { model.OnlineTime = int.Parse(row["OnlineTime"].ToString()); } if (row["OnlineUpdateTime"].ToString() != "") { model.OnlineUpdateTime = DateTime.Parse(row["OnlineUpdateTime"].ToString()); } if (row["Verify"].ToString() != "") { model.Verify = int.Parse(row["Verify"].ToString()); } model.Hometown = row["Hometown"].ToString(); model.Nonlocal = row["Nonlocal"].ToString(); model.Specialty = row["Specialty"].ToString(); if (row["Credit"].ToString() != "") { model.Credit = decimal.Parse(row["Credit"].ToString()); } if (row["CreditTotal"].ToString() != "") { model.CreditTotal = decimal.Parse(row["CreditTotal"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.Forum_UserExtended model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "Forum_UserExtended("); strSql.Append("UserId,QQ,MSN,Gender,Birthday,Bio,Address,Site,Signature,Nickname,LastPostDateTime,GroupId,LastActivity,TopicCount,PostCount,PostDigestCount,Medal,OnlineTime,OnlineUpdateTime,Verify,Hometown,Nonlocal,Specialty,Credit,CreditTotal"); strSql.Append(") values ("); strSql.Append("@UserId,@QQ,@MSN,@Gender,@Birthday,@Bio,@Address,@Site,@Signature,@Nickname,@LastPostDateTime,@GroupId,@LastActivity,@TopicCount,@PostCount,@PostDigestCount,@Medal,@OnlineTime,@OnlineUpdateTime,@Verify,@Hometown,@Nonlocal,@Specialty,@Credit,@CreditTotal"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@QQ", SqlDbType.NVarChar, 16), new SqlParameter("@MSN", SqlDbType.NVarChar, 32), new SqlParameter("@Gender", SqlDbType.Int, 4), new SqlParameter("@Birthday", SqlDbType.NVarChar, 16), new SqlParameter("@Bio", SqlDbType.NVarChar, 128), new SqlParameter("@Address", SqlDbType.NVarChar, 64), new SqlParameter("@Site", SqlDbType.NVarChar, 128), new SqlParameter("@Signature", SqlDbType.NVarChar, 128), new SqlParameter("@Nickname", SqlDbType.NVarChar, 50), new SqlParameter("@LastPostDateTime", SqlDbType.DateTime), new SqlParameter("@GroupId", SqlDbType.Int, 4), new SqlParameter("@LastActivity", SqlDbType.DateTime), new SqlParameter("@TopicCount", SqlDbType.Int, 4), new SqlParameter("@PostCount", SqlDbType.Int, 4), new SqlParameter("@PostDigestCount", SqlDbType.Int, 4), new SqlParameter("@Medal", SqlDbType.NText), new SqlParameter("@OnlineTime", SqlDbType.Int, 4), new SqlParameter("@OnlineUpdateTime", SqlDbType.DateTime), new SqlParameter("@Verify", SqlDbType.TinyInt, 1), new SqlParameter("@Hometown", SqlDbType.NVarChar, 128), new SqlParameter("@Nonlocal", SqlDbType.NVarChar, 128), new SqlParameter("@Specialty", SqlDbType.NVarChar, 50), new SqlParameter("@Credit", SqlDbType.Money, 8), new SqlParameter("@CreditTotal", SqlDbType.Money, 8) }; parameters[0].Value = model.UserId; parameters[1].Value = model.QQ; parameters[2].Value = model.MSN; parameters[3].Value = model.Gender; parameters[4].Value = model.Birthday; parameters[5].Value = model.Bio; parameters[6].Value = model.Address; parameters[7].Value = model.Site; parameters[8].Value = model.Signature; parameters[9].Value = model.Nickname; parameters[10].Value = model.LastPostDateTime; parameters[11].Value = model.GroupId; parameters[12].Value = model.LastActivity; parameters[13].Value = model.TopicCount; parameters[14].Value = model.PostCount; parameters[15].Value = model.PostDigestCount; parameters[16].Value = model.Medal; parameters[17].Value = model.OnlineTime; parameters[18].Value = model.OnlineUpdateTime; parameters[19].Value = model.Verify; parameters[20].Value = model.Hometown; parameters[21].Value = model.Nonlocal; parameters[22].Value = model.Specialty; parameters[23].Value = model.Credit; parameters[24].Value = model.CreditTotal; int bol = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (bol > 0) { return(true); } else { return(false); } }