コード例 #1
0
 /// <summary>
 /// Takes the specified budgetSourceCategory.
 /// </summary>
 /// <param name="estimateDetailStatementPartB">The estimate detail statement part b.</param>
 /// <returns></returns>
 private static object[] Take(EstimateDetailStatementPartBEntity estimateDetailStatementPartB)
 {
     return(new object[]
     {
         "@EstimateDetailStatementPartBID", estimateDetailStatementPartB.EstimateDetailStatementPartBId,
         "@OrderNumber", estimateDetailStatementPartB.OrderNumber,
         "@Description", estimateDetailStatementPartB.Description,
         "@Note", estimateDetailStatementPartB.Note,
         "@Amount", estimateDetailStatementPartB.Amount,
         "@IsActive", estimateDetailStatementPartB.IsActive
     });
 }
コード例 #2
0
        /// <summary>
        /// Updates the estimate detail statement.
        /// </summary>
        /// <param name="estimateDetailStatementPartB">The estimate detail statement part b.</param>
        /// <returns></returns>
        public string UpdateEstimateDetailStatementPartB(EstimateDetailStatementPartBEntity estimateDetailStatementPartB)
        {
            const string sql = @"uspUpdate_EstimateDetailStatementPartB";

            return(Db.Update(sql, true, Take(estimateDetailStatementPartB)));
        }
コード例 #3
0
        /// <summary>
        /// Inserts the estimateDetailStatement.
        /// </summary>
        /// <param name="estimateDetailStatement">The estimateDetailStatement.</param>
        /// <returns></returns>
        public int InsertEstimateDetailStatementPartB(EstimateDetailStatementPartBEntity estimateDetailStatement)
        {
            const string sql = @"uspInsert_EstimateDetailStatementPartB";

            return(Db.Insert(sql, true, Take(estimateDetailStatement)));
        }