public PromotionBLL()
{
pd = new PromotionDAL();
}
public DataTable GetPromotionList(PromotionDAL whereData)
{
string whereString = "";
if (whereData.LOID != 0)
whereString += (whereString == "" ? "" : "AND ") + "LOID = " + whereData.LOID.ToString() + " ";
if (whereData.CODE.Trim() != "")
whereString += (whereString == "" ? "" : "AND ") + "CODE = '" + OracleDB.QRText(whereData.CODE.Trim()) + "' ";
string sql = "SELECT P.LOID,PD.BARCODE,PD.NAME,PD.UNAME,PI.PRICEOLD,PI.PRICENEW ";
sql += "FROM PROMOTION P INNER JOIN V_PRODUCT_LIST PD ON PD.LOID = P.LOID ";
sql += "INNER JOIN PROMOTIONITEM PI ON P.LOID = PI.PROMOTION ";
sql += (whereString == "" ? "" : "WHERE " + whereString);
sql += "ORDER BY BARCODE ";
return OracleDB.ExecListCmd(sql);
}