/// <summary> /// 获得数据列表 /// </summary> public List <LPWeb.Model.Email_AttachmentsTemp> DataTableToList(DataTable dt) { List <LPWeb.Model.Email_AttachmentsTemp> modelList = new List <LPWeb.Model.Email_AttachmentsTemp>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { LPWeb.Model.Email_AttachmentsTemp model; for (int n = 0; n < rowsCount; n++) { model = new LPWeb.Model.Email_AttachmentsTemp(); if (dt.Rows[n]["Id"].ToString() != "") { model.Id = int.Parse(dt.Rows[n]["Id"].ToString()); } model.Token = dt.Rows[n]["Token"].ToString(); if (dt.Rows[n]["TemplAttachId"].ToString() != "") { model.TemplAttachId = int.Parse(dt.Rows[n]["TemplAttachId"].ToString()); } model.Name = dt.Rows[n]["Name"].ToString(); model.FileType = dt.Rows[n]["FileType"].ToString(); if (dt.Rows[n]["FileImage"].ToString() != "") { model.FileImage = (byte[])dt.Rows[n]["FileImage"]; } if (dt.Rows[n]["CreateDateTime"].ToString() != "") { model.CreateDateTime = DateTime.Parse(dt.Rows[n]["CreateDateTime"].ToString()); } modelList.Add(model); } } return(modelList); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["CloseDialogCodes"] != null) // 如果有LoanID { CloseDialogCodes = Request.QueryString["CloseDialogCodes"].ToString(); } if (Request.QueryString["TemplEmailId"] != null) // 如果有LoanID { string sTemplEmailId = Request.QueryString["TemplEmailId"]; if (PageCommon.IsID(sTemplEmailId) == false) { PageCommon.WriteJsEnd(this, sErrorMsg, CloseDialogCodes); } TemplEmailId = Convert.ToInt32(sTemplEmailId); } Token = Request.QueryString["token"] != null ? Request.QueryString["token"].ToString() : ""; isListTemplEmailAttach = Request.QueryString["isListTemplEmailAttach"] != null?Convert.ToBoolean(Request.QueryString["isListTemplEmailAttach"]) : false; if (!IsPostBack) { if (isListTemplEmailAttach) { LPWeb.BLL.Template_Email_Attachments bllTempEmailAttach = new Template_Email_Attachments(); var ds = bllTempEmailAttach.GetListWithOutFileImage(" Enabled =1 AND TemplEmailId = " + TemplEmailId); StringBuilder sb = new StringBuilder(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { sb.Append("<option value='s" + dr["TemplAttachId"].ToString() + "' >" + dr["Name"].ToString() + "." + dr["FileType"].ToString() + "</option>"); } } Default_lbxAttachments = sb.ToString(); } } ///判定是不是 在执行发送 if (Request.Form["hidIsSend"] != null) { sLocalTime = Request.Form["hfLocalTime"].ToString().Trim(); //Attachment #region Attachments if (Request.Files.Count > 0) { foreach (var key in Request.Files.AllKeys) { var file = Request.Files[key]; if (file.ContentLength > 0 && !string.IsNullOrEmpty(file.FileName)) { if (file.ContentLength > 1024 * 1024 * 20) { ErrorMsg("The file you tried to upload has exceeded the allowed limit, 20MB."); Response.End(); } byte[] bytes = new byte[file.InputStream.Length]; file.InputStream.Read(bytes, 0, bytes.Length); file.InputStream.Seek(0, SeekOrigin.Begin); FileInfo info = new FileInfo(file.FileName); Attachments.Add(info.Name, bytes); } } } #endregion if (Attachments.Count == 0) { ErrorMsg("Attachments / Note is empty."); Response.End(); } #region Save file try { LPWeb.BLL.Email_AttachmentsTemp bllEmailAttachTemp = new Email_AttachmentsTemp(); foreach (var item in Attachments) { LPWeb.Model.Email_AttachmentsTemp model = new LPWeb.Model.Email_AttachmentsTemp(); model.Token = Token; model.Name = item.Key.ToString().Substring(0, item.Key.ToString().LastIndexOf('.')); model.FileType = item.Key.ToString().Substring(item.Key.ToString().LastIndexOf('.') + 1); model.FileImage = item.Value; bllEmailAttachTemp.Add(model); } ErrorMsg(true, ""); } catch (Exception ex) { ErrorMsg(ex.Message.Replace("\"", "").Replace("\\n", "")); } #endregion Response.End(); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(LPWeb.Model.Email_AttachmentsTemp model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(LPWeb.Model.Email_AttachmentsTemp model) { return(dal.Add(model)); }