コード例 #1
0
        /// <summary>
        /// Gets a collection of OutgoingSMS objects by a BillingItem object.
        /// </summary>
        /// <param name="billingItem">billingItem</param>
        /// <param name="startRowIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="totalRows"></param>
        /// <returns>A collection OutgoingSMS objects.</returns>
        public static EntityList<OutgoingSMS> GetOutgoingSMsBybillingitem_(BillingItem @billingitem_, long startRowIndex, int pageSize, out long totalRows)
        {
            string commandText = @"
            FROM
            [dbo].[OutgoingSMS]
            WHERE
            [OutgoingSMS].[billingitem_id] = @billingitem_id ";

            List<SqlParameter> parameters = new List<SqlParameter>();

            parameters.Add(new SqlParameter("@billingitem_id", @billingitem_.billingitem_id));

            return GetList<OutgoingSMS>(SelectFieldList, commandText, parameters, null, startRowIndex, pageSize, out totalRows);
        }
コード例 #2
0
        /// <summary>
        /// Deletes OutgoingSMS objects by a BillingItem object.
        /// </summary>
        /// <param name="billingItem">billingItem</param>
        public static void DeleteOutgoingSMsBybillingitem_(BillingItem billingItem)
        {
            string commandText = "OutgoingSMSDeleteByBillingItem";

            System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
            parameters.Add(new SqlParameter("@billingitem_id", billingItem.billingitem_id));

            using (SqlHelper helper = new SqlHelper())
            {
                helper.Execute(commandText, CommandType.StoredProcedure, parameters);
            }
        }
コード例 #3
0
        /// <summary>
        /// Gets a collection of OutgoingSMS objects by a BillingItem object.
        /// </summary>
        /// <param name="billingitem_">billingitem_</param>
        /// <returns>A collection OutgoingSMS objects.</returns>
        public static EntityList<OutgoingSMS> GetOutgoingSMsBybillingitem_(BillingItem @billingitem_)
        {
            string commandText = "OutgoingSMSGetByBillingItem";

            List<SqlParameter> parameters = new List<SqlParameter>();
            parameters.Add(new SqlParameter("@billingitem_id", @billingitem_.billingitem_id));

            return GetList<OutgoingSMS>(@billingitem_, commandText, parameters);
        }
コード例 #4
0
        /// <summary>
        /// Create a new OutgoingSMS object from a BillingItem object.
        /// </summary>
        /// <param name="billingitem_">billingitem_</param>
        /// <returns>The newly created OutgoingSMS object.</returns>
        public static OutgoingSMS CreateOutgoingSMSBybillingitem_(BillingItem @billingitem_)
        {
            OutgoingSMS outgoingSMS = InitializeNew<OutgoingSMS>();

            outgoingSMS.billingitem_id = @billingitem_.billingitem_id;

            outgoingSMS.billingitem_ = @billingitem_;

            return outgoingSMS;
        }