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