public List<ProStatusMonitoring> SearchRecords(ProStatusMonitoring objInfo) { List<ProStatusMonitoring> proStatusMonitoring = new List<ProStatusMonitoring>(); using (MainDBDataContext db = new MainDBDataContext()) { string sqlString = string.Empty; sqlString += "select" + Environment.NewLine; sqlString += "ISNULL( mmt_cMachineID,0) as MachineID," + Environment.NewLine; sqlString += "case when swl_cProjStatus is not null then ISNULL( swl_cProjStatus,'空閒') else ISNULL( sst_cStatusName,'空閒') end as MacStatus," + Environment.NewLine; sqlString += "case when swl_cProjStatus is not null then ISNULL( datediff(minute,swl_dStatusChange,getdate()),0) else ISNULL( datediff (minute,sst_dBeginTime,sst_dEndTime),0) end as holdTime," + Environment.NewLine; sqlString += "ISNULL( swl_cSONO ,'') as SONO ," + Environment.NewLine; sqlString += "ISNULL( sim_cStaffName,'') as MachineCaption," + Environment.NewLine; sqlString += "ISNULL(ppj_iProjRunTime,0) as RunTime" + Environment.NewLine; sqlString += "from MachineMaster_mmt" + Environment.NewLine; sqlString += "left join ScheduleProjList_swl" + Environment.NewLine; sqlString += "on swl_cMachineNO=mmt_cMachineID and ISNULL( swl_cProjStatus,'') not in ('','SCHEDULE','FINISH','STOP')" + Environment.NewLine; sqlString += "left join dbo.SpareStatus_sst" + Environment.NewLine; sqlString += "on sst_cMachineNO=mmt_cMachineID" + Environment.NewLine; sqlString += "left join PrintProject_ppj" + Environment.NewLine; sqlString += "on swl_RecordID=ppj_SWLID and ppj_lActiveRecord=1" + Environment.NewLine; sqlString += "left join ShiftProjList_spl" + Environment.NewLine; sqlString += "on spl_PPJID=ppj_RecordID" + Environment.NewLine; sqlString += "left join ShiftInfo_sifo" + Environment.NewLine; sqlString += "on spl_SIFOID=sifo_RecordID" + Environment.NewLine; sqlString += "left join StaffInfoMaster_sim" + Environment.NewLine; sqlString += "on sim_iRecordID=sifo_DutyCaptainID" + Environment.NewLine; sqlString += "where 1=1" + Environment.NewLine; if (objInfo.MachineID != "" && objInfo.MachineID != Guid.Empty.ToString()) { sqlString += "and mmt_cMachineID='" + objInfo.MachineID + "'" + Environment.NewLine; } else { if (objInfo.MachineType != "") { sqlString += "and mmt_cMachineType='" + objInfo.MachineType + "'" + Environment.NewLine; } if (objInfo.MacStatus != "") { sqlString += "and swl_cProjStatus='" + objInfo.MacStatus + "'" + Environment.NewLine; } } IEnumerable<ProStatusMonitoring> infos = null; try { infos = db.ExecuteQuery<ProStatusMonitoring>(sqlString, new object[] { }); if (infos != null) { foreach (ProStatusMonitoring item in infos) { proStatusMonitoring.Add(item); } } } catch (Exception Ex) { throw Ex; } } return proStatusMonitoring; }
public List<ProStatusMonitoring> SearchRecords(ProStatusMonitoring objInfo) { return this._IProStatusMontoringDA.SearchRecords(objInfo); }
void GetMonitoringRecordsDetail() { ProStatusMonitoring objSearch = new ProStatusMonitoring(); //MachineMaster_mmt_Info machine = new MachineMaster_mmt_Info(); //if (machine != null && machine.mmt_cBrandName.ToString() != "全部") //{ // // objSearch.OperatorID = machine. //} //if (this.cbxProdStatus.SelectedValue != null && this.cbxProdStatus.SelectedValue.ToString() != "All") //{ // objSearch.MachineStatcName = this.cbxProdStatus.SelectedValue.ToString(); //} if (cobMacType.SelectedValue != null && cobMacType.SelectedValue.ToString() != "") { //machine.mmt_cMachineType = cbxMacType.SelectedValue.ToString(); objSearch.MachineType = cobMacType.SelectedValue.ToString(); } if (cobMachine.SelectedValue != null && cobMachine.SelectedValue.ToString() != "") { //machine.mmt_cMachineID = cbxProdType.SelectedValue.ToString(); objSearch.MachineID = cobMachine.SelectedValue.ToString(); } if (cbxProdStatus.SelectedValue != null && cbxProdStatus.SelectedValue.ToString() != "") { objSearch.MacStatus = cbxProdStatus.SelectedValue.ToString(); } this.m_AllStatusMonitoring = this._IProStatusMontoringBL.SearchRecords(objSearch); foreach (ProStatusMonitoring item in m_AllStatusMonitoring) { item.ProjectNO = "MO:"; item.SONO = "SO:" + item.SONO; item.MacStatus = "狀態:" + item.MacStatus; item.MachineCaption = "機長:" + item.MachineCaption; item.cRunTime = "運作:" + HandelDataFormatMin(item.RunTime); item.choldTime = "持續:" + HandelDataFormatMin(item.holdTime); } if (this.m_AllStatusMonitoring.Count != 0) { this.m_iRemainder = this.m_AllStatusMonitoring.Count % Convert.ToInt32(labLvMaxCount.Text); this.m_iAliquot = this.m_AllStatusMonitoring.Count / Convert.ToInt32(labLvMaxCount.Text); if (this.m_iRemainder > 0) { this.labSum.Text = (this.m_iAliquot + 1).ToString(); } else { this.labSum.Text = this.m_iAliquot.ToString(); } this.m_iNowPage = 1; this.btnFirst.Enabled = false; this.btnUp.Enabled = false; this.btnDown.Enabled = true; this.btnLast.Enabled = true; this.btnGo.Enabled = true; } else { this.m_iNowPage = 0; this.btnFirst.Enabled = false; this.btnUp.Enabled = false; this.btnDown.Enabled = false; this.btnLast.Enabled = false; this.btnGo.Enabled = false; } }