/// <summary> /// 获取待检查URL集合 /// </summary> /// <param name="top">取多少条,默认-1 表示全部</param> /// <param name="isDesc">是否按link降序</param> /// <param name="where">查询条件</param> /// <returns></returns> public async Task <List <UrlInfo> > GetWaitCheakListSync(long top = -1, bool isDesc = true, string where = "") { var list = new List <UrlInfo>(); await Task.Run(() => { using (TxDataHelper helper = TxDataHelper.GetDataHelper(DatabaseType.Sql, CON_STR)) { string _sql = @" SELECT {0} id AS ID,link AS Url FROM [main_link] WHERE baidu_included = 0 {2} ORDER BY ID {1}"; var _dt = helper.SqlGetDataTable(string.Format(_sql, top == -1 ? "" : "TOP " + top.ToString(), isDesc ? "DESC" : "ASC", where)); list.AddRange(DataEntityHelper.GetEntityList <UrlInfo>(_dt)); } }); return(list); }
public static DataTable GetUserDb(int pageIndex, int pageSize, string userId) { var _hash = new Hashtable(); _hash["@user_id"] = userId; int totalCount = 0; var _dt = DataEntityHelper.GetTable( "Agent93390Test", " sales_user WITH(NOLOCK) ", _hash, " user_id asc", out totalCount, " and [user_id]>@user_id ", "*", pageIndex * pageSize, pageSize); return(_dt); }
public ProcessorBase(T model) { Model = model; _dataHelper = new DataEntityHelper <T>(model); }
public ProcessorBase(Guid id) { _dataHelper = new DataEntityHelper <T>(id); }