/// <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; }
}
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);
}
public FrmConditonSet(IList <DetailCondition> has_Conditons)
{
InitializeComponent();
HasConditons = ConnectConfigTool.CreateDeepCopy <IList <DetailCondition> >(has_Conditons);
}
