public JsonModel Get(string Data)
{
string strcx = ""; //车型
string strch = ""; //车号
string strxcjl = ""; //行车交路
string strgh = ""; //工号字符串
string strcc = ""; //车次
string strcid = "";
string remarkTypeName = ""; //站接，库接
PSpecificOnduty paramModel = TF.CommonUtility.JsonConvert.JsonDeserialize <PSpecificOnduty>(Data);
strcx = paramModel.cx; //车型
strch = paramModel.ch; //车号
strxcjl = HttpUtility.UrlDecode(paramModel.xcjl); //行车交路
strcc = paramModel.cc; //车次
strcid = paramModel.cid; //客户端id
remarkTypeName = paramModel.remarkTypeName;
if (string.IsNullOrEmpty(strcid))
{
return(FengRunSpecific(strgh, strxcjl, strcid, strcx, strch, strcc, remarkTypeName, paramModel));
}
else
{
DBSpecificOnDuty ea = new DBSpecificOnDuty();
string strWorkShopGUID = ea.getWorkShopGUID(strcid);
if (strWorkShopGUID == "292be3ca-b357-4386-80dc-eb148e5a595e")
{
return(FengRunSpecific(strgh, strxcjl, strcid, strcx, strch, strcc, remarkTypeName, paramModel));
}
else if (strWorkShopGUID == "3b50bf66-dabb-48c0-8b6d-05db80591090")
{
SpecificOnDuty_ts ts = new SpecificOnDuty_ts();
return(ts.TangShanSpecific(strgh, strxcjl, strcid, strcx, strch, strcc, paramModel));
}
else
{
return(FengRunSpecific(strgh, strxcjl, strcid, strcx, strch, strcc, remarkTypeName, paramModel));
}
}
}
public JsonModel FengRunSpecific(string strgh, string strxcjl, string strcid, string strcx, string strch, string strcc, string remarkTypeName, PSpecificOnduty paramModel)
{
DBSpecificOnDuty ea = new DBSpecificOnDuty();
strgh = "";//工号字符串
foreach (gh g in paramModel.gh)
{
if (g.ghID.Length == 7)
{
strgh += g.ghID + ",";
}
else
{
}
}
strgh = strgh.Substring(0, strgh.Length - 1);
//查询完毕后渲染html
string html = TF.CommonUtility.CommonHelper.RenderHtml("top.htm", "");//头部的html代码
//获取关键站天气预报信息
DataTable dtTianQi = ea.GetAllTianQi(strxcjl);
string strTianQi = "";
for (int t = 0; t < dtTianQi.Rows.Count; t++)
{
strTianQi += "<tr><td class='Juleft' style=''>" + dtTianQi.Rows[t]["strCheZhan"].ToString();
strTianQi += " " + dtTianQi.Rows[t]["strTianQi"].ToString();
strTianQi += " " + dtTianQi.Rows[t]["strWenDu"].ToString() + "</td></tr>";
}
//预警，操作要求，车间要求
DataTable dtYuJin = ea.GetYuJing(strxcjl);
string strYuJing = "";
if (dtYuJin.Rows.Count > 0)
{
strYuJing += "<tr><td class='Juleft' style='font-weight:400;line-height:1.5; '> " + dtYuJin.Rows[0]["strChuanDa"].ToString() + "</td></tr>";
}
else
{
strYuJing = "";
}
//事故传达
DataTable dtShiGu = ea.GetShiGu();
string strShiGu = "";
if (dtShiGu.Rows.Count > 0)
{
strShiGu += "<tr><td class='Juleft' style='font-size:14px;line-height:1.2'>七、事故通报</td></tr>";
for (int kk = 0; kk < dtShiGu.Rows.Count; kk++)
{
strShiGu += "<tr><td class='Juleft'>" + (kk + 1).ToString() + "、" + dtShiGu.Rows[kk]["strShiGu"].ToString() + "</td></tr>";
}
}
//人员信息，考试情况,两违通报
string strRenYuan = "<tr><td align='left' style='font-weight:400;line-height:1.5;'>";
DataTable dtRenYuan = ea.GetRenYuan(strgh.Split(',')[0]);
string strRenYuan1 = "";
if (dtRenYuan.Rows.Count > 0)
{
strRenYuan1 += " 司机:" + dtRenYuan.Rows[0]["strTrainmanName1"].ToString() + " ";
strRenYuan1 += "副(换乘)司机:" + dtRenYuan.Rows[0]["strTrainmanName2"].ToString();
}
strRenYuan += strRenYuan1;
strRenYuan += "</td></tr>";
//机车临碎修
string strLinSuiXiu = "<tr><td align='left' >" + TF.CommonUtility.CommonHelper.RenderHtml("Tab_SpecificOnDuty_LingSuiXiu.htm", AllLingSuiXiu(strcx, strch)) + "</td></tr>";
html += "<div style='border:solid 0px #000;padding:5px;'><table style='width:100%; font-size:14px;'>";
html += "<tr><td class='Juleft' style='font-weight:400;line-height:1.5; '>一、出勤时间：" + DateTime.Now.ToString("yy年MM月dd日HH:mm") + "</td></tr>";
html += "<tr><td class='Juleft' style='font-weight:400;line-height:1.5;'>二、出勤机班：</td></tr>" + strRenYuan;
html += "<tr><td align='left' class='Juleft' style='font-weight:400;line-height:1.5; '>三、担当区段 车次：" + strxcjl + " " + strcc + "次</td></tr>";
html += "<tr><td align='left' style=' font-weight:400; line-height:2'>" + getZhanOrKu(strcx, strch, remarkTypeName) + "</td></tr>";
html += "<tr><td class='Juleft'>五、使用机车质量信息 " + strcx + " - " + strch + "</td></tr>";
html += strLinSuiXiu;
html += "<tr><td class='Juleft'>六、安全提示</td></tr>";
html += strYuJing;
html += strShiGu;
html += "<tr><td class='Juleft' style='font-size:14px;line-height:1.2'>八、天气预报</td></tr>";
html += strTianQi;
html += "<tr><td style=' font-weight:400; line-height:1.2;text-align:center;font-size: 20px' ><b>" + ea.GetYanYu() + "</b></td></tr>";
html += "</table></div>";
string strfilePath = "/SpecificOnDuty";
CreatHtmlFile(System.Web.Hosting.HostingEnvironment.MapPath(strfilePath), html, "" + strcid + ".htm");
CreatPdf(strcid);
//生成EXCEL
string strExcelHtml = "";
strExcelHtml += html;
strExcelHtml += "</td></tr></table></body></html>";
CreatHtmlFile(System.Web.Hosting.HostingEnvironment.MapPath(strfilePath), strExcelHtml, "" + strcid + ".xls");
JsonModel jsonModel = new JsonModel();
jsonModel.result = "0";
jsonModel.resultStr = "返回成功";
Random r = new Random();
jsonModel.data = new ResultData();
jsonModel.data.strPDFURL = "http://" + HttpContext.Current.Request.Url.Authority + "/SpecificOnDuty/" + strcid + ".pdf?r=" + r.Next(1, 2000) + "";
jsonModel.data.strExcelURL = "http://" + HttpContext.Current.Request.Url.Authority + "/SpecificOnDuty/" + strcid + ".xls?r=" + r.Next(1, 2000) + "";
return(jsonModel);
}
public override string QueryResult()
{
TF.RunSafty.DAL.ExcelAdd ea = new TF.RunSafty.DAL.ExcelAdd();
string strcx = ""; //车型
string strch = ""; //车号
string strxcjl = ""; //行车交路
string strgh = ""; //工号字符串
string strcc = ""; //车次
string strcid = "";
PSpecificOnduty paramModel = TF.CommonUtility.JsonConvert.JsonDeserialize <PSpecificOnduty>(this.Data);
strcx = paramModel.cx; //车型
strch = paramModel.ch; //车号
strxcjl = HttpUtility.UrlDecode(paramModel.xcjl); //行车交路
strcc = paramModel.cc; //车次
strcid = paramModel.cid; //客户端id
strgh = "";//工号字符串
foreach (gh g in paramModel.gh)
{
if (g.ghID.Length == 7)
{
strgh += g.ghID.Substring(2, 5) + ",";
}
}
strgh = strgh.Substring(0, strgh.Length - 1);
//查询完毕后渲染html
string html = TF.CommonUtility.CommonHelper.RenderHtml("top.htm", "");//头部的html代码
//获取关键站天气预报信息
DataTable dtTianQi = ea.GetAllTianQi(strxcjl);
string strTianQi = "";
for (int t = 0; t < dtTianQi.Rows.Count; t++)
{
strTianQi += " " + dtTianQi.Rows[t]["strCheZhan"].ToString();
strTianQi += " " + dtTianQi.Rows[t]["strTianQi"].ToString();
strTianQi += " " + dtTianQi.Rows[t]["strWenDu"].ToString() + " ";
}
//预警，操作要求，车间要求
DataTable dtYuJin = ea.GetYuJing(strxcjl);
string strYuJing = "";
if (dtYuJin.Rows.Count > 0)
{
strYuJing += "<tr><td>关键站：" + dtYuJin.Rows[0]["strGuanJianZhan"].ToString() + " 操纵要求：" + dtYuJin.Rows[0]["strCaoZongYaoQiu"].ToString() + "</td></tr>";
strYuJing += "<tr><td>预警：" + dtYuJin.Rows[0]["strYuJin"].ToString() + "</td></tr>";
}
else
{
strYuJing = "";
}
//人员信息，考试情况,两违通报
string strRenYuan = "";
for (int sp = 0; sp < strgh.Split(',').Length; sp++)
{
DataTable dtRenYuan = ea.GetRenYuan(strgh.Split(',')[sp]);
string strRenYuan1 = "";
string strRenYuan2 = "";
string strRenYuan3 = "";
string strRenYuan4 = "";
if (dtRenYuan.Rows.Count > 0)
{
strRenYuan1 = "<tr><td>姓名：" + dtRenYuan.Rows[0]["strName"].ToString() + " ";
strRenYuan2 = "重点人：" + dtRenYuan.Rows[0]["strZhongDianPerple"].ToString() + " ";
strRenYuan3 = "车间要求：" + dtRenYuan.Rows[0]["strCheJianYaoQiu"].ToString() + "</td></tr>";
strRenYuan4 = "<tr><td>人性化提示：" + dtRenYuan.Rows[0]["strJianKang"].ToString() + "</td></tr>";
}
strRenYuan += strRenYuan1;
strRenYuan += strRenYuan2;
strRenYuan += strRenYuan3;
strRenYuan += "<tr><td>" + TF.CommonUtility.CommonHelper.RenderHtml("Tab_Test.htm", AllTasts(strgh.Split(',')[sp])) + "</td></tr>";
strRenYuan += "<tr><td>" + TF.CommonUtility.CommonHelper.RenderHtml("Tab_SpecificOnDuty_LiangWei.htm", ea.GetAllLiangWei(strgh.Split(',')[sp]).Rows) + "</td></tr>";
strRenYuan += strRenYuan4;
strRenYuan += "<tr><td> </td></tr>";
}
//机车临碎修
//DataTable dtLinSuiXiu = ea.GetLinSuixiu(strcx, strch);
//string strLinSuiXiu = "<tr><td>" + TF.CommonUtility.CommonHelper.RenderHtml("Tab_SpecificOnDuty_LingSuiXiu.htm", dtLinSuiXiu.Rows) + "</td></tr>";
string strLinSuiXiu = "<tr><td>" + TF.CommonUtility.CommonHelper.RenderHtml("Tab_SpecificOnDuty_LingSuiXiu.htm", AllLingSuiXiu(strcx, strch)) + "</td></tr>";
html += "<div style='border:solid 1px #000'><table><tr><td><table style='width:100%; font-size:12px;text-decoration:underline'><tr><td align='center'><b>个性提示</b></td></tr></table></td></tr>";
html += "<tr><td align='left'>" + strxcjl + " 车次：" + strcc + "</td></tr>";
html += "<tr><td>天气预报：" + strTianQi + "</td></tr>";
html += strRenYuan;
html += "<tr><td><table style='width:100%; font-size:12px;text-decoration:underline; line-height:1.2'><tr><td align='center'><b>机车状态</b></td></tr></table></td></tr>";
html += strLinSuiXiu;
html += "<tr><td><table style='width:100%; font-size:12px;text-decoration:underline; line-height:1.2'><tr><td align='center'><b>预警提示</b></td></tr></table></td></tr>";
html += strYuJing;
html += "</table></div>";
string strfilePath = "/SpecificOnDuty";
CreatHtmlFile(System.Web.Hosting.HostingEnvironment.MapPath(strfilePath), html, "" + strcid + ".htm");
CreatPdf(strcid);
//生成EXCEL
string strExcelHtml = TF.CommonUtility.CommonHelper.RenderHtml("Excel.htm", "");
strExcelHtml += "<img alt='' src='http://" + HttpContext.Current.Request.Url.Authority + "/SpecificOnDuty/" + strcid + ".bmp' width='80%' height='145%' />";
strExcelHtml += "</div></body></html>";
CreatHtmlFile(System.Web.Hosting.HostingEnvironment.MapPath(strfilePath), strExcelHtml, "" + strcid + ".xls");
JsonModel jsonModel = new JsonModel();
jsonModel.result = "0";
jsonModel.resultStr = "返回成功";
Random r = new Random();
jsonModel.strPDFURL = "http://" + HttpContext.Current.Request.Url.Authority + "/SpecificOnDuty/" + strcid + ".pdf?r=" + r.Next(1, 2000) + "";
jsonModel.strExcelURL = "http://" + HttpContext.Current.Request.Url.Authority + "/SpecificOnDuty/" + strcid + ".xls?r=" + r.Next(1, 2000) + "";
string result = Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel);
return(result);
}