public ActionResult VerifyDevice()
{
string deviceID, fileName, hs_sql, path, newPath;
deviceID = Request.Form["deviceID"];
fileName = Request.Form["fileName"];
DataTable dt1 = new DataTable();
hs_sql = "select * from DevicePing where DeviceID='" + deviceID + "'";
dt1 = DbHelperSQL.OpenTable(hs_sql);
if (dt1.Rows.Count > 0)
{
//获得文件路径
hs_sql = "select pathName from DeviceInfo where DeviceID='" + deviceID + "'";
path = DbHelperSQL.ExecuteQuery(hs_sql);
newPath = System.IO.Path.Combine(path, fileName);
newPath += ".xml";
path = System.IO.Path.Combine(path, "lasttime.xml");
try
{
//c#实现把一个文件从一个文件夹复制到另外一个文件夹并改名
System.IO.File.Copy(path, newPath, true);//允许覆盖目的地的同名文件
return(Content("Success"));
}
catch
{
return(Content("Nodata"));
}
}
else
{
return(Content("Nofound"));
}
}
//public ActionResult Read(string name)
//{
// string hs_sql = "select pathName from DeviceInfo where DeviceID='" + test.common.deviceID + "'";
// string path = DbHelperSQL.ExecuteQuery(hs_sql);
// string newPath = System.IO.Path.Combine(path, name);
// newPath = newPath + ".xml";
// test.common.ReadXML(newPath);
// return Content("Success");
//}
public ActionResult Write()
{
//声明设备ID，文件名，查询语句，路径，路径，JSON
string deviceID, fileName, hs_sql, path, newPath, name;
string[] pattern = new string[20];
deviceID = Request.Form["deviceID"];
fileName = Request.Form["fileName"];
name = Request.Form["name"];
//获得文件路径
hs_sql = "select pathName from DeviceInfo where DeviceID='" + deviceID + "'";
path = DbHelperSQL.ExecuteQuery(hs_sql);
newPath = System.IO.Path.Combine(path, fileName);
newPath += ".xml";
name = System.IO.Path.Combine(path, name);
name += ".xml";
try
{
//c#实现把一个文件从一个文件夹复制到另外一个文件夹并改名
System.IO.File.Copy(newPath, name, true);//允许覆盖目的地的同名文件
return(Content("Success"));
}
catch
{
return(Content("Nodata"));
}
}
public ActionResult SendData()
{
//声明设备ID，文件名，查询语句，路径，路径，JSON
string deviceID, fileName, hs_sql, path, newPath, json;
string[] famen = new string[10];
deviceID = Request.Form["deviceID"];
fileName = Request.Form["fileName"];
//获得文件路径
hs_sql = "select pathName from DeviceInfo where DeviceID='" + deviceID + "'";
path = DbHelperSQL.ExecuteQuery(hs_sql);
newPath = System.IO.Path.Combine(path, fileName);
newPath = newPath + ".xml";
//读取值
XMLHelper opXML = new XMLHelper(newPath);
famen[1] = opXML.QueryNodeText("num0501");
famen[2] = opXML.QueryNodeText("num0502");
famen[3] = opXML.QueryNodeText("num0503");
famen[4] = opXML.QueryNodeText("num0504");
famen[5] = opXML.QueryNodeText("num0505");
famen[6] = opXML.QueryNodeText("num0506");
famen[7] = opXML.QueryNodeText("num0507");
json = "{\"famen1\":\"" + famen[1] + "\","
+ "\"famen2\":\"" + famen[2] + "\","
+ "\"famen3\":\"" + famen[3] + "\","
+ "\"famen4\":\"" + famen[4] + "\","
+ "\"famen5\":\"" + famen[5] + "\","
+ "\"famen6\":\"" + famen[7] + "\","
+ "\"famen7\":\"" + famen[6] + "\"}";
return(Content(json));
}
/// <summary>
/// 获取省份列表
/// </summary>
/// <returns></returns>
public DataTable GetProvinceList()
{
string sql = "select ProvinceID,ProvinceName from SetProvinceTab where ProvinceID!=0000";
DataSet ds = DbHelperSQL.ExecuteQuery(sql);
return(ds.Tables[0]);
}
//发送信息
public ActionResult VerifyDevice()
{
string fileName, hs_sql, path, newPath;
string deviceID = Request.Form["deviceID"];
string AdminName = Request.Form["AdminName"];
string SendTime = Request.Form["SendTime"];
fileName = Request.Form["fileName"];
//获得文件路径
hs_sql = "select pathName from DeviceInfo where DeviceID='" + deviceID + "'";
path = DbHelperSQL.ExecuteQuery(hs_sql);
newPath = System.IO.Path.Combine(path, fileName);
newPath = newPath + ".xml";
//读取值
XMLHelper opXML = new XMLHelper(newPath);
bool ROV = opXML.ModifyNode("sendtime", SendTime);
opXML.saveFile();
hs_sql = "INSERT INTO SendTable (UserName,DeviceID,SendTime) VALUES ('" + AdminName + "','" + deviceID + "','" + SendTime + "')";
int row = DbHelperSQL.Execute(hs_sql);
hs_sql = "INSERT INTO HistSendTable (UserName,DeviceID,SendTime) VALUES ('" + AdminName + "','" + deviceID + "','" + SendTime + "')";
int row1 = DbHelperSQL.Execute(hs_sql);
if ((row > 0) && (row1 > 0) && (ROV == true))
{
return(Content("Success"));
}
else
{
return(Content("Error"));
}
}
public ActionResult postData()
{
//声明设备ID，文件名，查询语句，路径，路径，JSON
string deviceID, fileName, hs_sql, path, newPath;
//ROV是Return on Value返回值
bool[] ROV = new bool[30];
deviceID = Request.Form["deviceID"];
fileName = Request.Form["fileName"];
//获得文件路径
hs_sql = "select pathName from DeviceInfo where DeviceID='" + deviceID + "'";
path = DbHelperSQL.ExecuteQuery(hs_sql);
newPath = System.IO.Path.Combine(path, fileName);
newPath = newPath + ".xml";
try
{
XMLHelper opXML = new XMLHelper(newPath);
ROV[1] = opXML.ModifyNode("num1001", Request.Form["firsttd"]);
ROV[2] = opXML.ModifyNode("num1002", Request.Form["twotd"]);
ROV[3] = opXML.ModifyNode("num1003", Request.Form["threetd"]);
ROV[4] = opXML.ModifyNode("num1004", Request.Form["fourtd"]);
ROV[5] = opXML.ModifyNode("num1005", Request.Form["fivetd"]);
ROV[6] = opXML.ModifyNode("num1006", Request.Form["sixtd"]);
ROV[7] = opXML.ModifyNode("num1007", Request.Form["seventd"]);
ROV[8] = opXML.ModifyNode("num1008", Request.Form["eighttd"]);
ROV[9] = opXML.ModifyNode("num1009", Request.Form["ninetd"]);
ROV[10] = opXML.ModifyNode("num1010", Request.Form["tentd"]);
ROV[11] = opXML.ModifyNode("num1011", Request.Form["ycll"]);
ROV[12] = opXML.ModifyNode("num1012", Request.Form["ecll"]);
ROV[13] = opXML.ModifyNode("num1013", Request.Form["scll"]);
ROV[14] = opXML.ModifyNode("num3501", Request.Form["yitongdao"]);
ROV[15] = opXML.ModifyNode("num3502", Request.Form["ertongdao"]);
ROV[16] = opXML.ModifyNode("num3503", Request.Form["santongdao"]);
ROV[17] = opXML.ModifyNode("num3504", Request.Form["sitongdao"]);
ROV[18] = opXML.ModifyNode("num3505", Request.Form["wutongdao"]);
ROV[19] = opXML.ModifyNode("num3506", Request.Form["liutongdao"]);
ROV[20] = opXML.ModifyNode("num3507", Request.Form["qitongdao"]);
ROV[21] = opXML.ModifyNode("num3508", Request.Form["batongdao"]);
ROV[22] = opXML.ModifyNode("num3509", Request.Form["jiutongdao"]);
ROV[23] = opXML.ModifyNode("num3510", Request.Form["shitongdao"]);
ROV[24] = opXML.saveFile();
//用ROV判断写入是否成功，false失败
for (int i = 1; i < 24; i++)
{
if (ROV[i] == false)
{
return(Content("Error"));
}
}
return(Content("Success"));
}
catch
{
return(Content("Error"));
}
}
public ActionResult postData()
{
//声明设备ID，文件名，查询语句，路径，路径，JSON
string deviceID, fileName, hs_sql, path, newPath;
//ROV是Return on Value返回值
bool[] ROV = new bool[30];
deviceID = Request.Form["deviceID"];
fileName = Request.Form["fileName"];
//获得文件路径
hs_sql = "select pathName from DeviceInfo where DeviceID='" + deviceID + "'";
path = DbHelperSQL.ExecuteQuery(hs_sql);
newPath = System.IO.Path.Combine(path, fileName);
newPath = newPath + ".xml";
try
{
XMLHelper opXML = new XMLHelper(newPath);
ROV[1] = opXML.ModifyNode("num3401", Request.Form["mod1"]);
ROV[2] = opXML.ModifyNode("num3402", Request.Form["mod2"]);
ROV[3] = opXML.ModifyNode("num3403", Request.Form["mod3"]);
ROV[4] = opXML.ModifyNode("num3404", Request.Form["mod4"]);
ROV[5] = opXML.ModifyNode("num3405", Request.Form["mod5"]);
ROV[6] = opXML.ModifyNode("num3406", Request.Form["mod6"]);
ROV[7] = opXML.ModifyNode("num3407", Request.Form["mod7"]);
ROV[8] = opXML.ModifyNode("num3408", Request.Form["mod8"]);
ROV[9] = opXML.ModifyNode("num3409", Request.Form["mod9"]);
ROV[10] = opXML.ModifyNode("num3410", Request.Form["mod10"]);
ROV[11] = opXML.ModifyNode("num3411", Request.Form["mod11"]);
ROV[12] = opXML.ModifyNode("num3412", Request.Form["mod12"]);
ROV[13] = opXML.ModifyNode("num3413", Request.Form["mod13"]);
ROV[14] = opXML.ModifyNode("num3414", Request.Form["mod14"]);
ROV[15] = opXML.ModifyNode("num3415", Request.Form["mod15"]);
ROV[16] = opXML.ModifyNode("num3416", Request.Form["mod16"]);
ROV[17] = opXML.ModifyNode("num3417", Request.Form["mod17"]);
ROV[18] = opXML.ModifyNode("num3418", Request.Form["mod18"]);
ROV[19] = opXML.ModifyNode("num3419", Request.Form["mod19"]);
ROV[20] = opXML.ModifyNode("num3420", Request.Form["mod20"]);
ROV[21] = opXML.ModifyNode("num3422", Request.Form["mod22"]);
ROV[22] = opXML.saveFile();
//用ROV判断写入是否成功，false失败
for (int i = 1; i < 23; i++)
{
if (ROV[i] == false)
{
return(Content("Error"));
}
}
return(Content("Success"));
}
catch
{
return(Content("Error"));
}
}
public ActionResult SendData()
{
//声明设备ID，文件名，查询语句，路径，路径，JSON
string deviceID, fileName, hs_sql, path, newPath, json;
string[] mian = new string[30];
deviceID = Request.Form["deviceID"];
fileName = Request.Form["fileName"];
//获得文件路径
hs_sql = "select pathName from DeviceInfo where DeviceID='" + deviceID + "'";
path = DbHelperSQL.ExecuteQuery(hs_sql);
newPath = System.IO.Path.Combine(path, fileName);
newPath = newPath + ".xml";
//读取值
XMLHelper opXML = new XMLHelper(newPath);
mian[1] = opXML.QueryNodeText("num1101");
mian[2] = opXML.QueryNodeText("num1102");
mian[3] = opXML.QueryNodeText("num1103");
mian[4] = opXML.QueryNodeText("num1104");
mian[5] = opXML.QueryNodeText("num1105");
mian[6] = opXML.QueryNodeText("num1106");
mian[7] = opXML.QueryNodeText("num1107");
mian[8] = opXML.QueryNodeText("num1108");
mian[9] = opXML.QueryNodeText("num1109");
mian[10] = opXML.QueryNodeText("num1110");
mian[11] = opXML.QueryNodeText("num1111");
mian[12] = opXML.QueryNodeText("num1112");
mian[13] = opXML.QueryNodeText("num1113");
mian[14] = opXML.QueryNodeText("num1114");
mian[15] = opXML.QueryNodeText("num1115");
mian[16] = opXML.QueryNodeText("num1116");
mian[17] = opXML.QueryNodeText("num1117");
mian[18] = opXML.QueryNodeText("num1118");
json = "{\"mian1\":\"" + mian[1] + "\","
+ "\"mian2\":\"" + mian[2] + "\","
+ "\"mian3\":\"" + mian[3] + "\","
+ "\"mian4\":\"" + mian[4] + "\","
+ "\"mian5\":\"" + mian[5] + "\","
+ "\"mian6\":\"" + mian[6] + "\","
+ "\"mian7\":\"" + mian[7] + "\","
+ "\"mian8\":\"" + mian[8] + "\","
+ "\"mian9\":\"" + mian[9] + "\","
+ "\"mian10\":\"" + mian[10] + "\","
+ "\"mian11\":\"" + mian[11] + "\","
+ "\"mian12\":\"" + mian[12] + "\","
+ "\"mian13\":\"" + mian[13] + "\","
+ "\"mian14\":\"" + mian[14] + "\","
+ "\"mian15\":\"" + mian[15] + "\","
+ "\"mian16\":\"" + mian[16] + "\","
+ "\"mian17\":\"" + mian[17] + "\","
+ "\"mian18\":\"" + mian[18] + "\"}";
return(Content(json));
}
public ActionResult postData()
{
//声明设备ID，文件名，查询语句，路径，路径，JSON
string deviceID, fileName, hs_sql, path, newPath;
//ROV是Return on Value返回值
bool[] ROV = new bool[10];
deviceID = Request.Form["deviceID"];
fileName = Request.Form["fileName"];
//获得文件路径
hs_sql = "select pathName from DeviceInfo where DeviceID='" + deviceID + "'";
path = DbHelperSQL.ExecuteQuery(hs_sql);
newPath = System.IO.Path.Combine(path, fileName);
newPath = newPath + ".xml";
try
{
XMLHelper opXML = new XMLHelper(newPath);
ROV[1] = opXML.ModifyNode("num0501", Request.Form["famen1"]);
ROV[2] = opXML.ModifyNode("num0502", Request.Form["famen2"]);
ROV[3] = opXML.ModifyNode("num0503", Request.Form["famen3"]);
ROV[4] = opXML.ModifyNode("num0504", Request.Form["famen4"]);
ROV[5] = opXML.ModifyNode("num0505", Request.Form["famen5"]);
ROV[6] = opXML.ModifyNode("num0506", Request.Form["famen7"]); //三次开阀和开阀周期有错误，进行修正
ROV[7] = opXML.ModifyNode("num0507", Request.Form["famen6"]); //三次开阀和开阀周期有错误，进行修正
ROV[8] = opXML.saveFile();
//用ROV判断写入是否成功，false失败
for (int i = 1; i < 9; i++)
{
if (ROV[i] == false)
{
return(Content("Error"));
}
}
return(Content("Success"));
}
catch
{
return(Content("Error"));
}
}
public ActionResult SendData()
{ //声明设备ID，文件名，查询语句，路径，路径，JSON
string deviceID, fileName, hs_sql, path, newPath, json;
string daow, kongw, sud;
deviceID = Request.Form["deviceID"];
fileName = Request.Form["fileName"];
//获得文件路径
hs_sql = "select pathName from DeviceInfo where DeviceID='" + deviceID + "'";
path = DbHelperSQL.ExecuteQuery(hs_sql);
newPath = System.IO.Path.Combine(path, fileName);
newPath = newPath + ".xml";
//读取值
XMLHelper opXML = new XMLHelper(newPath);
daow = opXML.QueryNodeText("num1301");
kongw = opXML.QueryNodeText("num1302");
sud = opXML.QueryNodeText("num1303");
json = "{\"daow\":\"" + daow + "\","
+ "\"kongw\":\"" + kongw + "\","
+ "\"sud\":\"" + sud + "\"}";
return(Content(json));
}
public ActionResult SendData()
{
//声明设备ID，文件名，查询语句，路径，路径，JSON
string deviceID, fileName, hs_sql, path, newPath, json;
string[] modSet = new string[30];
deviceID = Request.Form["deviceID"];
fileName = Request.Form["fileName"];
//获得文件路径
hs_sql = "select pathName from DeviceInfo where DeviceID='" + deviceID + "'";
path = DbHelperSQL.ExecuteQuery(hs_sql);
newPath = System.IO.Path.Combine(path, fileName);
newPath = newPath + ".xml";
//读取值
XMLHelper opXML = new XMLHelper(newPath);
modSet[1] = opXML.QueryNodeText("num3401");
modSet[2] = opXML.QueryNodeText("num3402");
modSet[3] = opXML.QueryNodeText("num3403");
modSet[4] = opXML.QueryNodeText("num3404");
modSet[5] = opXML.QueryNodeText("num3405");
modSet[6] = opXML.QueryNodeText("num3406");
modSet[7] = opXML.QueryNodeText("num3407");
modSet[8] = opXML.QueryNodeText("num3408");
modSet[9] = opXML.QueryNodeText("num3409");
modSet[10] = opXML.QueryNodeText("num3410");
modSet[11] = opXML.QueryNodeText("num3411");
modSet[12] = opXML.QueryNodeText("num3412");
modSet[13] = opXML.QueryNodeText("num3413");
modSet[14] = opXML.QueryNodeText("num3414");
modSet[15] = opXML.QueryNodeText("num3415");
modSet[16] = opXML.QueryNodeText("num3416");
modSet[17] = opXML.QueryNodeText("num3417");
modSet[18] = opXML.QueryNodeText("num3418");
modSet[19] = opXML.QueryNodeText("num3419");
modSet[20] = opXML.QueryNodeText("num3420");
modSet[21] = opXML.QueryNodeText("num3421");
modSet[22] = opXML.QueryNodeText("num3422");
json = "{\"mod1\":\"" + modSet[1] + "\","
+ "\"mod2\":\"" + modSet[2] + "\","
+ "\"mod3\":\"" + modSet[3] + "\","
+ "\"mod4\":\"" + modSet[4] + "\","
+ "\"mod5\":\"" + modSet[5] + "\","
+ "\"mod6\":\"" + modSet[6] + "\","
+ "\"mod7\":\"" + modSet[7] + "\","
+ "\"mod8\":\"" + modSet[8] + "\","
+ "\"mod9\":\"" + modSet[9] + "\","
+ "\"mod10\":\"" + modSet[10] + "\","
+ "\"mod11\":\"" + modSet[11] + "\","
+ "\"mod12\":\"" + modSet[12] + "\","
+ "\"mod13\":\"" + modSet[13] + "\","
+ "\"mod14\":\"" + modSet[14] + "\","
+ "\"mod15\":\"" + modSet[15] + "\","
+ "\"mod16\":\"" + modSet[16] + "\","
+ "\"mod17\":\"" + modSet[17] + "\","
+ "\"mod18\":\"" + modSet[18] + "\","
+ "\"mod19\":\"" + modSet[19] + "\","
+ "\"mod20\":\"" + modSet[20] + "\","
+ "\"mod21\":\"" + modSet[21] + "\","
+ "\"mod22\":\"" + modSet[22] + "\"}";
return(Content(json));
}
public ActionResult SendData()
{
//声明设备ID，文件名，查询语句，路径，路径，JSON
string deviceID, fileName, hs_sql, path, newPath, json;
string[] flowSet = new string[40];
deviceID = Request.Form["deviceID"];
fileName = Request.Form["fileName"];
//获得文件路径
hs_sql = "select pathName from DeviceInfo where DeviceID='" + deviceID + "'";
path = DbHelperSQL.ExecuteQuery(hs_sql);
newPath = System.IO.Path.Combine(path, fileName);
newPath = newPath + ".xml";
//读取值
XMLHelper opXML = new XMLHelper(newPath);
flowSet[1] = opXML.QueryNodeText("num1001");
flowSet[2] = opXML.QueryNodeText("num1002");
flowSet[3] = opXML.QueryNodeText("num1003");
flowSet[4] = opXML.QueryNodeText("num1004");
flowSet[5] = opXML.QueryNodeText("num1005");
flowSet[6] = opXML.QueryNodeText("num1006");
flowSet[7] = opXML.QueryNodeText("num1007");
flowSet[8] = opXML.QueryNodeText("num1008");
flowSet[9] = opXML.QueryNodeText("num1009");
flowSet[10] = opXML.QueryNodeText("num1010");
flowSet[11] = opXML.QueryNodeText("num1011");
flowSet[12] = opXML.QueryNodeText("num1012");
flowSet[13] = opXML.QueryNodeText("num1013");
flowSet[21] = opXML.QueryNodeText("num3501");
flowSet[22] = opXML.QueryNodeText("num3502");
flowSet[23] = opXML.QueryNodeText("num3503");
flowSet[24] = opXML.QueryNodeText("num3504");
flowSet[25] = opXML.QueryNodeText("num3505");
flowSet[26] = opXML.QueryNodeText("num3506");
flowSet[27] = opXML.QueryNodeText("num3507");
flowSet[28] = opXML.QueryNodeText("num3508");
flowSet[29] = opXML.QueryNodeText("num3509");
flowSet[30] = opXML.QueryNodeText("num3510");
json = "{\"firsttd\":\"" + flowSet[1] + "\","
+ "\"twotd\":\"" + flowSet[2] + "\","
+ "\"threetd\":\"" + flowSet[3] + "\","
+ "\"fourtd\":\"" + flowSet[4] + "\","
+ "\"fivetd\":\"" + flowSet[5] + "\","
+ "\"sixtd\":\"" + flowSet[6] + "\","
+ "\"seventd\":\"" + flowSet[7] + "\","
+ "\"eighttd\":\"" + flowSet[8] + "\","
+ "\"ninetd\":\"" + flowSet[9] + "\","
+ "\"tentd\":\"" + flowSet[10] + "\","
+ "\"ycll\":\"" + flowSet[11] + "\","
+ "\"ecll\":\"" + flowSet[12] + "\","
+ "\"scll\":\"" + flowSet[13] + "\","
+ "\"yitongdao\":\"" + flowSet[21] + "\","
+ "\"ertongdao\":\"" + flowSet[22] + "\","
+ "\"santongdao\":\"" + flowSet[23] + "\","
+ "\"sitongdao\":\"" + flowSet[24] + "\","
+ "\"wutongdao\":\"" + flowSet[25] + "\","
+ "\"liutongdao\":\"" + flowSet[26] + "\","
+ "\"qitongdao\":\"" + flowSet[27] + "\","
+ "\"batongdao\":\"" + flowSet[28] + "\","
+ "\"jiutongdao\":\"" + flowSet[29] + "\","
+ "\"shitongdao\":\"" + flowSet[30] + "\"}";
return(Content(json));
}
public ActionResult SendData()
{
//声明设备ID，文件名，查询语句，路径，路径，JSON
string deviceID, fileName, hs_sql, path, newPath, json;
string[] pattern = new string[20];
string[] fileTime = new string[20];
deviceID = Request.Form["deviceID"];
fileName = Request.Form["fileName"];
//获得文件路径
hs_sql = "select pathName from DeviceInfo where DeviceID='" + deviceID + "'";
path = DbHelperSQL.ExecuteQuery(hs_sql);
newPath = System.IO.Path.Combine(path, "name.xml");
//读取各个文件上传时间和name.xml值
try
{
FileInfo fi;
fi = new FileInfo(path + @"\lasttime.xml");
fileTime[0] = fi.LastWriteTime.ToString();
fi = new FileInfo(path + @"\mode1.xml");
fileTime[1] = fi.LastWriteTime.ToString();
fi = new FileInfo(path + @"\mode2.xml");
fileTime[2] = fi.LastWriteTime.ToString();
fi = new FileInfo(path + @"\mode3.xml");
fileTime[3] = fi.LastWriteTime.ToString();
fi = new FileInfo(path + @"\mode4.xml");
fileTime[4] = fi.LastWriteTime.ToString();
fi = new FileInfo(path + @"\mode5.xml");
fileTime[5] = fi.LastWriteTime.ToString();
fi = new FileInfo(path + @"\mode6.xml");
fileTime[6] = fi.LastWriteTime.ToString();
fi = new FileInfo(path + @"\mode7.xml");
fileTime[7] = fi.LastWriteTime.ToString();
fi = new FileInfo(path + @"\mode8.xml");
fileTime[8] = fi.LastWriteTime.ToString();
fi = new FileInfo(path + @"\mode9.xml");
fileTime[9] = fi.LastWriteTime.ToString();
fi = new FileInfo(path + @"\mode10.xml");
fileTime[10] = fi.LastWriteTime.ToString();
fi = new FileInfo(path + @"\mode11.xml");
fileTime[11] = fi.LastWriteTime.ToString();
fi = new FileInfo(path + @"\mode12.xml");
fileTime[12] = fi.LastWriteTime.ToString();
fi = new FileInfo(path + @"\mode13.xml");
fileTime[13] = fi.LastWriteTime.ToString();
fi = new FileInfo(path + @"\mode14.xml");
fileTime[14] = fi.LastWriteTime.ToString();
fi = new FileInfo(path + @"\mode15.xml");
fileTime[15] = fi.LastWriteTime.ToString();
}
catch
{
}
XMLHelper opXML = new XMLHelper(newPath);
pattern[1] = opXML.QueryNodeText("name1");
pattern[2] = opXML.QueryNodeText("name2");
pattern[3] = opXML.QueryNodeText("name3");
pattern[4] = opXML.QueryNodeText("name4");
pattern[5] = opXML.QueryNodeText("name5");
pattern[6] = opXML.QueryNodeText("name6");
pattern[7] = opXML.QueryNodeText("name7");
pattern[8] = opXML.QueryNodeText("name8");
pattern[9] = opXML.QueryNodeText("name9");
pattern[10] = opXML.QueryNodeText("name10");
pattern[11] = opXML.QueryNodeText("name11");
pattern[12] = opXML.QueryNodeText("name12");
pattern[13] = opXML.QueryNodeText("name13");
pattern[14] = opXML.QueryNodeText("name14");
pattern[15] = opXML.QueryNodeText("name15");
pattern[16] = opXML.QueryNodeText("name96");
pattern[17] = opXML.QueryNodeText("name97");
json = "{\"p1\":\"" + pattern[1] + "\","
+ "\"p2\":\"" + pattern[2] + "\","
+ "\"p3\":\"" + pattern[3] + "\","
+ "\"p4\":\"" + pattern[4] + "\","
+ "\"p5\":\"" + pattern[5] + "\","
+ "\"p6\":\"" + pattern[6] + "\","
+ "\"p7\":\"" + pattern[7] + "\","
+ "\"p8\":\"" + pattern[8] + "\","
+ "\"p9\":\"" + pattern[9] + "\","
+ "\"p10\":\"" + pattern[10] + "\","
+ "\"p11\":\"" + pattern[11] + "\","
+ "\"p12\":\"" + pattern[12] + "\","
+ "\"p13\":\"" + pattern[13] + "\","
+ "\"p14\":\"" + pattern[14] + "\","
+ "\"p15\":\"" + pattern[15] + "\","
+ "\"p96\":\"" + pattern[16] + "\","
+ "\"p96\":\"" + pattern[17] + "\","
+ "\"time1\":\"" + fileTime[1] + "\","
+ "\"time2\":\"" + fileTime[2] + "\","
+ "\"time3\":\"" + fileTime[3] + "\","
+ "\"time4\":\"" + fileTime[4] + "\","
+ "\"time5\":\"" + fileTime[5] + "\","
+ "\"time6\":\"" + fileTime[6] + "\","
+ "\"time7\":\"" + fileTime[7] + "\","
+ "\"time8\":\"" + fileTime[8] + "\","
+ "\"time9\":\"" + fileTime[9] + "\","
+ "\"time10\":\"" + fileTime[10] + "\","
+ "\"time11\":\"" + fileTime[11] + "\","
+ "\"time12\":\"" + fileTime[12] + "\","
+ "\"time13\":\"" + fileTime[13] + "\","
+ "\"time14\":\"" + fileTime[14] + "\","
+ "\"time15\":\"" + fileTime[15] + "\","
+ "\"time0\":\"" + fileTime[0] + "\"}";
return(Content(json));
}
/// <summary>
/// 获得服务类型
/// </summary>
/// <returns></returns>
public DataSet GetTypeAll()
{
string sql = "SELECT * FROM ProfessionalTypeTbl";
return(DbHelperSQL.ExecuteQuery(sql));
}
