public string FileUpload(long siteId, long menuId, string TemplateName, string Base64 = "")
{
if (Request.Files == null || Request.Files.Count == 0)
{
return(null);
}
HttpPostedFileBase file = Request.Files[0];
if (file.ContentLength == 0)
{
return(null);
}
ViewModels.MemberShipSetFile fileModel = new ViewModels.MemberShipSetFile()
{
FileInfo = WorkV3.Golbal.UpdFileInfo.SaveFilesByMenuID(file, siteId, menuId, Base64),
FileSize = file.ContentLength,
FileSizeDesc = uFiles.SizeToText((long)file.ContentLength),
ShowName = Path.GetFileNameWithoutExtension(file.FileName)
};
return(Newtonsoft.Json.JsonConvert.SerializeObject(fileModel));
}
public static MailTemplateSetModels GetMailTemplateItems(string TemplateName)
{
string sel_sql = $"SELECT * FROM MailTemplateSet WHERE TemplateName='{ TemplateName.Replace("'", "")}' ";
using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(WebInfo.Conn))
{
var qResult = conn.Query <MailTemplateSetModels>(sel_sql);
if (qResult != null && qResult.Count() > 0)
{
MailTemplateSetModels model = qResult.First();
model.AttShowFiles = "";
if (!string.IsNullOrEmpty(model.AttFiles))
{
List <ViewModels.MemberShipSetFile> fileShowList = new List <ViewModels.MemberShipSetFile>();
List <WorkV3.Models.ResourceFilesModels> fileList = Newtonsoft.Json.JsonConvert.DeserializeObject <List <WorkV3.Models.ResourceFilesModels> >(model.AttFiles);
foreach (WorkV3.Models.ResourceFilesModels fileModel in fileList)
{
ViewModels.MemberShipSetFile showFile = new ViewModels.MemberShipSetFile()
{
FileInfo = fileModel.FileInfo,
FileSize = fileModel.FileSize.HasValue ? fileModel.FileSize.Value : 0,
FileSizeDesc = "0",
ShowName = fileModel.ShowName
};
showFile.FileSizeDesc = WorkLib.uFiles.SizeToText((long)showFile.FileSize);
fileShowList.Add(showFile);
}
model.AttShowFiles = Newtonsoft.Json.JsonConvert.SerializeObject(fileShowList);
}
return(model);
}
else
{
MailTemplateSetModels item = new MailTemplateSetModels();
item.TemplateName = TemplateName;
System.Xml.XmlDocument xmldoc = new System.Xml.XmlDocument();
xmldoc.Load(HttpContext.Current.Server.MapPath("~/App_Data/mailContent/MailTemplates.xml"));
System.Xml.XmlNode templateNode = xmldoc.SelectSingleNode(string.Format("/Mails/Template[@ID='{0}']", TemplateName));
item.MailTitle = templateNode.SelectSingleNode("Subject").InnerXml;
item.MailContent = templateNode.SelectSingleNode("Content").InnerXml;
item.MailFromName = (string)WorkLib.GetItem.appSet("MailSender");
item.MailFromAddress = (string)WorkLib.GetItem.appSet("MailFrom");
item.AttFiles = "";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("MailTemplateSet");
tableObj.GetDataFromObject(item);
if (Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent != null)
{
tableObj["Creator"] = Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
}
else
{
tableObj["Creator"] = 0;
}
tableObj["CreateTime"] = DateTime.Now;
if (Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent != null)
{
tableObj["Modifier"] = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
}
else
{
tableObj["Modifier"] = 0;
}
tableObj["ModifyTime"] = DateTime.Now;
tableObj.Insert();
return(item);
}
}
//return new MailTemplateSetModels();
}
