public ActionResult OrderNextWeek() //訂下個月
{
if (Session["account"] == null || string.IsNullOrWhiteSpace(Session["account"].ToString())) //如果還沒有登入帳號就直接顯示Login view
{
return(View("Login"));
}
else
{
account = Session["account"].ToString();
}
DateTime FirstDay = DateTime.Now.AddMonths(1).AddDays(-DateTime.Now.Day + 1);
DateTime LastDay = DateTime.Now.AddMonths(2).AddDays(-DateTime.Now.AddMonths(1).Day);
TimeSpan span = LastDay.Subtract(FirstDay);
int dayDiff = span.Days;
String[] date = new String[dayDiff];
FirstDay = FirstDay.AddDays(1);
bool isExist = false;
int j = 0;
for (int i = 0; i < dayDiff; i++)
{
string day = FirstDay.DayOfWeek.ToString();
string datetime = string.Format("{0:yyyy/MM/dd}", FirstDay); //將日期轉成資料庫格式
Loginsql();
SqlCommand cmd = new SqlCommand //檢查此日期資料否已存在
{
Connection = em,
CommandText = "SELECT COUNT(*) FROM Orderday2 WHERE orderday = '" + datetime + "'AND account='" + account + "'"
};
using (SqlDataReader reader = cmd.ExecuteReader()) //如果該日期訂購紀錄大於1就不顯示
{
reader.Read();
isExist = reader.GetInt32(0) > 1;
em.Close();
}
if (isExist == false) //如果isExist是false且不是Sunday、Saturday就把日期加入到date陣列
{
if (day != "Sunday" && day != "Saturday")
{
date[j] = datetime;
j += 1;
}
}
FirstDay = FirstDay.AddDays(1);
}
ViewBag.date = date;
ViewBag.length = j;
return(View());
}
public ActionResult Order() //批量訂購
{
if (Session["account"] == null || string.IsNullOrWhiteSpace(Session["account"].ToString())) //如果還沒有登入帳號就直接顯示Login view
{
return(View("Login"));
}
else
{
account = Session["account"].ToString();
}
DateTime today = DateTime.Today; //抓今天的日期
DateTime LastDay = DateTime.Now.AddMonths(1).AddDays(-DateTime.Now.AddMonths(1).Day); //抓這個月最後一天的日期
TimeSpan span = LastDay.Subtract(today); //最後一天與今天相減，算出這個月剩幾天
int dayDiff = span.Days; //把天數存到dayDiff
String[] date = new String[dayDiff]; //定義一個Date陣列，大小為dayDiff
today = today.AddDays(1); //將today日期+1
bool isExist = false;
int j = 0;
for (int i = 0; i < dayDiff; i++)
{
string day = today.DayOfWeek.ToString(); //抓today的日期是星期幾
string datetime = string.Format("{0:yyyy/MM/dd}", today); //將日期轉成資料庫格式
Loginsql();
SqlCommand cmd = new SqlCommand //檢查此日期資料否已存在
{
Connection = em,
CommandText = "SELECT COUNT(*) FROM Orderday2 WHERE orderday = '" + datetime + "'AND account='" + account + "'"
};
using (SqlDataReader reader = cmd.ExecuteReader()) //如果該日期訂購紀錄大於1，isExist就是true，那個日期就不顯示
{
reader.Read();
isExist = reader.GetInt32(0) > 1;
em.Close();
}
if (isExist == false) //如果isExist是false且不是Sunday、Saturday就把日期加入到date陣列
{
if (day != "Sunday" && day != "Saturday")
{
date[j] = datetime;
j += 1;
}
}
today = today.AddDays(1); //將today日期+1
}
ViewBag.date = date; //將date陣列裝到ViewVag.date
ViewBag.length = j;
return(View());
}
