Exemplo n.º 1
0
        /// <summary>
        /// 向单据类型(冲红)表中插入记录
        /// </summary>
        /// <param name="docTypeTable">单据类型(冲红)模型</param>
        /// <returns>返回向单据类型(冲红)表中插入记录所影响的行数</returns>
        public static int AddDocTypeTable(DocTypeTableModel docTypeTable)
        {
            SqlParameter[] sparams = new SqlParameter[]
            {
                new SqlParameter("@docTypeName", SqlDbType.VarChar, 20),
                new SqlParameter("@isRubric", SqlDbType.Int),
                new SqlParameter("@docTypeDescr", SqlDbType.VarChar, 500)
            };
            sparams[0].Value = docTypeTable.DocTypeName;
            sparams[1].Value = docTypeTable.IsRubric;
            sparams[2].Value = docTypeTable.DocTypeDescr;

            return(DBHelper.ExecuteNonQuery("AddDocTypeTable", sparams, CommandType.StoredProcedure));
        }
Exemplo n.º 2
0
 /// <summary>
 /// 更新指定单据类型(冲红)表中记录
 /// </summary>
 /// <param name="docTypeTable">单据类型(冲红)模型</param>
 /// <returns>返回更新指定单据类型(冲红)表中记录所影响的行数</returns>
 public static int UpdDocTypeTableByID(DocTypeTableModel docTypeTable)
 {
     return(DocTypeTableDAL.UpdDocTypeTableByID(docTypeTable));
 }
Exemplo n.º 3
0
 /// <summary>
 /// 向单据类型(冲红)表中插入记录
 /// </summary>
 /// <param name="docTypeTable">单据类型(冲红)模型</param>
 /// <returns>返回向单据类型(冲红)表中插入记录所影响的行数</returns>
 public static int AddDocTypeTable(DocTypeTableModel docTypeTable)
 {
     return(DocTypeTableDAL.AddDocTypeTable(docTypeTable));
 }