public List <Vuser> getSearchUser(string key, int UserTypeID, int SubClassID) { List <Vuser> list = new List <Vuser>(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Key", SqlDbType.NVarChar), new SqlParameter("@UserTypeID", SqlDbType.Int), new SqlParameter("@SubClassID", SqlDbType.Int) }; parameters[0].Value = key; parameters[1].Value = UserTypeID; parameters[2].Value = SubClassID; SqlDataReader reader = SQLHelper.RunProcedure("pv_vUser_SearchList", parameters); while (reader.Read()) { Vuser item = new Vuser(); item.Dept = reader.GetString(reader.GetOrdinal("Dept")); item.Description = reader.GetString(reader.GetOrdinal("Description")); item.Email = reader.GetString(reader.GetOrdinal("Email")); item.GroupID = reader.GetInt32(reader.GetOrdinal("GroupID")); item.TypeID = reader.GetInt32(reader.GetOrdinal("TypeID")); item.SubClassID = reader.GetInt32(reader.GetOrdinal("SubClassID")); item.QQ = reader.GetString(reader.GetOrdinal("QQ")); item.RealName = reader.GetString(reader.GetOrdinal("RealName")); item.Password = reader.GetString(reader.GetOrdinal("Password")); item.Sex = reader.GetString(reader.GetOrdinal("Sex")); item.State = reader.GetString(reader.GetOrdinal("State")); item.WangWang = reader.GetString(reader.GetOrdinal("WangWang")); item.Tel = reader.GetString(reader.GetOrdinal("Tel")); item.UserName = reader.GetString(reader.GetOrdinal("UserName")); item.TypeName = reader.GetString(reader.GetOrdinal("TypeName")); item.SubClassName = reader.GetString(reader.GetOrdinal("SubClassName")); list.Add(item); } reader.Close(); return(list); }
public List <Vuser> getAllVuser() { List <Vuser> list = new List <Vuser>(); SqlDataReader reader = SQLHelper.RunProcedure("pv_vUser_getAll", null); while (reader.Read()) { Vuser item = new Vuser(); item.Dept = reader.GetString(reader.GetOrdinal("Dept")); item.Description = reader.GetString(reader.GetOrdinal("Description")); item.Email = reader.GetString(reader.GetOrdinal("Email")); item.GroupID = reader.GetInt32(reader.GetOrdinal("GroupID")); item.TypeID = reader.GetInt32(reader.GetOrdinal("TypeID")); item.SubClassID = reader.GetInt32(reader.GetOrdinal("SubClassID")); item.QQ = reader.GetString(reader.GetOrdinal("QQ")); item.RealName = reader.GetString(reader.GetOrdinal("RealName")); item.Password = reader.GetString(reader.GetOrdinal("Password")); item.Sex = reader.GetString(reader.GetOrdinal("Sex")); item.State = reader.GetString(reader.GetOrdinal("State")); item.WangWang = reader.GetString(reader.GetOrdinal("WangWang")); item.Tel = reader.GetString(reader.GetOrdinal("Tel")); item.UserName = reader.GetString(reader.GetOrdinal("UserName")); item.TypeName = reader.GetString(reader.GetOrdinal("TypeName")); item.SubClassName = reader.GetString(reader.GetOrdinal("SubClassName")); item.GroupName = reader.GetString(reader.GetOrdinal("GroupName")); list.Add(item); } reader.Close(); return(list); }
/// <summary> /// 初始化 /// </summary> protected void DataBand() { string username = Request.QueryString["UserName"]; if (username == null) { Response.Write("参数有误"); Response.End(); } Vuser u = new Vuser(); u = Leyp.SQLServerDAL.Factory.getVuserDAL().getUserViewByID(username); if (u == null) { Response.Write("没有数据"); Response.End(); } UserName.Text = u.UserName; Dept.Text = u.Dept; QQ.Text = u.QQ; WangWang.Text = u.WangWang; Email.Text = u.Email; RealName.Text = u.RealName; Tel.Text = u.Tel; Description.Text = u.Description; BankAccount.Text = u.BankAccount; Bankname.Text = u.Bankname; Character.Text = u.Character; CompanyInfo.Text = u.CompanyInfo; CompanyName.Text = u.CompanyName; Address.Text = u.Address; GroupID.Text = u.GroupID.ToString(); GroupID1.Value = u.GroupID.ToString(); TypeName.Text = u.TypeName; SubClassName.Text = u.SubClassName; Label3.Text = u.GroupName; SubClassDatabang(0);//初始化 }
protected void init() { string Username = Request.QueryString["UserName"].ToString(); Vuser u = new Vuser(); u = Leyp.SQLServerDAL.Factory.getVuserDAL().getUserViewByID(Username); if (u != null) { UserName.Text = u.UserName; Dept.Text = u.Dept; QQ.Text = u.QQ; WangWang.Text = u.WangWang; Email.Text = u.Email; RealName.Text = u.RealName; Tel.Text = u.Tel; Description.Text = u.Description; BankAccount.Text = u.BankAccount; Bankname.Text = u.Bankname; Character.Text = u.Character; CompanyInfo.Text = u.CompanyInfo; CompanyName.Text = u.CompanyName; Address.Text = u.Address; State.Text = u.State; Sex.Text = u.Sex; UserType.Text = u.TypeName + "------>" + u.SubClassName; GroupID.Text = u.GroupName; } else { Response.Write("没有您要的数据"); Response.End(); } }
public Vuser getUserViewByID(string UserName) { Vuser vuser = new Vuser(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@UserName", SqlDbType.NVarChar) }; parameters[0].Value = UserName; SqlDataReader reader = SQLHelper.RunProcedure("pv_vUser_getByUserName", parameters); while (reader.Read()) { vuser.Dept = reader.GetString(reader.GetOrdinal("Dept")); vuser.Description = reader.GetString(reader.GetOrdinal("Description")); vuser.Email = reader.GetString(reader.GetOrdinal("Email")); vuser.GroupID = reader.GetInt32(reader.GetOrdinal("GroupID")); vuser.TypeID = reader.GetInt32(reader.GetOrdinal("TypeID")); vuser.SubClassID = reader.GetInt32(reader.GetOrdinal("SubClassID")); vuser.QQ = reader.GetString(reader.GetOrdinal("QQ")); vuser.RealName = reader.GetString(reader.GetOrdinal("RealName")); vuser.Password = reader.GetString(reader.GetOrdinal("Password")); vuser.Sex = reader.GetString(reader.GetOrdinal("Sex")); vuser.State = reader.GetString(reader.GetOrdinal("State")); vuser.WangWang = reader.GetString(reader.GetOrdinal("WangWang")); vuser.Tel = reader.GetString(reader.GetOrdinal("Tel")); vuser.UserName = reader.GetString(reader.GetOrdinal("UserName")); vuser.TypeName = reader.GetString(reader.GetOrdinal("TypeName")); vuser.SubClassName = reader.GetString(reader.GetOrdinal("SubClassName")); vuser.GroupName = reader.GetString(reader.GetOrdinal("GroupName")); vuser.Address = reader.GetString(reader.GetOrdinal("Address")); vuser.BankAccount = reader.GetString(reader.GetOrdinal("BankAccount")); vuser.Bankname = reader.GetString(reader.GetOrdinal("Bankname")); vuser.Character = reader.GetString(reader.GetOrdinal("Character")); vuser.CompanyInfo = reader.GetString(reader.GetOrdinal("CompanyInfo")); vuser.CompanyName = reader.GetString(reader.GetOrdinal("CompanyName")); vuser.LatelyLogin = reader.GetString(reader.GetOrdinal("LatelyLogin")); } return(vuser); }