/// <summary>
/// 删除公文
/// </summary>
/// <param name="OfficeDocID"></param>
/// <returns></returns>
public int DelOfficeDoc(string OfficeDocID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from OA_OfficeDoc ");
strSql.Append(" where OfficeDocID=@OfficeDocID ");
SqlParameter[] parameters =
{
new SqlParameter("@OfficeDocID", SqlDbType.VarChar, 36)
};
parameters[0].Value = OfficeDocID;
IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString);
try
{
OfficeDocItemDAL itemBll = new OfficeDocItemDAL();
itemBll.DelOfficeDocItem(OfficeDocID);
DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
transaction.Commit();
}
catch
{
transaction.Rollback();
}
return(1);
}
/// <summary>
/// 新增公文
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddOfficeDoc(OfficeDoc model, IList <OfficeDocItem> list)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OA_OfficeDoc(");
strSql.Append("OfficeDocID,Title,Contents,WriterID,WriteTime)");
strSql.Append(" values (");
strSql.Append("@OfficeDocID,@Title,@Contents,@WriterID,@WriteTime)");
SqlParameter[] parameters =
{
new SqlParameter("@OfficeDocID", SqlDbType.VarChar, 36),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@Contents", SqlDbType.Text),
new SqlParameter("@WriterID", SqlDbType.VarChar, 36),
new SqlParameter("@WriteTime", SqlDbType.DateTime)
};
parameters[0].Value = model.OfficeDocID;
parameters[1].Value = model.Title;
parameters[2].Value = model.Contents;
parameters[3].Value = model.WriterID;
parameters[4].Value = model.WriteTime;
IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString);
try
{
DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
OfficeDocItemDAL itemBll = new OfficeDocItemDAL();
for (int i = 0; i < list.Count; i++)
{
OfficeDocItem item = list[i] as OfficeDocItem;
itemBll.AddOfficeDocItem(item);
}
transaction.Commit();
}
catch
{
transaction.Rollback();
}
return(1);
}
