public async Task <ActionResult> DeleteConfirmed(int id)
{
OtaSalesReport otaSalesReport = await db.OtaSalesReport.FindAsync(id);
db.OtaSalesReport.Remove(otaSalesReport);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit(OtaSalesReport otaSalesReport)
{
if (ModelState.IsValid)
{
db.Entry(otaSalesReport).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(otaSalesReport));
}
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OtaSalesReport otaSalesReport = await db.OtaSalesReport.FindAsync(id);
if (otaSalesReport == null)
{
return(HttpNotFound());
}
return(View(otaSalesReport));
}
public ActionResult Create(OtaSalesReport otaSalesReport)
{
if (ModelState.IsValid)
{
//自动根据时间读取拜访记录生成周报,有html的格式
otaSalesReport.ReportContent = GenerateReport(otaSalesReport.UserName, otaSalesReport.StartDate.Value, otaSalesReport.EndDate.Value);
db.OtaSalesReport.Add(otaSalesReport);
db.SaveChanges();
//生成周报的时候，要同时生成相应的报表统计图表存放到对应的id的文件夹里面
SavePersonCompanyTicketChart(otaSalesReport.UserName, otaSalesReport.ID, otaSalesReport.StartDate.Value, otaSalesReport.EndDate.Value);
return(RedirectToAction("Edit", new { id = otaSalesReport.ID }));
}
return(View(otaSalesReport));
}
public ActionResult Create()
{
var model = new OtaSalesReport();
model.CreateTime = DateTime.Now;
DateTime startWeek = DateTime.Now.AddDays(1 - Convert.ToInt32(DateTime.Now.DayOfWeek.ToString("d")));
DateTime endWeek = startWeek.AddDays(6);
model.StartDate = startWeek;
model.EndDate = endWeek;
model.ReportContent = "";
var Db = new ApplicationDbContext();
var user = Db.Users.First(u => u.UserName == User.Identity.Name);
model.SendToEmails = user.Email;
model.ReportTitle = "销售周报-" + user.TrueName + "-" + model.StartDate.Value.ToString("yyyyMMdd") + "-" + model.EndDate.Value.ToString("yyyyMMdd");
model.UserName = User.Identity.Name;
return(View(model));
}
public ActionResult SendEmail(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OtaSalesReport otaSalesReport = db.OtaSalesReport.Find(id);
if (otaSalesReport == null)
{
return(HttpNotFound());
}
//發送email
#region 发送邮件
//填写电子邮件地址，和显示名称
System.Net.Mail.MailAddress from = new System.Net.Mail.MailAddress("*****@*****.**", "ljy");
//填写邮件的收件人地址和名称
System.Net.Mail.MailAddress to = new System.Net.Mail.MailAddress(otaSalesReport.SendToEmails, otaSalesReport.UserName);
//设置好发送地址，和接收地址，接收地址可以是多个
System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage();
mail.Priority = MailPriority.Normal;
mail.From = from;
mail.To.Add(to);
mail.Subject = otaSalesReport.ReportTitle;
mail.SubjectEncoding = Encoding.GetEncoding(936); //这里非常重要，如果你的邮件标题包含中文，这里一定要指定，否则对方收到的极有可能是乱码。
mail.IsBodyHtml = true; //设置显示htmls
mail.BodyEncoding = Encoding.GetEncoding(936); //邮件正文的编码， 设置不正确， 接收者会收到乱码
string htmlHead = "<html><head><meta http-equiv='Content-Type' content='text/html; charset=gb2312'><style>body {font-size: 9pt;}table {border: 1px;padding: 0;border-collapse: collapse;border: none;}th {border: solid windowtext 1.0pt;background: #BFBFBF;padding: 3px;font-size: 10pt;font-weight: bold;margin:8px;}td {border: solid windowtext 1.0pt;border-top: none;font-size: 10pt;padding: 8px;}</style></head><body><div>";
string htmlEnd = "</div></body></html>";
string Themessage = htmlHead;
//Add Image，多张图片需要循环
var path = "~/CompanyImages/Reports/" + id.ToString();
var imgpath = Server.MapPath(path);
string[] imgFiles = GetAllFileName(imgpath);
foreach (string imgFile in imgFiles)
{
string imgHtml = "<img src='cid:" + imgFile.Replace(".jpg", "") + "' /><br><br>";
Themessage += imgHtml;
}
Themessage += otaSalesReport.ReportContent + htmlEnd;
AlternateView htmlView = AlternateView.CreateAlternateViewFromString(Themessage, null, "text/html");
foreach (string imgFile in imgFiles)
{
LinkedResource theEmailImage = new LinkedResource(Path.Combine(imgpath, imgFile), MediaTypeNames.Image.Jpeg);
theEmailImage.ContentId = imgFile.Replace(".jpg", "");
htmlView.LinkedResources.Add(theEmailImage);
}
mail.AlternateViews.Add(htmlView);
//设置好发送邮件服务地址
System.Net.Mail.SmtpClient client = new System.Net.Mail.SmtpClient();
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.Host = "smtp.qq.com"; //这里发邮件用的是126，所以为"smtp.126.com"
client.Port = 25;
client.EnableSsl = true;
client.UseDefaultCredentials = true;
//填写服务器地址相关的用户名和密码信息
client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "cpkehayuptjibgbc");
//发送邮件
client.Send(mail);
#endregion
ViewBag.Message = "发送成功.";
return(RedirectToAction("Index"));
}
