public DataTable ListMerchantInfo() { SqlConnection objConn = DBHelpers.ConnectDb(ref errMsg); string strSQL = ""; strSQL = "\r\n Select MerchantID, MerchantCode,MerchantName " + "\r\n From merchant_profile " + "\r\n Where Deleted=0 " + "\r\n Order by MerchantName ASC ;"; DataTable dt = DBHelpers.List(strSQL, objConn); objConn.Close(); return(dt); }
public DataTable TicketInfo() { SqlConnection objConn = DBHelpers.ConnectDb(ref errMsg); string strSQL = ""; strSQL = "\r\n Select t.*,m.MerchantName,b.BrandName,c.ProductLevelName From ticket_info t " + "\r\n left join merchant_profile m on t.MerchantID = m.MerchantID " + "\r\n left join brand_profile b on t.BrandID = b.BrandID " + "\r\n left join productlevel c on t.ShopID = c.ProductLevelID " + "\r\n Order By t.TicketID DESC "; DataTable dt = DBHelpers.List(strSQL, objConn); objConn.Close(); return(dt); }
public DataTable ListShopInfo(int id) { //id=BrandID SqlConnection objConn = DBHelpers.ConnectDb(ref errMsg); string strSQL = ""; strSQL = "\r\n Select MerchantID,BrandID,ProductLevelID,ProductLevelCode,ProductLevelName From productlevel " + "\r\n where Deleted=0"; if (id > 0) { strSQL += " and BrandID=" + id; } strSQL += "\r\n Order by ProductLevelName ASC "; DataTable dt = DBHelpers.List(strSQL, objConn); objConn.Close(); return(dt); }
public DataTable ListBrandInfo(int id) { //id=MerchantID SqlConnection objConn = DBHelpers.ConnectDb(ref errMsg); string strSQL = ""; strSQL = "\r\n Select BrandID, MerchantID, BrandName ,BrandCode " + "\r\n From brand_profile " + "\r\n Where Deleted = 0 "; if (id > 0) { strSQL += "and MerchantID =" + id; } strSQL += "\r\n Order by BrandName ASC "; DataTable dt = DBHelpers.List(strSQL, objConn); objConn.Close(); return(dt); }