public List <B2b_com_pro> serverSuodaoPagelist(int comid, string startime, string endtime, string key)
{
using (var helper = new SqlHelper())
{
var list = new InternalRentserver(helper).serverSuodaoPagelist(comid, startime, endtime, key);
return(list);
}
}
public string GetChipidByPrintNo(string printno)
{
using (var helper = new SqlHelper())
{
string chipid = new InternalRentserver(helper).GetChipidByPrintNo(printno);
return(chipid);
}
}
public List <b2b_Rentserver_user_Timeoutmoney> GetserverTimeoutPagelist(int comid, int pageindex, int pagesize, string startime, string endtime, string key, out int totalcount)
{
using (var helper = new SqlHelper())
{
List <b2b_Rentserver_user_Timeoutmoney> list = new InternalRentserver(helper).GetserverTimeoutPagelist(comid, pageindex, pagesize, startime, endtime, key, out totalcount);
return(list);
}
}
public decimal GetServerTimeoutMoney(int comid, string startime, string endtime, string key)
{
using (var helper = new SqlHelper())
{
decimal list = new InternalRentserver(helper).GetServerTimeoutMoney(comid, startime, endtime, key);
return(list);
}
}
public int GetServerUsageCount(int comid, string startime, string endtime, string key, int serverstate, int serverid)
{
using (var helper = new SqlHelper())
{
int r = new InternalRentserver(helper).GetServerUsageCount(comid, startime, endtime, key, serverstate, serverid);
return(r);
}
}
public List <B2b_Rentserver_User> GetserverfakaPagelist(int comid, int pageindex, int pagesize, string startime, string endtime, string key, int serverstate, int serverid, out int totalcount)
{
using (var helper = new SqlHelper())
{
List <B2b_Rentserver_User> list = new InternalRentserver(helper).GetserverfakaPagelist(comid, pageindex, pagesize, startime, endtime, key, serverstate, serverid, out totalcount);
return(list);
}
}
public int SearchRentserver_weiguihuancount_state(int sid, string startime, string endtime)
{
using (var helper = new SqlHelper())
{
var list = new InternalRentserver(helper).SearchRentserver_weiguihuancount_state(sid, startime, endtime);
return(list);
}
}
public int Insworktimeblackoutdates(b2b_com_pro_worktime_calendar model)
{
using (var helper = new SqlHelper())
{
int r = new InternalRentserver(helper).Insworktimeblackoutdates(model);
return(r);
}
}
public b2b_com_pro_worktime_calendar GetblackoutdateByWorktimeId(string daydate, int proworktimeid)
{
using (var helper = new SqlHelper())
{
b2b_com_pro_worktime_calendar r = new InternalRentserver(helper).GetblackoutdateByWorktimeId(daydate, proworktimeid);
return(r);
}
}
public int DelblackoutdateByWorktimeId(string daydate, int proworktimeid)
{
using (var helper = new SqlHelper())
{
int r = new InternalRentserver(helper).DelblackoutdateByWorktimeId(daydate, proworktimeid);
return(r);
}
}
public int Delworktimeusesetbyworktimeid(int proworktimeid)
{
using (var helper = new SqlHelper())
{
int r = new InternalRentserver(helper).Delworktimeusesetbyworktimeid(proworktimeid);
return(r);
}
}
//-------------------------------结束时间，索道票管理-------------------------------------------
#region 增加或更改服务内容
public int uppro_worktime(int id, int comid, string title, string defaultendtime, string defaultstartime)
{
using (var helper = new SqlHelper())
{
var pro = new InternalRentserver(helper).uppro_worktime(id, comid, title, defaultendtime, defaultstartime);
return(pro);
}
}
public List <b2b_com_pro_worktime> pro_worktimepagelist(int pageindex, int pagesize, int comid, out int totalcount, int proid = 0)
{
using (var helper = new SqlHelper())
{
var list = new InternalRentserver(helper).pro_worktimepagelist(pageindex, pagesize, comid, out totalcount, proid);
return(list);
}
}
public string produibicostrili(int comid, int proid, string stardate, string enddate)
{
using (var helper = new SqlHelper())
{
var list = new InternalRentserver(helper).produibicostrili(comid, proid, stardate, enddate);
return(list);
}
}
public int upprocostrili(B2b_pro_cost_rili costrili)
{
using (var helper = new SqlHelper())
{
var list = new InternalRentserver(helper).upprocostrili(costrili);
return(list);
}
}
public List <B2b_Rentserver> Rentserverpagelist(int pageindex, int pagesize, int comid, out int totalcount, int proid = 0, string pno = "")
{
using (var helper = new SqlHelper())
{
var list = new InternalRentserver(helper).Rentserverpagelist(pageindex, pagesize, comid, out totalcount, proid, pno);
return(list);
}
}
/// <summary>
/// 根据产品工作时间类型id获得特定日期
/// </summary>
/// <param name="proworktimetypeid">产品工作时间类型</param>
/// <param name="datatype">日期类型(0全部；1有效日期及今天以后的日期包括今天；2.失效日期)</param>
/// <returns></returns>
public List <b2b_com_pro_worktime_calendar> GetblackoutdatebyProWorktimeId(int proworktimeid, string datatype = "0")
{
using (var helper = new SqlHelper())
{
List <b2b_com_pro_worktime_calendar> list = new InternalRentserver(helper).GetblackoutdatebyProWorktimeId(proworktimeid, datatype);
return(list);
}
}
public int delRentserver(int id, int comid)
{
using (var helper = new SqlHelper())
{
var pro = new InternalRentserver(helper).delRentserver(id, comid);
return(pro);
}
}
public b2b_com_pro_worktime pro_worktimebyid(int id, int comid)
{
using (var helper = new SqlHelper())
{
var list = new InternalRentserver(helper).pro_worktimebyid(id, comid);
return(list);
}
}
public List <B2b_pro_cost_rili> procostrilipagelist(int pageindex, int pagesize, int comid, int proid, out int totalcount)
{
using (var helper = new SqlHelper())
{
var list = new InternalRentserver(helper).procostrilipagelist(pageindex, pagesize, comid, proid, out totalcount);
return(list);
}
}
public B2b_pro_cost_rili procostrilibyid(int comid, int id)
{
using (var helper = new SqlHelper())
{
var list = new InternalRentserver(helper).procostrilibyid(comid, id);
return(list);
}
}
public int delcostrili(int comid, int id)
{
using (var helper = new SqlHelper())
{
var list = new InternalRentserver(helper).delcostrili(comid, id);
return(list);
}
}
public string prolastcostrilibyid(int comid, int proid, int id)
{
using (var helper = new SqlHelper())
{
var list = new InternalRentserver(helper).prolastcostrilibyid(comid, proid, id);
return(list);
}
}
public decimal projectfinancesum(int comid, int projectid, string startime, string endtime)
{
using (var helper = new SqlHelper())
{
var list = new InternalRentserver(helper).projectfinancesum(comid, projectid, startime, endtime);
return(list);
}
}
public B2b_Rentserver Rentserverbyid(int id, int comid)
{
using (var helper = new SqlHelper())
{
var list = new InternalRentserver(helper).Rentserverbyid(id, comid);
return(list);
}
}
public int insertTimeoutmoney(b2b_Rentserver_user_Timeoutmoney timeout)
{
using (var helper = new SqlHelper())
{
var pro = new InternalRentserver(helper).insertTimeoutmoney(timeout);
return(pro);
}
}
public List <B2b_project_finance> projectfinancepagelist(int pageindex, int pagesize, int comid, int projectid, string startime, string endtime, out int totalcount)
{
using (var helper = new SqlHelper())
{
var list = new InternalRentserver(helper).projectfinancepagelist(pageindex, pagesize, comid, projectid, startime, endtime, out totalcount);
return(list);
}
}
public int Reverse_Rentserver_User(string pno)
{
using (var helper = new SqlHelper())
{
var pro = new InternalRentserver(helper).Reverse_Rentserver_User(pno);
return(pro);
}
}
public int upprojectfinance(B2b_project_finance project_finance)
{
using (var helper = new SqlHelper())
{
var list = new InternalRentserver(helper).upprojectfinance(project_finance);
return(list);
}
}
/// <summary>
/// 根据服务id得到服务信息
/// </summary>
/// <param name="rentserverid"></param>
/// <returns></returns>
public B2b_Rentserver GetRentServerById(int rentserverid)
{
using (var helper = new SqlHelper())
{
B2b_Rentserver r = new InternalRentserver(helper).GetRentServerById(rentserverid);
return(r);
}
}
