/// <summary>
/// 续费VIP
/// </summary>
/// <param name="_id">用户ID</param>
/// <param name="_vipyears">续的年数</param>
public void AddVIPYears(string _id, int _vipyears)
{
using (DbOperHandler _doh = new Common().Doh())
{
DateTime LimitDate = DateTime.Now;
_doh.Reset();
_doh.ConditionExpress = "id=" + _id;
object[] values = _doh.GetFields("jcms_normal_user", "IsVIP,VIPTime");
bool _isvip = (JumboTCMS.Utils.Validator.StrToInt(values[0].ToString(), 0) == 1);
if (!_isvip)//如果还不是VIP
LimitDate = DateTime.Now.AddYears(_vipyears);
else
{
if (JumboTCMS.Utils.Validator.ValidDate(values[1].ToString()))//如果已经过期
LimitDate = DateTime.Now.AddYears(_vipyears);
else
LimitDate = DateTime.Parse(values[1].ToString()).AddYears(_vipyears);
}
_doh.Reset();
_doh.ConditionExpress = "id=" + _id;
_doh.AddFieldItem("IsVIP", 1);
_doh.AddFieldItem("VIPTime", LimitDate);
_doh.Update("jcms_normal_user");
}
}
/// <summary>
/// 批量操作插件
/// </summary>
/// <param name="_act">行为</param>
/// <param name="_ids">id，以,隔开</param>
public bool BatchOper(string _act, string _ids)
{
using (DbOperHandler _doh = new Common().Doh())
{
string[] idValue;
idValue = _ids.Split(',');
if (_act == "pass")
{
for (int i = 0; i < idValue.Length; i++)
{
_doh.Reset();
_doh.ConditionExpress = "id=@id";
_doh.AddConditionParameter("@id", idValue[i]);
_doh.AddFieldItem("Enabled", 1);
_doh.Update("jcms_normal_user_oauth");
}
}
else if (_act == "nopass")
{
for (int i = 0; i < idValue.Length; i++)
{
_doh.Reset();
_doh.ConditionExpress = "id=@id";
_doh.AddConditionParameter("@id", idValue[i]);
_doh.AddFieldItem("Enabled", 0);
_doh.Update("jcms_normal_user_oauth");
}
}
}
return true;
}
/// <summary>
/// 得到内容
/// </summary>
/// <param name="_channeltype"></param>
/// <param name="_contentid"></param>
/// <returns></returns>
public Normal_Digg GetDigg(string _channeltype, string _contentid)
{
using (DbOperHandler _doh = new Common().Doh())
{
Normal_Digg digg = new Normal_Digg();
digg.ChannelType = _channeltype;
digg.ContentId = Str2Int(_contentid);
_doh.Reset();
_doh.ConditionExpress = "channeltype=@channeltype and contentid=@contentid";
_doh.AddConditionParameter("@channeltype", _channeltype);
_doh.AddConditionParameter("@contentid", _contentid);
if (!_doh.Exist("jcms_normal_digg"))
{
_doh.Reset();
_doh.AddFieldItem("ChannelType", _channeltype);
_doh.AddFieldItem("ContentId", _contentid);
_doh.AddFieldItem("DiggNum", 0);
_doh.Insert("jcms_normal_digg");
}
_doh.Reset();
_doh.ConditionExpress = "channeltype=@channeltype and contentid=@contentid";
_doh.AddConditionParameter("@channeltype", _channeltype);
_doh.AddConditionParameter("@contentid", _contentid);
digg.DiggNum = Str2Int(_doh.GetField("jcms_normal_digg", "DiggNum").ToString());
return digg;
}
}
/// <summary>
/// 保存用户日志
/// </summary>
/// <param name="_uid">会员ID</param>
/// <param name="_info">保存信息</param>
/// <param name="_type">操作类型,1=分组移动,2=扣除博币,3=积分增加(2,3为系统操作),4=增加博币,5=VIP升级,6积分扣除(4,5,6为管理员操作)</param>
public void SaveLog(string _uid, string _info, int _type)
{
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.AddFieldItem("UserId", _uid);
_doh.AddFieldItem("OperInfo", _info);
_doh.AddFieldItem("OperType", _type);
_doh.AddFieldItem("OperTime", DateTime.Now.ToString());
_doh.AddFieldItem("OperIP", IPHelp.ClientIP);
_doh.Insert("jcms_normal_user_logs");
}
}
/// <summary>
/// 批量操作插件
/// </summary>
/// <param name="_act">行为</param>
/// <param name="_ids">id，以,隔开</param>
public bool BatchOper(string _act, string _ids)
{
using (DbOperHandler _doh = new Common().Doh())
{
string[] idValue;
idValue = _ids.Split(',');
if (_act == "pass")
{
for (int i = 0; i < idValue.Length; i++)
{
_doh.Reset();
_doh.ConditionExpress = "id=@id";
_doh.AddConditionParameter("@id", idValue[i]);
_doh.AddFieldItem("Enabled", 1);
_doh.Update("jcms_normal_extends");
}
}
else if (_act == "nopass")
{
for (int i = 0; i < idValue.Length; i++)
{
_doh.Reset();
_doh.ConditionExpress = "id=@id";
_doh.AddConditionParameter("@id", idValue[i]);
_doh.AddFieldItem("Enabled", 0);
_doh.Update("jcms_normal_extends");
}
}
string TempStr = "";
_doh.Reset();
_doh.SqlCmd = JumboTCMS.Utils.SqlHelp.GetSql("[Title],[Name],[Type],[Enabled]", "jcms_normal_extends", "pId", 100, 1, "desc", "");
DataTable dt = _doh.GetDataTable();
for (int i = 0; i < dt.Rows.Count; i++)
{
if(dt.Rows[i]["Enabled"].ToString() =="1")
TempStr += "\r\nvar Plugin" + dt.Rows[i]["Name"].ToString() + " = true;//" + dt.Rows[i]["Title"].ToString() + "插件";
else
TempStr += "\r\nvar Plugin" + dt.Rows[i]["Name"].ToString() + " = false;//" + dt.Rows[i]["Title"].ToString() + "插件";
}
string _globalJS = JumboTCMS.Utils.DirFile.ReadFile("~/_data/jcmsV5.js");
string _strBegin = "//<!--插件开关begin";
string _strEnd = "//-->插件开关end";
System.Collections.ArrayList TagArray = JumboTCMS.Utils.Strings.GetHtmls(_globalJS, _strBegin, _strEnd, true, true);
if (TagArray.Count > 0)//标签存在
{
_globalJS = _globalJS.Replace(TagArray[0].ToString(), _strBegin + "\r\n\r\n" + TempStr + "\r\n\r\n" + _strEnd);
}
JumboTCMS.Utils.DirFile.SaveFile(_globalJS, "~/_data/jcmsV5.js");
}
return true;
}
/// <summary>
/// 新增购物车商品信息
/// </summary>
/// <param name="_cart"></param>
/// <returns></returns>
public int NewGoods(JumboTCMS.Entity.Normal_UserCart _cart)
{
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.AddFieldItem("UserId", _cart.UserId);
_doh.AddFieldItem("ProductId", _cart.ProductId);
_doh.AddFieldItem("ProductLink", _cart.ProductLink);
_doh.AddFieldItem("BuyCount", _cart.BuyCount);
_doh.AddFieldItem("State", 0);
_doh.AddFieldItem("CartTime", DateTime.Now.ToString());
int _newid = _doh.Insert("jcms_normal_user_cart");
return _newid;
}
}
/// <summary>
/// 加为好友，如果已经存在返回false
/// </summary>
/// <param name="_userid">主动方ID</param>
/// <param name="_username">主动方name</param>
/// <param name="_friendid">被动方ID</param>
/// <returns></returns>
public bool AddFriend(string _userid, string _username, string _friendid)
{
if (Exists(_userid, _friendid)) return false;//已经存在
_username = _username == "" ? "user(id:" + _userid + ")" : _username;
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.AddFieldItem("FriendId", _friendid);
_doh.AddFieldItem("UserId", _userid);
_doh.AddFieldItem("AddDate", DateTime.Now.ToString());
_doh.Insert("jcms_normal_user_friends");
new JumboTCMS.DAL.Normal_UserNoticeDAL().SendNotite("加好友", "<a href=\"javascript:void(0);\" onclick=\"ShowUserPage(" + _userid + ");\">" + _username + "</a> 把你加为了好友", _friendid, "friend");
}
return true;
}
/// <summary>
/// 发站内通知
/// </summary>
/// <param name="_Title">标题</param>
/// <param name="_Content">内容</param>
/// <param name="_ReceiveUserId">接收人ID,0表示所有人</param>
/// <param name="_NoticeType">类型，比如：friend</param>
public bool SendNotite(string _Title, string _Content, string _ReceiveUserId, string _NoticeType)
{
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.AddFieldItem("Title", _Title);
_doh.AddFieldItem("AddDate", DateTime.Now.ToString());
_doh.AddFieldItem("Content", _Content);
_doh.AddFieldItem("UserId", _ReceiveUserId);
_doh.AddFieldItem("NoticeType", _NoticeType);
_doh.AddFieldItem("State", 0);
_doh.AddFieldItem("ReadTime", DateTime.Now.ToString());
_doh.Insert("jcms_normal_user_notice");
return true;
}
}
/// <summary>
/// 新增充值信息
/// </summary>
/// <param name="_uid"></param>
/// <param name="_points">博币</param>
/// <param name="_payway">如：alipay、tenpay等</param>
/// <returns></returns>
public string NewOrder(string _uid, int _points, string _payway)
{
using (DbOperHandler _doh = new Common().Doh())
{
string _ordernum = GetProductOrderNum();//订单号
_doh.Reset();
_doh.AddFieldItem("UserId", _uid);
_doh.AddFieldItem("OrderNum", _ordernum);
_doh.AddFieldItem("Points", _points);
_doh.AddFieldItem("State", 0);
_doh.AddFieldItem("PaymentWay", _payway);
_doh.AddFieldItem("OrderTime", DateTime.Now.ToString());
_doh.AddFieldItem("OrderIP", IPHelp.ClientIP);
_doh.Insert("jcms_normal_recharge");
return _ordernum;
}
}
/// <summary>
/// 发站内短信
/// </summary>
/// <param name="_Title">标题</param>
/// <param name="_Content">内容</param>
/// <param name="_SendUserId">发送人ID</param>
/// <param name="_ReceiveUserId">接收人ID,多个用逗号隔开</param>
/// <param name="_ReceiveUserName">接收人用户名,多个用逗号隔开</param>
public bool SendMessage(string _Title, string _Content, string _SendUserId, string _ReceiveUserId, string _ReceiveUserName)
{
using (DbOperHandler _doh = new Common().Doh())
{
string[] _uId = _ReceiveUserId.Split(',');
string[] _uName = _ReceiveUserName.Split(',');
for (int i = 0; i < _uId.Length; i++)
{
_doh.Reset();
_doh.AddFieldItem("Title", _Title);
_doh.AddFieldItem("AddDate", DateTime.Now.ToString());
_doh.AddFieldItem("Content", _Content);
_doh.AddFieldItem("SendIP", IPHelp.ClientIP);
_doh.AddFieldItem("SendUserId", _SendUserId);
_doh.AddFieldItem("ReceiveUserId", _uId[i]);
_doh.AddFieldItem("ReceiveUserName", _uName[i]);
_doh.AddFieldItem("State", 0);
_doh.Insert("jcms_normal_user_message");
}
return true;
}
}
/// <summary>
/// 插入GUID
/// </summary>
/// <param name="_id"></param>
public string InsertGUID(string _id, DbOperHandler doh)
{
using (DbOperHandler _doh = new Common().Doh())
{
string _guid = "";
_doh.Reset();
_doh.SqlCmd = "SELECT [GUID] FROM [jcms_normal_user] WHERE [Id]=" + _id;
DataTable dt = _doh.GetDataTable();
if (dt.Rows.Count > 0)
{
_guid = dt.Rows[0][0].ToString();
}
if (_guid.Length != 36)
{
_guid = Guid.NewGuid().ToString();
_doh.ConditionExpress = "id=" + _id;
_doh.AddFieldItem("guid", _guid);
_doh.Update("jcms_normal_user");
}
return _guid;
}
}
/// <summary>
/// 更新购物车商品信息
/// </summary>
/// <param name="_productid">根据产品查询</param>
/// <param name="_buycount"></param>
/// <param name="_state">1表示状态发生了变化</param>
/// <returns></returns>
public bool UpdateGoods(string _uid, string _productid, int _buycount, int _state)
{
using (DbOperHandler _doh = new Common().Doh())
{
int _num = 0;
if (_state == 0)
{
_doh.Reset();
_doh.ConditionExpress = "ProductId=" + _productid + " and state=0 and userid=" + _uid;
_doh.AddFieldItem("BuyCount", _buycount);
_doh.AddFieldItem("CartTime", DateTime.Now.ToString());
_num = _doh.Update("jcms_normal_user_cart");
}
else if (_state == 1)
{
_doh.Reset();
_doh.ConditionExpress = "ProductId=" + _productid + " and state=1 and userid=" + _uid;
_doh.AddFieldItem("State", 1);
_num = _doh.Update("jcms_normal_user_cart");
}
return (_num == 1);
}
}
public int Register(string _username, string _nickname, string _userpass, bool isMD5Passwd, int _sex, string _email, string _birthday, string _usersign, string _adminname, string _adminpass, string _oauth_code, string _oauth_token)
{
if (_oauth_code == "") _oauth_code = "tencent";
if (Exists(string.Format("username='******'", _username)))
return 0;
using (DbOperHandler _doh = new Common().Doh())
{
string _md5pass = isMD5Passwd ? _userpass : JumboTCMS.Utils.MD5.Lower32(_userpass);
string _md5pass2 = isMD5Passwd ? _adminpass : JumboTCMS.Utils.MD5.Lower32(_adminpass);
int dPoints = Str2Int(JumboTCMS.Utils.XmlCOM.ReadConfig("~/_data/config/site", "DefaultPoints"), 0);
int uState = site.CheckReg ? 0 : 1;
object[,] addFields = new object[2, 19] {
{
"UserName", "NickName", "UserPass", "Sex", "Email", "Birthday",
"Group", "Points", "Login", "State", "AdminId", "Setting", "UserSign",
"AdminState", "IsVIP", "Integral","RegTime", "RegIp","Token_"+_oauth_code},
{
_username, _nickname, _md5pass, _sex,_email, _birthday,
1, dPoints, 0, uState,0, ",,", _usersign,
0,0, 0, DateTime.Now.ToString(),IPHelp.ClientIP,_oauth_token}
};
_doh.Reset();
_doh.AddFieldItems(addFields);
int _uID = _doh.Insert("jcms_normal_user");
#region 复制头像
JumboTCMS.Utils.DirFile.CopyFile("~/_data/avatar/0_l.jpg", "~/_data/avatar/" + _uID + "_l.jpg", true);
JumboTCMS.Utils.DirFile.CopyFile("~/_data/avatar/0_m.jpg", "~/_data/avatar/" + _uID + "_m.jpg", true);
JumboTCMS.Utils.DirFile.CopyFile("~/_data/avatar/0_s.jpg", "~/_data/avatar/" + _uID + "_s.jpg", true);
#endregion
#region 同步升级为管理员
if (_adminname.Length > 0 && _adminpass.Length > 0)
{
_doh.Reset();
_doh.ConditionExpress = "id=" + _uID;
_doh.AddFieldItem("State", 1);
_doh.AddFieldItem("AdminState", 1);
_doh.AddFieldItem("AdminId", _uID);
_doh.AddFieldItem("AdminName", _adminname);
_doh.AddFieldItem("AdminPass", _md5pass2);
_doh.AddFieldItem("Group", site.AdminGroupId);
_doh.Update("jcms_normal_user");
_doh.Reset();
_doh.ConditionExpress = "id=" + site.AdminGroupId;
_doh.Add("jcms_normal_usergroup", "UserTotal");
}
else
{
_doh.Reset();
_doh.ConditionExpress = "id=1";
_doh.Add("jcms_normal_usergroup", "UserTotal");
}
#endregion
#region 论坛同步注册
if (site.ForumAPIKey != "")
{
string _ForumAutoRegister = JumboTCMS.Utils.XmlCOM.ReadConfig("~/_data/config/site", "ForumAutoRegister");
if (_ForumAutoRegister == "true")//表示自动注册论坛用户
{
JumboTCMS.API.Discuz.Toolkit.DiscuzSession ds = JumboTCMS.API.Discuz.DiscuzSessionHelper.GetSession();
int _userid = ds.Register(_username, _userpass, _email, isMD5Passwd);
if (_userid > 0)
{
//注册成功
_doh.Reset();
_doh.ConditionExpress = "id=" + _uID;
_doh.AddFieldItem("ForumName", _username);
_doh.AddFieldItem("ForumPass", _md5pass);
_doh.Update("jcms_normal_user");
return _uID;
}
return 0;
}
return _uID;
}
#endregion
return _uID;
}
}
/// <summary>
/// 自动增添Tag标签到数据库
/// </summary>
/// <param name="_channelid">频道ID</param>
/// <param name="_tags">要增加的Tag，多个Tag以,隔开</param>
public void InsertTags(string _channelid, string _tags)
{
using (DbOperHandler _doh = new Common().Doh())
{
if (_tags.Length == 0) return;
string[] tag = _tags.Split(',');
for (int i = 0; i < tag.Length; i++)
{
if (!ExistTitle(tag[i].ToString(), "0", "ChannelId=" + _channelid))
{
_doh.Reset();
_doh.AddFieldItem("Title", tag[i].ToString());
_doh.AddFieldItem("ClickTimes", "0");
_doh.AddFieldItem("ChannelId", _channelid);
_doh.Insert("jcms_normal_tag");
}
}
}
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="_id">用户ID</param>
/// <param name="_pass">修改后的密码</param>
public void ChangePsd(string _id, string _pass)
{
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.ConditionExpress = "id=" + _id;
_doh.AddFieldItem("UserPass", _pass);
_doh.Update("jcms_normal_user");
}
}
/// <summary>
/// 移动
/// </summary>
/// <param name="_id"></param>
/// <param name="_isup">true代表向上移动</param>
/// <param name="_response"></param>
/// <returns></returns>
public bool Move(string _id, bool _isup, ref string _response)
{
using (DbOperHandler _doh = new Common().Doh())
{
if (_id == "0")
{
_response = "ID错误";
return false;
}
_doh.Reset();
_doh.ConditionExpress = "id=@id";
_doh.AddConditionParameter("@id", _id);
string pId = _doh.GetField("jcms_normal_user_oauth", "pId").ToString();
string temp;
_doh.Reset();
if (_isup)
{
_doh.ConditionExpress = "pId<@pId ORDER BY pId desc";
_doh.AddConditionParameter("@pId", pId);
}
else
{
_doh.ConditionExpress = "pId>@pId ORDER BY pId";
_doh.AddConditionParameter("@pId", pId);
}
temp = _doh.GetField("jcms_normal_user_oauth", "pId").ToString();
if (temp == "")
{
_response = "无须移动";
return false;
}
else
{
_doh.Reset();
_doh.ConditionExpress = "pId=@pId";
_doh.AddConditionParameter("@pId", temp);
_doh.AddFieldItem("pId", "-100000");
_doh.Update("jcms_normal_user_oauth");
_doh.Reset();
_doh.ConditionExpress = "id=@id";
_doh.AddConditionParameter("@id", _id);
_doh.AddFieldItem("pId", temp);
_doh.Update("jcms_normal_user_oauth");
_doh.Reset();
_doh.ConditionExpress = "pId=@pId";
_doh.AddConditionParameter("@pId", "-100000");
_doh.AddFieldItem("pId", pId);
_doh.Update("jcms_normal_user_oauth");
}
return true;
}
}
/// <summary>
/// 新增订单信息
/// </summary>
/// <param name="_uid"></param>
/// <param name="_truename"></param>
/// <param name="_address"></param>
/// <param name="_zipcode"></param>
/// <param name="_mobiletel"></param>
/// <returns></returns>
public bool NewOrder(string _uid, string _truename, string _address, string _zipcode, string _mobiletel)
{
using (DbOperHandler _doh = new Common().Doh())
{
string _ordernum = GetProductOrderNum();//订单号
int page = 1;
int PSize = 1000;
int countNum = 0;
string sqlStr = "";
string joinStr = "A.[ProductId]=B.Id";
string whereStr1 = "A.State=0 AND A.UserId=" + _uid;
string whereStr2 = "State=0 AND UserId=" + _uid;
_doh.Reset();
_doh.ConditionExpress = whereStr2;
countNum = _doh.Count("jcms_normal_user_cart");
sqlStr = JumboTCMS.Utils.SqlHelp.GetSql("A.*,b.points as unitprice,(b.points*a.buycount) as totalprice,b.id as productid,b.title as productname,b.img as productimg", "jcms_normal_user_cart", "jcms_module_product", "Id", PSize, page, "desc", joinStr, whereStr1, whereStr2);
_doh.Reset();
_doh.SqlCmd = sqlStr;
DataTable dt = _doh.GetDataTable();
if (dt.Rows.Count == 0)
return false;
float _money = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
JumboTCMS.Entity.Normal_UserGoods _goods = new JumboTCMS.Entity.Normal_UserGoods();
_goods.UserId = Str2Int(_uid);
_goods.OrderNum = _ordernum;
_goods.ProductId = Str2Int(dt.Rows[i]["ProductId"].ToString());
_goods.ProductName = dt.Rows[i]["ProductName"].ToString();
_goods.ProductImg = dt.Rows[i]["ProductImg"].ToString();
_goods.ProductLink = dt.Rows[i]["ProductLink"].ToString();
_goods.UnitPrice = Convert.ToSingle(dt.Rows[i]["UnitPrice"].ToString());
_goods.BuyCount = Str2Int(dt.Rows[i]["BuyCount"].ToString());
_goods.TotalPrice = Convert.ToSingle(dt.Rows[i]["TotalPrice"].ToString());
new JumboTCMS.DAL.Normal_UserGoodsDAL().NewGoods(_goods);
_money += _goods.TotalPrice;
}
dt.Clear();
dt.Dispose();
_doh.Reset();
_doh.AddFieldItem("UserId", _uid);
_doh.AddFieldItem("OrderNum", _ordernum);
_doh.AddFieldItem("TrueName", _truename);
_doh.AddFieldItem("Address", _address);
_doh.AddFieldItem("ZipCode", _zipcode);
_doh.AddFieldItem("MobileTel", _mobiletel);
_doh.AddFieldItem("Money", _money);
_doh.AddFieldItem("State", 0);
_doh.AddFieldItem("OrderTime", DateTime.Now.ToString());
_doh.AddFieldItem("OrderIP", IPHelp.ClientIP);
_doh.Insert("jcms_normal_user_order");
_doh.Reset();
_doh.SqlCmd = string.Format("UPDATE [jcms_normal_user_cart] SET [State]=1 WHERE UserId={0}", _uid);
_doh.ExecuteSqlNonQuery();
return true;
}
}
/// <summary>
/// 新增购物信息
/// </summary>
/// <param name="_goods"></param>
/// <returns></returns>
public int NewGoods(JumboTCMS.Entity.Normal_UserGoods _goods)
{
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.AddFieldItem("UserId", _goods.UserId);
_doh.AddFieldItem("OrderNum", _goods.OrderNum);
_doh.AddFieldItem("ProductId", _goods.ProductId);
_doh.AddFieldItem("ProductName", _goods.ProductName);
_doh.AddFieldItem("ProductImg", _goods.ProductImg);
_doh.AddFieldItem("ProductLink", _goods.ProductLink);
_doh.AddFieldItem("UnitPrice", _goods.UnitPrice);
_doh.AddFieldItem("BuyCount", _goods.BuyCount);
_doh.AddFieldItem("TotalPrice", _goods.TotalPrice);
_doh.AddFieldItem("State", 0);
_doh.AddFieldItem("GoodsTime", DateTime.Now.ToString());
int _newid = _doh.Insert("jcms_normal_user_goods");
return _newid;
}
}
/// <summary>
/// 内容加入专题
/// </summary>
/// <param name="_specialid">专题ID</param>
/// <param name="_channelid">频道ID</param>
/// <param name="_channeltype">频道类型，也就是内容的模型</param>
/// <param name="_contentids">内容ID，以,隔开</param>
public bool Move2Special(int _specialid, string _channelid, string _channeltype, string _contentids)
{
using (DbOperHandler _doh = new Common().Doh())
{
string _contentid = string.Empty;
string _title = string.Empty;
_doh.Reset();
_doh.SqlCmd = "SELECT [Id],[Title] FROM [jcms_module_" + _channeltype + "] WHERE [ChannelId]=" + _channelid + " AND [Id] In (" + _contentids + ")";
DataTable dt = _doh.GetDataTable();
for (int i = 0; i < dt.Rows.Count; i++)
{
_contentid = dt.Rows[i]["Id"].ToString();
_title = dt.Rows[i]["Title"].ToString();
_doh.Reset();
_doh.ConditionExpress = "sid=@sid and contentid=@contentid and channelid=@channelid";
_doh.AddConditionParameter("@sid", _specialid);
_doh.AddConditionParameter("@contentid", _contentid);
_doh.AddConditionParameter("@channelid", _channelid);
if (!_doh.Exist("jcms_normal_specialcontent"))
{
_doh.Reset();
_doh.AddFieldItem("Title", _title);
_doh.AddFieldItem("sId", _specialid);
_doh.AddFieldItem("ChannelId", _channelid);
_doh.AddFieldItem("ContentId", _contentid);
_doh.Insert("jcms_normal_specialcontent");
}
}
}
return true;
}
/// <summary>
/// 更新起/始IP整型值
/// </summary>
/// <param name="_id">编号</param>
/// <param name="_startip">开始IP</param>
/// <param name="_endip">结束IP</param>
public bool UpdateIPData(string _id, string _startip, string _endip)
{
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.ConditionExpress = "id=@id";
_doh.AddConditionParameter("@id", _id);
_doh.AddFieldItem("StartIP", JumboTCMS.Utils.IPHelp.IP2Long(System.Net.IPAddress.Parse(_startip)));
_doh.AddFieldItem("EndIP", JumboTCMS.Utils.IPHelp.IP2Long(System.Net.IPAddress.Parse(_endip)));
_doh.AddFieldItem("Enabled", 1);
int _update = _doh.Update("jcms_normal_forbidip");
return (_update == 1);
}
}
/// <summary>
/// 在线支付成功，给会员充博币
/// </summary>
/// <param name="_uid"></param>
/// <param name="_ordernum"></param>
/// <param name="_payway">如：支付宝、财付通等</param>
/// <returns></returns>
public bool UpdateOrder(string _uid, string _ordernum, string _payway)
{
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.ConditionExpress = "OrderNum='" + _ordernum + "' and state=0 and userid=" + _uid;
int _points = Str2Int(_doh.GetField("jcms_normal_recharge", "Points").ToString());
if (_points > 0)//充值的博币
{
new Normal_UserDAL().AddPoints(_uid, _points);
_doh.Reset();
_doh.ConditionExpress = "OrderNum='" + _ordernum + "' and state=0 and userid=" + _uid;
_doh.AddFieldItem("State", 1);
_doh.AddFieldItem("PaymentWay", _payway);
_doh.Update("jcms_normal_recharge");
return true;
}
else
{
return false;
}
}
}
/// <summary>
/// 修改指定用户的密码
/// </summary>
/// <param name="_userid"></param>
/// <param name="_originalPassword">原始密码</param>
/// <param name="_newPassword">新密码</param>
/// <returns></returns>
public bool ChangeUserPassword(string _userid, string _originalPassword, string _newPassword)
{
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.ConditionExpress = "id=@id and state=1";
_doh.AddConditionParameter("@id", _userid);
object pass = _doh.GetField("jcms_normal_user", "UserPass");
if (pass != null)//用户存在
{
if (pass.ToString().ToLower() == JumboTCMS.Utils.MD5.Lower32(_originalPassword) || pass.ToString().ToLower() == JumboTCMS.Utils.MD5.Lower16(_originalPassword)) //验证旧密码
{
_doh.Reset();
_doh.ConditionExpress = "id=@id and state=1";
_doh.AddConditionParameter("@id", _userid);
_doh.AddFieldItem("UserPass", JumboTCMS.Utils.MD5.Lower32(_newPassword));
_doh.Update("jcms_normal_user");
return true;
}
else
return false;
}
else
return false;
}
}
/// <summary>
/// 安装插件
/// </summary>
/// <param name="_name"></param>
/// <param name="_response">返回信息</param>
public bool Install(string _name, ref string _response)
{
if (!JumboTCMS.Utils.DirFile.FileExists(site.Dir + "extends/" + _name + "/install.config"))
{
_response = "插件的安装文件损坏或不存在";
return false;
}
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.ConditionExpress = "1=1";
int pId = _doh.MaxValue("jcms_normal_extends", "pId");
string _Title = JumboTCMS.Utils.XmlCOM.ReadConfig(site.Dir + "extends/" + _name + "/install", "Title");
string _Author = JumboTCMS.Utils.XmlCOM.ReadConfig(site.Dir + "extends/" + _name + "/install", "Author");
string _Info = JumboTCMS.Utils.XmlCOM.ReadConfig(site.Dir + "extends/" + _name + "/install", "Info");
string _Type = JumboTCMS.Utils.XmlCOM.ReadConfig(site.Dir + "extends/" + _name + "/install", "Type");
string _BaseTable = JumboTCMS.Utils.XmlCOM.ReadConfig(site.Dir + "extends/" + _name + "/install", "BaseTable");
string _ManageUrl = JumboTCMS.Utils.XmlCOM.ReadConfig(site.Dir + "extends/" + _name + "/install", "ManageUrl");
int _Locked = JumboTCMS.Utils.Validator.StrToInt(JumboTCMS.Utils.XmlCOM.ReadConfig(site.Dir + "extends/" + _name + "/install", "Locked"), 0);
if (_BaseTable != "")//需要安装数据库
{
string _SqlScriptText = JumboTCMS.Utils.XmlCOM.ReadConfig(site.Dir + "extends/" + _name + "/install", "SqlScript" + base.DBType);
string _SqlScriptFile = site.Dir + "extends/" + _name + "/install.sql";
JumboTCMS.Utils.DirFile.SaveFile(_SqlScriptText, _SqlScriptFile);
if (!ExecuteSqlInFile(HttpContext.Current.Server.MapPath(_SqlScriptFile)))
{
_response = "数据表创建有误,可能已存在";
return false;
}
}
_doh.Reset();
_doh.AddFieldItem("Title", _Title);
_doh.AddFieldItem("Name", _name);
_doh.AddFieldItem("Author", _Author);
_doh.AddFieldItem("Info", _Info);
_doh.AddFieldItem("Type", _Type);
_doh.AddFieldItem("BaseTable", _BaseTable);
_doh.AddFieldItem("ManageUrl", _ManageUrl);
_doh.AddFieldItem("Locked", _Locked);
_doh.AddFieldItem("Enabled", 0);
_doh.AddFieldItem("pId", pId + 1);
_doh.Insert("jcms_normal_extends");
_response = "插件安装成功";
}
return true;
}
/// <summary>
/// 会员登录
/// </summary>
/// <param name="_username"></param>
/// <param name="_userpass"></param>
/// <param name="iExpires"></param>
/// <param name="isMD5Passwd"></param>
/// <returns></returns>
public string ChkUserLogin(string _username, string _userpass, int iExpires, bool isMD5Passwd)
{
if (!isMD5Passwd)
_userpass = JumboTCMS.Utils.MD5.Lower32(_userpass);
using (DbOperHandler _doh = new Common().Doh())
{
_username = _username.Replace("\'", "");
_doh.Reset();
_doh.ConditionExpress = "username=@username";
_doh.AddConditionParameter("@username", _username);
string _userid = _doh.GetField("jcms_normal_user", "id").ToString();
if (_userid != "")
{
JumboTCMS.Entity.Normal_User _User = new JumboTCMS.DAL.Normal_UserDAL().GetEntity(_userid);
if (_User.UserPass != _userpass)
{
return "密码错误";
}
if (_User.State != 1)
{
return "帐号被锁定";
}
_doh.Reset();
_doh.SqlCmd = "SELECT [id],[GroupName],[IsLogin],[Setting] FROM [jcms_normal_usergroup] WHERE [Id]=" + _User.Group;
DataTable dtUserGroup = _doh.GetDataTable();
if (dtUserGroup.Rows.Count == 0)
{
return "用户组有误";
}
if (dtUserGroup.Rows[0]["IsLogin"].ToString() != "1")
{
return "帐号禁止登录";
}
string _userGroupid = dtUserGroup.Rows[0]["Id"].ToString();
string _userGroupname = dtUserGroup.Rows[0]["GroupName"].ToString();
string _userSetting = dtUserGroup.Rows[0]["Setting"].ToString();
dtUserGroup.Clear();
dtUserGroup.Dispose();
string _userCookies = "c" + (new Random().Next(10000000, 99999999)).ToString();
//设置Cookies
System.Collections.Specialized.NameValueCollection myCol = new System.Collections.Specialized.NameValueCollection();
myCol.Add("id", _userid);
myCol.Add("name", _User.UserName);
myCol.Add("nickname", _User.NickName);
myCol.Add("password", _User.UserPass);
myCol.Add("email", _User.Email);
myCol.Add("groupid", _userGroupid);
myCol.Add("groupname", _userGroupname);
myCol.Add("setting", _userSetting);
myCol.Add("cookies", _userCookies);
JumboTCMS.Utils.Cookie.SetObj(site.CookiePrev + "user", 60 * 60 * 24 * iExpires, myCol, site.CookieDomain, site.CookiePath);
//更新User登陆信息
_doh.Reset();
_doh.ConditionExpress = "id=@id and state=1";
_doh.AddConditionParameter("@id", _userid);
_doh.AddFieldItem("Cookies", _userCookies);
_doh.AddFieldItem("LastTime", DateTime.Now.ToString());
_doh.AddFieldItem("LastIP", IPHelp.ClientIP);
_doh.AddFieldItem("UserSign", "");
_doh.Update("jcms_normal_user");
if (site.ForumAPIKey != "")
{
bool _AutoLogining = false;
string _ForumAutoRegister = JumboTCMS.Utils.XmlCOM.ReadConfig("~/_data/config/site", "ForumAutoRegister");
if (_ForumAutoRegister == "true")//表示自动注册论坛用户
_AutoLogining = true;
if (_AutoLogining == true)
{
//登陆社区
_doh.Reset();
_doh.ConditionExpress = "id=@id and state=1";
_doh.AddConditionParameter("@id", _userid);
object[] _forumInfo = _doh.GetFields("jcms_normal_user", "ForumName,ForumPass");
if (_forumInfo[0].ToString().Length > 0 && _forumInfo[1].ToString().Length > 0)
{
JumboTCMS.API.Discuz.Toolkit.DiscuzSession ds = JumboTCMS.API.Discuz.DiscuzSessionHelper.GetSession();
ds.Login(ds.GetUserID(_forumInfo[0].ToString()), _forumInfo[1].ToString(), true, iExpires, site.CookieDomain);
}
}
}
return "ok";
}
else
{
return "帐号不存在";
}
}
}
/// <summary>
/// 更新购物信息
/// </summary>
/// <param name="_uid"></param>
/// <param name="_ids"></param>
/// <param name="_ordernum"></param>
/// <param name="_state"></param>
/// <returns></returns>
public int UpdateGoods(string _uid, string _ids, int _state)
{
using (DbOperHandler _doh = new Common().Doh())
{
int _num = 0;
if (_state == 1)
{
_doh.Reset();
_doh.ConditionExpress = "Id in (" + _ids + ") and state=0 and userid=" + _uid;
_doh.AddFieldItem("State", 1);
_num = _doh.Update("jcms_normal_user_goods");
}
else if (_state == 2)
{
_doh.Reset();
_doh.ConditionExpress = "Id in (" + _ids + ") and state=1 and userid=" + _uid;
_doh.AddFieldItem("State", 2);
_num = _doh.Update("jcms_normal_user_goods");
}
return _num;
}
}
/// <summary>
/// 保存发信日志
/// </summary>
/// <param name="_adminid">管理员ID</param>
/// <param name="_title">发信标题</param>
/// <param name="_users">发信收信人</param>
public void SaveLog(string _adminid, string _title, string _users)
{
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.AddFieldItem("AdminId", _adminid);
_doh.AddFieldItem("SendTitle", _title);
_doh.AddFieldItem("SendUsers", _users);
_doh.AddFieldItem("SendTime", DateTime.Now.ToString());
_doh.AddFieldItem("SendIP", IPHelp.ClientIP);
_doh.Insert("jcms_normal_emaillogs");
}
}
/// <summary>
/// 更新订单
/// </summary>
/// <param name="_uid"></param>
/// <param name="_ordernum">通过订单号棋查询</param>
/// <param name="_state">1表示付款；2表示交易完成(货收到了)</param>
/// <param name="_payway">如：alipay、tenpay等</param>
/// <returns></returns>
public int UpdateOrder(string _uid, string _ordernum, int _state, string _payway)
{
using (DbOperHandler _doh = new Common().Doh())
{
int _num = 0;
if (_state == 1)
{
_doh.Reset();
_doh.ConditionExpress = "OrderNum='" + _ordernum + "' and state=0 and userid=" + _uid;
_doh.AddFieldItem("State", 1);
_doh.AddFieldItem("PaymentWay", _payway);
_num = _doh.Update("jcms_normal_user_order");
}
else if (_state == 2)
{
_doh.Reset();
_doh.ConditionExpress = "OrderNum='" + _ordernum + "' and state=1 and userid=" + _uid;
_doh.AddFieldItem("State", 2);
_num = _doh.Update("jcms_normal_user_order");
}
return _num;
}
}
