///方法 private void BindData() { string strPartId = txtPartId.Text.Trim(); string strPartType = txtPartType.Text.Trim(); string strPartModule = txtMoudle.Text.Trim(); string strPartClass = txtClass.Text.Trim(); ByProductPartEntity ByProductPartEntity = new ByProductPartEntity(); PagingQueryConfig config = new PagingQueryConfig() { PageNo = pgnQueryResult.PageNo, PageSize = pgnQueryResult.PageSize }; DataSet dsReturn = ByProductPartEntity.GetByFourParameters(strPartId, strPartType, strPartModule, strPartClass, ref config); pgnQueryResult.Pages = config.Pages; pgnQueryResult.Records = config.Records; if (!string.IsNullOrEmpty(ByProductPartEntity.ErrorMsg)) { MessageService.ShowMessage(ByProductPartEntity.ErrorMsg); return; } if (dsReturn.Tables.Count > 0) { gcList.DataSource = dsReturn.Tables[0].DefaultView; gcList.MainView = gvList; gvList.BestFitColumns(); } }
private void BindWorkOrderInfo() { PagingQueryConfig config = new PagingQueryConfig() { PageNo = pgnWorkOrderInfoList.PageNo, PageSize = pgnWorkOrderInfoList.PageSize }; WorkOrders workOrders = new WorkOrders(); this.Factory = this.cbeFactory.Text; this.Status = this.cbeStatus.Text; this.WorkOrderNo = this.teWorkOrderNo.Text; this.PartNo = this.tePart.Text; this.Type = this.cbeType.Text; this.Store = this.teStore.Text; DataSet ds = workOrders.GetWorkOrderByCondition(this.Factory, this.WorkOrderNo, this.PartNo, this.Type, this.Store, this.Status, ref config); pgnWorkOrderInfoList.Pages = config.Pages; pgnWorkOrderInfoList.Records = config.Records; if (string.IsNullOrEmpty(workOrders.ErrorMsg)) { Content.MainView = gridView1; Content.DataSource = ds.Tables[0]; gridView1.BestFitColumns(); } else { MessageService.ShowMessage(workOrders.ErrorMsg); } }
/// <summary> /// 绑定领料项目列表。 /// </summary> /// <param name="paramTable"></param> private void BindReceiveMaterialList(DataTable paramTable) { ReceiveMaterialEntity receiveMaterial = new ReceiveMaterialEntity(); PagingQueryConfig config = new PagingQueryConfig() { PageNo = pgnQueryResult.PageNo, PageSize = pgnQueryResult.PageSize }; DataSet dsReturn = receiveMaterial.GetReceiveMaterialHistory(paramTable, ref config); pgnQueryResult.Pages = config.Pages; pgnQueryResult.Records = config.Records; if (string.IsNullOrEmpty(receiveMaterial.ErrorMsg)) { gdcView.MainView = gdvReceiveMaterialList; gdcView.DataSource = dsReturn.Tables[0]; gdvReceiveMaterialList.Invalidate(); gdvReceiveMaterialList.OptionsView.ColumnAutoWidth = false; gdvReceiveMaterialList.BestFitColumns(); } else { MessageBox.Show(receiveMaterial.ErrorMsg); } }
/// <summary> /// 工单清单。 /// </summary> /// <param name="pconfig">分页设置对象。</param> /// <returns>包含工单数据的数据集。</returns> public DataSet GetWorkOrderInfoList(ref PagingQueryConfig config) { DataSet dsReturn = new DataSet(); try { //调用远程对象 IServerObjFactory factor = CallRemotingService.GetRemoteObject(); if (null != factor) { dsReturn = factor.CreateIWorkOrders().GetWorkOrderInfoList(ref config); string returnMessage = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn); //若返回错误消息,则显示 if (returnMessage.Length > 0) { MessageService.ShowError(returnMessage); } else { return(dsReturn); } } } catch (Exception e) { MessageService.ShowError(e); } finally { //注销通道 CallRemotingService.UnregisterChannel(); } return(dsReturn); }
/// <summary> /// 绑定查询数据。 /// </summary> public void BindData() { OnlineMaterialQueryModel model = new OnlineMaterialQueryModel(this.Model); if (string.IsNullOrEmpty(model.StoreName)) { model.StoreName = PropertyService.Get(PROPERTY_FIELDS.STORES); } if (string.IsNullOrEmpty(model.OperationName)) { model.OperationName = PropertyService.Get(PROPERTY_FIELDS.OPERATIONS); } PagingQueryConfig config = new PagingQueryConfig() { PageNo = pgnQueryResult.PageNo, PageSize = pgnQueryResult.PageSize }; DataSet dsReturn = this._entity.Query(model, ref config); pgnQueryResult.Pages = config.Pages; pgnQueryResult.Records = config.Records; if (!string.IsNullOrEmpty(this._entity.ErrorMsg)) { MessageService.ShowMessage(this._entity.ErrorMsg); return; } if (dsReturn.Tables.Count > 0) { gcResult.DataSource = dsReturn.Tables[0]; gcResult.MainView = gvResult; gvResult.BestFitColumns(); } }
/// <summary> /// 绑定预设暂停的批次数据到控件中。 /// </summary> private void BindFutureHoldLotToControl() { FutureHoldEntity entity = new FutureHoldEntity(); DataSet dsParams = new DataSet(); Hashtable htParams = new Hashtable(); if (!string.IsNullOrEmpty(this._factoryRoomKey)) { htParams.Add(POR_LOT_FIELDS.FIELD_FACTORYROOM_KEY, this._factoryRoomKey); } if (!string.IsNullOrEmpty(this._lotNo)) { htParams.Add(WIP_FUTUREHOLD_FIELDS.FIELDS_LOT_NUMBER, this._lotNo); } if (!string.IsNullOrEmpty(this._operationName)) { htParams.Add(WIP_FUTUREHOLD_FIELDS.FIELDS_OPERATION_NAME, this._operationName); } if (!string.IsNullOrEmpty(this._workOrderNo)) { htParams.Add(WIP_FUTUREHOLD_FIELDS.FIELDS_WORKORDER_NUMBER, this._workOrderNo); } if (!string.IsNullOrEmpty(this._action)) { htParams.Add(WIP_FUTUREHOLD_FIELDS.FIELDS_ACTION_NAME, this._action); } DataTable dtParams = FanHai.Hemera.Share.Common.CommonUtils.ParseToDataTable(htParams); dsParams.Tables.Add(dtParams); PagingQueryConfig config = new PagingQueryConfig() { PageNo = pgnQueryResult.PageNo, PageSize = pgnQueryResult.PageSize }; DataSet ds = entity.Query(dsParams, ref config); pgnQueryResult.Pages = config.Pages; pgnQueryResult.Records = config.Records; if (string.IsNullOrEmpty(entity.ErrorMsg)) { this.gcLot.DataSource = ds.Tables[0]; gvLot.BestFitColumns(); } else { MessageService.ShowMessage(entity.ErrorMsg, MESSAGEBOX_CAPTION); } }
/// <summary> /// 接口方法的实现 /// </summary> /// Q.001 private void paginationControl1_DataPaging() { PagingQueryConfig config = new PagingQueryConfig() { PageNo = paginationControl1.PageNo, PageSize = paginationControl1.PageSize }; DataSet dsHis = edcPoint.GetEdcPointParamsTrans(ref config); if (dsHis.Relations.Count > 0) { paginationControl1.Pages = config.Pages; paginationControl1.Records = config.Records; this.gcHistoryResults.DataSource = dsHis.Relations[0].ParentTable; } }
/// <summary> /// 查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void QueryBtn_Click(object sender, EventArgs e) { DataSet dsParams = this.GetQueryCondition(); PagingQueryConfig config = new PagingQueryConfig() { PageNo = pgnQueryResult.PageNo, PageSize = pgnQueryResult.PageSize }; DataSet dsReturn = this._entity.Query(dsParams, ref config); if (!string.IsNullOrEmpty(this._entity.ErrorMsg)) { MessageService.ShowMessage(this._entity.ErrorMsg); return; } pgnQueryResult.Pages = config.Pages; pgnQueryResult.Records = config.Records; if (dsReturn.Tables.Count > 0) { DataTable dt = dsReturn.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["ISSYN"].ToString() == "0") { dt.Rows[i]["ISSYN"] = "未同步"; } else { dt.Rows[i]["ISSYN"] = "已同步"; } } gridControl1.DataSource = dt; this.gridControl1.MainView = gridView1; } if (gridView1.RowCount > 0) { gridView1.SelectRow(0); SelectedRowChanged(gridView1); } else { gridControl2.DataSource = null; } }
/// <summary> /// 查询外向交货单出库记录 /// </summary> /// <param name="dsParam"></param> /// <param name="PQConf"></param> /// <param name="status"></param> /// <returns></returns> public DataSet Query(DataSet dsParam, ref PagingQueryConfig PQConf) { DataSet dsReturn = null; try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); dsReturn = serverFactory.Get <IOutboundOperationEngine>().Query(dsParam, ref PQConf); } catch (Exception ex) { _errorMsg = ex.Message; } finally { CallRemotingService.UnregisterChannel(); } return(dsReturn); }
/// <summary> /// 查询入库单记录。 /// </summary> /// <param name="dsParams">包含查询条件的数据集。</param> /// <param name="config">分页配置对象。</param> /// <returns>包含出货信息的数据集对象。</returns> public DataSet Query(DataSet dsParams, ref PagingQueryConfig config) { DataSet dsReturn = null; try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); dsReturn = serverFactory.Get <IWarehouseWarrantOperationEngine>().QueryWarehouseWarrant(dsParams, ref config); _errorMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn); } catch (Exception ex) { _errorMsg = ex.Message; } finally { CallRemotingService.UnregisterChannel(); } return(dsReturn); }
/// <summary> /// 捞取修改抽检点的his /// </summary> /// <param name="?"></param> /// <returns></returns> /// Q.003 public DataSet GetEdcPointParamsTrans(ref PagingQueryConfig config) { DataSet dsReturn = new DataSet(); try { IServerObjFactory obj = CallRemotingService.GetRemoteObject(); dsReturn = obj.CreateIEDCPiont().GetEdcPiontParamsTrans(_pointRowKey, ref config); _errorMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn); } catch (Exception ex) { _errorMsg = ex.Message; } finally { CallRemotingService.GetRemoteObject(); } return(dsReturn); }
/// <summary> /// 查询在线物料信息。 /// </summary> /// <param name="model"> /// 包含查询条件对象。 /// </param> /// <param name="pconfig"> /// 分页查询的配置对象。 /// </param> /// <returns>包含在线物料信息的数据集。</returns> public DataSet Query(OnlineMaterialQueryModel model, ref PagingQueryConfig pconfig) { DataSet dsReturn = null; try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); dsReturn = serverFactory.CreateIOnlineMaterialQueryEngine().Query(model, ref pconfig); _errorMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn); } catch (Exception ex) { _errorMsg = ex.Message; } finally { CallRemotingService.UnregisterChannel(); } return(dsReturn); }
/// <summary> /// 查询包含托盘信息及其组件序列号的数据集。 /// </summary> /// <param name="dsSearch"> /// 包含查询条件的数据集。 /// </param> /// <param name="pconfig"> /// 分页查询的配置对象。 /// </param> /// <returns>包含托盘信息及其组件序列号的数据集。。</returns> public DataSet QueryDetail(DataSet dsParams, ref PagingQueryConfig pconfig) { DataSet dsReturn = null; try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); dsReturn = serverFactory.Get <IPalletQueryEngine>().SearchPalletDetailList(dsParams, ref pconfig); _errorMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn); } catch (Exception ex) { _errorMsg = ex.Message; } finally { CallRemotingService.UnregisterChannel(); } return(dsReturn); }
public DataSet GetMaterialSendingList(DataTable paramTable, ref PagingQueryConfig config) { DataSet dsReturn = new DataSet(); try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); dsReturn = serverFactory.CreateIMaterialReqOrReturnEngine().GetMaterialSendingList(paramTable, ref config); _errorMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn); } catch (Exception ex) { _errorMsg = ex.Message; } finally { CallRemotingService.UnregisterChannel(); } return(dsReturn); }
/// <summary> /// 绑定查询结果。 /// </summary> private void BindQueryResult() { string palletNo = this.tePalletNo.Text.Trim(); //查询批次 PagingQueryConfig config = new PagingQueryConfig() { PageNo = pgnQueryResult.PageNo, PageSize = pgnQueryResult.PageSize }; //组织查询参数。 DataSet dsParams = new DataSet(); Hashtable htParams = new Hashtable(); htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_VIRTUAL_PALLET_NO, palletNo); if (!string.IsNullOrEmpty(this._model.RoomKey)) { htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_ROOM_KEY, this._model.RoomKey); } htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_CS_DATA_GROUP, (int)this._model.PalletState); DataTable dtParams = CommonUtils.ParseToDataTable(htParams); dtParams.TableName = TRANS_TABLES.TABLE_MAIN_DATA; dsParams.Tables.Add(dtParams); //进行查询 DataSet dsReturn = _entity.Query(dsParams, ref config); pgnQueryResult.Pages = config.Pages; pgnQueryResult.Records = config.Records; if (!string.IsNullOrEmpty(_entity.ErrorMsg)) { MessageService.ShowMessage(_entity.ErrorMsg); return; } else { gcResult.DataSource = dsReturn.Tables[0]; gcResult.MainView = gvResult; } }
/// <summary> /// 查询离线数据采集数据。 /// </summary> /// <param name="dtParams">数据采集实例。</param> /// <param name="config">分页配置对象。</param> /// <returns>包含数据采集数据的数据集对象。</returns> public DataSet QueryEDCData(DataTable dtParams, ref PagingQueryConfig config) { DataSet dsReturn = new DataSet(); try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); if (null != serverFactory) { dsReturn = serverFactory.CreateIEDCEngine().QueryEDCData(dtParams, ref config); _errorMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn); } } catch (Exception ex) { _errorMsg = ex.Message; } finally { CallRemotingService.UnregisterChannel(); } return(dsReturn); }
/// <summary> /// 查询按钮Click事件。 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnQuery_Click(object sender, EventArgs e) { DataSet dsParams = this.GetQueryCondition(); PagingQueryConfig config = new PagingQueryConfig() { PageNo = pgnQueryResult.PageNo, PageSize = pgnQueryResult.PageSize }; DataSet dsReturn = this._entity.Query(dsParams, ref config); pgnQueryResult.Pages = config.Pages; pgnQueryResult.Records = config.Records; if (!string.IsNullOrEmpty(this._entity.ErrorMsg)) { MessageService.ShowMessage(this._entity.ErrorMsg); return; } if (dsReturn.Tables.Count > 0) { gcList.DataSource = dsReturn.Tables[0]; gcList.MainView = gvList; gvList.BestFitColumns(); } }
/// <summary> /// 绑定设备物料看板。 /// </summary> /// <param name="paramTable"></param> private void BindMaterialList(DataTable paramTable) { PagingQueryConfig config = new PagingQueryConfig() { PageNo = pgnQueryResult.PageNo, PageSize = pgnQueryResult.PageSize }; DataSet dsReturn = materialReqOrReturnEntity.GetEquMaterialInf(paramTable, ref config); pgnQueryResult.Pages = config.Pages; pgnQueryResult.Records = config.Records; if (string.IsNullOrEmpty(materialReqOrReturnEntity.ErrorMsg)) { gdcView.MainView = gdvMaterialList; gdcView.DataSource = dsReturn.Tables[0]; gdvMaterialList.Invalidate(); gdvMaterialList.BestFitColumns(); } else { MessageBox.Show(materialReqOrReturnEntity.ErrorMsg); } }
/// <summary> /// 绑定查询结果。 /// </summary> private void BindQueryResult() { string lotNumber = this.teLotNumber.Text.Trim(); //查询批次 PagingQueryConfig config = new PagingQueryConfig() { PageNo = pgnQueryResult.PageNo, PageSize = pgnQueryResult.PageSize }; //组织查询参数。 DataSet dsParams = new DataSet(); Hashtable htParams = new Hashtable(); htParams.Add(POR_LOT_FIELDS.FIELD_LOT_NUMBER, lotNumber); htParams.Add(POR_LOT_FIELDS.FIELD_FACTORYROOM_KEY, this._model.RoomKey); switch (_model.OperationType) { case LotOperationType.CellScrap: case LotOperationType.CellDefect: case LotOperationType.ReturnMaterial: htParams.Add(POR_LOT_FIELDS.FIELD_HOLD_FLAG, 0); //0:未暂停的批次;1:暂停的批次。 htParams.Add(POR_LOT_FIELDS.FIELD_DELETED_TERM_FLAG, 0); //0:未结束未删除 1:已结束 2:已删除 break; case LotOperationType.Scrap: case LotOperationType.Defect: case LotOperationType.Terminal: case LotOperationType.Merge: case LotOperationType.Split: htParams.Add(POR_LOT_FIELDS.FIELD_HOLD_FLAG, 0); //0:未暂停的批次;1:暂停的批次。 htParams.Add(POR_LOT_FIELDS.FIELD_LOT_TYPE, "N"); //N:生产批次 L:组件补片批次 htParams.Add(POR_LOT_FIELDS.FIELD_DELETED_TERM_FLAG, 0); //0:未结束未删除 1:已结束 2:已删除 break; case LotOperationType.CellPatch: case LotOperationType.CellRecovered: htParams.Add(POR_LOT_FIELDS.FIELD_HOLD_FLAG, 0); //0:未暂停的批次;1:暂停的批次。 htParams.Add(POR_LOT_FIELDS.FIELD_LOT_TYPE, "L"); //N:生产批次 L:组件补片批次 htParams.Add(POR_LOT_FIELDS.FIELD_DELETED_TERM_FLAG, 0); //0:未结束未删除 1:已结束 2:已删除 break; case LotOperationType.Adjust: case LotOperationType.BatchAdjust: case LotOperationType.Hold: case LotOperationType.BatchHold: htParams.Add(POR_LOT_FIELDS.FIELD_HOLD_FLAG, 0); //0:未暂停的批次;1:暂停的批次。 htParams.Add(POR_LOT_FIELDS.FIELD_DELETED_TERM_FLAG, 0); //0:未结束未删除 1:已结束 2:已删除 break; case LotOperationType.Release: case LotOperationType.BatchRelease: case LotOperationType.Rework: case LotOperationType.BatchRework: htParams.Add(POR_LOT_FIELDS.FIELD_HOLD_FLAG, 1); //0:未暂停的批次;1:暂停的批次。 htParams.Add(POR_LOT_FIELDS.FIELD_DELETED_TERM_FLAG, 0); //0:未结束未删除 1:已结束 2:已删除 break; case LotOperationType.Dispatch: htParams.Add(POR_LOT_FIELDS.FIELD_HOLD_FLAG, 0); //0:未暂停的批次;1:暂停的批次。 htParams.Add(POR_LOT_FIELDS.FIELD_LOT_TYPE, "N"); //N:生产批次 L:组件补片批次 htParams.Add(POR_LOT_FIELDS.FIELD_DELETED_TERM_FLAG, 0); //0:未结束未删除 1:已结束 2:已删除 htParams.Add(POR_ROUTE_OPERATION_VER_FIELDS.FIELD_ROUTE_OPERATION_NAME, this._model.OperationName); //工序名称 break; default: break; } DataTable dtParams = CommonUtils.ParseToDataTable(htParams); dtParams.TableName = TRANS_TABLES.TABLE_MAIN_DATA; dsParams.Tables.Add(dtParams); //进行查询 DataSet dsReturn = _entity.Query(dsParams, ref config); pgnQueryResult.Pages = config.Pages; pgnQueryResult.Records = config.Records; if (!string.IsNullOrEmpty(_entity.ErrorMsg)) { MessageService.ShowMessage(_entity.ErrorMsg); return; } else { gcResult.DataSource = dsReturn.Tables[0]; gcResult.MainView = gvResult; } }
/// <summary> /// 查询在线物料。 /// </summary> /// <param name="model">查询条件。</param> /// <param name="pconfig">分页对象。</param> /// <returns>包含在线物料信息的数据集对象。</returns> public DataSet Query(OnlineMaterialQueryModel model, ref PagingQueryConfig pconfig) { DataSet dsReturn = new DataSet(); StringBuilder sbSql = new StringBuilder(); try { sbSql.Append(@"SELECT A.STORE_MATERIAL_KEY , SUM(A.CURRENT_QTY)AS QTY, C.STORE_NAME AS STORE_NAME, D.MATERIAL_CODE AS MATERIAL_CODE, D.MATERIAL_NAME AS MATERIAL_NAME, D.UNIT AS UNIT, E.LOCATION_NAME AS ROOM_NAME, C.OPERATION_NAME AS OPERATION_NAME FROM WST_STORE_MATERIAL_DETAIL A LEFT JOIN WST_STORE_MATERIAL B ON A.STORE_MATERIAL_KEY=B.STORE_MATERIAL_KEY LEFT JOIN WST_STORE C ON B.STORE_KEY=C.STORE_KEY LEFT JOIN POR_MATERIAL D ON B.MATERIAL_KEY=D.MATERIAL_KEY LEFT JOIN FMM_LOCATION E ON C.LOCATION_KEY=E.LOCATION_KEY WHERE CURRENT_QTY>0 "); if (!string.IsNullOrEmpty(model.OperationName)) { sbSql.AppendFormat(UtilHelper.BuilderWhereConditionString("C.OPERATION_NAME", model.OperationName.Split(','))); } if (!string.IsNullOrEmpty(model.StoreName)) { sbSql.AppendFormat(UtilHelper.BuilderWhereConditionString("C.STORE_NAME", model.StoreName.Split(','))); } if (!string.IsNullOrEmpty(model.MaterialCode)) { sbSql.AppendFormat(" AND D.MATERIAL_CODE LIKE '{0}%'", model.MaterialCode.PreventSQLInjection()); } if (!string.IsNullOrEmpty(model.MaterialLot)) { sbSql.AppendFormat(" AND A.MATERIAL_LOT LIKE '{0}%'", model.MaterialLot.PreventSQLInjection()); } if (!string.IsNullOrEmpty(model.RoomName)) { sbSql.AppendFormat(" AND E.LOCATION_NAME LIKE '{0}%'", model.RoomName.PreventSQLInjection()); } if (!string.IsNullOrEmpty(model.SupplierName)) { sbSql.AppendFormat(" AND A.MATERIAL_SUPPLIER LIKE '{0}%'", model.SupplierName.PreventSQLInjection()); } sbSql.Append(@" GROUP BY A.STORE_MATERIAL_KEY,C.STORE_NAME,D.MATERIAL_CODE,E.LOCATION_NAME, D.MATERIAL_NAME,D.UNIT, E.LOCATION_NAME,C.OPERATION_NAME "); int pages = 0; int records = 0; AllCommonFunctions.CommonPagingData(sbSql.ToString(), pconfig.PageNo, pconfig.PageSize, out pages, out records, db, dsReturn, "WST_STORE_MATERIAL", "MATERIAL_CODE ASC"); pconfig.Pages = pages; pconfig.Records = records; ReturnMessageUtils.AddServerReturnMessage(dsReturn, string.Empty); } catch (Exception ex) { ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message); LogService.LogError("SearchLotList Error: " + ex.Message); } return(dsReturn); }
//查询按钮事件 private void tsbSearch_Click(object sender, EventArgs e) { string OutboundNo = this.txtOutboundNo.Text.Trim(); string VbelnNo = this.txtVbeln.Text.Trim(); bool QcResult = true; if ((OutboundNo.Length == 0) && (VbelnNo.Length == 0)) { MessageBox.Show("请输入出货单号或外向交货单号!"); gcList.DataSource = null; this.txtOutboundNo.Select(); return; } //根据外向交货单号或出库单号取抬头数据 DataSet dsOutboudInfo = this._entity.getOutboudInfo(OutboundNo, VbelnNo, "", ""); if (dsOutboudInfo.Tables[0].Rows.Count <= 0) { MessageBox.Show("没有您指定查询条件下的出货单抬头信息!"); return; } else if (dsOutboudInfo.Tables[0].Rows.Count > 1) { ShowBillNo SBillNo = new ShowBillNo(dsOutboudInfo.Tables[0]); SBillNo.pOutboundQCControl = this; SBillNo.ShowDialog(); } else { retIdx = 0; } if (retIdx >= 0) { DataRow dr = dsOutboudInfo.Tables[0].Rows[retIdx]; txtCreatedate.Text = (dr["ERDAT"].ToString()).Substring(0, 10); // txtCreator.Text = dr["CREATED_BY"].ToString(); // txtSalesto.Text = dr["SALESTO"].ToString(); // txtSalestoName.Text = dr["SHIPTO"].ToString(); // txtShipto.Text = dr["SALESTO_NAME"].ToString(); // txtShiptoName.Text = dr["SHIPTO_NAME"].ToString(); // txtVbeln.Text = dr["VBELN"].ToString(); // txtOutboundNo.Text = dr["OUTBANDNO"].ToString(); // txtStatus.Text = dr["status"].ToString(); // } PagingQueryConfig config = new PagingQueryConfig() { PageNo = pgnQueryResult.PageNo, PageSize = pgnQueryResult.PageSize }; //根据查询条件取外向交货单明细数据 DataSet dsParam = this.GetQueryCondition(); DataSet dsReturn = this._entity.Query(dsParam, ref config); pgnQueryResult.Pages = config.Pages; pgnQueryResult.Records = config.Records; if (!string.IsNullOrEmpty(this._entity.ErrorMsg)) { MessageService.ShowMessage(this._entity.ErrorMsg); return; } if (dsReturn.Tables.Count > 0) { //DataSet dsView=null; //if (this.txtStatus.Text.Trim() == "已确认") //{ // dsView = this.AddColumnDataSet(dsReturn); //} //else // dsView = dsReturn; gcList.DataSource = dsReturn.Tables[0]; gcList.MainView = gvList; gvList.BestFitColumns(); this.gvList.OptionsView.ColumnAutoWidth = false; this.SetComboBox(); if (this.txtStatus.Text.Trim() == "已检验") { gvList.OptionsBehavior.ReadOnly = true; DataTable dt = dsReturn.Tables[0]; foreach (DataRow dr in dt.Rows) { if (Convert.ToString(dr["QC_RESULT"]) == "不合格") { QcResult = false; } } this.tsbSave.Enabled = false; this.tsbEdit.Enabled = true; this.tsbDelete.Enabled = true; this.tsbComfirm.Enabled = false; if (QcResult == true) { this.tsbComfirm.Enabled = true; } } else if (this.txtStatus.Text.Trim() == "已确认") { gvList.OptionsBehavior.ReadOnly = false; this.tsbSave.Enabled = true; this.tsbComfirm.Enabled = false; this.tsbEdit.Enabled = false; this.tsbDelete.Enabled = false; } else if (this.txtStatus.Text.Trim() == "已过账") { gvList.OptionsBehavior.ReadOnly = true; this.tsbSave.Enabled = false; this.tsbComfirm.Enabled = false; this.tsbEdit.Enabled = false; this.tsbDelete.Enabled = true; } } else { MessageBox.Show("没有您指定查询条件下的出货单明细!"); return; } }
/// <summary> /// 查询按钮Click事件。 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnQuery_Click(object sender, EventArgs e) { string palletNo = this.tePalletNo.Text.Trim(); if (palletNo.Length > 2048) { MessageBox.Show("托盘号长度必须小于等于2048个字符。"); this.tePalletNo.Select(); return; } DataSet dsParams = this.GetQueryCondition(); PagingQueryConfig config = new PagingQueryConfig() { PageNo = pgnQueryResult.PageNo, PageSize = pgnQueryResult.PageSize }; DataSet dsReturn = this._entity.Query(dsParams, ref config); pgnQueryResult.Pages = config.Pages; pgnQueryResult.Records = config.Records; if (!string.IsNullOrEmpty(this._entity.ErrorMsg)) { MessageService.ShowMessage(this._entity.ErrorMsg); return; } if (dsReturn.Tables.Count > 0) { DataTable dt = dsReturn.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { string strtest = dt.Rows[i]["SHIPMENT_TYPE"].ToString().Equals("0").ToString(); if (dt.Rows[i]["CUSTCHECK"].ToString() == "0") { dt.Rows[i]["CUSTCHECK"] = "未客检"; } else if (dt.Rows[i]["CUSTCHECK"].ToString() == "1") { dt.Rows[i]["CUSTCHECK"] = "已客检"; } if (dt.Rows[i]["CONTAINER_NO"].ToString().Equals("")) { dt.Rows[i]["HFLAG"] = "1"; } //if (dt.Rows[i]["SHIPMENT_NO"].ToString().Equals("")) //{ // dt.Rows[i].Delete(); //} //if (dt.Rows[i]["SHIPMENT_TYPE"].ToString().Equals("0")) //{ // dt.Rows[i]["SHIPMENT_TYPE"] = "陆运"; //} //else if(dt.Rows[i]["SHIPMENT_TYPE"].ToString().Equals("1")) //{ // dt.Rows[i]["SHIPMENT_TYPE"] = "海运"; //} //else if(dt.Rows[i]["SHIPMENT_TYPE"].ToString().Equals("2")) //{ // dt.Rows[i]["SHIPMENT_TYPE"] = "空运"; //} switch (dt.Rows[i]["SHIPMENT_TYPE"].ToString()) { case "0": dt.Rows[i]["SHIPMENT_TYPE"] = "陆运"; break; case "1": dt.Rows[i]["SHIPMENT_TYPE"] = "海运"; break; case "2": dt.Rows[i]["SHIPMENT_TYPE"] = "空运"; break; default: dt.Rows[i]["SHIPMENT_TYPE"] = ""; break; } } gcList.DataSource = dt; gcList.MainView = gvList; gvList.BestFitColumns(); } }
/// <summary> /// 查询包含批次信息的数据集。 /// </summary> /// <param name="dsSearch"> /// 包含查询条件的数据集。 /// </param> /// <param name="pconfig"> /// 分页查询的配置对象。 /// </param> /// <param name="isPaging"> /// 是否分页查询。 /// </param> /// <returns>包含批次信息的数据集。</returns> private DataSet SearchLotList(DataSet dsSearch, ref PagingQueryConfig pconfig, bool isPaging) { DataSet dsReturn = new DataSet(); StringBuilder sBuilder = new StringBuilder(); try { sBuilder.Append(@"SELECT A.[LOT_KEY],A.[LOT_NUMBER],A.[WORK_ORDER_KEY],A.[WORK_ORDER_NO],A.[WORK_ORDER_SEQ] ,A.[PART_VER_KEY],A.[PART_NUMBER],A.[PRO_ID],A.[PRO_LEVEL],A.[PRIORITY],A.[QUANTITY_INITIAL] ,A.[LOT_LINE_CODE],A.[LOT_LINE_KEY] ,A.[QUANTITY],A.[ROUTE_ENTERPRISE_VER_KEY],A.[CUR_ROUTE_VER_KEY],A.[CUR_STEP_VER_KEY] ,A.[CUR_PRODUCTION_LINE_KEY],A.[LINE_NAME],A.[START_WAIT_TIME],A.[START_PROCESS_TIME] ,A.[EDC_INS_KEY],A.[STATE_FLAG],A.[IS_MAIN_LOT],A.[SPLIT_FLAG],A.[LOT_SEQ],A.[REWORK_FLAG] ,A.[HOLD_FLAG],A.[SHIPPED_FLAG],A.[DELETED_TERM_FLAG],A.[IS_PRINT],A.[LOT_TYPE],A.[CREATE_TYPE] ,A.[COLOR],A.[PALLET_NO],A.[PALLET_TIME],A.[STATUS],A.[OPERATOR],A.[OPR_LINE],A.[OPR_COMPUTER] ,A.[OPR_LINE_PRE],A.[CHILD_LINE],A.[MATERIAL_CODE],A.[MATERIAL_LOT],A.[SUPPLIER_NAME],A.[SI_LOT] ,A.[EFFICIENCY],A.[FACTORYROOM_KEY],A.[FACTORYROOM_NAME],A.[CREATE_OPERTION_NAME],A.[CREATOR] ,A.[CREATE_TIME],A.[CREATE_TIMEZONE_KEY],A.[EDITOR],A.[EDIT_TIME],A.[EDIT_TIMEZONE],A.[SHIFT_NAME] ,A.[DESCRIPTIONS],A.[LOT_SIDECODE],A.[LOT_CUSTOMERCODE],A.[ORG_WORK_ORDER_NO],w.PART_NUMBER AS ORG_PART_NUMBER, E.ENTERPRISE_NAME, D.ROUTE_NAME, B.ROUTE_STEP_NAME, (SELECT TOP 1 EQUIPMENT_KEY FROM EMS_LOT_EQUIPMENT WHERE LOT_KEY=A.LOT_KEY AND STEP_KEY=A.CUR_STEP_VER_KEY AND END_TIMESTAMP IS NULL) AS EQUIPMENT_KEY, (SELECT EQUIPMENT_NAME FROM EMS_EQUIPMENTS WHERE EQUIPMENT_KEY=(SELECT TOP 1 EQUIPMENT_KEY FROM EMS_LOT_EQUIPMENT WHERE LOT_KEY=A.LOT_KEY AND STEP_KEY=A.CUR_STEP_VER_KEY AND END_TIMESTAMP IS NULL)) AS EQUIPMENT_NAME FROM POR_LOT A LEFT JOIN POR_WORK_ORDER w ON w.ORDER_NUMBER=A.ORG_WORK_ORDER_NO LEFT JOIN POR_ROUTE_STEP B ON A.CUR_STEP_VER_KEY= B.ROUTE_STEP_KEY LEFT JOIN POR_ROUTE_ROUTE_VER D ON A.CUR_ROUTE_VER_KEY=D.ROUTE_ROUTE_VER_KEY LEFT JOIN POR_ROUTE_ENTERPRISE_VER E ON A.ROUTE_ENTERPRISE_VER_KEY =E.ROUTE_ENTERPRISE_VER_KEY WHERE A.STATUS < 2"); if (dsSearch != null && dsSearch.Tables.Contains(TRANS_TABLES.TABLE_MAIN_DATA)) { DataTable dtParams = dsSearch.Tables[TRANS_TABLES.TABLE_MAIN_DATA]; Hashtable htParams = CommonUtils.ConvertToHashtable(dtParams); if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_FACTORYROOM_KEY)) { string roomKey = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_FACTORYROOM_KEY]); sBuilder.AppendFormat(" AND A.FACTORYROOM_KEY ='{0}'", roomKey.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_LOT_NUMBER)) { string lotNumber = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_LOT_NUMBER]); sBuilder.AppendFormat(" AND A.LOT_NUMBER LIKE '%{0}%'", lotNumber.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_LOT_NUMBER + "_START")) { string lotNumber = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_LOT_NUMBER + "_START"]); sBuilder.AppendFormat(" AND A.LOT_NUMBER >='{0}'", lotNumber.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_LOT_NUMBER + "_END")) { string lotNumber = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_LOT_NUMBER + "_END"]); sBuilder.AppendFormat(" AND A.LOT_NUMBER <='{0}'", lotNumber.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_HOLD_FLAG)) { string holdFalg = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_HOLD_FLAG]); sBuilder.AppendFormat(" AND A.HOLD_FLAG={0}", holdFalg.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_LOT_TYPE)) { string lotType = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_LOT_TYPE]); sBuilder.AppendFormat(" AND A.LOT_TYPE='{0}'", lotType.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_STATE_FLAG)) { string stateFlag = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_STATE_FLAG]); sBuilder.AppendFormat(" AND A.STATE_FLAG={0}", stateFlag.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_CREATOR)) { string creator = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_CREATOR]); sBuilder.AppendFormat(" AND A.CREATOR='{0}'", creator.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_DELETED_TERM_FLAG)) { string deletedTermFlag = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_DELETED_TERM_FLAG]); sBuilder.AppendFormat(" AND A.DELETED_TERM_FLAG={0}", deletedTermFlag.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_SHIPPED_FLAG)) { string flag = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_SHIPPED_FLAG]); sBuilder.AppendFormat(" AND A.SHIPPED_FLAG={0}", flag.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_PRO_ID)) { string proId = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_PRO_ID]); sBuilder.AppendFormat(" AND A.PRO_ID LIKE '%{0}%'", proId.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_PART_NUMBER)) { string partNumber = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_PART_NUMBER]); sBuilder.AppendFormat(" AND A.PART_NUMBER LIKE '%{0}%'", partNumber.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_WORK_ORDER_NO)) { string orderNumber = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_WORK_ORDER_NO]); sBuilder.AppendFormat(" AND A.WORK_ORDER_NO LIKE '%{0}%'", orderNumber.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_ORG_WORK_ORDER_NO)) { string orderNumber = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_ORG_WORK_ORDER_NO]); sBuilder.AppendFormat(" AND A.ORG_WORK_ORDER_NO LIKE '%{0}%'", orderNumber.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_PALLET_NO)) { string palletNo = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_PALLET_NO]); sBuilder.AppendFormat(" AND A.PALLET_NO LIKE '%{0}%'", palletNo.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_LINE_NAME)) { string lineName = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_LINE_NAME]); sBuilder.AppendFormat(" AND A.LINE_NAME ='{0}'", lineName.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_SHIFT_NAME)) { string shiftName = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_SHIFT_NAME]); sBuilder.AppendFormat(" AND A.SHIFT_NAME='{0}'", shiftName.PreventSQLInjection()); } if (htParams.ContainsKey(POR_ROUTE_ENTERPRISE_VER_FIELDS.FIELD_ENTERPRISE_NAME)) { string enterpriseName = Convert.ToString(htParams[POR_ROUTE_ENTERPRISE_VER_FIELDS.FIELD_ENTERPRISE_NAME]); sBuilder.AppendFormat(" AND E.ENTERPRISE_NAME='{0}'", enterpriseName.PreventSQLInjection()); } if (htParams.ContainsKey(POR_ROUTE_ROUTE_VER_FIELDS.FIELD_ROUTE_NAME)) { string routeName = Convert.ToString(htParams[POR_ROUTE_ROUTE_VER_FIELDS.FIELD_ROUTE_NAME]); sBuilder.AppendFormat(" AND D.ROUTE_NAME='{0}'", routeName.PreventSQLInjection()); } if (htParams.ContainsKey(POR_ROUTE_OPERATION_VER_FIELDS.FIELD_ROUTE_OPERATION_NAME)) { string stepName = Convert.ToString(htParams[POR_ROUTE_OPERATION_VER_FIELDS.FIELD_ROUTE_OPERATION_NAME]); sBuilder.AppendFormat(" AND B.ROUTE_STEP_NAME='{0}'", stepName.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_CREATE_TIME + "_START")) { string createStartTime = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_CREATE_TIME + "_START"]); sBuilder.AppendFormat(" AND A.CREATE_TIME >='{0}'", createStartTime.PreventSQLInjection()); } if (htParams.ContainsKey(POR_LOT_FIELDS.FIELD_CREATE_TIME + "_END")) { string createEndTime = Convert.ToString(htParams[POR_LOT_FIELDS.FIELD_CREATE_TIME + "_END"]); sBuilder.AppendFormat(" AND A.CREATE_TIME<='{0}'", createEndTime.PreventSQLInjection()); } } if (!isPaging) { sBuilder.Append(" ORDER BY A.LOT_NUMBER ASC,A.CREATE_TIME DESC"); dsReturn = this._dbRead.ExecuteDataSet(CommandType.Text, sBuilder.ToString()); } else { int pages = 0; int records = 0; AllCommonFunctions.CommonPagingData(sBuilder.ToString(), pconfig.PageNo, pconfig.PageSize, out pages, out records, this._dbRead, dsReturn, POR_LOT_FIELDS.DATABASE_TABLE_NAME, "ASC", new string[] { "LOT_NUMBER", "CREATE_TIME" }); dsReturn.Tables[0].Columns[POR_LOT_FIELDS.FIELD_START_WAIT_TIME].DateTimeMode = DataSetDateTime.Unspecified; dsReturn.Tables[0].Columns[POR_LOT_FIELDS.FIELD_START_PROCESS_TIME].DateTimeMode = DataSetDateTime.Unspecified; dsReturn.Tables[0].Columns[POR_LOT_FIELDS.FIELD_EDIT_TIME].DateTimeMode = DataSetDateTime.Unspecified; pconfig.Pages = pages; pconfig.Records = records; } FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, string.Empty); } catch (Exception ex) { FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message); LogService.LogError("SearchLotList Error: " + ex.Message); } return(dsReturn); }
/// <summary> /// 获取设备信息。 /// </summary> /// <param name="equipmentCode">设备编码,左匹配模糊查询。</param> /// <param name="equipmentName">设备名称,左匹配模糊查询。</param> /// <param name="equipmentType">设备类型。如果为空,则查询所有类型的设备。</param> /// <param name="pconfig">数据分页查询的配置对象。</param> /// <returns>包含设备数据信息的数据集对象。</returns> public DataSet GetEquipments(string equipmentCode, string equipmentName, string equipmentType, ref PagingQueryConfig pconfig) { DataSet dsReturn = null; try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); dsReturn = serverFactory.CreateIEquipments().GetEquipments(equipmentCode, equipmentName, equipmentType, ref pconfig); this.ErrorMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn); } catch (Exception ex) { this.ErrorMsg = ex.Message; } finally { CallRemotingService.UnregisterChannel(); } return(dsReturn); }
/// <summary> /// 绑定批次信息。 /// </summary> private void BindLotInfo() { string factoryRoomKey = Convert.ToString(this.lueFactoryRoom.EditValue);; if (string.IsNullOrEmpty(factoryRoomKey)) { MessageService.ShowMessage("请选择车间。", "系统提示"); this.lueFactoryRoom.Select(); return; } //开始时间>结束时间 if (this.deStartCreateDate.DateTime > this.deEndCreateDate.DateTime) { MessageService.ShowMessage("开始时间必须小于结束时间。", "系统提示"); this.deStartCreateDate.Select(); return; } string DeletedFlag = Convert.ToString(this.lueDeletedFlag.EditValue); string HoldFlag = Convert.ToString(this.lueHoldFlag.EditValue); string LotNumber = this.teLotNumber.Text.ToUpper().Trim(); string LotType = Convert.ToString(this.lueLotType.EditValue); string OperationName = Convert.ToString(this.lueOperation.EditValue); string ProId = this.teProId.Text.ToUpper().Trim(); string ReworkFlag = Convert.ToString(this.lueReworkFlag.EditValue); string RoomKey = factoryRoomKey; string RoomName = Convert.ToString(this.lueFactoryRoom.Text); string ShippedFlag = Convert.ToString(this.lueShippedFlag.EditValue); string StateFlag = Convert.ToString(this.lueState.EditValue); string PalletNo = this.tePalletNo.Text.Trim(); string WorkOrderNumber = this.teWorkOrderNumber.Text.ToUpper().Trim(); string StartCreateDate = this.deStartCreateDate.DateTime.ToString("yyyy-MM-dd HH:mm:ss"); string EndCreateDate = this.deEndCreateDate.DateTime.ToString("yyyy-MM-dd HH:mm:ss"); string Creator = this.teCreator.Text.Trim(); string LotNumber1 = this.teLotNumberEnd.Text.Trim(); string PartNumber = this.tePartNumber.Text.Trim(); string OrgOrderNumber = this.teOrgOrderNumber.Text.Trim(); Hashtable htParams = new Hashtable(); DataSet dsParams = new DataSet(); DataSet dsReturn = new DataSet(); //车间主键。 htParams.Add(POR_LOT_FIELDS.FIELD_FACTORYROOM_KEY, RoomKey); //工序名称不为空 if (!string.IsNullOrEmpty(OperationName)) { htParams.Add(POR_ROUTE_OPERATION_VER_FIELDS.FIELD_ROUTE_OPERATION_NAME, OperationName); } //批次号不为空 if (!string.IsNullOrEmpty(LotNumber1) && !string.IsNullOrEmpty(LotNumber)) { htParams.Add(POR_LOT_FIELDS.FIELD_LOT_NUMBER + "_START", LotNumber); htParams.Add(POR_LOT_FIELDS.FIELD_LOT_NUMBER + "_END", LotNumber1); } //批次号不为空 else if (!string.IsNullOrEmpty(LotNumber)) { htParams.Add(POR_LOT_FIELDS.FIELD_LOT_NUMBER, LotNumber); } //工单号不为空 if (!string.IsNullOrEmpty(WorkOrderNumber)) { htParams.Add(POR_LOT_FIELDS.FIELD_WORK_ORDER_NO, WorkOrderNumber); } //工单号不为空 if (!string.IsNullOrEmpty(OrgOrderNumber)) { htParams.Add(POR_LOT_FIELDS.FIELD_ORG_WORK_ORDER_NO, OrgOrderNumber); } //产品ID号不为空 if (!string.IsNullOrEmpty(ProId)) { htParams.Add(POR_LOT_FIELDS.FIELD_PRO_ID, ProId); } //产品料不为空 if (!string.IsNullOrEmpty(PartNumber)) { htParams.Add(POR_LOT_FIELDS.FIELD_PART_NUMBER, PartNumber); } //托盘号不为空 if (!string.IsNullOrEmpty(PalletNo)) { htParams.Add(POR_LOT_FIELDS.FIELD_PALLET_NO, PalletNo); } //暂停标记不为空 if (!string.IsNullOrEmpty(HoldFlag)) { htParams.Add(POR_LOT_FIELDS.FIELD_HOLD_FLAG, HoldFlag); } //重工标记不为空 if (!string.IsNullOrEmpty(ReworkFlag)) { htParams.Add(POR_LOT_FIELDS.FIELD_IS_REWORKED, ReworkFlag); } //删除标记不为空 if (!string.IsNullOrEmpty(DeletedFlag)) { htParams.Add(POR_LOT_FIELDS.FIELD_DELETED_TERM_FLAG, DeletedFlag); } //出货标记不为空 if (!string.IsNullOrEmpty(ShippedFlag)) { htParams.Add(POR_LOT_FIELDS.FIELD_SHIPPED_FLAG, ShippedFlag); } //状态不为空 if (!string.IsNullOrEmpty(StateFlag)) { htParams.Add(POR_LOT_FIELDS.FIELD_STATE_FLAG, StateFlag); } //批次类型不为空 if (!string.IsNullOrEmpty(LotType)) { htParams.Add(POR_LOT_FIELDS.FIELD_LOT_TYPE, LotType); } //创建人 if (!string.IsNullOrEmpty(Creator)) { htParams.Add(POR_LOT_FIELDS.FIELD_CREATOR, Creator); } //创建日期-起不为空 if (!string.IsNullOrEmpty(StartCreateDate)) { htParams.Add(POR_LOT_FIELDS.FIELD_CREATE_TIME + "_START", StartCreateDate); } //创建日期-止不为空 if (!string.IsNullOrEmpty(EndCreateDate)) { htParams.Add(POR_LOT_FIELDS.FIELD_CREATE_TIME + "_END", EndCreateDate); } DataTable dtParams = CommonUtils.ParseToDataTable(htParams); dtParams.TableName = TRANS_TABLES.TABLE_MAIN_DATA; dsParams.Tables.Add(dtParams); //查询批次 LotQueryEntity entity = new LotQueryEntity(); PagingQueryConfig config = new PagingQueryConfig() { PageNo = pgnQueryResult.PageNo, PageSize = pgnQueryResult.PageSize }; dsReturn = entity.Query(dsParams, ref config); pgnQueryResult.Pages = config.Pages; pgnQueryResult.Records = config.Records; if (!string.IsNullOrEmpty(entity.ErrorMsg)) { MessageService.ShowMessage(entity.ErrorMsg); return; } if (dsReturn.Tables.Count > 0) { gcLot.DataSource = dsReturn.Tables[0]; gcLot.MainView = gvLot; gvLot.BestFitColumns(); } }
/// <summary> /// 绑定托盘信息。 /// </summary> private void BindPalletInfo() { PalletQueryConditionModel model = this.Model; Hashtable htParams = new Hashtable(); DataSet dsParams = new DataSet(); //车间主键。 htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_ROOM_KEY, model.RoomKey); //批次号不为空 if (!string.IsNullOrEmpty(model.PalletNo1) && !string.IsNullOrEmpty(model.PalletNo)) { htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_VIRTUAL_PALLET_NO + "_START", model.PalletNo); htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_VIRTUAL_PALLET_NO + "_END", model.PalletNo1); } //批次号不为空 else if (!string.IsNullOrEmpty(model.PalletNo)) { htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_VIRTUAL_PALLET_NO, model.PalletNo); } //工单号不为空 if (!string.IsNullOrEmpty(model.WorkOrderNumber)) { htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_WORKNUMBER, model.WorkOrderNumber); } //产品ID号不为空 if (!string.IsNullOrEmpty(model.ProId)) { htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_PRO_ID, model.ProId); } //产品料号不为空 if (!string.IsNullOrEmpty(model.PartNumber)) { htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_SAP_NO, model.PartNumber); } //状态不为空 if (!string.IsNullOrEmpty(model.StateFlag)) { htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_CS_DATA_GROUP, model.StateFlag); } //创建日期-起不为空 if (!string.IsNullOrEmpty(model.StartCreateDate)) { htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_CREATE_TIME + "_START", model.StartCreateDate); } //创建日期-止不为空 if (!string.IsNullOrEmpty(model.EndCreateDate)) { htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_CREATE_TIME + "_END", model.EndCreateDate); } //入库检日期-起不为空 if (!string.IsNullOrEmpty(model.StartCheckDate)) { htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_CHECK_TIME + "_START", model.StartCheckDate); } //入库检日期-止不为空 if (!string.IsNullOrEmpty(model.EndCheckDate)) { htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_CHECK_TIME + "_END", model.EndCheckDate); } //入库日期-起不为空 if (!string.IsNullOrEmpty(model.StartTowarehouseDate)) { htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_TO_WH_TIME + "_START", model.StartTowarehouseDate); } //入库日期-止不为空 if (!string.IsNullOrEmpty(model.EndTowarehouseDate)) { htParams.Add(WIP_CONSIGNMENT_FIELDS.FIELDS_TO_WH_TIME + "_END", model.EndTowarehouseDate); } DataTable dtParams = CommonUtils.ParseToDataTable(htParams); dtParams.TableName = TRANS_TABLES.TABLE_MAIN_DATA; dsParams.Tables.Add(dtParams); //查询批次 PagingQueryConfig config = new PagingQueryConfig() { PageNo = pgnQueryResult.PageNo, PageSize = pgnQueryResult.PageSize }; DataSet dsReturn = _entity.Query(dsParams, ref config); pgnQueryResult.Pages = config.Pages; pgnQueryResult.Records = config.Records; if (!string.IsNullOrEmpty(_entity.ErrorMsg)) { MessageService.ShowMessage(_entity.ErrorMsg); return; } if (dsReturn.Tables.Count > 0) { dsReturn.Tables[0].Columns.Add("ROW_NUM", typeof(Decimal)); for (int i = 0; i < dsReturn.Tables[0].Rows.Count; i++) { DataRow dr = dsReturn.Tables[0].Rows[i]; dr["ROW_NUM"] = i + 1; string grade = Convert.ToString(dr[WIP_CONSIGNMENT_FIELDS.FIELDS_GRADE]); dr[WIP_CONSIGNMENT_FIELDS.FIELDS_GRADE] = GetProductGradeDisplayText(grade); object val = dr[WIP_CONSIGNMENT_FIELDS.FIELDS_CS_DATA_GROUP]; PalletState state = (PalletState)Convert.ToInt32(val); dr[WIP_CONSIGNMENT_FIELDS.FIELDS_GRADE] = GetProductGradeDisplayText(grade); dr[WIP_CONSIGNMENT_FIELDS.FIELDS_CS_DATA_GROUP] = CommonUtils.GetEnumValueDescription(state); } gcPallet.DataSource = dsReturn.Tables[0]; gcPallet.MainView = gvPallet; gvPallet.BestFitColumns(); } }
public DataSet GetByFourParameters(string partId, string partType, string partModule, string partClass, ref PagingQueryConfig pconfig) { DataSet dsReturn = new DataSet(); StringBuilder sqlCommon = new StringBuilder(); try { sqlCommon.Append(@"SELECT PART_ID,PART_DESC,PART_TYPE,PART_MODULE,PART_CLASS, (SELECT COUNT(1) FROM POR_PART_BYPRODUCT b WHERE b.MAIN_PART_NUMBER=A.PART_ID AND b.IS_USED='Y') AS TOTOL FROM dbo.POR_PART A WHERE 1=1 AND A.PART_STATUS = 1"); if (!string.IsNullOrEmpty(partId)) { sqlCommon.AppendFormat(" AND PART_ID LIKE '{0}%'", partId); } if (!string.IsNullOrEmpty(partType)) { sqlCommon.AppendFormat(" AND PART_TYPE LIKE '{0}%'", partType); } if (!string.IsNullOrEmpty(partModule)) { sqlCommon.AppendFormat(" AND PART_MODULE LIKE '{0}%'", partModule); } if (!string.IsNullOrEmpty(partClass)) { sqlCommon.AppendFormat(" AND PART_CLASS LIKE '{0}%'", partClass); } int pages = 0; int records = 0; AllCommonFunctions.CommonPagingData(sqlCommon.ToString(), pconfig.PageNo, pconfig.PageSize, out pages, out records, db, dsReturn, "POR_PART", "PART_ID ASC"); pconfig.Pages = pages; pconfig.Records = records; ReturnMessageUtils.AddServerReturnMessage(dsReturn, string.Empty); } catch (Exception ex) { ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message); LogService.LogError("GetByFourParameters Error: " + ex.Message); } return(dsReturn); }
public DataSet GetByFourParameters(string partId, string partType, string partModule, string partClass, ref PagingQueryConfig pconfig) { DataSet dsReturn = new DataSet(); try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); if (null != serverFactory) { dsReturn = serverFactory.CreateIByProductPartEngine().GetByFourParameters(partId, partType, partModule, partClass, ref pconfig); _errorMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn); } } catch (Exception ex) { _errorMsg = ex.Message; } finally { CallRemotingService.UnregisterChannel(); } return(dsReturn); }
private DataSet Query(DataSet dsParams, ref PagingQueryConfig pConfig, bool ispaging) { DataSet dsReturn = new DataSet(); StringBuilder sBuilder = new StringBuilder(); try { ////出库校验 //if (status == "CKJY") //{ sBuilder.Append(@"select OUTBANDNO,VBELN,POSNR,CPBH,XHGG,OBDQTY,QC_RESULT,BATCHNO,STATUS,QC_PERSON, case PKG_MAT when 0 then '合格' when 1 then '不合格' else ''end as PKG_MAT, case BILL_BRND when 0 then '合格' when 1 then '不合格'else '' end as BILL_BRND , case CANTR when 0 then '合格' when 1 then '不合格' else '' end as CANTR , case F_OUTB_CUSTM when 0 then '合格' when 1 then '不合格'else '' end as F_OUTB_CUSTM , case EL when 0 then '合格' when 1 then '不合格'else '' end as EL , case DATA_FORMT when 0 then '合格' when 1 then '不合格'else '' end as DATA_FORMT, case LIST_ABSENCE when 0 then '合格' when 1 then '不合格'else '' end as LIST_ABSENCE , case LiST_ERR when 0 then '合格' when 1 then '不合格'else '' end as LiST_ERR , case CELL when 0 then '合格' when 1 then '不合格'else '' end as CELL , case MOD_ERR when 0 then '合格' when 1 then '不合格'else '' end as MOD_ERR , case QLVL_ERR when 0 then '合格' when 1 then '不合格'else '' end as QLVL_ERR, case FRAME when 0 then '合格' when 1 then '不合格'else '' end as FRAME , case BRND_PARM_ERR when 0 then '合格' when 1 then '不合格'else '' end as BRND_PARM_ERR , case CONT_LOCK_BRK when 0 then '合格' when 1 then '不合格'else '' end as CONT_LOCK_BRK , case CUSTM_CK when 0 then '合格' when 1 then '不合格'else '' end as CUSTM_CK from (select OUTBANDNO,a.VBELN,a.POSNR,CPBH,XHGG,OBDQTY,a.QC_RESULT,a.BATCHNO,a.STATUS,a.QC_PERSON, PKG_MAT,BILL_BRND ,CANTR ,F_OUTB_CUSTM ,EL ,DATA_FORMT, LIST_ABSENCE , LiST_ERR , CELL , MOD_ERR ,QLVL_ERR,FRAME ,BRND_PARM_ERR ,CONT_LOCK_BRK ,CUSTM_CK from AWMS_OUTB_ITEM a left join AWMS_OUTB_QC b on a.VBELN=b.VBELN and a.POSNR=b.POSNR where a.STATUS in('已确认') and b.STATUS is null union select distinct OUTBANDNO,a.VBELN,a.POSNR,CPBH,XHGG,OBDQTY,a.QC_RESULT,a.BATCHNO,a.STATUS,a.QC_PERSON, PKG_MAT=2,BILL_BRND=2 ,CANTR=2 ,F_OUTB_CUSTM= 2,EL=2 ,DATA_FORMT=2, LIST_ABSENCE=2 ,LiST_ERR=2 , CELL=2 ,MOD_ERR=2 , QLVL_ERR=2,FRAME=2 , BRND_PARM_ERR=2 ,CONT_LOCK_BRK=2 ,CUSTM_CK=2 from AWMS_OUTB_ITEM a left join AWMS_OUTB_QC b on a.VBELN=b.VBELN and a.POSNR=b.POSNR where a.STATUS in('已确认') and b.STATUS ='删除' union select OUTBANDNO,a.VBELN,a.POSNR,CPBH,XHGG,OBDQTY,a.QC_RESULT,a.BATCHNO,a.STATUS,a.QC_PERSON, PKG_MAT,BILL_BRND ,CANTR ,F_OUTB_CUSTM ,EL ,DATA_FORMT, LIST_ABSENCE , LiST_ERR , CELL , MOD_ERR ,QLVL_ERR,FRAME ,BRND_PARM_ERR ,CONT_LOCK_BRK ,CUSTM_CK from AWMS_OUTB_ITEM a left join AWMS_OUTB_QC b on a.VBELN=b.VBELN and a.POSNR=b.POSNR where a.STATUS in('已过账','已检验') and b.STATUS='正常') a where 1=1 "); //} // //出库管理 // else if (status == "CKGL") // { // sBuilder.Append(@"select a.OUTBANDNO,a.VBELN,a.POSNR,a.status,CPBH,XHGG,QCQTY,OBDQTY,QC_RESULT,BATCHNO, // c.PALLET_NO from AWMS_OUTB_ITEM a,AWMS_CONTAINER_DETAIL b ,[dbo].WIP_CONSIGNMENT c // where a.Cabinet_NO=b.CONTAINER_CODE and a.Cabinet_KEY=b.CONTAINER_KEY and a.CPBH=c.SAP_NO // and b.PALLET_NO=c.PALLET_NO and a.STATUS in('已确认','已过账','已检验') // "); // } if (dsParams != null && dsParams.Tables.Contains(TRANS_TABLES.TABLE_MAIN_DATA)) { DataTable dtParam = dsParams.Tables[TRANS_TABLES.TABLE_MAIN_DATA]; Hashtable hsParam = CommonUtils.ConvertToHashtable(dtParam); if (hsParam.ContainsKey(AWMS_OUTB_ITEM_FIELDS.Field_VBELN)) { string vbelnNo = Convert.ToString(hsParam[AWMS_OUTB_ITEM_FIELDS.Field_VBELN]); sBuilder.AppendFormat(" and a.VBELN like '{0}%'", vbelnNo.PreventSQLInjection()); } if (hsParam.ContainsKey(AWMS_OUTB_ITEM_FIELDS.Field_OUTBANDNO)) { string outboundNo = Convert.ToString(hsParam[AWMS_OUTB_ITEM_FIELDS.Field_OUTBANDNO]); sBuilder.AppendFormat(" and a.OUTBANDNO like '{0}%'", outboundNo.PreventSQLInjection()); } if (hsParam.ContainsKey(AWMS_CONTAINER_DETAIL_FIELDS.Field_PALLET_NO)) { string outboundNo = Convert.ToString(hsParam[AWMS_CONTAINER_DETAIL_FIELDS.Field_PALLET_NO]); sBuilder.AppendFormat(" and c.PALLET_NO like '{0}%'", outboundNo.PreventSQLInjection()); } } int pages = 0; int records = 0; AllCommonFunctions.CommonPagingData(sBuilder.ToString(), pConfig.PageNo, pConfig.PageSize, out pages, out records, db, dsReturn, POR_LOT_FIELDS.DATABASE_TABLE_NAME, ""); pConfig.Pages = pages; pConfig.Records = records; ReturnMessageUtils.AddServerReturnMessage(dsReturn, string.Empty); } catch (Exception ex) { ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message); LogService.LogError("OutboundOperationEngine Query Error:" + ex.Message); } finally { } return(dsReturn); }
//实现接口 public DataSet Query(DataSet dsParams, ref PagingQueryConfig config) { return(Query(dsParams, ref config, true)); }