/// <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_CompanyPrice comModel = db.CRM_CompanyPrice.Where(e => e.ID == mainTableID).FirstOrDefault(); comModel.Status = 1;//启用 CRM_CompanyPrice_Audit comAudit = db.CRM_CompanyPrice_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_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="entity">修改信息</param> /// <returns></returns> public int ModifyPrice(CRM_CompanyPrice_Audit entity) { if (entity != null) { using (SysEntities db = new SysEntities()) { CRM_CompanyPrice linkModel = db.CRM_CompanyPrice.Where(e => e.ID == entity.CRM_CompanyPrice_ID).FirstOrDefault(); linkModel.Status = 2;//修改中 db.CRM_CompanyPrice_Audit.Add(entity); return(db.SaveChanges()); } } else { return(0); } }
/// <summary> /// 提交企业报价信息添加审核 /// </summary> /// <param name="ID">审核表ID</param> /// <returns></returns> public int PassAdd(int ID) { 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 = new CRM_CompanyPrice(); comModel.AddPrice = comAudit.AddPrice; comModel.LowestPrice = comAudit.LowestPrice; comModel.PRD_Product_ID = comAudit.PRD_Product_ID; 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_CompanyPrice.Add(comModel); return(db.SaveChanges()); } }