protected void btnSubmit_Click(object sender, EventArgs e)
{
Entity.BASE_ARTICLE model = new Entity.BASE_ARTICLE();
model = GetModel();
if (CheckModel(model))
{
//上传附件
model = UpLoadAnnex(model);
//reply
bll.Add(model);
//短信提醒
if (chkSMSAlert.Checked)
{
//获取发文userid的phone
//send ...
}
//跳转到收文页面
Response.Redirect("~/ManageCenter/Official/Accept.aspx", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//告诉表单如何格式化文件信息
Page.Form.Enctype = "multipart/form-data";
//init session
if (Session["user"] != null)
{
userSession = (Utility.UserSession)Session["user"];
}
//get send id
if (Request.QueryString["id"] != null)
{
srcModel = bll.GetEntity(Convert.ToInt32(Request.QueryString["id"]));
txtTitle.Text = srcModel.TITLE + "的回复";
txtContent.Text = string.Format("<p></p><p>引用“{0}”</p>", srcModel.CONTENT);
hidSrcCode.Value = srcModel.ID.ToString();
hnkSourceTitle.Text = srcModel.TITLE;
hnkSourceTitle.NavigateUrl = string.Format("~/ManageCenter/Official/Detail.aspx?id={0}",
srcModel.ID.ToString());
}
}
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);
}
//更新公文
private void Update(Entity.BASE_ARTICLE model)
{
/*
* 说明:发送到单位不能更改，附件不更改。
*/
bll.Update(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_ARTICLE GetEntity(int ArticleID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ArticleID, Title, Detail, SendTime, Media, Author, ClickNum, CommentNum, Url, ExtractionTime, Score ");
strSql.Append(" from Base_Article ");
strSql.Append(" where ArticleID=@ArticleID");
SqlParameter[] parameters =
{
new SqlParameter("@ArticleID", SqlDbType.Int, 4)
};
parameters[0].Value = ArticleID;
Entity.BASE_ARTICLE entity = new Entity.BASE_ARTICLE();
DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ArticleID"].ToString() != "")
{
entity.ArticleID = int.Parse(ds.Tables[0].Rows[0]["ArticleID"].ToString());
}
entity.Title = ds.Tables[0].Rows[0]["Title"].ToString();
entity.Detail = ds.Tables[0].Rows[0]["Detail"].ToString();
if (ds.Tables[0].Rows[0]["SendTime"].ToString() != "")
{
entity.SendTime = DateTime.Parse(ds.Tables[0].Rows[0]["SendTime"].ToString());
}
entity.Media = ds.Tables[0].Rows[0]["Media"].ToString();
entity.Author = ds.Tables[0].Rows[0]["Author"].ToString();
if (ds.Tables[0].Rows[0]["ClickNum"].ToString() != "")
{
entity.ClickNum = int.Parse(ds.Tables[0].Rows[0]["ClickNum"].ToString());
}
if (ds.Tables[0].Rows[0]["CommentNum"].ToString() != "")
{
entity.CommentNum = int.Parse(ds.Tables[0].Rows[0]["CommentNum"].ToString());
}
entity.Url = ds.Tables[0].Rows[0]["Url"].ToString();
if (ds.Tables[0].Rows[0]["ExtractionTime"].ToString() != "")
{
entity.ExtractionTime = DateTime.Parse(ds.Tables[0].Rows[0]["ExtractionTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Score"].ToString() != "")
{
entity.Score = decimal.Parse(ds.Tables[0].Rows[0]["Score"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_ARTICLE entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Base_Article set ");
strSql.Append(" Title = @Title , ");
strSql.Append(" Detail = @Detail , ");
strSql.Append(" SendTime = @SendTime , ");
strSql.Append(" Media = @Media , ");
strSql.Append(" Author = @Author , ");
strSql.Append(" ClickNum = @ClickNum , ");
strSql.Append(" CommentNum = @CommentNum , ");
strSql.Append(" Url = @Url , ");
strSql.Append(" ExtractionTime = @ExtractionTime , ");
strSql.Append(" Score = @Score ");
strSql.Append(" where ArticleID=@ArticleID ");
SqlParameter[] parameters =
{
new SqlParameter("@ArticleID", SqlDbType.Int, 4),
new SqlParameter("@Title", SqlDbType.VarChar, 200),
new SqlParameter("@Detail", SqlDbType.VarChar, 8000),
new SqlParameter("@SendTime", SqlDbType.DateTime),
new SqlParameter("@Media", SqlDbType.VarChar, 50),
new SqlParameter("@Author", SqlDbType.VarChar, 50),
new SqlParameter("@ClickNum", SqlDbType.Int, 4),
new SqlParameter("@CommentNum", SqlDbType.Int, 4),
new SqlParameter("@Url", SqlDbType.VarChar, 1024),
new SqlParameter("@ExtractionTime", SqlDbType.DateTime),
new SqlParameter("@Score", SqlDbType.Float, 8)
};
parameters[10].Value = entity.ArticleID;
parameters[11].Value = entity.Title;
parameters[12].Value = entity.Detail;
parameters[13].Value = entity.SendTime;
parameters[14].Value = entity.Media;
parameters[15].Value = entity.Author;
parameters[16].Value = entity.ClickNum;
parameters[17].Value = entity.CommentNum;
parameters[18].Value = entity.Url;
parameters[19].Value = entity.ExtractionTime;
parameters[20].Value = entity.Score;
int rows = SqlServerHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//添加公文
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 int Add(Entity.BASE_ARTICLE entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Base_Article(");
strSql.Append("Title,Detail,SendTime,Media,Author,ClickNum,CommentNum,Url,ExtractionTime,Score");
strSql.Append(") values (");
strSql.Append("@Title,@Detail,@SendTime,@Media,@Author,@ClickNum,@CommentNum,@Url,@ExtractionTime,@Score");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Title", SqlDbType.VarChar, 200),
new SqlParameter("@Detail", SqlDbType.Text),
new SqlParameter("@SendTime", SqlDbType.DateTime),
new SqlParameter("@Media", SqlDbType.VarChar, 50),
new SqlParameter("@Author", SqlDbType.VarChar, 50),
new SqlParameter("@ClickNum", SqlDbType.Int, 4),
new SqlParameter("@CommentNum", SqlDbType.Int, 4),
new SqlParameter("@Url", SqlDbType.VarChar, 1024),
new SqlParameter("@ExtractionTime", SqlDbType.DateTime),
new SqlParameter("@Score", SqlDbType.Float, 8)
};
parameters[0].Value = entity.Title;
parameters[1].Value = entity.Detail;
parameters[2].Value = entity.SendTime;
parameters[3].Value = entity.Media;
parameters[4].Value = entity.Author;
parameters[5].Value = entity.ClickNum;
parameters[6].Value = entity.CommentNum;
parameters[7].Value = entity.Url;
parameters[8].Value = entity.ExtractionTime;
parameters[9].Value = entity.Score;
object obj = SqlServerHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private Entity.BASE_ARTICLE GetModel()
{
Entity.BASE_ARTICLE model = new Entity.BASE_ARTICLE();
model.ANNEX = "";
model.CONTENT = txtContent.Text.Trim();
model.DEPTID = userSession.DEPTID;
model.ISREPLY = 1;
model.PARENTID = srcModel.ID;
model.SCORE = 0;
model.SENDCODE = srcModel.SENDCODE;
model.STATUS = 0;
model.TIMESTAMP = DateTime.Now;
model.TITLE = txtTitle.Text.Trim();
model.TYPEID = 0;
model.USERID = userSession.USERID;
return(model);
}
//页面加载
protected void Page_Load(object sender, EventArgs e)
{
//获取用户Session
userSession = (Utility.UserSession)Session["user"];
if (!IsPostBack)
{
if (Request.QueryString["id"] != null)
{
sendId = Convert.ToInt32(Request.QueryString["id"]);
}
//获取发文实体
model = bll.GetEntity(sendId);
//绑定回文列表数据
BindingReplyList();
}
}
//设置实体
private void SetEntity(Entity.BASE_ARTICLE model)
{
if (model != null)
{
txtContent.Text = model.CONTENT; //内容
chkIsReply.Checked = model.ISREPLY.ToString().Equals("0") ? true : false; //允许回复
txtSCORE.Text = model.SCORE.ToString(); //分值
txtSendCode.Text = model.SENDCODE; //发文字号
txtTitle.Text = model.TITLE; //标题
ddlTypeId.SelectedValue = model.TYPEID.ToString(); //公文类别
hidPrimary.Value = model.ID.ToString(); //主键
hidParentPrimary.Value = model.PARENTID.ToString(); //父发文编号
//ddlStatus.SelectedValue = model.STATUS.ToString(); //发文状态
//model.TIMESTAMP = DateTime.Now; //时间戳
//model.USERID = userSession.USERID; //用户编号
//model.DEPTID = userSession.Department[0].DEPTID; //部门
//model.ANNEX = ""; //附件
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_ARTICLE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_ARTICLE(");
strSql.Append("ID,STATUS,ISREPLY,TYPEID,SENDCODE,USERID,DEPTID,PARENTID,TITLE,CONTENT,TIMESTAMP,SCORE,ANNEX");
strSql.Append(") values (");
strSql.Append(":ID,:STATUS,:ISREPLY,:TYPEID,:SENDCODE,:USERID,:DEPTID,:PARENTID,:TITLE,:CONTENT,:TIMESTAMP,:SCORE,:ANNEX");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":STATUS", OracleType.Number, 4),
new OracleParameter(":ISREPLY", OracleType.Number, 4),
new OracleParameter(":TYPEID", OracleType.Number, 4),
new OracleParameter(":SENDCODE", OracleType.VarChar, 80),
new OracleParameter(":USERID", OracleType.Number, 4),
new OracleParameter(":DEPTID", OracleType.Number, 4),
new OracleParameter(":PARENTID", OracleType.Number, 4),
new OracleParameter(":TITLE", OracleType.VarChar, 200),
new OracleParameter(":CONTENT", OracleType.VarChar, 4000),
new OracleParameter(":TIMESTAMP", OracleType.DateTime),
new OracleParameter(":SCORE", OracleType.Number, 4),
new OracleParameter(":ANNEX", OracleType.VarChar, 200)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.STATUS;
parameters[2].Value = model.ISREPLY;
parameters[3].Value = model.TYPEID;
parameters[4].Value = model.SENDCODE;
parameters[5].Value = model.USERID;
parameters[6].Value = model.DEPTID;
parameters[7].Value = model.PARENTID;
parameters[8].Value = model.TITLE;
parameters[9].Value = model.CONTENT;
parameters[10].Value = model.TIMESTAMP;
parameters[11].Value = model.SCORE;
parameters[12].Value = model.ANNEX;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
private bool CheckModel(Entity.BASE_ARTICLE model)
{
if (string.IsNullOrWhiteSpace(model.TITLE))
{
litmsg.Visible = true;
litmsg.Text = "<div style='font-size:16px; font-family:微软雅黑; color:red;font-weight:bold; text-align:center;float:left;'>标题不能为空!</div>";
txtTitle.Focus();
return(false);
}
if (string.IsNullOrWhiteSpace(model.CONTENT))
{
litmsg.Visible = true;
litmsg.Text = "<div style='font-size:16px; font-family:微软雅黑; color:red;font-weight:bold; text-align:center;float:left;'>内容不能为空!</div>";
txtContent.Focus();
return(false);
}
return(true);
}
//获取实体
private Entity.BASE_ARTICLE GetEntity()
{
Entity.BASE_ARTICLE model = new Entity.BASE_ARTICLE();
model.CONTENT = txtContent.Text; //内容
model.ISREPLY = chkIsReply.Checked ? 0 : 1; //允许回复
model.SCORE = Convert.ToInt32(txtSCORE.Text); //分值
model.SENDCODE = txtSendCode.Text; //发文字号
//model.STATUS = Convert.ToInt32(ddlStatus.SelectedValue); //发文状态
model.TITLE = txtTitle.Text; //标题
model.TYPEID = Convert.ToInt32(ddlTypeId.SelectedValue); //公文类别
model.PARENTID = 0; //父发文编号
model.TIMESTAMP = DateTime.Now; //时间戳
model.ANNEX = ""; //附件
model.USERID = userSession.USERID; //用户编号
model.DEPTID = userSession.DEPTID; //所属部门
model.ID = Convert.ToInt32(hidPrimary.Value); //主键
model.PARENTID = Convert.ToInt32(hidParentPrimary.Value); //父发文编号
return(model);
}
//页面加载
protected void Page_Load(object sender, EventArgs e)
{
//告诉表单如何格式化文件信息
Page.Form.Enctype = "multipart/form-data";
userSession = (Utility.UserSession)Session["user"];
if (!IsPostBack)
{
BindingType(); //绑定公文分类
BindAcceptUnit(); //绑定收文部门
}
//获取编辑模式ID
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"].ToString());
Entity.BASE_ARTICLE model = new Entity.BASE_ARTICLE();
model = bll.GetEntity(id);
SetEntity(model);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_ARTICLE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_ARTICLE set ");
strSql.Append(" STATUS = :STATUS , ");
strSql.Append(" ISREPLY = :ISREPLY , ");
strSql.Append(" TYPEID = :TYPEID , ");
strSql.Append(" SENDCODE = :SENDCODE , ");
strSql.Append(" USERID = :USERID , ");
strSql.Append(" DEPTID = :DEPTID , ");
strSql.Append(" PARENTID = :PARENTID , ");
strSql.Append(" TITLE = :TITLE , ");
strSql.Append(" CONTENT = :CONTENT , ");
strSql.Append(" TIMESTAMP = :TIMESTAMP , ");
strSql.Append(" SCORE = :SCORE , ");
strSql.Append(" ANNEX = :ANNEX ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":STATUS", OracleType.Number, 4),
new OracleParameter(":ISREPLY", OracleType.Number, 4),
new OracleParameter(":TYPEID", OracleType.Number, 4),
new OracleParameter(":SENDCODE", OracleType.VarChar, 80),
new OracleParameter(":USERID", OracleType.Number, 4),
new OracleParameter(":DEPTID", OracleType.Number, 4),
new OracleParameter(":PARENTID", OracleType.Number, 4),
new OracleParameter(":TITLE", OracleType.VarChar, 200),
new OracleParameter(":CONTENT", OracleType.VarChar, 4000),
new OracleParameter(":TIMESTAMP", OracleType.DateTime),
new OracleParameter(":SCORE", OracleType.Number, 4),
new OracleParameter(":ANNEX", OracleType.VarChar, 200),
new OracleParameter(":ID", OracleType.Number, 4)
};
parameters[0].Value = model.STATUS;
parameters[1].Value = model.ISREPLY;
parameters[2].Value = model.TYPEID;
parameters[3].Value = model.SENDCODE;
parameters[4].Value = model.USERID;
parameters[5].Value = model.DEPTID;
parameters[6].Value = model.PARENTID;
parameters[7].Value = model.TITLE;
parameters[8].Value = model.CONTENT;
parameters[9].Value = model.TIMESTAMP;
parameters[10].Value = model.SCORE;
parameters[11].Value = model.ANNEX;
parameters[12].Value = model.ID;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新公文
/// </summary>
/// <param name="model">公文实体</param>
/// <returns></returns>
public bool Update(Entity.BASE_ARTICLE model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model">实体</param>
public void Add(Entity.BASE_ARTICLE model)
{
dal.Add(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_ARTICLE GetEntity(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, STATUS, ISREPLY, TYPEID, SENDCODE, USERID, DEPTID, PARENTID, TITLE, CONTENT, TIMESTAMP, SCORE, ANNEX ");
strSql.Append(" from BASE_ARTICLE ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4)
};
parameters[0].Value = ID;
Entity.BASE_ARTICLE entity = new Entity.BASE_ARTICLE();
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());
}
if (dt.Rows[0]["STATUS"].ToString() != "")
{
entity.STATUS = decimal.Parse(dt.Rows[0]["STATUS"].ToString());
}
if (dt.Rows[0]["ISREPLY"].ToString() != "")
{
entity.ISREPLY = decimal.Parse(dt.Rows[0]["ISREPLY"].ToString());
}
if (dt.Rows[0]["TYPEID"].ToString() != "")
{
entity.TYPEID = decimal.Parse(dt.Rows[0]["TYPEID"].ToString());
}
entity.SENDCODE = dt.Rows[0]["SENDCODE"].ToString();
if (dt.Rows[0]["USERID"].ToString() != "")
{
entity.USERID = decimal.Parse(dt.Rows[0]["USERID"].ToString());
}
if (dt.Rows[0]["DEPTID"].ToString() != "")
{
entity.DEPTID = decimal.Parse(dt.Rows[0]["DEPTID"].ToString());
}
if (dt.Rows[0]["PARENTID"].ToString() != "")
{
entity.PARENTID = decimal.Parse(dt.Rows[0]["PARENTID"].ToString());
}
entity.TITLE = dt.Rows[0]["TITLE"].ToString();
entity.CONTENT = dt.Rows[0]["CONTENT"].ToString();
if (dt.Rows[0]["TIMESTAMP"].ToString() != "")
{
entity.TIMESTAMP = DateTime.Parse(dt.Rows[0]["TIMESTAMP"].ToString());
}
if (dt.Rows[0]["SCORE"].ToString() != "")
{
entity.SCORE = decimal.Parse(dt.Rows[0]["SCORE"].ToString());
}
entity.ANNEX = dt.Rows[0]["ANNEX"].ToString();
return(entity);
}
else
{
return(null);
}
}
