public List <AdProduct> GetAdProListByAdID(int AdvertiseID)
{
Func <SqlConnection, List <AdProduct> > action = (connection) => DALAdvertise.GetAdProListByAdID(connection, AdvertiseID);
return(dbManager.Execute(action));
}
public Advertise GetAdvertiseByID(int id)
{
Func <SqlConnection, Advertise> action = (connection) => DALAdvertise.GetAdvertiseByID(connection, id);
return(dbManager.Execute(action));
}
public bool IsExistsxAdColumnID(string AdColumnID)
{
Func <SqlConnection, bool> action = (connection) => DALAdvertise.IsExistsxAdColumnID(connection, AdColumnID);
return(dbManager.Execute(action));
}
public void DeleteAdvertise(int id)
{
Action <SqlConnection> action = (connection) => DALAdvertise.DeleteAdvertise(connection, id);
dbManager.Execute(action);
}
public void UpdateAdvertise(Advertise advertise)
{
Action <SqlConnection> action = (connection) => DALAdvertise.UpdateAdvertise(connection, advertise);
dbManager.Execute(action);
}
/// <summary>
/// 新版本 通过产品id获取产品信息
/// </summary>
/// <param name="PID"></param>
/// <returns></returns>
public DataTable GetProductInfoByPIdNewVersion(string PID)
{
Func <SqlConnection, DataTable> action = (connection) => DALAdvertise.GetProductInfoByPIdNewVersion(connection, PID);
return(dbManager.Execute(action));
}
public List <Advertise> GetSuppliesModule()
{
Func <SqlConnection, List <Advertise> > action = (connection) => DALAdvertise.GetAllAdvertise(connection);
return(dbManager.Execute(action));
}
public string GetCateNameByCateID(string CateID)
{
Func <SqlConnection, string> action = (connection) => DALAdvertise.GetCateNameByCateID(connection, CateID);
return(dbManager.Execute(action));
}
public void AddAdProduct(int AdvertiseID, string PID, byte Position, byte State, decimal PromotionPrice, int PromotionNum)
{
Action <SqlConnection> action = (connection) => DALAdvertise.AddAdProduct(connection, AdvertiseID, PID, Position, State, PromotionPrice, PromotionNum);
dbManager.Execute(action);
}
public Dictionary <string, string> GetProductNamesByPids(IEnumerable <string> pids)
{
Func <SqlConnection, Dictionary <string, string> > action = (connection) => DALAdvertise.GetProductNamesByPids(connection, pids);
return(dbManager.Execute(action));
}
public string GetProductNameByPID(string PID)
{
Func <SqlConnection, string> action = (connection) => DALAdvertise.GetProductNameByPID(connection, PID);
return(dbManager.Execute(action));
}
public void ChangeState(int AdvertiseID, string PID, byte State)
{
Action <SqlConnection> action = (connection) => DALAdvertise.ChangeState(connection, AdvertiseID, PID, State);
dbManager.Execute(action);
}
public void DeleteAdProduct(int AdvertiseID, string PID)
{
Action <SqlConnection> action = (connection) => DALAdvertise.DeleteAdProduct(connection, AdvertiseID, PID);
dbManager.Execute(action);
}
public string GetCountByAdID(int AdvertiseID)
{
Func <SqlConnection, string> action = (connection) => DALAdvertise.GetCountByAdID(connection, AdvertiseID);
return(dbManager.Execute(action));
}
