Пример #1
0
 public BillCodeBll(ContextInfo contextInfo, DBInstance _dbInstance) :
     base(contextInfo)
 {
     dbInstance = _dbInstance;
     localDal = new BillCodeDal(dbInstance);
     baseDal = localDal;
 }
Пример #2
0
 public SystemConfigBll(ContextInfo contextInfo,DBInstance dbInstance)
     : base(contextInfo)
 {
     this.dbInstance = dbInstance;
     localDal = new SystemConfigDal(dbInstance);
     baseDal = localDal;
 }
Пример #3
0
        public static DataSet CallStoredProcedure(DBInstance dbInstance, string _Sql, ParameterItem[] _inParameters, ParameterItem[] _outParameters)
        {
            List<SqlParameter> parameters = new List<SqlParameter>();
            try
            {

                if (_inParameters != null)
                {
                    foreach (ParameterItem item in _inParameters)
                    {
                        if (item != null)
                        {
                            if (item.ParameterName != null && item.ParameterValue != null)
                            {
                                SqlParameter parm = new SqlParameter(item.ParameterName, SqlDbType.VarChar);
                                parm.Direction = ParameterDirection.Input;
                                parm.Value = item.ParameterValue;
                                parameters.Add(parm);
                            }
                        }
                    }
                }

                if (_outParameters != null)
                {
                    foreach (ParameterItem item in _outParameters)
                    {
                        if (item != null)
                        {
                            if (item.ParameterName != null)
                            {
                                SqlParameter parm = new SqlParameter(item.ParameterName, SqlDbType.VarChar);//�д�
                                parm.Direction = ParameterDirection.Output;
                                parameters.Add(parm);
                            }
                        }
                    }
                }

                DataSet ds = SqlHelper.ExecuteQuery(dbInstance.Connection.ConnectionString, CommandType.StoredProcedure, _Sql, parameters.ToArray());
                return ds;

            }
            catch (UtilException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw new UtilException(ex.Message, ex);
            }
        }
Пример #4
0
        public static int ExecuteNonQuery(DBInstance db, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
        {
            // Create a new Oracle command
            SqlCommand cmd = new SqlCommand();
            SqlConnection connection = db.Connection;
            //Prepare the command
            PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);

            //Execute the command
            int val = cmd.ExecuteNonQuery();
            cmd.Parameters.Clear();
            return val;
        }
Пример #5
0
 public PricingDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #6
0
 public WorkGroupDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #7
0
 public BillCodeRuleDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #8
0
 public ReasonCategoryDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #9
0
 public EmployeeDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #10
0
 public CustOrderHistoryBll(DBInstance _dbInstance, ContextInfo contextInfo)
     : base(contextInfo)
 {
     dbInstance = _dbInstance;
     baseDal = new CustOrderHistoryDal(dbInstance);
 }
Пример #11
0
 public ShippingDtlCtnDal(DBInstance dbi)
     : base(dbi)
 {
     this.TableName = "tinpshippingdtlctn";
 }
Пример #12
0
 public WOTypeDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #13
0
 public ScheduleDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #14
0
 public AppInfoDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #15
0
 public AssyBoxDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #16
0
 public RepairStockDal(DBInstance dbi)
     : base(dbi)
 {
     this.TableName = "tinprepairstock";
 }
Пример #17
0
 public ReceivingDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #18
0
 public UnpackingDtlDal(DBInstance dbi)
     : base(dbi)
 {
     this.TableName = "tinpunpackingdtl";
 }
Пример #19
0
 public AttributeValueBll(ContextInfo contextInfo, DBInstance dbInstance)
     : base(contextInfo)
 {
     localDal = new AttributeValueDal(dbInstance);
     baseDal = localDal;
 }
Пример #20
0
 public UserDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #21
0
 public FunctionsDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #22
0
 public IPControlDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #23
0
 public SessionDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #24
0
 public StockDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #25
0
 public ExchangeDal(DBInstance dbi)
     : base(dbi)
 {
     this.TableName = "tmdlexchange";
 }
Пример #26
0
 public CustomerDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #27
0
 public RequestPayDal(DBInstance dbi)
     : base(dbi)
 {
     this.TableName = "tinprequestpay";
 }
Пример #28
0
 public SystemConfigDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #29
0
 public LocationDal(DBInstance dbi)
     : base(dbi)
 {
 }
Пример #30
0
 public StaticValueDal(DBInstance dbi)
     : base(dbi)
 {
 }