public DB_SysConfig_Out GetDBSysConfig(string input)
{
DB_SysConfig_Out json = new DB_SysConfig_Out();
DB_SysConfig_In model = null;
try
{
model = JsonConvert.DeserializeObject <DB_SysConfig_In>(input);
string strSql = " select * from TAB_System_Config where strSection =@strSection and strIdent =@strIdent ";
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("strSection", model.SectionName), new SqlParameter("strIdent", model.Ident),
};
DataTable table =
SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters).Tables[0];
if (table != null && table.Rows.Count > 0)
{
json.data.strValue = table.Rows[0]["strValue"].ToString();
json.result = "0";
json.resultStr = "获取配置成功";
}
else
{
json.data.strValue = String.Empty;
json.result = "1";
json.resultStr = "获取配置失败";
}
}
catch (Exception ex)
{
LogClass.logex(ex, "");
throw ex;
}
return(json);
}
public SiteConfig_Out GetSiteConfig(string input)
{
SiteConfig_Out json = new SiteConfig_Out();
SiteConfig_In model = null;
try
{
model = JsonConvert.DeserializeObject <SiteConfig_In>(input);
string strSql = "select * from TAB_System_SiteConfig where strSiteNumber=@strSiteNumber ";
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("strSiteNumber", model.SiteNumber),
};
DataTable table =
SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters).Tables[0];
json.data = new List <SiteConfig>();
SiteConfig config = null;
foreach (DataRow dataRow in table.Rows)
{
config = new SiteConfig();
config.strName = dataRow["strName"].ToString();
config.strValue = dataRow["strValue"].ToString();
json.data.Add(config);
}
json.result = "0";
json.resultStr = "获取客户端配置成功";
}
catch (Exception ex)
{
LogClass.logex(ex, "");
throw ex;
}
return(json);
}
public IsJiaoLuInSite_Out IsJiaoLuInSite(string input)
{
IsJiaoLuInSite_Out json = new IsJiaoLuInSite_Out();
json.data = new IsJiaoLuInSiteResult();
IsJiaoLuInSite_In model = null;
string strSql = String.Empty;
DataTable table = null;
try
{
model = JsonConvert.DeserializeObject <IsJiaoLuInSite_In>(input);
strSql = @"select strTrainJiaoluGUID from TAB_Base_TrainJiaoluInSite where strSiteGUID =@strSiteGUID
and strTrainJiaoluGUID = @strTrainJiaoluGUID
union
select strSubTrainJiaoLuGUID from TAB_Base_TrainJiaolu_SubDetail where strTrainJiaoluGUID in
(select strTrainJiaoluGUID from TAB_Base_TrainJiaoluInSite where strSiteGUID =@strSiteGUID )
and strSubTrainJiaoLuGUID =@strTrainJiaoluGUID ";
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("strSiteGUID", model.SiteGUID), new SqlParameter("strTrainJiaoluGUID", model.TrainJiaoluGUID),
};
table =
SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters).Tables[0];
if (table != null && table.Rows.Count > 0)
{
json.data.isInSite = 1;
json.result = "0";
json.resultStr = "判断交路是否在客户端的管理范围成功";
}
else
{
json.data.isInSite = 0;
}
}
catch (Exception ex)
{
LogClass.logex(ex, "");
json.result = "1";
json.resultStr = "判断交路是否在客户端的管理范围失败";
throw ex;
}
return(json);
}
public TrainJiaolu_Out GetTrainJiaolu(string input)
{
TrainJiaolu_Out json = new TrainJiaolu_Out();
TrainJiaolu_In model = null;
RRsTrainJiaolu jiaolu = null;
try
{
model = JsonConvert.DeserializeObject <TrainJiaolu_In>(input);
string strSql = "select * from VIEW_Base_TrainJiaolu where strTrainJiaoluGUID=@strTrainJiaoluGUID ";
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("strTrainJiaoluGUID", model.strTrainJiaoluGUID),
};
DataTable table =
SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters).Tables[0];
json.data = new List <RRsTrainJiaolu>();
foreach (DataRow dataRow in table.Rows)
{
jiaolu = new RRsTrainJiaolu();
jiaolu.strEndStation = dataRow["strEndStation"].ToString();
jiaolu.strEndStationName = dataRow["strEndStationName"].ToString();
jiaolu.strStartStation = dataRow["strStartStation"].ToString();
jiaolu.strStartStationName = dataRow["strStartStationName"].ToString();
jiaolu.strTrainJiaoluGUID = dataRow["strTrainJiaoluGUID"].ToString();
jiaolu.strTrainJiaoluName = dataRow["strTrainJiaoluName"].ToString();
jiaolu.strWorkShopGUID = dataRow["strWorkShopGUID"].ToString();
jiaolu.bIsBeginWorkFP = Convert.ToInt32(dataRow["bIsBeginWorkFP"].ToString());
json.data.Add(jiaolu);
}
json.result = "0";
json.resultStr = "获取交路成功";
}
catch (Exception ex)
{
LogClass.logex(ex, "");
throw ex;
}
return(json);
}
public SetConfig_Out SetDBSysConfig(string input)
{
SetConfig_Out json = new SetConfig_Out();
SetConfig_In model = null;
string strSql = String.Empty;
int count = -1;
try
{
model = JsonConvert.DeserializeObject <SetConfig_In>(input);
strSql = "select count(*) from TAB_System_Config where strSection = @strSection and strIdent =@strIdent ";
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("strSection", model.SectionName), new SqlParameter("strIdent", model.Ident),
new SqlParameter("strValue", model.Value),
};
count =
Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql,
sqlParameters));
if (count == 0)
{
strSql =
"insert into TAB_System_Config(strSection,strIdent,strValue) values(@strSection,@strIdent,@strValue)";
}
else
{
strSql =
"update TAB_System_Config set strValue=@strValue where strSection = @strSection and strIdent =@strIdent ";
}
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters);
json.result = "0";
json.resultStr = "设置数据库配置成功";
}
catch (Exception ex)
{
LogClass.logex(ex, "");
throw ex;
}
return(json);
}
public GetStation_Out GetStationsOfJiaoJu(string input)
{
GetStation_Out json = new GetStation_Out();
json.data = new List <Station>();
GetStation_In model = null;
Station station = null;
string strSql = String.Empty;
try
{
model = JsonConvert.DeserializeObject <GetStation_In>(input);
strSql = @"select B.strStationGUID,B.strStationNumber,B.strStationName from
TAB_Base_StationInTrainJiaolu AS A inner join TAB_Base_Station AS B
ON B.strStationGUID = A.strStationGUID where A.strTrainJiaoluGUID = @strTrainJiaoluGUID order by nSortid";
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("strTrainJiaoluGUID", model.strJiaoLuID),
};
DataTable table =
SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters).Tables[0];
foreach (DataRow row in table.Rows)
{
station = new Station();
station.strStationGUID = row["strStationGUID"].ToString();
station.strStationName = row["strStationName"].ToString();
station.strStationNumber = row["strStationNumber"].ToString();
json.data.Add(station);
}
json.result = "0";
json.resultStr = "获取车站成功";
}
catch (Exception ex)
{
LogClass.logex(ex, "");
throw ex;
}
return(json);
}
public CheCi_Out GetKehuoByCheCi(string input)
{
CheCi_Out json = new CheCi_Out();
CheCi_In model = null;
//List<TrainNoBelong> trainNoBelongs = null;
//string strReg = String.Empty;
//Regex regex = null;
//int nBeginNumber, nEndNumber;
//bool isMatch = false;
try
{
#region 原来的代码
//model = JsonConvert.DeserializeObject<CheCi_In>(input);
//trainNoBelongs = GetTrainNoBelongArray();
//if (trainNoBelongs != null)
//{
// foreach (var trainNoBelong in trainNoBelongs)
// {
// nBeginNumber = trainNoBelong.nBeginNumber;
// nEndNumber = trainNoBelong.nEndNumber;
// int CheCi;
// json.result = "0";
// json.resultStr = "获取车次成功";
// //构造正则表达式
// if (String.IsNullOrEmpty(trainNoBelong.strTrainNoHead))
// {
// if (Int32.TryParse(model.TrainNo, out CheCi) && CheCi >= nBeginNumber && CheCi <= nEndNumber)
// {
// json.data.Kehuo = trainNoBelong.strKehuoName;
// isMatch = true;
// break;
// }
// }
// else
// {
// strReg = String.Format("^{0}", trainNoBelong.strTrainNoHead);
// }
// regex = new Regex(strReg);
// Match match = regex.Match(model.TrainNo);
// string strNum = String.Empty;
// if (match.Success)
// {
// int num;
// strNum = model.TrainNo.Substring(match.Length, model.TrainNo.Length - match.Length);
// if (strNum.Length > 0)
// {
// if ((Int32.TryParse(strNum, out num) && num >= nBeginNumber && num <= nEndNumber))
// {
// json.data.Kehuo = trainNoBelong.strKehuoName;
// isMatch = true;
// break;
// }
// }
// else
// {
// if (trainNoBelong.nBeginNumber == 0 && trainNoBelong.nEndNumber == 0)
// {
// json.data.Kehuo = trainNoBelong.strKehuoName;
// isMatch = true;
// break;
// }
// }
// }
// }
//}
//if (!isMatch)
//{
// //json.result = "1";
// //json.resultStr = "根据车次获取客货类型失败，没有找到匹配的规则";
// json.data.Kehuo = "";
//}
#endregion
string Remarks = "";
model = JsonConvert.DeserializeObject <CheCi_In>(input);
json.data.Kehuo = getKeHuoByTrainNo(model.TrainNo, ref Remarks);
json.data.Remarks = Remarks;
json.result = "0";
json.resultStr = "获取客货成功";
}
catch (Exception ex)
{
LogClass.logex(ex, "");
throw ex;
}
return(json);
}