private ShiftProjectProductionDataInfo_Query_Search CreateCondition() { ShiftProjectProductionDataInfo_Query_Search condition = new ShiftProjectProductionDataInfo_Query_Search(); condition.SearchDate = this.m_frmProductCollectBase.DateTimePickerSearchDate.Value.Date; if (this.m_frmProductCollectBase.ComboBoxSearchShift.SelectedValue != null && this.m_frmProductCollectBase.ComboBoxSearchShift.SelectedValue.ToString() != "") { condition.ShiftTypeID = Convert.ToInt32(this.m_frmProductCollectBase.ComboBoxSearchShift.SelectedValue); } condition.MachineNO = this.m_objShiftProjectProductionDataQuery.CurrentMachineNo; return condition; }
/// <summary> /// 查詢歷史班次的班次內工程生產數據信息 /// </summary> /// <param name="searchCondition">查詢條件</param> /// <returns></returns> public override List<ShiftProjectProductionDataInfo_Query> SearchHistoryShiftProjectProductionDatas(ShiftProjectProductionDataInfo_Query_Search searchCondition) { try { //System.Threading.Thread.Sleep(1000*10); ProjectProductionDataQueryBLL bll = new ProjectProductionDataQueryBLL(); return bll.SearchHistoryShiftProjectProductionDatas(searchCondition, this.ShiftTypeInfos); } catch(Exception ex) { this.OnException(mc_strClassName, "SearchHistoryShiftProjectProductionDatas", ex.Message); throw; } }
/// <summary> /// 查詢歷史班次的班次內工程生產數據信息 /// </summary> /// <param name="searchCondition">查詢條件</param> /// <returns></returns> public abstract List<ShiftProjectProductionDataInfo_Query> SearchHistoryShiftProjectProductionDatas(ShiftProjectProductionDataInfo_Query_Search searchCondition);
/// <summary> /// 班次內工程數據查詢 /// </summary> /// <param name="searchCondition">查詢信息</param> /// <param name="ShiftTypeInfos">班次類型信息列表</param> public List<ShiftProjectProductionDataInfo_Query> SearchHistoryShiftProjectProductionDatas(ShiftProjectProductionDataInfo_Query_Search searchCondition, List<ShiftTypeInfo> ShiftTypeInfos) { List<ShiftProjectProductionDataInfo_Query> lst = new List<ShiftProjectProductionDataInfo_Query>(); string l_strSQL = string.Empty; string l_strWhere = string.Empty; l_strWhere += " And sifo.sifo_dProdDate = " + Common.General.HandleSqlFormatDateTime(searchCondition.SearchDate) + " " + Environment.NewLine; if (!string.IsNullOrEmpty(searchCondition.MachineNO)) { l_strWhere += " And sifo.sifo_cMachineNO = '" + Common.General.HandleSqlSingle(searchCondition.MachineNO) + "' " + Environment.NewLine; } l_strWhere += " And sifo.sifo_iSTMID = " + searchCondition.ShiftTypeID.ToString().Trim() + Environment.NewLine; l_strSQL = l_strSQL + " Select " + Environment.NewLine; l_strSQL = l_strSQL + " ProjectNO = swl.swl_cProjectNO," + Environment.NewLine; l_strSQL = l_strSQL + " SONO = swl.swl_cSONO," + Environment.NewLine; l_strSQL = l_strSQL + " ItemNO = swl.swl_cItemNO," + Environment.NewLine; l_strSQL = l_strSQL + " ProdName = swl.swl_cProdName," + Environment.NewLine; l_strSQL = l_strSQL + " ItemName = swl.swl_cItemName," + Environment.NewLine; l_strSQL = l_strSQL + " Edition = swl.swl_cEdition," + Environment.NewLine; l_strSQL = l_strSQL + " SheetProdQty = swl.swl_iSheetProdQty," + Environment.NewLine; l_strSQL = l_strSQL + " PlanProdQty = swl.swl_iPlanProdQty," + Environment.NewLine; l_strSQL = l_strSQL + " ActualProdNum = spl.spl_iQTY," + Environment.NewLine; l_strSQL = l_strSQL + " CountDefectiveQty = spl.spl_iDefectiveQty," + Environment.NewLine; l_strSQL = l_strSQL + " CountWastNum = spl.spl_iWastQTY," + Environment.NewLine; l_strSQL = l_strSQL + " QualifiedNum = spl.spl_iQTY - spl.spl_iWastQTY - spl.spl_iDefectiveQty," + Environment.NewLine; //Begin Add By DonaldHuang 03/11/2015 //紙袋 l_strSQL = l_strSQL + " PaperBagName = swl.swl_cPaperBagName," + Environment.NewLine; l_strSQL = l_strSQL + " PaperBagModel = swl.swl_cPaperBagModel," + Environment.NewLine; l_strSQL = l_strSQL + " PaperBagSizeW = swl.swl_fPaperBagSizeW," + Environment.NewLine; l_strSQL = l_strSQL + " PaperBagSizeH = swl.swl_fPaperBagSizeH," + Environment.NewLine; l_strSQL = l_strSQL + " PaperBagSizeG = swl.swl_fPaperBagSizeG," + Environment.NewLine; l_strSQL = l_strSQL + " PaperBagSizeUnit = swl.swl_cPaperBagSizeUnit," + Environment.NewLine; l_strSQL = l_strSQL + " PaperBagQuality = swl.swl_cPaperBagQuality," + Environment.NewLine; //End Add By DonaldHuang 03/11/2015 l_strSQL = l_strSQL + " BeginTime = spl.spl_dBeginTime," + Environment.NewLine; l_strSQL = l_strSQL + " EndTime = spl.spl_dEndTime," + Environment.NewLine; l_strSQL = l_strSQL + " ProjRunTime = spl.spl_iRunTime," + Environment.NewLine; l_strSQL = l_strSQL + " StopTime = spl.spl_iStopTime," + Environment.NewLine; l_strSQL = l_strSQL + " ActualPrepairTime = spl.spl_iPrepairTime," + Environment.NewLine; l_strSQL = l_strSQL + " ShiftTypeID = sifo.sifo_iSTMID," + Environment.NewLine; l_strSQL = l_strSQL + " MachineNO = swl.swl_cMachineNO" + Environment.NewLine; l_strSQL = l_strSQL + " From ShiftInfo_sifo sifo " + Environment.NewLine; l_strSQL = l_strSQL + " Inner join ShiftProjList_spl spl on spl.spl_SIFOID = sifo.sifo_RecordID" + Environment.NewLine; l_strSQL = l_strSQL + " Inner join PrintProject_ppj ppj on spl.spl_PPJID = ppj.ppj_RecordID" + Environment.NewLine; l_strSQL = l_strSQL + " Inner join ScheduleProjList_swl swl on ppj.ppj_SWLID = swl.swl_RecordID" + Environment.NewLine; if (l_strWhere != "") { l_strSQL = l_strSQL + " Where 1=1 " + l_strWhere + Environment.NewLine; } l_strSQL = l_strSQL + " order by spl.spl_dBeginTime" + Environment.NewLine; try { using (IDataReader dataReader = DbHelperSQL.ExecuteReader(l_strSQL)) { while (dataReader.Read()) { ShiftProjectProductionDataInfo_Query model = new ShiftProjectProductionDataInfo_Query(); object ojb; model.ProjectNO = dataReader["ProjectNO"].ToString(); model.SONO = dataReader["SONO"].ToString(); model.ItemNO = dataReader["ItemNO"].ToString(); model.ProdName = dataReader["ProdName"].ToString(); model.ItemName = dataReader["ItemName"].ToString(); model.Edition = dataReader["Edition"].ToString(); //Begin Add By DonaldHuang 03/11/2015 model.PaperBagName = dataReader["PaperBagName"].ToString(); model.PaperBagModel = dataReader["PaperBagModel"].ToString(); model.PaperBagSizeW = float.Parse(dataReader["PaperBagSizeW"].ToString()); model.PaperBagSizeH = float.Parse(dataReader["PaperBagSizeH"].ToString()); model.PaperBagSizeG = float.Parse(dataReader["PaperBagSizeG"].ToString()); model.PaperBagSizeUnit = dataReader["PaperBagSizeUnit"].ToString(); model.PaperBagQuality = dataReader["PaperBagQuality"].ToString(); //End Add By DonaldHuang 03/11/2015 ojb = dataReader["SheetProdQty"]; if (ojb != null && ojb != DBNull.Value) { model.SheetProdQty = (int)ojb; } ojb = dataReader["PlanProdQty"]; if (ojb != null && ojb != DBNull.Value) { model.PlanProdQty = (int)ojb; } ojb = dataReader["ActualProdNum"]; if (ojb != null && ojb != DBNull.Value) { model.ActualProdNum = (int)ojb; } ojb = dataReader["CountDefectiveQty"]; if (ojb != null && ojb != DBNull.Value) { model.CountDefectiveQty = (int)ojb; } ojb = dataReader["CountWastNum"]; if (ojb != null && ojb != DBNull.Value) { model.CountWastNum = (int)ojb; } ojb = dataReader["QualifiedNum"]; if (ojb != null && ojb != DBNull.Value) { model.QualifiedNum = (int)ojb; } ojb = dataReader["BeginTime"]; if (ojb != null && ojb != DBNull.Value) { model.BeginTime = (DateTime)ojb; } ojb = dataReader["EndTime"]; if (ojb != null && ojb != DBNull.Value) { model.EndTime = (DateTime)ojb; } ojb = dataReader["ProjRunTime"]; if (ojb != null && ojb != DBNull.Value) { model.ProjRunTime = (int)ojb; } ojb = dataReader["StopTime"]; if (ojb != null && ojb != DBNull.Value) { model.StopTime = (int)ojb; } ojb = dataReader["ActualPrepairTime"]; if (ojb != null && ojb != DBNull.Value) { model.ActualPrepairTime = (int)ojb; } ojb = dataReader["ShiftTypeID"]; if (ojb != null && ojb != DBNull.Value) { model.ShiftTypeID = (int)ojb; } model.MachineNO = dataReader["MachineNO"].ToString(); lst.Add(model); } } } catch (Exception ex) { throw ex; } int indexvalue = 1; foreach (ShiftProjectProductionDataInfo_Query oEarchRecord in lst) { oEarchRecord.Index = indexvalue; indexvalue++; } return lst; }
/// <summary> /// 班次內工程數據查詢 /// </summary> /// <param name="searchCondition">查詢信息</param> /// <param name="ShiftTypeInfos">班次類型信息列表</param> public List<ShiftProjectProductionDataInfo_Query> SearchHistoryShiftProjectProductionDatas(ShiftProjectProductionDataInfo_Query_Search searchCondition,List<ShiftTypeInfo> ShiftTypeInfos) { ProjectProductionDataQueryDAL dal = new ProjectProductionDataQueryDAL(); return dal.SearchHistoryShiftProjectProductionDatas(searchCondition, ShiftTypeInfos); }