/**
*
*/
package coolbuy360.logic;
import java.util.List;
import java.util.Map;
import android.content.Context;
import coolbuy360.service.CommandResult;
/**
* ҩ���ѯ
* @author yangxc
*/
public class DrugStore {
/**
* ���Ҹ�����ҩ�꣬��ҳ���ң�������ֵ��DrugStoreID��DrugStoreName��Tel��Mobile��IsTel��IsDoor��IsCOD��
* IsHC��Is24Hour��IsMember��LongValue��LatValue��Address��distance�����м�ֵСд��
* @param distance �������뷶Χ����λ�����
* @param currentLat ��ǰλ��γ����
* @param currentLong ��ǰλ�þ�����
* @param isHC �Ƿ�ҽ��ָ��ҩ��ɸѡ������-1��ʾ���ޣ�0��ʾ��1��ʾ��
* @param pageSize ÿҳ������0��ʾ��ϵͳĬ��ֵ
* @param pageIndex ҳ�룬0��ʾ����ҳ
* @return
*/
public static List<Map<String,String>> getList(double distance,
double currentLat, double currentLong, int isHC, int pageSize, int pageIndex)
{
String strQL = ConstantsSetting.QLDrugStores;
String tisHC = " and DST_Info.IsHC=";
if(isHC==-1)
strQL = String.format(strQL, currentLat, currentLong, distance, "");
else
strQL = String.format(strQL, currentLat, currentLong, distance, tisHC + isHC + "");
return ConstantsSetting.qLGetList(pageSize, pageIndex, strQL, null);
}
/**
* ��ͼģʽ���Ҹ�����ҩ�꣬������ֵ��DrugStoreID��DrugStoreName��LongValue��LatValue��distance�����м�ֵСд��
* @param distance �������뷶Χ����λ�����
* @param currentLat ��ǰλ��γ����
* @param currentLong ��ǰλ�þ�����
* @param isHC �Ƿ�ҽ��ָ��ҩ��ɸѡ������-1��ʾ���ޣ�0��ʾ��1��ʾ��
* @param pageSize ÿҳ������0��ʾ��ϵͳĬ��ֵ
* @param pageIndex ҳ�룬0��ʾ����ҳ
* @return
*/
public static List<Map<String,String>> getListMapMode(double distance,
double currentLat, double currentLong, int isHC, int pageSize, int pageIndex)
{
String strQL = ConstantsSetting.QLDrugStoresMapMode;
String tisHC = " and DST_Info.IsHC=";
if(isHC==-1)
strQL = String.format(strQL, currentLat, currentLong, distance, "");
else
strQL = String.format(strQL, currentLat, currentLong, distance, tisHC + isHC + "");
return ConstantsSetting.qLGetList(pageSize, pageIndex, strQL, null);
}
/**
* ����ȫ�ǵ�ҩ�꣬��ҳ���ң�������ֵ��DrugStoreID��DrugStoreName��Tel��Mobile��IsTel��IsDoor��IsCOD��
* IsHC��Is24Hour��IsMember��LongValue��LatValue��Address��distance�����м�ֵСд��
* @param cityName ��������
* @param currentLat ��ǰλ��γ����
* @param currentLong ��ǰλ�þ�����
* @param isHC �Ƿ�ҽ��ָ��ҩ��ɸѡ������-1��ʾ���ޣ�0��ʾ��1��ʾ��
* @param pageSize ÿҳ������0��ʾ��ϵͳĬ��ֵ
* @param pageIndex ҳ�룬0��ʾ����ҳ
* @return
*/
public static List<Map<String,String>> getList(String cityName,
double currentLat, double currentLong, int isHC, int pageSize, int pageIndex)
{
String strQL = ConstantsSetting.QLDrugStoresInCity;
String tisHC = " and DST_Info.IsHC=";
if(isHC==-1)
strQL = String.format(strQL, currentLat, currentLong, cityName, "");
else
strQL = String.format(strQL, currentLat, currentLong, cityName, tisHC + isHC + "");
return ConstantsSetting.qLGetList(pageSize, pageIndex, strQL, null);
}
/**
* ��ͼģʽ����ȫ�ǵ�ҩ�꣬������ֵ��DrugStoreID��DrugStoreName��LongValue��LatValue��distance�����м�ֵСд��
* @param cityName ��������
* @param currentLat ��ǰλ��γ����
* @param currentLong ��ǰλ�þ�����
* @param isHC �Ƿ�ҽ��ָ��ҩ��ɸѡ������-1��ʾ���ޣ�0��ʾ��1��ʾ��
* @param pageSize ÿҳ������0��ʾ��ϵͳĬ��ֵ
* @param pageIndex ҳ�룬0��ʾ����ҳ
* @return
*/
public static List<Map<String,String>> getListMapMode(String cityName,
double currentLat, double currentLong, int isHC, int pageSize, int pageIndex)
{
String strQL = ConstantsSetting.QLDrugStoresInCityMapMode;
String tisHC = " and DST_Info.IsHC=";
if(isHC==-1)
strQL = String.format(strQL, currentLat, currentLong, cityName, "");
else
strQL = String.format(strQL, currentLat, currentLong, cityName, tisHC + isHC + "");
return ConstantsSetting.qLGetList(pageSize, pageIndex, strQL, null);
}
/**
* ����ҩ��ID��ѯҩ����ϸ��Ϣ������һ����¼��������ֵ��DrugStoreID��DrugStoreName��Tel��Mobile��IsTel��IsDoor��IsCOD��
* IsHC��Is24Hour��IsMember��LongValue��LatValue��Address��distance��OldPrice��NowPrice��Intro��Logo��BusinessTime��
* DoorContent��OtherService��FullAddress�����м�ֵСд��
* @param currentLat ��ǰλ��γ����
* @param currentLong ��ǰλ�þ�����
* @param drugStoreID ҩ��ID
* @return
*/
public static List<Map<String,String>> getInfo(double currentLat, double currentLong, String drugStoreID)
{
String strQL = ConstantsSetting.QLDrugStoreInfoByID;
strQL = String.format(strQL, currentLat, currentLong, drugStoreID);
return ConstantsSetting.qLGetList(0, 0, strQL, null);
}
/**
* �ж�ҩ���Ƿ��Ѿ����ղ�
* @param context
* @param drugStoreID
* @return
*/
public static boolean isCollected(Context context, String drugStoreID)
{
String strQL = ConstantsSetting.QLDrugStoreIsCollected;
String appUserID = User.IsLogged ? User.getMemberAppUserID() : User
.getDevAppUserID(context);
strQL = String.format(strQL, appUserID, drugStoreID);
List<Map<String, String>> result = ConstantsSetting.qLGetList(0, 0,
strQL, null);
if (result != null && result.size() > 0) {
return true;
}
return false;
}
/**
* �ղ�ҩ��
* @param context
* @param drugStoreID
* @return
*/
public static CommandResult doCollect(Context context,String drugStoreID)
{
return DrugStoreFavorite.SetDrugStoreFav(context, drugStoreID, FavOperationType.Add);
}
/**
* ȡ��ҩ���ղ�
* @param context
* @param drugStoreID
* @return
*/
public static CommandResult unCollect(Context context,String drugStoreID)
{
return DrugStoreFavorite.SetDrugStoreFav(context, drugStoreID, FavOperationType.Remove);
}
}