C# Common.GetField方法代码示例

        /// <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 = "[email protected] and [email protected]";
                _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 = "[email protected] and [email protected]";
                _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"></param>
 /// <returns></returns>
 public int GetGoodsCount(string _uid, string _productid)
 {
     using (DbOperHandler _doh = new Common().Doh())
     {
         _doh.Reset();
         _doh.ConditionExpress = "state=0 and UserId=" + _uid + " and ProductId=" + _productid;
         return Str2Int(_doh.GetField("jcms_normal_user_cart", "BuyCount").ToString());
     }
 }

 /// <summary>
 /// 获得订单的总金额
 /// </summary>
 /// <param name="_uid"></param>
 /// <param name="_ordernum"></param>
 /// <returns></returns>
 public float GetOrderMoney(string _uid, string _ordernum)
 {
     using (DbOperHandler _doh = new Common().Doh())
     {
         _doh.Reset();
         _doh.ConditionExpress = "OrderNum='" + _ordernum + "' and userid=" + _uid;
         return Convert.ToSingle(_doh.GetField("jcms_normal_user_order", "Money").ToString());
     }
 }

 /// <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="_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 = "[email protected]";
                _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 = "[email protected]";
                    _doh.AddConditionParameter("@pId", temp);
                    _doh.AddFieldItem("pId", "-100000");
                    _doh.Update("jcms_normal_user_oauth");
                    _doh.Reset();
                    _doh.ConditionExpress = "[email protected]";
                    _doh.AddConditionParameter("@id", _id);
                    _doh.AddFieldItem("pId", temp);
                    _doh.Update("jcms_normal_user_oauth");
                    _doh.Reset();
                    _doh.ConditionExpress = "[email protected]";
                    _doh.AddConditionParameter("@pId", "-100000");
                    _doh.AddFieldItem("pId", pId);
                    _doh.Update("jcms_normal_user_oauth");

                }
                return true;
            }
        }

 private void p__GetChannel_Soft(TemplateEngineDAL te, DataTable dt, ref string PageStr, ref System.Collections.ArrayList ContentList, int i)
 {
     string TempId, ClassName;
     using (DbOperHandler _doh = new Common().Doh())
     {
         _doh.Reset();
         _doh.ConditionExpress = "IsOut=0 AND id=" + dt.Rows[i]["ClassId"].ToString();
         TempId = _doh.GetField("jcms_normal_class", "ContentTemp").ToString();
         ClassName = _doh.GetField("jcms_normal_class", "Title").ToString();
     }
     string pId = string.Empty;
     //得到模板方案组ID/主题ID/模板内容
     new JumboTCMS.DAL.Normal_TemplateDAL().GetTemplateContent(TempId, ref pId, ref PageStr);
     te.PageNav = "<script type=\"text/javascript\" src=\"" + site.Dir + te.MainChannel.Dir + "/js/classnav_" + dt.Rows[i]["ClassId"].ToString() + ".js\"></script>";
     if (te.MainChannel.IsTop)
         te.PageTitle = dt.Rows[i]["Title"] + "_" + ClassName + "_" + te.MainChannel.Title + "_" + site.Name + site.TitleTail;
     else
         te.PageTitle = dt.Rows[i]["Title"] + "_" + ClassName + "_" + site.Name + site.TitleTail;
     te.PageKeywords = JumboTCMS.Utils.WordSpliter.GetKeyword(dt.Rows[i]["Title"].ToString()) + "," + site.Keywords;
     te.PageDescription = JumboTCMS.Utils.Strings.SimpleLineSummary(dt.Rows[i]["Summary"].ToString());
     te.ReplacePublicTag(ref PageStr);
     te.ReplaceChannelTag(ref PageStr, dt.Rows[i]["ChannelId"].ToString());
     te.ReplaceChannelClassLoopTag(ref PageStr);
     te.ReplaceClassTag(ref PageStr, dt.Rows[i]["ClassId"].ToString());
     //te.ReplaceContentLoopTag(ref PageStr);
 }

 /// <summary>
 /// 判断内容阅读权限(频道ID只能从外部传入，不支持跨频道)
 /// 假设内容ID和栏目ID都已经正确
 /// </summary>
 /// <param name="_contentid"></param>
 /// <param name="_classid"></param>
 /// <returns></returns>
 public bool CanReadContent(string _contentid, string _classid)
 {
     if (Cookie.GetValue(site.CookiePrev + "admin") != null)//管理员直接可以看
         return true;
     int _usergroup = 0;
     if (Cookie.GetValue(site.CookiePrev + "user") != null)
         _usergroup = Str2Int(Cookie.GetValue(site.CookiePrev + "user", "groupid"));
     int _ContentReadGroup, _ClassReadGroup;
     using (DbOperHandler _doh = new Common().Doh())
     {
         _doh.Reset();
         _doh.ConditionExpress = "id=" + _contentid;
         _ContentReadGroup = Str2Int(_doh.GetField("jcms_module_" + this.MainChannel.Type, "ReadGroup").ToString());
         _doh.Reset();
         _doh.ConditionExpress = "id=" + _classid;
         _ClassReadGroup = Str2Int(_doh.GetField("jcms_normal_class", "ReadGroup").ToString());
     }
     if (_ContentReadGroup > -1)//说明不是继承栏目
     {
         if (_ContentReadGroup > _usergroup)
             return false;
         else
             return true;
     }
     else
     {
         if (_ClassReadGroup > _usergroup)
             return false;
         else
             return true;
     }
 }

 /// <summary>
 /// 获得栏目名称
 /// </summary>
 /// <param name="_id"></param>
 /// <returns></returns>
 public string GetClassName(string _id)
 {
     using (DbOperHandler _doh = new Common().Doh())
     {
         _doh.Reset();
         _doh.ConditionExpress = "id=" + _id;
         string _classname = _doh.GetField("jcms_normal_class", "Title").ToString();
         return _classname;
     }
 }

        /// <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 = "[email protected]";
                _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 = "[email protected] 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 = "[email protected] 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="_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 = "[email protected] 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 = "[email protected] 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;
     }
 }