/// <summary>
///
/// </summary>
/// <param name="pp"></param>
/// <param name="SerialNo"></param>
/// <param name="name"></param>
/// <param name="dwtype"></param>
/// <param name="startM"></param>
/// <param name="length"></param>
/// <param name="dt"></param>
/// <param name="AvgProgress"></param>
/// <param name="dkcode"></param>
public CRailwayDWProj(CRailwayProject pp, string SerialNo, string name, string dwtype, double startM, double length, DateTime dt, double AvgProgress, string dkcode = "DK")
{
mParentProj = pp;
mDWName = name;
mDWType = dwtype;
mSerialNo = SerialNo;
mMileage_Start = startM;
mDKCode_Start = dkcode;
mLength = length;
mUpdateTime = dt;
mAvgProgress = AvgProgress;
mIsValid = mParentProj.mScene.mMiddleLines.getPosbAndLengthByDKCode(dkcode, mMileage_Start,
out mLongitude_Mid, out mLatitude_Mid, out mAltitude_Mid, out mHeading_Mid, out mGlobalLength);
}
//public int mType1;
//public int mType2;
/// <summary>
///
/// </summary>
/// <param name="pp"></param>
/// <param name="SerialNo"></param>
/// <param name="name"></param>
/// <param name="startM"></param>
/// <param name="length"></param>
/// <param name="dt"></param>
/// <param name="AvgProgress"></param>
/// <param name="dkcode"></param>
public CRailwayDWProj(CRailwayProject pp, int pid, string SerialNo, int dwid, string name, double startM, double length, DateTime dt, bool isFinish, string dkcode)
{
mParentProj = pp;
mParentID = pid;
mDWID = dwid;
mDWName = name;
mSerialNo = SerialNo;
mMileage_Start = startM;
mDKCode_Start = dkcode;
mLength = length;
mFinishTime = dt;
//mAvgProgress = AvgProgress;
mIsDone = isFinish;
mIsValid = CRailwayLineList.getGPSbyDKCode(dkcode, mMileage_Start,
out mLongitude_Mid, out mLatitude_Mid, out mAltitude_Mid, out mHeading_Mid);
mIsOnMainPath = mParentProj.mScene.mMainPath.getPathMileageByDKCode(dkcode, mMileage_Start, out mMainMileage, out mdistanceToMainPath);
}
public List <String> mBeamName = new List <string>(); // 梁的名字
//public List<double> mBeamLength = new List<double>();
public CRailwayPier(CRailwayProject pp, int pid, string SerialNo, int dwid, string name, double startM, double endM, DateTime dt, bool isFinish, string dkcode)
: base(pp, pid, SerialNo, dwid, name, startM, endM, dt, isFinish, dkcode)
{
//string sqlstr = @"select * from (SELECT AutoID, Project_B_DW_ID, PropertyID, Value " +
// "FROM ProjectPropertyConfigInfo)a, " +
// "(SELECT AutoID, Property, Unit, UpdateTime, CrtUSrID " +
// "FROM ProjectPropertyInfo)b where a.PropertyID = b.AutoID and a.Project_B_DW_ID=" + dwid;
//System.Data.DataTable dtt = CServerWrapper.execSqlQuery(sqlstr);
//DatabaseWrapper.PrintDataTable(dtt);
string[] ss = name.Split('#');
try
{
DWName = ss[0];
}
catch (Exception e)
{
Console.WriteLine(name + "：桥墩名称解析错误:");
}
//getPierType(dwtype);
}
private void initProjectsFromServer()
{
#region init Items
//DataSet ds = null;
System.Data.DataTable dt = null;
string ProjectSQL = @"SELECT ProjectID, ProjectName, ProfessionalName, ProfessionalCategoryCode, ShorName,Mileage_Start,Mileage_Mid, Mileage_End,
MileagePrefix , SerialNo, UpdateTime, Direction , avgProgress, ParentID from vw_ProjectInfo where ProfessionalCategoryCode like '-1-42-26-%' OR
ProfessionalCategoryCode like '-1-42-27-%' OR ProfessionalCategoryCode like '-1-42-28-%' order by ProjectID asc;";
//string[] professionalCateCode = { "-1-42-26-", "-1-42-28-", "-1-42-27-" }; // 桥梁，路基，涵洞
string projectName, professionalName, ProfessionalCategoryCode, ShorName;
int projID, parentID;
double Mileage_Start, Mileage_End, Mileage_Mid;
string dkCode, SerialNo;
DateTime UpdateTime;
double Direction, avgProgress;
CRailwayProject sItem = null;
try
{
// if (isTunnel)
// ProjectSQL = @"SELECT ProjectID, ProjectName, ProfessionalName, ProfessionalCategoryCode, ShorName,Mileage_Start,Mileage_Mid, Mileage_End,
// Mileage_Start_Des,Mileage_Mid_Des, Mileage_End_Des, ProjectLenth, SerialNo, UpdateTime, Direction , avgProgress, ParentID from vw_ProjectInfo where ProfessionalCategoryCode like '";
// else
// ProjectSQL = @"SELECT ProjectID, ProjectName, ProfessionalName, ProfessionalCategoryCode, ShorName,Mileage_Start,Mileage_Mid, Mileage_End,
// Mileage_Start_Des,Mileage_Mid_Des, Mileage_End_Des, ProjectLenth, SerialNo, UpdateTime, Direction , avgProgress, ParentID from vw_ProjectInfo where ParentID=0 AND ProfessionalCategoryCode like '";
// //ProjectSQL += CServerWrapper.findProjectCode(projCode) + @"%' order by ProjectID asc;";
// ProjectSQL += projCode + @"%' order by ProjectID asc;";
dt = CServerWrapper.execSqlQuery(ProjectSQL);
//int count = dt.Rows.Count;
foreach (DataRow dataReader in dt.Rows)
{
projID = (int)dataReader["ProjectID"];
Mileage_Start = Convert.ToDouble(dataReader["Mileage_Start"]);
Mileage_Mid = Convert.ToDouble(dataReader["Mileage_Mid"]);
Mileage_End = Convert.ToDouble(dataReader["Mileage_End"]);
avgProgress = Convert.ToDouble(dataReader["avgProgress"]);
Direction = Convert.ToDouble(dataReader["Direction"]);
projectName = (string)dataReader["ProjectName"];
professionalName = (string)dataReader["ProfessionalName"];
ProfessionalCategoryCode = (string)dataReader["ProfessionalCategoryCode"];
ShorName = (string)dataReader["ShorName"];
dkCode = (string)dataReader["MileagePrefix"];
SerialNo = (string)dataReader["SerialNo"];
UpdateTime = (DateTime)dataReader["UpdateTime"]; // (DateTime)dataReader["UpdateTime"];
parentID = (int)dataReader["ProjectID"];
if (ProfessionalCategoryCode.StartsWith("-1-42-26-")) // 桥梁
{
if (ProfessionalCategoryCode.StartsWith("-1-42-26-81-")) // 连续梁
{
sItem = new CContBeam(this, SerialNo, projID, professionalName, projectName, ShorName, dkCode,
Mileage_Start, Mileage_Mid, Mileage_End, UpdateTime, avgProgress, Direction, @"桥梁.png");
mContBeamList.Add((CContBeam)sItem);
if (sItem.GlobalMileage > 0)
{
mTotalSpotList.Add(sItem);
}
}
else
{
sItem = new CRailwayBridge(this, SerialNo, projID, professionalName, projectName, ShorName, dkCode,
Mileage_Start, Mileage_Mid, Mileage_End, UpdateTime, avgProgress, Direction, @"桥梁.png");
mBridgeList.Add((CRailwayBridge)sItem);
}
}
else if (ProfessionalCategoryCode.StartsWith("-1-42-27-")) // 隧道，涵洞
{
sItem = new CRailwayTunnel(this, SerialNo, projID, professionalName, projectName, ShorName, dkCode,
Mileage_Start, Mileage_Mid, Mileage_End, UpdateTime, avgProgress, Direction, @"涵洞.png");
mTunnelList.Add((CRailwayTunnel)sItem);
if (sItem.GlobalMileage > 0)
{
mTotalSpotList.Add(sItem);
}
}
else if (ProfessionalCategoryCode.StartsWith("-1-42-28-")) // 路基
{
sItem = new CRailwayRoad(this, SerialNo, projID, professionalName, projectName, ShorName, dkCode,
Mileage_Start, Mileage_Mid, Mileage_End, UpdateTime, avgProgress, Direction, @"路基.png");
mRoadList.Add((CRailwayRoad)sItem);
if (sItem.GlobalMileage > 0)
{
mTotalSpotList.Add(sItem);
}
}
///没有车站表，暂时以站场路基计算，车站方向暂时位于铁路同一侧
//if (ProfessionalCategoryCode.StartsWith("-1-42-28-84-")) //-1-43-84-
//if (ProfessionalCategoryCode.StartsWith(CServerWrapper.findProjectCode("giscode_station")))
//{
// int ix = projectName.IndexOf('站');
////Console.WriteLine(projectName);
// if (ix >= 0)
// {
// projectName = projectName.Substring(0, ix + 1);
// Direction = 90;
// }
// sItem = new CRailwayProject(this, SerialNo, projID, professionalName, projectName, ShorName,
// Mileage_Start, Mileage_Mid, Mileage_End, Mileage_Start_Des, Mileage_Mid_Des, Mileage_End_Des, UpdateTime, avgProgress, Direction, fileName, projLength);
// mProjectList.Add(sItem);
// //mOtherList.Add(sItem);
// projList.Add(sItem);
//}
//else if (ProfessionalCategoryCode.StartsWith("-1-42-26-"))
//{
// sItem = new CRailwayProject(this, SerialNo, projID, professionalName, projectName, ShorName,
// Mileage_Start, Mileage_Mid, Mileage_End, Mileage_Start_Des, Mileage_Mid_Des, Mileage_End_Des, UpdateTime, avgProgress, Direction, @"桥梁.png", projLength);
// mProjectList.Add(sItem);
// mBridgeList.Add(sItem);
//}
//else if (ProfessionalCategoryCode.StartsWith("-1-42-28-"))
//{
// sItem = new CRailwayProject(this, SerialNo, projID, professionalName, projectName, ShorName,
// Mileage_Start, Mileage_Mid, Mileage_End, Mileage_Start_Des, Mileage_Mid_Des, Mileage_End_Des, UpdateTime, avgProgress, Direction, @"路基.png", projLength);
// mProjectList.Add(sItem);
// mRoadList.Add(sItem);
//}
//else if (ProfessionalCategoryCode.StartsWith("-1-42-31-")) // && projectName.EndsWith("站") // 梁厂
//{
// sItem = new CRailwayProject(this, SerialNo, projID, professionalName, projectName, ShorName,
// Mileage_Start, Mileage_Mid, Mileage_End, Mileage_Start_Des, Mileage_Mid_Des, Mileage_End_Des, UpdateTime, avgProgress, Direction, @"路基.png", projLength);
// mOtherList.Add(sItem);
// //mStationList.Add(sItem);
//}
//else if (ProfessionalCategoryCode.StartsWith("-1-42-27-") || ProfessionalCategoryCode.StartsWith("-1-42-74-"))
//{
// sItem = new CRailwayProject(this, SerialNo, projID, professionalName, projectName, ShorName,
// Mileage_Start, Mileage_Mid, Mileage_End, Mileage_Start_Des, Mileage_Mid_Des, Mileage_End_Des, UpdateTime, avgProgress, Direction, @"涵洞.png", projLength);
// mProjectList.Add(sItem);
// mTunnelList.Add(sItem);
//}
}
//System.Console.WriteLine("readok");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message.ToString());
}
#endregion
}
public CRailwayBeam(CRailwayProject pp, int pid, string SerialNo, int dwid, string name, double startM, double endM, DateTime dt, bool isFinish, string dkcode)
: base(pp, pid, SerialNo, dwid, name, startM, endM, dt, isFinish, dkcode = "DK")
{
}
public CRailwayBeam(CRailwayProject pp, string SerialNo, string name, string dwtype, double startM, double endM, DateTime dt, double AvgProgress, string dkcode)
: base(pp, SerialNo, name, dwtype, startM, endM, dt, AvgProgress, dkcode = "DK")
{
}
