public string GenTable() { string result = ""; MDProcductivity oMDPro = new MDProcductivity(); DateTime dt = new DateTime(); if (txtDate.Text != "") { dt = Convert.ToDateTime(txtDate.Text.Trim()); } else { dt = DateTime.Now; } oMDPro = oPro.GetProductivityByMonth(dt.Month, dt.Year); hidMonth.Value = dt.Month.ToString(); hidYear.Value = dt.Year.ToString(); int days = DateTime.DaysInMonth(dt.Year, dt.Month); result += "" + Environment.NewLine; result += "<table class='table' style='width: 3800px;' border=\"1\">" + Environment.NewLine; result += " <tr>" + Environment.NewLine; result += " <td rowspan=\"3\">Line" + Environment.NewLine; result += " </td>" + Environment.NewLine; result += " <td rowspan=\"3\" width='100px'>Process" + Environment.NewLine; result += " </td>" + Environment.NewLine; result += " <td colspan=\"" + days * 2 + "\">" + GetMonth() + "" + Environment.NewLine; result += " </td>" + Environment.NewLine; result += " </tr>" + Environment.NewLine; result += " <tr>" + Environment.NewLine; for (int day = 1; day <= days; day++) { if (day == DateTime.Now.Day && dt.Month == DateTime.Now.Month) { result += " <td colspan=\"2\" style='background-color: yellow;'>" + Environment.NewLine; } else { result += " <td colspan=\"2\" style='background-color: white;'>" + Environment.NewLine; } result += " " + day + "" + Environment.NewLine; result += " </td>" + Environment.NewLine; } result += " </tr>" + Environment.NewLine; result += " <tr>" + Environment.NewLine; for (int day = 1; day <= days; day++) { if (day == DateTime.Now.Day && dt.Month == DateTime.Now.Month) { result += " <td style='background-color: yellow; border-top: 1px solid #000000;'>" + Environment.NewLine; result += " D" + Environment.NewLine; result += " </td>" + Environment.NewLine; result += " <td style='background-color: yellow; border-top: 1px solid #000000;'>" + Environment.NewLine; result += " N" + Environment.NewLine; result += " </td>" + Environment.NewLine; } else { result += " <td style='background-color: white; border-top: 1px solid #000000;'>" + Environment.NewLine; result += " D" + Environment.NewLine; result += " </td>" + Environment.NewLine; result += " <td style='background-color: white; border-top: 1px solid #000000;'>" + Environment.NewLine; result += " N" + Environment.NewLine; result += " </td>" + Environment.NewLine; } } result += " </tr>" + Environment.NewLine; // Loop by Day foreach (MDProcductivity.CMDProductivity oMD in oMDPro.ListOfProductivity) { result += " <tr>" + Environment.NewLine; result += " <td rowspan=\"3\">" + Environment.NewLine; result += " " + oMD.LineName + "" + Environment.NewLine; result += " </td>" + Environment.NewLine; result += " <td style='border-top: 1px solid #000000;'>" + Environment.NewLine; result += " Plan" + Environment.NewLine; result += " </td>" + Environment.NewLine; // Loop for (int day = 1; day <= days; day++) { if (day == DateTime.Now.Day && dt.Month == DateTime.Now.Month) { result += " <td width='60px' style='background-color: yellow; border-top: 1px solid #000000;'>" + Environment.NewLine; result += " " + oMD.ListOfQty[day - 1].PlanD + "" + Environment.NewLine; // Plan Day result += " </td>" + Environment.NewLine; result += " <td width='60px' style='background-color: yellow; border-top: 1px solid #000000;'>" + Environment.NewLine; result += " " + oMD.ListOfQty[day - 1].PlanN + "" + Environment.NewLine; // Plan Night result += " </td>" + Environment.NewLine; } else { result += " <td width='60px' style='background-color: white; border-top: 1px solid #000000;'>" + Environment.NewLine; result += " " + oMD.ListOfQty[day - 1].PlanD + "" + Environment.NewLine; // Plan Day result += " </td>" + Environment.NewLine; result += " <td width='60px' style='background-color: white; border-top: 1px solid #000000;'>" + Environment.NewLine; result += " " + oMD.ListOfQty[day - 1].PlanN + "" + Environment.NewLine; // Plan Night result += " </td>" + Environment.NewLine; } } result += " </tr>" + Environment.NewLine; result += " <tr>" + Environment.NewLine; result += " <td>" + Environment.NewLine; result += " Start" + Environment.NewLine; result += " </td>" + Environment.NewLine; // Loop for (int day = 1; day <= days; day++) { if (day == DateTime.Now.Day && dt.Month == DateTime.Now.Month) { result += " <td width='60px' style='background-color: yellow;'>" + Environment.NewLine; result += " " + oMD.ListOfQty[day - 1].StartD + "" + Environment.NewLine; // Start Day result += " </td>" + Environment.NewLine; result += " <td width='60px' style='background-color: yellow;'>" + Environment.NewLine; result += " " + oMD.ListOfQty[day - 1].StartN + "" + Environment.NewLine; // Start Night result += " </td>" + Environment.NewLine; } else { result += " <td width='60px' style='background-color: white;'>" + Environment.NewLine; result += " " + oMD.ListOfQty[day - 1].StartD + "" + Environment.NewLine; // Start Day result += " </td>" + Environment.NewLine; result += " <td width='60px' style='background-color: white;'>" + Environment.NewLine; result += " " + oMD.ListOfQty[day - 1].StartN + "" + Environment.NewLine; // Start Night result += " </td>" + Environment.NewLine; } } result += " </tr>" + Environment.NewLine; result += " <tr>" + Environment.NewLine; result += " <td>" + Environment.NewLine; result += " Last" + Environment.NewLine; result += " </td>" + Environment.NewLine; // Loop for (int day = 1; day <= days; day++) { if (day == DateTime.Now.Day && dt.Month == DateTime.Now.Month) { result += " <td width='60px' style='background-color: yellow;'>" + Environment.NewLine; result += " " + oMD.ListOfQty[day - 1].LastD + "" + Environment.NewLine; // End Day result += " </td>" + Environment.NewLine; result += " <td width='60px' style='background-color: yellow;'>" + Environment.NewLine; result += " " + oMD.ListOfQty[day - 1].LastN + "" + Environment.NewLine; // End Night result += " </td>" + Environment.NewLine; } else { result += " <td width='60px' style='background-color: white;'>" + Environment.NewLine; result += " " + oMD.ListOfQty[day - 1].LastD + "" + Environment.NewLine; // End Day result += " </td>" + Environment.NewLine; result += " <td width='60px' style='background-color: white;'>" + Environment.NewLine; result += " " + oMD.ListOfQty[day - 1].LastN + "" + Environment.NewLine; // End Night result += " </td>" + Environment.NewLine; } } result += " </tr>" + Environment.NewLine; } result += "</table>" + Environment.NewLine; return(result); }
public string GenGraph() { string result = ""; MDProcductivity oMDProc = new MDProcductivity(); DateTime _Date = new DateTime(); if (txtDate.Text != "") { _Date = Convert.ToDateTime(txtDate.Text.Trim()); } else { _Date = DateTime.Now; } oMDProc = oPro.GetProductivityNow(_Date, dropDownShift.SelectedValue); if (oMDProc.ListOfProductivity.Count > 0) { string Shift = ""; if (dropDownShift.SelectedValue != "") { Shift = dropDownShift.SelectedValue; } //if (DateTime.Now.TimeOfDay.Hours >= 20 || DateTime.Now.TimeOfDay.Hours < 8) //{ // Shift = "Night"; //} //else //{ // Shift = "Day"; //} //if (dropDownShift.SelectedValue == "NIGHT") //{ // Shift = "Night"; //} //else //{ // Shift = "Day"; //} result += "<script type='text/javascript'>" + Environment.NewLine; result += "Highcharts.chart('container', {" + Environment.NewLine; result += " chart: {" + Environment.NewLine; result += " type: 'column'" + Environment.NewLine; result += " }," + Environment.NewLine; result += " title: {" + Environment.NewLine; result += " text: 'Productivity Factory 3'" + Environment.NewLine; result += " }," + Environment.NewLine; result += " subtitle: {" + Environment.NewLine; result += " text: '" + _Date.ToString("dd MMMM yyyy") + " " + Shift + "'" + Environment.NewLine; result += " }," + Environment.NewLine; result += " xAxis: {" + Environment.NewLine; result += " categories: [" + Environment.NewLine; for (int i = 0; i < oMDProc.ListOfProductivity.Count; i++) { if (i == oMDProc.ListOfProductivity.Count - 1) { result += " '" + oMDProc.ListOfProductivity[i].LineName + "'" + Environment.NewLine; } else { result += " '" + oMDProc.ListOfProductivity[i].LineName + "'," + Environment.NewLine; } } //result += " 'Rear Head'," + Environment.NewLine; //result += " 'Cylinder'," + Environment.NewLine; //result += " 'Crank Shaft'," + Environment.NewLine; //result += " 'Front Head'," + Environment.NewLine; //result += " 'Piston'," + Environment.NewLine; //result += " 'Pipe'," + Environment.NewLine; //result += " 'Mecha'," + Environment.NewLine; //result += " 'Main Assy'," + Environment.NewLine; //result += " 'Final'" + Environment.NewLine; result += " ]," + Environment.NewLine; result += " crosshair: true" + Environment.NewLine; result += " }," + Environment.NewLine; result += " yAxis: {" + Environment.NewLine; result += " min: 0," + Environment.NewLine; result += " title: {" + Environment.NewLine; result += " text: 'Quantity (pcs)'" + Environment.NewLine; result += " }" + Environment.NewLine; result += " }," + Environment.NewLine; result += " tooltip: {" + Environment.NewLine; result += " headerFormat: '<span style=\"font-size:10px\">{point.key}</span><table>'," + Environment.NewLine; result += " pointFormat: '<tr><td style=\"color:{series.color};padding:0\">{series.name}: </td>' +" + Environment.NewLine; result += " '<td style=\"padding:0\"><b>{point.y:.1f} mm</b></td></tr>'," + Environment.NewLine; result += " footerFormat: '</table>'," + Environment.NewLine; result += " shared: true," + Environment.NewLine; result += " useHTML: true" + Environment.NewLine; result += " }," + Environment.NewLine; result += " plotOptions: {" + Environment.NewLine; result += " column: {" + Environment.NewLine; result += " pointPadding: 0.2," + Environment.NewLine; result += " borderWidth: 0," + Environment.NewLine; result += " dataLabels: {" + Environment.NewLine; result += " enabled: true," + Environment.NewLine; //result += " format: '{point.y:.1f}'," + Environment.NewLine; result += " y: 0," + Environment.NewLine; result += " color: (Highcharts.theme && Highcharts.theme.dataLabelsColor) || 'black'" + Environment.NewLine; result += " }" + Environment.NewLine; result += " }" + Environment.NewLine; result += " }," + Environment.NewLine; result += " tooltip: {" + Environment.NewLine; result += " shared: true" + Environment.NewLine; result += " }," + Environment.NewLine; result += " series: [{" + Environment.NewLine; result += " name: 'Plan'," + Environment.NewLine; result += " data: [" + Environment.NewLine; for (int i = 0; i < oMDProc.ListOfProductivity.Count; i++) { if (i == oMDProc.ListOfProductivity.Count - 1) { result += " " + oMDProc.ListOfProductivity[i].ListOfQty[0].PlanD != DBNull.Value.ToString() ? oMDProc.ListOfProductivity[i].ListOfQty[0].PlanD : "0" + "" + Environment.NewLine; } else { result += " " + oMDProc.ListOfProductivity[i].ListOfQty[0].PlanD != DBNull.Value.ToString() ? oMDProc.ListOfProductivity[i].ListOfQty[0].PlanD + "," : "0" + "," + Environment.NewLine; } } result += " ]," + Environment.NewLine; //result += " data: [49.9, 71.5, 106.4, 129.2, 144.0, 176.0, 135.6, 148.5, 216.4]," + Environment.NewLine; result += " tooltip: {" + Environment.NewLine; result += " valueSuffix: ' pcs'" + Environment.NewLine; result += " }" + Environment.NewLine; result += " }, {" + Environment.NewLine; result += " name: 'Start'," + Environment.NewLine; result += " data: [" + Environment.NewLine; for (int i = 0; i < oMDProc.ListOfProductivity.Count; i++) { if (i == oMDProc.ListOfProductivity.Count - 1) { result += " " + oMDProc.ListOfProductivity[i].ListOfQty[0].StartD != DBNull.Value.ToString() ? oMDProc.ListOfProductivity[i].ListOfQty[0].StartD : "0" + "" + Environment.NewLine; } else { result += " " + oMDProc.ListOfProductivity[i].ListOfQty[0].StartD != DBNull.Value.ToString() ? oMDProc.ListOfProductivity[i].ListOfQty[0].StartD + "," : "0" + "," + Environment.NewLine; } } result += " ]," + Environment.NewLine; //result += " data: [83.6, 78.8, 98.5, 93.4, 106.0, 84.5, 105.0, 104.3, 91.2]," + Environment.NewLine; result += " tooltip: {" + Environment.NewLine; result += " valueSuffix: ' pcs'" + Environment.NewLine; result += " }" + Environment.NewLine; result += " }, {" + Environment.NewLine; result += " name: 'Last'," + Environment.NewLine; result += " data: [" + Environment.NewLine; for (int i = 0; i < oMDProc.ListOfProductivity.Count; i++) { if (i == oMDProc.ListOfProductivity.Count - 1) { result += " " + oMDProc.ListOfProductivity[i].ListOfQty[0].LastD != DBNull.Value.ToString() ? oMDProc.ListOfProductivity[i].ListOfQty[0].LastD : "0" + "" + Environment.NewLine; } else { result += " " + oMDProc.ListOfProductivity[i].ListOfQty[0].LastD != DBNull.Value.ToString() ? oMDProc.ListOfProductivity[i].ListOfQty[0].LastD + "," : "0" + "," + Environment.NewLine; } } result += " ]," + Environment.NewLine; //result += " data: [83.6, 78.8, 98.5, 93.4, 106.0, 84.5, 105.0, 104.3, 91.2]," + Environment.NewLine; result += " tooltip: {" + Environment.NewLine; result += " valueSuffix: ' pcs'" + Environment.NewLine; result += " }" + Environment.NewLine; result += " }]" + Environment.NewLine; result += "});" + Environment.NewLine; result += "</script>" + Environment.NewLine; } return(result); }