protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { pssid = Request.Params["ps_sid"] == null ? "" : Request.Params["ps_sid"].Trim(); stageName = DBUtility.DbHelperSQL.GetSingle("select stage_name from stage where sid=" + pssid).ToString().Trim(); //动态添加实施列 string dynamicColumn = ""; DataTable impDT = new DataTable(); DataSet impDS = new BLL.project_stage_implement_model().GetList(" s_sid='" + pssid + "'"); if (impDS.Tables.Count > 0) { impDT = impDS.Tables[0]; } for (int i = 0; i < impDT.Rows.Count; i++) { dynamicColumn += "{field:'" + "imp" + impDT.Rows[i]["sid"].ToString().Trim() + "',title:'" + impDT.Rows[i]["implement_name"].ToString().Trim() + "',width:80,rowspan:3,align:'center',halign: 'center'},"; } string flow = ""; DataTable tmpDT = new DataTable(); DataSet tmpDS = new BLL.project_stage_work_flow_model().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() + ","; } column += "[["; column += "{ title: '空间', field: 'contentName', width: 200, rowspan:3,halign: 'center',formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + value + '\\\"><span class=\\\"mlength\\\">' + value + '</span></a>';}},"; column += "{ title: '图纸及索引号', field: 'itemName', width: 200,rowspan:3, halign: 'center',formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + value + '\\\"><span class=\\\"mlength\\\">' + value + '</span></a>';}},"; column += "{ title: '月'},"; column += "{ title: '(施工图立面框架"+flow+"(计划表中实际完成时间将用绿色色块做的标志))', field: 'tmp',width: 150,rowspan:3},"; column += dynamicColumn; column += "{ title: '组长审核', field: 'v1', width: 60,rowspan:3, halign: 'center', align: 'center'},"; column += "{ title: '未完成的原因', field: 'unfinished_reason', width: 60,rowspan:3, sortable: true, halign: 'center', align: 'center'},"; column += "{ title: '解决的办法', field: 'solution', width: 60, rowspan:3,sortable: true, halign: 'center', align: 'center'},"; column += "{ title: '解决的结果', field: 'reviewed', width: 60, rowspan:3,sortable: true, halign: 'center', align: 'center'},"; column += "{ title: '总审', field: 'v2', width: 60, rowspan:3,sortable: true, halign: 'center', align: 'center'},"; column += "{ title: '备注', field: 'remark', width: 60, rowspan:3,halign: 'center', editor: 'text',formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + value + '\\\"><span class=\\\"mlength\\\">' + value + '</span></a>';}}"; column += "],"; column += "["; column += "{ title: '日'}"; column += "],["; column += "{ title: '星期', field: 'week',styler: function(value,row,index){return 'background-color:lightgray;color:lightgray;';}}"; column += "]]"; } }
private string ContentList(HttpContext context) { DataTable dt = new DataTable(); //DataSet ds = new BLL.Common().GetList("select row_number()over (order by b.sequence) as rowid, a.sid,b.sid as csid,c.stage_name,d.group_name,b.name as contentName,a.name as itemName,a.unfinished_reason,a.solution,a.reviewed,a.remark,'' [week],'' tmp,a.v1,a.v2,a.sequence as itemSequence,b.sequence as contentSequence,b.remark as cremark,b.group_sid,a.parent_sid from project_specific_item_model b left outer join project_specific_item_model a on a.parent_sid=b.sid left outer join stage c on b.s_sid=c.sid left outer join project_stage_group_model d on b.group_sid=d.sid where b.s_sid=" + context.Request.Params["pssid"].Trim() + " and b.ischild=0 order by d.sequence asc, b.sequence asc, a.sequence asc"); DataSet ds = new BLL.Common().GetList("select row_number()over (order by b.sequence) as rowid, a.sid,b.sid as csid,c.stage_name,d.group_name,b.name as contentName,a.name as itemName,a.unfinished_reason,a.solution,a.reviewed,a.remark,'' [week],'' tmp,a.v1,a.v2,a.sequence as itemSequence,b.sequence as contentSequence,b.remark as cremark,b.group_sid,a.parent_sid from project_specific_item_model b left outer join project_specific_item_model a on a.parent_sid=b.sid left outer join stage c on b.s_sid=c.sid left outer join project_stage_group_model d on b.group_sid=d.sid where b.s_sid=" + context.Request.Params["pssid"].Trim() + " and b.ischild=0 order by b.sequence asc, a.sequence asc"); if (ds.Tables.Count > 0) { dt = ds.Tables[0]; } if (dt.Rows.Count > 0) { DataTable impDT = new DataTable(); DataSet impDS = new BLL.project_stage_implement_model().GetList(" s_sid='" + context.Request.Params["pssid"].Trim() + "'"); if (impDS.Tables.Count > 0) { impDT = impDS.Tables[0]; } for (int i = 0; i < impDT.Rows.Count; i++) { DataColumn datetimeColumn = new DataColumn(); //该列的数据类型 datetimeColumn.DataType = System.Type.GetType("System.String"); //该列得名称 datetimeColumn.ColumnName = "imp" + impDT.Rows[i]["sid"].ToString().Trim(); //该列得默认值 datetimeColumn.DefaultValue = ""; dt.Columns.Add(datetimeColumn); for (int j = 0; j < dt.Rows.Count; j++) { dt.Rows[j]["imp" + impDT.Rows[i]["sid"].ToString().Trim()] = ""; } } } return(DBUtility.JsonHelper.DataTable2Json_Datagrid(dt, dt.Rows.Count)); }