TG.WXCRM.V4/DAL/Soft/Soft_Customer_DAL.cs

using System.Collections.Generic;
using System.Data;
using System.Data.OracleClient;

namespace WX.CRM.DAL.Soft
{
    public class Soft_Customer_DAL
    {
        public void setSoftCustomerSalerId()
        {

            try
            {
                OracleHelper.ExecuteNonQuery(CommandType.StoredProcedure, "PACK_SOFT_CUSTOMER.GetUserIdByResIds");
            }
            catch { throw; }

        }
        public void ComputeSoftCustomer(decimal impid)
        {

            try
            {
                var param = new List<OracleParameter>
                {
                    new OracleParameter() { ParameterName = "v_importid", OracleType = OracleType.Number, Value =impid }
                };
                OracleHelper.ExecuteNonQuery(CommandType.StoredProcedure, "PACK_SOFT_CUSTOMER.ComputeSoftCustomer", param.ToArray()); ;
            }
            catch { throw; }

        }
        public void ListOfSoftSalerCommit(decimal saleruserid, decimal opuserid, int count)
        {
            try
            {
                var param = new List<OracleParameter>
                {
                    new OracleParameter() { ParameterName = "p_userid", OracleType = OracleType.Number, Value =saleruserid },
                    new OracleParameter() { ParameterName = "p_opuserid", OracleType = OracleType.Number, Value =opuserid },
                    new OracleParameter() { ParameterName = "p_count", OracleType = OracleType.Int32, Value =count }
                };
                OracleHelper.ExecuteNonQuery(CommandType.StoredProcedure, "PACK_SOFT_CUSTOMER.ListOfSoftSalerCommit", param.ToArray()); ;
            }
            catch { throw; }
        }
    }
}