public static int ExistContinutedRecord(string resourceId, ResourceType type) { try { ISelectDataSourceFace query = new SelectSQL(TableName.ResourceRecord); query.DataBaseAlias = Const.LogConnection; query.SelectColumn("BlogId"); query.AddWhere("ResourceId", resourceId.Trim()); query.AddWhere("ResourceType", (int)type); query.AddWhere("Continued", true); return(SafeValueHelper.ToInt32(query.ExecuteScalar())); } catch (Exception ex) { Logger.Error(ex); return(0); } }
public static int GetFetchId(ResourceType type) { try { ISelectDataSourceFace query = new SelectSQL(TableName.FetchRecord); query.DataBaseAlias = Const.LogConnection; query.SelectColumn("Id"); query.AddWhere("ResourceType", (int)type); query.AddOrderBy("Id", Sort.Descending); query.Top = 1; return(SafeValueHelper.ToInt32(query.ExecuteScalar())); } catch (Exception ex) { Logger.Error(ex); return(0); } }