/// <summary>
/// page
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="pageIndex">page index</param>
/// <param name="pageSize">page size</param>
/// <param name="pmsDict">parameters</param>
/// <returns>page result</returns>
public virtual Tuple <int, List <T> > Page <T>(int pageIndex, int pageSize, Dictionary <string, object> pmsDict = null) where T : class
{
IBaseDal dal = new BaseDal();
int total = 0;
List <T> list = dal.Page <T>("Count", "Page", pageIndex, pageSize, out total, pmsDict);
return(new Tuple <int, List <T> >(total, list));
}
/// <summary>
/// read model
/// </summary>
/// <typeparam name="T">entity type</typeparam>
/// <param name="sqlFileName">sql file name</param>
/// <param name="sqlId">sql id</param>
/// <param name="pmsDict">parameters</param>
/// <returns>data</returns>
public virtual T ReadModelByPms <T>(string sqlFileName, string sqlId, Dictionary <string, object> pmsDict) where T : class
{
IBaseDal dal = new BaseDal();
return(dal.ReadSingle <T>(sqlFileName, sqlId, pmsDict));
}
/// <summary>
/// read model
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="pmsDict">parameters</param>
/// <returns>model</returns>
public virtual T ReadModelByPms <T>(Dictionary <string, object> pmsDict = null) where T : class
{
IBaseDal dal = new BaseDal();
return(dal.ReadSingle <T>("Read", pmsDict));
}
/// <summary>
/// count by parameters
/// </summary>
/// <param name="sqlFileName">sql file name</param>
/// <param name="sqlId">sql id</param>
/// <param name="pmsDict">parameters</param>
/// <returns>count quantity</returns>
public int Count(string sqlFileName, string sqlId, Dictionary <string, object> pmsDict = null)
{
IBaseDal dal = new BaseDal();
return(dal.Count(sqlFileName, sqlId, pmsDict));
}
/// <summary>
/// count by parameters
/// </summary>
/// <typeparam name="T">type</typeparam>
/// <param name="sqlId">sql id</param>
/// <param name="entity">parameter entity</param>
/// <returns>count quantity</returns>
public int Count <T>(string sqlId, T entity) where T : class
{
IBaseDal dal = new BaseDal();
return(dal.Count <T>(sqlId, entity));
}
/// <summary>
/// exist current entity
/// </summary>
/// <typeparam name="T">type</typeparam>
/// <param name="sqlId">sql id</param>
/// <param name="entity">current entity</param>
/// <returns>exist result</returns>
public bool Exist <T>(string sqlId, T entity) where T : class
{
IBaseDal dal = new BaseDal();
return(dal.Exist <T>(sqlId, entity));
}
/// <summary>
/// query object
/// </summary>
/// <param name="sqlFileName">sql file name</param>
/// <param name="sqlId">sql id</param>
/// <param name="pmsDict">parameters</param>
/// <returns>object result in string</returns>
public virtual object QueryObj(string sqlFileName, string sqlId, Dictionary <string, object> pmsDict)
{
IBaseDal dal = new BaseDal();
return(dal.QueryObj(sqlFileName, sqlId, pmsDict));
}
/// <summary>
/// read record
/// </summary>
/// <param name="sqlFileName">sql file name</param>
/// <param name="sqlId">sql id</param>
/// <param name="pmsDict">parameteres</param>
/// <returns>record</returns>
public virtual Dictionary <string, object> ReadRecordByPms(string sqlFileName, string sqlId, Dictionary <string, object> pmsDict = null)
{
IBaseDal dal = new BaseDal();
return(dal.ReadSingle(sqlFileName, sqlId, pmsDict));
}
/// <summary>
/// create,update,delete record by parameter
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="sqlFileName">sql file name</param>
/// <param name="sqlId">sql id</param>
/// <param name="modelList">model list</param>
/// <returns>create,update,delete quantity</returns>
public virtual int CUDByModel <T>(string sqlFileName, string sqlId, List <T> modelList) where T : class
{
IBaseDal dal = new BaseDal();
return(dal.CUD(sqlFileName, sqlId, modelList.Select(a => { return BaseDal.ConvertEntityToParameters <T>(a); }).ToList()));
}
/// <summary>
/// create,update,delete record by parameter
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="sqlFileName">sql file name</param>
/// <param name="sqlId">sql id</param>
/// <param name="model">model</param>
/// <returns>create,update,delete quantity</returns>
public virtual int CUDByModel <T>(string sqlFileName, string sqlId, T model) where T : class
{
IBaseDal dal = new BaseDal();
return(dal.CUD(sqlFileName, sqlId, BaseDal.ConvertEntityToParameters <T>(model)));
}
/// <summary>
/// create,update,delete record by parameter
/// </summary>
/// <param name="sqlFileName">sql file name</param>
/// <param name="sqlId">sql id</param>
/// <param name="pmsDictList">parameter list</param>
/// <returns>create,update,delete quantity</returns>
public virtual int CUDByPms(string sqlFileName, string sqlId, List <Dictionary <string, object> > pmsDictList)
{
IBaseDal dal = new BaseDal();
return(dal.CUD(sqlFileName, sqlId, pmsDictList));
}
/// <summary>
/// delete record by parameters
/// </summary>
/// <param name="sqlFileName">sql file name</param>
/// <param name="pmsDict">parameter</param>
/// <returns>delete quantity</returns>
public virtual int DeleteByPms(string sqlFileName, Dictionary <string, object> pmsDict)
{
IBaseDal dal = new BaseDal();
return(dal.CUD(sqlFileName, "Delete", pmsDict));
}
/// <summary>
/// delete record by model
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="model">model</param>
/// <returns>delete quantity</returns>
public virtual int DeleteByModel <T>(T model) where T : class
{
IBaseDal dal = new BaseDal();
return(dal.CUD <T>("Delete", model));
}
/// <summary>
/// update record by model
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="models">models</param>
/// <returns>update quantity</returns>
public virtual int UpdateByModel <T>(List <T> models) where T : class
{
IBaseDal dal = new BaseDal();
return(dal.CUD <T>("Update", models));
}
/// <summary>
/// get whole model list
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <returns>whole model list</returns>
public virtual List <T> Index <T>() where T : class
{
IBaseDal dal = new BaseDal();
return(dal.Read <T>("Index"));
}
/// <summary>
/// read models
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="model">parameter model</param>
/// <returns></returns>
public virtual List <T> ReadModelListByModel <T>(T model) where T : class
{
IBaseDal dal = new BaseDal();
return(dal.Read <T>("Read", BaseDal.ConvertEntityToParameters <T>(model)));
}
/// <summary>
/// read models
/// </summary>
/// <typeparam name="T">model type</typeparam>
/// <param name="pms">parameters</param>
/// <returns>models</returns>
public virtual List <T> ReadModelListByPms <T>(Dictionary <string, object> pms = null) where T : class
{
IBaseDal dal = new BaseDal();
return(dal.Read <T>("Read", pms));
}
/// <summary>
/// read models
/// </summary>
/// <typeparam name="T">entity type</typeparam>
/// <param name="sqlFileName">sql file name</param>
/// <param name="sqlId">sql id</param>
/// <param name="pmsDict">parameters</param>
/// <returns>models</returns>
public virtual List <T> ReadModelListByPms <T>(string sqlFileName, string sqlId, Dictionary <string, object> pmsDict = null) where T : class
{
IBaseDal dal = new BaseDal();
return(dal.Read <T>(sqlFileName, sqlId, pmsDict));
}
