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 += "]]";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
pssid = Request.Params["ps_sid"] == null ? "" : Request.Params["ps_sid"].Trim();
isConstruction = Request.Params["isConstruction"] == null ? "" : Request.Params["isConstruction"].Trim();
isView = Request.Params["isView"] == null ? "0" : Request.Params["isView"].Trim();
stageName = DBUtility.DbHelperSQL.GetSingle("select stage_name from stage where sid=" + pssid).ToString().Trim();
//动态添加实施列
string dynamicColumn = "";
DataTable impDT = new DataTable();
DataSet impDS = new DAL.project_stage_implement_model().GetList(" s_sid='" + pssid + "' order by sequence");//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 calendarStr = "";
string showGroup = "true";
switch (isConstruction)
{
case "1":
showContent = "空间";
showItem = "图纸及索引号";
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() + ",";
}
calendarStr = "(施工图立面框架" + flow + "(计划表中实际完成时间将用绿色色块做的标志))";
//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: 200,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 += "]]";
break;
case "0":
showContent = "工作内容";
showItem = "细目";
calendarStr = "(黄色色块代表完成这项工作所需要的完成时间，计划表中实际完成时间将用绿色色块做标记)";
showGroup = "false";
//column += "[[";
//column += "{ title: '小组', field: 'group_name', width: 60, rowspan:3, halign: 'center', align: 'center'},";
//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: '(黄色色块代表完成这项工作所需要的完成时间，计划表中实际完成时间将用绿色色块做标记)', 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 += "]]";
break;
case "2":
showContent = "货物类别";
showItem = "工作细目";
calendarStr = "工作日历";
break;
case "3":
showContent = "加工类别";
showItem = "内容";
calendarStr = "进程计划";
break;
default:
break;
}
column += "[[";
column += "{ title: '小组', field: 'group_name', width: 60, rowspan:3, halign: 'center', align: 'center',hidden:" + showGroup + "},";
column += "{ title: '" + showContent + "', 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: '" + showItem + "', 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: '" + calendarStr + "', field: 'tmp',width: 200,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 += "]]";
}
}
