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);
}
