/// <summary> /// 批次查询Click事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnQuery_Click(object sender, EventArgs e) { try { //if (_queryConditionDlg == null) //{ // _queryConditionDlg = new PalletQueryConditionDialog(); //} //if (_queryConditionDlg.ShowDialog() == DialogResult.OK) //{ // BindPalletInfo(); //} Model = new PalletQueryConditionModel(); string palletNo = this.tePalletNo.Text.Trim(); string factoryRoomKey = Convert.ToString(this.lueFactoryRoom.EditValue);; if (string.IsNullOrEmpty(factoryRoomKey)) { MessageService.ShowMessage("请选择车间。", "系统提示"); this.lueFactoryRoom.Select(); return; } if (palletNo.Length > 2048) { MessageService.ShowMessage("托盘号长度不能超过2048个字符。", "系统提示"); this.tePalletNo.Select(); return; } //开始时间>结束时间 if (this.deStartCreateDate.DateTime > this.deEndCreateDate.DateTime) { MessageService.ShowMessage("开始时间必须小于结束时间。", "系统提示"); this.deStartCreateDate.Select(); return; } this.Model.RoomKey = factoryRoomKey; this.Model.RoomName = Convert.ToString(this.lueFactoryRoom.Text); this.Model.PalletNo = this.tePalletNo.Text.Trim(); this.Model.PalletNo1 = this.tePalletNoEnd.Text.Trim(); this.Model.WorkOrderNumber = this.teWorkOrderNumber.Text.ToUpper().Trim(); this.Model.ProId = this.teProId.Text.ToUpper().Trim(); this.Model.StateFlag = Convert.ToString(this.lueState.EditValue); this.Model.StartCreateDate = this.deStartCreateDate.Text; this.Model.EndCreateDate = this.deEndCreateDate.Text; this.Model.PartNumber = this.tePartNumber.Text.Trim(); this.Model.StartTowarehouseDate = this.deToWarehouseDateStart.Text; this.Model.EndTowarehouseDate = this.deToWarehoseDateEnd.Text; this.Model.StartCheckDate = this.deToWarehouseCheckDateStart.Text; this.Model.EndCheckDate = this.deToWarehouseCheckDateEnd.Text; BindPalletInfo(); } catch (Exception ex) { MessageService.ShowError(ex.Message); } }
private void InitializeLanguage() { this.gcolLotRowNum.Caption = StringParser.Parse("${res:Global.RowNumber}"); //"序号"; this.gcolLotNumber.Caption = StringParser.Parse("${res:Global.LotNumber}"); //"批次号"; this.btnQuery.Text = StringParser.Parse("${res:Global.Query}"); //"查询"; this.gcolWorkOrderNumber.Caption = StringParser.Parse("${res:Global.WorkNumber}"); //工单号 this.gcolRowNum.Caption = StringParser.Parse("${res:Global.RowNumber}"); //"序号"; this.gcolLotWorkorderNo.Caption = StringParser.Parse("${res:Global.WorkNumber}"); //工单号 this.gcolLotQty.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolLotQty}"); //"电池片数量"; this.gcolEFFICIENCY.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolEFFICIENCY}"); //"转换效率"; this.gcolLotProId.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolLotProId}"); //"产品ID号"; this.gcolLotPartNumber.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolLotPartNumber}"); //"产品料号"; this.gcolLotSideCode.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolLotSideCode}"); //"侧板编号"; this.gcolLotCustomerCode.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolLotCustomerCode}"); //"客户编码"; this.gcolLotLotColor.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolLotLotColor}"); //"组件花色"; this.gcolLotGradeName.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolLotGradeName}"); //"组件等级"; this.gcolTTime.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolTTime}"); //"测试时间"; this.gcolDeviceNum.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolDeviceNum}"); //"测试设备"; this.gcolMODName.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolMODName}"); //"档位名称"; this.gcolPalletNo.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolPalletNo}"); //"托盘号"; this.gcolSAPNO.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolSAPNO}"); //"产品料号"; this.gcolProId.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolProId}"); //"产品ID号"; this.gcolProLevel.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolProLevel}"); //"产品等级"; this.gcolQuantity.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolQuantity}"); //"组件数量"; this.gcolPowerLevel.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolPowerLevel}"); //"功率档位"; this.gcolTotlePower.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolTotlePower}"); //"总瓦数(总功率)"; this.gcolAvgPower.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolAvgPower}"); //"平均功率"; this.gcolLotColor.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolLotColor}"); //"花色"; this.gcolStateFlag.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolStateFlag}"); //"状态"; this.gcolPalletTime.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolPalletTime}"); //"包装时间"; this.gcolPalletPerson.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolPalletPerson}"); //"包装人员"; this.gcolCheckTime.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolCheckTime}"); //"入库检时间"; this.gcolChecker.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolChecker}"); //"入库检人员"; this.gcolToWHTime.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolToWHTime}"); //"入库时间"; this.gcolToWHPerson.Caption = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.gcolToWHPerson}"); //"入库人员"; //this.lciQueryResult.Text = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.lciQueryResult}");//"查询结果"; //this.lciPaging.Text = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.lciPaging}");//"分页"; this.btnExportExcel.Text = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.btnExportExcel}"); //"导出本页数据到EXCEL"; this.tsbExportDetail.Text = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.tsbExportDetail}"); //"导出本页明细数据到EXCEL"; this.lblMenu.Text = StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.PalletQueryCtrl.lblTitle}"); //"托盘信息查询"; this.lblMenu.Text = "质量管理>质量作业>托盘查询"; //"托盘信息查询"; this.Model = new PalletQueryConditionModel(); BindFactoryRoom(); BindStateFlag(); InitControlValue(); }
/// <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(); } }
/// <summary> /// 构造函数。 /// </summary> public PalletQueryConditionDialog() { InitializeComponent(); this.Model = new PalletQueryConditionModel(); }