public ProductAttrValueInfo GetProductAttrValueInfo(string _proID,int _attrID)
{
ProductAttrValueInfo productAttrValueInfo = null;
StringBuilder sql= new StringBuilder();
sql.Append("SELECT * FROM");
sql.Append(" [Tbl_ProductAttrValue]");
sql.Append(" WHERE");
sql.Append(" [ProID]=@ProID");
sql.Append(" AND");
sql.Append(" [AttrID]=@AttrID");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@ProID",_proID),
dbhelper.CreateParameter("@AttrID",_attrID)
};
using(IDataReader reader=dbhelper.ExecuteReader(sql.ToString(),p_Parms))
{
if(reader.Read())
{
productAttrValueInfo = ProductAttrValueInfo.SetValue(reader);
}
}
}
return productAttrValueInfo;
}
public PriceLevelInfo GetPriceLevelInfo(int _id)
{
PriceLevelInfo priceLevelInfo = null;
StringBuilder sql= new StringBuilder();
sql.Append("SELECT * FROM");
sql.Append(" [Tbl_PriceLevel]");
sql.Append(" WHERE");
sql.Append(" [ID]=@ID");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@ID",_id)
};
using(IDataReader reader=dbhelper.ExecuteReader(sql.ToString(),p_Parms))
{
if(reader.Read())
{
priceLevelInfo = PriceLevelInfo.SetValue(reader);
}
}
}
return priceLevelInfo;
}
public AutoNumInfo GetAutoNumInfo(int _keyID)
{
AutoNumInfo autoNumInfo = null;
StringBuilder sql= new StringBuilder();
sql.Append("SELECT * FROM");
sql.Append(" [AutoNum]");
sql.Append(" WHERE");
sql.Append(" [KeyID]=@KeyID");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@KeyID",_keyID)
};
using(IDataReader reader=dbhelper.ExecuteReader(sql.ToString(),p_Parms))
{
if(reader.Read())
{
autoNumInfo = AutoNumInfo.SetValue(reader);
}
}
}
return autoNumInfo;
}
public CustomerInfo GetCustomerInfo(string _customerNO)
{
CustomerInfo customerInfo = null;
StringBuilder sql= new StringBuilder();
sql.Append("SELECT * FROM");
sql.Append(" [Tbl_Customer]");
sql.Append(" WHERE");
sql.Append(" [CustomerNO]=@CustomerNO");
using(NetShopHelper dbhelper=new NetShopHelper())
{
IDbDataParameter[] p_Parms = new IDbDataParameter[]{
dbhelper.CreateParameter("@CustomerNO",_customerNO)
};
using(IDataReader reader=dbhelper.ExecuteReader(sql.ToString(),p_Parms))
{
if(reader.Read())
{
customerInfo = CustomerInfo.SetValue(reader);
}
}
}
return customerInfo;
}