private ObservableCollection<JuncMesage> GetData(int id)
{
var Datas = new ObservableCollection<JuncMesage>();
SelectCmd scmd = new SelectCmd();
JuncRev rev = new JuncRev();
rev.ID = id;
scmd.SetReceiver(rev);
scmd.Execute();
if (rev.ListJunc == null || rev.ListJunc.Count <= 0)
return null;
mJunc = rev.ListJunc.ElementAt(0);
mJuncext = rev.ListJuncExt.ElementAt(0);
Datas.Add(new JuncMesage { ItemName = "井盖名称", ValueName = mJunc.JuncName });
Datas.Add(new JuncMesage { ItemName = "道路名称", ValueName = mJuncext.Lane_Way });
Datas.Add(new JuncMesage { ItemName = "经度", ValueName = Convert.ToString(mJunc.X_Coor) });
Datas.Add(new JuncMesage { ItemName = "纬度", ValueName = Convert.ToString(mJunc.Y_Coor) });
Datas.Add(new JuncMesage { ItemName = "检查井类别", ValueName = GetCategoryName(mJunc.Junc_Category) });
Datas.Add(new JuncMesage { ItemName = "检查井类型", ValueName = GetType(mJunc.Junc_Type) });
Datas.Add(new JuncMesage { ItemName = "检查井形式", ValueName = GetStyle(mJunc.Junc_Style) });
Datas.Add(new JuncMesage { ItemName = "井深", ValueName = GetDepth(mJunc.Depth) });
Datas.Add(new JuncMesage { ItemName = "井盖所处的地面高程", ValueName = GetDepth(mJunc.Surface_Ele) });
Datas.Add(new JuncMesage { ItemName = "数据来源", ValueName = GetDataSource(mJunc.DataSource) });
Datas.Add(new JuncMesage { ItemName = "数据填报单位", ValueName = mJunc.ReportDept });
Datas.Add(new JuncMesage { ItemName = "数据填报时间", ValueName = Convert.ToString(mJunc.Record_Date) });
Datas.Add(new JuncMesage { ItemName = "管道是否暗接", ValueName = bool2str(mJunc.Junc_Darkjoint) });
Datas.Add(new JuncMesage { ItemName = "污水是否直排", ValueName = bool2str(mJunc.Sewage_Line) });
Datas.Add(new JuncMesage { ItemName = "井盖错误", ValueName = bool2str(mJunc.Junc_Error) });
Datas.Add(new JuncMesage { ItemName = "CCTV检测编号", ValueName = mJunc.CCTV_CheckCode });
Datas.Add(new JuncMesage { ItemName = "数据是否完整", ValueName = bool2str(mJunc.FullData) });
Datas.Add(new JuncMesage { ItemName = "数据缺失原因", ValueName = mJunc.LoseReson });
Datas.Add(new JuncMesage { ItemName = "A上游井口至管顶距离", ValueName = GetDepth(mJunc.Dis[0]) });
Datas.Add(new JuncMesage { ItemName = "A上游井口至管底距离", ValueName = GetDepth(mJunc.Dis[1]) });
Datas.Add(new JuncMesage { ItemName = "A下游井口至管顶距离", ValueName = GetDepth(mJunc.Dis[2]) });
Datas.Add(new JuncMesage { ItemName = "A下游井口至管底距离", ValueName = GetDepth(mJunc.Dis[3]) });
Datas.Add(new JuncMesage { ItemName = "B上游井口至管顶距离", ValueName = GetDepth(mJunc.Dis[4]) });
Datas.Add(new JuncMesage { ItemName = "B上游井口至管底距离", ValueName = GetDepth(mJunc.Dis[5]) });
Datas.Add(new JuncMesage { ItemName = "B下游井口至管顶距离", ValueName = GetDepth(mJunc.Dis[6]) });
Datas.Add(new JuncMesage { ItemName = "B下游井口至管底距离", ValueName = GetDepth(mJunc.Dis[7]) });
Datas.Add(new JuncMesage { ItemName = "备注", ValueName = mJuncext.Remark });
return Datas;
}
static void Main(string[] args)
{
// CUser user = (CUser)(Assembly.Load(filepath).CreateInstance(filepath + ".DBClass." + "CUser"));
// if (user != null)
// {
// System.Console.WriteLine(user.ToString());
// System.Console.ReadLine();
// }
InsertCmd icmd = new InsertCmd();
LoadCmd lcmd = new LoadCmd();
SelectCmd scmd = new SelectCmd();
UpdateCmd ucmd = new UpdateCmd();
DeleteCmd dcmd = new DeleteCmd();
ClearCmd ccmd = new ClearCmd();
#region test TUser
// UserRev userrev = new UserRev();
// CUser u = new CUser();
// u.UserName = "******";
// u.UserType = 1;
// u.PassWord = "******";
// List<CUser> listuser = new List<CUser>();
// listuser.Add(u);
// userrev.ListUser = listuser;
// icmd.SetReceiver(userrev);
// icmd.Execute();
// lcmd.SetReceiver(userrev);
// lcmd.Execute();
// System.Console.WriteLine("Element number:{0}", userrev.ListUser.Count);
// userrev.UserName = "******";
// scmd.SetReceiver(userrev);
// scmd.Execute();
// System.Console.WriteLine("Element number:{0}", userrev.ListUser.Count);
// userrev.ListUser.ElementAt(0).PassWord = "******";
// ucmd.SetReceiver(userrev);
// ucmd.Execute();
// dcmd.SetReceiver(userrev);
// dcmd.Execute();
// ccmd.SetReceiver(userrev);
// ccmd.Execute();
#endregion
#region test TSystemBase
SystemRev sysrev = new SystemRev();
// CSystemBase sysbase = new CSystemBase();
// sysbase.SystemID = "2014722002";
// sysbase.SysName = "test system name";
// List<CSystemBase> list = new List<CSystemBase>();
// list.Add(sysbase);
// sysrev.SysList = list;
// icmd.SetReceiver(sysrev);
// icmd.Execute();
// lcmd.SetReceiver(sysrev);
// lcmd.Execute();
// System.Console.WriteLine(sysrev.SysList.Count);
//
// dcmd.SetReceiver(sysrev);
// dcmd.Execute();
#endregion
#region test PumpRev
PumpRev prev = new PumpRev();
// CPumpStationInfo pump = new CPumpStationInfo();
// pump.PumpName = "testpum";
// List<CPumpStationInfo> list = new List<CPumpStationInfo>();
// list.Add(pump);
// prev.ListPump = list;
// icmd.SetReceiver(prev);
// icmd.Execute();
// lcmd.SetReceiver(prev);
// lcmd.Execute();
// System.Console.WriteLine(prev.ListPump.Count);
// prev.PumpName = "testpum";
// scmd.SetReceiver(prev);
// scmd.Execute();
// System.Console.WriteLine(prev.ListPump.Count);
// prev.ListPump.ElementAt(0).PumpName = "Newname";
// ucmd.SetReceiver(prev);
// ucmd.Execute();
// dcmd.SetReceiver(prev);
// dcmd.Execute();
// ccmd.SetReceiver(prev);
// ccmd.Execute();
#endregion
#region test OutFallinfo
OutFallRev orev = new OutFallRev();
// COutFallInfo outfall = new COutFallInfo();
// COutFallExtInfo outext = new COutFallExtInfo();
// List<COutFallInfo> listoutfall = new List<COutFallInfo>();
// List<COutFallExtInfo> listoutext = new List<COutFallExtInfo>();
// outfall.Category = 1;
// outfall.SystemID = "2014722001";
// listoutfall.Add(outfall);
// outext.OutFallName = "outfallname";
// listoutext.Add(outext);
// orev.OutList = listoutfall;
// orev.OutExtList = listoutext;
// icmd.SetReceiver(orev);
// icmd.Execute();
// lcmd.SetReceiver(orev);
// lcmd.Execute();
// System.Console.WriteLine("OutList Number: {0},OutlistExt NUmber : {1}",orev.OutList.Count,orev.OutExtList.Count);
// orev.OutExtList.ElementAt(0).OutFallName = "New Name";
// orev.OutList.ElementAt(0).ReportDept = "adasda";
// ucmd.SetReceiver(orev);
// ucmd.Execute();
// dcmd.SetReceiver(orev);
// dcmd.Execute();
#endregion
#region test junction
JuncRev jrev = new JuncRev();
//lcmd.SetReceiver(jrev);
//lcmd.Execute();
//Console.WriteLine(jrev.ListJunc.Count);
//CJuncInfo junc = new CJuncInfo();
//CJuncExtInfo junext = new CJuncExtInfo();
//List<CJuncInfo> listjunc = new List<CJuncInfo>();
//List<CJuncExtInfo> listjuncext = new List<CJuncExtInfo>();
//junc.Junc_Style = 1;
//junc.X_Coor = 119.1232443;
//junc.Y_Coor = 21.123023123;
//junext.Lane_Way = "way name";
//listjuncext.Add(junext);
//listjunc.Add(junc);
//listjuncext.Add(junext);
//jrev.ListJunc = listjunc;
//icmd.SetReceiver(jrev);
//icmd.Execute();
jrev.JuncName = "ShiN-W1 / LongQ-W1";
scmd.SetReceiver(jrev);
scmd.Execute();
System.Console.WriteLine(jrev.ListJunc.Count);
//jrev.ListJunc.ElementAt(0).SystemID = "2102323";
//jrev.ListJuncExt.ElementAt(0).Junc_Class = 2;
//ucmd.SetReceiver(jrev);
//ucmd.Execute();
//dcmd.SetReceiver(jrev);
//dcmd.Execute();
//ccmd.SetReceiver(jrev);
//ccmd.Execute();
#endregion
#region test pipe
PipeRev piperev = new PipeRev();
// lcmd.SetReceiver(piperev);
// lcmd.Execute();
// System.Console.WriteLine(piperev.ListPipe.Count);
// CPipeInfo pipe = new CPipeInfo();
// pipe.PipeName = "Y2-Y3";
// List<CPipeInfo> listpipe = new List<CPipeInfo>();
// listpipe.Add(pipe);
// piperev.ListPipe = listpipe;
// icmd.SetReceiver(piperev);
// icmd.Execute();
//piperev.PipeName = "Y1-Y2";
//scmd.SetReceiver(piperev);
//scmd.Execute();
//System.Console.WriteLine(piperev.ListPipe.Count);
//System.Console.WriteLine(piperev.ListPipeExt.Count);
//System.Console.WriteLine(piperev.ListUS.Count);
//System.Console.WriteLine(piperev.ListLog.Count);
//System.Console.WriteLine(piperev.ListVideo.Count);
// ucmd.SetReceiver(piperev);
// ucmd.Execute();
//piperev.ListLog.Clear();
//piperev.ListPipeExt.Clear();
//dcmd.SetReceiver(piperev);
//dcmd.Execute();
#endregion
System.Console.WriteLine("Done");
System.Console.ReadLine();
}
public bool DoSave()
{
ObservableCollection<JuncMesage> datas = (ObservableCollection<JuncMesage>)JUNCDG.DataContext;
foreach (JuncMesage msg in datas)
{
try
{
ParseData(msg);
}
catch (Exception ex)
{
System.Console.WriteLine(ex.ToString());
string str = "";
if (ex is ExceptionProcess)
{
str += ((ExceptionProcess)ex).getReson() + "\n";
}
MessageBox.Show(str + "设置数据格式错误：" + msg.ItemName + " " + msg.ValueName);
return false;
}
}
UpdateCmd cmd = new UpdateCmd();
JuncRev rev = new JuncRev();
rev.ListJunc = new List<CJuncInfo>();
rev.ListJuncExt = new List<CJuncExtInfo>();
rev.ListJunc.Add(mJunc);
rev.ListJuncExt.Add(mJuncext);
cmd.SetReceiver(rev);
cmd.Execute();
return true;
}
protected void DelDB(Cover c)
{
if (c == null) return;
CJuncInfo info = c.juncInfo;
DeleteCmd cmd = new DeleteCmd();
JuncRev rev = new JuncRev();
rev.ListJunc = new List<CJuncInfo>();
rev.ListJunc.Add(info);
cmd.SetReceiver(rev);
cmd.Execute();
}
private int GetJuncId(string name)
{
JuncRev jr = new JuncRev();
jr.JuncName = name;
SelectCmd scmd = new SelectCmd();
scmd.SetReceiver(jr);
scmd.Execute();
CJuncInfo ji;
if (jr.ListJunc != null && jr.ListJunc.Count >= 0)
ji = jr.ListJunc.ElementAt(0);
else
throw new ExceptionProcess("找不到对应检查井");
return ji.ID;
}
private string GetJuncName(int id)
{
JuncRev jr = new JuncRev();
jr.ID = id;
SelectCmd scmd = new SelectCmd();
scmd.SetReceiver(jr);
scmd.Execute();
CJuncInfo ji;
if (jr.ListJunc != null && jr.ListJunc.Count >= 0)
ji = jr.ListJunc.ElementAt(0);
else
return "";
return ji.JuncName;
}
private bool SaverTodb(List<PipeSheetData> list)
{
//get the juncinfo. then
if (list == null || list.Count <= 0)
return false;
QuickInsert icm = new QuickInsert();
PipeRev rev = new PipeRev();
rev.ListPipe = new List<CPipeInfo>();
rev.ListPipeExt = new List<CPipeExtInfo>();
LoadCmd lcmd = new LoadCmd();
JuncRev junrev = new JuncRev();
lcmd.SetReceiver(junrev);
lcmd.Execute();
string pname = "";
try
{
foreach (PipeSheetData data in list)
{
CPipeInfo info = new CPipeInfo();
CPipeExtInfo extinfo = new CPipeExtInfo();
extinfo.Lane_Way = data.RoadName;
info.PipeName = data.PipeName;
info.Pipe_Category = GetCategory(data.PipeCategory);
info.Pipe_Len = 0;//default
int inid = CheckID(data.InCode, junrev.ListJunc);
int outid = CheckID(data.OutCode, junrev.ListJunc);
info.In_JunID = inid;
info.Out_JunID = outid;
info.In_UpEle = data.In_UpEle;
info.In_BottomEle = data.In_BottomEle;
info.Out_UpEle = data.Out_UpEle;
info.Out_BottomEle = data.Out_UpEle;
info.Shape_Data1 = data.In_R;
info.Shape_Data2 = data.Out_R;
info.ShapeType = GetShapeType(data.ShapeType);
info.ShapeData = data.ShapeData;
info.Material = Getmaterial(data.Matrial);
info.Roughness = data.Roughness;
info.DataSource = GetDataSource(data.DataSource);
info.Record_Date = data.DataTime;
info.ReportDept = data.RecordDept;
info.ReportDate = data.RecordTime;
extinfo.DataIsFull = data.DataFull;
extinfo.LoseReason = data.LoseReson;
extinfo.Remark = data.Remark;
rev.ListPipe.Add(info);
rev.ListPipeExt.Add(extinfo);
pname = data.PipeName;
}
}
catch(Exception e)
{
Console.WriteLine("PipeName : {0} in exception{1}",pname,e.Message);
}
icm.SetReceiver(rev);
icm.Execute();
return true;
}
private bool SaverTodb(List<JuncSheetData> list)
{
if (list == null || list.Count <= 0)
return false;
QuickInsert qicm = new QuickInsert();
JuncRev rev = new JuncRev();
rev.ListJunc = new List<CJuncInfo>();
rev.ListJuncExt = new List<CJuncExtInfo>();
foreach (JuncSheetData data in list)
{
CJuncInfo info = new CJuncInfo();
CJuncExtInfo extinfo = new CJuncExtInfo();
extinfo.Lane_Way = data.RoadName;
info.JuncName = data.JuncName;
info.Junc_Category = GetCategory(data.JuncCategory);
info.Junc_Type = GetType(data.JuncType);
info.Y_Coor = data.Latitude;
info.X_Coor = data.Longitude;
info.Surface_Ele = data.Height;
info.Junc_Style = GetStyle(data.JuncStyle);
info.Depth = data.Depth;
info.Junc_Darkjoint = data.JuncDarkjoint;
info.Sewage_Line = data.SewageLine;
info.Junc_Error = data.JuncError;
info.CCTV_CheckCode = data.CCTV_CheckCode;
info.DataSource = GetDataSource(data.DataSource);
info.Record_Date = data.DataTime;
info.ReportDept = data.RecordDept;
info.ReportDate = data.RecordTime;
for (int i = 0; i < 8;i++ )
{
info.Dis[i] = data.Dis[i];
}
info.FullData = data.DataFull;
info.LoseReson = data.LoseReson;
extinfo.Remark = data.Remark;
rev.ListJunc.Add(info);
rev.ListJuncExt.Add(extinfo);
}
qicm.SetReceiver(rev);
qicm.Execute();
return true;
}