using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; using System.Threading.Tasks; namespace CallCenterApi.BLL { /// /// 导入电话表 /// public partial class T_Vis_Telphone { private readonly DAL.T_Vis_Telphone dal = new DAL.T_Vis_Telphone(); public T_Vis_Telphone() { } #region BasicMethod /// /// 是否存在该记录 /// public bool Exists(int F_TelID) { return dal.Exists(F_TelID); } /// /// 增加一条数据 /// public int Add(Model.T_Vis_Telphone model) { return dal.Add(model); } /// /// 更新一条数据 /// public bool Update(Model.T_Vis_Telphone model) { return dal.Update(model); } /// /// 删除一条数据 /// public bool Delete(int F_TelID) { return dal.Delete(F_TelID); } /// /// 删除一条数据 /// public bool DeleteList(string F_TelIDlist) { return dal.DeleteList(F_TelIDlist); } /// /// 得到一个对象实体 /// public Model.T_Vis_Telphone GetModel(int F_TelID) { return dal.GetModel(F_TelID); } /// /// 获得数据列表 /// public DataSet GetList(string strWhere) { return dal.GetList(strWhere); } /// /// 获得前几行数据 /// public DataSet GetList(int Top, string strWhere, string filedOrder) { return dal.GetList(Top, strWhere, filedOrder); } /// /// 获得数据列表 /// public List GetModelList(string strWhere) { DataSet ds = dal.GetList(strWhere); return DataTableToList(ds.Tables[0]); } /// /// 获得数据列表 /// public List DataTableToList(DataTable dt) { List modelList = new List(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.T_Vis_Telphone model; for (int n = 0; n < rowsCount; n++) { model = dal.DataRowToModel(dt.Rows[n]); if (model != null) { modelList.Add(model); } } } return modelList; } /// /// 获得数据列表 /// public DataSet GetAllList() { return GetList(""); } /// /// 分页获取数据列表 /// public int GetRecordCount(string strWhere) { return dal.GetRecordCount(strWhere); } /// /// 分页获取数据列表 /// public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex) { return dal.GetListByPage(strWhere, orderby, startIndex, endIndex); } #endregion BasicMethod #region ExtensionMethod /// /// 分配更新 /// /// public bool UpdateFP(int telid, int fpid, int zxid, string zxname, string fpname) { return dal.UpdateFP(telid, fpid, zxid, zxname, fpname); } /// /// 呼叫更新 /// /// public bool UpdateHJ(int telid, int uid, string uname, int resid, string res) { return dal.UpdateHJ(telid, uid, uname, resid, res); } /// /// 回访更新 /// /// public bool UpdateHF(int telid, bool isvis, bool isres, int resid, string res, int uid, string uname, string tscore, string rscore, string rings, string wholes, string totals, string remark, string visresult, string visinfo, string visis) { return dal.UpdateHF(telid, isvis, isres, resid, res, uid, uname, tscore, rscore, rings, wholes, totals, remark, visresult, visinfo, visis); } public bool UpdateBZ(int telid, string tscore) { return dal.UpdateBZ(telid, tscore); } public DataSet GetListDQ(string strWhere) { return dal.GetListDQ(strWhere); } public DataSet GetListDQYX(string strWhere) { return dal.GetListDQYX(strWhere); } public DataSet GetListGW(string strWhere) { return dal.GetListGW(strWhere); } public DataSet GetListGWYX(string strWhere) { return dal.GetListGWYX(strWhere); } public DataSet GetListBZ(string strWhere) { return dal.GetListBZ(strWhere); } public DataSet GetListBZYX(string strWhere) { return dal.GetListBZYX(strWhere); } public DataSet GetListExpt(string strWhere) { return dal.GetListExpt(strWhere); } /// /// 根据文件删除 /// public bool DeleteListByFileID(string FileID) { return dal.DeleteListByFileID(FileID); } #endregion ExtensionMethod } }