每年工作日与非工作日的设置

public string GetYear(int year)

{            

if (year == 0)

{

year = DateTime.Now.Year;  //获取当前年份

}

DataTable dt = SQLHelper.GetDBToDataTable("select convert(varchar(10),NoWorkDate,120) as NoWorkDate from LVS_CORE_NoWorkDay where YearTime='" + year + "'");

int[] array = new int[12];

for (int i = 1; i < 13; i++)

{

int num = i - 1;

array[num] = DateTime.DaysInMonth(year, i); //获取当前年月的每月天数

}

string text = "<table class=\"tb_AdPlan\" cellpadding=\"0\" cellspacing=\"0\">";  // 拼个table

for (int j = 0; j < 12; j++)

{

text += "<tr class=\"tb_AdPlan_Caption\">";

object obj = text;

text = string.Concat(new object[]

{

obj,

"<td class=\"tb_AdPlan_Caption_TitleCell\">",

year,

"年",

j + 1,

"月</td>"

});

for (int k = 1; k <= array[j]; k++)

{

DateTime dateTime = DateTime.Parse(string.Concat(new object[]

{

year,

"-",

j + 1,

"-",

k

}));

DayOfWeek dayOfWeek = dateTime.DayOfWeek;  （获取当前星期几）                

string str = "tb_AdPlan_Caption_Cell";

int num2 = 0;

if(dt.Select(string.Format("NoWorkDate='{0}'",dateTime.ToString("yyyy -MM-dd"))).Length>0)

 {

str = "tb_AdPlan_Caption_WeekEndCell";

num2 = 1;

 }

                  if (dayOfWeek == DayOfWeek.Saturday || dayOfWeek == DayOfWeek.Sunday)    //为非工作日设置一个默认的背景颜色   {

                        string s = "#009100";

                        text = text + "<td class=\"" + str + "\" bgcolor=\"" + s + "\"";

                    }

                    else {

                        text = text + "<td class=\"" + str + "\"";

                    }

obj = text;

text = string.Concat(new object[]

{

obj,

" οnmοuseοver=\"ShowTipInfo(this,'点击增加非工作日')\"      οnmοuseοut=\"HideTipInfo(this)\" οnclick=\"AddNoWorkDay('",

num2,

"','",

dateTime.ToString("yyyy-MM-dd"),

"')\" style=\"cursor:hand;\""

});

text += " >";

text += k;

text += "</td>";

}

text += "</tr>";

}

return text + "</table>";

}