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