/// <summary> /// 修改企业会员信息 /// </summary> public int UpdateUser(UserInfo eui) { SqlParameter[] commandParameters = new SqlParameter[]{ new SqlParameter("@UserID", eui.UserID), new SqlParameter("@GradeID", eui.GradeID), new SqlParameter("@CompanyName", eui.CompanyName), new SqlParameter("@CompanyNature", eui.CompanyNature), new SqlParameter("@BusinessModel", eui.BusinessModel), new SqlParameter("@DealinAdd", eui.DealinAdd), new SqlParameter("@Product", eui.Product), new SqlParameter("@Industry", eui.Industry), new SqlParameter("@Summary", eui.Summary), new SqlParameter("@Country", eui.Country), new SqlParameter("@Province", eui.Province), new SqlParameter("@City", eui.City), new SqlParameter("@Area", eui.Area), new SqlParameter("@Street", eui.Street), new SqlParameter("@Postalcode", eui.Postalcode), new SqlParameter("@URL", eui.URL), new SqlParameter("@Capital", eui.Capital), new SqlParameter("@Established",eui.Established), new SqlParameter("@RegisterAddress", eui.RegisterAddress), new SqlParameter("@Corporate", eui.Corporate), new SqlParameter("@Logo", eui.Logo) }; return SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "SP_U_UserInfo_CorpInfo_Update", commandParameters); }
/// <summary> /// 添加注册时信息 /// </summary> public int InsertUser(UserInfo eui) { SqlParameter[] commandParameters = new SqlParameter[]{ new SqlParameter("@LoginName", eui.LoginName), new SqlParameter("@Sex",eui.Sex), new SqlParameter("@Password",eui.Password), new SqlParameter("@Question", eui.Question), new SqlParameter("@Answer", eui.Answer), new SqlParameter("@GradeID", eui.GradeID), new SqlParameter("@Lockuedup", eui.Lockuedup), new SqlParameter("@LinkName", eui.LinkName), new SqlParameter("@MobilePhone", eui.MobilePhone), new SqlParameter("@Email", eui.Email), new SqlParameter("@QQ", eui.QQ), new SqlParameter("@MSN", eui.MSN), new SqlParameter("@Tel_International", eui.Tel_International), new SqlParameter("@Tel_DistrictNumber", eui.Tel_DistrictNumber), new SqlParameter("@Tel_Telephone", eui.Tel_Telephone), new SqlParameter("@Tel_Ext", eui.Tel_Ext), new SqlParameter("@Fax_International", eui.Fax_International), new SqlParameter("@Fax_DistrictNumber", eui.Fax_DistrictNumber), new SqlParameter("@Fax_Telephone", eui.Fax_Telephone), new SqlParameter("@Fax_Ext", eui.Fax_Ext), new SqlParameter("@Department", eui.Department), new SqlParameter("@Position", eui.Position), //new SqlParameter("@RegDate", eui.RegDate), new SqlParameter("@CompanyName", eui.CompanyName), new SqlParameter("@CompanyNature", eui.CompanyNature), new SqlParameter("@BusinessModel", eui.BusinessModel), new SqlParameter("@DealinAdd", eui.DealinAdd), new SqlParameter("@Product", eui.Product), new SqlParameter("@Industry", eui.Industry), new SqlParameter("@Summary", eui.Summary), new SqlParameter("@Verify", eui.Verify), new SqlParameter("@Country", eui.Country), new SqlParameter("@Province", eui.Province), new SqlParameter("@City", eui.City), new SqlParameter("@Area", eui.Area), new SqlParameter("@Street", eui.Street), new SqlParameter("@Postalcode", eui.Postalcode), new SqlParameter("@URL", eui.URL), new SqlParameter("@Capital", eui.Capital), new SqlParameter("@Established",eui.Established), new SqlParameter("@RegisterAddress", eui.RegisterAddress), new SqlParameter("@Corporate", eui.Corporate), //new SqlParameter("@StartDate", eui.StartDate), //new SqlParameter("@EndDate", eui.EndDate), //new SqlParameter("@Logo", eui.Logo) }; return SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "SP_U_UserInfo_Add", commandParameters); }
/// <summary> /// 修改企业会员信息 /// </summary> public abstract int UpdateUser(UserInfo uinfo);
public UserInfo GetUserByName(string lname) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@strWhere", "where LoginName='" + lname + "'"), new SqlParameter("@strTableName", "U_UserInfo"), new SqlParameter("@strOrder", "") }; UserInfo info = null; using (SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "SP_SelectByWhere", param)) { if (!reader.Read()) { return info; } info = new UserInfo(); //会员信息 info.UserID = Convert.ToInt32(reader["UserID"].ToString()); info.LoginName = reader["LoginName"].ToString(); info.Password = reader["password"].ToString(); info.Question = reader["Question"].ToString(); info.Answer = reader["Answer"].ToString(); if (reader["GradeID"].ToString() != "") info.GradeID = int.Parse(reader["GradeID"].ToString()); //返回联系人信息 info.LinkName = reader["LinkName"].ToString(); info.Sex = reader["Sex"].ToString(); info.Department = reader["Department"].ToString(); info.Position = reader["Position"].ToString(); info.Tel_International = reader["Tel_International"].ToString(); info.Tel_DistrictNumber = reader["Tel_DistrictNumber"].ToString(); info.Tel_Telephone = reader["Tel_Telephone"].ToString(); info.Tel_Ext = reader["Tel_Ext"].ToString(); info.Fax_International = reader["Fax_International"].ToString(); info.Fax_DistrictNumber = reader["Fax_DistrictNumber"].ToString(); info.Fax_Telephone = reader["Fax_Telephone"].ToString(); info.Fax_Ext = reader["Fax_Ext"].ToString(); info.MobilePhone = reader["MobilePhone"].ToString(); info.Email = reader["EMail"].ToString(); info.QQ = reader["QQ"].ToString(); info.MSN = reader["MSN"].ToString(); //返回公司信息 info.CompanyName = reader["CompanyName"].ToString(); info.CompanyNature = reader["CompanyNature"].ToString(); info.BusinessModel = reader["BusinessModel"].ToString(); if (reader["Capital"].ToString() != "") info.Capital = int.Parse(reader["Capital"].ToString()); if (reader["Established"].ToString() != "") info.Established = Convert.ToDateTime(reader["Established"].ToString()); info.RegisterAddress = reader["RegisterAddress"].ToString(); info.Country = reader["Country"].ToString(); info.Province = reader["Province"].ToString(); info.City = reader["City"].ToString(); info.Area = reader["Area"].ToString(); info.DealinAdd = reader["DealinAdd"].ToString(); info.Postalcode = reader["Postalcode"].ToString(); info.Product = reader["Product"].ToString(); info.Industry = reader["Industry"].ToString(); info.Summary = reader["Summary"].ToString(); info.Street = reader["Street"].ToString(); info.URL = reader["URL"].ToString(); info.Corporate = reader["Corporate"].ToString(); info.Logo = reader["Logo"].ToString(); info.StartDate = DateTime.Parse(reader["StartDate"].ToString()); info.EndDate = DateTime.Parse(reader["EndDate"].ToString()); } return info; }
/// <summary> /// 增加企业会员 /// </summary> public abstract int InsertUser(UserInfo uinfo);
/// <summary> /// 修改企业会员信息 /// </summary> public static int UpdateUser(UserInfo uinfo) { return Data.DbProvider.GetInstance().UpdateUser(uinfo); }
/// <summary> /// 增加企业会员 /// </summary> public static int InsertUser(UserInfo uinfo) { return Data.DbProvider.GetInstance().InsertUser(uinfo); }
/// <summary> /// 修改企业会员信息 /// </summary> public override int UpdateUser(UserInfo uinfo) { return INFOPlatform.UpdateUser(uinfo); }
/// <summary> /// 增加企业会员 /// </summary> public override int InsertUser(UserInfo uinfo) { return INFOPlatform.InsertUser(uinfo); }