public InternalPriceSetInfo GetInternalPriceSetInfoList(int goodstype, Guid hostingFilialeId)
{
InternalPriceSetInfo internalPriceSetInfoList = new InternalPriceSetInfo();
var sql = @"SELECT [GoodsType] ,[HostingFilialeId] ,[ReserveProfitRatio] FROM [InternalPriceSet]";
if (goodstype != 0)
{
sql = sql + " WHERE GoodsType=" + goodstype + " AND HostingFilialeId = '" + hostingFilialeId + "'";
}
using (var rdr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, sql))
{
while (rdr.Read())
{
internalPriceSetInfoList.GoodsType = rdr["GoodsType"] == DBNull.Value
? 0
: Convert.ToInt32(rdr["GoodsType"].ToString());
internalPriceSetInfoList.HostingFilialeId = rdr["HostingFilialeId"] == DBNull.Value
? Guid.Empty
: new Guid(rdr["HostingFilialeId"].ToString());
internalPriceSetInfoList.ReserveProfitRatio = rdr["ReserveProfitRatio"] == DBNull.Value
? "0.00"
: rdr["ReserveProfitRatio"].ToString();
}
}
return(internalPriceSetInfoList);
}
/// <summary> 获取StorageRecordInfo表信息
/// </summary>
/// <param name="dr">IDataReader</param>
/// <returns></returns>
private static InternalPriceSetInfo ReaderInternalPriceSetInfo(IDataReader dr)
{
var internalPriceSetInfo = new InternalPriceSetInfo
{
GoodsType = dr["GoodsType"] == DBNull.Value ? 0 : Convert.ToInt32(dr["GoodsType"].ToString()),
HostingFilialeId = dr["HostingFilialeId"] == DBNull.Value ? Guid.Empty : new Guid(dr["HostingFilialeId"].ToString()),
ReserveProfitRatio = dr["ReserveProfitRatio"] == DBNull.Value ? "0.00" : dr["ReserveProfitRatio"].ToString()
};
return(internalPriceSetInfo);
}
