/// <summary>
/// 为防止前台胡乱输入做的验证处理
/// </summary>
/// <param name="contractTypeEntity"></param>
/// <returns></returns>
public CasContractTypeEntity CheckInputValue(CasContractTypeEntity contractTypeEntity)
{
if (contractTypeEntity.IsTemplateContract == true)
{
contractTypeEntity.CounterpartyCn = false;
contractTypeEntity.ContractName = false;
contractTypeEntity.ContractTerm = false;
contractTypeEntity.ContractOwner = false;
contractTypeEntity.ContractInitiator = false;
contractTypeEntity.IsMasterAgreement = false;
contractTypeEntity.Supplementary = false;
contractTypeEntity.BudgetType = false;
contractTypeEntity.BudgetAmount = false;
contractTypeEntity.InternalORInvestmentOrder = false;
contractTypeEntity.ContractOREstimatedPrice = false;
//contractTypeEntity.EstimatedPrice = false;
contractTypeEntity.Currency = false;
contractTypeEntity.PrepaymentAmount = false;
contractTypeEntity.PrepaymentPercentage = false;
contractTypeEntity.ContractKeyPoints = false;
}
if (contractTypeEntity.IsTemplateContract == false)
{
contractTypeEntity.TemplateName = false;
contractTypeEntity.TemplateTerm = false;
contractTypeEntity.TemplateOwner = false;
contractTypeEntity.TemplateInitiator = false;
contractTypeEntity.ScopeOfApplication = false;
}
return(contractTypeEntity);
}
public ActionResult ItemDetails(CasContractEntity entity, string id)
{
if (!string.IsNullOrEmpty(id))
{
string sqlstring = $@"SELECT CONTRACT_ID,CONTRACT_SERIAL_NO,STATUS,ORIGINAL_CONTRACT_ID,SUPPLIER,CONTRACT_GROUP,MODIFICATION_POINTS,CONTRACT_TYPE_ID,CONTRACT_TYPE_NAME,NEED_COMMENT,NOT_DISPLAY_IN_MY_SUPPORT,IS_TEMPLATE_CONTRACT,CONTRACT_NAME,CONTRACT_TERM,CONTRACT_OWNER,CONTRACT_INITIATOR,FERRERO_ENTITY,COUNTERPARTY_EN,COUNTERPARTY_CN,EFFECTIVE_DATE,EXPIRATION_DATE,IS_MASTER_AGREEMENT,TAX,CONTRACT_PRICE,ESTIMATED_PRICE,CURRENCY,CAPEX,SUPPLEMENTARY,BUDGET_AMOUNT,INTERNAL_INVERTMENT_ORDER,REFERENCE_CONTRACT,PREPAYMENT_AMOUNT,PREPAYMENT_PERCENTAGE,CONTRACT_KEY_POINTS,BUDGET_TYPE,CASE contract.IS_TEMPLATE_CONTRACT
when 1
then contract.TEMPLATE_NO
else
(select template.TEMPLATE_NO from CAS_CONTRACT template
where contract.TEMPLATE_NO = template.CONTRACT_ID)
end TEMPLATE_NO,TEMPLATE_NAME,TEMPLATE_TERM,TEMPLATE_OWNER,TEMPLATE_INITIATOR,SCOPE_OF_APPLICATION,APPLY_DATE,IS_DELETED,CREATED_BY,CREATE_TIME,LAST_MODIFIED_BY,LAST_MODIFIED_TIME FROM CAS_CONTRACT contract WHERE contract.CONTRACT_ID='{id}'";
entity = DataAccess.Select <CasContractEntity>(sqlstring).FirstOrDefault();
//entity = BusinessDataService.ContractApplayService.GetById<CasContractEntity>(id);
CasContractTypeEntity casContractTypeEntity = BusinessDataService.ContractTypeManagementService.GetById <CasContractTypeEntity>(entity.ContractTypeId);
ViewBag.ContractType = casContractTypeEntity;
List <CasAttachmentEntity> list = BusinessDataService.CommonHelperService.GetFilesBySourceId(id);
var mineFileIds = list.Where(f => f.AttachmentType == 1).ToList();
var originalFileIds = list.Where(f => f.AttachmentType == 2).ToList();
ViewBag.MineFiles = mineFileIds;
ViewBag.OriginalFiles = originalFileIds;
#region 合同审批结果
//获取审批结果信息
DataTable approvalResultDt = BusinessDataService.CommonHelperService.GetApprovalResultDt(entity.ContractId);
JsonSerializerSettings setting = new JsonSerializerSettings()
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
};
var ret = JsonConvert.SerializeObject(approvalResultDt, setting);
ViewBag.ApprovalResult = ret;
#endregion
}
return(View(entity));
}
public virtual bool SaveContractTypeEntity(CasContractTypeEntity contractTypeEntity, ref string strError)
{
contractTypeEntity.LastModifiedBy = WebCaching.UserId;
contractTypeEntity.LastModifiedTime = DateTime.Now;
contractTypeEntity = CheckInputValue(contractTypeEntity);
try
{
var isExist = IsExist(contractTypeEntity, ref strError);
if (isExist)
{
//更新
if (Update(contractTypeEntity))
{
return(true);
}
}
else
{
//新增
contractTypeEntity.ContractTypeId = Guid.NewGuid().ToString();
contractTypeEntity.CreatedBy = WebCaching.UserId;
contractTypeEntity.CreateTime = DateTime.Now;
contractTypeEntity.IsDeleted = false;
if (Insert(contractTypeEntity))
{
return(true);
}
}
}
catch (Exception exception)
{
strError = exception.Message;
}
return(false);
}
public virtual bool IsExist(CasContractTypeEntity casContractTypeEntity, ref string strError)
{
if (casContractTypeEntity.ContractTypeId == null)
{
return(false);
}
var strsql = new StringBuilder();
strsql.AppendFormat("SELECT 1 FROM CAS_CONTRACT_TYPE WHERE CONTRACT_TYPE_ID = {0}",
Utils.ToSQLStr(casContractTypeEntity.ContractTypeId).Trim());
var val = DataAccess.SelectScalar(strsql.ToString());
if (string.IsNullOrEmpty(val) || val != "1")
{
return(false);
}
strError = "该合同类型已存在";
return(true);
}
public ActionResult Edit(string id)
{
//合同信息
CasContractEntity entity = new CasContractEntity();
if (!string.IsNullOrEmpty(id))
{
//获取合同正文信息
entity = BusinessDataService.ContractApplayService.GetById <CasContractEntity>(id);
CasContractTypeEntity casContractTypeEntity = BusinessDataService
.ContractTypeManagementService
.GetById <CasContractTypeEntity>(entity.ContractTypeId);
ViewBag.ContractType = casContractTypeEntity;
//获取合同附件
List <CasAttachmentEntity> list = BusinessDataService.CommonHelperService.GetFilesBySourceId(entity.ContractId);
var mineFiles = list.Where(f => f.AttachmentType == 1).ToList();
ViewBag.MineFiles = mineFiles;
var originalFiles = new List <CasAttachmentEntity>();
if (!string.IsNullOrEmpty(entity.OriginalContractId))
{
originalFiles = BusinessDataService.CommonHelperService.GetFilesBySourceId(entity.OriginalContractId).Where(f => f.AttachmentType == 1).ToList();
}
else
{
originalFiles = list.Where(f => f.AttachmentType == 2).ToList();
}
ViewBag.OriginalFiles = originalFiles;
//获取模板编号合同数据
CasContractEntity templateNoContract = new CasContractEntity();
if (!(bool)casContractTypeEntity.IsTemplateContract && (bool)casContractTypeEntity.TemplateNo)
{
templateNoContract = BusinessDataService.ContractApplayService.GetById <CasContractEntity>(entity.TemplateNo);
}
ViewBag.templateNoContract = templateNoContract;
}
return(View(entity));
}
public ActionResult Edit(CasContractTypeEntity entity, string id, string type)
{
if (type == "check")
{
ViewBag.Type = "3";
}
entity.Status = Convert.ToInt32(entity.submitType);
string strError = "";
if (!IsPost)
{
entity = BusinessDataService.ContractTypeManagementService.CreateContractTypeEntity("MDM");
if (!string.IsNullOrEmpty(id))
{
entity = BusinessDataService.ContractTypeManagementService.GetById <CasContractTypeEntity>(id);
//编辑
ViewBag.EditType = "0";
}
else
{
//新增
ViewBag.EditType = "1";
}
}
else
{
if (BusinessDataService.ContractTypeManagementService.SaveContractTypeEntity(entity, ref strError))
{
return(Json(AjaxResult.Success()));
}
else
{
return(Json(AjaxResult.Error("Update failed")));
}
}
ViewBag.strError = strError;
return(View(entity));
}
/// <summary>
/// 跳转到审批页
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Approval(string id)
{
//合同信息
CasContractEntity entity = new CasContractEntity();
if (!string.IsNullOrEmpty(id))
{
//获取审批人信息
CasContractApproverEntity casContractApproverEntity = new CasContractApproverEntity {
ContractApproverId = id
};
casContractApproverEntity = BusinessDataService.CommonHelperService.GetApprover(casContractApproverEntity);
//获取合同正文信息
entity = BusinessDataService.ContractApplayService.GetById <CasContractEntity>(casContractApproverEntity.ContractId);
//获取合同类型信息
CasContractTypeEntity casContractTypeEntity = BusinessDataService
.ContractTypeManagementService
.GetById <CasContractTypeEntity>(entity.ContractTypeId);
ViewBag.ContractType = casContractTypeEntity;
//获取审批结果信息
DataTable approvalResultDt = BusinessDataService.CommonHelperService.GetApprovalResultDt(casContractApproverEntity.ContractId);
JsonSerializerSettings setting = new JsonSerializerSettings()
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
};
var ret = JsonConvert.SerializeObject(approvalResultDt, setting);
ViewBag.ApprovalResult = ret;
ViewBag.ContractApproverId = casContractApproverEntity.ContractApproverId;
List <CasAttachmentEntity> list = BusinessDataService.CommonHelperService.GetFilesBySourceId(entity.ContractId);
var mineFileIds = list.Where(f => f.AttachmentType == 1).ToList();
var originalFileIds = list.Where(f => f.AttachmentType == 2).ToList();
ViewBag.MineFiles = mineFileIds;
ViewBag.OriginalFiles = originalFileIds;
}
return(View(entity));
}
public ActionResult Delet(CasContractTypeEntity entity, string id)
{
var a = BusinessDataService.ContractTypeManagementService.DeletContractTypeEntity(id);
return(Json(AjaxResult.Success()));
}
