/// <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)); }