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(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 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 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 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 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 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 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 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 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 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 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 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 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 bool InsertRecord(MixMaterialDetail_mmdl_Info infoObject)
{
bool isSuccess = false;
MixMaterialDetail_mmdl_Info info = new MixMaterialDetail_mmdl_Info();
info = infoObject;
using (MainDBDataContext db = new MainDBDataContext())
{
MixMaterialDetail_mmdl newTab = Common.General.CopyObjectValue<MixMaterialDetail_mmdl_Info, MixMaterialDetail_mmdl>(infoObject);
db.MixMaterialDetail_mmdl.InsertOnSubmit(newTab);
db.SubmitChanges();
isSuccess = true;
}
return isSuccess;
}
public bool InsertRecord(MaterialProfile_mlpf_Info infoObject)
{
bool isSuccess = false;
MaterialProfile_mlpf_Info info = new MaterialProfile_mlpf_Info();
info = infoObject;
using (MainDBDataContext db = new MainDBDataContext())
{
MaterialProfile_mlpf newTab = Common.General.CopyObjectValue<MaterialProfile_mlpf_Info, MaterialProfile_mlpf>(infoObject);
db.MaterialProfile_mlpf.InsertOnSubmit(newTab);
db.SubmitChanges();
isSuccess = true;
}
return isSuccess;
}
public bool DeleteRecord(IModelObject KeyObject)
{
bool isSuccess = false;
MixMaterialGroup_mmpg_Info info = new MixMaterialGroup_mmpg_Info();
info = KeyObject as MixMaterialGroup_mmpg_Info;
using (MainDBDataContext db = new MainDBDataContext())
{
MixMaterialGroup_mmpg delTab = db.MixMaterialGroup_mmpg.SingleOrDefault(t => t.mmpg_Id == info.mmpg_Id);
if (delTab != null)
{
db.MixMaterialGroup_mmpg.DeleteOnSubmit(delTab);
db.SubmitChanges();
isSuccess = true;
}
}
return isSuccess;
}
/// <summary>
/// 刪除記錄
/// </summary>
/// <param name="KeyObject"></param>
/// <returns></returns>
/// <remarks>Create By Leothlink TonyWu On 01/02/2013</remarks>
public bool DeleteRecord(Model.IModel.IModelObject KeyObject)
{
bool isSuccess = false;
PrepareProjectMaster_ppm_Info info = new PrepareProjectMaster_ppm_Info();
info = KeyObject as PrepareProjectMaster_ppm_Info;
using (MainDBDataContext db = new MainDBDataContext())
{
PrepareProjectMaster_ppm delTab = db.PrepareProjectMaster_ppm.SingleOrDefault(t => t.ppm_RecordID == info.ppm_RecordID);
if (delTab != null)
{
db.PrepareProjectMaster_ppm.DeleteOnSubmit(delTab);
db.SubmitChanges();
isSuccess = true;
}
}
return isSuccess;
}
public bool InsertRecord(AheadOfOffDuty_aod_Info infoObject)
{
bool isSuccess = false;
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
AheadOfOffDuty_aod newTab = Common.General.CopyObjectValue<AheadOfOffDuty_aod_Info, AheadOfOffDuty_aod>(infoObject);
db.AheadOfOffDuty_aod.InsertOnSubmit(newTab);
db.SubmitChanges();
isSuccess = true;
}
}
catch (Exception Ex)
{
throw Ex;
}
return isSuccess;
}
public bool DeleteRecord(Model.IModel.IModelObject KeyObject)
{
bool isSuccess = false;
ListColumnsMaster_lcm_Info info = new ListColumnsMaster_lcm_Info();
info = KeyObject as ListColumnsMaster_lcm_Info;
using (MainDBDataContext db = new MainDBDataContext())
{
ListColumnsMaster_lcm delTab = db.ListColumnsMaster_lcm.SingleOrDefault(t => t.lcm_iRecordID == info.lcm_iRecordID);
if (delTab != null)
{
db.ListColumnsMaster_lcm.DeleteOnSubmit(delTab);
db.SubmitChanges();
isSuccess = true;
}
}
return isSuccess;
}
public bool DeleteRecord(IModelObject KeyObject)
{
bool isSuccess = false;
MaterialProfile_mlpf_Info info = new MaterialProfile_mlpf_Info();
info = KeyObject as MaterialProfile_mlpf_Info;
using (MainDBDataContext db = new MainDBDataContext())
{
MaterialProfile_mlpf delTab = db.MaterialProfile_mlpf.SingleOrDefault(t => t.mlpf_MLPFID == info.mlpf_MLPFID);
if (delTab != null)
{
//db.MaterialProfile_mlpf.DeleteOnSubmit(delTab);
delTab.mlpf_lIsDeleted = true;
db.SubmitChanges();
isSuccess = true;
}
}
return isSuccess;
}
public bool InsertRecord(VacationMaster_vcm_Info infoObject)
{
bool isSuccess = false;
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
VacationMaster_vcm newTab = Common.General.CopyObjectValue<VacationMaster_vcm_Info, VacationMaster_vcm>(infoObject);
db.VacationMaster_vcm.InsertOnSubmit(newTab);
db.SubmitChanges();
isSuccess = true;
}
}
catch (Exception Ex)
{
throw Ex;
}
return isSuccess;
}
public bool DeleteRecord(Model.IModel.IModelObject KeyObject)
{
Sys_UserMaster_usm_Info info = null;
try
{
info = KeyObject as Sys_UserMaster_usm_Info;
using (MainDBDataContext db = new MainDBDataContext())
{
Sys_UserMaster_usm usm = db.Sys_UserMaster_usm.Single<Sys_UserMaster_usm>(i => i.usm_iRecordID == info.usm_iRecordID);
var usrs = db.Sys_UserRoles_usr.Where(d => d.usr_cUserLoginID == info.usm_cUserLoginID);
db.Sys_UserRoles_usr.DeleteAllOnSubmit(usrs);
db.Sys_UserMaster_usm.DeleteOnSubmit(usm);
db.SubmitChanges();
return true;
}
}
catch (Exception Ex)
{
throw Ex;
}
}
public bool DeleteRecord(Model.IModel.IModelObject KeyObject)
{
Sys_RoleMaster_rlm_Info info = null;
try
{
info = KeyObject as Sys_RoleMaster_rlm_Info;
using (MainDBDataContext db = new MainDBDataContext())
{
db.Log = Console.Out;
Sys_RoleMaster_rlm rlm = db.Sys_RoleMaster_rlm.Single<Sys_RoleMaster_rlm>(i => i.rlm_iRecordID == info.rlm_iRecordID);
db.Sys_UserRoles_usr.DeleteAllOnSubmit(db.Sys_UserRoles_usr.Where(d => d.usr_cRoleID == info.rlm_cRoleID));
db.Sys_RoleMaster_rlm.DeleteOnSubmit(rlm);
db.SubmitChanges();
return true;
}
}
catch (Exception Ex)
{
throw Ex;
}
}
/// <summary>
/// 刪除通告顯示表
/// </summary>
/// <param name="notID"></param>
/// <returns></returns>
public bool DeleteNoticeList(System.Guid notID)
{
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
var ret = from nol in db.NoticeList_nol where nol.nol_NOTID == notID select nol;
if (ret.Count() > 0)
{
db.NoticeList_nol.DeleteAllOnSubmit(ret);
db.SubmitChanges();
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return false;
}
public ReturnValueInfo DeleteRecord(int ID)
{
ReturnValueInfo returnValue = new ReturnValueInfo();
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
var query = db.MaintainRecord_mtr.SingleOrDefault(t => t.mtr_iPlanID == ID);
if (query != null)
{
returnValue.boolValue = false;
returnValue.isError = true;
returnValue.messageText = "該計劃已存在使用記錄，不能刪除，如有需要請設為無效。";
}
else
{
var plan = from mtp in db.MaintainPlan_mtp where mtp.mtp_iRecordID == ID select mtp;
if (plan.Count() > 0)
{
db.MaintainPlan_mtp.DeleteAllOnSubmit(plan);
db.SubmitChanges();
}
returnValue.boolValue = true;
returnValue.isError = false;
returnValue.ValueObject = plan;
returnValue.messageText = "刪除成功";
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return returnValue;
}
public bool DeleteRecord(Model.IModel.IModelObject KeyObject)
{
bool isSuccess = false;
CodeMaster_cmt_Info info = new CodeMaster_cmt_Info();
info = KeyObject as CodeMaster_cmt_Info;
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
CodeMaster_cmt delTab = db.CodeMaster_cmt.SingleOrDefault(t => t.cmt_iRecordID == info.cmt_iRecordID);
if (delTab != null)
{
db.CodeMaster_cmt.DeleteOnSubmit(delTab);
db.SubmitChanges();
isSuccess = true;
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return isSuccess;
}
public bool UpdateRecord(AheadOfOffDuty_aod_Info infoObject)
{
bool isSuccess = false;
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
AheadOfOffDuty_aod query = db.AheadOfOffDuty_aod.SingleOrDefault(t => t.aod_RecordID == infoObject.aod_RecordID);
if (query != null)
{
query.aod_cName = infoObject.aod_cName;
query.aod_dOffDutyTime = infoObject.aod_dOffDutyTime;
query.aod_iShiftTypeID = infoObject.aod_iShiftTypeID;
query.aod_lIsAtive = infoObject.aod_lIsAtive;
query.aod_cLast = infoObject.aod_cLast;
query.aod_dLastDate = infoObject.aod_dLastDate;
//Common.General.SetDataToLingQEntity<AheadOfOffDuty_aod>(query, infoObject);
db.SubmitChanges();
isSuccess = true;
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return isSuccess;
}
