public bool SaveSignalType(CommContracts.SignalType SignalType) { using (DAL.HisContext ctx = new DAL.HisContext()) { var config = new MapperConfiguration(cfg => { cfg.CreateMap <CommContracts.SignalType, DAL.SignalType>(); }); var mapper = config.CreateMapper(); DAL.SignalType temp = new DAL.SignalType(); temp = mapper.Map <DAL.SignalType>(SignalType); ctx.SignalTypes.Add(temp); try { ctx.SaveChanges(); } #pragma warning disable CS0168 // 声明了变量“ex”,但从未使用过 catch (Exception ex) #pragma warning restore CS0168 // 声明了变量“ex”,但从未使用过 { return(false); } } return(true); }
public bool UpdateSignalType(CommContracts.SignalType SignalType) { using (DAL.HisContext ctx = new DAL.HisContext()) { var temp = ctx.SignalTypes.FirstOrDefault(m => m.ID == SignalType.ID); if (temp != null) { temp.WorkTypeID = SignalType.WorkTypeID; temp.Name = SignalType.Name; temp.JobID = SignalType.JobID; temp.WorkTypeID = SignalType.WorkTypeID; temp.DoctorClinicFee = SignalType.DoctorClinicFee; } else { return(false); } try { ctx.SaveChanges(); } #pragma warning disable CS0168 // 声明了变量“ex”,但从未使用过 catch (Exception ex) #pragma warning restore CS0168 // 声明了变量“ex”,但从未使用过 { return(false); } } return(true); }
public List <CommContracts.WorkPlanToSignalSource> GetAllWorkPlan111(int DepartmentID, DateTime startDate, DateTime endDate) { List <CommContracts.WorkPlanToSignalSource> list = new List <CommContracts.WorkPlanToSignalSource>(); using (DAL.HisContext ctx = new DAL.HisContext()) { //var query = from a in ctx.WorkPlans // from b in ctx.SignalTypes // where // (DepartmentID <= 0 || a.DepartmentID == DepartmentID) && // a.WorkTypeID == b.WorkTypeID && // a.WorkPlanDate.Value <= endDate && // a.WorkPlanDate.Value >= startDate && // (a.WorkPlanStatus == DAL.WorkPlanStatus.eIsOk || a.WorkPlanStatus == DAL.WorkPlanStatus.eIsTempStop) // select a; var query = from w in ctx.WorkPlans from s in ctx.SignalTypes from j in ctx.EmployeeJobHistorys where w.DepartmentID == DepartmentID && w.WorkPlanDate.Value <= endDate && w.WorkPlanDate.Value >= startDate && w.WorkPlanStatus == DAL.WorkPlanStatus.eIsOk && s.WorkTypeID == w.WorkTypeID && w.Employee.ID == j.EmployeeID && !j.EndDate.HasValue && j.JobID == s.JobID select new { w, s }; int n = query.Count(); foreach (var temp in query) { var config = new MapperConfiguration(cfg => { cfg.CreateMap <DAL.WorkPlan, CommContracts.WorkPlan>(); }); var mapper = config.CreateMapper(); CommContracts.WorkPlan w = mapper.Map <CommContracts.WorkPlan>(temp.w); var config1 = new MapperConfiguration(cfg => { cfg.CreateMap <DAL.SignalType, CommContracts.SignalType>(); }); var mapper1 = config1.CreateMapper(); CommContracts.SignalType s = mapper1.Map <CommContracts.SignalType>(temp.s); CommContracts.WorkPlanToSignalSource ws = new CommContracts.WorkPlanToSignalSource(); ws.WorkPlan = w; ws.SignalType = s; list.Add(ws); } } return(list); }
private void NewBtn_Click(object sender, RoutedEventArgs e) { CommContracts.SignalType item = new CommContracts.SignalType(); this.SignalItemNameBox.Text = ""; this.SignalItemDoctorJobComBo.SelectedItem = null; this.SignalItemWorkTypeComBo.SelectedItem = null; this.SignalItemPrice.Text = ""; EditGrid.IsEnabled = true; this.SignalItemNameBox.Focus(); this.AllSignalItemList.SelectedItem = null; bIsEdit = false; }
private void SaveBtn_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(this.SignalItemNameBox.Text.Trim())) { return; } if (this.SignalItemDoctorJobComBo.SelectedItem == null) { return; } CommClient.SignalType myd = new CommClient.SignalType(); if (bIsEdit) { m_SignalType.Name = this.SignalItemNameBox.Text.Trim(); m_SignalType.JobID = (this.SignalItemDoctorJobComBo.SelectionBoxItem as CommContracts.Job).ID; m_SignalType.WorkTypeID = (this.SignalItemWorkTypeComBo.SelectedItem as CommContracts.WorkType).ID; m_SignalType.DoctorClinicFee = decimal.Parse(this.SignalItemPrice.Text.Trim()); if (myd.UpdateSignalType(m_SignalType)) { MessageBox.Show("OK"); UpdateAllDate(); } else { MessageBox.Show("Error"); } } else { CommContracts.SignalType signalType = new CommContracts.SignalType(); signalType.Name = this.SignalItemNameBox.Text.Trim(); signalType.JobID = (this.SignalItemDoctorJobComBo.SelectedItem as CommContracts.Job).ID; signalType.WorkTypeID = (this.SignalItemWorkTypeComBo.SelectedItem as CommContracts.WorkType).ID; signalType.DoctorClinicFee = decimal.Parse(this.SignalItemPrice.Text.Trim()); if (myd.SaveSignalType(signalType)) { MessageBox.Show("OK"); UpdateAllDate(); } else { MessageBox.Show("Error"); } } }
private void AllSignalItemList_SelectionChanged(object sender, SelectionChangedEventArgs e) { var item = this.AllSignalItemList.SelectedItem as CommContracts.SignalType; if (item == null) { return; } var vm = this.DataContext as HISGUISetVM; m_SignalType = item; this.SignalItemNameBox.Text = m_SignalType.Name; this.SignalItemDoctorJobComBo.SelectedItem = m_SignalType.Job; this.SignalItemWorkTypeComBo.SelectedItem = m_SignalType.WorkType; this.SignalItemPrice.Text = m_SignalType.DoctorClinicFee.ToString(); EditGrid.IsEnabled = false; bIsEdit = true; }
public List <CommContracts.SignalType> GetAllSignalType(string strName = "") { List <CommContracts.SignalType> list = new List <CommContracts.SignalType>(); using (DAL.HisContext ctx = new DAL.HisContext()) { var query = from a in ctx.SignalTypes where a.WorkType.Name.StartsWith(strName) select a; foreach (DAL.SignalType ass in query) { var config = new MapperConfiguration(cfg => { cfg.CreateMap <DAL.SignalType, CommContracts.SignalType>(); }); var mapper = config.CreateMapper(); CommContracts.SignalType temp = mapper.Map <CommContracts.SignalType>(ass); list.Add(temp); } } return(list); }