public FrmLogin()
{
InitializeComponent();
//判断数据库链接
bool isSucc = true;
try
{
ConnectConfigTool.setDBase();
}
catch (Exception ex)
{
MsgBox.ShowError(ex.Message + "请检查...");
isSucc = false;
}
if (ConnectConfigTool.DBase == null || !isSucc)
{
//弹出维护数据库维护界面
using (FrmSysConnSet frm = new FrmSysConnSet())
{
if (frm.ShowDialog() != DialogResult.OK)
{
Application.ExitThread();
Application.Exit();
return;
}
else
{
ConnectConfigTool.setDBase();
}
}
}
}
public FrmSecondDMain()
{
InitializeComponent();
this.Text = "AGV调度系统实时显示";
bool isSucc = true;
try
{
ConnectConfigTool.setDBase();
}
catch (Exception ex)
{
MsgBox.ShowError(ex.Message + "请检查...");
isSucc = false;
}
if (ConnectConfigTool.DBase == null || !isSucc)
{
//弹出维护数据库维护界面
using (FrmSysConnSet frm = new FrmSysConnSet())
{
if (frm.ShowDialog() != DialogResult.OK)
{
Application.ExitThread();
Application.Exit();
return;
}
}
}
using (WaitDialogForm dialog = new WaitDialogForm("正在启动,请稍后...", "提示"))
{
InitCanvas("", false);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
this.label1.Focus();
if (Valide())
{
using (DevExpress.Utils.WaitDialogForm dialog = new DevExpress.Utils.WaitDialogForm("正在测试数据库连接,请稍后...", "提示"))
{
if (TestdataBaseInfo == null)
{
TestdataBaseInfo = new DataBaseInfo();
}
TestdataBaseInfo.DataBaseName = this.txtDBName.Text.Trim();
TestdataBaseInfo.DbSource = this.txtIP.Text.Trim();
TestdataBaseInfo.Pwd = this.txtPass.Text.Trim();
TestdataBaseInfo.Uid = this.txtUser.Text.Trim();
IDbOperator dbTesthqOperator = CreateDbOperator.DbOperatorInstance(TestdataBaseInfo);
//测试数据库
if (dbTesthqOperator.ServerIsThrough())
{
}
else
{
MsgBox.ShowError("数据库地址不正确!");
return;
}
}
DataTable dt = ConnectConfigTool.GetDataTableStruct();
DataRow dr = dt.NewRow();
dr["DBIP"] = this.txtIP.Text.Trim();
dr["DBName"] = this.txtDBName.Text.Trim();
dr["DBUser"] = this.txtUser.Text.Trim();
dr["DBPass"] = this.txtPass.Text.Trim();
dr["ServerIP"] = this.txtServeIP.Text.Trim();
dr["ServerPort"] = this.txtServePort.Text.Trim();
dt.Rows.Add(dr);
DtToTxt(dt);
ConnectConfigTool.setDBase();
MsgBox.ShowWarn("保存成功!");
if (MsgBox.ShowQuestion("是否重新加载地图?") == DialogResult.Yes)
{
this.DialogResult = DialogResult.OK;
}
else
{
this.DialogResult = DialogResult.Cancel;
}
this.Close();
return;
}
}
catch (Exception ex)
{ MsgBox.ShowError(ex.Message); }
}
/// <summary>
/// 加载所有指令档案
/// </summary>
/// <returns></returns>
public static IList <CmdInfo> Load_Cmd()
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
DataTable dtResult = dbOperator.LoadDatas("Load_Cmd");
IList <CmdInfo> CmdInfos = ConnectConfigTool.TableToEntity <CmdInfo>(dtResult);
return(CmdInfos);
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
/// 加载调度程序里配置信息
/// </summary>
/// <returns></returns>
public static IList <DispatchAssembly> Load_DisptchAssembly()
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
DataTable dtResult = dbOperator.LoadDatas("Load_DisptchAssembly");
IList <DispatchAssembly> DispatchAssems = ConnectConfigTool.TableToEntity <DispatchAssembly>(dtResult);
return(DispatchAssems);
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
/// 根据呼叫器ID加载呼叫器配置明细
/// </summary>
/// <param name="CallBoxID"></param>
/// <returns></returns>
public static IList <CallBoxDetail> LoadCallBoxDetails(int CallBoxID)
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
Hashtable dic = new Hashtable();
dic["CallBoxID"] = CallBoxID;
DataTable dt = dbOperator.LoadDatas("LoadCallBoxDetails", dic);
return(ConnectConfigTool.TableToEntity <CallBoxDetail>(dt));
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
/// 加载用户可操作按钮
/// </summary>
public static IList <SysOprButtonToCategory> LoadUserOprBtn(string UserID)
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
Hashtable hs = new Hashtable();
hs["UserID"] = UserID;
DataTable dt = dbOperator.LoadDatas("QueryUserOperButttons", hs);
return(ConnectConfigTool.TableToEntity <SysOprButtonToCategory>(dt));
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
/// 加载所有的地标
/// </summary>
/// <returns></returns>
public static IList <LandMarkShap> LoadLandShaps()
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
Hashtable hs = new Hashtable();
DataTable dt = dbOperator.LoadDatas("getLandMarks", hs);
IList <LandMarkShap> lands = ConnectConfigTool.TableToEntity <LandMarkShap>(dt);
return(lands);
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
/// 加载所有的车辆信息
/// </summary>
/// <returns></returns>
public static IList <CarInfo> LoadCarShap()
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
Hashtable hs = new Hashtable();
DataTable dt = dbOperator.LoadDatas("LoadAGVAchive", hs);
IList <CarInfo> Cars = ConnectConfigTool.TableToEntity <CarInfo>(dt);
return(Cars);
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
/// 匹配线段配置
/// </summary>
/// <returns></returns>
public static IList <RouteFragmentConfigInfo> Load_RouteFragment()
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
Hashtable hs = new Hashtable();
DataTable dtResult = dbOperator.LoadDatas("Load_RouteFragment");
IList <RouteFragmentConfigInfo> RouteFragmens = ConnectConfigTool.TableToEntity <RouteFragmentConfigInfo>(dtResult);
return(RouteFragmens);
}
catch (Exception ex)
{ throw ex; }
}
public static IList <TraJunctionSegInfo> QueryJunctionSeg(int TraJunctionID)
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
Hashtable hs = new Hashtable();
hs["TraJunctionID"] = TraJunctionID;
DataTable dt = dbOperator.LoadDatas("QueryJunctionSeg", hs);
IList <TraJunctionSegInfo> segs = ConnectConfigTool.TableToEntity <TraJunctionSegInfo>(dt);
return(segs);
}
catch (Exception e)
{ throw e; }
}
/// <summary>
/// 根据任务配置明细加载其必经地标档案
/// </summary>
/// <returns></returns>
public static IList <TaskConfigMustPass> LoadTaskMustPass(string TaskConditonCode, int TaskConfigDetailID)
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
Hashtable dic = new Hashtable();
dic["TaskConditonCode"] = TaskConditonCode;
dic["TaskConfigDetailID"] = TaskConfigDetailID;
DataTable dt = dbOperator.LoadDatas("LoadTaskMustPass", dic);
return(ConnectConfigTool.TableToEntity <TaskConfigMustPass>(dt));
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
/// 根据任务明细查询相应必经地标的动作档案信息
/// </summary>
/// <returns></returns>
public static IList <TaskConfigMustPass> LoadIOActiones(string TaskConditonCode, int TaskConfigDetailID)
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
Hashtable hs = new Hashtable();
hs["TaskConditonCode"] = TaskConditonCode;
hs["TaskConfigDetailID"] = TaskConfigDetailID;
DataTable dtResult = dbOperator.LoadDatas("LoadMustPassbyConditonCode");
IList <TaskConfigMustPass> TaskConfigMustPasses = ConnectConfigTool.TableToEntity <TaskConfigMustPass>(dtResult);
return(TaskConfigMustPasses);
}
catch (Exception ex)
{ throw ex; }
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
try
{
ConnectConfigTool.setDBase();
}
catch (Exception ex)
{
MsgBox.ShowError(ex.Message + "请检查...");
Application.Exit();
return;
}
Application.Run(new FrmMain());
}
private void FrmSysConnSet_Shown(object sender, EventArgs e)
{
try
{
DataTable dt = ConnectConfigTool.TxtToDT();
if (dt != null && dt.Rows.Count > 0)
{
this.txtIP.Text = dt.Rows[0]["DBIP"].ToString();
this.txtDBName.Text = dt.Rows[0]["DBName"].ToString();
this.txtPass.Text = dt.Rows[0]["DBPass"].ToString();
this.txtUser.Text = dt.Rows[0]["DBUser"].ToString();
this.txtServeIP.Text = dt.Rows[0]["ServerIP"].ToString();
this.txtServePort.Text = dt.Rows[0]["ServerPort"].ToString();
}
this.label1.Focus();
}
catch (Exception ex)
{ MsgBox.ShowError(ex.Message); }
}
/// <summary>
/// 加载agv的当前路线
/// </summary>
public static List <LandmarkInfo> LoadCarRoute(CarInfo Car)
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
List <LandmarkInfo> route = new List <LandmarkInfo>();
Hashtable dic = new Hashtable();
dic["AGVID"] = Car.AgvID;
DataTable dt = dbOperator.LoadDatas("QueryAGVRoute", dic);
if (dt != null && dt.Rows.Count > 0)
{
string RouteLandCodes = dt.Rows[0]["RouteLandCodes"].ToString();
if (string.IsNullOrEmpty(RouteLandCodes))
{
return(route);
}
else
{
string[] LandCodes = RouteLandCodes.Split(',');
foreach (string item in LandCodes)
{
LandmarkInfo Land = CoreData.AllLands.FirstOrDefault(p => p.LandmarkCode == item);
if (Land == null)
{
continue;
}
else
{
route.Add(ConnectConfigTool.CreateDeepCopy <LandmarkInfo>(Land));
}
}
}
return(route);
}
else
{
return(route);
}
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
/// 根据IO动作ID加载对应的IO动作信息
/// </summary>
public static DispatchTaskInfo LoadTaskByNo(string No)
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
Hashtable hs = new Hashtable();
hs["dispatchNo"] = No;
DataTable dt = dbOperator.LoadDatas("LoadTaskByNo", hs);
IList <DispatchTaskInfo> Tasks = ConnectConfigTool.TableToEntity <DispatchTaskInfo>(dt);
if (Tasks != null && Tasks.Count > 0)
{
return(Tasks.FirstOrDefault());
}
else
{
return(null);
}
}
catch (Exception e)
{ throw e; }
}
/// <summary>
/// 根据呼叫器ID加载呼叫器信息
/// </summary>
/// <param name="BoxID"></param>
/// <returns></returns>
public static CallBoxInfo LoadAllCallBoxByID(int BoxID)
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
Hashtable dic = new Hashtable();
dic["CallBoxID"] = BoxID;
DataTable dt = dbOperator.LoadDatas("LoadCallBoxByID", dic);
IList <CallBoxInfo> CallBoxInfos = ConnectConfigTool.TableToEntity <CallBoxInfo>(dt);
if (CallBoxInfos == null || (CallBoxInfos != null && CallBoxInfos.Count <= 0))
{
return(null);
}
else
{
return(CallBoxInfos.FirstOrDefault());
}
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
/// 根据IO动作ID加载对应的IO动作信息
/// </summary>
public static IOActionInfo LoadAllIOAction(int IOActionID)
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
Hashtable hs = new Hashtable();
hs["IOActionID"] = IOActionID;
DataTable dt = dbOperator.LoadDatas("LoadIOActionByID");
IList <IOActionInfo> IOActiones = ConnectConfigTool.TableToEntity <IOActionInfo>(dt);
if (IOActiones != null && IOActiones.Count > 0)
{
return(IOActiones.FirstOrDefault());
}
else
{
return(null);
}
}
catch (Exception e)
{ throw e; }
}
public FrmSimula3D()
{
InitializeComponent();
this.MouseWheel += new System.Windows.Forms.MouseEventHandler(this.OnMouseWheel);
bool isSucc = true;
try
{
ConnectConfigTool.setDBase();
}
catch (Exception ex)
{
MsgBox.ShowError(ex.Message + "请检查...");
isSucc = false;
}
if (ConnectConfigTool.DBase == null || !isSucc)
{
//弹出维护数据库维护界面
using (FrmSysConnSet frm = new FrmSysConnSet())
{
if (frm.ShowDialog() != DialogResult.OK)
{
Application.ExitThread();
Application.Exit();
return;
}
}
}
try
{
ConnectConfigTool.setDBase();
}
catch (Exception ex)
{
MsgBox.ShowError(ex.Message + "请检查...");
return;
}
}
/// <summary>
/// 根据条件加载任务明细
/// </summary>
/// <returns></returns>
public static DispatchTaskDetail LoadTaskDetailByNo(string disPatchNo, int DetailID)
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
Hashtable dic = new Hashtable();
dic["dispatchNo"] = disPatchNo;
dic["DetailID"] = DetailID;
DataTable dtTaskDetailInfo = dbOperator.LoadDatas("LoadTaskDetailByNo", dic);
IList <DispatchTaskDetail> TaskDetail = ConnectConfigTool.TableToEntity <DispatchTaskDetail>(dtTaskDetailInfo);
if (TaskDetail != null && TaskDetail.Count > 0)
{
return(TaskDetail[0]);
}
else
{
return(null);
}
}
catch (Exception ex)
{ throw ex; }
}
public static DispatchTaskDetail GetTaskDetail(string No, int id)
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
Hashtable dic = new Hashtable();
dic["dispatchNo"] = No;
dic["TaskDetailID"] = id;
DataTable dtDetail = dbOperator.LoadDatas("GetTaskDetail", dic);
DispatchTaskDetail detail = null;
if (dtDetail != null && dtDetail.Rows.Count > 0)
{
detail = ConnectConfigTool.TableToEntity <DispatchTaskDetail>(dtDetail)[0];
return(detail);
}
else
{
return(null);
}
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
/// 验证用于信息
/// </summary>
/// <returns></returns>
public static UserInfo LoadUserInfo(string UserID, string PassWord)
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
Hashtable dic = new Hashtable();
dic["UserID"] = UserID;
dic["PassWord"] = PassWord;
DataTable dtUser = dbOperator.LoadDatas("LoadUserInfo", dic);
UserInfo user = null;
if (dtUser != null && dtUser.Rows.Count > 0)
{
user = ConnectConfigTool.TableToEntity <UserInfo>(dtUser)[0];
return(user);
}
else
{
return(null);
}
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
/// 根据条件加载任务信息
/// </summary>
public static IList <DispatchTaskInfo> LoadDispatchTask(string Condition)
{
try
{
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
Hashtable dic = new Hashtable();
dic["TaskState"] = Condition;
dic["CurrDate"] = DateTime.Now.ToString("yyyyMMdd");
dic["PreDate"] = DateTime.Now.AddDays(-1).ToString("yyyyMMdd");
DataTable dtTaskInfo = dbOperator.LoadDatas("LoadTaskInfo", dic);
IList <DispatchTaskInfo> Tasks = ConnectConfigTool.TableToEntity <DispatchTaskInfo>(dtTaskInfo);
foreach (DispatchTaskInfo item in Tasks)
{
dic["dispatchNo"] = item.dispatchNo;
DataTable dtTaskDetail = dbOperator.LoadDatas("LoadTaskDetail", dic);
IList <DispatchTaskDetail> TaskDetail = ConnectConfigTool.TableToEntity <DispatchTaskDetail>(dtTaskDetail);
item.TaskDetail = TaskDetail;
}
return(Tasks);
}
catch (Exception ex)
{ throw ex; }
}
private bool InitAndStartServer()
{
try
{
DelegateState.InvokeDispatchStateEvent("正在读取数据库连接...");
ConnectConfigTool.setDBase();
if (ConnectConfigTool.DBase == null)
{
DelegateState.InvokeDispatchStateEvent("数据库连接文件不存在!");
return(false);
}
IDbOperator dbOperator = CreateDbOperator.DbOperatorInstance(ConnectConfigTool.DBase);
if (dbOperator == null)
{
DelegateState.InvokeDispatchStateEvent("数据库连接文件不存在!");
return(false);
}
bool IsConnectDB = false;
try
{
IsConnectDB = dbOperator.ServerIsThrough();
}
catch (Exception ex)
{
DelegateState.InvokeDispatchStateEvent("数据库连接失败【" + ex.Message + "】");
}
if (!IsConnectDB)
{
return(false);
}
CoreData.dbOperator = dbOperator;
#region 读取系统参数
DelegateState.InvokeDispatchStateEvent("正在读取系统参数...");
DataTable dtSysparameter = CoreData.dbOperator.LoadDatas("QuerySyspara");
foreach (DataRow row in dtSysparameter.Rows)
{
CoreData.SysParameter[row["ParameterCode"].ToString()] = row["ParameterValue"].ToString();
}
DelegateState.InvokeDispatchStateEvent("读取系统参数成功...");
#endregion
DataTable dtAllCallBox = CoreData.dbOperator.LoadDatas("QueryAllCallBox");
CoreData.AllCallBoxes = DataToObject.TableToEntity <CallBoxInfo>(dtAllCallBox);
DataTable dtAllCallBoxDetail = CoreData.dbOperator.LoadDatas("QueryAllCallBoxDetails");
CoreData.AllCallBoxDetail = DataToObject.TableToEntity <CallBoxDetail>(dtAllCallBoxDetail);
//读取储位
DataTable dtstorage = CoreData.dbOperator.LoadDatas("QueryAllStore");
CoreData.StorageList = DataToObject.TableToEntity <StorageInfo>(dtstorage);
//读取区域
DataTable dtarea = CoreData.dbOperator.LoadDatas("LoadAllArea");
CoreData.AllAreaList = DataToObject.TableToEntity <AreaInfo>(dtarea);
//初始化呼叫器通信
Seccions.Clear();
foreach (CallBoxInfo callbox in CoreData.AllCallBoxes)
{
//if (callbox.CallBoxID != 5)
//{
// continue;
//}
SiemensConnectInfo ConnConfig = new SiemensConnectInfo()
{
ServerIP = callbox.CallBoxIP, Port = callbox.CallBoxPort
};
CommunicationSiemensPlc Commer = new CommunicationSiemensPlc(callbox.CallBoxID, ConnConfig);
if (!Commer.InitSiemens())
{
DelegateState.InvokeDispatchStateEvent("初始化呼叫器:" + callbox.CallBoxID.ToString() + "IP:" + "callbox.CallBoxIP" + "失败!");
continue;
}
Commer.Start();
Seccions.Add(Commer);
}
DelegateState.InvokeDispatchStateEvent("初始化成功...");
return(true);
}
catch (Exception ex)
{
DelegateState.InvokeDispatchStateEvent(ex.Message);
return(false);
}
}
public FrmConditonSet(IList <DetailCondition> has_Conditons)
{
InitializeComponent();
HasConditons = ConnectConfigTool.CreateDeepCopy <IList <DetailCondition> >(has_Conditons);
}
private void btnQuery_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
this.gvDetail.Focus();
if (QueryInfo == null)
{
MsgBox.ShowWarn("报表" + QueryCode + "不完整!");
return;
}
try
{
foreach (DetailCondition item in QueryInfo.Condition)
{
switch (item.control_type)
{
case 0:
TextBox txt = pnlCondition.Controls.Find(item.ConditionCode, true)[0] as TextBox;
item.RealyValue = txt.Text.Trim();
break;
case 1:
DateTimePicker dtp = pnlCondition.Controls.Find(item.ConditionCode, true)[0] as DateTimePicker;
item.RealyValue = dtp.Value.ToString("yyyy/MM/dd");
break;
case 2:
ComboBox cbx = pnlCondition.Controls.Find(item.ConditionCode, true)[0] as ComboBox;
string[] value = item.ConditionValue.Split(';');
string contian = value.Where(P => P.Contains(cbx.Text.ToString())).FirstOrDefault();
string reaValue = contian.Split(':')[0];
item.RealyValue = reaValue;
break;
default: break;
}
}
}
catch (Exception ex)
{
MsgBox.ShowError("报表条件配置有误!\r\n" + ex.Message);
}
DataTable res = AGVDAccess.AGVClientDAccess.ExcuteBI(QueryInfo);
if (res == null)
{
return;
}
DataTable Data = ConnectConfigTool.CreateDeepCopy <DataTable>(res);
foreach (DataColumn col in res.Columns)
{
int count = QueryInfo.Fileds.Where(P => P.FiledCode.Equals(col.ColumnName)).Count();
if (count == 0)
{
Data.Columns.Remove(col.ColumnName);
}
}
this.gcDetail.DataSource = Data;
gcDetail.Refresh();
//实现汇总方式
ModiFyName();
}
catch (Exception ex)
{ MsgBox.ShowError(ex.Message); }
}
public FrmDetailSqlSet(DetailQueryInfo queryinfo)
{
InitializeComponent();
QueryInfo = ConnectConfigTool.CreateDeepCopy <DetailQueryInfo>(queryinfo);
}