private void SaveByReason() { bool retValue = true; List<MachineStopReasonProfile_msrp_Info> data = new List<MachineStopReasonProfile_msrp_Info>(); foreach (ListViewItem item in lvSelectedMachines2.Items) { MachineMaster_mmt_Info mmt = item.Tag as MachineMaster_mmt_Info; MachineStopReasonProfile_msrp_Info obj; obj = new MachineStopReasonProfile_msrp_Info(); obj.msrp_cMachineID = mmt.mmt_cMachineID; obj.msrp_iSRPFID = mSelectedReasonID; obj.msrp_lIsDeleted = false; obj.msrp_dUpdateTime = DateTime.Now; data.Add(obj); } retValue = _MachineStopReasonBL.SavePPByReasonID(mSelectedReasonID, data); if (retValue) { m_MachineStopReasonProfile = _MachineStopReasonBL.GetStopReasonByReasonID(mSelectedReasonID); MessageBox.Show("保存成功!"); tsbAdd.Enabled = false; } else { MessageBox.Show("保存失敗,請重新選擇!"); } ClearData(); }
/// <summary> /// 停機原因主檔 /// </summary> public List<MachineStopReasonProfile_msrp_Info> GetMachineStopReasonMapping(string machineID) { try { List<MachineStopReasonProfile_msrp_Info> list = new List<MachineStopReasonProfile_msrp_Info>(); StringBuilder strSql = new StringBuilder(); strSql.AppendLine("select"); strSql.AppendLine("msrp_iMSRPID,msrp_iSRPFID,msrp_cMachineID,msrp_lIsDeleted,msrp_dUpdateTime "); strSql.AppendLine("from MachineStopReasonProfile_msrp "); strSql.AppendLine("where msrp_cMachineID='"+machineID.Trim()+"' "); strSql.AppendLine("and msrp_lIsDeleted=0"); using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (sdr.Read()) { MachineStopReasonProfile_msrp_Info model = new MachineStopReasonProfile_msrp_Info(); if (sdr["msrp_iMSRPID"] != null && sdr["msrp_iMSRPID"].ToString() != "") { model.msrp_iMSRPID = int.Parse(sdr["msrp_iMSRPID"].ToString()); } if (sdr["msrp_iSRPFID"] != null && sdr["msrp_iSRPFID"].ToString() != "") { model.msrp_iSRPFID = int.Parse(sdr["msrp_iSRPFID"].ToString()); } if (sdr["msrp_cMachineID"] != null && sdr["msrp_cMachineID"].ToString() != "") { model.msrp_cMachineID = sdr["msrp_cMachineID"].ToString(); } if (sdr["msrp_lIsDeleted"] != null && sdr["msrp_lIsDeleted"].ToString() != "") { if ((sdr["msrp_lIsDeleted"].ToString() == "1") || (sdr["msrp_lIsDeleted"].ToString().ToLower() == "true")) { model.msrp_lIsDeleted = true; } else { model.msrp_lIsDeleted = false; } } if (sdr["msrp_dUpdateTime"] != null && sdr["msrp_dUpdateTime"].ToString() != "") { model.msrp_dUpdateTime = DateTime.Parse(sdr["msrp_dUpdateTime"].ToString()); } list.Add(model); } } return list; } catch (Exception ex) { throw ex; } }
public bool UpdateRecord(MachineStopReasonProfile_msrp_Info infoObject) { throw new NotImplementedException(); }
private IList<MachineStopReasonProfile_msrp_Info> CreateMachineStopReasonProfileFromStopReasonData(IList<StopReasonMaster_srm_Info> data) { MachineMaster_mmt_Info dcm = GetDCMProfile(); if (dcm == null) { MessageBox.Show(" 請選擇幾台!"); return null; } IList<MachineStopReasonProfile_msrp_Info> msrpData = new List<MachineStopReasonProfile_msrp_Info>(); foreach (StopReasonMaster_srm_Info item in data) { MachineStopReasonProfile_msrp_Info obj; obj = m_MachineStopReasonProfile.Find(f => f.msrp_iSRPFID == item.srm_iRecordID); if (obj == null) obj = m_MachineStopReasonProfileInsertData.Find(f => f.msrp_iSRPFID == item.srm_iRecordID); if (obj == null) { obj = new MachineStopReasonProfile_msrp_Info(); obj.msrp_iSRPFID = item.srm_iRecordID; obj.msrp_cMachineID = dcm.mmt_cMachineID; obj.msrp_lIsDeleted = false; //obj.OID = commManager.GetMaxID(typeof(MachineStopReasonProfile).Name); //obj.MSRPID = obj.OID; //obj.SRPFID = item.SRPFID; //obj.DCMPID = dcm.DCMPID; } obj.msrp_dUpdateTime = DateTime.Now; msrpData.Add(obj); } return msrpData; }
public bool InsertRecord(MachineStopReasonProfile_msrp_Info infoObject) { //throw new NotImplementedException(); bool isSuccess = false; try { using (MainDBDataContext db = new MainDBDataContext()) { MachineStopReasonProfile_msrp newTab = Common.General.CopyObjectValue<MachineStopReasonProfile_msrp_Info, MachineStopReasonProfile_msrp>(infoObject); db.MachineStopReasonProfile_msrp.InsertOnSubmit(newTab); db.SubmitChanges(); isSuccess = true; } } catch (Exception Ex) { throw Ex; } return isSuccess; }
private string GetMachineStopReasonMappingSQL(MachineStopReasonProfile_msrp_Info model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.msrp_iMSRPID != null) { strSql1.Append("msrp_iMSRPID,"); strSql2.Append("'" + model.msrp_iMSRPID + "',"); } if (model.msrp_iSRPFID != null) { strSql1.Append("msrp_iSRPFID,"); strSql2.Append("" + model.msrp_iSRPFID + ","); } if (model.msrp_cMachineID != null) { strSql1.Append("msrp_cMachineID,"); strSql2.Append("'" + model.msrp_cMachineID + "',"); } if (model.msrp_lIsDeleted != null) { strSql1.Append("msrp_lIsDeleted,"); strSql2.Append("" + (model.msrp_lIsDeleted ? 1 : 0) + ","); } if (model.msrp_dUpdateTime != null) { strSql1.Append("msrp_dUpdateTime,"); strSql2.Append("'" + model.msrp_dUpdateTime.ToString(this._sqlLiteDatetimeFormat) + "',"); } strSql.Append("insert into MachineStopReasonProfile_msrp("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); return strSql.ToString(); }
public bool SavePPByReasonID(int ReasonID, List<MachineStopReasonProfile_msrp_Info> MCList) { //throw new NotImplementedException(); //throw new NotImplementedException(); bool returnValue = true; if (MCList == null) return true; if (ReasonID == 0) return true; try { _MachineStopReasonDA.DeleteListByReasonID(ReasonID); //List<MachinePrepareItem_mpit_Info> hadSelet = _MachineReadyPlanDA.GetPrepareProjectsByMachine(Machine); foreach (MachineStopReasonProfile_msrp_Info item in MCList) { MachineStopReasonProfile_msrp_Info insertItem = new MachineStopReasonProfile_msrp_Info(); insertItem.msrp_iSRPFID = ReasonID ; insertItem.msrp_cMachineID = item.msrp_cMachineID ; insertItem.msrp_lIsDeleted = false; insertItem.msrp_dUpdateTime = DateTime.Now; //insertItem.mpit_MPITID = Guid.NewGuid(); returnValue = _MachineStopReasonDA.InsertRecord(insertItem); } } catch (Exception Ex) { throw Ex; } return returnValue; }
public bool SaveMachineStopReasonByMachie(string MachineID, List<MachineStopReasonProfile_msrp_Info> ReasonList) { //throw new NotImplementedException(); bool returnValue = true; if (ReasonList == null) return true; if (MachineID.Trim().Length == 0) return true; try { _MachineStopReasonDA.DeleteListByMachie(MachineID); //List<MachineStopReasonProfile_msrp_Info> hadSelet = _MachineStopReasonDA.GetPrepareProjectsByMachine(Machine); foreach (MachineStopReasonProfile_msrp_Info item in ReasonList) { MachineStopReasonProfile_msrp_Info insertItem = new MachineStopReasonProfile_msrp_Info(); insertItem.msrp_cMachineID = MachineID ; insertItem.msrp_iSRPFID = item.msrp_iSRPFID ; insertItem.msrp_lIsDeleted = false; insertItem.msrp_dUpdateTime = DateTime.Now; //insertItem.msrp_iMSRPID = -1; returnValue = _MachineStopReasonDA.InsertRecord(insertItem); } } catch (Exception Ex) { throw Ex; } return returnValue; }
public Model.General.ReturnValueInfo Save(Model.IModel.IModelObject itemEntity, Common.DefineConstantValue.EditStateEnum EditMode) { Model.General.ReturnValueInfo returnValue = new Model.General.ReturnValueInfo(); MachineStopReasonProfile_msrp_Info info = new MachineStopReasonProfile_msrp_Info(); returnValue.messageText = ""; info = itemEntity as MachineStopReasonProfile_msrp_Info; try { switch (EditMode) { case Common.DefineConstantValue.EditStateEnum.OE_Insert: bool isExist = false; //info.mpit_MPITID = Guid.NewGuid(); returnValue.boolValue = _MachineStopReasonDA.InsertRecord(info); //isExist = _MachineStopReasonDA.IsExistRecord(info); //if (!isExist) //{ // returnValue.boolValue = _MachineStopReasonDA.InsertRecord(info); //} //else //{ // returnValue.boolValue = false; // returnValue.messageText = "數據重複!"; //} break; case Common.DefineConstantValue.EditStateEnum.OE_Update: returnValue.boolValue = _MachineStopReasonDA.UpdateRecord(info); break; case Common.DefineConstantValue.EditStateEnum.OE_Delete: returnValue.boolValue = _MachineStopReasonDA.DeleteRecord(info); break; } } catch (Exception Ex) { throw Ex; } return returnValue; }