public ActionResult Create(BEmplyee bemplyee)
{
try
{
if (ModelState.IsValid)
{
WebSecurity.CreateUserAndAccount(bemplyee.NumberEmp, "111111");
BEmplyee emp = db.BEmplyees.Single(m => m.NumberEmp.Equals(bemplyee.NumberEmp));
emp.CopyFrom(bemplyee);
emp.RegisterDate = bemplyee.RegisterDate = System.DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Create"));
}
}
catch (Exception ex)
{
return(Content(ex.Message));
}
//else
//{
// string err = "";
// foreach (string k in ModelState.Keys)
// {
// if (ModelState[k].Errors.Count > 0)
// {
// err += k + "\n ";
// foreach (ModelError eor in ModelState[k].Errors)
// {
// err += ">>" + eor.ErrorMessage + ":" + eor.Exception.Message + "\n" + eor.Exception.StackTrace ;
// }
// }
// }
// return Content(err);
//}
return(View(bemplyee));
}
public ActionResult Register(RegisterModel register)
{
if (ModelState.IsValid)
{
HttpPostedFileBase fCodeAtt = Request.Files["fCodeAtt"];
HttpPostedFileBase fTaxAtt = Request.Files["fTaxAtt"];
HttpPostedFileBase fCertAtt = Request.Files["fCertAtt"];
HttpPostedFileBase fLicenceAtt = Request.Files["fLicenceAtt"];
HttpPostedFileBase fDelegateBook = Request.Files["fDelegateBook"];
//**************** 委托书 **************
HttpPostedFileBase fPromiseAtt = Request.Files["fPromiseAtt"];
HttpPostedFileBase fSecretAtt = Request.Files["fSecretAtt"];
HttpPostedFileBase fPeopleAtt = Request.Files["fPeopleAtt"];
HttpPostedFileBase fOpenAccountAtt = Request.Files["fOpenAccountAtt"];
HttpPostedFileBase fprojectAtt = Request.Files["fprojectAtt"];
//**************** 委托书 **************
if (fCodeAtt == null || fTaxAtt == null || fCertAtt == null || fLicenceAtt == null || fDelegateBook == null || fPromiseAtt == null)
{
return(Content("error file is null"));
}
if (Path.GetExtension(fCodeAtt.FileName).ToLower().EndsWith("exe") ||
Path.GetExtension(fTaxAtt.FileName).ToLower().EndsWith("exe") ||
Path.GetExtension(fCertAtt.FileName).ToLower().EndsWith("exe") ||
Path.GetExtension(fCertAtt.FileName).ToLower().EndsWith("exe") ||
//**************** 委托书 **************
Path.GetExtension(fPromiseAtt.FileName).ToLower().EndsWith("exe") ||
Path.GetExtension(fDelegateBook.FileName).ToLower().EndsWith("exe"))
{
return(Content("请上传办公文件或压缩文件"));
}
//using( TransactionScope scope=new TransactionScope())
//{
WebSecurity.CreateUserAndAccount(register.bemplyee.NumberEmp, register.Password);
BEmplyee emp = db.BEmplyees.Single(m => m.NumberEmp.Equals(register.bemplyee.NumberEmp));
emp.CopyFrom(register.bemplyee);
//**************** 保密协议 **************
emp.SecretAtt = DateTime.Now.ToString("yyyyMMdd") + Guid.NewGuid().ToString("N");
if (fSecretAtt != null)
{
Directory.CreateDirectory(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.SecretAtt.Substring(0, 4) + @"\" + emp.SecretAtt.Substring(4, 4) + @"\")));
fSecretAtt.SaveAs(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.SecretAtt.Substring(0, 4) + @"\" + emp.SecretAtt.Substring(4, 4) + @"\" + emp.SecretAtt.Substring(8))));
GenericDataAccess.UpdateBySql("Insert into YZAppAttachment(FileID,Name,Ext,Size,OwnerAccount) values(@FileID,@Name,@Ext,@Size,@OwnerAccount)", new string[, ] {
{ "@FileID", emp.SecretAtt, "DbType.String", null },
{ "@Name", Path.GetFileName(fSecretAtt.FileName), "DbType.String", null },
{ "@Ext", Path.GetExtension(fSecretAtt.FileName), "DbType.String", null },
{ "@Size", fSecretAtt.ContentLength.ToString(), "DbType.Int32", null },
{ "@OwnerAccount", "0", "DbType.String", null }
});
}
//*******************资格证明***********
//**************** 开户许可证 **************
emp.OpenAccountAtt = DateTime.Now.ToString("yyyyMMdd") + Guid.NewGuid().ToString("N");
if (fOpenAccountAtt != null)
{
Directory.CreateDirectory(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.OpenAccountAtt.Substring(0, 4) + @"\" + emp.OpenAccountAtt.Substring(4, 4) + @"\")));
fOpenAccountAtt.SaveAs(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.OpenAccountAtt.Substring(0, 4) + @"\" + emp.OpenAccountAtt.Substring(4, 4) + @"\" + emp.OpenAccountAtt.Substring(8))));
GenericDataAccess.UpdateBySql("Insert into YZAppAttachment(FileID,Name,Ext,Size,OwnerAccount) values(@FileID,@Name,@Ext,@Size,@OwnerAccount)", new string[, ] {
{ "@FileID", emp.OpenAccountAtt, "DbType.String", null },
{ "@Name", Path.GetFileName(fOpenAccountAtt.FileName), "DbType.String", null },
{ "@Ext", Path.GetExtension(fOpenAccountAtt.FileName), "DbType.String", null },
{ "@Size", fOpenAccountAtt.ContentLength.ToString(), "DbType.Int32", null },
{ "@OwnerAccount", "0", "DbType.String", null }
});
}
//**************** 类似项目的经营业绩 **************
emp.projectAtt = DateTime.Now.ToString("yyyyMMdd") + Guid.NewGuid().ToString("N");
if (fprojectAtt != null)
{
Directory.CreateDirectory(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.projectAtt.Substring(0, 4) + @"\" + emp.projectAtt.Substring(4, 4) + @"\")));
fprojectAtt.SaveAs(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.projectAtt.Substring(0, 4) + @"\" + emp.projectAtt.Substring(4, 4) + @"\" + emp.projectAtt.Substring(8))));
GenericDataAccess.UpdateBySql("Insert into YZAppAttachment(FileID,Name,Ext,Size,OwnerAccount) values(@FileID,@Name,@Ext,@Size,@OwnerAccount)", new string[, ] {
{ "@FileID", emp.projectAtt, "DbType.String", null },
{ "@Name", Path.GetFileName(fprojectAtt.FileName), "DbType.String", null },
{ "@Ext", Path.GetExtension(fprojectAtt.FileName), "DbType.String", null },
{ "@Size", fprojectAtt.ContentLength.ToString(), "DbType.Int32", null },
{ "@OwnerAccount", "0", "DbType.String", null }
});
}
//**************** 保密协议 **************
emp.PeopleAtt = DateTime.Now.ToString("yyyyMMdd") + Guid.NewGuid().ToString("N");
if (fPeopleAtt != null)
{
Directory.CreateDirectory(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.PeopleAtt.Substring(0, 4) + @"\" + emp.PeopleAtt.Substring(4, 4) + @"\")));
fPeopleAtt.SaveAs(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.PeopleAtt.Substring(0, 4) + @"\" + emp.PeopleAtt.Substring(4, 4) + @"\" + emp.PeopleAtt.Substring(8))));
GenericDataAccess.UpdateBySql("Insert into YZAppAttachment(FileID,Name,Ext,Size,OwnerAccount) values(@FileID,@Name,@Ext,@Size,@OwnerAccount)", new string[, ] {
{ "@FileID", emp.PeopleAtt, "DbType.String", null },
{ "@Name", Path.GetFileName(fPeopleAtt.FileName), "DbType.String", null },
{ "@Ext", Path.GetExtension(fPeopleAtt.FileName), "DbType.String", null },
{ "@Size", fPeopleAtt.ContentLength.ToString(), "DbType.Int32", null },
{ "@OwnerAccount", "0", "DbType.String", null }
});
}
//**************** 委托书 **************
emp.PromiseAtt = DateTime.Now.ToString("yyyyMMdd") + Guid.NewGuid().ToString("N");
if (fPromiseAtt != null)
{
Directory.CreateDirectory(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.PromiseAtt.Substring(0, 4) + @"\" + emp.PromiseAtt.Substring(4, 4) + @"\")));
fPromiseAtt.SaveAs(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.PromiseAtt.Substring(0, 4) + @"\" + emp.PromiseAtt.Substring(4, 4) + @"\" + emp.PromiseAtt.Substring(8))));
GenericDataAccess.UpdateBySql("Insert into YZAppAttachment(FileID,Name,Ext,Size,OwnerAccount) values(@FileID,@Name,@Ext,@Size,@OwnerAccount)", new string[, ] {
{ "@FileID", emp.PromiseAtt, "DbType.String", null },
{ "@Name", Path.GetFileName(fPromiseAtt.FileName), "DbType.String", null },
{ "@Ext", Path.GetExtension(fPromiseAtt.FileName), "DbType.String", null },
{ "@Size", fPromiseAtt.ContentLength.ToString(), "DbType.Int32", null },
{ "@OwnerAccount", "0", "DbType.String", null }
});
}
emp.CodeAtt = DateTime.Now.ToString("yyyyMMdd") + Guid.NewGuid().ToString("N");
if (fCodeAtt != null)
{
Directory.CreateDirectory(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.CodeAtt.Substring(0, 4) + @"\" + emp.CodeAtt.Substring(4, 4) + @"\")));
fCodeAtt.SaveAs(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.CodeAtt.Substring(0, 4) + @"\" + emp.CodeAtt.Substring(4, 4) + @"\" + emp.CodeAtt.Substring(8))));
GenericDataAccess.UpdateBySql("Insert into YZAppAttachment(FileID,Name,Ext,Size,OwnerAccount) values(@FileID,@Name,@Ext,@Size,@OwnerAccount)", new string[, ] {
{ "@FileID", emp.CodeAtt, "DbType.String", null },
{ "@Name", Path.GetFileName(fCodeAtt.FileName), "DbType.String", null },
{ "@Ext", Path.GetExtension(fCodeAtt.FileName), "DbType.String", null },
{ "@Size", fCodeAtt.ContentLength.ToString(), "DbType.Int32", null },
{ "@OwnerAccount", "0", "DbType.String", null }
});
}
emp.TaxAtt = DateTime.Now.ToString("yyyyMMdd") + Guid.NewGuid().ToString("N");
if (fTaxAtt != null)
{
Directory.CreateDirectory(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.TaxAtt.Substring(0, 4) + @"\" + emp.TaxAtt.Substring(4, 4) + @"\")));
fTaxAtt.SaveAs(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.TaxAtt.Substring(0, 4) + @"\" + emp.TaxAtt.Substring(4, 4) + @"\" + emp.TaxAtt.Substring(8))));
GenericDataAccess.UpdateBySql("Insert into YZAppAttachment(FileID,Name,Ext,Size,OwnerAccount) values(@FileID,@Name,@Ext,@Size,@OwnerAccount)", new string[, ] {
{ "@FileID", emp.TaxAtt, "DbType.String", null },
{ "@Name", Path.GetFileName(fTaxAtt.FileName), "DbType.String", null },
{ "@Ext", Path.GetExtension(fTaxAtt.FileName), "DbType.String", null },
{ "@Size", fTaxAtt.ContentLength.ToString(), "DbType.Int32", null },
{ "@OwnerAccount", "0", "DbType.String", null }
});
}
emp.CertAtt = DateTime.Now.ToString("yyyyMMdd") + Guid.NewGuid().ToString("N");
if (fCertAtt != null)
{
Directory.CreateDirectory(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.CertAtt.Substring(0, 4) + @"\" + emp.CertAtt.Substring(4, 4) + @"\")));
fCertAtt.SaveAs(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.CertAtt.Substring(0, 4) + @"\" + emp.CertAtt.Substring(4, 4) + @"\" + emp.CertAtt.Substring(8))));
GenericDataAccess.UpdateBySql("Insert into YZAppAttachment(FileID,Name,Ext,Size,OwnerAccount) values(@FileID,@Name,@Ext,@Size,@OwnerAccount)", new string[, ] {
{ "@FileID", emp.CertAtt, "DbType.String", null },
{ "@Name", Path.GetFileName(fCertAtt.FileName), "DbType.String", null },
{ "@Ext", Path.GetExtension(fCertAtt.FileName), "DbType.String", null },
{ "@Size", fCertAtt.ContentLength.ToString(), "DbType.Int32", null },
{ "@OwnerAccount", "0", "DbType.String", null }
});
}
emp.LicenceAtt = DateTime.Now.ToString("yyyyMMdd") + Guid.NewGuid().ToString("N");
if (fLicenceAtt != null)
{
Directory.CreateDirectory(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.LicenceAtt.Substring(0, 4) + @"\" + emp.LicenceAtt.Substring(4, 4) + @"\")));
fLicenceAtt.SaveAs(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.LicenceAtt.Substring(0, 4) + @"\" + emp.LicenceAtt.Substring(4, 4) + @"\" + emp.LicenceAtt.Substring(8))));
GenericDataAccess.UpdateBySql("Insert into YZAppAttachment(FileID,Name,Ext,Size,OwnerAccount) values(@FileID,@Name,@Ext,@Size,@OwnerAccount)", new string[, ] {
{ "@FileID", emp.LicenceAtt, "DbType.String", null },
{ "@Name", Path.GetFileName(fLicenceAtt.FileName), "DbType.String", null },
{ "@Ext", Path.GetExtension(fLicenceAtt.FileName), "DbType.String", null },
{ "@Size", fLicenceAtt.ContentLength.ToString(), "DbType.Int32", null },
{ "@OwnerAccount", "0", "DbType.String", null }
});
}
emp.DelegateBook = DateTime.Now.ToString("yyyyMMdd") + Guid.NewGuid().ToString("N");
if (fDelegateBook != null)
{
Directory.CreateDirectory(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.DelegateBook.Substring(0, 4) + @"\" + emp.DelegateBook.Substring(4, 4) + @"\")));
fDelegateBook.SaveAs(Path.Combine(System.Web.Configuration.WebConfigurationManager.AppSettings["AttachmentRootPath"], (emp.DelegateBook.Substring(0, 4) + @"\" + emp.DelegateBook.Substring(4, 4) + @"\" + emp.DelegateBook.Substring(8))));
GenericDataAccess.UpdateBySql("Insert into YZAppAttachment(FileID,Name,Ext,Size,OwnerAccount) values(@FileID,@Name,@Ext,@Size,@OwnerAccount)", new string[, ] {
{ "@FileID", emp.DelegateBook, "DbType.String", null },
{ "@Name", Path.GetFileName(fDelegateBook.FileName), "DbType.String", null },
{ "@Ext", Path.GetExtension(fDelegateBook.FileName), "DbType.String", null },
{ "@Size", fDelegateBook.ContentLength.ToString(), "DbType.Int32", null },
{ "@OwnerAccount", "0", "DbType.String", null }
});
}
emp.RegisterDate = System.DateTime.Now;
db.SaveChanges();
//WebSecurity.Login(emp.NumberEmp, register.Password);
//System.Web.Routing.RouteValueDictionary routv= new System.Web.Routing.RouteValueDictionary();
//routv.Add("EmpID","6");
//return RedirectToAction("Create", "Tender_CompanyInfo", routv);
// scope.Complete();
//}
return(Content("注册成功！请登录"));
//return RedirectToLocal("/");
}
return(View());
}