[OperationContract]//合同是否能被查看
public bool IsContractCanBrowser(string ContractID)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
return(cab.IsContractCanBrowser(ContractID));
}
}
[OperationContract]//删除申请信息
public bool DeleteContraApproval(string[] contraApprovalID)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
return(cab.DeleteContraApproval(contraApprovalID));
}
}
[OperationContract]//获取所有的申请信息
public List <T_OA_CONTRACTAPP> GetContractApprovalInfo()
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
IQueryable <T_OA_CONTRACTAPP> ContracApprovalList = cab.GetContractApplications();
return(ContracApprovalList == null ? null : ContracApprovalList.ToList());
}
}
[OperationContract]//根据ID获取合同申请
public V_ContractApplications GetContractApprovalById(string contractApprovalID)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
V_ContractApplications ContracApproval = cab.GetContractApprovalById(contractApprovalID);
return(ContracApproval == null ? null : ContracApproval);
}
}
[OperationContract]//根据ID获取合同申请(打印)
public V_ContractPrint GetContractPrintingById(string contractPrintinglID)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
V_ContractPrint ContractPrinting = cab.GetContractPrintingById(contractPrintinglID);
return(ContractPrinting == null ? null : ContractPrinting);
}
}
public override void Run(Hashtable parameters)
{
ContractApprovalBLL bll = new ContractApprovalBLL();
List <CasContractEntity> listCallbackContinueOver3DaysContracts = bll.GetAllCallbackContinueOver3DaysContracts();
foreach (CasContractEntity callbackContinueOver3DaysContracts in listCallbackContinueOver3DaysContracts)
{
bll.CallbackContinueOver3DaysContractsContinue(callbackContinueOver3DaysContracts);
}
}
public override void Run(Hashtable parameters)
{
ContractApprovalBLL bll = new ContractApprovalBLL();
List <CasContractEntity> listCommentedOver1DayContracts = bll.GetAllCommentedOver1DayContracts();
foreach (CasContractEntity commentedOver1DayContracts in listCommentedOver1DayContracts)
{
bll.ContinueCommentedOver1DayContracts(commentedOver1DayContracts);
}
}
[OperationContract]//更新申请信息
public string UpdateContraApproval(T_OA_CONTRACTAPP contraApprovalInfo)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
string returnStr = "";
if (!cab.UpdateContraApproval(contraApprovalInfo))
{
returnStr = "更新数据失败！";
}
return(returnStr);
}
}
[OperationContract]//(更新合同打印)上传附件
public string UpdateContractPrinting(T_OA_CONTRACTPRINT contractPrinting)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
string result = "";
if (!cab.UpdateContractPrinting(contractPrinting))
{
result = "更新或上传数据失败！";
}
return(result);
}
}
[OperationContract]//添加合同打印
public string ContractPrintingAdd(T_OA_CONTRACTPRINT ContractPrintingInfo)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
string returnStr = "";
if (!cab.ContractPrintingAdd(ContractPrintingInfo))
{
returnStr = "添加数据失败";
}
return(returnStr);
}
}
public List <V_ContractApplications> GetApprovalListByUserId(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, string checkState, LoginUserInfo loginUserInfo)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
List <V_ContractApplications> ArchivesList = null;
if (checkState != ((int)CheckStates.WaittingApproval).ToString()) //获取用户的提交申请信息
{
//List<V_ContractApplications> ArchivesList = cab.GetApprovalInfo(pageIndex, pageSize, sort, filterString, paras, ref pageCount, null, checkState);
if (checkState != ((int)CheckStates.ALL).ToString())
{
ArchivesList = cab.GetApprovalInfo(pageIndex, pageSize, sort, filterString, paras, ref pageCount, null, checkState, loginUserInfo.userID);
}
else
{
ArchivesList = cab.GetApprovalInfo(pageIndex, pageSize, sort, filterString, paras, ref pageCount, null, "", loginUserInfo.userID);
}
return(ArchivesList != null?ArchivesList.ToList() : null);
}
else //通过工作流获取用户要审批的申请信息
{
SMT.SaaS.BLLCommonServices.FlowWFService.FLOW_FLOWRECORDDETAIL_T flowInfo = new SMT.SaaS.BLLCommonServices.FlowWFService.FLOW_FLOWRECORDDETAIL_T(); //审核人 操作
SMT.SaaS.BLLCommonServices.FlowWFService.FLOW_FLOWRECORDDETAIL_T[] flowList = workFlowWS.GetFlowInfo("", "", "", "0", "T_OA_CONTRACTAPP", loginUserInfo.companyID, loginUserInfo.userID);
if (flowList == null)
{
return(null);
}
List <V_FlowAPP> flowAppList = new List <V_FlowAPP>();
for (int i = 0; i < flowList.Length; i++)
{
V_FlowAPP App = new V_FlowAPP();
App.Guid = flowList[i].FLOWRECORDDETAILID;
App.FormID = flowList[i].FLOW_FLOWRECORDMASTER_T.FORMID;
App.EditUserID = flowList[i].EDITUSERID;
App.EditUserName = flowList[i].EDITUSERNAME;
flowAppList.Add(App);
}
checkState = ((int)CheckStates.Approving).ToString();
ArchivesList = cab.GetApprovalInfo(pageIndex, pageSize, sort, filterString, paras, ref pageCount, flowAppList, checkState, loginUserInfo.userID);
if (ArchivesList == null)
{
return(null);
}
else
{
return(ArchivesList.ToList());
}
}
}
}
[OperationContract]//根据标题、ID获取合同的申请信息
public List <V_ContractApplications> GetContractApprovalRoomInfosListBySearch(string StrContractApprovalName, string StrID, string strContractLevel, string strContractLogo)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
List <V_ContractApplications> ContractApprovalList = cab.GetApprovalRoomInfosListBySearch(StrContractApprovalName, StrID, strContractLevel, strContractLogo);
if (ContractApprovalList == null)
{
return(null);
}
else
{
return(ContractApprovalList.ToList());
}
}
}
[OperationContract]//查询已打印和上传的合同
public List <V_ContractPrint> GetInquiryContractPrintingRecordInfo(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
List <V_ContractPrint> ContractPrintList = cab.GetInquiryContractPrintingRecordInfo(pageIndex, pageSize, sort, filterString, paras, ref pageCount);
if (ContractPrintList == null)
{
return(null);
}
else
{
return(ContractPrintList.ToList());
}
}
}
[OperationContract]//添加合同申请信息
public string ContractApprovalAdd(T_OA_CONTRACTAPP ContractApproval)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
string returnStr = "";
if (!cab.IsExistContractApproval(ContractApproval.CONTRACTCODE, ContractApproval.CONTRACTTITLE,
ContractApproval.CONTRACTTYPEID, ContractApproval.CONTRACTLEVEL))
{
if (!cab.ContractApprovalAdd(ContractApproval))
{
returnStr = "添加数据失败";
}
}
else
{
returnStr = "合同申请信息已经存在,添加数据失败";
}
return(returnStr);
}
}
[OperationContract]//合同是否能被查看
public bool IsContractCanBrowser(string ContractID)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
return cab.IsContractCanBrowser(ContractID);
}
}
[OperationContract]//获取所有的申请信息
public List<T_OA_CONTRACTAPP> GetContractApprovalInfo()
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
IQueryable<T_OA_CONTRACTAPP> ContracApprovalList = cab.GetContractApplications();
return ContracApprovalList == null ? null : ContracApprovalList.ToList();
}
}
[OperationContract]//根据ID获取合同申请
public V_ContractApplications GetContractApprovalById(string contractApprovalID)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
V_ContractApplications ContracApproval = cab.GetContractApprovalById(contractApprovalID);
return ContracApproval == null ? null : ContracApproval;
}
}
[OperationContract]//更新申请信息
public string UpdateContraApproval(T_OA_CONTRACTAPP contraApprovalInfo)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
string returnStr = "";
if (!cab.UpdateContraApproval(contraApprovalInfo))
{
returnStr = "更新数据失败！";
}
return returnStr;
}
}
[OperationContract]//添加合同申请信息
public string ContractApprovalAdd(T_OA_CONTRACTAPP ContractApproval)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
string returnStr = "";
if (!cab.IsExistContractApproval(ContractApproval.CONTRACTCODE, ContractApproval.CONTRACTTITLE,
ContractApproval.CONTRACTTYPEID, ContractApproval.CONTRACTLEVEL))
{
if (!cab.ContractApprovalAdd(ContractApproval))
{
returnStr = "添加数据失败";
}
}
else
{
returnStr = "合同申请信息已经存在,添加数据失败";
}
return returnStr;
}
}
[OperationContract]//删除申请信息
public bool DeleteContraApproval(string[] contraApprovalID)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
return cab.DeleteContraApproval(contraApprovalID);
}
}
[OperationContract]//(更新合同打印)上传附件
public string UpdateContractPrinting(T_OA_CONTRACTPRINT contractPrinting)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
string result = "";
if (!cab.UpdateContractPrinting(contractPrinting))
{
result = "更新或上传数据失败！";
}
return result;
}
}
[OperationContract]//添加合同打印
public string ContractPrintingAdd(T_OA_CONTRACTPRINT ContractPrintingInfo)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
string returnStr = "";
if (!cab.ContractPrintingAdd(ContractPrintingInfo))
{
returnStr = "添加数据失败";
}
return returnStr;
}
}
[OperationContract]//查询已打印和上传的合同
public List<V_ContractPrint> GetInquiryContractPrintingRecordInfo(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
List<V_ContractPrint> ContractPrintList = cab.GetInquiryContractPrintingRecordInfo(pageIndex, pageSize, sort, filterString, paras, ref pageCount);
if (ContractPrintList == null)
{
return null;
}
else
{
return ContractPrintList.ToList();
}
}
}
public override void Run(Hashtable parameters)
{
ContractApprovalBLL bll = new ContractApprovalBLL();
bll.OverTimeContractApproval();
}
public override void Run(Hashtable parameters)
{
ContractApprovalBLL bll = new ContractApprovalBLL();
ContractManagementBLL contractManagementBLL = new ContractManagementBLL();
List <CasUserEntity> listApprovers = bll.GetAllPendingApprovalAndOvertimeContractsApprovers();
foreach (CasUserEntity approver in listApprovers)
{
//待审批和超时合同
List <CasContractApproverEntity> listPendingApprovalAndOverTimeContractApprovers = bll.GetPendingApprovalAndOvertimeContractApprovers(approver.UserId);
//待审批合同
List <CasContractApproverEntity> listPendingApprovalContractApprovers = listPendingApprovalAndOverTimeContractApprovers.Where(p => p.Status == ContractApproverStatusEnum.WaitApproval.GetHashCode()).ToList();
//超时合同
List <CasContractApproverEntity> listOverTimeContractApprovers = listPendingApprovalAndOverTimeContractApprovers.Where(p => p.Status == ContractApproverStatusEnum.OverTime.GetHashCode()).ToList();
//邮件标题
string mailTitle = $@"e-Approval - Contract Approval List";
//邮件正文
string mailContent = $@"Dear {approver.EnglishName},<br/>尊敬的：{approver.ChineseName}";
if (listPendingApprovalContractApprovers.Count > 0)
{
mailContent += $@"<br/>The following contracts have been submitted for your approval(please kindly confirm your approval or rejection within 3 working days):<br/>以下合同申请需要您的审核（请在3个工作日内批准或拒绝申请）：<br/>
</br><table style='font-family:verdana,arial,sans-serif;font-size:11px;color:#333333;border-width: 1px;border-color: #666666;border-collapse:collapse;'><thead>
<tr><th style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #dedede;'>Initiator 申请人</th>
<th style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #dedede;'>Contract Owner 合同经办部门</th>
<th style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #dedede;'>Contract Name 合同名称</th>
<th style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #dedede;'>Ferrero Entity 费列罗方</th>
<th style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #dedede;'>Counter Party 相对方</th>
</tr></thead><tbody>";
foreach (var pendingApproval in listPendingApprovalContractApprovers)
{
CasContractEntity contract = contractManagementBLL.GetById <CasContractEntity>(pendingApproval.ContractId);
CasUserEntity userEntity = contractManagementBLL.GetById <CasUserEntity>(contract.CreatedBy);
mailContent += $@"<tr>
<td style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #ffffff;'>{userEntity.ChineseName}</td>
<td style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #ffffff;'>{contract.ContractOwner}{contract.TemplateOwner}</td>
<td style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #ffffff;'>{contract.ContractName}{contract.TemplateName}</td>
<td style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #ffffff;'>{contract.FerreroEntity}</td>
<td style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #ffffff;'>{contract.CounterpartyEn}{contract.CounterpartyCn}</td>
</tr>";
}
mailContent += $@"</tbody></table></br>";
}
if (listOverTimeContractApprovers.Count > 0)
{
mailContent += $@"<br/>Note below contracts are overdue, please review the contracts at your earliest convenient.<br/>请注意以下合同已超期，请尽快进行审批。<br/>
</br><table style='font-family:verdana,arial,sans-serif;font-size:11px;color:#333333;border-width: 1px;border-color: #666666;border-collapse:collapse;'><thead>
<tr><th style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #dedede;'>Initiator 申请人</th>
<th style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #dedede;'>Contract Owner 合同经办部门</th>
<th style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #dedede;'>Contract Name 合同名称</th>
<th style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #dedede;'>Ferrero Entity 费列罗方</th>
<th style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #dedede;'>Counter Party 相对方</th>
</tr></thead><tbody>";
foreach (var listOverTime in listOverTimeContractApprovers)
{
CasContractEntity contract = contractManagementBLL.GetById <CasContractEntity>(listOverTime.ContractId);
CasUserEntity userEntity = contractManagementBLL.GetById <CasUserEntity>(contract.CreatedBy);
mailContent += $@"<tr>
<td style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #ffffff;'>{userEntity.ChineseName}</td>
<td style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #ffffff;'>{contract.ContractOwner}{contract.TemplateOwner}</td>
<td style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #ffffff;'>{contract.ContractName}{contract.TemplateName}</td>
<td style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #ffffff;'>{contract.FerreroEntity}</td>
<td style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #ffffff;'>{contract.CounterpartyEn}{contract.CounterpartyCn}</td>
</tr>";
}
mailContent += $@"</tbody></table></br>";
}
//foreach (CasContractApproverEntity casContractApproverEntity in listPendingApprovalAndOverTimeContractApprovers)
//{
// CasContractEntity contract = contractManagementBLL.GetById<CasContractEntity>(casContractApproverEntity.ContractId);
// string statusName = "";
// switch (casContractApproverEntity.Status)
// {
// case (2): statusName = "待审批"; break;
// case (4): statusName = "超时"; break;
// default: statusName = "待审批"; break;
// }
// string approveTypeName = "";
// switch (casContractApproverEntity.ApproverType)
// {
// case (1): approveTypeName = "领导"; break;
// case (2): approveTypeName = "大区总监"; break;
// case (3): approveTypeName = "部门总监"; break;
// case (4): approveTypeName = "审批部门"; break;
// default: approveTypeName = "审批部门"; break;
// }
// mailContent += $@"<tr><td style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #ffffff;'>{contract.ContractName}</td><td style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #ffffff;'>{approveTypeName}</td><td style='border-width: 1px;padding: 8px;border-style: solid;border-color: #666666;background-color: #ffffff;'>{statusName}</td></tr>";
//}
mailContent += "</br></br>Ferrero China Contract Approval System</br>费列罗中国合同审批系统";
var cc = "*****@*****.**";
#if DEBUG
string reciever = "*****@*****.**";
#else
string reciever = approver.Email;
#endif
SendEmail.Send(reciever, mailTitle, mailContent);
}
}
[OperationContract]//根据ID获取合同申请(打印)
public V_ContractPrint GetContractPrintingById(string contractPrintinglID)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
V_ContractPrint ContractPrinting = cab.GetContractPrintingById(contractPrintinglID);
return ContractPrinting == null ? null : ContractPrinting;
}
}
[OperationContract]//根据标题、ID获取合同的申请信息
public List<V_ContractApplications> GetContractApprovalRoomInfosListBySearch(string StrContractApprovalName, string StrID, string strContractLevel, string strContractLogo)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
List<V_ContractApplications> ContractApprovalList = cab.GetApprovalRoomInfosListBySearch(StrContractApprovalName, StrID, strContractLevel, strContractLogo);
if (ContractApprovalList == null)
{
return null;
}
else
{
return ContractApprovalList.ToList();
}
}
}
public List<V_ContractApplications> GetApprovalListById(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, string checkState, LoginUserInfo loginUserInfo)
{
using (ContractApprovalBLL cab = new ContractApprovalBLL())
{
List<V_ContractApplications> ArchivesList = null;
if (checkState != ((int)CheckStates.WaittingApproval).ToString()) //获取用户的提交申请信息
{
if (checkState != ((int)CheckStates.ALL).ToString())
{
ArchivesList = cab.GetApprovalInfoPrinting(pageIndex, pageSize, sort, filterString, paras, ref pageCount, null, checkState);
}
else
{
ArchivesList = cab.GetApprovalInfoPrinting(pageIndex, pageSize, sort, filterString, paras, ref pageCount, null, "");
}
return ArchivesList != null ? ArchivesList.ToList() : null;
}
else //通过工作流获取用户要审批的申请信息
{
FLOW_FLOWRECORDDETAIL_T flowInfo = new FLOW_FLOWRECORDDETAIL_T(); //审核人 操作
FLOW_FLOWRECORDDETAIL_T[] flowList = workFlowWS.GetFlowInfo("", "", "", "0", "T_OA_CONTRACTAPP", loginUserInfo.companyID, loginUserInfo.userID);
if (flowList == null)
{
return null;
}
List<V_FlowAPP> flowAppList = new List<V_FlowAPP>();
for (int i = 0; i < flowList.Length; i++)
{
V_FlowAPP App = new V_FlowAPP();
App.Guid = flowList[i].FLOWRECORDDETAILID;
App.FormID = flowList[i].FLOW_FLOWRECORDMASTER_T.FORMID;
App.EditUserID = flowList[i].EDITUSERID;
App.EditUserName = flowList[i].EDITUSERNAME;
flowAppList.Add(App);
}
checkState = ((int)CheckStates.Approving).ToString();
ArchivesList = cab.GetApprovalInfoPrinting(pageIndex, pageSize, sort, filterString, paras, ref pageCount, flowAppList, checkState);
if (ArchivesList == null)
{
return null;
}
else
{
return ArchivesList.ToList();
}
}
}
}
public override void Run(Hashtable parameters)
{
ContractApprovalBLL bll = new ContractApprovalBLL();
bll.TimeBack1Day();
}
