/////////////////////////////////////////////////////////////////////////////////
#region // StoreAllInfoQuery Test
public ActionResult StoreAllInfoQuery(string _USCode)
{
List <StoreBasicInfo> lsStoreBasicInfo = new List <StoreBasicInfo>();
StoreBasicInfo mStoreBasicInfo = new StoreBasicInfo();
lsStoreBasicInfo = StoreBasicInfo.Search(o => o.StoreCode.Contains(_USCode)).ToList <StoreBasicInfo>();
if (lsStoreBasicInfo.Count > 0)
{
mStoreBasicInfo = lsStoreBasicInfo[0];
}
List <StoreDevelop> lsStoreDevelop = new List <StoreDevelop>();
StoreDevelop mStoreDevelop = new StoreDevelop();
lsStoreDevelop = StoreDevelop.Search(o => o.StoreCode.Contains(_USCode)).ToList <StoreDevelop>();
if (lsStoreDevelop.Count > 0)
{
mStoreDevelop = lsStoreDevelop[0];
}
List <StoreOps> lsStoreOp = new List <StoreOps>();
StoreOps mStoreOp = new StoreOps();
lsStoreOp = StoreOps.Search(o => o.StoreCode.Contains(_USCode)).ToList <StoreOps>();
if (lsStoreOp.Count > 0)
{
mStoreOp = lsStoreOp[0];
}
List <StoreContractInfo> lsStoreContractInfo = new List <StoreContractInfo>();
StoreContractInfo mStoreContractInfo = new StoreContractInfo();
lsStoreContractInfo = StoreContractInfo.Search(o => o.StoreCode.Contains(_USCode)).ToList <StoreContractInfo>();
if (lsStoreContractInfo.Count > 0)
{
mStoreContractInfo = lsStoreContractInfo[0];
}
var resultStoreAllInfo = new
{
StoreBasicInfo = mStoreBasicInfo,
StoreDevelop = mStoreDevelop,
StoreOp = mStoreOp,
StoreContractInfo = new
{
StoreContractInfo = mStoreContractInfo,
StoreContractRevision = "",
StoreContractInfoAttached = ""
}
};
string result = JsonConvert.SerializeObject(resultStoreAllInfo);
return(Content(result));
}
public static List <EmailSendingResultType> SendPackageApprovalEmail(RenewalInfo info, RenewalPackage entity, ApproveUsers approvers)
{
var project = ProjectInfo.Get(entity.ProjectId, FlowCode.Renewal_Package);
var storeBasic = StoreBasicInfo.GetStorInfo(project.USCode);
var storeContract = StoreContractInfo.Search(c => c.StoreCode == project.USCode).OrderByDescending(c => c.CreatedTime).FirstOrDefault();
var assetMgr = ProjectUsers.FirstOrDefault(pu => pu.ProjectId == entity.ProjectId && pu.RoleCode == ProjectUserRoleCode.AssetManager);
var assetActor = ProjectUsers.FirstOrDefault(pu => pu.ProjectId == entity.ProjectId && pu.RoleCode == ProjectUserRoleCode.AssetActor);
var assetRep = ProjectUsers.FirstOrDefault(pu => pu.ProjectId == entity.ProjectId && pu.RoleCode == ProjectUserRoleCode.AssetRep);
var results = new List <EmailSendingResultType>();
using (EmailServiceClient emailClient = new EmailServiceClient())
{
List <SimpleEmployee> approveEmps = new List <SimpleEmployee> {
approvers.MarketMgr,
approvers.GM,
approvers.MDD,
approvers.FC,
approvers.MCCLAssetDtr
};
if (approvers.RegionalMgr != null)
{
approveEmps.Add(approvers.RegionalMgr);
}
if (approvers.CDO != null)
{
approveEmps.Add(approvers.CDO);
}
if (approvers.ManagingDirector != null)
{
approveEmps.Add(approvers.ManagingDirector);
}
//邮件模板中的数据
Dictionary <string, string> bodyValues = new Dictionary <string, string>();
//邮件内容中的键值对
bodyValues.Add("ApplicantName", ClientCookie.UserNameENUS);//--提交人
bodyValues.Add("StoreCode", storeBasic.StoreCode);
bodyValues.Add("StoreName", storeBasic.NameENUS + @" \ " + storeBasic.NameZHCN);
bodyValues.Add("Actor", assetActor.UserNameENUS); ////--呈递人
//bodyValues.Add("WorkflowName", Constants.TempClosure_Package);////--流程名称
bodyValues.Add("ProjectName", Constants.TempClosure); //项目名称
var viewPage = string.Format("{0}/Renewal/Main#/Package/View/param?projectId={1}",
HttpContext.Current.Request.Url.Authority, entity.ProjectId);
bodyValues.Add("FormUrl", viewPage);
Dictionary <string, string> templateFileds = entity.GetPrintTemplateFields();
var approveRecords = ProjectComment.GetList("TempClosurePackage", entity.Id, ProjectCommentStatus.Submit).Select(pc => new SubmissionApprovalRecord
{
OperatorID = pc.UserAccount,
OperatorName = pc.UserNameENUS,
OperatorTitle = pc.TitleNameENUS,
OperationDate = pc.CreateTime.HasValue ? pc.CreateTime.Value : DateTime.Now,
ActionName = pc.ActivityName,
Comments = pc.Content
}).ToList();
string imgPath = HtmlConversionUtility.HtmlConvertToPDF(HtmlTempalteType.Renewal, templateFileds, approveRecords);
approveEmps.ForEach(e =>
{
EmailMessage email = new EmailMessage();
List <string> emailAddresses = new List <string>
{
e.Mail,
"*****@*****.**",
"*****@*****.**",
"*****@*****.**"
};
if (bodyValues.ContainsKey("ApproverName"))
{
bodyValues["ApproverName"] = e.NameENUS;
}
else
{
bodyValues.Add("ApproverName", e.NameENUS);//--提交人
}
email.EmailBodyValues = bodyValues;
email.To = string.Join(";", emailAddresses);
email.Attachments = imgPath;
//var result = emailClient.SendEmail(email);
results.Add(new EmailSendingResultType());
});
approvers.NoticeUsers.ForEach(e =>
{
EmailMessage email = new EmailMessage();
List <string> emailAddresses = new List <string>
{
e.Mail,
"*****@*****.**",
"*****@*****.**",
"*****@*****.**"
};
if (bodyValues.ContainsKey("ApproverName"))//--提交人
{
bodyValues["ApproverName"] = e.NameENUS;
}
else
{
bodyValues.Add("ApproverName", e.NameENUS);
}
email.EmailBodyValues = bodyValues;
email.To = string.Join(";", emailAddresses);
email.Attachments = imgPath;
//var result = emailClient.SendEmail(email);
results.Add(new EmailSendingResultType());
});
}
return(results);
}
public static List <EmailSendingResultType> SendPackageApprovalEmail(TempClosureInfo tempClosureInfo, TempClosurePackage entity, ApproveUsers approvers)
{
var project = ProjectInfo.Get(entity.ProjectId, FlowCode.TempClosure_ClosurePackage);
var storeBasic = StoreBasicInfo.GetStorInfo(project.USCode);
var storeContract = StoreContractInfo.Search(c => c.StoreCode == project.USCode).OrderByDescending(c => c.CreatedTime).FirstOrDefault();
var assetMgr = ProjectUsers.FirstOrDefault(pu => pu.ProjectId == entity.ProjectId && pu.RoleCode == ProjectUserRoleCode.AssetManager);
var assetActor = ProjectUsers.FirstOrDefault(pu => pu.ProjectId == entity.ProjectId && pu.RoleCode == ProjectUserRoleCode.AssetActor);
var assetRep = ProjectUsers.FirstOrDefault(pu => pu.ProjectId == entity.ProjectId && pu.RoleCode == ProjectUserRoleCode.AssetRep);
var results = new List <EmailSendingResultType>();
using (EmailServiceClient emailClient = new EmailServiceClient())
{
List <SimpleEmployee> approveEmps = new List <SimpleEmployee> {
approvers.MarketMgr,
approvers.GM,
approvers.MDD,
approvers.FC,
approvers.VPGM
//approvers.MCCLAssetMgr,
//approvers.MCCLAssetDtr
};
if (approvers.RegionalMgr != null)
{
approveEmps.Add(approvers.RegionalMgr);
}
//邮件模板中的数据
Dictionary <string, string> bodyValues = new Dictionary <string, string>();
//邮件内容中的键值对
bodyValues.Add("ApplicantName", ClientCookie.UserNameENUS);//--提交人
bodyValues.Add("StoreCode", storeBasic.StoreCode);
bodyValues.Add("StoreName", storeBasic.NameENUS + @" \ " + storeBasic.NameZHCN);
bodyValues.Add("Actor", assetActor.UserNameENUS); ////--呈递人
//bodyValues.Add("WorkflowName", Constants.TempClosure_Package);////--流程名称
bodyValues.Add("ProjectName", Constants.TempClosure); //项目名称
var viewPage = string.Format("{0}/TempClosure/Main#/ClosurePackage/View/param?projectId={1}",
HttpContext.Current.Request.Url.Authority, entity.ProjectId);
bodyValues.Add("FormUrl", viewPage);
Dictionary <string, string> templateFileds = new Dictionary <string, string>();
var flowInfo = FlowInfo.Get(FlowCode.TempClosure);
templateFileds.Add("WorkflowName", flowInfo.NameENUS);
templateFileds.Add("ProjectID", entity.ProjectId);
templateFileds.Add("USCode", storeBasic.StoreCode);
templateFileds.Add("City", storeBasic.CityZHCN);
templateFileds.Add("Region", storeBasic.Region);
templateFileds.Add("StoreNameEN", storeBasic.NameENUS);
templateFileds.Add("Market", storeBasic.Market);
templateFileds.Add("StoreNameCN", storeBasic.NameZHCN);
templateFileds.Add("StoreAge", Math.Floor((DateTime.Now - storeBasic.OpenDate).TotalDays / 365D).ToString());
templateFileds.Add("OpenDate", storeBasic.OpenDate.ToString("yyyy-MM-dd"));
var storeInfo = StoreBasicInfo.GetStore(project.USCode);
if (!string.IsNullOrEmpty(storeInfo.StoreContractInfo.EndYear))
{
templateFileds.Add("CurrentLeaseENDYear", (int.Parse(storeInfo.StoreContractInfo.EndYear) - storeInfo.CurrentYear).ToString());
}
else
{
templateFileds.Add("CurrentLeaseENDYear", "");
}
if (assetMgr != null)
{
templateFileds.Add("AssetsManager", assetMgr.UserNameENUS);
}
templateFileds.Add("AssetsActor", assetActor.UserNameENUS);
templateFileds.Add("AssetsRep", assetRep.UserNameENUS);
templateFileds.Add("ClosureDate", tempClosureInfo.ActualTempClosureDate.ToString("yyyy-MM-dd"));
templateFileds.Add("LeaseExpireDate", tempClosureInfo.LeaseExpireDate.HasValue ? tempClosureInfo.LeaseExpireDate.Value.ToString("yyyy-MM-dd") : "");
templateFileds.Add("ReOpenDate", tempClosureInfo.ActualReopenDate.ToString("yyyy-MM-dd"));
templateFileds.Add("RentFreeTerm", string.IsNullOrEmpty(entity.RentReliefClause) ? "否" : "是");
templateFileds.Add("RentFreeStartDate", entity.RentReliefStartDate.HasValue ? entity.RentReliefStartDate.Value.ToString("yyyy-MM-dd") : "");
templateFileds.Add("RentFreeEndDate", entity.RentReliefEndDate.HasValue ? entity.RentReliefEndDate.Value.ToString("yyyy-MM-dd") : "");
templateFileds.Add("FreeRentTerm", entity.RentReliefClause);
var approveRecords = ProjectComment.GetList("TempClosurePackage", entity.Id, ProjectCommentStatus.Submit).Select(pc => new SubmissionApprovalRecord
{
OperatorID = pc.UserAccount,
OperatorName = pc.UserNameENUS,
OperatorTitle = pc.TitleNameENUS,
OperationDate = pc.CreateTime.HasValue ? pc.CreateTime.Value : DateTime.Now,
ActionName = pc.ActivityName,
Comments = pc.Content
}).ToList();
string imgPath = HtmlConversionUtility.HtmlConvertToPDF(HtmlTempalteType.TempClosure, templateFileds, approveRecords);
approveEmps.ForEach(e =>
{
EmailMessage email = new EmailMessage();
List <string> emailAddresses = new List <string>
{
e.Mail,
"*****@*****.**",
"*****@*****.**",
"*****@*****.**"
};
if (bodyValues.ContainsKey("ApproverName"))
{
bodyValues["ApproverName"] = e.NameENUS;
}
else
{
bodyValues.Add("ApproverName", e.NameENUS);//--提交人
}
email.EmailBodyValues = bodyValues;
email.To = string.Join(";", emailAddresses);
email.Attachments = imgPath;
//var result = emailClient.SendEmail(email);
results.Add(new EmailSendingResultType());
});
approvers.NoticeUsers.ForEach(e =>
{
EmailMessage email = new EmailMessage();
List <string> emailAddresses = new List <string>
{
e.Mail,
"*****@*****.**",
"*****@*****.**",
"*****@*****.**"
};
if (bodyValues.ContainsKey("ApproverName"))//--提交人
{
bodyValues["ApproverName"] = e.NameENUS;
}
else
{
bodyValues.Add("ApproverName", e.NameENUS);
}
email.EmailBodyValues = bodyValues;
email.To = string.Join(";", emailAddresses);
email.Attachments = imgPath;
//var result = emailClient.SendEmail(email);
results.Add(new EmailSendingResultType());
});
}
return(results);
}