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 += "]]"; } } }