public string GetOrderBySql(string vipNo)
{
var sql = @"select c_chdh,c_quantity,c_ShopName,c_VipId,c_Total,c_TotalVip,c_Date from h_chtj where";
if (!string.IsNullOrEmpty(vipNo))
{
sql += " c_VIPID=" + vipNo;
}
var list = dal.SqlQuery <h_chtjWX>(sql);
return(JsonConvert.SerializeObject(list));
}
public string GetCityListBySql(string keyword)
{
string sql = @"select * from City where 1=1";
if (!string.IsNullOrEmpty(keyword))
{
sql += " and CityNo like '%" + keyword + "%' or CityName like '%" + keyword + "%' or ProvinceNo like '%" + keyword + "%'";
}
var list = dal.SqlQuery <City>(sql);
return(JsonConvert.SerializeObject(list));
}
public string GetSaleListBySql(string id)
{
var sql = @"select * from h_ch where";
if (!string.IsNullOrEmpty(id))
{
sql += " (c_ID='" + id + "')";
}
var list = dal.SqlQuery <h_ch>(sql);
return(JsonConvert.SerializeObject(list));
}
public string GetSaleListBySql(string aaa)
{
BaseOption <h_ch> bs = new BaseOption <h_ch>();
CommDAL dal = new CommDAL();
var sql = @"select c_chdh,c_name,c_num from h_ch where";
if (!string.IsNullOrEmpty(aaa))
{
sql += " c_VIPID=" + aaa;
}
var list = dal.SqlQuery <h_ch>(sql);
return(JsonConvert.SerializeObject(list));
}