public BillCodeBll(ContextInfo contextInfo, DBInstance _dbInstance) : base(contextInfo) { dbInstance = _dbInstance; localDal = new BillCodeDal(dbInstance); baseDal = localDal; }
public SystemConfigBll(ContextInfo contextInfo,DBInstance dbInstance) : base(contextInfo) { this.dbInstance = dbInstance; localDal = new SystemConfigDal(dbInstance); baseDal = localDal; }
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); } }
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; }
public PricingDal(DBInstance dbi) : base(dbi) { }
public WorkGroupDal(DBInstance dbi) : base(dbi) { }
public BillCodeRuleDal(DBInstance dbi) : base(dbi) { }
public ReasonCategoryDal(DBInstance dbi) : base(dbi) { }
public EmployeeDal(DBInstance dbi) : base(dbi) { }
public CustOrderHistoryBll(DBInstance _dbInstance, ContextInfo contextInfo) : base(contextInfo) { dbInstance = _dbInstance; baseDal = new CustOrderHistoryDal(dbInstance); }
public ShippingDtlCtnDal(DBInstance dbi) : base(dbi) { this.TableName = "tinpshippingdtlctn"; }
public WOTypeDal(DBInstance dbi) : base(dbi) { }
public ScheduleDal(DBInstance dbi) : base(dbi) { }
public AppInfoDal(DBInstance dbi) : base(dbi) { }
public AssyBoxDal(DBInstance dbi) : base(dbi) { }
public RepairStockDal(DBInstance dbi) : base(dbi) { this.TableName = "tinprepairstock"; }
public ReceivingDal(DBInstance dbi) : base(dbi) { }
public UnpackingDtlDal(DBInstance dbi) : base(dbi) { this.TableName = "tinpunpackingdtl"; }
public AttributeValueBll(ContextInfo contextInfo, DBInstance dbInstance) : base(contextInfo) { localDal = new AttributeValueDal(dbInstance); baseDal = localDal; }
public UserDal(DBInstance dbi) : base(dbi) { }
public FunctionsDal(DBInstance dbi) : base(dbi) { }
public IPControlDal(DBInstance dbi) : base(dbi) { }
public SessionDal(DBInstance dbi) : base(dbi) { }
public StockDal(DBInstance dbi) : base(dbi) { }
public ExchangeDal(DBInstance dbi) : base(dbi) { this.TableName = "tmdlexchange"; }
public CustomerDal(DBInstance dbi) : base(dbi) { }
public RequestPayDal(DBInstance dbi) : base(dbi) { this.TableName = "tinprequestpay"; }
public SystemConfigDal(DBInstance dbi) : base(dbi) { }
public LocationDal(DBInstance dbi) : base(dbi) { }
public StaticValueDal(DBInstance dbi) : base(dbi) { }