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);
}
