public List<SysMonitoring> GetAllRecords() { try { using (MainDBDataContext db = new MainDBDataContext()) { return (from Sysm in db.SystemMonitoring_sym select new SysMonitoring { sym_MACAddress = Sysm.sym_MACAddress, sym_iSystemID = Sysm.sym_iSystemID, sym_cSystemType = Sysm.sym_cSystemType, sym_cSystemName = Sysm.sym_cSystemName, sym_cSystemIP = Sysm.sym_cSystemIP, sym_dStartTime = Sysm.sym_dStartTime, sym_iStatus = Sysm.sym_iStatus, sym_dUpdateTime = Sysm.sym_dUpdateTime, sym_cVersion = Sysm.sym_cVersion, sym_cProcessName = Sysm.sym_cProcessName, sym_lIsPLCConnection = Sysm.sym_lIsPLCConnection, sym_dMarkTime = Sysm.sym_dMarkTime, sym_dAddTime = Sysm.sym_dAddTime, sym_dLastTime = Sysm.sym_dLastTime, sym_cMachineID = Sysm.sym_cMachineID, sym_cSoftwareNo = Sysm.sym_cSoftwareNo }).ToList(); } } catch { throw; } }
public bool DeleteList(List<MachineStopReasonProfile_msrp_Info> DeleteList) { //throw new NotImplementedException(); bool isSuccess = false; try { using (MainDBDataContext db = new MainDBDataContext()) { // List<MachineStopReasonProfile_msrp> uItems = db.MachineStopReasonProfile_msrp.Where(w => w.msrp_iSRPFID == ReasonID).ToList(); if (DeleteList != null) { foreach (MachineStopReasonProfile_msrp_Info item in DeleteList) { //item.mpit_lIsDeleted = true; //item.mpit_dUpdateTime = DateTime.Now; MachineStopReasonProfile_msrp delitem = db.MachineStopReasonProfile_msrp.SingleOrDefault(w => w.msrp_iMSRPID == item.msrp_iMSRPID ); db.MachineStopReasonProfile_msrp.DeleteOnSubmit(delitem); } } db.SubmitChanges(); isSuccess = true; } } catch (Exception Ex) { throw Ex; } return isSuccess; }
public ReturnValueInfo Delete(SysMonitoring objInfo) { ReturnValueInfo returnInfo = new ReturnValueInfo(false); try { using (MainDBDataContext db = new MainDBDataContext()) { var delTab = db.SystemMonitoring_sym.Where(t => t.sym_MACAddress == objInfo.sym_MACAddress); if (delTab != null) { foreach (var item in delTab) { db.SystemMonitoring_sym.DeleteOnSubmit(item); } db.SubmitChanges(); returnInfo.boolValue = true; } } } catch (Exception Ex) { returnInfo.messageText = Ex.Message; } return returnInfo; }
public ReturnValueInfo DeleteRecord(Guid ntoID) { List<NoticeToMachine> listReturn = new List<NoticeToMachine>(); try { using (MainDBDataContext db = new MainDBDataContext()) { var ret_notm = from notm in db.NoticeMachine_notm where notm.notm_NOTID == ntoID select notm; if (ret_notm.Count() > 0) { db.NoticeMachine_notm.DeleteAllOnSubmit(ret_notm); db.SubmitChanges(); } DeleteNoticeList(ntoID); var ret_not = from not in db.NoticeManage_not where not.not_RecordID == ntoID select not; if (ret_not.Count() > 0) { db.NoticeManage_not.DeleteAllOnSubmit(ret_not); db.SubmitChanges(); } } } catch (Exception Ex) { throw Ex; } return null; }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { Sys_FunctionMaster_fum_Info info = null; try { info = KeyObject as Sys_FunctionMaster_fum_Info; using (MainDBDataContext db = new MainDBDataContext()) { Sys_FunctionMaster_fum fum = db.Sys_FunctionMaster_fum.Single<Sys_FunctionMaster_fum>(i => i.fum_iRecordID == info.fum_iRecordID); for (int i = 0; i < fum.Sys_FormPurview_frp.Count; i++) { Sys_FormPurview_frp sta = fum.Sys_FormPurview_frp[i]; db.Sys_FormPurview_frp.DeleteOnSubmit(sta); } db.Sys_FunctionMaster_fum.DeleteOnSubmit(fum); db.SubmitChanges(); return true; } } catch (Exception Ex) { throw Ex; } }
public bool DeleteListByMachie(string MachineID) { bool isSuccess = false; try { using (MainDBDataContext db = new MainDBDataContext()) { List<MachineStopReasonProfile_msrp> uItems = db.MachineStopReasonProfile_msrp.Where(w => w.msrp_cMachineID.ToUpper().Trim() == MachineID.ToUpper().Trim()).ToList(); if (uItems != null) { db.MachineStopReasonProfile_msrp.DeleteAllOnSubmit(uItems); } db.SubmitChanges(); isSuccess = true; } } catch (Exception Ex) { throw Ex; } return isSuccess; }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { bool isSuccess = false; AheadOfOffDuty_aod_Info info = new AheadOfOffDuty_aod_Info(); info = KeyObject as AheadOfOffDuty_aod_Info; try { using (MainDBDataContext db = new MainDBDataContext()) { //AheadOfOffDuty_aod delTab = db.AheadOfOffDuty_aod.SingleOrDefault(t => t.aod_iRecordID == info.aod_iRecordID && t.aod_lIsDeleted == false); AheadOfOffDuty_aod delTab = db.AheadOfOffDuty_aod.SingleOrDefault(t => t.aod_RecordID == info.aod_RecordID && t.aod_lIsAtive == true); if (delTab != null) { //delTab.aod_lIsDeleted = true; db.AheadOfOffDuty_aod.DeleteOnSubmit(delTab); delTab.aod_lIsAtive = false; db.SubmitChanges(); isSuccess = true; } } } catch (Exception Ex) { throw Ex; } return isSuccess; }
public ReturnValueInfo DeleteRecord(ProjectStopReason_pjsr_Info reasonInfo) { ReturnValueInfo returnInfo = new ReturnValueInfo(false); if (reasonInfo != null) { try { using (MainDBDataContext db = new MainDBDataContext()) { ProjectStopReason_pjsr deleteData = db.ProjectStopReason_pjsr.FirstOrDefault(t => t.pjsr_RecordID == reasonInfo.pjsr_RecordID); if (deleteData != null) { db.ProjectStopReason_pjsr.DeleteOnSubmit(deleteData); db.SubmitChanges(); returnInfo.boolValue = true; } } } catch (Exception Ex) { returnInfo.messageText = Ex.Message; } } return returnInfo; }
public bool DeleteListByMachie(string MachineID) { bool isSuccess = false; try { using (MainDBDataContext db = new MainDBDataContext()) { List<MachinePrepareItem_mpit> uItems = db.MachinePrepareItem_mpit.Where(w => w.mpit_cDCMPID.ToUpper().Trim() == MachineID.ToUpper().Trim()).ToList(); if (uItems != null) { foreach (MachinePrepareItem_mpit item in uItems) { //item.mpit_lIsDeleted = true; //item.mpit_dUpdateTime = DateTime.Now; db.MachinePrepareItem_mpit.DeleteOnSubmit(item); } } db.SubmitChanges(); isSuccess = true; } } catch (Exception Ex) { throw Ex; } return isSuccess; }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { bool isSuccess = false; VacationMaster_vcm_Info delInfo = KeyObject as VacationMaster_vcm_Info; try { using (MainDBDataContext db = new MainDBDataContext()) { VacationMaster_vcm delTab = db.VacationMaster_vcm.SingleOrDefault(t => t.vcm_RecordID == delInfo.vcm_RecordID ); if (delTab != null) { //delTab.vcm_lIsDeleted = true; db.VacationMaster_vcm.DeleteOnSubmit(delTab); //delTab.vcm_lIsAtive = false; db.SubmitChanges(); isSuccess = true; } } } catch(Exception Ex) { throw Ex; } return isSuccess; }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { bool isSuccess = false; Model.HBPMS.Master.StaffInfoMaster_sim_Info info = new Model.HBPMS.Master.StaffInfoMaster_sim_Info(); info = KeyObject as Model.HBPMS.Master.StaffInfoMaster_sim_Info; try { using (MainDBDataContext db = new MainDBDataContext()) { LinqToSQLModel.StaffInfoMaster_sim delTab = db.StaffInfoMaster_sim.SingleOrDefault(t => t.sim_iRecordID == info.sim_iRecordID); if (delTab != null) { db.StaffInfoMaster_sim.DeleteOnSubmit(delTab); db.SubmitChanges(); isSuccess = true; } } } catch (Exception Ex) { throw Ex; } return isSuccess; }
public List<ShiftTypeMaster_stm_Info> CboShiftType() { //Add by peizhiwu List<ShiftTypeMaster_stm_Info> list = new List<ShiftTypeMaster_stm_Info>(); string strSQL = string.Empty; strSQL = " SELECT stm_iRecordID,stm_cShiftName,stm_cBeginTime,stm_cEndTime,stm_lIsAtive,stm_cAdd,stm_dAddDate,stm_cLast,stm_dLastDate " + Environment.NewLine; strSQL += " FROM ShiftTypeMaster_stm WHERE stm_lIsAtive = 1 " + Environment.NewLine; IEnumerable<ShiftTypeMaster_stm_Info> infos = null; try { using (MainDBDataContext db = new MainDBDataContext()) { infos = db.ExecuteQuery<ShiftTypeMaster_stm_Info>(strSQL, new object[] { }); if (infos != null) { list = infos.ToList<ShiftTypeMaster_stm_Info>(); } } } catch (Exception Ex) { throw Ex; } return list; }
public Sys_RoleMaster_rlm_Info GetRecord_First() { try { using (MainDBDataContext db = new MainDBDataContext()) { IQueryable<Sys_RoleMaster_rlm> taQuery = (from ta in db.Sys_RoleMaster_rlm orderby ta.rlm_iRecordID ascending select ta).Take(1); Sys_RoleMaster_rlm_Info info = new Sys_RoleMaster_rlm_Info(); if (taQuery.Count() > 0) { foreach (var t in taQuery) { info = Common.General.CopyObjectValue<Sys_RoleMaster_rlm, Sys_RoleMaster_rlm_Info>(t); FindUserRole(info); } } return info; } } catch (Exception Ex) { throw Ex; } }
public bool DeleteRecord(IModelObject KeyObject) { bool isSuccess = false; MixMaterialDetail_mmdl_Info info = new MixMaterialDetail_mmdl_Info(); info = KeyObject as MixMaterialDetail_mmdl_Info; using (MainDBDataContext db = new MainDBDataContext()) { MixMaterialDetail_mmdl delTab = null; if (info.mmdl_Id != new Guid()) { delTab = db.MixMaterialDetail_mmdl.SingleOrDefault(t => t.mmdl_Id == info.mmdl_Id); if (delTab != null) { db.MixMaterialDetail_mmdl.DeleteOnSubmit(delTab); } } else { var del = db.MixMaterialDetail_mmdl.Where(t => (info.mmdl_cMaterialCode != null ? t.mmdl_cMaterialCode == info.mmdl_cMaterialCode : true) && (info.mmdl_cMaterialGroupNo != null ? t.mmdl_cMaterialGroupNo == info.mmdl_cMaterialGroupNo : true) ); db.MixMaterialDetail_mmdl.DeleteAllOnSubmit(del); } //if (info.mmdl_cMaterialGroupNo != null) //{ // var del = db.MixMaterialDetail_mmdl.Where(c => c.mmdl_cMaterialGroupNo == info.mmdl_cMaterialGroupNo); // db.MixMaterialDetail_mmdl.DeleteAllOnSubmit(del); //} db.SubmitChanges(); isSuccess = true; } return isSuccess; }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { bool isSuccess = false; DinnerScheduleMaster_dsm_Info info = new DinnerScheduleMaster_dsm_Info(); info = KeyObject as DinnerScheduleMaster_dsm_Info; try { using (MainDBDataContext db = new MainDBDataContext()) { DinnerScheduleMaster_dsm delTab = db.DinnerScheduleMaster_dsm.SingleOrDefault(t => t.dsm_RecordID == info.dsm_RecordID); if (delTab != null) { db.DinnerScheduleMaster_dsm.DeleteOnSubmit(delTab); db.SubmitChanges(); isSuccess = true; } } } catch (Exception ex) { mLoger.Error("run DinnerScheduleMasterDA.DeleteRecord", ex); throw ex; } return isSuccess; }
public bool AddInArea(AreaMaster_amr_Info objArea, List<MachineMaster_mmt_Info> machines) { bool isSuccess = false; if (objArea != null && machines != null) { try { using (MainDBDataContext db = new MainDBDataContext()) { foreach (MachineMaster_mmt_Info item in machines) { MachineMaster_mmt updateData = db.MachineMaster_mmt.FirstOrDefault(t => t.mmt_cMachineID == item.mmt_cMachineID); if (updateData != null) { updateData.mmt_cAreaID = objArea.amr_cRecordID; } } db.SubmitChanges(); isSuccess = true; } } catch (Exception Ex) { throw Ex; } } return isSuccess; }
public ShiftTargetYieldSchedule_sty_Info DisplayRecord(IModelObject KeyObject) { ShiftTargetYieldSchedule_sty_Info displayInfo = null; if (KeyObject != null) { displayInfo = KeyObject as ShiftTargetYieldSchedule_sty_Info; try { using (MainDBDataContext db = new MainDBDataContext()) { ShiftTargetYieldSchedule_sty displayData = db.ShiftTargetYieldSchedule_sty.FirstOrDefault(t => t.sty_iRecordID == displayInfo.sty_iRecordID); if (displayData != null) { displayInfo = Common.General.CopyObjectValue<ShiftTargetYieldSchedule_sty, ShiftTargetYieldSchedule_sty_Info>(displayData); } } } catch (Exception Ex) { throw Ex; } } return displayInfo; }
public bool DeleteRecord(IModelObject KeyObject) { bool isSuccess = false; if (KeyObject != null) { ShiftTargetYieldSchedule_sty_Info deleteInfo = KeyObject as ShiftTargetYieldSchedule_sty_Info; try { using (MainDBDataContext db = new MainDBDataContext()) { ShiftTargetYieldSchedule_sty deleteData = db.ShiftTargetYieldSchedule_sty.FirstOrDefault(t => t.sty_iRecordID == deleteInfo.sty_iRecordID); if (deleteData != null) { //deleteData.sty_lIsDeleted = true; deleteData.sty_lIsAtive = false; db.SubmitChanges(); isSuccess = true; } } } catch (Exception Ex) { throw Ex; } } return isSuccess; }
public StopReasonMaster_srm_Info GetLastUpdateRecord() { StopReasonMaster_srm_Info result = null; try { //using (NHibernateTransaction.DBContext db = new NHibernateTransaction.DBContext(NHibernateTransaction.NHConfigFactory.DBConfig.HBIMSN)) //{ // var data = db.CurrentSession.QueryOver<StopReasonMaster_srm_Info>().OrderBy(d => d.srm_dLastDate).Desc.Take(1).List(); // if (data != null && data.Count > 0) // { // result = data[0]; // } //} using (MainDBDataContext db = new MainDBDataContext()) { var mmts = from t in db.StopReasonMaster_srm select t; var mmt = mmts.OrderByDescending(d => d.srm_dLastDate).FirstOrDefault(); result = Common.General.CopyObjectValue<StopReasonMaster_srm, StopReasonMaster_srm_Info>(mmt); } } catch (Exception Ex) { //Logger.Error(Ex); //throw Ex; } return result; }
public MailConfig_mcf_Info DisplayRecord(IModelObject KeyObject) { MailConfig_mcf_Info displayInfo = null; if (KeyObject != null) { displayInfo = KeyObject as MailConfig_mcf_Info; try { using (MainDBDataContext db = new MainDBDataContext()) { MailConfig_mcf displayData = db.MailConfig_mcf.FirstOrDefault(t => t.mcf_iRecordID == displayInfo.mcf_iRecordID); if (displayData != null) { displayInfo = Common.General.CopyObjectValue<MailConfig_mcf, MailConfig_mcf_Info>(displayData); } } } catch (Exception Ex) { throw Ex; } } return displayInfo; }
public bool DeleteRecord(IModelObject KeyObject) { bool isSuccess = false; if (KeyObject != null) { MailConfig_mcf_Info deleteInfo = KeyObject as MailConfig_mcf_Info; try { using (MainDBDataContext db = new MainDBDataContext()) { MailConfig_mcf deleteData = db.MailConfig_mcf.FirstOrDefault(t => t.mcf_iRecordID == deleteInfo.mcf_iRecordID); db.MailConfig_mcf.DeleteOnSubmit(deleteData); db.SubmitChanges(); isSuccess = true; } } catch (Exception Ex) { throw Ex; } } return isSuccess; }
public bool DeleteListByPPID(Guid PPID) { //throw new NotImplementedException(); bool isSuccess = false; try { using (MainDBDataContext db = new MainDBDataContext()) { List<MachinePrepareItem_mpit> uItems = db.MachinePrepareItem_mpit.Where(w => w.mpit_PIPFID == PPID).ToList(); if (uItems != null) { foreach (MachinePrepareItem_mpit item in uItems) { //item.mpit_lIsDeleted = true; //item.mpit_dUpdateTime = DateTime.Now; db.MachinePrepareItem_mpit.DeleteOnSubmit(item); } } db.SubmitChanges(); isSuccess = true; } } catch (Exception Ex) { throw Ex; } return isSuccess; }
public Sys_RoleMaster_rlm_Info DisplayRecord(Model.IModel.IModelObject KeyObject) { Sys_RoleMaster_rlm_Info rlm = new Sys_RoleMaster_rlm_Info(); Sys_RoleMaster_rlm_Info info = new Sys_RoleMaster_rlm_Info(); rlm = KeyObject as Sys_RoleMaster_rlm_Info; try { using (MainDBDataContext db = new MainDBDataContext()) { IQueryable<Sys_RoleMaster_rlm> taQuery = (from ta in db.Sys_RoleMaster_rlm where ta.rlm_iRecordID == rlm.rlm_iRecordID //orderby dpms.dpm_iRecordID ascending select ta).Take(1); if (taQuery != null) { //foreach (var t in taQuery) foreach (Sys_RoleMaster_rlm t in taQuery) { info = Common.General.CopyObjectValue<Sys_RoleMaster_rlm, Sys_RoleMaster_rlm_Info>(t); FindUserRole(info); } } return info; } } catch (Exception Ex) { throw Ex; } }
public ListColumnsMaster_lcm_Info GetRecord_First() { ListColumnsMaster_lcm_Info info; using (MainDBDataContext db = new MainDBDataContext()) { ListColumnsMaster_lcm query = db.ListColumnsMaster_lcm.OrderBy(t => t.lcm_iRecordID).FirstOrDefault(); info = Common.General.CopyObjectValue<ListColumnsMaster_lcm, ListColumnsMaster_lcm_Info>(query); } return info; }
/// <summary> /// 取得日志 /// </summary> /// <param name="p_strIP">IP</param> /// <param name="p_strSystemName">系统名</param> /// <param name="p_strModel">模组</param> /// <param name="p_strType">类型</param> /// <param name="p_strOperator">操作人</param> /// <returns></returns> public List<LogDetail_lgd_Info> GetLogs(string p_strIP, string p_strSystemName, string p_strModel, string p_strType, string p_strOperator) { StringBuilder l_strSQL = new StringBuilder(); l_strSQL.AppendLine("Select Top 200 lgd_iID,"); l_strSQL.AppendLine("lgd_cIpAddr,"); l_strSQL.AppendLine("lgd_cSysName,"); l_strSQL.AppendLine("lgd_cClassMethodName,"); l_strSQL.AppendLine("lgd_cLogType,"); l_strSQL.AppendLine("lgd_cLogMessage,"); l_strSQL.AppendLine("lgd_cRemark,"); l_strSQL.AppendLine("lgd_cOperator,"); l_strSQL.AppendLine("lgd_dOperateDateTime"); l_strSQL.AppendLine("From LogDetail_lgd"); l_strSQL.AppendLine("Where 1=1"); if (p_strIP != "") { l_strSQL.AppendLine("And lgd_cIpAddr = '" + p_strIP + "'"); } if (p_strSystemName != "") { l_strSQL.AppendLine("And lgd_cSysName = '" + p_strSystemName + "'"); } if (p_strModel != "") { l_strSQL.AppendLine("And lgd_cClassMethodName = '" + p_strModel + "'"); } if (p_strType != "") { l_strSQL.AppendLine("And lgd_cLogType = '" + p_strType + "'"); } if (p_strOperator != "") { l_strSQL.AppendLine("And lgd_cOperator = '" + p_strOperator + "'"); } l_strSQL.AppendLine("Order By lgd_dOperateDateTime Desc"); using (MainDBDataContext db = new MainDBDataContext()) { return db.ExecuteQuery<LogDetail_lgd_Info>(l_strSQL.ToString(), new object[] { }).ToList(); } }
public ListColumnsMaster_lcm_Info DisplayRecord(Model.IModel.IModelObject KeyObject) { ListColumnsMaster_lcm_Info info = new ListColumnsMaster_lcm_Info(); using (MainDBDataContext db = new MainDBDataContext()) { ListColumnsMaster_lcm disTab = db.ListColumnsMaster_lcm.SingleOrDefault(t => t.lcm_iRecordID == ((KeyObject) as ListColumnsMaster_lcm_Info).lcm_iRecordID); if (disTab != null) { info = Common.General.CopyObjectValue<ListColumnsMaster_lcm, ListColumnsMaster_lcm_Info>(disTab); } } return info; }
public MaterialProfile_mlpf_Info DisplayRecord(IModelObject KeyObject) { MaterialProfile_mlpf_Info info = new MaterialProfile_mlpf_Info(); using (MainDBDataContext db = new MainDBDataContext()) { MaterialProfile_mlpf disTab = db.MaterialProfile_mlpf.SingleOrDefault(t => t.mlpf_MLPFID == ((KeyObject) as MaterialProfile_mlpf_Info).mlpf_MLPFID); if (disTab != null) { info = Common.General.CopyObjectValue<MaterialProfile_mlpf, MaterialProfile_mlpf_Info>(disTab); } } return info; }
public MixMaterialDetail_mmdl_Info DisplayRecord(IModelObject KeyObject) { MixMaterialDetail_mmdl_Info info = new MixMaterialDetail_mmdl_Info(); using (MainDBDataContext db = new MainDBDataContext()) { MixMaterialDetail_mmdl disTab = db.MixMaterialDetail_mmdl.SingleOrDefault(t => t.mmdl_Id == ((KeyObject) as MixMaterialDetail_mmdl_Info).mmdl_Id); if (disTab != null) { info = Common.General.CopyObjectValue<MixMaterialDetail_mmdl, MixMaterialDetail_mmdl_Info>(disTab); } } return info; }
public bool IsExistRecord(object KeyObject) { MaterialProfile_mlpf_Info info = KeyObject as MaterialProfile_mlpf_Info; using (MainDBDataContext db = new MainDBDataContext()) { MaterialProfile_mlpf query = db.MaterialProfile_mlpf.SingleOrDefault(t => t.mlpf_cMaterialCode == info.mlpf_cMaterialCode); if (query != null) { return true; } } return false; }
/// <summary> /// 合計用餐計劃的用餐記錄數 /// </summary> /// <param name="scheduleID">就餐計劃</param> /// <returns></returns> public int CountDinnerRecord(Guid scheduleID) { try { using (MainDBDataContext db = new MainDBDataContext()) { int total = db.DinnerRecord_dnr.Count(t => t.dnr_DSMID == scheduleID); return total; } } catch (Exception Ex) { throw Ex; } }