工作日与非工作日的设置"/>
每年工作日与非工作日的设置
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>";
}
更多推荐
每年工作日与非工作日的设置
发布评论