Gsmarket/Sources/GS-MarketMG-2018/SysDataLibs/TableClass/Sys_GroupHasUser_info.cs

using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using SysBaseLibs; 
using System.Web.Script.Serialization;
 namespace SysDataLibs.TableClass  
 {  
    #region      Sys_GroupHasUser  
     public class Sys_GroupHasUser_info : ITableInfo
     {
         #region      Sys_GroupHasUser表 字段信息
         /// <summary> 
         /// 为关键字段： Y --- PrimaryKey;
         /// 自动增长： Y;
         /// 数据类型： int;
         /// 数据长度： 4;
         /// 是否允许为空： N;
         /// 默认值： ;
         /// 描述： 编号;
         /// </summary>
         public const string cGroupHasUserID = "GroupHasUserID";

         /// <summary> 
         /// 为关键字段： N ;
         /// 自动增长： N;
         /// 数据类型： varchar;
         /// 数据长度： 10;
         /// 是否允许为空： N;
         /// 默认值： ;
         /// 描述： 用户组编号;
         /// </summary>
         public const string cGroupID = "GroupID";

         /// <summary> 
         /// 为关键字段： N ;
         /// 自动增长： N;
         /// 数据类型： varchar;
         /// 数据长度： 30;
         /// 是否允许为空： N;
         /// 默认值： ;
         /// 描述： 用户编号;
         /// </summary>
         public const string cUserID = "UserID";

         #endregion
         public Sys_GroupHasUser_info() { }

         public Sys_GroupHasUser_info(DataRow poRow)
         {
             CreateTableInfo(poRow);
         }

         public void CreateTableInfo(DataRow poRow)
         {
             _GroupHasUserID = UtilStr.StrFromObj(poRow[cGroupHasUserID]);
             _GroupID = UtilStr.StrFromObj(poRow[cGroupID]);
             _UserID = UtilStr.StrFromObj(poRow[cUserID]);
         }

         public Sys_GroupHasUser_info(string pcGroupHasUserID, DBConnSql poDBConn)
         {
             if (pcGroupHasUserID.Trim().Length > 0 && poDBConn != null)
             {
                 string lcSql = "select * from " + Tn.Sys_GroupHasUser + " where GroupHasUserID='" + pcGroupHasUserID + "'";
                 rsQuery loQuery = poDBConn.OpenQuery(lcSql);
                 if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                 {
                     loQuery.MoveFirst();
                     CreateTableInfo(loQuery.CurrentRow);
                 }
             }
         }
         private string _GroupHasUserID = "";
         public string GroupHasUserID
         {
             get { return _GroupHasUserID; }
             set { _GroupHasUserID = value; }
         }

         private string _GroupID = "";
         public string GroupID
         {
             get { return _GroupID; }
             set { _GroupID = value; }
         }

         private string _UserID = "";
         public string UserID
         {
             get { return _UserID; }
             set { _UserID = value; }
         }

         [ScriptIgnore]
         public rsXmlNode DataXMLNode
         {
             get
             {
                 rsXmlNode loMainNode = new rsXmlNode("Sys_GroupHasUserRecord", "");
                 rsXmlNode loNode = null;
                 loNode = new rsXmlNode(cGroupHasUserID, GroupHasUserID);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cGroupID, GroupID);
                 loMainNode.AddChild(loNode);
                 loNode = new rsXmlNode(cUserID, UserID);
                 loMainNode.AddChild(loNode);
                 return loMainNode;
             }
         }
         public string InsertSql()
         {
             return " insert into " + Tn.Sys_GroupHasUser + " " +
                        " (" + cGroupID + "," + cUserID + ") " +
                        " values ('" + _GroupID + "','" + _UserID + "') ";
         }

         public string UpdateSql()
         {
             return " update " + Tn.Sys_GroupHasUser + " " +
                        " set " + cGroupID + "='" + _GroupID + "'," + cUserID + "='" + _UserID + "' " +
                        " where  " + cGroupHasUserID + "=" + _GroupHasUserID + "";
         }

         public string DeleteSql()
         {
             return "Delete " + Tn.Sys_GroupHasUser + " where " + cGroupHasUserID + "=" + _GroupHasUserID + "";
         }

         public static rsQuery GetGroupByUserID(string pcUserId, DBConnSql poConn)
         {
             string sql = "select g." + Sys_Groups_info.cGroupID + " as 'ID' ,g." + Sys_Groups_info.cNames + " as 'Names'  from " + Tn.Sys_Groups + " as g inner join   " + Tn.Sys_GroupHasUser + " as gu ";
             sql += " on(g." + Sys_Groups_info.cGroupID + "=gu." + Sys_GroupHasUser_info.cGroupID + ") where g." + Sys_Groups_info.cIsLock  + "='N' and  gu." + Sys_GroupHasUser_info.cUserID + "='" + pcUserId + "'";

             return poConn.OpenQuery(sql);
         }

         public static rsQuery GetGroupsByGroupID(string pcGroupID, DBConnSql poConn)
         {
             string sql = "select u." + Sys_Users_info.cUserID + " as 'UserID' ,u." + Sys_Users_info.cNames + "   as  'Names'  from " + Tn.Sys_Users + " as u ";
             sql += " join   " + Tn.Sys_GroupHasUser + " as gu on(u." + Sys_Users_info.cUserID + "=gu." + Sys_GroupHasUser_info.cUserID + ") where u." + Sys_Users_info.cIsLock + "='N' and gu." + Sys_GroupHasUser_info.cGroupID + "='" + pcGroupID + "'    ";

             return poConn.OpenQuery(sql);
         }

         public static bool UpdateUserToGroup(string pcUserID, string pcGroupId, DBConnSql poConn)
         {
             bool lbRetVal = false;
             pcGroupId = UtilStr.FormatStr(pcGroupId);
             string lcSql = " Delete " + Tn.Sys_GroupHasUser + " where " + Sys_GroupHasUser_info.cUserID + "='" + pcUserID + "'   ";
             if (pcGroupId.Trim().Length > 0)
                 lcSql += " insert into " + Tn.Sys_GroupHasUser+ " (GroupID,UserID) values ('" + pcGroupId + "','" + pcUserID + "') ";
             if (poConn != null)
             {
                 lbRetVal = poConn.ExcuteSqlTran(lcSql);
             }
             return lbRetVal;
         }

         public static bool UpdateUsersToGroup(string pcGroupID, string pcUserList, DBConnSql poConn)
         {
             bool lbRetVal = false;
             string lcSql = " Delete " + Tn.Sys_GroupHasUser + " where " + Sys_GroupHasUser_info .cGroupID + "='" + pcGroupID + "'   \r\n ";
             if (pcUserList.Trim().Length > 0)
             {

                 Array loArr = UtilStr.StrToArrayEx(pcUserList, ",");
                 if (loArr != null && loArr.Length > 0)
                 {
                     foreach (string lcUserId in loArr)
                     {
                         string UserId = UtilStr.FormatStr(lcUserId);
                         if (UserId.Trim().Length > 0)
                             lcSql += " insert into " + Tn.Sys_GroupHasUser + " (GroupID,UserID) values ('" + pcGroupID + "','" + UserId + "')  \r\n ";
                     }
                 }
             }
             if (poConn != null)
             {
                 lbRetVal = poConn.ExcuteSqlTran(lcSql);
             }
             return lbRetVal;
         }

     }
    #endregion 

  #region 

    public class Sys_GroupHasUser_Qry : rsQuery  
    {  
        public Int64 GroupHasUserID  
           {  
               get { return GetInt(Sys_GroupHasUser_info.cGroupHasUserID); } 
           //    set { SetField(Sys_GroupHasUser_info.cGroupHasUserID, value); } 
           } 
 
        public String GroupID  
           {  
               get { return GetString(Sys_GroupHasUser_info.cGroupID); } 
           //    set { SetField(Sys_GroupHasUser_info.cGroupID, value); } 
           } 
 
        public String UserID  
           {  
               get { return GetString(Sys_GroupHasUser_info.cUserID); } 
           //    set { SetField(Sys_GroupHasUser_info.cUserID, value); } 
           } 
 
    } 
  #endregion 

}