/// <summary>
/// 提交企业合同信息添加审核
/// </summary>
/// <param name="ID">审核表ID</param>
/// <returns></returns>
public int PassAdd(int ID)
{
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 = new CRM_CompanyContract();
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;//启用
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_CompanyContract.Add(comModel);
return(db.SaveChanges());
}
}
/// <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="entity">修改信息</param>
/// <returns></returns>
public int ModifyContract(CRM_CompanyContract_Audit entity)
{
if (entity != null)
{
using (SysEntities db = new SysEntities())
{
CRM_CompanyContract linkModel = db.CRM_CompanyContract.Where(e => e.ID == entity.CRM_CompanyContract_ID).FirstOrDefault();
linkModel.Status = 2;//修改中
db.CRM_CompanyContract_Audit.Add(entity);
return(db.SaveChanges());
}
}
else
{
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());
}
}
// 创建新公司
//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);
}
}
}
}
