/// <summary> /// 增加一条数据 /// </summary> public void Add(Entity.BASE_ANNEX model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BASE_ANNEX("); strSql.Append("ID,SRCNAME,EXTENSION,SERVERNAME,SERVERPATH,UPTIME,STATUS,UPAUTHOR,DEPTCODE"); strSql.Append(") values ("); strSql.Append(":ID,:SRCNAME,:EXTENSION,:SERVERNAME,:SERVERPATH,:UPTIME,:STATUS,:UPAUTHOR,:DEPTCODE"); strSql.Append(") "); OracleParameter[] parameters = { new OracleParameter(":ID", OracleType.Number, 4), new OracleParameter(":SRCNAME", 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), new OracleParameter(":DEPTCODE", OracleType.Number, 4) }; parameters[0].Value = model.ID; parameters[1].Value = model.SRCNAME; 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; parameters[8].Value = model.DEPTCODE; OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters); }
public decimal Add(Entity.BASE_ANNEX model) { dal.Add(model); decimal id; string sqlString = string.Format("SERVERNAME='{0}'", model.SERVERNAME); string serverName = dal.GetList(sqlString).Tables[0].Rows[0]["ID"].ToString(); id = Convert.ToDecimal(serverName); return(id); }
/// <summary> /// 得到一个对象实体 /// </summary> public Entity.BASE_ANNEX GetEntity(decimal ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, SRCNAME, EXTENSION, SERVERNAME, SERVERPATH, UPTIME, STATUS, UPAUTHOR, DEPTCODE "); strSql.Append(" from BASE_ANNEX "); strSql.Append(" where ID=:ID "); OracleParameter[] parameters = { new OracleParameter(":ID", OracleType.Number, 4) }; parameters[0].Value = ID; Entity.BASE_ANNEX entity = new Entity.BASE_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.SRCNAME = dt.Rows[0]["SRCNAME"].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()); } if (dt.Rows[0]["DEPTCODE"].ToString() != "") { entity.DEPTCODE = decimal.Parse(dt.Rows[0]["DEPTCODE"].ToString()); } return(entity); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Entity.BASE_ANNEX model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BASE_ANNEX set "); strSql.Append(" ID = :ID , "); strSql.Append(" SRCNAME = :SRCNAME , "); 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(" DEPTCODE = :DEPTCODE "); strSql.Append(" where ID=:ID "); OracleParameter[] parameters = { new OracleParameter(":ID", OracleType.Number, 4), new OracleParameter(":SRCNAME", 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), new OracleParameter(":DEPTCODE", OracleType.Number, 4) }; parameters[9].Value = model.ID; parameters[10].Value = model.SRCNAME; parameters[11].Value = model.EXTENSION; parameters[12].Value = model.SERVERNAME; parameters[13].Value = model.SERVERPATH; parameters[14].Value = model.UPTIME; parameters[15].Value = model.STATUS; parameters[16].Value = model.UPAUTHOR; parameters[17].Value = model.DEPTCODE; int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private string UploadAnnex() { string resultAnnex = ""; BLL.BASE_ANNEX bllAnnex = new BLL.BASE_ANNEX(); for (int index = 0; index < Request.Files.Count; index++) { if (!string.IsNullOrEmpty(Request.Files[index].FileName)) { Entity.BASE_ANNEX annex = new Entity.BASE_ANNEX(); annex.SERVERNAME = Guid.NewGuid().ToString(); //服务器存储文件名 annex.SRCNAME = Path.GetFileName(Request.Files[index].FileName); //原文件名称 annex.EXTENSION = Path.GetExtension(Request.Files[index].FileName); //文件扩展名 annex.STATUS = 0; //存储状态:0正常 annex.UPAUTHOR = userSession.USERID; //上传者用户ID annex.DEPTCODE = userSession.DEPTID; //部门编号 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); //加入数据库 decimal id = bllAnnex.Add(annex); //公文附件示例:12,56,87,96,56 resultAnnex += id.ToString() + ","; } } return(resultAnnex); }
public void Update(Entity.BASE_ANNEX model) { }