public static List <int> UGetMaintainUsers(int MaintainTypeID) { List <int> list = new List <int>(); string sql = "SELECT UID FROM tUserGroup " + "WHERE GID in " + "(select GID from tGroupModuleJurisdiction where MID = @MID) "; SqlParameter spr = new SqlParameter("@MID", MaintainTypeID); SqlDataReader dr = null; try { dr = MsSqlHelper.ExecReader(sql, spr); while (dr.Read()) { list.Add(dr.GetInt32(dr.GetOrdinal("UID"))); } return(list); } catch (Exception e) { LogHelper.WriteLog("UGetUserInfoByCode" + "\r\n" + sql, e); return(null); } finally { if (dr != null) { dr.Close(); } } }
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 List <TUserInfo> UGetUserInfosByCondition(string wheres, params SqlParameter[] pms) { string ssql = "select * from tUserInfo "; SqlDataReader dr = null; List <TUserInfo> listUser = new List <TUserInfo>(); try { if (pms != null && wheres != String.Empty) { ssql = ssql + wheres; dr = MsSqlHelper.ExecReader(ssql, pms); } else { dr = MsSqlHelper.ExecReader(ssql); } DateTime?timenull = null; while (dr.Read()) { listUser.Add(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.GetDateTime(dr.GetOrdinal("UEntryTime")) == null ? timenull : dr.GetDateTime(dr.GetOrdinal("UEntryTime")), Uentrytime = dr.IsDBNull(dr.GetOrdinal("UEntryTime")) == true ? timenull : dr.GetDateTime(dr.GetOrdinal("UEntryTime")), Ustate = dr.GetInt32(dr.GetOrdinal("UState")) }); } return(listUser); } catch (Exception e) { LogHelper.WriteLog("UGetUserInfosByCondition", e); return(null); } finally { if (dr != null) { dr.Close(); } } }
public static List <TMaintainType> UGetMaintainTypes(string wheres, params SqlParameter[] pms) { string sql = "select * from tMaintainType "; SqlDataReader dr = null; List <TMaintainType> lsmaintypes = new List <TMaintainType>(); try { if (pms != null && wheres != string.Empty) { sql += wheres; dr = MsSqlHelper.ExecReader(sql, pms); } else { dr = MsSqlHelper.ExecReader(sql); } while (dr.Read()) { lsmaintypes.Add(new TMaintainType() { Mid = dr.GetInt32(dr.GetOrdinal("MID")), Mname = dr["MTypeName"].ToString() == null ? "" : dr["MTypeName"].ToString(), Remark = dr["Remark"].ToString() == null ? "" : dr["Remark"].ToString() }); } return(lsmaintypes); } catch (Exception e) { LogHelper.WriteLog("UGetMaintainTypes", e); return(null); } finally { if (dr != null) { dr.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(); } } }