protected void btnDownload_Click(object sender, EventArgs e) { int id = GetQueryIntValue("id"); TSM.Model.pms_Attachment modelpms_Attachment = m_bllpms_Attachment.GetModel1(id); if (modelpms_Attachment == null) { // 参数错误,首先弹出Alert对话框然后关闭弹出窗口 Alert.Show("营销员没有上传过附件!"); return; } string shortName = modelpms_Attachment.AttachmentName; shortName = shortName.Remove(0, 19); //去掉字符串的前19个字符 string filename = Server.MapPath("~/upload/attachment/" + modelpms_Attachment.AttachmentName); Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/octet-stream"; Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(shortName, Encoding.UTF8)); Response.TransmitFile(filename); Response.End(); }
private void SaveAttachment() { if (filePhoto.HasFile) { //获取当前登录用户uid var cookie = HttpContext.Current.Request.Cookies[FormsAuthentication.FormsCookieName]; var ticket = FormsAuthentication.Decrypt(cookie.Value); string uid = ticket.UserData; //获取附件名 string fileName = filePhoto.ShortFileName; TSM.Model.pms_Attachment modelpms_Attachment = new TSM.Model.pms_Attachment(); TSM.BLL.pms_Attachment m_bllpms_Attachment = new TSM.BLL.pms_Attachment(); fileName = fileName.Replace(":", "_").Replace(" ", "_").Replace("\\", "_").Replace("/", "_"); fileName = DateTime.Now.Ticks.ToString() + "_" + fileName; filePhoto.SaveAs(Server.MapPath("~/upload/attachment/" + fileName)); modelpms_Attachment.ProductInfoID = m_bllpms_Product_Info.GetMaxId() - 1; modelpms_Attachment.UploadUid = int.Parse(uid); modelpms_Attachment.AttachmentName = fileName; modelpms_Attachment.AttachmentAddr = "~/upload/attachment/" + fileName; modelpms_Attachment.UploadPermission = "营销员"; modelpms_Attachment.UploadTime = DateTime.Now.Date; m_bllpms_Attachment.Add(modelpms_Attachment); // 清空文件上传组件 filePhoto.Reset(); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(TSM.Model.pms_Attachment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update pms_Attachment set "); strSql.Append("ProductInfoID=@ProductInfoID,"); strSql.Append("UploadUid=@UploadUid,"); strSql.Append("AttachmentName=@AttachmentName,"); strSql.Append("AttachmentAddr=@AttachmentAddr,"); strSql.Append("UploadPermission=@UploadPermission,"); strSql.Append("UploadTime=@UploadTime"); strSql.Append(" where AttachmentID=@AttachmentID "); SqlParameter[] parameters = { new SqlParameter("@AttachmentID", SqlDbType.Int, 4), new SqlParameter("@ProductInfoID", SqlDbType.Int, 4), new SqlParameter("@UploadUid", SqlDbType.Int, 4), new SqlParameter("@AttachmentName", SqlDbType.VarChar, 64), new SqlParameter("@AttachmentAddr", SqlDbType.VarChar, 64), new SqlParameter("@UploadPermission", SqlDbType.VarChar, 64), new SqlParameter("@UploadTime", SqlDbType.DateTime) }; parameters[0].Value = model.AttachmentID; parameters[1].Value = model.ProductInfoID; parameters[2].Value = model.UploadUid; parameters[3].Value = model.AttachmentName; parameters[4].Value = model.AttachmentAddr; parameters[5].Value = model.UploadPermission; parameters[6].Value = model.UploadTime; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
private void SaveAttachment() { if (fileUpload.HasFile) { int id = GetQueryIntValue("id"); //获取当前登录用户uid var cookie = HttpContext.Current.Request.Cookies[FormsAuthentication.FormsCookieName]; var ticket = FormsAuthentication.Decrypt(cookie.Value); string uid = ticket.UserData; //保存文件到服务器 string fileName = fileUpload.ShortFileName; fileName = fileName.Replace(":", "_").Replace(" ", "_").Replace("\\", "_").Replace("/", "_"); fileName = DateTime.Now.Ticks.ToString() + "_" + fileName; fileUpload.SaveAs(Server.MapPath("~/upload/attachment/" + fileName)); TSM.Model.pms_Attachment modelpms_Attachment = new TSM.Model.pms_Attachment(); TSM.BLL.pms_Attachment m_bllpms_Attachment = new TSM.BLL.pms_Attachment(); TSM.Model.pms_Attachment modelpms_Attachment_1 = m_bllpms_Attachment.GetModel1(id); if (modelpms_Attachment_1 == null) { // 为空则ADD modelpms_Attachment.ProductInfoID = GetQueryIntValue("id"); modelpms_Attachment.UploadUid = int.Parse(uid); modelpms_Attachment.AttachmentName = fileName; modelpms_Attachment.AttachmentAddr = "~/upload/attachment/" + fileName; modelpms_Attachment.UploadPermission = "营销员"; modelpms_Attachment.UploadTime = DateTime.Now.Date; m_bllpms_Attachment.Add(modelpms_Attachment); } else { //非空则UPDATE modelpms_Attachment.AttachmentID = modelpms_Attachment_1.AttachmentID; modelpms_Attachment.ProductInfoID = GetQueryIntValue("id"); modelpms_Attachment.UploadUid = int.Parse(uid); modelpms_Attachment.AttachmentName = fileName; modelpms_Attachment.AttachmentAddr = "~/upload/attachment/" + fileName; modelpms_Attachment.UploadPermission = "营销员"; modelpms_Attachment.UploadTime = DateTime.Now.Date; m_bllpms_Attachment.Update(modelpms_Attachment); } // 清空文件上传组件 fileUpload.Reset(); } }
/// <summary> /// 得到一个对象实体,通过ProductInfoID,取工艺员上传附件 /// </summary> public TSM.Model.pms_Attachment GetModel2(int ProductInfoID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 AttachmentID,ProductInfoID,UploadUid,AttachmentName,AttachmentAddr,UploadPermission,UploadTime from pms_Attachment "); strSql.Append(" where UploadPermission='工艺员' and ProductInfoID=@ProductInfoID "); SqlParameter[] parameters = { new SqlParameter("@ProductInfoID", SqlDbType.Int, 4) }; parameters[0].Value = ProductInfoID; TSM.Model.pms_Attachment model = new TSM.Model.pms_Attachment(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["AttachmentID"].ToString() != "") { model.AttachmentID = int.Parse(ds.Tables[0].Rows[0]["AttachmentID"].ToString()); } if (ds.Tables[0].Rows[0]["ProductInfoID"].ToString() != "") { model.ProductInfoID = int.Parse(ds.Tables[0].Rows[0]["ProductInfoID"].ToString()); } if (ds.Tables[0].Rows[0]["UploadUid"].ToString() != "") { model.UploadUid = int.Parse(ds.Tables[0].Rows[0]["UploadUid"].ToString()); } model.AttachmentName = ds.Tables[0].Rows[0]["AttachmentName"].ToString(); model.AttachmentAddr = ds.Tables[0].Rows[0]["AttachmentAddr"].ToString(); model.UploadPermission = ds.Tables[0].Rows[0]["UploadPermission"].ToString(); if (ds.Tables[0].Rows[0]["UploadTime"].ToString() != "") { model.UploadTime = DateTime.Parse(ds.Tables[0].Rows[0]["UploadTime"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TSM.Model.pms_Attachment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into pms_Attachment("); strSql.Append("ProductInfoID,UploadUid,AttachmentName,AttachmentAddr,UploadPermission,UploadTime)"); strSql.Append(" values ("); strSql.Append("@ProductInfoID,@UploadUid,@AttachmentName,@AttachmentAddr,@UploadPermission,@UploadTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ProductInfoID", SqlDbType.Int, 4), new SqlParameter("@UploadUid", SqlDbType.Int, 4), new SqlParameter("@AttachmentName", SqlDbType.VarChar, 64), new SqlParameter("@AttachmentAddr", SqlDbType.VarChar, 64), new SqlParameter("@UploadPermission", SqlDbType.VarChar, 64), new SqlParameter("@UploadTime", SqlDbType.DateTime) }; parameters[0].Value = model.ProductInfoID; parameters[1].Value = model.UploadUid; parameters[2].Value = model.AttachmentName; parameters[3].Value = model.AttachmentAddr; parameters[4].Value = model.UploadPermission; parameters[5].Value = model.UploadTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }