public WxMaterial logGetidinfo(string promotetype)
{
using (var helper = new SqlHelper())
{
WxMaterial wxmaterial = new InternalWxMaterial(helper).logGetidinfo(promotetype);
return(wxmaterial);
}
}
public int Delwxmenu(int wxmenuid)
{
using (var helper = new SqlHelper())
{
var id = new InternalWxMaterial(helper).Delwxmenu(wxmenuid);
return(id);
}
}
public WxMaterial Getidinfo(int id)
{
using (var helper = new SqlHelper())
{
WxMaterial wxmaterial = new InternalWxMaterial(helper).Getidinfo(id);
return(wxmaterial);
}
}
public int EditMaterial(WxMaterial material)
{
using (var helper = new SqlHelper())
{
var id = new InternalWxMaterial(helper).EditMaterial(material);
return(id);
}
}
public periodical selectWxsaletype(int Wxsaletype, int comid)
{
using (var helper = new SqlHelper())
{
periodical wxmaterial = new InternalWxMaterial(helper).selectWxsaletype(Wxsaletype, comid);
return(wxmaterial);
}
}
public int DelWxKeyWord(int materialid)
{
using (var helper = new SqlHelper())
{
var id = new InternalWxMaterial(helper).DelWxKeyWord(materialid);
return(id);
}
}
public int Editperiod(periodical model)
{
using (var helper = new SqlHelper())
{
var id = new InternalWxMaterial(helper).Editperiod(model);
return(id);
}
}
/// <summary>
/// 插入Reservation数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int insert_Res(Reservation model)
{
using (var helper = new SqlHelper())
{
var num = new InternalWxMaterial(helper).insert_Res(model);
return(num);
}
}
public int SortMaterial(string materialid, int sortid)
{
using (var helper = new SqlHelper())
{
var id = new InternalWxMaterial(helper).SortMaterial(materialid, sortid);
return(id);
}
}
/// <summary>
/// 期
/// </summary>
/// <param name="periodicalid"></param>
/// <returns></returns>
public periodical selectperiodical(int periodicalid)
{
using (var helper = new SqlHelper())
{
periodical wxmaterial = new InternalWxMaterial(helper).selectperiodical(periodicalid);
return(wxmaterial);
}
}
public int FrowardingSetCannel(int materialid, int comid)
{
using (var helper = new SqlHelper())
{
var id = new InternalWxMaterial(helper).FrowardingSetCannel(materialid, comid);
return(id);
}
}
public WxMaterial GetWxMaterial(int comid, int materialid)
{
using (var helper = new SqlHelper())
{
WxMaterial wxmaterial = new InternalWxMaterial(helper).GetWxMaterial(comid, materialid);
return(wxmaterial);
}
}
public int Delmaterialtype(int typeid, int comid)
{
using (var helper = new SqlHelper())
{
int count = new InternalWxMaterial(helper).Delmaterialtype(typeid, comid);
return(count);
}
}
internal IList <WxMaterial> GetWxMateriallistbytypeid(int wxmaterialtypeid, int topnums)
{
using (var helper = new SqlHelper())
{
IList <WxMaterial> r = new InternalWxMaterial(helper).GetWxMateriallistbytypeid(wxmaterialtypeid, topnums);
return(r);
}
}
public int GetWxMaterialCountByPercal(int comid, int Wxsaletypeid, int percal)
{
using (var helper = new SqlHelper())
{
int count = new InternalWxMaterial(helper).GetWxMaterialCountByPercal(comid, Wxsaletypeid, percal);
return(count);
}
}
public int GetNewestPerical(int Wxsaletypeid, int comid)
{
using (var helper = new SqlHelper())
{
int count = new InternalWxMaterial(helper).GetNewestPerical(Wxsaletypeid, comid);
return(count);
}
}
public int FrowardingSetSearch(int materialid)
{
using (var helper = new SqlHelper())
{
var id = new InternalWxMaterial(helper).FrowardingSetSearch(materialid);
return(id);
}
}
public int FrowardingSetList(int comid)
{
using (var helper = new SqlHelper())
{
var id = new InternalWxMaterial(helper).FrowardingSetList(comid);
return(id);
}
}
public periodical Selperiod(int percal, int wxtype)
{
using (var helper = new SqlHelper())
{
periodical wxmaterial = new InternalWxMaterial(helper).Selperiod(percal, wxtype);
return(wxmaterial);
}
}
public int InsMaterialKey(int MaterialId, string keyword)
{
using (var helper = new SqlHelper())
{
var id = new InternalWxMaterial(helper).InsMaterialKey(MaterialId, keyword);
return(id);
}
}
/// <summary>
/// 添加 期
/// </summary>
/// <param name="periodicalid"></param>
/// <returns></returns>
public int Addperiod(int period, int comid, int Wxsaletypeid, int percal)
{
using (var helper = new SqlHelper())
{
int periodical = new InternalWxMaterial(helper).Addperiod(period, comid, Wxsaletypeid, percal);
return(periodical);
}
}
internal IList <WxMaterial> GetLatestWxMaterial()
{
using (var helper = new SqlHelper())
{
var list = new InternalWxMaterial(helper).GetLatestWxMaterial();
return(list);
}
}
public string upRes(Reservation quren)
{
using (var helper = new SqlHelper())
{
var res = new InternalWxMaterial(helper).upRes(quren);
return(res.ToString());
}
}
public Reservation Res_id(int id, int comid)
{
using (var helper = new SqlHelper())
{
var list = new InternalWxMaterial(helper).Res_id(id, comid);
return(list);
}
}
public List <Reservation> ResSearchList(string comid, int pageindex, int pagesize, string key, bool isNum, out int totalcount)
{
using (var helper = new SqlHelper())
{
var list = new InternalWxMaterial(helper).ResSearchList(comid, pageindex, pagesize, key, isNum, out totalcount);
return(list);
}
}
public List <Reservation> Res_LoadingList(string comid, int pageindex, int pagesize, out int totalcount, int userid = 0)
{
using (var helper = new SqlHelper())
{
var list = new InternalWxMaterial(helper).Res_LoadingList(comid, pageindex, pagesize, out totalcount, userid);
return(list);
}
}
internal IList <WxMaterial> GetWxMaterialByKeyword(string keyword, int comid)
{
using (var helper = new SqlHelper())
{
var list = new InternalWxMaterial(helper).GetWxMaterialByKeyword(keyword, comid);
return(list);
}
}
public IList <WxMaterial> GetMaterialByPromoteType(int promotetypeid, out int totalcount)
{
using (var helper = new SqlHelper())
{
var list = new InternalWxMaterial(helper).GetMaterialByPromoteType(promotetypeid, out totalcount);
return(list);
}
}
internal IList <WxMaterial> GetWxMaterialByNewestPeriodical(int pageindex, int pagesize, int applystate, int promotetypeid, int perical, int comid, out int totalcount)
{
using (var helper = new SqlHelper())
{
var list = new InternalWxMaterial(helper).PageList(pageindex, pagesize, applystate, promotetypeid, perical, comid, out totalcount);
return(list);
}
}
public string GetWxMaterialKeyWordStrByMaterialId(int materialid)
{
using (var helper = new SqlHelper())
{
var keys = new InternalWxMaterial(helper).GetWxMaterialKeyWordStrByMaterialId(materialid);
return(keys);
}
}
