Exemplo n.º 1
0
        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>";
                }
            }
        }
Exemplo n.º 2
0
        private string ViewUserProject(HttpContext context)
        {
            DataTable dt = new DataTable();
            DataSet   ds = new BLL.Common().GetList(" select a.sid, c.stage_name,d.group_name,b.name as contentName,a.name as itemName,a.unfinished_reason,a.solution,a.remark,a.begin_date,a.end_date,c.begin_date as stage_sDate,c.end_date as stage_eDate,dbo.getProjectReview_fu(a.sid) as reviews,dbo.getProjectSubmitDate_fu(a.sid) as submitDate from project_specific_item a left outer join project_specific_item b on a.parent_sid=b.sid left outer join project_stage c on a.s_sid=c.sid left outer join project_group d on a.group_sid=d.sid where a.ischild=1 and a.s_sid=" + context.Request.Params["pssid"].Trim() + " order by a.s_sid asc, a.group_sid asc, a.parent_sid asc  ");

            if (ds.Tables.Count > 0)
            {
                dt = ds.Tables[0];
            }
            if (dt.Rows.Count > 0)
            {
                DateTime sDate = DateTime.Parse(dt.Rows[0]["stage_sDate"].ToString().Trim());
                DateTime eDate = DateTime.Parse(dt.Rows[0]["stage_eDate"].ToString().Trim());
                TimeSpan ts    = eDate.AddDays(1).Subtract(sDate);
                for (int i = 0; i < ts.Days; i++)
                {
                    DataColumn datetimeColumn = new DataColumn();
                    //该列的数据类型
                    datetimeColumn.DataType = System.Type.GetType("System.String");
                    //该列得名称
                    datetimeColumn.ColumnName = sDate.AddDays(i).ToString("yyyy-MM-dd");
                    //该列得默认值
                    datetimeColumn.DefaultValue = "0";



                    dt.Columns.Add(datetimeColumn);
                }
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    DateTime mysDate = DateTime.Parse(dt.Rows[i]["begin_date"].ToString().Trim());
                    DateTime myeDate = DateTime.Parse(dt.Rows[i]["end_date"].ToString().Trim());
                    TimeSpan myts    = myeDate.AddDays(1).Subtract(mysDate);
                    for (int j = 0; j < myts.Days; j++)
                    {
                        if (dt.Rows[i][mysDate.AddDays(j).ToString("yyyy-MM-dd")].ToString().Trim() == "0")
                        {
                            dt.Rows[i][mysDate.AddDays(j).ToString("yyyy-MM-dd")] = "1";
                        }
                    }
                }


                DataTable impDT = new DataTable();
                DataSet   impDS = new BLL.project_implement().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++)
                    {
                        DataTable impworkDT = new DataTable();
                        impDS = new BLL.project_work_implement().GetList("psi_sid='" + dt.Rows[j]["sid"] + "' and imp_sid='" + impDT.Rows[i]["sid"] + "'");
                        if (impDS.Tables.Count > 0)
                        {
                            impworkDT = impDS.Tables[0];
                            if (impworkDT.Rows.Count > 0)
                            {
                                dt.Rows[j]["imp" + impDT.Rows[i]["sid"].ToString().Trim()] = impworkDT.Rows[0]["implementer"].ToString().Trim();
                            }
                        }
                    }

                    string[] submitDate = dt.Rows[i]["submitDate"].ToString().Trim().Split(',');
                    for (int j = 0; j < submitDate.Length; j++)
                    {
                        try
                        {
                            for (int n = 0; n < ts.Days; n++)
                            {
                                if (sDate.AddDays(n).Date == DateTime.Parse(submitDate[j].Trim()).Date)
                                {
                                    dt.Rows[i][sDate.AddDays(n).ToString("yyyy-MM-dd")] = "2";
                                }
                            }
                        }
                        catch
                        {
                        }
                    }
                }
            }

            return(DBUtility.JsonHelper.DataTable2Json_Datagrid(dt, dt.Rows.Count));
        }
Exemplo n.º 3
0
        private string ContentViewItem(string pssid)
        {
            DataTable dt = new DataTable();
            DataSet   ds = new BLL.Common().GetList(" select a.sid, c.stage_name,d.group_name,b.name as contentName,a.name as itemName,dbo.getProjectReview_fu(a.sid) as reviews,a.unfinished_reason,a.solution,a.remark,a.begin_date,a.end_date,c.begin_date as stage_sDate,c.end_date as stage_eDate,dbo.getProjectSubmitDate_fu(a.sid) as submitDate from project_specific_item a left outer join project_specific_item b on a.parent_sid=b.sid left outer join project_stage c on a.s_sid=c.sid left outer join project_group d on a.group_sid=d.sid where a.ischild=1 and a.s_sid=" + pssid + " order by a.s_sid asc, a.group_sid asc, a.parent_sid asc  ");

            if (ds.Tables.Count > 0)
            {
                dt = ds.Tables[0];
            }
            if (dt.Rows.Count > 0)
            {
                DateTime sDate = DateTime.Parse(dt.Rows[0]["stage_sDate"].ToString().Trim());
                DateTime eDate = DateTime.Parse(dt.Rows[0]["stage_eDate"].ToString().Trim());
                TimeSpan ts    = eDate.AddDays(1).Subtract(sDate);

                DataColumn datetimeColumn1 = new DataColumn();
                //该列的数据类型
                datetimeColumn1.DataType = System.Type.GetType("System.String");
                //该列得名称
                datetimeColumn1.ColumnName = "week";
                //该列得默认值
                datetimeColumn1.DefaultValue = "";
                dt.Columns.Add(datetimeColumn1);

                dt.Columns[datetimeColumn1.ColumnName].SetOrdinal(5);

                //插入周期列
                for (int i = 0; i < ts.Days; i++)
                {
                    DataColumn datetimeColumn = new DataColumn();
                    //该列的数据类型
                    datetimeColumn.DataType = System.Type.GetType("System.String");
                    //该列得名称
                    datetimeColumn.ColumnName = sDate.AddDays(i).ToString("yyyy-MM-dd");
                    //该列得默认值
                    datetimeColumn.DefaultValue = "0";



                    dt.Columns.Add(datetimeColumn);

                    dt.Columns[datetimeColumn.ColumnName].SetOrdinal(i + 6);
                }
                //周期列赋值
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    DateTime mysDate = DateTime.Parse(dt.Rows[i]["begin_date"].ToString().Trim());
                    DateTime myeDate = DateTime.Parse(dt.Rows[i]["end_date"].ToString().Trim());
                    TimeSpan myts    = myeDate.AddDays(1).Subtract(mysDate);
                    for (int j = 0; j < myts.Days; j++)
                    {
                        if (dt.Rows[i][mysDate.AddDays(j).ToString("yyyy-MM-dd")].ToString().Trim() == "0")
                        {
                            dt.Rows[i][mysDate.AddDays(j).ToString("yyyy-MM-dd")] = "1";
                        }
                    }

                    string[] submitDate = dt.Rows[i]["submitDate"].ToString().Trim().Split(',');
                    for (int j = 0; j < submitDate.Length; j++)
                    {
                        try
                        {
                            for (int n = 0; n < ts.Days; n++)
                            {
                                if (sDate.AddDays(n).Date == DateTime.Parse(submitDate[j].Trim()).Date)
                                {
                                    dt.Rows[i][sDate.AddDays(n).ToString("yyyy-MM-dd")] = "2";
                                }
                            }
                        }
                        catch
                        {
                        }
                    }
                }

                //插入实施列并赋值
                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++)
                {
                    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);
                    dt.Columns[datetimeColumn.ColumnName].SetOrdinal(i + 6 + ts.Days);

                    for (int j = 0; j < dt.Rows.Count; j++)
                    {
                        DataTable impworkDT = new DataTable();
                        impDS = new BLL.project_work_implement().GetList("psi_sid='" + dt.Rows[j]["sid"] + "' and imp_sid='" + impDT.Rows[i]["sid"] + "'");
                        if (impDS.Tables.Count > 0)
                        {
                            impworkDT = impDS.Tables[0];
                            if (impworkDT.Rows.Count > 0)
                            {
                                dt.Rows[j]["imp" + impDT.Rows[i]["sid"].ToString().Trim()] = impworkDT.Rows[0]["implementer"].ToString().Trim();
                            }
                        }
                    }
                }
            }

            string reStr = "";

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                reStr += "<tr>";
                //bool group = false, content = false;
                for (int j = 1; j < dt.Columns.Count; j++)
                {
                    if (j == 1)
                    {
                        if (dt.Columns[j].ColumnName == "stage_name" && i == 0)
                        {
                            reStr += "<td rowspan='" + dt.Rows.Count + "'>" + dt.Rows[i][j].ToString().Trim() + "</td>";
                            continue;
                        }
                        else
                        {
                            continue;
                        }
                    }

                    if (dt.Columns[j].ColumnName == "group_name")
                    {
                        if (i == 0)
                        {
                            DataRow[] dr       = dt.Select("group_name='" + dt.Rows[i][j].ToString().Trim() + "'");
                            int       tmpCount = dr.Length;
                            reStr += "<td rowspan='" + tmpCount + "'>" + dt.Rows[i][j].ToString().Trim() + "</td>";
                            continue;
                        }
                        else if (dt.Rows[i][j].ToString().Trim() != dt.Rows[i - 1][j].ToString().Trim())
                        {
                            DataRow[] dr       = dt.Select("group_name='" + dt.Rows[i][j].ToString().Trim() + "'");
                            int       tmpCount = dr.Length;
                            reStr += "<td rowspan='" + tmpCount + "'>" + dt.Rows[i][j].ToString().Trim() + "</td>";
                            continue;
                        }
                        else
                        {
                            continue;
                        }
                    }

                    if (dt.Columns[j].ColumnName == "contentName")
                    {
                        if (i == 0)
                        {
                            DataRow[] dr       = dt.Select("contentName='" + dt.Rows[i][j].ToString().Trim() + "'");
                            int       tmpCount = dr.Length;
                            reStr += "<td rowspan='" + tmpCount + "'>" + dt.Rows[i][j].ToString().Trim() + "</td>";
                            continue;
                        }
                        else if (dt.Rows[i][j].ToString().Trim() != dt.Rows[i - 1][j].ToString().Trim())
                        {
                            DataRow[] dr       = dt.Select("contentName='" + dt.Rows[i][j].ToString().Trim() + "'");
                            int       tmpCount = dr.Length;
                            reStr += "<td rowspan='" + tmpCount + "'>" + dt.Rows[i][j].ToString().Trim() + "</td>";
                            continue;
                        }
                        else
                        {
                            continue;
                        }
                    }

                    if (dt.Columns[j].ColumnName == "begin_date")
                    {
                        break;
                    }
                    if (dt.Columns[j].ColumnName == "week")
                    {
                        reStr += "<td style='background-color:lightgray;'></td>";
                        continue;
                    }
                    //if (IsDate(dt.Columns[j].ColumnName))
                    if (dt.Columns[j].ColumnName.Contains('-'))
                    {
                        switch (dt.Rows[i][j].ToString().Trim())
                        {
                        case "0":
                            reStr += "<td></td>";
                            break;

                        case "1":
                            //reStr += "<td style='background-color:yellow;'><img  width='16px' height='16px' src='../Images/point/bullet_yellow.png'/></td>";
                            reStr += "<td style='background-color:yellow;'></td>";
                            break;

                        case "2":
                            //reStr += "<td style='background-color:green;'><img  width='16px' height='16px' src='../Images/point/bullet_green.png'/></td>";
                            reStr += "<td style='background-color:green;'></td>";
                            break;

                        default:
                            reStr += "<td></td>";
                            break;
                        }
                    }
                    else if (dt.Columns[j].ColumnName.Trim() == "reviews")
                    {
                        string[] arr      = dt.Rows[i][j].ToString().Trim().Split(',');
                        string   pointStr = "";
                        for (int n = 0; n < arr.Length; n++)
                        {
                            switch (arr[n].Trim())
                            {
                            case "0":
                                pointStr += "";
                                break;

                            case "1":
                                pointStr += "<img  width='16px' height='16px' src='../Images/point/bullet_green.png'/>&nbsp;";
                                break;

                            case "2":
                                pointStr += "<img  width='16px' height='16px' src='../Images/point/bullet_yellow.png'/>&nbsp;";
                                break;

                            case "3":
                                pointStr += "<img  width='16px' height='16px' src='../Images/point/bullet_orange.png'/>&nbsp;";
                                break;

                            case "4":
                                pointStr += "<img  width='16px' height='16px' src='../Images/point/bullet_red.png'/>&nbsp;";
                                break;

                            default:
                                break;
                            }
                        }
                        reStr += "<td>" + pointStr + "</td>";
                    }
                    else
                    {
                        reStr += "<td>" + dt.Rows[i][j].ToString().Trim() + "</td>";
                    }
                }
                reStr += "</tr>";
            }
            return(reStr);
        }
Exemplo n.º 4
0
        public static void GetProjectContent(string pssid, ref string isConstruction, out string stageName, out string pname, out string psid, out string sDateStr, out string eDateStr, out string showContent, out string showItem, out string frozencolumns, out string column)
        {
            stageName     = "";
            pname         = "";
            psid          = "";
            sDateStr      = "";
            eDateStr      = "";
            showContent   = "";
            showItem      = "";
            frozencolumns = "";
            column        = "";
            DataSet   ds;
            DataTable dt = new DataTable();

            ds = new BLL.Common().GetList("select project.sid as psid, project_name,project_code,stage_name,Convert(varchar(10),begin_date,120) begin_date,Convert(varchar(10),end_date,120) end_date,project_stage.is_system,project.v1,dbo.getUserNames_fu(project.v1) as v1Users,project.v2,dbo.getUserNames_fu(project.v2) as v2Users from project_stage left outer join project on project_stage.p_sid=project.sid where project_stage.sid='" + pssid + "'");


            string    user   = "";
            DataTable userdt = new BLL.Common().GetList("select UserName,Name from baseuser where Permissions=1 order by name ").Tables[0];
            DataRow   newdr  = userdt.NewRow();

            newdr["UserName"] = "";
            newdr["Name"]     = "请选择";
            userdt.Rows.InsertAt(newdr, 0);
            user = DBUtility.JsonHelper.DataTable2Json_Combo(userdt).Replace('\"', '\'');

            if (ds.Tables.Count > 0)
            {
                dt = ds.Tables[0];
            }
            if (dt.Rows.Count > 0)
            {
                isConstruction = dt.Rows[0]["is_system"].ToString().Trim();
                stageName      = dt.Rows[0]["stage_name"].ToString().Trim();
                pname          = dt.Rows[0]["project_name"].ToString().Trim();
                psid           = dt.Rows[0]["psid"].ToString().Trim();

                //动态添加实施列
                //主管审核人
                string dnyV1 = "";
                dnyV1 = ",{title: '',field:'v1',width:80, halign:'center', align:'center',formatter:function(value,row){return row.header;},editor:{type:'combobox', options: { data: " + user + ", valueField: 'UserName', editable: false, textField: 'Name',required: true, missingMessage: '必填'}}}";

                //总审人
                string dnyV2 = "";
                dnyV2 = ",{title: '',field:'v2',width:80, halign:'center', align:'center',formatter:function(value,row){return row.finaler;},editor:{type:'combobox', options: { data: " + user + ", valueField: 'UserName', editable: false, textField: 'Name',required: true, missingMessage: '必填'}}}";

                //工作种类及人员
                string    dynImp = "", dynImpUser = "", dynDay = "", dynWeek = "";
                DataTable impDT = new DataTable();
                DataSet   impDS = new BLL.project_implement().GetList(" s_sid='" + pssid + "' order by sequence");
                if (impDS.Tables.Count > 0)
                {
                    impDT = impDS.Tables[0];

                    for (int i = 0; i < impDT.Rows.Count; i++)
                    {
                        string[] dynImpUserArr = impDT.Rows[i]["impUsers"].ToString().Trim().Split(',');
                        string[] dynImpUidArr  = impDT.Rows[i]["implementers_sid"].ToString().Trim().Split(',');
                        dynImp += ",{title:'" + impDT.Rows[i]["implement_name"].ToString().Trim() + "',rowspan:2,colspan:" + (dynImpUserArr.Length > 0 ? dynImpUserArr.Length : 1) + "}";

                        dynImpUser += ",{title: '" + impDT.Rows[i]["impUsers"].ToString().Trim() + "',field:'imp_" + impDT.Rows[i]["sid"].ToString().Trim() + "',width:80, halign:'center', align:'center',formatter:function(value,row){return row.Abbr_imp_" + impDT.Rows[i]["sid"].ToString().Trim() + ";},editor:{type:'combobox', options: { data: " + user + ", valueField: 'UserName', editable: false, textField: 'Name'}}}";
                    }
                }
                else
                {
                    dynImp     = ",{title:'',rowspan:2}";
                    dynImpUser = "******";
                }

                //工作日历
                string cols     = "1";
                string monthstr = "";
                string tmp      = dt.Rows[0]["begin_date"].ToString().Trim();
                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)
                {
                    sDateStr = dt.Rows[0]["begin_date"].ToString().Trim();
                    eDateStr = dt.Rows[0]["end_date"].ToString().Trim();
                    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();
                    for (int i = 0; i < ts.Days; i++)
                    {
                        dynDay += ",{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;
                        }
                        dynWeek += ",{title:'" + w + "',field:'flow_" + sDate.AddDays(i).ToString("yyyy-MM-dd") + "',width:30,halign:'center',align:'center',styler: function(value,row,index){if(row['flow_" + sDate.AddDays(i).ToString("yyyy-MM-dd") + "']==null)return '';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 ''}},editor:'text'}";
                    }
                }
                else
                {
                    monthstr = "";
                    dynDay   = ",{title: '',rowspan:1}";
                    dynWeek  = ",{title: '',field:'w'}";
                }

                //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 calendarStr = "";
                string showGroup     = "true";
                string showWorkTitle = "";
                string widthContent  = "200";
                string widthItem     = "200";
                switch (isConstruction)
                {
                case "1":
                    showContent = "空间";
                    showItem    = "图纸及索引号";
                    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 + "(计划表中实际完成时间将用绿色色块做的标志))";
                    showWorkTitle = "";
                    for (int i = 0; i < workTitle.Length; i++)
                    {
                        showWorkTitle += workTitle[i];
                        if ((i + 1) % showCount == 0)
                        {
                            showWorkTitle += "<br/>";
                        }
                    }
                    break;

                case "0":
                    showContent   = "工作内容";
                    showItem      = "细目";
                    showGroup     = "false";
                    workTitle     = monthstr + "(黄色色块代表完成这项工作所需要的完成时间,计划表中实际完成时间将用绿色色块做标记)";
                    showWorkTitle = "";
                    for (int i = 0; i < workTitle.Length; i++)
                    {
                        showWorkTitle += workTitle[i];
                        if ((i + 1) % showCount == 0)
                        {
                            showWorkTitle += "<br/>";
                        }
                    }
                    break;

                case "2":

                    showContent   = "货物类别";
                    showItem      = "工作细目";
                    showWorkTitle = monthstr;
                    break;

                case "3":
                    showContent = "商品类别";
                    showItem    = "细目";
                    workTitle   = "智创产品逐个跟踪+" + pname;
                    for (int i = 0; i < workTitle.Length; i++)
                    {
                        showWorkTitle += workTitle[i];
                        if ((i + 1) % showCount == 0)
                        {
                            showWorkTitle += "<br/>";
                        }
                    }
                    break;

                case "4":
                    showContent = "加工类别";
                    showItem    = "工作细目";
                    workTitle   = monthstr + "(进程计划)";
                    for (int i = 0; i < workTitle.Length; i++)
                    {
                        showWorkTitle += workTitle[i];
                        if ((i + 1) % showCount == 0)
                        {
                            showWorkTitle += "<br/>";
                        }
                    }
                    widthContent = "80";
                    break;

                default:
                    break;
                }

                if (isConstruction != "3")
                {
                    frozencolumns += "[[";
                    frozencolumns += "{ title: '小组', field: 'group_name', width: 60, rowspan:3, halign: 'center', align: 'center',hidden:" + showGroup + ",editor:{type:'diseditText'}}";
                    frozencolumns += ",{ title: '" + showContent + "', field: 'contentName', width: " + widthContent + ", rowspan:3,halign: 'center',formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + value + '\\\"><span class=\\\"mlength\\\">' + value + '</span></a>';},editor:{type:'diseditText'}}";
                    frozencolumns += ",{ title: '" + showItem + "', field: 'itemName', width: " + widthItem + ",rowspan:3, halign: 'center',formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + value + '\\\"><span class=\\\"mlength\\\">' + value + '</span></a>';},editor:'text'}";
                    frozencolumns += "]]";
                    column        += "[[";
                    column        += "{ title: '月'}";
                    column        += ",{ title: '" + showWorkTitle + "',colspan:" + cols + "}";
                    column        += dynImp;
                    //column += ",{ title: '组长审核', rowspan:2,colspan:"+(v1UidArr.Length>0?v1UidArr.Length:1)+", halign: 'center', align: 'center'}";
                    column += ",{ title: '组长审核', rowspan:2,colspan:1, halign: 'center', align: 'center'}";
                    column += ",{ title: '未完成的原因', field: 'unfinished_reason', width: 60,rowspan:3, halign: 'center', align: 'center',editor:{type:'diseditText'}}";
                    column += ",{ title: '解决的办法', field: 'solution', width: 60, rowspan:3, halign:'center', align:'center',editor:{type:'diseditText'}}";
                    column += ",{ title: '解决的结果', field: 'reviewed', width: 60, rowspan:3, halign:'center', align:'center',editor:{type:'diseditText'}}";
                    //column += ",{ title: '总审', rowspan:2,colspan:" + (v2UidArr.Length > 0 ? v2UidArr.Length : 1) + ", halign: 'center', align: 'center'}";
                    column += ",{ title: '总审', rowspan:2,colspan:1, 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 += dynDay;
                    column += "],[";
                    column += "{ title: '星期', field: 'week',width:40,halign: 'center', align: 'center',styler: function(value,row,index){return 'background-color:lightgray;color:lightgray;';},editor:{type:'diseditText'}}";
                    column += dynWeek;
                    column += dynImpUser;
                    column += dnyV1;
                    column += dnyV2;
                    column += "]]";
                }
                else
                {
                    frozencolumns += "[[";
                    frozencolumns += "{ title: '编号', field: 'number', width: 60, rowspan:3, halign: 'center', align: 'center',editor:{type:'diseditText'}}";
                    frozencolumns += ",{ title: '细目', rowspan:1, colspan:3, halign: 'center', align: 'center'}";
                    frozencolumns += ",{ title: '漆面颜色', field: 'paintColor', width: 100, rowspan:3, halign: 'center', align: 'center',editor:{type:'text'}}";
                    frozencolumns += ",{ title: '应用空间', field: 'useSpace', width: 60, rowspan:3, halign: 'center', align: 'center',editor:{type:'diseditText'}}";
                    frozencolumns += ",{ title: '应用数量', field: 'spaceCount', width: 60, rowspan:3, halign: 'center', align: 'center',editor:{type:'diseditText'}}";
                    frozencolumns += ",{ title: '安装位置', field: 'install', width: 60, rowspan:3, halign: 'center', align: 'center',editor:{type:'diseditText'}}";
                    frozencolumns += ",{ title: '应用部位', field: 'usePart', width: 60, rowspan:3, halign: 'center', align: 'center',editor:{type:'diseditText'}}";
                    frozencolumns += ",{ title: '单位', field: 'unit', width: 60, rowspan:3, halign: 'center', align: 'center',editor:{type:'diseditText'}}";
                    frozencolumns += ",{ title: '数量', field: 'amount', width: 60, rowspan:3, halign: 'center', align: 'center',editor:{type:'diseditText'}}";
                    frozencolumns += ",{ title: '油漆色板编号', field: 'paintPaletteNumber', width: 60, rowspan:3, halign: 'center', align: 'center',editor:{type:'diseditText'}}";
                    frozencolumns += ",{ title: '加工类别', field: 'contentName', width: 60, rowspan:3, halign: 'center', align: 'center',editor:{type:'diseditText'}}";
                    frozencolumns += ",{ title: '备注', field: 'remark', width: 60, rowspan:3, halign: 'center', align: 'center',editor:{type:'text'}}";
                    frozencolumns += ",{ title: '工作明细', field: 'itemName', width: 60, rowspan:3, halign: 'center', align: 'center',editor:{type:'text'}}";
                    frozencolumns += "]";
                    frozencolumns += ",[";
                    frozencolumns += "{ title: '项目产品名称', field: 'productName', width: 100,  rowspan:2, halign: 'center', align: 'center',editor:{type:'diseditText'}}";
                    frozencolumns += ",{ title: '图片', field: 'productPic', width: 100, rowspan:2,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>\\\";"
                                     + "}"
                                     + "}}";
                    frozencolumns += ",{ title: '规格', field: 'Specifications', width: 60, rowspan:2,halign: 'center', align: 'center',editor:{type:'diseditText'}}";



                    frozencolumns += "]]";
                    column        += "[[";
                    column        += "{ title: '月'}";
                    column        += ",{ title: '" + showWorkTitle + "',colspan:" + cols + "}";
                    column        += dynImp;
                    //column += ",{ title: '组长审核', rowspan:2,colspan:"+(v1UidArr.Length>0?v1UidArr.Length:1)+", halign: 'center', align: 'center'}";
                    column += ",{ title: '组长审核', rowspan:2,colspan:1, halign: 'center', align: 'center'}";
                    column += ",{ title: '未完成的原因', field: 'unfinished_reason', width: 60,rowspan:3, halign: 'center', align: 'center',editor:{type:'diseditText'}}";
                    column += ",{ title: '解决的办法', field: 'solution', width: 60, rowspan:3, halign:'center', align:'center',editor:{type:'diseditText'}}";
                    column += ",{ title: '解决的结果', field: 'reviewed', width: 60, rowspan:3, halign:'center', align:'center',editor:{type:'diseditText'}}";
                    //column += ",{ title: '总审', rowspan:2,colspan:" + (v2UidArr.Length > 0 ? v2UidArr.Length : 1) + ", halign: 'center', align: 'center'}";
                    column += ",{ title: '总审', rowspan:2,colspan:1, 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 += dynDay;
                    column += "],[";
                    column += "{ title: '星期', field: 'week',width:40,halign: 'center', align: 'center',styler: function(value,row,index){return 'background-color:lightgray;color:lightgray;';},editor:{type:'diseditText'}}";
                    column += dynWeek;
                    column += dynImpUser;
                    column += dnyV1;
                    column += dnyV2;
                    column += "]]";
                }
            }
        }
Exemplo n.º 5
0
        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();
                //stageName = DBUtility.DbHelperSQL.GetSingle("select stage_name from project_stage where sid=" + pssid).ToString().Trim();
                DataTable dt = new DataTable();
                DataSet   ds = new BLL.Common().GetList("select project.sid as psid, project_name,project_code,stage_name,Convert(varchar(10),begin_date,120) begin_date,Convert(varchar(10),end_date,120) 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();
                    stageName      = dt.Rows[0]["stage_name"].ToString().Trim();
                    pname          = dt.Rows[0]["project_name"].ToString().Trim();
                    psid           = dt.Rows[0]["psid"].ToString().Trim();

                    //动态添加实施列
                    string    dynImp = "", dynImpUser = "", dynDay = "", dynWeek = "";
                    DataTable impDT = new DataTable();
                    DataSet   impDS = new BLL.project_implement().GetList(" s_sid='" + pssid + "' order by sequence");
                    if (impDS.Tables.Count > 0)
                    {
                        impDT = impDS.Tables[0];

                        for (int i = 0; i < impDT.Rows.Count; i++)
                        {
                            dynImp += ",{title:'" + impDT.Rows[i]["implement_name"].ToString().Trim() + "',rowspan:2}";

                            dynImpUser += ",{title: '" + impDT.Rows[i]["implementers"].ToString().Trim() + "',field:'impAbbr_" + impDT.Rows[i]["sid"].ToString().Trim() + "',width:80, halign:'center', align:'center'}";
                        }
                    }
                    else
                    {
                        dynImp     = ",{title:'',rowspan:2}";
                        dynImpUser = "******";
                    }

                    string cols     = "1";
                    string monthstr = "";
                    string tmp      = dt.Rows[0]["begin_date"].ToString().Trim();
                    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)
                    {
                        sDateStr = dt.Rows[0]["begin_date"].ToString().Trim();
                        eDateStr = dt.Rows[0]["end_date"].ToString().Trim();
                        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();
                        for (int i = 0; i < ts.Days; i++)
                        {
                            dynDay += ",{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;
                            }
                            dynWeek += ",{title:'" + w + "',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 ''}}}";
                        }
                    }
                    else
                    {
                        monthstr = "";
                        dynDay   = ",{title: '',rowspan:1}";
                        dynWeek  = ",{title: '',field:'w'}";
                    }

                    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);
                        }
                    }

                    if (isConstruction == "1")
                    {
                        showContent = "空间";
                        showItem    = "图纸及索引号";
                        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/>";
                            }
                        }

                        column += "[[";
                        column += "{ title: '空间', field: 'contentName', width: 80, 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: '" + monthstr + "(施工图立面框架" + flow + "(计划表中实际完成时间将用绿色色块做的标志))',rowspan:1,colspan:" + cols + "}";
                        column += ",{ title: '" + showWorkTitle + "',rowspan:1,colspan:" + cols + "}";
                        column += dynImp;
                        column += ",{ title: '主管审核', field: 'header', width: 60,rowspan:3, halign: 'center', align: 'center'}";
                        column += ",{ title: '未完成的原因', field: 'unfinished_reason', width: 60,rowspan:3, halign: 'center', align: 'center'}";
                        column += ",{ title: '解决的办法', field: 'solution', width: 60, rowspan:3, halign: 'center', align: 'center'}";
                        column += ",{ title: '解决的结果', field: 'reviewed', width: 60, rowspan:3, halign: 'center', align: 'center'}";
                        column += ",{ title: '总审', field: 'finaler', width: 60, rowspan:3,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 += dynDay;
                        column += "],[";
                        column += "{ title: '星期', field: 'week',width:40,halign: 'center', align: 'center',styler: function(value,row,index){return 'background-color:lightgray;color:lightgray;';}}";
                        column += dynWeek;
                        column += dynImpUser;
                        column += "]]";
                    }
                    else
                    {
                        showContent = "工作内容";
                        showItem    = "细目";
                        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: '" + monthstr + "(黄色色块代表完成这项工作所需要的完成时间,<br/>计划表中实际完成时间将用绿色色块做标记)',colspan:" + cols + "}";
                        column     += dynImp;
                        column     += ",{ title: '主管审核', field: 'header', width: 60,rowspan:3, halign: 'center', align: 'center'}";
                        column     += ",{ title: '未完成的原因', field: 'unfinished_reason', width: 60,rowspan:3, halign: 'center', align: 'center'}";
                        column     += ",{ title: '解决的办法', field: 'solution', width: 60, rowspan:3, halign: 'center', align: 'center'}";
                        column     += ",{ title: '解决的结果', field: 'reviewed', width: 60, rowspan:3, halign: 'center', align: 'center'}";
                        column     += ",{ title: '总审', field: 'finaler', width: 60, rowspan:3, 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     += dynDay;
                        column     += "],[";
                        column     += "{ title: '星期', field: 'week',width:40,halign: 'center', align: 'center',styler: function(value,row,index){return 'background-color:lightgray;color:lightgray;';}}";
                        column     += dynWeek;
                        column     += dynImpUser;
                        column     += "]]";
                    }
                }
            }
        }
Exemplo n.º 6
0
        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,project.v1 as groupAppr,project.v2 as trialAppr,project.v3 as qsAppr 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();

                    //动态添加实施列
                    string    dynamicColumn = "";
                    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++)
                    {
                        string    json   = "[]";
                        DataTable tmpDT1 = new DataTable();
                        DataSet   tmpDS1 = new BLL.Common().GetList(" select username, name from baseuser where username in (  select * from  dbo.getTable('" + impDT.Rows[i]["implementers_sid"].ToString().Trim() + "',',')) order by name asc");
                        if (tmpDS1.Tables.Count > 0)
                        {
                            tmpDT1 = tmpDS1.Tables[0];
                            json   = DBUtility.JsonHelper.DataTable2Json_Combo(tmpDT1).Replace('"', '\'');
                        }
                        dynamicColumn += "{field:'" + "imp" + impDT.Rows[i]["sid"].ToString().Trim() + "',title:'" + impDT.Rows[i]["implement_name"].ToString().Trim() + "',width:80,align:'center',halign: 'center', editor: {type:'combobox',options:{valueField:'username',textField:'name',data:" + json + ",panelWidth:100}},formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + rowData.imp_abb" + impDT.Rows[i]["sid"].ToString().Trim() + " + '\\\"><span class=\\\"mlength\\\">' + rowData.imp_abb" + impDT.Rows[i]["sid"].ToString().Trim() + " + '</span></a>';}},";
                        //dynamicColumn += "{field:'" + "imp" + impDT.Rows[i]["sid"].ToString().Trim() + "',title:'" + impDT.Rows[i]["implement_name"].ToString().Trim() + "',width:80,align:'center',halign: 'center', editor: {type:'combobox',options:{valueField:'username',textField:'name',url:'../ashx/project.ashx?action=getImpJson&pisid=" + impDT.Rows[i]["sid"].ToString().Trim() + "',panelWidth:100}},formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + rowData.imp_abb" + impDT.Rows[i]["sid"].ToString().Trim() + " + '\\\"><span class=\\\"mlength\\\">' + rowData.imp_abb" + impDT.Rows[i]["sid"].ToString().Trim() + " + '</span></a>';}},";
                        //dynamicColumn += "{field:'" + "imp" + impDT.Rows[i]["sid"].ToString().Trim() + "',title:'" + impDT.Rows[i]["implement_name"].ToString().Trim() + "',width:80,align:'center',halign: 'center', formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + rowData.imp_abb" + impDT.Rows[i]["sid"].ToString().Trim() + " + '\\\"><span class=\\\"mlength\\\">' + rowData.imp_abb" + impDT.Rows[i]["sid"].ToString().Trim() + " + '</span></a>';}},";
                    }
                    //获取小组列表
                    string    groupJson = "[]";
                    DataTable tmpDT     = new DataTable();
                    DataSet   tmpDS     = new BLL.Common().GetList(" select sid, group_name from project_group where ps_sid='" + pssid + "' order by sequence asc");
                    if (tmpDS.Tables.Count > 0)
                    {
                        tmpDT     = tmpDS.Tables[0];
                        groupJson = DBUtility.JsonHelper.DataTable2Json_Combo(tmpDT).Replace('"', '\'');
                    }

                    //小组审核
                    string groupAppJson = "[]";
                    tmpDT = new DataTable();
                    tmpDS = new BLL.Common().GetList(" select username, name from baseuser where username in (  select * from  dbo.getTable('" + dt.Rows[0]["groupAppr"].ToString().Trim() + "',',')) order by name asc");
                    if (tmpDS.Tables.Count > 0)
                    {
                        tmpDT        = tmpDS.Tables[0];
                        groupAppJson = DBUtility.JsonHelper.DataTable2Json_Combo(tmpDT).Replace('"', '\'');
                    }

                    //初审
                    string trialAppJson = "[]";
                    tmpDT = new DataTable();
                    tmpDS = new BLL.Common().GetList(" select username, name from baseuser where username in (  select * from  dbo.getTable('" + dt.Rows[0]["trialAppr"].ToString().Trim() + "',',')) order by name asc");
                    if (tmpDS.Tables.Count > 0)
                    {
                        tmpDT        = tmpDS.Tables[0];
                        trialAppJson = DBUtility.JsonHelper.DataTable2Json_Combo(tmpDT).Replace('"', '\'');
                    }

                    //质量监督
                    string qsAppJson = "[]";
                    tmpDT = new DataTable();
                    tmpDS = new BLL.Common().GetList(" select username as v3, name as qsAppr from baseuser where username in (  select * from  dbo.getTable('" + dt.Rows[0]["qsAppr"].ToString().Trim() + "',',')) order by name asc");
                    if (tmpDS.Tables.Count > 0)
                    {
                        tmpDT     = tmpDS.Tables[0];
                        qsAppJson = DBUtility.JsonHelper.DataTable2Json_Combo(tmpDT).Replace('"', '\'');
                    }

                    column += "[[";
                    column += "{ title: '小组', field: 'group_sid', width: 60,  halign: 'center', align: 'center', editor: {type:'combobox',options:{valueField:'sid',textField:'group_name',data:" + groupJson + ",panelWidth:100}},formatter: function (value, rowData, rowIndex) {if (rowData.parent_sid == 0) {return '<a class=\\\"a_black\\\" title=\\\"' + rowData.group_name + '\\\"><span class=\\\"mlength\\\">' + rowData.group_name + '</span></a>';}else {return '';}}},";
                    //column += "{ title: '小组', field: 'group_sid', width: 60, sortable: true, halign: 'center', align: 'center', editor: {type:'combobox',options:{valueField:'sid',textField:'group_name',data:"+groupJson+",panelWidth:100}},formatter: function (value, rowData, rowIndex) {if (rowData.parent_sid == 0) {return '<a class=\\\"a_black\\\" title=\\\"' + rowData.group_name + '\\\"><span class=\\\"mlength\\\">' + rowData.group_name + '</span></a>';}else {return '';}}},";
                    column += "{ title: '工作内容/细目', field: 'name', width: 200,  halign: 'center', editor: 'text',                        formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + value + '\\\"><span class=\\\"mlength\\\">' + value + '</span></a>';}},";
                    column += "{ title: '开始日期', field: 'begin_date', width: 80,  halign: 'center', align: 'center', editor: 'datebox',formatter: function (value, rowData, rowIndex) {if (value.Format('yyyy-MM-dd') == '1900-01-01') {return '';} else {return value.Format('yyyy-MM-dd');}}},";
                    column += "{ title: '结束日期', field: 'end_date', width: 80, halign: 'center', align: 'center', editor: 'datebox',formatter: function (value, rowData, rowIndex) {if (value.Format('yyyy-MM-dd') == '1900-01-01') {return '';} else {return value.Format('yyyy-MM-dd');}}},";
                    column += dynamicColumn;
                    column += "{ title: '小组审核', field: 'v1', width: 100, halign: 'center', align: 'center', editor: {type:'combobox',options:{valueField:'username',textField:'name',data:" + groupAppJson + ",panelWidth:100}},formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + rowData.groupAppr + '\\\"><span class=\\\"mlength\\\">' + rowData.groupAppr + '</span></a>';}},";
                    column += "{ title: '初审', field: 'v2', width: 100, sortable: true, halign: 'center', align: 'center',formatter: function (value, rowData, rowIndex) {return  rowData.trialAppr ;}, editor: {type:'combobox',options:{valueField:'username',textField:'name',data:" + trialAppJson + ",panelWidth:100}}},";
                    column += "{ title: '质量监督', field: 'v3', width: 100, halign: 'center', align: 'center',formatter: function (value, rowData, rowIndex) {return  rowData.qsAppr;}, editor: {type:'combobox',options:{valueField:'v3',textField:'qsAppr',data:" + qsAppJson + ",panelWidth:100}}},";

                    //column += "{ title: '小组审核', field: 'v1', width: 100, sortable: true, halign: 'center', align: 'center', editor: {type:'combobox',options:{valueField:'username',textField:'name',url:'../ashx/project.ashx?action=getGroupApprJson&psid=" + dt.Rows[0]["psid"].ToString().Trim() + "',panelWidth:100}},formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + rowData.groupAppr + '\\\"><span class=\\\"mlength\\\">' + rowData.groupAppr + '</span></a>';}},";
                    //column += "{ title: '初审', field: 'v2', width: 100, sortable: true, halign: 'center', align: 'center', editor: {type:'combobox',options:{valueField:'username',textField:'name',url:'../ashx/project.ashx?action=getTrialApprJson&pssid=" + dt.Rows[0]["psid"].ToString().Trim() + "',panelWidth:100}},formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + rowData.groupAppr + '\\\"><span class=\\\"mlength\\\">' + rowData.trialAppr + '</span></a>';}},";
                    //column += "{ title: '质量监督', field: 'v3', width: 100, sortable: true, halign: 'center', align: 'center', editor: {type:'combobox',options:{valueField:'username',textField:'name',url:'../ashx/project.ashx?action=getQsApprJson&pssid=" + dt.Rows[0]["psid"].ToString().Trim() + "',panelWidth:100}},formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + rowData.groupAppr + '\\\"><span class=\\\"mlength\\\">' + rowData.qsAppr + '</span></a>';}},";

                    //column += "{ title: '小组审核', field: 'v1', width: 100, sortable: true, halign: 'center', align: 'center',formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + rowData.groupAppr + '\\\"><span class=\\\"mlength\\\">' + rowData.groupAppr + '</span></a>';}},";

                    //column += "{ title: '初审', field: 'v2', width: 100, sortable: true, halign: 'center', align: 'center', formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + rowData.groupAppr + '\\\"><span class=\\\"mlength\\\">' + rowData.trialAppr + '</span></a>';}},";
                    //column += "{ title: '质量监督', field: 'v3', width: 100, sortable: true, halign: 'center', align: 'center', formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + rowData.groupAppr + '\\\"><span class=\\\"mlength\\\">' + rowData.qsAppr + '</span></a>';}},";
                    column += "{ title: '备注', field: 'remark', width: 100, halign: 'center', editor: 'text',formatter: function (value, rowData, rowIndex) {return '<a class=\\\"a_black\\\" title=\\\"' + value + '\\\"><span class=\\\"mlength\\\">' + value + '</span></a>';}}";
                    column += "]]";
                }
            }
        }
Exemplo n.º 7
0
        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\\\"/>&nbsp;\";break;case \"2\":str+=\"<img width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_yellow.png\\\" />&nbsp;\";break;case \"3\":str+=\"<img width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_orange.png\\\" />&nbsp;\";break;case \"4\":str+=\"<img width=\\\"16px\\\" height=\\\"16px\\\" src=\\\"../Images/point/bullet_red.png\\\" />&nbsp;\";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 += "]]";
                }
            }
        }
Exemplo n.º 8
0
        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,Convert(varchar(10),begin_date,120) begin_date,Convert(varchar(10),end_date,120) end_date,project_stage.is_system,project.v1,dbo.getUserNames_fu(project.v1) as v1Users,project.v2,dbo.getUserNames_fu(project.v2) as v2Users 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();
                    stageName      = dt.Rows[0]["stage_name"].ToString().Trim();
                    pname          = dt.Rows[0]["project_name"].ToString().Trim();
                    psid           = dt.Rows[0]["psid"].ToString().Trim();

                    //动态添加实施列
                    //主管审核人
                    string   dnyV1     = "";
                    string[] v1UserArr = dt.Rows[0]["v1Users"].ToString().Trim().Split(',');
                    string[] v1UidArr  = dt.Rows[0]["v1"].ToString().Trim().Split(',');
                    for (int j = 0; j < v1UserArr.Length; j++)
                    {
                        if (v1UidArr[j].Trim() != "")
                        {
                            dnyV1 += ",{title: '" + v1UserArr[j].ToString().Trim() + "',field:'v1_" + v1UidArr[j] + "',width:60, halign:'center', align:'center',editor:'text'}";
                        }
                        else
                        {
                            dnyV1 += ",{title: '" + v1UserArr[j].ToString().Trim() + "',field:'v1_" + v1UidArr[j] + "',width:60, halign:'center', align:'center',editor:{type:'diseditText'}}";
                        }
                        //dnyV1 += ",{title: '" + v1UserArr[j].ToString().Trim() + "',field:'v1_" + v1UidArr[j] + "',width:60, halign:'center', align:'center',formatter: function(value,row,index){},editor:'text'}";
                    }
                    if (v1UserArr.Length == 0)
                    {
                        dnyV1 = ",{title: '',field:'v1_',width:60, halign:'center', align:'center'}";
                    }

                    //总审人
                    string   dnyV2     = "";
                    string[] v2UserArr = dt.Rows[0]["v2USers"].ToString().Trim().Split(',');
                    string[] v2UidArr  = dt.Rows[0]["v2"].ToString().Trim().Split(',');
                    for (int j = 0; j < v2UserArr.Length; j++)
                    {
                        if (v2UidArr[j].Trim() != "")
                        {
                            dnyV2 += ",{title: '" + v2UserArr[j].ToString().Trim() + "',field:'v2_" + v2UidArr[j] + "',width:60, halign:'center', align:'center',editor:'text'}";
                        }
                        else
                        {
                            dnyV2 += ",{title: '" + v2UserArr[j].ToString().Trim() + "',field:'v2_" + v2UidArr[j] + "',width:60, halign:'center', align:'center',editor:{type:'diseditText'}}";
                        }
                    }
                    if (v2UserArr.Length == 0)
                    {
                        dnyV2 = ",{title: '',field:'v2_',width:60, halign:'center', align:'center'}";
                    }

                    //工作种类及人员
                    string    dynImp = "", dynImpUser = "", dynDay = "", dynWeek = "";
                    DataTable impDT = new DataTable();
                    DataSet   impDS = new BLL.project_implement().GetList(" s_sid='" + pssid + "' order by sequence");
                    if (impDS.Tables.Count > 0)
                    {
                        impDT = impDS.Tables[0];

                        for (int i = 0; i < impDT.Rows.Count; i++)
                        {
                            string[] dynImpUserArr = impDT.Rows[i]["impUsers"].ToString().Trim().Split(',');
                            string[] dynImpUidArr  = impDT.Rows[i]["implementers_sid"].ToString().Trim().Split(',');
                            dynImp += ",{title:'" + impDT.Rows[i]["implement_name"].ToString().Trim() + "',rowspan:2,colspan:" + (dynImpUserArr.Length > 0 ? dynImpUserArr.Length : 1) + "}";
                            for (int j = 0; j < dynImpUserArr.Length; j++)
                            {
                                if (dynImpUserArr[j].Trim() != "")
                                {
                                    dynImpUser += ",{title: '" + dynImpUserArr[j].ToString().Trim() + "',field:'impAbbr_" + impDT.Rows[i]["sid"].ToString().Trim() + "_" + dynImpUidArr[j] + "',width:80, halign:'center', align:'center',editor:'text'}";
                                }
                                else
                                {
                                    dynImpUser += ",{title: '" + dynImpUserArr[j].ToString().Trim() + "',field:'impAbbr_" + impDT.Rows[i]["sid"].ToString().Trim() + "_" + dynImpUidArr[j] + "',width:80, halign:'center', align:'center',editor:{type:'diseditText'}}";
                                }
                            }
                            if (dynImpUserArr.Length == 0)
                            {
                                dynImpUser = "******";
                            }
                        }
                    }
                    else
                    {
                        dynImp     = ",{title:'',rowspan:2}";
                        dynImpUser = "******";
                    }

                    //工作日历
                    string cols     = "1";
                    string monthstr = "";
                    string tmp      = dt.Rows[0]["begin_date"].ToString().Trim();
                    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)
                    {
                        sDateStr = dt.Rows[0]["begin_date"].ToString().Trim();
                        eDateStr = dt.Rows[0]["end_date"].ToString().Trim();
                        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();
                        for (int i = 0; i < ts.Days; i++)
                        {
                            dynDay += ",{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;
                            }
                            dynWeek += ",{title:'" + w + "',field:'flow_" + sDate.AddDays(i).ToString("yyyy-MM-dd") + "',width:30,halign:'center',align:'center',styler: function(value,row,index){if(row['flow_" + sDate.AddDays(i).ToString("yyyy-MM-dd") + "']==null);return;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 ''}},editor:'text'}";
                        }
                    }
                    else
                    {
                        monthstr = "";
                        dynDay   = ",{title: '',rowspan:1}";
                        dynWeek  = ",{title: '',field:'w'}";
                    }

                    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);
                        }
                    }
                    //string calendarStr = "";
                    string showGroup     = "true";
                    string showWorkTitle = "";
                    switch (isConstruction)
                    {
                    case "1":
                        showContent = "空间";
                        showItem    = "图纸及索引号";
                        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 + "(计划表中实际完成时间将用绿色色块做的标志))";
                        showWorkTitle = "";
                        for (int i = 0; i < workTitle.Length; i++)
                        {
                            showWorkTitle += workTitle[i];
                            if ((i + 1) % showCount == 0)
                            {
                                showWorkTitle += "<br/>";
                            }
                        }
                        break;

                    case "0":
                        showContent   = "工作内容";
                        showItem      = "细目";
                        showGroup     = "false";
                        showWorkTitle = monthstr + "(黄色色块代表完成这项工作所需要的完成时间,<br/>计划表中实际完成时间将用绿色色块做标记)";
                        break;

                    case "2":
                        showContent   = "货物类别";
                        showItem      = "工作细目";
                        showWorkTitle = monthstr;
                        break;

                    default:
                        break;
                    }

                    frozencolumns += "[[";
                    frozencolumns += "{ title: '小组', field: 'group_name', width: 60, rowspan:3, halign: 'center', align: 'center',hidden:" + showGroup + ",editor:{type:'diseditText'}}";
                    frozencolumns += ",{ 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>';},editor:{type:'diseditText'}}";
                    frozencolumns += ",{ 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>';},editor:'text'}";
                    frozencolumns += "]]";
                    column        += "[[";
                    column        += "{ title: '月'}";
                    column        += ",{ title: '" + showWorkTitle + "',colspan:" + cols + "}";
                    column        += dynImp;
                    column        += ",{ title: '主管审核', rowspan:2,colspan:" + (v1UidArr.Length > 0?v1UidArr.Length:1) + ", halign: 'center', align: 'center'}";
                    column        += ",{ title: '未完成的原因', field: 'unfinished_reason', width: 60,rowspan:3, halign: 'center', align: 'center',editor:{type:'diseditText'}}";
                    column        += ",{ title: '解决的办法', field: 'solution', width: 60, rowspan:3, halign:'center', align:'center',editor:{type:'diseditText'}}";
                    column        += ",{ title: '解决的结果', field: 'reviewed', width: 60, rowspan:3, halign:'center', align:'center',editor:{type:'diseditText'}}";
                    column        += ",{ title: '总审', rowspan:2,colspan:" + (v2UidArr.Length > 0 ? v2UidArr.Length : 1) + ", 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        += dynDay;
                    column        += "],[";
                    column        += "{ title: '星期', field: 'week',width:40,halign: 'center', align: 'center',styler: function(value,row,index){return 'background-color:lightgray;color:lightgray;';},editor:{type:'diseditText'}}";
                    column        += dynWeek;
                    column        += dynImpUser;
                    column        += dnyV1;
                    column        += dnyV2;
                    column        += "]]";
                }
            }
        }