/// <summary>
/// 查询,关联表,返回字符串,然后在后台分隔
/// </summary>
/// <param name="dishid"></param>
/// <param name="ShopID"></param>
/// <param name="AppID"></param>
/// <returns></returns>
public static string[] getDish_DishTagID(int dishid, int ShopID, int AppID)
{
string sql = "SELECT TagID FROM Dish_DishTags WHERE DishID=@DishID and ShopID=@ShopID and AppID=@AppID";
DbCommand cmd = Db_CanYin.GetSqlStringCommand(Convert.ToString(Sql));
Db_CanYin.AddInParameter(cmd, "@AppID", DbType.Int32, AppID);
Db_CanYin.AddInParameter(cmd, "@ShopID", DbType.Int32, ShopID);
Db_CanYin.AddInParameter(cmd, "@DishID", DbType.Int32, dishid);
return new string[] { "", "" };
//return Convert.ToString(Db_CanYin.ExecuteScalar(cmd));
}
/// 查询,关联表,返回字符串,然后在后台分隔
/// </summary>
/// <param name="dishid"></param>
/// <param name="ShopID"></param>
/// <param name="AppID"></param>
/// <returns></returns>
public static string[] getDish_DishTagID(int dishid, int ShopID, int AppID)
{
string sql = "SELECT TagID FROM Dish_DishTags WHERE DishID=@DishID and ShopID=@ShopID and AppID=@AppID";
DbCommand cmd = Db_CanYin.GetSqlStringCommand(Convert.ToString(Sql));
Db_CanYin.AddInParameter(cmd, "@AppID", DbType.Int32, AppID);
Db_CanYin.AddInParameter(cmd, "@ShopID", DbType.Int32, ShopID);
Db_CanYin.AddInParameter(cmd, "@DishID", DbType.Int32, dishid);
return new string[] { "", "" };
//return Convert.ToString(Db_CanYin.ExecuteScalar(cmd));
}