/// 加载行数据到对象--集合
/// </summary>
/// <param name="dr"></param>
/// <param name="classes"></param>
public void LoadDataToList(DataRow dr, MODEL.doc_calendar calendar)
{
calendar.date = DateTime.Parse(dr["date"].ToString());
calendar.year = dr["year"].ToString();
calendar.month = int.Parse(dr["month"].ToString());
calendar.day = int.Parse(dr["day"].ToString());
calendar.weekday = int.Parse(dr["weekday"].ToString());
calendar.isholiday = int.Parse(dr["isholiday"].ToString());
calendar.week = int.Parse(dr["week"].ToString());
if (dr["worktime"].ToString() != "")
{
calendar.worktime = int.Parse(dr["worktime"].ToString());
}
if (dr["basetime"].ToString() != "")
{
calendar.basetime = int.Parse(dr["basetime"].ToString());
}
if (dr["explain"].ToString() != "")
{
calendar.explain = dr["explain"].ToString();
}
if (dr["planstr"].ToString() != "")
{
calendar.planstr = int.Parse(dr["planstr"].ToString());
}
}
/// <summary>
/// 增加工作日历
/// </summary>
/// <param name="addCalendar"></param>
/// <returns></returns>
public int AddCalendar(MODEL.doc_calendar addCalendar)
{
sql = "insert into doc_calendar(date,year,month,day,weekday,week,worktime,basetime,explain,planstr,isholiday) values(@date,@year,@month, @day,@weekday,@week,@worktime, @basetime,@explain,@planstr,@isholiday)";
SqlParameter[] ps =
{
new SqlParameter("date", addCalendar.date),
new SqlParameter("year", addCalendar.year),
new SqlParameter("month", addCalendar.month),
new SqlParameter("day", addCalendar.day),
new SqlParameter("weekday", addCalendar.weekday),
new SqlParameter("week", addCalendar.week),
new SqlParameter("worktime", addCalendar.worktime),
new SqlParameter("basetime", addCalendar.basetime),
new SqlParameter("explain", addCalendar.explain),
new SqlParameter("planstr", addCalendar.planstr),
new SqlParameter("isholiday", addCalendar.isholiday)
};
return(SqlHelper.ExecuteNonQuery(sql, ps));
}
/// <summary>
/// 获取某年所有假期其訊息
/// </summary>
/// <param name>date</param>
/// <returns></returns>
public List <MODEL.doc_calendar> GetMonthCalendar(string year, string month)
{
string sql = "select * from doc_calendar where year=@year and month=@month ";
SqlParameter[] ps =
{
new SqlParameter("year", year),
new SqlParameter("month", month)
};
DataTable dt = SqlHelper.ExcuteTable(sql, ps);
List <MODEL.doc_calendar> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.doc_calendar>();
foreach (DataRow row in dt.Rows)
{
MODEL.doc_calendar c = new MODEL.doc_calendar();
LoadDataToList(row, c);
lists.Add(c);
}
}
return(lists);
}
/// <summary>
/// 增加工作日历
/// </summary>
/// <param name="addCalendar"></param>
/// <returns></returns>
public int AddCalendar(MODEL.doc_calendar addCalendar)
{
return(cs.AddCalendar(addCalendar));
}
