protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { IniData(); lblParent.Text = ""; lblFolderId.Visible = false; tb_AttachmentService attSer = new tb_AttachmentService(); if (base.Request["Id"] != null) { this.btnAdd.Visible = false; tb_Attachment attachment = attSer.GetListArrayByParentId(Convert.ToInt32(base.Request["Id"])); txtAttName.Text = attachment.MainName; txtRemark.Text = attachment.Remark; txtVersion.Text = attachment.version; lblFolderId.Text = attachment.Folder_Id.ToString(); lblParent.Text = attachment.FolderName; lblAttName.Text = attachment.fileName; } else { this.btnUpdate.Visible = false; } } }
public int AddSomAttachments(tb_Attachment attachments) { int id = 0; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; try { objCommand.Parameters.Clear(); id = attachmentSer.Add(attachments, objCommand); tan.Commit(); } catch (Exception) { tan.Rollback(); return(0); } return(id); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // string url="<script>window.open('55.htm', '','fullscreen=yes')</script>"; // Response.Write(url); //if (1 == 1) //{ // return; //} if (Request["id"] != null) { tb_AttachmentService attSer = new tb_AttachmentService(); tb_Attachment atts = attSer.GetListArrayByParentId_Pre(Request["id"]); if (atts != null) { string qizhui = System.Web.HttpContext.Current.Request.MapPath("Attachment/") + Request["id"]; string fileExtension = atts.fileName.Substring(atts.fileName.LastIndexOf(".") + 1).ToLower(); if (fileExtension == "doc" || fileExtension == "docx") { if (File.Exists(qizhui + "." + "htm") == false) { WordToHtml(qizhui + "." + fileExtension, qizhui + ".htm"); } // url = "/Attachment/" + Request["id"] + ".htm"; Response.Redirect("~/Attachment/" + Request["id"] + ".htm"); } else if (fileExtension == "xlsx" || fileExtension == "xls") { if (File.Exists(qizhui + "." + "htm") == false) { ExcelConvertToHtml(qizhui + "." + fileExtension, qizhui + ".htm"); } // url = "/Attachment/" + Request["id"] + ".htm"; Response.Redirect("~/Attachment/" + Request["id"] + ".htm"); } else { Response.Redirect("~/Attachment/" + Request["id"] + "." + fileExtension); //Response.ContentType = atts.FileType; //Response.BinaryWrite((byte[])atts.fileNo); //Response.Write(atts.fileName.ToString()); } } // Response.Write("<script>window.close();window.opener=null;</script>"); } } }
/// <summary> /// treeview /// </summary> /// <param name="strWhere"></param> /// <returns></returns> public List <tb_Attachment> GetListArray_TV(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select MainName,id,tb_Attachment.folder_Id, ParentId,createTime"); strSql.Append(" FROM tb_Attachment left join tb_Folder on tb_Attachment.folder_Id=tb_Folder.folder_Id"); if (strWhere.Trim() != "") { strSql.Append(" where 1=1 " + strWhere); } strSql.Append(" order by MainName,createTime desc"); List <tb_Attachment> list = new List <tb_Attachment>(); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader objReader = objCommand.ExecuteReader()) { while (objReader.Read()) { tb_Attachment model = new tb_Attachment(); object ojb; ojb = objReader["id"]; if (ojb != null && ojb != DBNull.Value) { model.id = (int)ojb; } ojb = objReader["Folder_Id"]; if (ojb != null && ojb != DBNull.Value) { model.Folder_Id = (int)ojb; } ojb = objReader["ParentId"]; if (ojb != null && ojb != DBNull.Value) { model.Parentd = ojb.ToString(); } ojb = objReader["createTime"]; if (ojb != null && ojb != DBNull.Value) { model.createTime = Convert.ToDateTime(ojb); } model.MainName = objReader["MainName"].ToString(); list.Add(model); } } } return(list); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(tb_Attachment model, SqlCommand objCommand) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Attachment set "); if (model.Folder_Id != null) { strSql.Append("Folder_Id=" + model.Folder_Id + ","); } if (model.fileName != null) { strSql.Append("fileName='" + model.fileName + "',"); } if (model.fileNo != null) { strSql.Append("fileNo=@fileNo,"); SqlParameter pp = new System.Data.SqlClient.SqlParameter("@fileNo", System.Data.SqlDbType.Image, model.fileNo.Length); pp.Value = model.fileNo; objCommand.Parameters.Add(pp); } if (model.createTime != null) { strSql.Append("createTime='" + model.createTime + "',"); } if (model.userName != null) { strSql.Append("userName='******',"); } if (model.version != null) { strSql.Append("version='" + model.version + "',"); } if (model.Remark != null) { strSql.Append("Remark='" + model.Remark + "',"); } if (model.MainName != null) { strSql.Append("MainName='" + model.MainName + "',"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where id=" + model.id + ""); objCommand.CommandText = strSql.ToString(); objCommand.ExecuteNonQuery(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request["id"]!=null) { tb_AttachmentService attSer = new tb_AttachmentService(); tb_Attachment atts = attSer.GetListArrayByParentId_Down( Request["id"]); if (atts != null ) { string qizhui = System.Web.HttpContext.Current.Request.MapPath("Attachment/") + Request["id"]; string fileExtension = atts.fileName.Substring(atts.fileName.LastIndexOf(".") + 1).ToLower(); string url = qizhui + "." + fileExtension; down1(Request["id"]+"." + fileExtension, url); //Response.Buffer = true; //Page.Response.Clear();//清除缓冲区所有内容 //Page.Response.ContentType = "application/octet-stream"; //Page.Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(atts.fileName)); //byte[] file; //if (atts.fileNo == null) //{ // file = new byte[0]; //} //else //{ // file = (Byte[])atts.fileNo;//读出数据 //} //int a = file.Length; //if (atts.fileNo != null) //{ // Response.BinaryWrite(file); //} //Response.Flush(); //Response.End(); } // Response.Write("<script>window.close();window.opener=null;</script>"); } } }
/// <summary> /// 对象实体绑定数据 /// </summary> public tb_Attachment ReaderBind(IDataReader dataReader) { tb_Attachment model = new tb_Attachment(); object ojb; ojb = dataReader["id"]; if (ojb != null && ojb != DBNull.Value) { model.id = (int)ojb; } ojb = dataReader["Folder_Id"]; if (ojb != null && ojb != DBNull.Value) { model.Folder_Id = (int)ojb; } model.fileName = dataReader["fileName"].ToString(); //ojb = dataReader["fileNo"]; //if (ojb != null && ojb != DBNull.Value) //{ // model.fileNo = (byte[])ojb; //} ojb = dataReader["FileType"]; if (ojb != null && ojb != DBNull.Value) { model.FileType = ojb.ToString(); } ojb = dataReader["createTime"]; if (ojb != null && ojb != DBNull.Value) { model.createTime = (DateTime)ojb; } model.userName = dataReader["userName"].ToString(); model.version = dataReader["version"].ToString(); model.Remark = dataReader["Remark"].ToString(); model.MainName = dataReader["MainName"].ToString(); ojb = dataReader["Folder_NAME"]; if (ojb != null && ojb != DBNull.Value) { model.FolderName = ojb.ToString(); } return(model); }
public bool UpdateSomAttachments(tb_Attachment attachments) { using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; try { objCommand.Parameters.Clear(); attachmentSer.Update(attachments, objCommand); tan.Commit(); } catch (Exception) { tan.Rollback(); return(false); } return(true); } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { if (txtAttName.Text.Trim() == "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写文件名称!');</script>"); return; } if (lblParent.Text == "" || lblParent.Text == "内部文件") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请选择一个文件!');</script>"); return; } tb_Attachment att = new tb_Attachment(); att.createTime = DateTime.Now; att.MainName = txtAttName.Text; att.Folder_Id = Convert.ToInt32(lblFolderId.Text); att.Remark = txtRemark.Text; att.userName = Session["LoginName"].ToString(); att.version = txtVersion.Text; att.id = Convert.ToInt32(base.Request["Id"]); HttpFileCollection files = HttpContext.Current.Request.Files; string fileName, fileExtension; fileExtension = ""; HttpPostedFile postedFile = null; for (int iFile = 0; iFile < files.Count; iFile++) { ///'检查文件扩展名字 postedFile = files[iFile]; //string fileName, fileExtension; fileName = System.IO.Path.GetFileName(postedFile.FileName); if (fileName != "") { att.fileName = fileName; fileExtension = System.IO.Path.GetExtension(fileName); string fileType = postedFile.ContentType.ToString(); //文件类型 att.FileType = fileType; System.IO.Stream streamFile = postedFile.InputStream; //建立数据流对象 int fileLength = postedFile.ContentLength; //文件长度以字节为单位 byte[] fileData = new Byte[fileLength]; //新建一个数组 streamFile.Read(fileData, 0, fileLength); //将这个数据流读取到数组中 att.fileNo = fileData; } } tb_AttachmentManager attMan = new tb_AttachmentManager(); if (attMan.UpdateSomAttachments(att)) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('保存成功!');</script>"); if (att.fileNo != null && fileExtension != "") { if (lblAttName.Text != "") { string attName = System.Web.HttpContext.Current.Request.MapPath("Attachment/") + att.id + lblAttName.Text.Substring(lblAttName.Text.LastIndexOf(".")); string ban = System.Web.HttpContext.Current.Request.MapPath("Attachment/") + att.id; if (File.Exists(attName)) { try { File.Delete(attName); File.Delete(ban + ".htm"); File.Delete(ban + ".files"); } catch (Exception) { } } } string qizhui = System.Web.HttpContext.Current.Request.MapPath("Attachment/") + att.id; postedFile.SaveAs(qizhui + fileExtension); fileExtension = fileExtension.Substring(1, fileExtension.Length - 1).ToLower(); if (fileExtension == "doc" || fileExtension == "docx") { WordToHtml(qizhui + "." + fileExtension, qizhui + ".htm"); } else if (fileExtension == "xlsx" || fileExtension == "xls") { ExcelConvertToHtml(qizhui + "." + fileExtension, qizhui + ".htm"); } } Response.Redirect("~/WfAttachmentList.aspx"); } else { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('保存失败!');</script>"); // Response.Redirect("~/WfAttachmentList.aspx"); } } catch (Exception EX) { base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('{0}');</script>", EX.Message.ToString())); } }
public int Insert(SPKHeaderModel hdr, List <SPKAdditionalModel> lsAdditional, SPKEquipmentModel misc, List <SPKAttachmentModel> attchs, int docType, out string errMsg) { errMsg = string.Empty; imap = config.CreateMapper(); int _spkId = 0; tb_spkHdr hdrEnt = new tb_spkHdr(); tb_KetTambahan miscEnt = new tb_KetTambahan(); tb_PerlTambahan additionalEnt = new tb_PerlTambahan(); using (TDMDBEntities context = new TDMDBEntities()) { using (var transaction = context.Database.BeginTransaction()) { try { imap = config.CreateMapper(); hdrEnt = imap.Map <SPKHeaderModel, tb_spkHdr>(hdr); context.tb_spkHdr.Add(hdrEnt); result_affected = context.SaveChanges(); _spkId = hdrEnt.Id; foreach (var item in lsAdditional) { additionalEnt.No = item.No; additionalEnt.SPKId = _spkId; additionalEnt.AdditionalItem = item.Additional; context.tb_PerlTambahan.Add(additionalEnt); result_affected += context.SaveChanges(); } //miscEnt = imap.Map<SPKEquipmentModel, tb_KetTambahan>(misc); //miscEnt.SPKId = _spkId; //context.tb_KetTambahan.Add(miscEnt); //result_affected += context.SaveChanges(); foreach (var item in attchs) { tb_Attachment attchEnt = new tb_Attachment(); attchEnt.Attachment = item.Attachment; attchEnt.AttachmentName = item.AttachmentName; attchEnt.DocType = item.DocType; attchEnt.DocId = _spkId; attchEnt.CreatedBy = "SYSTEM"; attchEnt.CreatedDate = DateTime.Now; context.tb_Attachment.Add(attchEnt); result_affected += context.SaveChanges(); } //insert to worklist tb_Worklist _entWorklist = new tb_Worklist(); _entWorklist.DocId = _spkId; _entWorklist.DocType = docType; _entWorklist.Status = MyEnums.workflowStatus.PENDING.ToString(); _entWorklist.StartDate = DateTime.Now; _entWorklist.CurrLevel = 0; _entWorklist.NextApprover = Convert.ToInt32(new WorkflowSettingBLL().GetNextActorId(docType, _entWorklist.CurrLevel + 1)); _entWorklist.CreatedBy = hdr.CreatedBy; _entWorklist.CreatedDate = DateTime.Now; context.tb_Worklist.Add(_entWorklist); result_affected += context.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); errMsg = ex.Message; } } } return(_spkId); }
public int Update(SPKHeaderModel hdr, List <SPKAdditionalModel> lsAdditional, SPKEquipmentModel misc, List <SPKAttachmentModel> attchs, int docType, WorklistModel wrkl, out string errMsg) { errMsg = string.Empty; imap = config.CreateMapper(); result_affected = 0; tb_spkHdr hdrEnt = new tb_spkHdr(); tb_KetTambahan miscEnt = new tb_KetTambahan(); tb_PerlTambahan additionalEnt = new tb_PerlTambahan(); tb_Worklist_Archive worklistArchive = new tb_Worklist_Archive(); using (TDMDBEntities context = new TDMDBEntities()) { using (var transaction = context.Database.BeginTransaction()) { try { var update = context.tb_spkHdr.SingleOrDefault(x => x.Id == hdr.Id); if (update != null) { update.SPKDate = hdr.SPKDate; update.JanjiPenyerahan = hdr.JanjiPenyerahan; update.LOTNo = hdr.LOTNo; update.Buyer = hdr.Buyer; update.BuyerAddress = hdr.BuyerAddress; update.KTP = hdr.KTP; update.Phone = hdr.Phone; update.STNKName = hdr.STNKName; update.STNKAddress = hdr.STNKAddress; update.Email = hdr.Email; update.Branch = hdr.Branch; update.Merk = hdr.Merk; update.Warna = hdr.Warna; update.Karoseri = hdr.Karoseri; update.MachineNo = hdr.MachineNo; update.RangkaNo = hdr.RangkaNo; update.Pembiayaan = hdr.Pembiayaan; update.Year = hdr.Year; update.Via = hdr.Via; update.PercentageBunga = hdr.PercentageBunga; update.OTRPrice = hdr.OTRPrice; update.KaroseriPrice = hdr.KaroseriPrice; update.TotalPrice = hdr.TotalPrice; update.DP = hdr.DP; update.TandaJadi = hdr.TandaJadi; update.Pembayaran = hdr.Pembayaran; update.TransferVia = hdr.TransferVia; update.AlamatKirim = hdr.AlamatKirim; update.City = hdr.City; update.IsKaroseri = hdr.IsKaroseri; update.KaroseriDesc = hdr.KaroseriDesc; update.IsOnTR = hdr.IsOnTR; update.IsOffTR = hdr.IsOffTR; update.IsChooseNo = hdr.IsChooseNo; update.ChooseNo = hdr.ChooseNo; update.ModifiedBy = hdr.ModifiedBy; update.ModifiedDate = DateTime.Now; result_affected = context.SaveChanges(); #region ::ADDITIONAL ITEMS:: //remove additional items var _qryAdditional = context.tb_PerlTambahan.Where(x => x.SPKId == hdr.Id); context.tb_PerlTambahan.RemoveRange(_qryAdditional); context.SaveChanges(); //add additional items foreach (var item in lsAdditional) { additionalEnt.No = item.No; additionalEnt.SPKId = hdr.Id; additionalEnt.AdditionalItem = item.Additional; context.tb_PerlTambahan.Add(additionalEnt); result_affected += context.SaveChanges(); } #endregion #region ::ATTACHMENTS:: foreach (var item in attchs) { tb_Attachment attchEnt = new tb_Attachment(); attchEnt.Attachment = item.Attachment; attchEnt.AttachmentName = item.AttachmentName; attchEnt.DocType = item.DocType; attchEnt.DocId = hdr.Id; attchEnt.CreatedBy = "SYSTEM"; attchEnt.CreatedDate = DateTime.Now; context.tb_Attachment.Add(attchEnt); result_affected += context.SaveChanges(); } #endregion #region ::WORKFLOW APPROVAL:: var _updWorklist = context.tb_Worklist.SingleOrDefault(x => x.DocId == hdr.Id && x.DocType == docType); if (wrkl.Actioner.ToLower() == MyEnums.actionStatus.APPROVE.ToString().ToLower() || wrkl.Actioner.ToLower() == MyEnums.actionStatus.ACKNOWLEDGE.ToString().ToLower()) { if (_updWorklist != null) { worklistArchive = imap.Map <tb_Worklist, tb_Worklist_Archive>(_updWorklist); worklistArchive.RespondDate = DateTime.Now; worklistArchive.Actioner = wrkl.Actioner; worklistArchive.LastActor = wrkl.Actor; worklistArchive.CreatedBy = _updWorklist.CreatedBy; worklistArchive.CreatedDate = _updWorklist.CreatedDate; worklistArchive.ModifiedBy = hdr.CreatedBy; worklistArchive.ModifiedDate = DateTime.Now; worklistArchive.LastLevel = _updWorklist.CurrLevel + 1; worklistArchive.IsCompleted = new WorkflowSettingBLL().CheckIsWorkflowCompleted(docType, (int)worklistArchive.LastLevel); if (worklistArchive.IsCompleted) { worklistArchive.Status = MyEnums.workflowStatus.COMPLETED.ToString(); } context.tb_Worklist_Archive.Add(worklistArchive); context.SaveChanges(); if (!worklistArchive.IsCompleted) { //update status worklist _updWorklist.CurrLevel = _updWorklist.CurrLevel + 1; _updWorklist.ModifiedBy = hdr.ModifiedBy; _updWorklist.ModifiedDate = DateTime.Now; _updWorklist.NextApprover = Convert.ToInt32(new WorkflowSettingBLL().GetNextActorId(docType, _updWorklist.CurrLevel + 1)); result_affected += context.SaveChanges(); } else { var removeDocId = context.tb_Worklist.Where(x => x.DocId == hdr.Id); context.tb_Worklist.RemoveRange(removeDocId); result_affected += context.SaveChanges(); } } } else if (wrkl.Actioner.ToLower() == MyEnums.actionStatus.REJECT.ToString().ToLower()) { worklistArchive = imap.Map <tb_Worklist, tb_Worklist_Archive>(_updWorklist); worklistArchive.RespondDate = DateTime.Now; worklistArchive.Actioner = wrkl.Actioner; worklistArchive.LastActor = wrkl.Actor; worklistArchive.CreatedBy = _updWorklist.CreatedBy; worklistArchive.CreatedDate = _updWorklist.CreatedDate; worklistArchive.ModifiedBy = hdr.CreatedBy; worklistArchive.ModifiedDate = DateTime.Now; worklistArchive.LastLevel = _updWorklist.CurrLevel + 1; worklistArchive.IsCompleted = true; context.tb_Worklist_Archive.Add(worklistArchive); context.SaveChanges(); var removeDocId = context.tb_Worklist.Where(x => x.DocId == hdr.Id); context.tb_Worklist.RemoveRange(removeDocId); context.SaveChanges(); } #endregion transaction.Commit(); } } catch (Exception ex) { transaction.Rollback(); errMsg = ex.Message == null ? ex.InnerException.Message : ex.Message; } } } return(result_affected); }
/// <summary> /// 预览 /// </summary> public tb_Attachment GetListArrayByParentId_Pre(string id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select MainName,id,tb_Attachment.folder_Id,fileNo,fileName,fileType,createTime,userName,version,Remark "); strSql.Append(" FROM tb_Attachment "); strSql.Append(" where id=" + id); tb_Attachment model = new tb_Attachment(); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { while (dataReader.Read()) { object ojb; ojb = dataReader["id"]; if (ojb != null && ojb != DBNull.Value) { model.id = (int)ojb; } ojb = dataReader["folder_Id"]; if (ojb != null && ojb != DBNull.Value) { model.Folder_Id = (int)ojb; } model.fileName = dataReader["fileName"].ToString(); ojb = dataReader["FileType"]; if (ojb != null && ojb != DBNull.Value) { model.FileType = ojb.ToString(); } ojb = dataReader["createTime"]; if (ojb != null && ojb != DBNull.Value) { model.createTime = (DateTime)ojb; } model.userName = dataReader["userName"].ToString(); model.version = dataReader["version"].ToString(); model.Remark = dataReader["Remark"].ToString(); model.MainName = dataReader["MainName"].ToString(); //ojb = dataReader["Folder_NAME"]; //if (ojb != null && ojb != DBNull.Value) //{ // model.FolderName = ojb.ToString(); //} ojb = dataReader["fileNo"]; if (ojb != null && ojb != DBNull.Value) { model.fileNo = (byte[])ojb; } } } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(tb_Attachment model, SqlCommand objCommand) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.Folder_Id != null) { strSql1.Append("Folder_Id,"); strSql2.Append("" + model.Folder_Id + ","); } if (model.fileName != null) { strSql1.Append("fileName,"); strSql2.Append("'" + model.fileName + "',"); } if (model.fileNo != null) { strSql1.Append("fileNo,"); strSql2.Append("@fileNo,"); SqlParameter pp = new System.Data.SqlClient.SqlParameter("@fileNo", System.Data.SqlDbType.Image, model.fileNo.Length); pp.Value = model.fileNo; objCommand.Parameters.Add(pp); } if (model.FileType != null) { strSql1.Append("FileType,"); strSql2.Append("'" + model.FileType + "',"); } if (model.createTime != null) { strSql1.Append("createTime,"); strSql2.Append("'" + model.createTime + "',"); } if (model.userName != null) { strSql1.Append("userName,"); strSql2.Append("'" + model.userName + "',"); } if (model.version != null) { strSql1.Append("version,"); strSql2.Append("'" + model.version + "',"); } strSql1.Append("Remark,"); strSql2.Append("'" + model.Remark + "',"); strSql1.Append("MainName,"); strSql2.Append("'" + model.MainName + "',"); strSql.Append("insert into tb_Attachment("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); objCommand.CommandText = strSql.ToString(); int result; object obj = objCommand.ExecuteScalar(); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }