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)
{
}