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