/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_ARTICLE_UNIT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_ARTICLE_UNIT(");
strSql.Append("ID,ARTICLEID,DPTCODE,ISREAD,READTIME");
strSql.Append(") values (");
strSql.Append(":ID,:ARTICLEID,:DPTCODE,:ISREAD,:READTIME");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":ARTICLEID", OracleType.Number, 4),
new OracleParameter(":DPTCODE", OracleType.Number, 4),
new OracleParameter(":ISREAD", OracleType.Number, 4),
new OracleParameter(":READTIME", OracleType.DateTime)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.ARTICLEID;
parameters[2].Value = model.DPTCODE;
parameters[3].Value = model.ISREAD;
parameters[4].Value = model.READTIME;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_ARTICLE_UNIT GetEntity(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, ARTICLEID, DPTCODE, ISREAD, READTIME ");
strSql.Append(" from BASE_ARTICLE_UNIT ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4)
};
parameters[0].Value = ID;
Entity.BASE_ARTICLE_UNIT entity = new Entity.BASE_ARTICLE_UNIT();
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]["ARTICLEID"].ToString() != "")
{
entity.ARTICLEID = decimal.Parse(dt.Rows[0]["ARTICLEID"].ToString());
}
if (dt.Rows[0]["DPTCODE"].ToString() != "")
{
entity.DPTCODE = decimal.Parse(dt.Rows[0]["DPTCODE"].ToString());
}
if (dt.Rows[0]["ISREAD"].ToString() != "")
{
entity.ISREAD = decimal.Parse(dt.Rows[0]["ISREAD"].ToString());
}
if (dt.Rows[0]["READTIME"].ToString() != "")
{
entity.READTIME = DateTime.Parse(dt.Rows[0]["READTIME"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_ARTICLE_UNIT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_ARTICLE_UNIT set ");
strSql.Append(" ID = :ID , ");
strSql.Append(" ARTICLEID = :ARTICLEID , ");
strSql.Append(" DPTCODE = :DPTCODE , ");
strSql.Append(" ISREAD = :ISREAD , ");
strSql.Append(" READTIME = :READTIME ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.Number, 4),
new OracleParameter(":ARTICLEID", OracleType.Number, 4),
new OracleParameter(":DPTCODE", OracleType.Number, 4),
new OracleParameter(":ISREAD", OracleType.Number, 4),
new OracleParameter(":READTIME", OracleType.DateTime)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.ARTICLEID;
parameters[2].Value = model.DPTCODE;
parameters[3].Value = model.ISREAD;
parameters[4].Value = model.READTIME;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//遍历每一个部门节点(增加公文收文单位)
private void RecursiveSubNode(TreeNode node, int articleId)
{
if (node.Checked)
{
BLL.BASE_ARTICLE_UNIT unitBll = new BLL.BASE_ARTICLE_UNIT();
Entity.BASE_ARTICLE_UNIT unitmodel = new Entity.BASE_ARTICLE_UNIT();
unitmodel.ARTICLEID = articleId;
unitmodel.DPTCODE = Convert.ToInt32(node.Value);
unitmodel.ISREAD = 0; //未查阅
unitmodel.READTIME = DateTime.Now; //发文时间
unitBll.Add(unitmodel);
/*短信通知*/
if (chkSMSAlert.Checked)
{
//给该部门负责人发送短信通知
}
}
foreach (TreeNode subNode in node.ChildNodes)
{
RecursiveSubNode(subNode, articleId);
}
}
public void Add(Entity.BASE_ARTICLE_UNIT model)
{
dal.Add(model);
}
