public static string GetCoinfo(string id, string area)
{
string sql = string.Format("select top 1 * from sys_product_price where PID='{0}' and AreaName='{1}' order by addtime desc", id, area);
string info = "";
DataTable dt = sqlRep.Query(sql).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
info += dt.Rows[i]["GroupId"].ToString() + ":" + dt.Rows[i]["Price"].ToString() + ",";
}
return(info.TrimEnd(','));
}
public static DataSet SQuery(string sql)
{
return(rep.Query(sql));
}
public DataSet Query(string sql)
{
return(repository.Query(sql));
}