public static List <BibleContent> getBible() { string sqlStr = "SELECT B_CONTENT AS content, B.WEEK_DAY, IMAGE_PATH as path FROM BIBLE_CONTENT B WHERE B.B_DATE IN (@DAY1,@DAY2,@DAY3,@DAY4,@DAY5,@DAY6)"; List <string> thisWeek = getThisWeek(); SqlParameter day1 = new SqlParameter("@DAY1", thisWeek[0]); SqlParameter day2 = new SqlParameter("@DAY2", thisWeek[1]); SqlParameter day3 = new SqlParameter("@DAY3", thisWeek[2]); SqlParameter day4 = new SqlParameter("@DAY4", thisWeek[3]); SqlParameter day5 = new SqlParameter("@DAY5", thisWeek[4]); SqlParameter day6 = new SqlParameter("@DAY6", thisWeek[5]); SqlParameter[] paras = { day1, day2, day3, day4, day5, day6 }; DataTableCollection tables = SqlHelper.GetTableText(sqlStr, paras); DataTable table = tables[0]; List <BibleContent> results = new List <BibleContent>(); for (int i = 0; i < table.Rows.Count; i++) { BibleContent content = new BibleContent(); DataRow row = table.Rows[i]; content.content = row[CONTENT] as string; content.dateWeek = Convert.ToInt32(row[DAY]); content.imagePath = Convert.ToString(row[IMAGE_PATH]); results.Add(content); } return(results); }
public static BibleContent getDayBible(string date) { string sql = "SELECT B_CONTENT AS content, B.WEEK_DAY, IMAGE_PATH as path FROM BIBLE_CONTENT B WHERE B.B_DATE=@Date"; SqlParameter para = new SqlParameter("@Date", date); SqlParameter[] paras = { para }; DataTableCollection tables = SqlHelper.GetTableText(sql, paras); DataTable table = tables[0]; BibleContent content = new BibleContent(); for (int i = 0; i < table.Rows.Count; i++) { DataRow row = table.Rows[i]; content.content = row[CommonInfo.CONTENT] as string; content.dateWeek = Convert.ToInt32(row[CommonInfo.DAY]); content.imagePath = Convert.ToString(row[CommonInfo.D_IMAGE_PATH]); } return(content); }
public static BibleContent getBibleByDay(int day) { string sqlStr = "SELECT TOP 1 B_CONTENT AS content, B.WEEK_DAY, IMAGE_PATH as path FROM BIBLE_CONTENT B WHERE B.WEEK_DAY = @Day ORDERBY B_DATE DESC"; SqlParameter Day = new SqlParameter("@Day", day); SqlParameter[] paras = { Day }; DataTableCollection tables = SqlHelper.GetTableText(sqlStr, paras); DataTable table = tables[0]; BibleContent content = new BibleContent(); for (int i = 0; i < table.Rows.Count; i++) { DataRow row = table.Rows[i]; content.content = row[CONTENT] as string; content.dateWeek = Convert.ToInt32(row[DAY]); content.imagePath = Convert.ToString(row[IMAGE_PATH]); }//这边复制粘贴了, 有空改一改 return(content); }