/// <summary>
/// 修改密码
/// </summary>
/// <param name="personName">用户名</param>
/// <param name="oldPassword">旧密码</param>
/// <param name="newPassword">新密码</param>
/// <returns>修改密码是否成功</returns>
public bool ChangePassword(string personName, string oldPassword, string newPassword)
{
if (!string.IsNullOrWhiteSpace(personName) && !string.IsNullOrWhiteSpace(oldPassword) && !string.IsNullOrWhiteSpace(newPassword))
{
try
{
string oldPasswordEncryptString = EncryptAndDecrypte.EncryptString(oldPassword);
string newPasswordEncryptString = EncryptAndDecrypte.EncryptString(newPassword);
using (SysEntities db = new SysEntities())
{
var person = db.SysPerson.FirstOrDefault(p => (p.Name == personName) && (p.Password == oldPasswordEncryptString));
person.Password = newPasswordEncryptString;
person.SurePassword = newPasswordEncryptString;
if (!string.IsNullOrWhiteSpace(person.EmailAddress))
{
NetSendMail.MailSendChangePassword(db, person.EmailAddress, personName, newPassword);
//发送通知的邮件
}
db.SaveChanges();
return true;
}
}
catch (Exception ex)
{
ExceptionsHander.WriteExceptions(ex);
}
}
return false;
}
/// <summary>
/// 验证用户名和密码是否正确
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="password">密码</param>
/// <returns>登录成功后的用户信息</returns>
public SysPerson ValidateUser(string userName, string password)
{
if (String.IsNullOrWhiteSpace(userName) || String.IsNullOrWhiteSpace(password))
return null;
//获取用户信息,请确定web.config中的连接字符串正确
using (SysEntities db = new SysEntities())
{
var person = (from p in db.SysPerson
where p.Name == userName
&& p.Password == password
&& p.State == "开启"
select p).FirstOrDefault();
if (person != null)
{//登录成功
person.LastLogonTime = person.LogonTime;
person.LastLogonIP = person.LogonIP;
person.LogonNum++;
person.LogonTime = DateTime.Now;
person.LogonIP = Common.IP.GetIP();
db.SaveChanges();
return person;
}
} return null;
}
/// <summary>
/// 创建一个菜单
/// </summary>
/// <param name="validationErrors">返回的错误信息</param>
/// <param name="db">数据库上下文</param>
/// <param name="entity">一个菜单</param>
/// <returns></returns>
public bool Create(ref ValidationErrors validationErrors, SysEntities db, SysMenu entity)
{
int count = 1;
foreach (string item in entity.SysOperationId.GetIdSort())
{
SysOperation sys = new SysOperation { Id = item };
db.SysOperation.Attach(sys);
entity.SysOperation.Add(sys);
count++;
}
repository.Create(db, entity);
if (count == repository.Save(db))
{
//创建后重置菜单编码
List<int> flags = new List<int>();//层级
GetMenus2(null, flags);
db.SaveChanges();
return true;
}
else
{
validationErrors.Add("创建出错了");
}
return false;
}
/// <summary>
/// 添加员工
/// </summary>
/// <param name="baseModel"></param>
/// <param name="contactModel"></param>
/// <param name="bankModel"></param>
/// <returns></returns>
public int EmployeeAdd(Employee baseModel, EmployeeContact contactModel, EmployeeBank bankModel, CompanyEmployeeRelation relationModel)
{
using (SysEntities db = new SysEntities())
{
using (var tran = db.Database.BeginTransaction())
{
try
{
//创建公司
db.Employee.Add(baseModel);
db.SaveChanges();
//添加联系方式
contactModel.EmployeeId = baseModel.Id;
db.EmployeeContact.Add(contactModel);
//添加银行信息
if (bankModel != null)
{
bankModel.EmployeeId = baseModel.Id;
db.EmployeeBank.Add(bankModel);
}
//企业员工关系
relationModel.EmployeeId = baseModel.Id;
db.CompanyEmployeeRelation.Add(relationModel);
db.SaveChanges();
tran.Commit();
return(1);
}
catch (Exception ex)
{
tran.Rollback();
return(0);
}
}
}
}
/// <summary>
/// 退回企业合同信息修改审核
/// </summary>
/// <param name="ID">审核表ID</param>
/// <param name="mainTableID">原表ID</param>
/// <returns></returns>
public int ReturnEdit(int ID, int mainTableID)
{
using (SysEntities db = new SysEntities())
{
CRM_CompanyContract comModel = db.CRM_CompanyContract.Where(e => e.ID == mainTableID).FirstOrDefault();
comModel.Status = 1;//启用
CRM_CompanyContract_Audit comAudit = db.CRM_CompanyContract_Audit.Where(c => c.ID == ID).FirstOrDefault();
comAudit.OperateStatus = 0;//未通过
return(db.SaveChanges());
}
}
/// <summary>
/// 提交企业银行信息修改审核
/// </summary>
/// <param name="ID">审核表ID</param>
/// <param name="mainTableID">原表ID</param>
/// <returns></returns>
public int PassEdit(int ID, int mainTableID)
{
using (SysEntities db = new SysEntities())
{
CRM_CompanyBankAccount_Audit comAudit = db.CRM_CompanyBankAccount_Audit.Where(c => c.ID == ID).FirstOrDefault();
comAudit.OperateStatus = 2;//成功
CRM_CompanyBankAccount comModel = db.CRM_CompanyBankAccount.Where(e => e.ID == mainTableID).FirstOrDefault();
comModel.Account = comAudit.Account;
comModel.Bank = comAudit.Bank;
comModel.Status = 1;//启用
return(db.SaveChanges());
}
}
/// <summary>
/// 提交企业财务信息（开票）修改审核
/// </summary>
/// <param name="ID">审核表ID</param>
/// <param name="mainTableID">原表ID</param>
/// <returns></returns>
public int PassEdit(int ID, int mainTableID)
{
using (SysEntities db = new SysEntities())
{
CRM_CompanyFinance_Bill_Audit comAudit = db.CRM_CompanyFinance_Bill_Audit.Where(c => c.ID == ID).FirstOrDefault();
comAudit.OperateStatus = 2;//成功
CRM_CompanyFinance_Bill comModel = db.CRM_CompanyFinance_Bill.Where(e => e.ID == mainTableID).FirstOrDefault();
comModel.BillName = comAudit.BillName;
comModel.TaxRegistryNumber = comAudit.TaxRegistryNumber;
comModel.Status = 1;//启用
return(db.SaveChanges());
}
}
/// <summary>
/// 提交企业报价信息修改审核
/// </summary>
/// <param name="ID">审核表ID</param>
/// <param name="mainTableID">原表ID</param>
/// <returns></returns>
public int PassEdit(int ID, int mainTableID)
{
using (SysEntities db = new SysEntities())
{
CRM_CompanyPrice_Audit comAudit = db.CRM_CompanyPrice_Audit.Where(c => c.ID == ID).FirstOrDefault();
comAudit.OperateStatus = 2;//成功
CRM_CompanyPrice comModel = db.CRM_CompanyPrice.Where(e => e.ID == mainTableID).FirstOrDefault();
comModel.AddPrice = comAudit.AddPrice;
comModel.LowestPrice = comAudit.LowestPrice;
comModel.PRD_Product_ID = comAudit.PRD_Product_ID;
comModel.Status = 1;//启用
return(db.SaveChanges());
}
}
/// <summary>
/// 修改默认联系人
/// </summary>
/// <param name="id">联系人表id</param>
/// <returns></returns>
public int SetDefault(int id, int companyID)
{
using (SysEntities db = new SysEntities())
{
var data = db.CRM_CompanyLinkMan.Where(e => (e.CRM_Company_ID == companyID && e.IsDefault == "Y"));
if (data.Count() > 0)
{
foreach (var item in data)
{
item.IsDefault = "N";
}
}
db.CRM_CompanyLinkMan.Where(e => e.ID == id).FirstOrDefault().IsDefault = "Y";
return(db.SaveChanges());
}
}
/// <summary>
/// 修改默认联系人
/// </summary>
/// <param name="id">联系人表id</param>
/// <returns></returns>
public int SetDefault(string id, int supplierID)
{
using (SysEntities db = new SysEntities())
{
var data = db.SupplierLinkMan.Where(e => (e.SupplierId == supplierID && e.IsDefault == "Y"));
if (data.Count() > 0)
{
foreach (var item in data)
{
item.IsDefault = "N";
}
}
db.SupplierLinkMan.Where(e => e.Id == id).FirstOrDefault().IsDefault = "Y";
return(db.SaveChanges());
}
}
/// <summary>
/// 提交企业阶梯报价信息修改审核
/// </summary>
/// <param name="entity">修改信息</param>
/// <returns></returns>
public int ModifyLadderPrice(CRM_CompanyLadderPrice_Audit entity)
{
if (entity != null)
{
using (SysEntities db = new SysEntities())
{
CRM_CompanyLadderPrice linkModel = db.CRM_CompanyLadderPrice.Where(e => e.ID == entity.CRM_CompanyLadderPrice_ID).FirstOrDefault();
linkModel.Status = 2;//修改中
db.CRM_CompanyLadderPrice_Audit.Add(entity);
return(db.SaveChanges());
}
}
else
{
return(0);
}
}
/// <summary>
/// 停用企业报价信息
/// </summary>
/// <param name="entity">修改信息</param>
/// <returns></returns>
public int StopPrice(int ID)
{
using (SysEntities db = new SysEntities())
{
CRM_CompanyPrice model = db.CRM_CompanyPrice.Where(c => c.ID == ID).FirstOrDefault();
model.Status = 0;//停用
List <CRM_CompanyLadderPrice> list = new List <CRM_CompanyLadderPrice>();
list = db.CRM_CompanyLadderPrice.Where(c => c.CRM_Company_ID == model.CRM_Company_ID && c.PRD_Product_ID == model.PRD_Product_ID).ToList();
foreach (CRM_CompanyLadderPrice l in list)
{
l.Status = 0;//停用
}
return(db.SaveChanges());
}
}
/// <summary>
/// 提交企业银行信息修改审核
/// </summary>
/// <param name="entity">修改信息</param>
/// <returns></returns>
public int ModifyBank(CRM_CompanyBankAccount_Audit entity)
{
if (entity != null)
{
using (SysEntities db = new SysEntities())
{
CRM_CompanyBankAccount bankModel = db.CRM_CompanyBankAccount.Where(e => e.ID == entity.CRM_CompanyBankAccount_ID).FirstOrDefault();
bankModel.Status = 2;//修改中
db.CRM_CompanyBankAccount_Audit.Add(entity);
return(db.SaveChanges());
}
}
else
{
return(0);
}
}
/// <summary>
/// 停用企业报价信息
/// </summary>
/// <param name="entity">修改信息</param>
/// <returns></returns>
public bool StopPrice(SysEntities db, string ID)
{
using (db)
{
LadderLowestPrice model = db.LadderLowestPrice.Where(c => c.Id == ID).FirstOrDefault();
model.Status = Common.Status.停用.ToString();//停用
List <LadderPrice> list = new List <LadderPrice>();
list = db.LadderPrice.Where(c => c.LadderLowestPriceId == model.Id).ToList();
foreach (LadderPrice l in list)
{
l.Status = Common.Status.停用.ToString();//停用
}
return(db.SaveChanges().GetBool());
}
}
/// <summary>
/// 审核退回修改信息
/// </summary>
/// <param name="companyID">企业ID</param>
/// <param name="cityID">缴纳地ID</param>
/// <returns></returns>
public bool ReturnEdit(SysEntities db, int companyID, string cityID)
{
try
{
int operateType = (int)Common.OperateType.修改;
int operateState = (int)Common.AuditStatus.待处理;
string state = Common.Status.修改中.ToString();
//DateTime dtnow = DateTime.Now;
var AuditI = db.CRM_Company_Insurance_Audit.Where(c => c.CRM_Company_ID == companyID && c.City == cityID && c.OperateType == operateType && c.OperateStatus == operateState && c.OperateNode == 2);
var AuditPI = db.CRM_Company_PoliceInsurance_Audit.Where(c => c.CRM_Company_ID == companyID && c.City == cityID && c.OperateType == operateType && c.OperateStatus == operateState && c.OperateNode == 2);
var updI = db.CRM_Company_Insurance.Where(c => c.CRM_Company_ID == companyID && c.City == cityID && c.State == state);
var updPI = db.CRM_Company_PoliceInsurance.Where(c => c.CRM_Company_ID == companyID && c.City == cityID && c.State == state);
foreach (var modelI in AuditI)
{
//设置失败
modelI.OperateStatus = (int)Common.AuditStatus.失败;
}
foreach (var modelPI in AuditPI)
{
//设置失败
modelPI.OperateStatus = (int)Common.AuditStatus.失败;
}
foreach (var modelI in updI)
{
//设置启用
modelI.State = Common.Status.启用.ToString();
}
foreach (var modelPI in updPI)
{
//设置启用
modelPI.State = Common.Status.启用.ToString();
}
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 提交企业联系人信息修改审核
/// </summary>
/// <param name="ID">审核表ID</param>
/// <param name="mainTableID">原表ID</param>
/// <returns></returns>
public int PassEdit(int ID, int mainTableID)
{
using (SysEntities db = new SysEntities())
{
CRM_CompanyLinkMan_Audit comAudit = db.CRM_CompanyLinkMan_Audit.Where(c => c.ID == ID).FirstOrDefault();
comAudit.OperateStatus = 2;//成功
CRM_CompanyLinkMan comModel = db.CRM_CompanyLinkMan.Where(e => e.ID == mainTableID).FirstOrDefault();
comModel.LinkManName = comAudit.LinkManName;
comModel.Mobile = comAudit.Mobile;
comModel.Position = comAudit.Position;
comModel.Remark = comAudit.Remark;
comModel.Telephone = comAudit.Telephone;
comModel.Email = comAudit.Email;
comModel.Address = comAudit.Address;
comModel.Status = 1;//启用
return(db.SaveChanges());
}
}
/// <summary>
/// 修改供应商基本信息
/// </summary>
/// <param name="viewModel">供应商</param>
/// <returns></returns>
public int EditSupplier(SupplierView viewModel)
{
using (SysEntities db = new SysEntities())
{
using (var tran = db.Database.BeginTransaction())
{
try
{
//基本信息
var entity = db.Supplier.Where(e => e.Id == viewModel.Id).FirstOrDefault();
entity.Code = viewModel.Code;
entity.Name = viewModel.Name;
entity.OfficeAddress = viewModel.OfficeAddress;
entity.OrganizationCode = viewModel.OrganizationCode;
entity.RegisterAddress = viewModel.RegisterAddress;
//社保缴纳地
var oldCityList = db.SupplierNatureCity.Where(e => e.SupplierId == viewModel.Id).ToList();
string[] arrOldCity = new string[oldCityList.Count()];//旧城市ID数组
for (int i = 0; i < oldCityList.Count(); i++)
{
arrOldCity[i] = oldCityList[i].NatureCityId;
}
List <SupplierNatureCity> newCityList = GetCityList(viewModel.Id, viewModel.NatureCityId, arrOldCity);
if (newCityList.Count > 0)
{
db.SupplierNatureCity.RemoveRange(oldCityList);
db.SupplierNatureCity.AddRange(newCityList);
}
db.SaveChanges();
tran.Commit();
return(1);
}
catch (Exception ex)
{
tran.Rollback();
return(0);
}
}
}
}
/// <summary>
/// 提交企业合同信息修改审核
/// </summary>
/// <param name="ID">审核表ID</param>
/// <param name="mainTableID">原表ID</param>
/// <returns></returns>
public int PassEdit(int ID, int mainTableID)
{
using (SysEntities db = new SysEntities())
{
CRM_CompanyContract_Audit comAudit = db.CRM_CompanyContract_Audit.Where(c => c.ID == ID).FirstOrDefault();
comAudit.OperateStatus = 2;//成功
CRM_CompanyContract comModel = db.CRM_CompanyContract.Where(e => e.ID == mainTableID).FirstOrDefault();
comModel.BillDay = comAudit.BillDay;
comModel.ChangeDay = comAudit.ChangeDay;
comModel.DatumDay = comAudit.DatumDay;
comModel.FeesCycle = comAudit.FeesCycle;
comModel.ReceivedDay = comAudit.ReceivedDay;
comModel.SendBillDay = comAudit.SendBillDay;
comModel.ServceEndDay = comAudit.ServceEndDay;
comModel.ServiceBeginDay = comAudit.ServceEndDay;
comModel.Status = 1;//启用
return(db.SaveChanges());
}
}
/// <summary>
/// 提交企业财务信息（付款）添加审核
/// </summary>
/// <param name="ID">审核表ID</param>
/// <returns></returns>
public int PassAdd(int ID)
{
using (SysEntities db = new SysEntities())
{
CRM_CompanyFinance_Payment_Audit comAudit = db.CRM_CompanyFinance_Payment_Audit.Where(c => c.ID == ID).FirstOrDefault();
comAudit.OperateStatus = 2;//成功
CRM_CompanyFinance_Payment comModel = new CRM_CompanyFinance_Payment();
comModel.PaymentName = comAudit.PaymentName;
comModel.Status = 1;//启用
comModel.CRM_Company_ID = Convert.ToInt32(comAudit.CRM_Company_ID);
comModel.CreateTime = comAudit.CreateTime;
comModel.CreateUserID = comAudit.CreateUserID;
comModel.CreateUserName = comAudit.CreateUserName;
comModel.BranchID = comAudit.BranchID;
db.CRM_CompanyFinance_Payment.Add(comModel);
return(db.SaveChanges());
}
}
/// <summary>
/// 批量更新供应商客服
/// </summary>
/// <param name="id">供应商编号</param>
/// <param name="customerServiceId">供应商客服ID</param>
/// <returns></returns>
public bool UpdateCustomerService(int?[] ids, int customerServiceId)
{
using (SysEntities db = new SysEntities())
{
try
{
var query = from supplier in db.Supplier
where ids.Contains(supplier.Id)
select supplier;
var f = query.ToList();
foreach (var item in f)
{
item.CustomerServiceId = customerServiceId;
}
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
/// <summary>
/// 批量删除角色（将标志位置为‘N’）
/// </summary>
/// <param name="db">数据访问的上下文</param>
/// <param name="id">菜单功能编号</param>
/// <returns></returns>
public bool DeleteRoleOp(int[] ids)
{
using (SysEntities db = new SysEntities())
{
try
{
var query = from menuop in db.ORG_Role
where ids.Contains(menuop.ID)
select menuop;
var f = query.ToList();
foreach (var item in f)
{
item.XYBZ = "N";
}
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
/// <summary>
/// 批量删除供应商（将状态设置为‘停用’）
/// </summary>
/// <param name="id">供应商编号</param>
/// <returns></returns>
public bool DeleteSupplier(int?[] ids)
{
using (SysEntities db = new SysEntities())
{
try
{
var query = from supplier in db.Supplier
where ids.Contains(supplier.Id)
select supplier;
var f = query.ToList();
foreach (var item in f)
{
item.Status = "停用";
}
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
/// <summary>
/// 提交企业阶梯报价信息添加审核
/// </summary>
/// <param name="ID">审核表ID</param>
/// <returns></returns>
public int PassAdd(int ID)
{
using (SysEntities db = new SysEntities())
{
CRM_CompanyLadderPrice_Audit comAudit = db.CRM_CompanyLadderPrice_Audit.Where(c => c.ID == ID).FirstOrDefault();
comAudit.OperateStatus = 2;//成功
CRM_CompanyLadderPrice comModel = new CRM_CompanyLadderPrice();
comModel.BeginLadder = comAudit.BeginLadder;
comModel.EndLadder = comAudit.EndLadder;
comModel.PRD_Product_ID = comAudit.PRD_Product_ID;
comModel.SinglePrice = comAudit.SinglePrice;
comModel.Status = 1;//启用
comModel.CRM_Company_ID = Convert.ToInt32(comAudit.CRM_Company_ID);
comModel.CreateTime = comAudit.CreateTime;
comModel.CreateUserID = comAudit.CreateUserID;
comModel.CreateUserName = comAudit.CreateUserName;
comModel.BranchID = comAudit.BranchID;
db.CRM_CompanyLadderPrice.Add(comModel);
return(db.SaveChanges());
}
}
// 创建新公司
//public int CreateNewCompany(CRM_Company baseModel, CRM_CompanyContract contractModel, CRM_CompanyToBranch branchModel, List<CRM_CompanyLinkMan> listLink, List<CRM_CompanyBankAccount> listBank, List<CRM_CompanyFinance_Bill> listBill, List<CRM_CompanyFinance_Payment> listPay, List<CRM_CompanyPrice> listPrice, List<CRM_CompanyLadderPrice> listLadderPrice)
public int CreateNewCompany(CRM_Company baseModel, CRM_CompanyContract contractModel, CRM_CompanyToBranch branchModel, List <CRM_CompanyLinkMan> listLink, List <CRM_CompanyBankAccount> listBank, List <CRM_CompanyFinance_Bill> listBill, List <CRM_CompanyFinance_Payment> listPay, List <CRM_CompanyPrice> listPrice, List <CRM_CompanyLadderPrice> listLadderPrice, List <CRM_Company_PoliceInsurance> CompanyPoliceInsurance, List <CRM_Company_Insurance> CompanyInsurance)
{
using (SysEntities db = new SysEntities())
{
using (var tran = db.Database.BeginTransaction())
{
try
{
//创建公司
db.CRM_Company.Add(baseModel);
db.SaveChanges();
baseModel.CompanyCode = baseModel.ID.ToString();//编号等于ID
//添加公司分支机构
branchModel.CRM_Company_ID = baseModel.ID;
db.CRM_CompanyToBranch.Add(branchModel);
//添加合同信息
contractModel.CRM_Company_ID = baseModel.ID;
db.CRM_CompanyContract.Add(contractModel);
//联系人
if (listLink != null && listLink.Count > 0)
{
listLink = GetLinkList(listLink, baseModel.ID);
db.CRM_CompanyLinkMan.AddRange(listLink);
}
//银行
if (listBank != null && listBank.Count > 0)
{
listBank = GetBankList(listBank, baseModel.ID);
db.CRM_CompanyBankAccount.AddRange(listBank);
}
//开票
if (listBill != null && listBill.Count > 0)
{
listBill = GetBillList(listBill, baseModel.ID);
db.CRM_CompanyFinance_Bill.AddRange(listBill);
}
//回款
if (listPay != null && listPay.Count > 0)
{
listPay = GetPayList(listPay, baseModel.ID);
db.CRM_CompanyFinance_Payment.AddRange(listPay);
}
//报价
if (listPrice != null && listPrice.Count > 0)
{
listPrice = GetPriceList(listPrice, baseModel.ID);
db.CRM_CompanyPrice.AddRange(listPrice);
}
//阶梯报价
if (listLadderPrice != null && listLadderPrice.Count > 0)
{
listLadderPrice = GetLadderList(listLadderPrice, baseModel.ID);
db.CRM_CompanyLadderPrice.AddRange(listLadderPrice);
}
//企业社保政策
if (CompanyPoliceInsurance != null && CompanyPoliceInsurance.Count > 0)
{
CompanyPoliceInsurance = GetPoliceInsuranceList(CompanyPoliceInsurance, baseModel.ID);
db.CRM_Company_PoliceInsurance.AddRange(CompanyPoliceInsurance);
}
//企业社保信息
if (CompanyInsurance != null && CompanyInsurance.Count > 0)
{
CompanyInsurance = GetInsuranceList(CompanyInsurance, baseModel.ID);
db.CRM_Company_Insurance.AddRange(CompanyInsurance);
}
db.SaveChanges();
tran.Commit();
return(1);
}
catch (Exception ex)
{
tran.Rollback();
return(0);
}
}
}
}
/// <summary>
/// 编辑一个菜单
/// </summary>
/// <param name="validationErrors">返回的错误信息</param>
/// <param name="db">数据上下文</param>
/// <param name="entity">一个菜单</param>
/// <returns>是否编辑成功</returns>
public bool Edit(ref ValidationErrors validationErrors, SysEntities db, SysMenu entity)
{
/*
* 不操作 原有 现有
* 增加 原没 现有
* 删除 原有 现没
*/
if (entity == null)
{
return false;
}
int count = 1;
List<string> addSysOperationId = new List<string>();
List<string> deleteSysOperationId = new List<string>();
DataOfDiffrent.GetDiffrent(entity.SysOperationId.GetIdSort(), entity.SysOperationIdOld.GetIdSort(), ref addSysOperationId, ref deleteSysOperationId);
List<SysOperation> listEntitySysOperation = new List<SysOperation>();
if (deleteSysOperationId != null && deleteSysOperationId.Count() > 0)
{
foreach (var item in deleteSysOperationId)
{
SysOperation sys = new SysOperation { Id = item };
listEntitySysOperation.Add(sys);
entity.SysOperation.Add(sys);
}
}
SysMenu editEntity = repository.Edit(db, entity);
if (addSysOperationId != null && addSysOperationId.Count() > 0)
{
foreach (var item in addSysOperationId)
{
SysOperation sys = new SysOperation { Id = item };
db.SysOperation.Attach(sys);
editEntity.SysOperation.Add(sys);
count++;
}
}
if (deleteSysOperationId != null && deleteSysOperationId.Count() > 0)
{
foreach (SysOperation item in listEntitySysOperation)
{
editEntity.SysOperation.Remove(item);
count++;
}
}
if (count == repository.Save(db))
{
//修改后重置菜单编码
List<int> flags = new List<int>();//层级
GetMenus2(null, flags);
db.SaveChanges();
return true;
}
else
{
validationErrors.Add("编辑菜单出错了");
}
return false;
}
/// <summary>
/// 配置角色权限
/// </summary>
/// <param name="id"></param>
/// <param name="isEditOpt"></param>
/// <param name="isEditDpt"></param>
/// <param name="isEditData"></param>
/// <param name="selectedMenuOpt"></param>
/// <param name="selectedMenuDpt"></param>
/// <param name="selectedMenuScope"></param>
/// <returns></returns>
private bool ConfigRloe(int id, bool isEditOpt, bool isEditDpt, bool isEditData, string selectedMenuOpt, string selectedMenuDpt, string selectedMenuScope)
{
try
{
using (SysEntities db = new SysEntities())
{
if (isEditOpt)
{
#region 配置操作权限
//删除操作权限
//dal.Delete<ORG_RoleMenuOpAuthority>(string.Format(" ORG_Role_ID = {0}", id));
//db.Database.ExecuteSqlCommand("delete from ORG_RoleMenuOpAuthority where ORG_Role_ID = " + id, null);
IEnumerable <ORG_RoleMenuOpAuthority> MenuOps_Old = db.ORG_RoleMenuOpAuthority.Where(c => c.ORG_Role_ID == id);
db.ORG_RoleMenuOpAuthority.RemoveRange(MenuOps_Old);
//重新添加操作权限
if (!string.IsNullOrEmpty(selectedMenuOpt))
{
//拆解成（菜单:操作1,操作2）类型的集合
string[] tmpMenusOpts = selectedMenuOpt.Split(';');
ORG_RoleMenuOpAuthority MenuOp = new ORG_RoleMenuOpAuthority();
foreach (string tmpMenuOpts in tmpMenusOpts)
{
if (!string.IsNullOrEmpty(tmpMenuOpts))
{
//拆解菜单和菜单操作
string[] strMenuOpts = tmpMenuOpts.Split(':');
MenuOp = new ORG_RoleMenuOpAuthority();
MenuOp.ORG_Role_ID = id;
MenuOp.ORG_Menu_ID = strMenuOpts[0];//菜单ID
//若有操作，则存入菜单操作ID集合
if (strMenuOpts.Length > 1)
{
MenuOp.ORG_MenuOp_ID_List = strMenuOpts[1];
}
//dal.Add<ORG_RoleMenuOpAuthority>(MenuOp);
db.ORG_RoleMenuOpAuthority.Add(MenuOp);
}
}
}
#endregion
}
if (isEditDpt)
{
#region 配置部门业务权限
//拆解成（菜单:部门1,部门2）类型的集合
string[] tmpMenuDpt = selectedMenuDpt.Split(';');
foreach (string md in tmpMenuDpt)
{
string[] menu_dpt = md.Split(':');
if (menu_dpt.Length > 0)
{
//删除部门的菜单部门权限
//dal.Delete<ORG_RoleDepartmentAuthority>(string.Format(" ORG_Role_ID = {0} and ORG_Menu_ID = '{1}'", id, menu_dpt[0]));
string menuId = menu_dpt[0];
IEnumerable <ORG_RoleDepartmentAuthority> RoleDeparts_Old = db.ORG_RoleDepartmentAuthority.Where(c => c.ORG_Role_ID == id && c.ORG_Menu_ID == menuId);
db.ORG_RoleDepartmentAuthority.RemoveRange(RoleDeparts_Old);
}
if (menu_dpt.Length == 2 && menu_dpt[1] != "")
{
//添加部门权限
ORG_RoleDepartmentAuthority DptAuthority = new ORG_RoleDepartmentAuthority();
DptAuthority = new ORG_RoleDepartmentAuthority();
DptAuthority.ORG_Role_ID = id;
DptAuthority.ORG_Menu_ID = menu_dpt[0];
DptAuthority.ORG_Department_ID_List = menu_dpt[1];
//dal.Add<ORG_RoleDepartmentAuthority>(DptAuthority);
db.ORG_RoleDepartmentAuthority.Add(DptAuthority);
}
}
#endregion
}
if (isEditData)
{
#region 配置部门范围权限
//分解成（菜单:范围）类型的集合
string[] tmpMenuScope = selectedMenuScope.Split(';');
foreach (string strMenuScope in tmpMenuScope)
{
string[] menuScope = strMenuScope.Split(':');
//删除原有权限
//dal.Delete<ORG_RoleDepartmenScopetAuthority>(string.Format("ORG_Role_ID = {0} and ORG_Menu_ID = '{1}'", id, menuScope[0]));
string menuId = menuScope[0];
IEnumerable <ORG_RoleDepartmenScopetAuthority> Scopes_Olds = db.ORG_RoleDepartmenScopetAuthority.Where(c => c.ORG_Role_ID == id && c.ORG_Menu_ID == menuId);
db.ORG_RoleDepartmenScopetAuthority.RemoveRange(Scopes_Olds);
//添加部门范围权限
ORG_RoleDepartmenScopetAuthority Scopet = new ORG_RoleDepartmenScopetAuthority();
Scopet.ORG_Role_ID = id;
Scopet.ORG_Menu_ID = menuScope[0];
Scopet.DepartmentScope = Convert.ToInt32(menuScope[1]);
//dal.Add<ORG_RoleDepartmenScopetAuthority>(Scopet);
db.ORG_RoleDepartmenScopetAuthority.Add(Scopet);
//菜单范围权限不为0（无限制）时，删除部门业务权限
if (menuScope[1] != "0")
{
//删除部门的菜单部门权限
//dal.Delete<ORG_RoleDepartmentAuthority>(string.Format("ORG_Role_ID = {0} and ORG_Menu_ID = '{1}'", id, menuScope[0]));
IEnumerable <ORG_RoleDepartmentAuthority> RoleDeparts_Err = db.ORG_RoleDepartmentAuthority.Where(c => c.ORG_Role_ID == id && c.ORG_Menu_ID == menuId);
db.ORG_RoleDepartmentAuthority.RemoveRange(RoleDeparts_Err);
}
}
#endregion
}
db.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 提交保存，持久化到数据库
/// </summary>
/// <param name="db">实体数据</param>
/// <returns>受影响行数</returns>
public int Save(SysEntities db)
{
return(db.SaveChanges());
}
/// <summary>
/// 审核通过修改信息
/// </summary>
/// <param name="companyID">企业ID</param>
/// <param name="cityID">缴纳地ID</param>
/// <returns></returns>
public bool PassEdit(SysEntities db, int companyID, string cityID)
{
try
{
int operateType = (int)Common.OperateType.修改;
int operateState = (int)Common.AuditStatus.待处理;
string state = Common.Status.修改中.ToString();
//DateTime dtnow = DateTime.Now;
var updI = db.CRM_Company_Insurance_Audit.Where(c => c.CRM_Company_ID == companyID && c.City == cityID && c.OperateType == operateType && c.OperateStatus == operateState && c.OperateNode == 2);
var updPI = db.CRM_Company_PoliceInsurance_Audit.Where(c => c.CRM_Company_ID == companyID && c.City == cityID && c.OperateType == operateType && c.OperateStatus == operateState && c.OperateNode == 2);
var delI = db.CRM_Company_Insurance.Where(c => c.CRM_Company_ID == companyID && c.City == cityID && c.State == state);
var delPI = db.CRM_Company_PoliceInsurance.Where(c => c.CRM_Company_ID == companyID && c.City == cityID && c.State == state);
//删除正式表元数据
db.CRM_Company_Insurance.RemoveRange(delI);
db.CRM_Company_PoliceInsurance.RemoveRange(delPI);
List <CRM_Company_Insurance> ListI = new List <CRM_Company_Insurance>();
List <CRM_Company_PoliceInsurance> ListPI = new List <CRM_Company_PoliceInsurance>();
foreach (var modelI in updI)
{
//设置成功
modelI.OperateStatus = (int)Common.AuditStatus.成功;
//数据复制到正式表
CRM_Company_Insurance entityI = new CRM_Company_Insurance();
entityI.Account = modelI.Account;
entityI.City = modelI.City;
entityI.CreatePerson = modelI.CreatePerson;
entityI.CreateTime = modelI.CreateTime;
entityI.CRM_Company_ID = companyID;
entityI.InsuranceKind = modelI.InsuranceKind;
entityI.State = modelI.State;
ListI.Add(entityI);
}
foreach (var modelPI in updPI)
{
//设置成功
modelPI.OperateStatus = (int)Common.AuditStatus.成功;
//数据复制到正式表
CRM_Company_PoliceInsurance entityPI = new CRM_Company_PoliceInsurance();
entityPI.City = modelPI.City;
entityPI.CreatePerson = modelPI.CreatePerson;
entityPI.CreateTime = modelPI.CreateTime;
entityPI.CRM_Company_ID = companyID;
entityPI.InsuranceKind = modelPI.InsuranceKind;
entityPI.PoliceInsurance = modelPI.PoliceInsurance;
entityPI.State = modelPI.State;
ListPI.Add(entityPI);
}
db.CRM_Company_Insurance.AddRange(ListI);
db.CRM_Company_PoliceInsurance.AddRange(ListPI);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 修改企业社保信息
/// </summary>
/// <param name="db"></param>
/// <param name="model">社保信息实体</param>
/// <param name="userID">操作人ID</param>
/// <param name="userName">操作人姓名</param>
/// <param name="branchID">所属分支机构</param>
/// <returns></returns>
public bool UpdateCRM_Company_Insurance(SysEntities db, CompanyInsurance model, int userID, string userName, int branchID)
{
try
{
DateTime dtnow = DateTime.Now;
List <CRM_Company_Insurance_Audit> ListI = new List <CRM_Company_Insurance_Audit>();
CRM_Company_Insurance_Audit ModelI = new CRM_Company_Insurance_Audit();
List <CRM_Company_PoliceInsurance_Audit> ListPI = new List <CRM_Company_PoliceInsurance_Audit>();
CRM_Company_PoliceInsurance_Audit ModelPI = new CRM_Company_PoliceInsurance_Audit();
string[] Accounts = model.Account1 == null ? null : model.Account1.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
string[] Polices1 = model.PoliceID1 == null ? null : model.PoliceID1.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
string[] Polices2 = model.PoliceID2 == null ? null : model.PoliceID2.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
List <CRM_Company_Insurance> ListI_Old = db.CRM_Company_Insurance.Where(c => c.City == model.CityId && c.CRM_Company_ID == model.CRM_Company_ID).OrderBy(c => c.InsuranceKind).ToList();
List <CRM_Company_PoliceInsurance> ListPI_Old = db.CRM_Company_PoliceInsurance.Where(c => c.City == model.CityId && c.CRM_Company_ID == model.CRM_Company_ID).OrderBy(c => c.InsuranceKind).ToList();
//公积金账户
if (!string.IsNullOrEmpty(model.Account2))
{
ModelI = new CRM_Company_Insurance_Audit();
ModelI.Account = model.Account2;
ModelI.InsuranceKind = (int)Common.EmployeeAdd_InsuranceKindId.公积金;
ModelI.CRM_Company_ID = model.CRM_Company_ID;
ModelI.City = model.CityId;
CRM_Company_Insurance oldGGJ = ListI_Old.Where(c => c.InsuranceKind == ModelI.InsuranceKind).ToList().FirstOrDefault();
if (oldGGJ != null)
{
ModelI.CRM_Company_Insurance_ID = oldGGJ.ID;
}
ModelI.State = Common.Status.启用.ToString();
ModelI.CreateTime = dtnow;
ModelI.CreateUserID = userID;
ModelI.CreatePerson = userName;
ModelI.OperateStatus = (int)Common.AuditStatus.待处理; //待处理
ModelI.OperateNode = 2; //质控
ModelI.BranchID = branchID;
ModelI.OperateType = (int)Common.OperateType.修改;
ListI.Add(ModelI);
}
//社保账户
if (!string.IsNullOrEmpty(model.Account1))
{
foreach (string acc in Accounts)
{
string[] account = acc.Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries);
if (account.Length == 2 && !string.IsNullOrEmpty(account[1]))
{
Common.EmployeeAdd_InsuranceKindId getType = (Common.EmployeeAdd_InsuranceKindId)Enum.Parse(typeof(Common.EmployeeAdd_InsuranceKindId), account[0]);
ModelI = new CRM_Company_Insurance_Audit();
ModelI.Account = account[1];
ModelI.InsuranceKind = (int)getType;
ModelI.CRM_Company_ID = model.CRM_Company_ID;
ModelI.City = model.CityId;
CRM_Company_Insurance oldInsurance = ListI_Old.Where(c => c.InsuranceKind == ModelI.InsuranceKind).ToList().FirstOrDefault();
if (oldInsurance != null)
{
ModelI.CRM_Company_Insurance_ID = oldInsurance.ID;
}
//ModelI.CRM_Company_Insurance_ID = ListI_Old.Where(c => c.InsuranceKind == ModelI.InsuranceKind).ToList().FirstOrDefault().ID;
ModelI.State = Common.Status.启用.ToString();
ModelI.CreateTime = dtnow;
ModelI.CreateUserID = userID;
ModelI.CreatePerson = userName;
ModelI.OperateStatus = (int)Common.AuditStatus.待处理; //待处理
ModelI.OperateNode = 2; //质控
ModelI.BranchID = branchID;
ModelI.OperateType = (int)Common.OperateType.修改;
ListI.Add(ModelI);
}
}
}
//公积金政策
if (!string.IsNullOrEmpty(model.PoliceID2))
{
foreach (string po in Polices2)
{
ModelPI = new CRM_Company_PoliceInsurance_Audit();
ModelPI.PoliceInsurance = Convert.ToInt32(po);
ModelPI.InsuranceKind = (int)Common.EmployeeAdd_InsuranceKindId.公积金;
ModelPI.CRM_Company_ID = model.CRM_Company_ID;
ModelPI.City = model.CityId;
CRM_Company_PoliceInsurance oldPiGGJ = ListPI_Old.Where(c => c.InsuranceKind == ModelPI.InsuranceKind).ToList().FirstOrDefault();
if (oldPiGGJ != null)
{
ModelPI.CRM_Company_PoliceInsurance_ID = oldPiGGJ.ID;
}
//ModelPI.CRM_Company_PoliceInsurance_ID = ListPI_Old.Where(c => c.InsuranceKind == ModelPI.InsuranceKind).ToList().FirstOrDefault().ID;
ModelPI.State = Common.Status.启用.ToString();
ModelPI.CreateTime = dtnow;
ModelPI.CreateUserID = userID;
ModelPI.CreatePerson = userName;
ModelPI.OperateStatus = (int)Common.AuditStatus.待处理; //待处理
ModelPI.OperateNode = 2; //质控
ModelPI.BranchID = branchID;
ModelPI.OperateType = (int)Common.OperateType.修改;
ListPI.Add(ModelPI);
}
}
//工伤政策
if (!string.IsNullOrEmpty(model.PoliceID1))
{
foreach (string po in Polices1)
{
ModelPI = new CRM_Company_PoliceInsurance_Audit();
ModelPI.PoliceInsurance = Convert.ToInt32(po);
ModelPI.InsuranceKind = (int)Common.EmployeeAdd_InsuranceKindId.工伤;
ModelPI.CRM_Company_ID = model.CRM_Company_ID;
ModelPI.City = model.CityId;
CRM_Company_PoliceInsurance oldPiGS = ListPI_Old.Where(c => c.InsuranceKind == ModelPI.InsuranceKind).ToList().FirstOrDefault();
if (oldPiGS != null)
{
ModelPI.CRM_Company_PoliceInsurance_ID = oldPiGS.ID;
}
ModelPI.State = Common.Status.启用.ToString();
ModelPI.CreateTime = dtnow;
ModelPI.CreateUserID = userID;
ModelPI.CreatePerson = userName;
ModelPI.OperateStatus = (int)Common.AuditStatus.待处理; //待处理
ModelPI.OperateNode = 2; //质控
ModelPI.BranchID = branchID;
ModelPI.OperateType = (int)Common.OperateType.修改;
ListPI.Add(ModelPI);
}
}
db.CRM_Company_Insurance_Audit.AddRange(ListI);
db.CRM_Company_PoliceInsurance_Audit.AddRange(ListPI);
foreach (var Iold in ListI_Old)
{
Iold.State = Common.Status.修改中.ToString();
}
foreach (var PIold in ListPI_Old)
{
PIold.State = Common.Status.修改中.ToString();
}
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool EmployeeListAdd(List <EmployeeAddExcle> empList, string createPerson)
{
using (SysEntities db = new SysEntities())
{
using (var tran = db.Database.BeginTransaction())
{
try
{
if (empList != null)
{
foreach (EmployeeAddExcle employ in empList)
{
Employee employee = new Employee(); //员工表
EmployeeContact employeeContact = new EmployeeContact(); //联系人表
CompanyEmployeeRelation companyEmployeeRelation = new CompanyEmployeeRelation(); //员工企业关系表
EmployeeBank employeebank = new EmployeeBank(); //员工银行
//员工基本
employee.Name = employ.Empname;
employee.CertificateType = employ.CertificateType;
employee.CertificateNumber = employ.CertificateNumber;
employee.AccountType = employ.AccountType;
employee.Sex = Common.CardCommon.Getsex(employ.CertificateNumber) == 1 ? "男" : "女";
employee.Birthday = Common.CardCommon.GetShengRi(employ.CertificateNumber);
employee.CreateTime = DateTime.Now;
employee.CreatePerson = createPerson;
db.Employee.Add(employee);
//联系人
employeeContact.Telephone = employ.Telephone;
employeeContact.MobilePhone = employ.MobilePhone;
employeeContact.Address = employ.Address;
employeeContact.Email = employ.Email;
employeeContact.EmployeeId = employee.Id;
employeeContact.State = "启用";
employeeContact.CreateTime = DateTime.Now;
employeeContact.CreatePerson = createPerson;
db.EmployeeContact.Add(employeeContact);
db.SaveChanges();
// 银行信息
//if (!string.IsNullOrWhiteSpace(employeebank.AccountName))
{
employeebank.EmployeeId = employee.Id;
employeebank.AccountName = employ.AccountName;
employeebank.Bank = employ.Bank;
employeebank.BranchBank = employ.BranchBank;
employeebank.Account = employ.Account;
employeebank.IsDefault = employ.Account;
employeebank.State = "启用";
employeebank.CreateTime = DateTime.Now;
employeebank.CreatePerson = createPerson;
db.EmployeeBank.Add(employeebank);
db.SaveChanges();
}
//员工关系表
companyEmployeeRelation.CityId = employ.City;
companyEmployeeRelation.CompanyId = employ.CompanyId;
companyEmployeeRelation.EmployeeId = employee.Id;
companyEmployeeRelation.State = "在职";
companyEmployeeRelation.Station = employ.Station;
companyEmployeeRelation.PoliceAccountNatureId = employ.PoliceAccountNature;
companyEmployeeRelation.CreateTime = DateTime.Now;
companyEmployeeRelation.CreatePerson = createPerson;
db.CompanyEmployeeRelation.Add(companyEmployeeRelation);
db.SaveChanges();
}
}
tran.Commit();
return(true);
}
//catch
//{
// tran.Rollback();
// return false;
//}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
tran.Rollback();
foreach (var errors in ex.EntityValidationErrors)
{
foreach (var item in errors.ValidationErrors)
{
Console.WriteLine(item.ErrorMessage + item.PropertyName);
}
}
return(false);
}
}
}
}