public static List <TGroupInfo> UGetGroupList() { SqlDataReader sdr = null; List <TGroupInfo> lstGI = new List <TGroupInfo>(); try { string sql = "select * from tGroupInfo"; sdr = MsSqlHelper.ExecReader(sql); while (sdr.Read()) { TGroupInfo gi = new TGroupInfo() { GID = sdr.GetInt32(sdr.GetOrdinal("GID")), GName = sdr["GName"].ToString(), GType = sdr.GetInt32(sdr.GetOrdinal("GType")) }; lstGI.Add(gi); } return(lstGI); } catch (Exception e) { LogHelper.WriteLog("TGroupInfoDAL.UGetGroupList", e); return(null); } finally { if (sdr != null) { sdr.Close(); } } }
public static TUserInfo UGetUserInfoByCode(string ucode) { string ssql = "select * from tUserInfo where UCode=@UCode and UState=1"; SqlParameter sdr = new SqlParameter("@UCode", ucode); SqlDataReader dr = null; SqlDataReader drGroupInfo = null; TUserInfo ui = null; try { dr = MsSqlHelper.ExecReader(ssql, sdr); DateTime?timenull = null; while (dr.Read()) { ui = new TUserInfo() { Uid = dr.GetInt32(dr.GetOrdinal("UID")), Ucode = dr["UCode"].ToString() == null ? "" : dr["UCode"].ToString(), Uname = dr["UName"].ToString() == null ? "" : dr["UName"].ToString(), Upassword = dr["UPassword"].ToString() == null ? "" : dr["UPassword"].ToString(), Uidentitycardno = dr["UIdentityCardNo"].ToString() == null ? "" : dr["UIdentityCardNo"].ToString(), Utel1 = dr["UTel1"].ToString() == null ? "" : dr["UTel1"].ToString(), Utel2 = dr["UTel2"].ToString() == null ? "" : dr["UTel2"].ToString(), Uaddress = dr["UAddress"].ToString() == null ? "" : dr["UAddress"].ToString(), Uphoto = dr["UPhoto"].ToString() == null ? "" : dr["UPhoto"].ToString(), Ubrithday = dr["UBirthday"].ToString() == null ? "" : dr["UBirthday"].ToString(), Uremark = dr["URemark"].ToString() == null ? "" : dr["URemark"].ToString(), Uentrytime = dr.IsDBNull(dr.GetOrdinal("UEntryTime")) == true ? timenull : dr.GetDateTime(dr.GetOrdinal("UEntryTime")), Ustate = dr.GetInt32(dr.GetOrdinal("UState")) }; } //查询用户所在用户组 if (ui != null) { ui.Usergroups = new List <TGroupInfo>(); string s1 = "select GID, (select GName from tGroupInfo b where a.GID = b.GID) as GName" + " (select GType from tGroupInfo b where a.GID = b.GID) as GType" + " from tUserGroup a where UID = @UID"; SqlParameter sp = new SqlParameter("@UID", ui.Uid); drGroupInfo = MsSqlHelper.ExecReader(s1, sp); while (drGroupInfo.Read()) { TGroupInfo gi = new TGroupInfo() { GID = drGroupInfo.GetInt32(drGroupInfo.GetOrdinal("GID")), GName = drGroupInfo["GName"].ToString(), GType = drGroupInfo.GetInt32(drGroupInfo.GetOrdinal("GType")) }; ui.Usergroups.Add(gi); } } return(ui); } catch (Exception e) { LogHelper.WriteLog("UGetUserInfoByCode", e); return(null); } finally { if (dr != null) { dr.Close(); } if (drGroupInfo != null) { drGroupInfo.Close(); } } }