/// <summary> /// 为公司基本信息加载个人用户基本信息 /// </summary> private static void LoadBaseInfoForCompanyInfo(CompanyInfo model,DataRow dr) { var memberInfo = GetByDataRow(dr); //MemberInfo model.Id = memberInfo.Id; model.UserName = memberInfo.UserName; model.Email = memberInfo.Email; model.RealName = memberInfo.RealName; model.Mobile = memberInfo.Mobile; model.Phone = memberInfo.Phone; model.CreateDateTime = memberInfo.CreateDateTime; model.LastLoginDateTime = memberInfo.LastLoginDateTime; model.ModifyDateTime = memberInfo.ModifyDateTime; model.Type = memberInfo.Type; model.Address = memberInfo.Address; model.Province = memberInfo.Province; model.City = memberInfo.City; model.Industry = memberInfo.Industry; model.Fax = memberInfo.Fax; model.Position = memberInfo.Position; model.Password = memberInfo.Password; }
/// <summary> /// 更新公司信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int UpdateCompanyInfo(CompanyInfo model) { string strSQL = "UPDATE Companies SET CompanyName = @CompanyName,CompanyIntroduction = @CompanyIntroduction,CompanyLogo = @CompanyLogo,CompanySite = @CompanySite,CompanyBanner = @CompanyBanner WHERE CompanyId = @CompanyId"; SqlParameter[] parms = { new SqlParameter("CompanyId",SqlDbType.Int), new SqlParameter("CompanyName",SqlDbType.NVarChar), new SqlParameter("CompanyIntroduction",SqlDbType.NVarChar), new SqlParameter("CompanyLogo",SqlDbType.NVarChar), new SqlParameter("CompanySite",SqlDbType.NVarChar), new SqlParameter("CompanyBanner",SqlDbType.NVarChar), }; parms[0].Value = model.CompanyId; parms[1].Value = string.IsNullOrEmpty(model.CompanyName) ? string.Empty : model.CompanyName; parms[2].Value = string.IsNullOrEmpty(model.CompanyIntroduction) ? string.Empty : model.CompanyIntroduction; parms[3].Value = string.IsNullOrEmpty(model.CompanyLogo) ? string.Empty : model.CompanyLogo; parms[4].Value = string.IsNullOrEmpty(model.CompanySite) ? string.Empty : model.CompanySite; parms[5].Value = string.IsNullOrEmpty(model.CompanyBanner) ? string.Empty : model.CompanyBanner; int flag = SQLPlus.ExecuteNonQuery(CommandType.Text,strSQL,parms); if(flag > 0 && model.Categories.Count >0){ //更新公司产品类别 //首先删除 strSQL = string.Format("DELETE Company2Category WHERE CompanyId = {0}",model.CompanyId); SQLPlus.ExecuteNonQuery(CommandType.Text,strSQL); //第二步,插入 foreach (int i in model.Categories) { strSQL = string.Format("INSERT INTO dbo.Company2Category(CompanyId,CategoryId) VALUES({0},{1})", model.CompanyId, i); SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL); } } return flag; }
/// <summary> /// 添加公司信息 /// </summary> /// <param name="model"></param> /// <returns>返回公司ID(CompanyID)</returns> public static int InsertCompany(CompanyInfo model) { string strSQL = "INSERT INTO Companies(UserId,CompanyName,CompanyIntroduction,CompanyLogo,CompanySite,[CompanyStatus]) VALUES(@UserId,@CompanyName,@CompanyIntroduction,@CompanyLogo,@CompanySite,1);SELECT @@IDENTITY;"; SqlParameter[] parms = { new SqlParameter("UserId",SqlDbType.Int), new SqlParameter("CompanyName",SqlDbType.NVarChar), new SqlParameter("CompanyIntroduction",SqlDbType.NVarChar), new SqlParameter("CompanyLogo",SqlDbType.NVarChar), new SqlParameter("CompanySite",SqlDbType.NVarChar) }; parms[0].Value = model.UserId; parms[1].Value = string.IsNullOrEmpty(model.CompanyName) ? string.Empty :model.CompanyName; parms[2].Value = string.IsNullOrEmpty(model.CompanyIntroduction) ? string.Empty : model.CompanyIntroduction; parms[3].Value = string.IsNullOrEmpty(model.CompanyLogo) ? string.Empty:model.CompanyLogo; parms[4].Value = string.IsNullOrEmpty(model.CompanySite) ? string.Empty : model.CompanySite; ; int companyId = Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text,strSQL,parms)); //插入【公司产品】表 if(companyId>0){ foreach(int i in model.Categories){ strSQL = string.Format("INSERT INTO dbo.Company2Category(CompanyId,CategoryId) VALUES({0},{1})",companyId,i); SQLPlus.ExecuteNonQuery(CommandType.Text,strSQL); } } return companyId; }
public ActionResult Profile(CompanyInfo oldModel,FormCollection fc) { bool errors = false; //var companyInfo = MemberService.GetCompanyInfoByUserId(PlantEngContext.Current.UserId); //oldModel = companyInfo; //POST过来oldModel中CompanyId = 0 //在这在设置一下 var catList = CompanyProductCategoryService.GetSystemCategoryList(); ViewBag.CatList = catList; var pc = fc["cbCat"]; if (string.IsNullOrEmpty(pc)) { errors = true; ModelState.AddModelError("PRODUCTCATERROR", "请选择公司产品"); } else { oldModel.Categories = pc.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(ii => Convert.ToInt32(ii)).ToList(); } #region == 上传 LOGO BANNER == //上传LOGO HttpFileCollectionBase files = Request.Files; HttpPostedFileBase logoFile = files["logofile"]; int logoErrorCode = 0; string logo = FileUpload.UploadCompanyLogo(logoFile, out logoErrorCode); if(!string.IsNullOrEmpty(logo)){ oldModel.CompanyLogo = logo; } if (logoErrorCode == 2) { errors = true; ModelState.AddModelError("FILEERROR","LOGO格式错误,请重试"); } if (logoErrorCode == 3) { errors = true; ModelState.AddModelError("FILESIZEERROR","LOGO大小请在3M以内"); } //上传Banner HttpPostedFileBase bannerFile = files["bannerfile"]; int bannerErrorCode = 0; string banner = FileUpload.UploadCompanyBanner(bannerFile, out bannerErrorCode); if(!string.IsNullOrEmpty(banner)){ oldModel.CompanyBanner = banner; } if (bannerErrorCode == 2) { errors = true; ModelState.AddModelError("BANNERFILEERROR", "BANNER格式错误,请重试"); } if (bannerErrorCode == 3) { errors = true; ModelState.AddModelError("BANNERFILESIZEERROR", "BANNER大小请在3M以内"); } #endregion if (!errors && ModelState.IsValid) { int i = MemberService.UpdateCompanyInfo(oldModel); if (i > 0) { ViewBag.Msg = "更新成功"; } else { ModelState.AddModelError("ERROR", "更新失败,请重试"); } } return View(oldModel); }
/// <summary> /// 添加公司信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int InsertCompany(CompanyInfo model) { //取消密码MD5 //model.Password = Controleng.Common.Utils.MD5(model.Password); return MemberManage.InsertCompany(model); }
/// <summary> /// 更新公司信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int UpdateCompanyInfo(CompanyInfo model) { return MemberManage.UpdateCompanyInfo(model); }
public ActionResult RegisterCompany(CompanyInfo oldModel, FormCollection fc) { var catList = CompanyProductCategoryService.GetSystemCategoryList(); ViewBag.CatList = catList; #region == 验证合法性 == bool errors = false; if (string.IsNullOrEmpty(oldModel.UserName)) { ModelState.AddModelError("USERNAME", "用户名不能为空"); errors = true; } if (string.IsNullOrEmpty(oldModel.Email)) { ModelState.AddModelError("EMAIL", "Email不能为空"); errors = true; } if (string.IsNullOrEmpty(oldModel.Password) || string.IsNullOrEmpty(fc["confirmpassword"])) { ModelState.AddModelError("PASSWORD", "密码不能为空"); errors = true; } if (oldModel.Password != fc["confirmpassword"]) { ModelState.AddModelError("PASSWORD2", "两次密码不一致,请重新输入"); errors = true; } if (string.IsNullOrEmpty(oldModel.RealName)) { ModelState.AddModelError("REALNAME", "真实姓名不能为空"); errors = true; } //判断用户名是否存在 if (!string.IsNullOrEmpty(oldModel.UserName)) { if (CheckBlockUser(oldModel.UserName) || MemberService.UserNameExists(oldModel.UserName)) { ModelState.AddModelError("USERNAMEEXISTS", "用户名已经存在,请选择其他用户名"); errors = true; } } //判断Email是否存在 if (!string.IsNullOrEmpty(oldModel.Email)) { if (MemberService.EmailExists(oldModel.Email)) { ModelState.AddModelError("EMAILEXISTS", "Email已经存在,请选择其他Email"); errors = true; } } //判断公司产品类别是否选择 var pc = fc["cbCat"]; if (string.IsNullOrEmpty(pc)) { ModelState.AddModelError("PRODUCTCATERROR", "请选择公司产品"); errors = true; } else { oldModel.Categories = pc.Split(new char []{ ',' }, StringSplitOptions.RemoveEmptyEntries).Select(i => Convert.ToInt32(i)).ToList(); } #endregion if (!errors && ModelState.IsValid) { //行业 oldModel.Industry = fc["Industry"]; oldModel.Province = fc["Province"]; oldModel.City = fc["City"]; oldModel.Position = fc["Position"]; //设置为企业用户类型 oldModel.Type = MemberType.Enterprise; oldModel.UserId = oldModel.Id = MemberService.Insert(oldModel); if (oldModel.UserId > 0) { //上传LOGO HttpFileCollectionBase files = Request.Files; HttpPostedFileBase postedFile = files["picfile"]; int errorCode = 0; oldModel.CompanyLogo = FileUpload.UploadCompanyLogo(postedFile, out errorCode); //插入企业用户信息 oldModel.CompanyId = MemberService.InsertCompany(oldModel); //登录 _Login(oldModel); Response.Redirect("/accounts/"); } else { ModelState.AddModelError("FINALERROR", "注册失败,请重试。"); } } return View(); }