Beispiel #1
0
        /// <summary>
        /// 修改公文
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateOfficeDoc(OfficeDoc model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update OA_OfficeDoc set ");
            strSql.Append("Title=@Title,");
            strSql.Append("Contents=@Contents");
            strSql.Append(" where OfficeDocID=@OfficeDocID ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@Title",       SqlDbType.NVarChar, 100),
                new SqlParameter("@Contents",    SqlDbType.Text),
                new SqlParameter("@OfficeDocID", SqlDbType.VarChar, 36)
            };
            parameters[0].Value = model.Title;
            parameters[1].Value = model.Contents;
            parameters[2].Value = model.OfficeDocID;

            int rows = DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Beispiel #2
0
        /// <summary>
        /// 获取我的公文集合
        /// </summary>
        /// <param name="OfficeDocID"></param>
        /// <returns></returns>
        public DataSet GetList(string OfficeDocID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 OfficeDocID,Title,Contents,WriterID,WriteTime,U.UserCode,U.UserName from OA_OfficeDoc Doc ");
            strSql.Append(" left join OA_User U on U.UserID=Doc.WriterID ");
            strSql.Append(" where OfficeDocID=@OfficeDocID ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@OfficeDocID", SqlDbType.VarChar, 36)
            };
            parameters[0].Value = OfficeDocID;

            OfficeDoc model = new OfficeDoc();
            DataSet   ds    = DBAccess.ExecuteDataset(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(ds);
            }
            else
            {
                return(null);
            }
        }
Beispiel #3
0
        /// <summary>
        /// 获取我的公文
        /// </summary>
        /// <param name="OfficeDocID"></param>
        /// <returns></returns>
        public OfficeDoc GetModel(string OfficeDocID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 OfficeDocID,Title,Contents,WriterID,WriteTime from OA_OfficeDoc ");
            strSql.Append(" where OfficeDocID=@OfficeDocID ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@OfficeDocID", SqlDbType.VarChar, 36)
            };
            parameters[0].Value = OfficeDocID;

            OfficeDoc model = new OfficeDoc();
            DataSet   ds    = DBAccess.ExecuteDataset(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["OfficeDocID"] != null && ds.Tables[0].Rows[0]["OfficeDocID"].ToString() != "")
                {
                    model.OfficeDocID = ds.Tables[0].Rows[0]["OfficeDocID"].ToString();
                }
                if (ds.Tables[0].Rows[0]["Title"] != null && ds.Tables[0].Rows[0]["Title"].ToString() != "")
                {
                    model.Title = ds.Tables[0].Rows[0]["Title"].ToString();
                }
                if (ds.Tables[0].Rows[0]["Contents"] != null && ds.Tables[0].Rows[0]["Contents"].ToString() != "")
                {
                    model.Contents = ds.Tables[0].Rows[0]["Contents"].ToString();
                }
                if (ds.Tables[0].Rows[0]["WriterID"] != null && ds.Tables[0].Rows[0]["WriterID"].ToString() != "")
                {
                    model.WriterID = ds.Tables[0].Rows[0]["WriterID"].ToString();
                }
                if (ds.Tables[0].Rows[0]["WriteTime"] != null && ds.Tables[0].Rows[0]["WriteTime"].ToString() != "")
                {
                    model.WriteTime = DateTime.Parse(ds.Tables[0].Rows[0]["WriteTime"].ToString());
                }
                return(model);
            }
            else
            {
                return(null);
            }
        }
Beispiel #4
0
        /// <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);
        }
Beispiel #5
0
 /// <summary>
 /// 修改公文
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public bool UpdateOfficeDoc(OfficeDoc model)
 {
     return(iOfficeDocDAL.UpdateOfficeDoc(model));
 }
Beispiel #6
0
 /// <summary>
 /// 新增公文
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public int AddOfficeDoc(OfficeDoc model, IList <OfficeDocItem> list)
 {
     return(iOfficeDocDAL.AddOfficeDoc(model, list));
 }