protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
sid = Request.Params["sid"] == null ? "" : Request.Params["sid"].Trim();
type = Request.Params["action"] == null ? "" : Request.Params["action"].Trim();
if (sid != "")
{
model = new BLL.project().GetModel(int.Parse(sid));
if (model != null)
{
try
{
string v1Str = model.v1 != null ? model.v1 : "";
string v2Str = model.v2 != null ? model.v2 : "";
v10 = model.v10 != null ? model.v10 : "未分类";
if (v1Str != "")
{
v1 = DbHelperSQL.GetSingle("select dbo.getUserNames_fu('" + v1Str + "')").ToString();
}
if (v2Str != "")
{
v2 = DbHelperSQL.GetSingle("select dbo.getUserNames_fu('" + v2Str + "')").ToString();
}
}
catch
{
}
//v3 = DbHelperSQL.GetSingle("select dbo.getUserNames_fu('" + model.v3 != null ? model.v3 : "" + "')").ToString();
}
}
}
}
/// <summary>
/// 取出 Project 表中 MenuPro.M_ID = Project.P_ID 的数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public DataTable GetProject_Single(Model.project model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select P_ID,P_NAME,P_PorName,P_MakerNO,M_P_ID,P_order from Project ");
strSql.Append("where M_P_ID = '" + model.M_P_ID + "' order by P_order");
return(DbHelperSQL.Query(strSql.ToString()).Tables[0]);
}
/// <summary>
/// 删除 Project
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string GetProject_Delect(Model.project model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Project where ");
strSql.Append("P_ID = '" + model.P_ID + "' and ");
strSql.Append("P_NAME = '" + model.P_NAME + "'");
return(strSql.ToString());
}
/// <summary>
/// update Project
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string GetProject_Update(Model.project model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Project set P_NAME=N'" + model.P_NAME + "',");
strSql.Append(" P_PorName=N'" + model.P_PorName + "',P_MakerNO='" + model.P_MakerNO + "',M_P_ID='" + model.M_P_ID + "' ");//,P_order=N'"+model.P_ORDER+"'
strSql.Append(" where P_NAME=N'" + model.P_NAME + "'");
return(strSql.ToString());
}
public string insert(Model.project model)
{
if (dal.exists(" where project_code='" + model.project_code + "'"))
{
return("项目编号已存在");
}
if (dal.exists(" where project_name='" + model.project_name + "'"))
{
return("项目名称已存在");
}
return(dal.insert(model));
}
/// <summary>
/// 插入 Project
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string GetProject_Insert(Model.project model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Project (P_NAME,P_PorName,P_MakerNO,M_P_ID,P_order,xsqf) ");
strSql.Append("values ( ");
strSql.Append("'" + model.P_NAME + "',");
strSql.Append("'" + model.P_PorName + "',");
strSql.Append("'" + model.P_MakerNO + "',");
strSql.Append("'" + model.M_P_ID + "'");
// strSql.Append(",'"+model.P_ORDER+"','1') ");
return(strSql.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
sid = Request.Params["sid"] == null ? "" : Request.Params["sid"].Trim();
type = Request.Params["action"] == null ? "" : Request.Params["action"].Trim();
if (sid != "")
{
model = new BLL.project().GetModel(int.Parse(sid));
if (model != null)
{
v1 = DbHelperSQL.GetSingle("select dbo.getUserNames_fu('" + model.v1 + "')").ToString();
v2 = DbHelperSQL.GetSingle("select dbo.getUserNames_fu('" + model.v2 + "')").ToString();
v3 = DbHelperSQL.GetSingle("select dbo.getUserNames_fu('" + model.v3 + "')").ToString();
}
}
}
}
public string update(Model.project model)
{
SqlParameter[] parameters =
{
new SqlParameter("@ActionType", SqlDbType.NVarChar, 20),
new SqlParameter("@project_name", SqlDbType.NVarChar, 100),
new SqlParameter("@project_code", SqlDbType.NVarChar, 50),
new SqlParameter("@prepared_by", SqlDbType.NVarChar, 50),
new SqlParameter("@reviewed_by", SqlDbType.NVarChar, 50),
new SqlParameter("@project_manager", SqlDbType.NVarChar, 50),
new SqlParameter("@creation_date", SqlDbType.NVarChar, 50),
new SqlParameter("@remark", SqlDbType.Text),
new SqlParameter("@head_audit", SqlDbType.NVarChar, 100),
new SqlParameter("@general_review", SqlDbType.NVarChar, 100),
new SqlParameter("@sid", SqlDbType.Int),
new SqlParameter("@update_person", SqlDbType.NVarChar, 50),
new SqlParameter("@update_date", SqlDbType.NVarChar, 50),
new SqlParameter("@reValue", SqlDbType.NVarChar, 200),
new SqlParameter("@outSid", SqlDbType.Int)
};
parameters[0].Value = "Update1";
parameters[1].Value = model.project_name;
parameters[2].Value = model.project_code;
parameters[3].Value = model.prepared_by;
parameters[4].Value = model.reviewed_by;
parameters[5].Value = model.project_manager;
parameters[6].Value = model.creation_date;
parameters[7].Value = model.remark;
parameters[8].Value = model.v1;
parameters[9].Value = model.v2;
parameters[10].Value = model.sid;
parameters[11].Value = model.update_person;
parameters[12].Value = model.update_date;
parameters[13].Direction = ParameterDirection.Output;
parameters[14].Direction = ParameterDirection.Output;
DataSet ds = DbHelperSQL.RunProcedure("Proc_Project", parameters, "");
string reVal = parameters[13].Value.ToString().Trim();
string reSid = parameters[14].Value.ToString().Trim();
return(reVal);
}
public string update(Model.project model)
{
//return dal.update(model);
if (dal.exists(" where project_code='" + model.project_code + "' and sid!=" + model.sid))
{
return("项目编号已存在");
}
if (dal.exists(" where project_name='" + model.project_name + "' and sid!=" + model.sid))
{
return("项目名称已存在");
}
return(dal.update(model));
//if (dal.Update(model))
//{
// return "success";
//}
//else
//{
// return "修改失败！";
//}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
pssid = Request.Params["ps_sid"] == null ? "" : Request.Params["ps_sid"].Trim();
DataTable dt = new DataTable();
DataSet ds = new BLL.Common().GetList("select project.sid as psid, project_name,project_code,stage_name,begin_date,end_date from project_stage left outer join project on project_stage.p_sid=project.sid where project_stage.sid='" + pssid + "'");
if (ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
if (dt.Rows.Count > 0)
{
pname = dt.Rows[0]["project_name"].ToString().Trim();
pcode = dt.Rows[0]["project_code"].ToString().Trim();
stageName = dt.Rows[0]["stage_name"].ToString().Trim();
pModel = new BLL.project().GetModel(int.Parse(dt.Rows[0]["psid"].ToString().Trim()));
string str1 = "", str2 = "", str3 = "", str4 = "";
DataTable impDT = new DataTable();
DataSet impDS = new BLL.project_implement().GetList(" s_sid='" + pssid + "'");
if (impDS.Tables.Count > 0)
{
impDT = impDS.Tables[0];
}
for (int i = 0; i < impDT.Rows.Count; i++)
{
str1 += "<th colspan='1' rowspan='2' >" + impDT.Rows[i]["implement_name"].ToString().Trim() + "</th>";
str2 += "<th>" + impDT.Rows[i]["implementers"].ToString().Trim() + "</th>";
}
DateTime sDate = DateTime.Parse(dt.Rows[0]["begin_date"].ToString().Trim());
DateTime eDate = DateTime.Parse(dt.Rows[0]["end_date"].ToString().Trim());
TimeSpan ts = eDate.AddDays(1).Subtract(sDate);
string monthstr = "";
if (sDate.Month == eDate.Month)
{
monthstr = sDate.Month.ToString() + "月";
}
else
{
monthstr = sDate.Month.ToString() + "-" + eDate.Month.ToString() + "月";
}
string cols = ts.Days.ToString();
for (int i = 0; i < ts.Days; i++)
{
str3 += "<th colspan='1' >" + sDate.AddDays(i).Day.ToString() + "</th>";
string w = "";
switch (sDate.AddDays(i).DayOfWeek)
{
case DayOfWeek.Sunday:
w = "日";
break;
case DayOfWeek.Monday:
w = "一";
break;
case DayOfWeek.Tuesday:
w = "二";
break;
case DayOfWeek.Wednesday:
w = "三";
break;
case DayOfWeek.Thursday:
w = "四";
break;
case DayOfWeek.Friday:
w = "五";
break;
case DayOfWeek.Saturday:
w = "六";
break;
}
str4 += "<th style='white-space:pre-wrap; word-wrap:break-word;'>" + w + "</th>";
}
trStr += "<table class='printinnertable' cellpadding='0' cellspacing='0'>";
trStr += "<thead>";
trStr += "<tr>";
trStr += "<th rowspan='3'>阶段</th>";
trStr += "<th rowspan='3'>小组</th>";
trStr += "<th rowspan='3' >工作内容</th>";
trStr += "<th rowspan='3'>细目</th>";
trStr += "<th colspan='1'>月</th>";
trStr += "<th colspan='" + cols + "'>" + monthstr + "(黄色色块代表完成这项工作所需要的完成时间，计划表中实际完成时间将用绿色色块做标记)</th>";
trStr += str1;
trStr += "<th width='100px' rowspan='3'>完成情况(按照公司设计质量标准评定:绿，黄，橙，红。四种工作完成状况)</th>";
trStr += "<th width='150px' rowspan='3'>未完成的原因</th>";
trStr += "<th width='150px' rowspan='3'>解决的办法</th>";
trStr += "<th width='150px' rowspan='3'>备注</th>";
trStr += "</tr>";
trStr += "<tr>";
trStr += "<th colspan='1'>日</th>";
trStr += str3;
trStr += "</tr>";
trStr += "<tr>";
trStr += "<th >星期</th>";
trStr += str4;
trStr += str2;
trStr += "</tr>";
trStr += "</thead>";
trStr += ContentViewItem(pssid);
trStr += "</table>";
}
}
}
/// <summary>
/// update Project
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string GetProject_Update(Model.project model)
{
return(dal.GetProject_Update(model));
}
/// <summary>
/// 删除 Project
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string GetProject_Delect(Model.project model)
{
return(dal.GetProject_Delect(model));
}
/// <summary>
/// 取出 Project 表中 MenuPro.M_ID = Project.P_ID 的数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public DataTable GetProject_Single(Model.project model)
{
return(dal.GetProject_Single(model));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
type = Request.Params["type"] == null ? "" : Request.Params["type"].Trim();
pssid = Request.Params["ps_sid"] == null ? "" : Request.Params["ps_sid"].Trim();
DataTable dt = new DataTable();
DataSet ds = new BLL.Common().GetList("select project.sid as psid, project_name,project_code,stage_name,begin_date,end_date,project_stage.is_system from project_stage left outer join project on project_stage.p_sid=project.sid where project_stage.sid='" + pssid + "'");
if (ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
if (dt.Rows.Count > 0)
{
isConstruction = dt.Rows[0]["is_system"].ToString().Trim();
pname = dt.Rows[0]["project_name"].ToString().Trim();
pcode = dt.Rows[0]["project_code"].ToString().Trim();
stageName = dt.Rows[0]["stage_name"].ToString().Trim();
pModel = new BLL.project().GetModel(int.Parse(dt.Rows[0]["psid"].ToString().Trim()));
string str0 = "", str1 = "", str2 = "", str3 = "", str4 = "";
DataTable impDT = new DataTable();
DataSet impDS = new BLL.Common().GetList("select * from project_implement where s_sid='" + pssid + "' order by sequence asc");
if (impDS.Tables.Count > 0)
{
impDT = impDS.Tables[0];
for (int i = 0; i < impDT.Rows.Count; i++)
{
str0 += "<th >" + new BLL.Common().GetList("select dbo.get_SNs_zxf('" + impDT.Rows[i]["v1"].ToString().Trim() + "')").Tables[0].Rows[0][0].ToString() + "</th>";
if (isConstruction == "1")
{
str1 += "<th colspan='1'>" + impDT.Rows[i]["implement_name"].ToString().Trim() + "</th>";
}
else
{
str1 += "<th colspan='1' rowspan='2' >" + impDT.Rows[i]["implement_name"].ToString().Trim() + "</th>";
}
//str1 += "{title:'" + impDT.Rows[i]["implement_name"].ToString().Trim() + "',rowspan:2},";
//str1 += "<th colspan='1' rowspan='2' ></th>";
//str2 += "<th data-options=\"field:'imp" + impDT.Rows[i]["sid"].ToString().Trim() + "',width:100, halign:'center', align:'center'\" >" + new BLL.Common().GetList("select dbo.getUserAbbr_fu('"+impDT.Rows[i]["implementers_sid"].ToString().Trim()+"')").Tables[0].Rows[0][0] + "</th>";
str2 += "<th data-options=\"field:'imp" + impDT.Rows[i]["sid"].ToString().Trim() + "',width:100, halign:'center', align:'center'\" >" + new BLL.Common().GetList("select dbo.getUserName_fu('" + impDT.Rows[i]["implementers_sid"].ToString().Trim() + "')").Tables[0].Rows[0][0] + "</th>";
//str2 += "<th data-options=\"field:'imp" + impDT.Rows[i]["sid"].ToString().Trim() + "',width:100, halign:'center', align:'center'\" >" + impDT.Rows[i]["implementers"].ToString().Trim() + "</th>";
//str2 += "{field:'imp" + impDT.Rows[i]["sid"].ToString().Trim() + "',title:'" + impDT.Rows[i]["implementers"].ToString().Trim() + "',width:100, halign:'center', align:'center'},";
}
}
else
{
str0 += "<th ></th>";
if (isConstruction == "1")
{
str1 += "<th colspan='1'></th>";
}
else
{
str1 += "<th colspan='1' rowspan='2'></th>";
}
str2 += "<th data-options=\"field:''\"></th>";
}
string monthstr = "";
string cols = "1";
if (dt.Rows[0]["begin_date"].ToString().Trim() != "" && dt.Rows[0]["end_date"].ToString().Trim() != "" && dt.Rows[0]["begin_date"] != null && dt.Rows[0]["end_date"] != null)
{
DateTime sDate = DateTime.Parse(dt.Rows[0]["begin_date"].ToString().Trim());
DateTime eDate = DateTime.Parse(dt.Rows[0]["end_date"].ToString().Trim());
TimeSpan ts = eDate.AddDays(1).Subtract(sDate);
if (sDate.Month == eDate.Month)
{
monthstr = sDate.Month.ToString() + "月";
}
else
{
monthstr = sDate.Month.ToString() + "-" + eDate.Month.ToString() + "月";
}
cols = ts.Days.ToString();
//string widthstr = (int.Parse(cols) * 30).ToString();
for (int i = 0; i < ts.Days; i++)
{
str3 += "<th colspan='1' >" + sDate.AddDays(i).Day.ToString() + "</th>";
//str3 += "{title:'" + sDate.AddDays(i).Day.ToString() + "'},";
string w = "";
switch (sDate.AddDays(i).DayOfWeek)
{
case DayOfWeek.Sunday:
w = "日";
break;
case DayOfWeek.Monday:
w = "一";
break;
case DayOfWeek.Tuesday:
w = "二";
break;
case DayOfWeek.Wednesday:
w = "三";
break;
case DayOfWeek.Thursday:
w = "四";
break;
case DayOfWeek.Friday:
w = "五";
break;
case DayOfWeek.Saturday:
w = "六";
break;
}
//str4 += "<th data-options=\"field:'" + sDate.AddDays(i).ToString("yyyy-MM-dd") + "',width:30,halign:'center',align:'center',styler: function(value,row,index){if(value==1){return 'background-color:yellow;'}else{return ''};},formatter: function(value,row,index){return '';}\" style='white-space:pre-wrap; word-wrap:break-word;'>" + w + "</th>";
str4 += "<th data-options=\"field:'flow_" + sDate.AddDays(i).ToString("yyyy-MM-dd") + "',width:30,halign:'center',align:'center',styler: function(value,row,index){var font='';if(row['flow_" + sDate.AddDays(i).ToString("yyyy-MM-dd") + "'].length>3){font='font-size:8px;';}if(row['" + sDate.AddDays(i).ToString("yyyy-MM-dd") + "']==1){return 'background-color:yellow;'+font}else if(row['" + sDate.AddDays(i).ToString("yyyy-MM-dd") + "']==2){return 'background-color:green;'+font}else{return ''}}\" style='white-space:pre-wrap; word-wrap:break-word;'>" + w + "</th>";
}
}
else
{
monthstr = "";
str3 = "<th data-options=\"title: '',rowspan:1\"}/>";
str4 = "<th data-options=\"title:'',field:'w',width:300\"}/>";
}
//int work_width = 200;
//int showCount = 15;
//if (int.Parse(cols) * 30 > 200)
//{
// work_width = int.Parse(cols) * 30;
// if (work_width > 200)
// {
// showCount = showCount + ((work_width - 200) * 3 / 30);
// }
//}
int work_width = 30;
int showCount = 2;
if (int.Parse(cols) * 30 > 30)
{
work_width = int.Parse(cols) * 30;
if (work_width > 30)
{
showCount = showCount + ((work_width - 30) * 2 / 30);
}
}
string content = "";
string item = "";
bool showContent = true;
bool showItem = true;
bool showGroup = true;
bool showStage = true;
string showWorkTitle = "";
string widthContent = "200";
string widthItem = "200";
switch (isConstruction)
{
case "0":
content = "工作内容";
item = "细目";
string workTitle = monthstr + "(黄色色块代表完成这项工作所需要的完成时间,计划表中实际完成时间将用绿色色块做标记)";
showWorkTitle = "";
for (int i = 0; i < workTitle.Length; i++)
{
showWorkTitle += workTitle[i];
if ((i + 1) % showCount == 0)
{
showWorkTitle += "<br/>";
}
}
break;
case "1":
content = "空间";
item = "图纸及索引号";
showGroup = false;
string flow = "";
DataTable tmpDT = new DataTable();
DataSet tmpDS = new BLL.project_work_flow().GetList(" s_sid='" + pssid + "'");
if (tmpDS.Tables.Count > 0)
{
tmpDT = tmpDS.Tables[0];
}
for (int i = 0; i < tmpDT.Rows.Count; i++)
{
flow += (i + 1).ToString() + "." + tmpDT.Rows[i]["work_flow_name"].ToString().Trim() + ",";
}
workTitle = monthstr + "(施工图立面框架" + flow + "(计划表中实际完成时间将用绿色色块做的标志))";
showWorkTitle = "";
for (int i = 0; i < workTitle.Length; i++)
{
showWorkTitle += workTitle[i];
if ((i + 1) % showCount == 0)
{
showWorkTitle += "<br/>";
}
}
break;
case "2":
showGroup = false;
content = "货物类别";
item = "工作细目";
showWorkTitle = monthstr;
break;
case "3":
content = "商品类别";
item = "细目";
workTitle = "智创产品逐个跟踪+" + pname;
for (int i = 0; i < workTitle.Length; i++)
{
showWorkTitle += workTitle[i];
if ((i + 1) % showCount == 0)
{
showWorkTitle += "<br/>";
}
}
showStage = false;
showGroup = false;
showContent = false;
widthItem = "100";
break;
case "4":
content = "加工类别";
item = "工作细目";
workTitle = monthstr + "(进程计划)";
for (int i = 0; i < workTitle.Length; i++)
{
showWorkTitle += workTitle[i];
if ((i + 1) % showCount == 0)
{
showWorkTitle += "<br/>";
}
}
showStage = false;
showGroup = false;
widthContent = "80";
widthItem = "100";
break;
default:
break;
}
trStr += "<thead data-options='frozen:true'>";
trStr += "<tr>";
if (isConstruction == "3")
{
trStr += "<th rowspan='3' data-options='field:\"number\",width:60, halign:\"center\", align:\"center\"'>图纸编号 </th>";
trStr += "<th rowspan='1' colspan='4' style='width:200px'>细目</th>";
trStr += "<th rowspan='3' data-options='field:\"useSpace\",width:60, halign:\"center\", align:\"center\"'>应用空间 </th>";
trStr += "<th rowspan='3' data-options='field:\"spaceCount\",width:60, halign:\"center\", align:\"center\"'>应用数量</th>";
trStr += "<th rowspan='3' data-options='field:\"install\",width:60, halign:\"center\", align:\"center\"'>安装位置</th>";
trStr += "<th rowspan='3' data-options='field:\"usePart\",width:60, halign:\"center\", align:\"center\"'>应用部位</th>";
trStr += "<th rowspan='3' data-options='field:\"unit\",width:60, halign:\"center\", align:\"center\"'>单位 </th>";
trStr += "<th rowspan='3' data-options='field:\"amount\",width:60, halign:\"center\", align:\"center\"'>数量</th>";
trStr += "<th rowspan='3' data-options='field:\"paintPaletteNumber\",width:60, halign:\"center\", align:\"center\"'>油漆色板编号 </th>";
trStr += "<th rowspan='3' data-options='field:\"ppiRemark\",width:60, halign:\"center\", align:\"center\"'>备注</th>";
}
if (isConstruction == "4")
{
trStr += "<th rowspan='3' data-options='field:\"number\",width:60, halign:\"center\", align:\"center\"'>图纸编号 </th>";
trStr += "<th rowspan='1' colspan='4' style='width:200px'>细目</th>";
trStr += "<th rowspan='3' data-options='field:\"useSpace\",width:60, halign:\"center\", align:\"center\"'>应用空间 </th>";
trStr += "<th rowspan='3' data-options='field:\"usePart\",width:60, halign:\"center\", align:\"center\"'>应用部位</th>";
trStr += "<th rowspan='3' data-options='field:\"unit\",width:60, halign:\"center\", align:\"center\"'>单位 </th>";
trStr += "<th rowspan='3' data-options='field:\"amount\",width:60, halign:\"center\", align:\"center\"'>数量</th>";
trStr += "<th rowspan='3' data-options='field:\"EndProduct\",width:60, halign:\"center\", align:\"center\"'>成品</th>";
trStr += "<th rowspan='3' data-options='field:\"ppiRemark\",width:60, halign:\"center\", align:\"center\"'>备注</th>";
}
if (showGroup)
{
trStr += "<th data-options=\"field:'group_name',width:50, halign: 'center', align: 'center',styler: function(value,row,index){return 'background-color:white;';}\" rowspan='3'>小组</th>";
}
if (showContent)
{
trStr += "<th data-options='field:\"contentName\",width:" + widthContent + ", halign: \"center\", styler: function(value,row,index){return \"background-color:white;\";},formatter: function (value, rowData, rowIndex) {var str=\"<a class=\\\"a_black\\\" title=\\\"\" + value + \"\\\"><span class=\\\"mlength\\\">\" + value + \"</span></a>\";return str;}' rowspan='3' >" + content + "</th>";
}
trStr += "<th data-options='field:\"itemName\",width:" + widthItem + ", halign: \"center\" ,formatter: function (value, rowData, rowIndex) {var str=\"<a class=\\\"a_black\\\" title=\\\"\" + value + \"\\\"><span class=\\\"mlength\\\">\" + value + \"</span></a>\";return str;}' rowspan='3'>" + item + "</th>";
trStr += "</tr>";
if (isConstruction == "3")
{
trStr += "<tr>";
trStr += "<th colspan='1' rowspan='2' data-options='field:\"productName\",width:60, halign:\"center\", align:\"center\"'>项目产品名称 </th>";
trStr += "<th colspan='1' rowspan='2' data-options='field:\"productPic\",width:45, halign:\"center\", align:\"center\",formatter: function (value, rowData, rowIndex) {if (value != \"\") { return \"<a path=\\\"/ProductPic/\" + value +\"\\\" class=\\\"preview\\\"><img alt=\\\"\\\" height=\\\"45px\\\" src=\\\"/ProductPic/\" + value + \"\\\"></a>\";}}'>图片 </th>";
trStr += "<th colspan='1' rowspan='2' data-options='field:\"Specifications\",width:55, halign:\"center\", align:\"center\"'>图纸规格 </th>";
trStr += "<th rowspan='2' data-options='field:\"paintColor\",width:60, halign:\"center\", align:\"center\"'>漆面颜色 </th>";
trStr += "</tr>";
}
if (isConstruction == "4")
{
trStr += "<tr>";
trStr += "<th colspan='1' rowspan='2' data-options='field:\"productName\",width:60, halign:\"center\", align:\"center\"'>项目产品名称 </th>";
trStr += "<th colspan='1' rowspan='2' data-options='field:\"productPic\",width:45, halign:\"center\", align:\"center\",formatter: function (value, rowData, rowIndex) {if (value != \"\") { return \"<a path=\\\"/ProductPic/\" + value +\"\\\" class=\\\"preview\\\"><img alt=\\\"\\\" height=\\\"45px\\\" src=\\\"/ProductPic/\" + value + \"\\\"></a>\";}}'>图片 </th>";
trStr += "<th colspan='1' rowspan='2' data-options='field:\"Specifications\",width:55, halign:\"center\", align:\"center\"'>图纸规格 </th>";
trStr += "<th rowspan='2' data-options='field:\"paintColor\",width:60, halign:\"center\", align:\"center\"'>漆面颜色 </th>";
trStr += "</tr>";
}
trStr += "</thead>";
trStr += "<thead>";
trStr += "<tr>";
trStr += "<th colspan='1'>月</th>";
trStr += "<th colspan='" + cols + "' >" + showWorkTitle + "</th>";
trStr += str1;
trStr += "<th data-options='field:\"header\",width:150, halign:\"center\", align:\"center\"' rowspan='3'>组长审核人</th>";
trStr += "<th data-options='field:\"review_results\",width:150, halign:\"center\", align:\"center\",formatter:function(value,rowData,rowIndex){var str=\"\";var s=rowData[\"reviewer\"]; switch(value){case\"0\":str+=\"<div style=\\\"color:Red;\\\">未完成(\"+s+\")</div>\";break;case\"1\":str+=\"<div style=\\\"color:Green;\\\">完成(\"+s+\")</div>\";break;} return str;}' rowspan='3'>组长审核结果</th>";
trStr += "<th data-options=\"field:'unfinished_reason',width:150, halign: 'center', align: 'center'\" rowspan='3'>未完成的原因</th>";
trStr += "<th data-options=\"field:'solution',width:150, halign: 'center', align: 'center'\" rowspan='3'>解决的办法</th>";
trStr += "<th data-options=\"field:'reviewed',width:150, halign: 'center', align: 'center'\" rowspan='3'>解决的结果</th>";
trStr += "<th data-options='field:\"finaler\",width:150, halign:\"center\", align:\"center\"' rowspan='3'>总审人</th>";
trStr += "<th data-options='field:\"reviews\",width:150, halign: \"center\",formatter: function (value, rowData, rowIndex) {var arr=value.split(\",\"); var ReviewDates = rowData[\"ReviewDates\"].split(\",\");var str=\"\";for(var i=0;i<arr.length;i++){switch (arr[i]) {case \"0\":break;case \"1\":str+=\"<img title=\\\"审核时间：\"+ReviewDates[i]+\" 结果：优\\\" width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_green.png\\\"/> \";break;case \"2\":str+=\"<img title=\\\"审核时间：\"+ReviewDates[i]+\" 结果：良\\\" width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_yellow.png\\\" /> \";break;case \"3\":str+=\"<img title=\\\"审核时间：\"+ReviewDates[i]+\" 结果：差\\\" width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_orange.png\\\" /> \";break;case \"4\":str+=\"<img title=\"+ReviewDates[i]+\" width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_red.png\\\" /> \";break;case \"5\":str+=\"<img title=\\\"审核时间：\"+ReviewDates[i]+\" 结果：不及格\\\" width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_error.png\\\"/> \";break;default:break;}} return str;}' rowspan='3'>总审结果</th>";
trStr += "<th data-options=\"field:'wtype9',width:150, halign: 'center', align: 'center'\" rowspan='3'>备注</th>";
trStr += "</tr>";
trStr += "<tr>";
trStr += "<th colspan='1'>日</th>";
trStr += str3;
trStr += "</tr>";
trStr += "<tr>";
trStr += "<th data-options=\"field:'wtype11',width:35, halign: 'center', align: 'center',styler: function(value,row,index){return 'background-color:lightgray;color:lightgray;';}\">星期</th>";
trStr += str4;
trStr += str2;
trStr += "</tr>";
trStr += "</thead>";
//if (isConstruction=="1")
//{
// string flow = "";
// DataTable tmpDT = new DataTable();
// DataSet tmpDS = new BLL.project_work_flow().GetList(" s_sid='" + pssid + "'");
// if (tmpDS.Tables.Count > 0)
// {
// tmpDT = tmpDS.Tables[0];
// }
// for (int i = 0; i < tmpDT.Rows.Count; i++)
// {
// flow += (i + 1).ToString() + "." + tmpDT.Rows[i]["work_flow_name"].ToString().Trim() + ",";
// }
// string workTitle = monthstr + "(施工图立面框架" + flow + "(计划表中实际完成时间将用绿色色块做的标志))";
// string showWorkTitle = "";
// for (int i = 0; i < workTitle.Length; i++)
// {
// showWorkTitle += workTitle[i];
// if ((i + 1) % showCount == 0)
// {
// showWorkTitle += "<br/>";
// }
// }
// trStr += "<thead data-options='frozen:true'>";
// trStr += "<tr>";
// trStr += "<th data-options='field:\"contentName\",width:150, halign: \"center\", styler: function(value,row,index){return \"background-color:white;\";},formatter: function (value, rowData, rowIndex) {var str=\"<a class=\\\"a_black\\\" title=\\\"\" + value + \"\\\"><span class=\\\"mlength\\\">\" + value + \"</span></a>\";return str;}' rowspan='3' >空间</th>";
// trStr += "<th data-options='field:\"itemName\",width:150, halign: \"center\" ,formatter: function (value, rowData, rowIndex) {var str=\"<a class=\\\"a_black\\\" title=\\\"\" + value + \"\\\"><span class=\\\"mlength\\\">\" + value + \"</span></a>\";return str;}' rowspan='3'>图纸及索引</th>";
// trStr += "</tr>";
// trStr += "</thead>";
// trStr += "<thead>";
// trStr += "<tr>";
// trStr += "<th colspan='1'>月</th>";
// trStr += "<th colspan='" + cols + "'>" + showWorkTitle + "</th>";
// trStr += str1;
// trStr += "<th data-options='field:\"header\",width:150, halign:\"center\", align:\"center\"' rowspan='3'>组长审核人</th>";
// trStr += "<th data-options='field:\"review_results\",width:150, halign:\"center\", align:\"center\",formatter:function(value,rowData,rowIndex){var str=\"\";var s=rowData[\"reviewer\"]; switch(value){case\"0\":str+=\"<div style=\\\"color:Red;\\\">未完成(\"+s+\")</div>\";break;case\"1\":str+=\"<div style=\\\"color:Green;\\\">完成(\"+s+\")</div>\";break;} return str;}' rowspan='3'>组长审核结果</th>";
// trStr += "<th data-options=\"field:'unfinished_reason',width:150, halign: 'center', align: 'center'\" rowspan='3'>未完成的原因</th>";
// trStr += "<th data-options=\"field:'solution',width:150, halign: 'center', align: 'center'\" rowspan='3'>解决的办法</th>";
// trStr += "<th data-options=\"field:'reviewed',width:150, halign: 'center', align: 'center'\" rowspan='3'>解决的结果</th>";
// trStr += "<th data-options='field:\"finaler\",width:150, halign:\"center\", align:\"center\"' rowspan='3'>总审人</th>";
// trStr += "<th data-options='field:\"reviews\",width:150, halign: \"center\",formatter: function (value, rowData, rowIndex) {var arr=value.split(\",\"); var ReviewDates = rowData[\"ReviewDates\"].split(\",\");var str=\"\";for(var i=0;i<arr.length;i++){switch (arr[i]) {case \"0\":break;case \"1\":str+=\"<img title=\\\"审核时间：\"+ReviewDates[i]+\" 结果：优\\\" width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_green.png\\\"/> \";break;case \"2\":str+=\"<img title=\\\"审核时间：\"+ReviewDates[i]+\" 结果：良\\\" width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_yellow.png\\\" /> \";break;case \"3\":str+=\"<img title=\\\"审核时间：\"+ReviewDates[i]+\" 结果：差\\\" width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_orange.png\\\" /> \";break;case \"4\":str+=\"<img title=\"+ReviewDates[i]+\" width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_red.png\\\" /> \";break;case \"5\":str+=\"<img title=\\\"审核时间：\"+ReviewDates[i]+\" 结果：不及格\\\" width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_error.png\\\"/> \";break;default:break;}} return str;}' rowspan='3'>总审结果</th>";
// trStr += "<th data-options=\"field:'wtype9',width:150, halign: 'center', align: 'center'\" rowspan='3'>备注</th>";
// trStr += "</tr>";
// trStr += "<tr>";
// trStr += "<th colspan='1'>日</th>";
// trStr += str3;
// trStr += str0;
// trStr += "</tr>";
// trStr += "<tr>";
// trStr += "<th data-options=\"field:'wtype11',width:35, halign: 'center', align: 'center',styler: function(value,row,index){return 'background-color:lightgray;color:lightgray;';}\">星期</th>";
// trStr += str4;
// trStr += str2;
// trStr += "</tr>";
// trStr += "</thead>";
//}
//else
//{
// string workTitle = monthstr + "(黄色色块代表完成这项工作所需要的完成时间，计划表中实际完成时间将用绿色色块做标记)";
// string showWorkTitle = "";
// for (int i = 0; i < workTitle.Length; i++)
// {
// showWorkTitle += workTitle[i];
// if ((i + 1) % showCount == 0)
// {
// showWorkTitle += "<br/>";
// }
// }
// trStr += "<thead data-options='frozen:true'>";
// trStr += "<tr>";
// trStr += "<th data-options=\"field:'group_name',width:50, halign: 'center', align: 'center',styler: function(value,row,index){return 'background-color:white;';}\" rowspan='3'>小组</th>";
// trStr += "<th data-options='field:\"contentName\",width:150, halign: \"center\", styler: function(value,row,index){return \"background-color:white;\";},formatter: function (value, rowData, rowIndex) {var str=\"<a class=\\\"a_black\\\" title=\\\"\" + value + \"\\\"><span class=\\\"mlength\\\">\" + value + \"</span></a>\";return str;}' rowspan='3' >工作内容</th>";
// trStr += "<th data-options='field:\"itemName\",width:150, halign: \"center\" ,formatter: function (value, rowData, rowIndex) {var str=\"<a class=\\\"a_black\\\" title=\\\"\" + value + \"\\\"><span class=\\\"mlength\\\">\" + value + \"</span></a>\";return str;}' rowspan='3'>细目</th>";
// trStr += "</tr>";
// trStr += "</thead>";
// trStr += "<thead>";
// trStr += "<tr>";
// trStr += "<th colspan='1'>月</th>";
// trStr += "<th colspan='" + cols + "' >" + showWorkTitle + "</th>";
// trStr += str1;
// trStr += "<th data-options='field:\"header\",width:150, halign:\"center\", align:\"center\"' rowspan='3'>组长审核人</th>";
// trStr += "<th data-options='field:\"review_results\",width:150, halign:\"center\", align:\"center\",formatter:function(value,rowData,rowIndex){var str=\"\";var s=rowData[\"reviewer\"]; switch(value){case\"0\":str+=\"<div style=\\\"color:Red;\\\">未完成(\"+s+\")</div>\";break;case\"1\":str+=\"<div style=\\\"color:Green;\\\">完成(\"+s+\")</div>\";break;} return str;}' rowspan='3'>组长审核结果</th>";
// trStr += "<th data-options=\"field:'unfinished_reason',width:150, halign: 'center', align: 'center'\" rowspan='3'>未完成的原因</th>";
// trStr += "<th data-options=\"field:'solution',width:150, halign: 'center', align: 'center'\" rowspan='3'>解决的办法</th>";
// trStr += "<th data-options=\"field:'reviewed',width:150, halign: 'center', align: 'center'\" rowspan='3'>解决的结果</th>";
// trStr += "<th data-options='field:\"finaler\",width:150, halign:\"center\", align:\"center\"' rowspan='3'>总审人</th>";
// trStr += "<th data-options='field:\"reviews\",width:150, halign: \"center\",formatter: function (value, rowData, rowIndex) {var arr=value.split(\",\"); var ReviewDates = rowData[\"ReviewDates\"].split(\",\");var str=\"\";for(var i=0;i<arr.length;i++){switch (arr[i]) {case \"0\":break;case \"1\":str+=\"<img title=\\\"审核时间：\"+ReviewDates[i]+\" 结果：优\\\" width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_green.png\\\"/> \";break;case \"2\":str+=\"<img title=\\\"审核时间：\"+ReviewDates[i]+\" 结果：良\\\" width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_yellow.png\\\" /> \";break;case \"3\":str+=\"<img title=\\\"审核时间：\"+ReviewDates[i]+\" 结果：差\\\" width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_orange.png\\\" /> \";break;case \"4\":str+=\"<img title=\"+ReviewDates[i]+\" width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_red.png\\\" /> \";break;case \"5\":str+=\"<img title=\\\"审核时间：\"+ReviewDates[i]+\" 结果：不及格\\\" width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_error.png\\\"/> \";break;default:break;}} return str;}' rowspan='3'>总审结果</th>";
// trStr += "<th data-options=\"field:'wtype9',width:150, halign: 'center', align: 'center'\" rowspan='3'>备注</th>";
// trStr += "</tr>";
// trStr += "<tr>";
// trStr += "<th colspan='1'>日</th>";
// trStr += str3;
// trStr += "</tr>";
// trStr += "<tr>";
// trStr += "<th data-options=\"field:'wtype11',width:35, halign: 'center', align: 'center',styler: function(value,row,index){return 'background-color:lightgray;color:lightgray;';}\">星期</th>";
// trStr += str4;
// trStr += str2;
// trStr += "</tr>";
// trStr += "</thead>";
//}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
pssid = Request.Params["ps_sid"] == null ? "" : Request.Params["ps_sid"].Trim();
DataTable dt = new DataTable();
DataSet ds = new BLL.Common().GetList("select project.sid as psid, project_name,project_code,stage_name,begin_date,end_date from project_stage left outer join project on project_stage.p_sid=project.sid where project_stage.sid='" + pssid + "'");
if (ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
if (dt.Rows.Count > 0)
{
pname = dt.Rows[0]["project_name"].ToString().Trim();
pcode = dt.Rows[0]["project_code"].ToString().Trim();
stageName = dt.Rows[0]["stage_name"].ToString().Trim();
pModel = new BLL.project().GetModel(int.Parse(dt.Rows[0]["psid"].ToString().Trim()));
string str1 = "", str2 = "", str3 = "", str4 = "";
DataTable impDT = new DataTable();
DataSet impDS = new BLL.project_implement().GetList(" s_sid='" + pssid + "'");
if (impDS.Tables.Count > 0)
{
impDT = impDS.Tables[0];
}
for (int i = 0; i < impDT.Rows.Count; i++)
{
str1 += "<th colspan='1' rowspan='2' >" + impDT.Rows[i]["implement_name"].ToString().Trim() + "</th>";
//str1 += "{title:'" + impDT.Rows[i]["implement_name"].ToString().Trim() + "',rowspan:2},";
//str1 += "<th colspan='1' rowspan='2' ></th>";
str2 += "<th data-options=\"field:'imp" + impDT.Rows[i]["sid"].ToString().Trim() + "',width:100, halign:'center', align:'center'\" >" + impDT.Rows[i]["implementers"].ToString().Trim() + "</th>";
//str2 += "{field:'imp" + impDT.Rows[i]["sid"].ToString().Trim() + "',title:'" + impDT.Rows[i]["implementers"].ToString().Trim() + "',width:100, halign:'center', align:'center'},";
}
DateTime sDate = DateTime.Parse(dt.Rows[0]["begin_date"].ToString().Trim());
DateTime eDate = DateTime.Parse(dt.Rows[0]["end_date"].ToString().Trim());
TimeSpan ts = eDate.AddDays(1).Subtract(sDate);
string monthstr = "";
if (sDate.Month == eDate.Month)
{
monthstr = sDate.Month.ToString() + "月";
}
else
{
monthstr = sDate.Month.ToString() + "-" + eDate.Month.ToString() + "月";
}
string cols = ts.Days.ToString();
//string widthstr = (int.Parse(cols) * 30).ToString();
for (int i = 0; i < ts.Days; i++)
{
str3 += "<th colspan='1' >" + sDate.AddDays(i).Day.ToString() + "</th>";
//str3 += "{title:'" + sDate.AddDays(i).Day.ToString() + "'},";
string w = "";
switch (sDate.AddDays(i).DayOfWeek)
{
case DayOfWeek.Sunday:
w = "日";
break;
case DayOfWeek.Monday:
w = "一";
break;
case DayOfWeek.Tuesday:
w = "二";
break;
case DayOfWeek.Wednesday:
w = "三";
break;
case DayOfWeek.Thursday:
w = "四";
break;
case DayOfWeek.Friday:
w = "五";
break;
case DayOfWeek.Saturday:
w = "六";
break;
}
//str4 += "<th data-options=\"field:'" + sDate.AddDays(i).ToString("yyyy-MM-dd") + "',width:30,halign:'center',align:'center',styler: function(value,row,index){if(value==1){return 'background-color:yellow;'}else{return ''};},formatter: function(value,row,index){return '';}\" style='white-space:pre-wrap; word-wrap:break-word;'>" + w + "</th>";
str4 += "<th data-options=\"field:'" + sDate.AddDays(i).ToString("yyyy-MM-dd") + "',width:30,halign:'center',align:'center',styler: function(value,row,index){if(value==1){return 'background-color:yellow;'}else if(value==2){return 'background-color:green;'}else{return ''};},formatter: function(value,row,index){return '';}\" style='white-space:pre-wrap; word-wrap:break-word;'>" + w + "</th>";
//str4 += "{field:'" + sDate.AddDays(i).ToString("yyyy-MM-dd") + "',title:'" + w + "',width:30,halign:'center',align:'center',styler: function(value,row,index){if(value==1){return 'background-color:yellow;'}else{return ''};},formatter: function(value,row,index){return '';}},";
}
//trStr += "<thead>";
trStr += "<thead data-options='frozen:true'>";
trStr += "<tr>";
trStr += "<th data-options=\"field:'stage_name',width:50, halign: 'center', align: 'center',styler: function(value,row,index){return 'background-color:white;white-space:pre-wrap; word-wrap:break-word;';}\" rowspan='3'>阶段</th>";
trStr += "<th data-options=\"field:'group_name',width:50, halign: 'center', align: 'center',styler: function(value,row,index){return 'background-color:white;white-space:pre-wrap; word-wrap:break-word;';}\" rowspan='3'>小组</th>";
//trStr += "<th data-options=\"field:'contentName',width:150, halign: 'center', styler: function(value,row,index){return 'background-color:white;white-space:pre-wrap; word-wrap:break-word;';},formatter: function (value, rowData, rowIndex) {return '<span style=\'white-space:pre-wrap; word-wrap:break-word;\'>' + value + '</span>';}\" rowspan='3' >工作内容</th>";
trStr += "<th data-options=\"field:'contentName',width:150, halign: 'center', styler: function(value,row,index){return 'background-color:white;white-space:pre-wrap; word-wrap:break-word;';}\" rowspan='3' >工作内容</th>";
trStr += "<th data-options='field:\"itemName\",width:150, halign: \"center\" ,formatter: function (value, rowData, rowIndex) {var str=\"<a class=\\\"a_black\\\" title=\\\"\" + value + \"\\\"><span class=\\\"mlength\\\">\" + value + \"</span></a>\";return str;}' rowspan='3'>细目</th>";
trStr += "</tr>";
trStr += "</thead>";
trStr += "<thead>";
trStr += "<tr>";
trStr += "<th colspan='1'>月</th>";
trStr += "<th colspan='" + cols + "'>" + monthstr + "(黄色色块代表完成这项工作所需要的完成时间，<br/>计划表中实际完成时间将用绿色色块做标记)</th>";
trStr += str1;
//trStr += "<th data-options=\"field:'reviews',width:150, halign: 'center',formatter: function (value, rowData, rowIndex) {var arr=value.split(',');var str='';for(var i=0;i<arr.length;i++){switch (arr[i]) {case 0:break;case 1:str+='<img src=\"../Images/point/bullet_green.png\" />';break;case 2:str+='<img src=\"../Images/point/bullet_yellow.png\" />';break;case 3:str+='<img src=\"../Images/point/bullet_orange.png\" />';break;case 4:str+='<img src=\"../Images/point/bullet_red.png\" />';break;default:break;}}return str;}\" rowspan='3'>完成情况(按照公司设计质量标准评定:绿，黄，橙，红。四种工作完成状况)</th>";
//trStr += "<th data-options='field:\"reviews\",width:150, halign: \"center\",formatter: function (value, rowData, rowIndex) {var arr=value.split(\",\");var str=\"\";for(var i=0;i<arr.length;i++){switch (arr[i]) {case \"0\":break;case \"1\":str+=\"<div style=\\\"float:left\\\"><img src=\\\"../Images/point/bullet_green.png\\\"/></div>\";break;case \"2\":str+=\"<div style=\\\"float:left\\\"><img src=\\\"../Images/point/bullet_yellow.png\\\" /></div>\";break;case \"3\":str+=\"<div style=\\\"float:left\\\"><img src=\\\"../Images/point/bullet_orange.png\\\" /></div>\";break;case \"4\":str+=\"<div style=\\\"float:left\\\"><img src=\\\"../Images/point/bullet_red.png\\\" /></div>\";break;default:break;}} return str;}' rowspan='3'>完成情况(按照公司设计质量标准评定:绿，黄，橙，红。四种工作完成状况)</th>";
trStr += "<th data-options='field:\"reviews\",width:150, halign: \"center\",formatter: function (value, rowData, rowIndex) {var arr=value.split(\",\");var str=\"\";for(var i=0;i<arr.length;i++){switch (arr[i]) {case \"0\":break;case \"1\":str+=\"<img width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_green.png\\\"/> \";break;case \"2\":str+=\"<img width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_yellow.png\\\" /> \";break;case \"3\":str+=\"<img width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_orange.png\\\" /> \";break;case \"4\":str+=\"<img width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_red.png\\\" /> \";break;default:break;}} return str;}' rowspan='3'>完成情况(按照公司设计质量标准评定:绿，黄，橙，红。四种工作完成状况)</th>";
trStr += "<th data-options=\"field:'wtype7',width:150, halign: 'center', align: 'center'\" rowspan='3'>未完成的原因</th>";
trStr += "<th data-options=\"field:'wtype8',width:150, halign: 'center', align: 'center'\" rowspan='3'>解决的办法</th>";
trStr += "<th data-options=\"field:'wtype9',width:150, halign: 'center', align: 'center'\" rowspan='3'>备注</th>";
trStr += "</tr>";
trStr += "<tr>";
trStr += "<th colspan='1'>日</th>";
trStr += str3;
trStr += "</tr>";
trStr += "<tr>";
trStr += "<th data-options=\"field:'wtype11',width:35, halign: 'center', align: 'center',styler: function(value,row,index){return 'background-color:lightgray;color:lightgray;';}\">星期</th>";
trStr += str4;
trStr += str2;
trStr += "</tr>";
trStr += "</thead>";
//tr.Text = trStr;
//trStr += "[[";
//trStr += "{field:'stage_name',title:'阶段',width:50, halign: 'center', align: 'center',rowspan:3,styler: function(value,row,index){return 'background-color:white;';}},";
//trStr += "{field:'group_name',title:'小组',width:50, halign: 'center', align: 'center',rowspan:3,styler: function(value,row,index){return 'background-color:white;';}},";
//trStr += "{field:'contentName',title:'工作内容',width:150, halign: 'center',rowspan:3,styler: function(value,row,index){return 'background-color:white;';},formatter: function (value, rowData, rowIndex) {return '<a>' + value + '</a>';}},";
//trStr += "{field:'itemName',title:'细目',width:150, halign: 'center',rowspan:3},";
//trStr += "{field:'m',title:'月'},";
//trStr += "{title:'" + monthstr + "(黄色色块代表完成这项工作所需要的完成时间，<br/>计划表中实际完成时间将用绿色色块做标记)',colspan:" + cols + "},";
//trStr += "{field:'wtype6',title:'完成情况(按照公司设计质量标准评定:绿，黄，橙，红。四种工作完成状况)',width:150, halign: 'center',rowspan:3},";
//trStr += "{field:'wtype7',title:'未完成的原因',width:150, halign: 'center',rowspan:3},";
//trStr += "{field:'wtype8',title:'解决的办法',width:150, halign: 'center',rowspan:3},";
//trStr += "{field:'wtype9',title:'备注',width:150, halign: 'center',rowspan:3}";
//trStr += "],[";
//trStr += "{field:'d',title:'日'},";
//trStr += str3.Substring(0, str3.Length - 1);
//trStr += "],[";
//trStr += "{field:'wtype11',title:'星期',width:35, halign: 'center', align: 'center',styler: function(value,row,index){return 'background-color:lightgray;color:lightgray;';}},";
//trStr += str4;
//trStr += str2.Substring(0, str2.Length - 1);
//trStr += "]]";
}
}
}
