private Entity.BASE_ARTICLE UpLoadAnnex(Entity.BASE_ARTICLE model) { BLL.BASE_ARTICLE_ANNEX bllAnnex = new BLL.BASE_ARTICLE_ANNEX(); for (int index = 0; index < Request.Files.Count; index++) { if (!string.IsNullOrEmpty(Request.Files[index].FileName)) { Entity.BASE_ARTICLE_ANNEX annex = new Entity.BASE_ARTICLE_ANNEX(); annex.SERVERNAME = Guid.NewGuid().ToString(); //服务器存储文件名 annex.SOURCENAME = Path.GetFileName(Request.Files[index].FileName); //原文件名称 annex.EXTENSION = Path.GetExtension(Request.Files[index].FileName); //文件扩展名 annex.STATUS = 0; //存储状态:0正常 annex.UPAUTHOR = userSession.USERID; //上传者用户ID annex.UPTIME = DateTime.Now; //文件上传时间 annex.SERVERPATH = string.Format("Document/{0}/", DateTime.Now.ToString("yyyyMMdd")); //判断服务器存储目录路径是否存在 if (!Directory.Exists(Server.MapPath("~/") + annex.SERVERPATH)) { Directory.CreateDirectory(Server.MapPath("~/") + annex.SERVERPATH); } //保存附件(服务器存储路径) Request.Files[index].SaveAs(Server.MapPath("~/") + annex.SERVERPATH + annex.SERVERNAME + annex.EXTENSION); //加入数据库 bllAnnex.Add(annex); //公文附件示例:12,56,87,96,56 model.ANNEX += bllAnnex.GetMaxId().ToString() + ","; } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Entity.BASE_ARTICLE_ANNEX model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BASE_ARTICLE_ANNEX("); strSql.Append("ID,SOURCENAME,EXTENSION,SERVERNAME,SERVERPATH,UPTIME,STATUS,UPAUTHOR"); strSql.Append(") values ("); strSql.Append(":ID,:SOURCENAME,:EXTENSION,:SERVERNAME,:SERVERPATH,:UPTIME,:STATUS,:UPAUTHOR"); strSql.Append(") "); OracleParameter[] parameters = { new OracleParameter(":ID", OracleType.Number, 4), new OracleParameter(":SOURCENAME", OracleType.VarChar, 100), new OracleParameter(":EXTENSION", OracleType.VarChar, 10), new OracleParameter(":SERVERNAME", OracleType.VarChar, 50), new OracleParameter(":SERVERPATH", OracleType.VarChar, 100), new OracleParameter(":UPTIME", OracleType.DateTime), new OracleParameter(":STATUS", OracleType.Number, 4), new OracleParameter(":UPAUTHOR", OracleType.Number, 4) }; parameters[0].Value = model.ID; parameters[1].Value = model.SOURCENAME; parameters[2].Value = model.EXTENSION; parameters[3].Value = model.SERVERNAME; parameters[4].Value = model.SERVERPATH; parameters[5].Value = model.UPTIME; parameters[6].Value = model.STATUS; parameters[7].Value = model.UPAUTHOR; OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters); }
//添加公文 private void Creates(Entity.BASE_ARTICLE model) { #region 附件 BLL.BASE_ARTICLE_ANNEX bllAnnex = new BLL.BASE_ARTICLE_ANNEX(); for (int index = 0; index < Request.Files.Count; index++) { if (!string.IsNullOrEmpty(Request.Files[index].FileName)) { Entity.BASE_ARTICLE_ANNEX annex = new Entity.BASE_ARTICLE_ANNEX(); annex.SERVERNAME = Guid.NewGuid().ToString(); //服务器存储文件名 annex.SOURCENAME = Path.GetFileName(Request.Files[index].FileName); //原文件名称 annex.EXTENSION = Path.GetExtension(Request.Files[index].FileName); //文件扩展名 annex.STATUS = 0; //存储状态:0正常 annex.UPAUTHOR = userSession.USERID; //上传者用户ID annex.UPTIME = DateTime.Now; //文件上传时间 annex.SERVERPATH = string.Format("Document/{0}/", DateTime.Now.ToString("yyyyMMdd")); //判断服务器存储目录路径是否存在 if (!Directory.Exists(Server.MapPath("~/") + annex.SERVERPATH)) { Directory.CreateDirectory(Server.MapPath("~/") + annex.SERVERPATH); } //保存附件(服务器存储路径) Request.Files[index].SaveAs(Server.MapPath("~/") + annex.SERVERPATH + annex.SERVERNAME + annex.EXTENSION); //加入数据库 bllAnnex.Add(annex); //公文附件示例:12,56,87,96,56 model.ANNEX += bllAnnex.GetMaxId().ToString() + ","; } } #endregion //保存公文到数据库 bll.Add(model); /*回复模式不需要添加收文单位*/ if (hidParentPrimary.Value.Equals("0")) { //获取出刚添加的公文ID编号 string where = string.Format("TITLE='{0}'", model.TITLE); int id = Convert.ToInt32(bll.GetList(where).Rows[0]["ID"].ToString()); //增加公文接收部门记录 foreach (TreeNode node in TreeViewAcceptUnit.Nodes) { RecursiveSubNode(node, id); } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Entity.BASE_ARTICLE_ANNEX model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BASE_ARTICLE_ANNEX set "); strSql.Append(" ID = :ID , "); strSql.Append(" SOURCENAME = :SOURCENAME , "); strSql.Append(" EXTENSION = :EXTENSION , "); strSql.Append(" SERVERNAME = :SERVERNAME , "); strSql.Append(" SERVERPATH = :SERVERPATH , "); strSql.Append(" UPTIME = :UPTIME , "); strSql.Append(" STATUS = :STATUS , "); strSql.Append(" UPAUTHOR = :UPAUTHOR "); strSql.Append(" where ID=:ID "); OracleParameter[] parameters = { new OracleParameter(":ID", OracleType.Number, 4), new OracleParameter(":SOURCENAME", OracleType.VarChar, 100), new OracleParameter(":EXTENSION", OracleType.VarChar, 10), new OracleParameter(":SERVERNAME", OracleType.VarChar, 50), new OracleParameter(":SERVERPATH", OracleType.VarChar, 100), new OracleParameter(":UPTIME", OracleType.DateTime), new OracleParameter(":STATUS", OracleType.Number, 4), new OracleParameter(":UPAUTHOR", OracleType.Number, 4) }; parameters[8].Value = model.ID; parameters[9].Value = model.SOURCENAME; parameters[10].Value = model.EXTENSION; parameters[11].Value = model.SERVERNAME; parameters[12].Value = model.SERVERPATH; parameters[13].Value = model.UPTIME; parameters[14].Value = model.STATUS; parameters[15].Value = model.UPAUTHOR; int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Entity.BASE_ARTICLE_ANNEX GetEntity(decimal ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, SOURCENAME, EXTENSION, SERVERNAME, SERVERPATH, UPTIME, STATUS, UPAUTHOR "); strSql.Append(" from BASE_ARTICLE_ANNEX "); strSql.Append(" where ID=:ID "); OracleParameter[] parameters = { new OracleParameter(":ID", OracleType.Number, 4) }; parameters[0].Value = ID; Entity.BASE_ARTICLE_ANNEX entity = new Entity.BASE_ARTICLE_ANNEX(); DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters); if (dt.Rows.Count > 0) { if (dt.Rows[0]["ID"].ToString() != "") { entity.ID = decimal.Parse(dt.Rows[0]["ID"].ToString()); } entity.SOURCENAME = dt.Rows[0]["SOURCENAME"].ToString(); entity.EXTENSION = dt.Rows[0]["EXTENSION"].ToString(); entity.SERVERNAME = dt.Rows[0]["SERVERNAME"].ToString(); entity.SERVERPATH = dt.Rows[0]["SERVERPATH"].ToString(); if (dt.Rows[0]["UPTIME"].ToString() != "") { entity.UPTIME = DateTime.Parse(dt.Rows[0]["UPTIME"].ToString()); } if (dt.Rows[0]["STATUS"].ToString() != "") { entity.STATUS = decimal.Parse(dt.Rows[0]["STATUS"].ToString()); } if (dt.Rows[0]["UPAUTHOR"].ToString() != "") { entity.UPAUTHOR = decimal.Parse(dt.Rows[0]["UPAUTHOR"].ToString()); } return(entity); } else { return(null); } }
public void Add(Entity.BASE_ARTICLE_ANNEX model) { dal.Add(model); }