public void CreateDoctorPriceDetial(DoctorPriceDetial doctorPriceDetial)
{
if (FindDoctorPriceById(doctorPriceDetial.Id) == null)
{
_doctorPriceDetialRepository.Create(doctorPriceDetial);
_doctorPriceDetialRepository.Commit();
}
}
private void dgvRadiationDoctorPriceDetial_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
try
{
DataGridView dataGridView = sender as DataGridView;
if (dataGridView == null)
{
return;
}
int rowIndex = e.RowIndex;
DataGridViewRow dataGridViewRow = dataGridView.Rows[rowIndex];
DoctorPriceDetial doctorPriceDetial = new DoctorPriceDetial();
Guid guid;
bool isSuccess = Guid.TryParse(dataGridViewRow.Cells[0].Value.ToString(), out guid);
doctorPriceDetial.Id = guid;
doctorPriceDetial.No = int.Parse(dataGridViewRow.Cells[1].Value.ToString());
doctorPriceDetial.DoctorName = dataGridViewRow.Cells[2].Value.ToString();
doctorPriceDetial.CTDiagnosisPrice = dataGridViewRow.Cells[3].Value.ToString();
doctorPriceDetial.MRDiagnosisPrice = dataGridViewRow.Cells[4].Value.ToString();
doctorPriceDetial.DRDiagnosisPrice = dataGridViewRow.Cells[5].Value.ToString();
doctorPriceDetial.CTAuditPrice = dataGridViewRow.Cells[6].Value.ToString();
doctorPriceDetial.MRAuditPrice = dataGridViewRow.Cells[7].Value.ToString();
doctorPriceDetial.Note = dataGridViewRow.Cells[8].Value.ToString();
if (_importFileService.FindDoctorPriceById(doctorPriceDetial.Id) != null)
{
_importFileService.UpdteDoctorPriceDetial(doctorPriceDetial);
}
if (_importFileService.FindDoctorPriceById(doctorPriceDetial.Id) == null)
{
_importFileService.CreateDoctorPriceDetial(doctorPriceDetial);
}
var findResult = _importFileService.FindDoctorPriceById(doctorPriceDetial.Id);
if (findResult != null)
{
if (dataGridViewRow.Cells[0].Value == null)
{
dataGridViewRow.Cells[0].Value = findResult.Id;
}
if (dataGridViewRow.Cells[0].Value.ToString() != findResult.Id.ToString())
{
dataGridViewRow.Cells[0].Value = findResult.Id;
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Logger.Info($"触发函数dgvRadiationDoctorPriceDetial_CellValueChanged失败！" + ex.Message);
}
}
public void InsertDoctorPriceDataIntoDatabase(List <DoctorPriceDetial> list)
{
for (int i = 0; i < list.Count; i++)
{
DoctorPriceDetial doctorPriceDetial = list[i];
_doctorPriceDetialRepository.Create(doctorPriceDetial);
if (i % 100 == 0)
{
_doctorPriceDetialRepository.Commit();
}
}
_doctorPriceDetialRepository.Commit();
}
public void UpdteDoctorPriceDetial(DoctorPriceDetial doctorPriceDetial)
{
var result = FindDoctorPriceById(doctorPriceDetial.Id);
if (result != null)
{
result.No = doctorPriceDetial.No;
result.CTDiagnosisPrice = doctorPriceDetial.CTDiagnosisPrice;
result.CTAuditPrice = doctorPriceDetial.CTAuditPrice;
result.MRDiagnosisPrice = doctorPriceDetial.MRDiagnosisPrice;
result.MRAuditPrice = doctorPriceDetial.MRAuditPrice;
result.DRDiagnosisPrice = doctorPriceDetial.DRDiagnosisPrice;
result.DoctorName = doctorPriceDetial.DoctorName;
result.Note = doctorPriceDetial.Note;
_doctorPriceDetialRepository.Update(result);
_doctorPriceDetialRepository.Commit();
}
}
public List <DoctorPriceDetial> GetDoctorPriceDetialList(DataTable table)
{
var doctorPriceDetialList = new List <DoctorPriceDetial>();
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
try
{
if (string.IsNullOrEmpty(ConvertDataRow(row["序号"])))
{
/// table.Rows.Remove(row);
}
DoctorPriceDetial doctorPriceDetial = new DoctorPriceDetial
{
No = int.Parse(ConvertDataRow(row["序号"])),
DoctorName = ConvertDataRow(row["医生"]),
CTDiagnosisPrice = ConvertDataRow(row["CT诊断（元/张）"]),
CTAuditPrice = ConvertDataRow(row["CT核片（元/张）"]),
MRDiagnosisPrice = ConvertDataRow(row["MRI诊断（元/张）"]),
MRAuditPrice = ConvertDataRow(row["MRI核片（元/张）"]),
DRDiagnosisPrice = ConvertDataRow(row["DR诊断（元/张）"]),
//DRAuditPrice = ConvertDataRow(row["DR核片（元/张）"]),
Note = ConvertDataRow(row["备注"])
};
doctorPriceDetialList.Add(doctorPriceDetial);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
break;
}
}
return(doctorPriceDetialList);
}
private void btnRadiationDoctorReport_Click(object sender, EventArgs e)
{
DateTime startTime = dtpRadiationDoctorStartTime.Value.Date;
DateTime endTime = dtpRadiationDoctorEndTime.Value.Date.AddDays(1);
Dictionary <string, List <DoctorStatistics> > dictionary = _importFileService.GetStoreDoctorDetialDic(startTime, endTime);
List <DoctorStatistics> doctorStatisticsList = new List <DoctorStatistics>();
dgvRadiationStoreDoctorPrice.Rows.Clear();
dgvRadiationDoctorPrice.Rows.Clear();
foreach (var item in dictionary)
{
string storeName = item.Key;
List <DoctorStatistics> storeDoctorStatisticsList = dictionary[item.Key];
foreach (var doctorStatistics in storeDoctorStatisticsList)
{
StoreStatistics storeStatistics = new StoreStatistics();
storeStatistics.StoreName = storeName;
storeStatistics.DoctorName = doctorStatistics.DoctorName;
storeStatistics.CTAuditCount = doctorStatistics.CTAuditCount;
storeStatistics.CTDiagnosisCount = doctorStatistics.CTDiagnosisCount;
storeStatistics.CTCount = doctorStatistics.CTCount;
storeStatistics.DRAuditCount = doctorStatistics.DRAuditCount;
storeStatistics.DRDiagnosisCount = doctorStatistics.DRDiagnosisCount;
storeStatistics.DRCount = doctorStatistics.DRCount;
storeStatistics.MRAuditCount = doctorStatistics.MRAuditCount;
storeStatistics.MRDiagnosisCount = doctorStatistics.MRDiagnosisCount;
storeStatistics.MRCount = doctorStatistics.MRCount;
string priceStr = "没有找到此医生对应的放射价格.";
DoctorPriceDetial doctorPriceDetial = _importFileService.GetDoctorPriceDetial(storeStatistics.DoctorName);
if (doctorPriceDetial != null)
{
string CTDiagnosisPriceStr = doctorPriceDetial.CTDiagnosisPrice;
if (string.IsNullOrEmpty(CTDiagnosisPriceStr))
{
CTDiagnosisPriceStr = "0";
}
string CTAuditPriceStr = doctorPriceDetial.CTAuditPrice;
if (string.IsNullOrEmpty(CTAuditPriceStr))
{
CTAuditPriceStr = "0";
}
string MRDiagnosisPriceStr = doctorPriceDetial.MRDiagnosisPrice;
if (string.IsNullOrEmpty(MRDiagnosisPriceStr))
{
MRDiagnosisPriceStr = "0";
}
string MRAuditPriceStr = doctorPriceDetial.MRAuditPrice;
if (string.IsNullOrEmpty(MRAuditPriceStr))
{
MRAuditPriceStr = "0";
}
string DRDiagnosisPriceStr = doctorPriceDetial.DRDiagnosisPrice;
if (string.IsNullOrEmpty(DRDiagnosisPriceStr))
{
DRDiagnosisPriceStr = "0";
}
decimal CTDiagnosisPrice = storeStatistics.CTDiagnosisCount * Convert.ToDecimal(CTDiagnosisPriceStr);
decimal CTAuditPrice = storeStatistics.CTAuditCount * Convert.ToDecimal(CTAuditPriceStr);
decimal MRDiagnosisPrice = storeStatistics.MRDiagnosisCount * Convert.ToDecimal(MRDiagnosisPriceStr);
decimal MRAuditPrice = storeStatistics.MRAuditCount * Convert.ToDecimal(MRAuditPriceStr);
decimal DRDiagnosisPrice = storeStatistics.DRDiagnosisCount * Convert.ToDecimal(DRDiagnosisPriceStr);
//decimal DRAuditPrice = storeStatistics.DRAuditCount * Convert.ToDecimal(doctorPriceDetial.DR); //TODO::这个暂时没有
doctorStatistics.Price = CTDiagnosisPrice + CTAuditPrice + MRDiagnosisPrice + MRAuditPrice + DRDiagnosisPrice;
storeStatistics.Price = doctorStatistics.Price;
doctorStatistics.IsContainPrice = true;
storeStatistics.IsContainPrice = true;
priceStr = storeStatistics.Price.ToString();
}
var findDoctorStatistics = doctorStatisticsList.Find(d => d.DoctorName.Equals(doctorStatistics.DoctorName));
if (findDoctorStatistics != null) //找到了此医生
{
findDoctorStatistics.CTDiagnosisCount += doctorStatistics.CTDiagnosisCount;
findDoctorStatistics.CTAuditCount += doctorStatistics.CTAuditCount;
findDoctorStatistics.DRDiagnosisCount += doctorStatistics.DRDiagnosisCount;
findDoctorStatistics.DRAuditCount += doctorStatistics.DRAuditCount;
findDoctorStatistics.MRDiagnosisCount += doctorStatistics.MRDiagnosisCount;
findDoctorStatistics.MRAuditCount += doctorStatistics.MRAuditCount;
findDoctorStatistics.IsContainPrice = doctorStatistics.IsContainPrice;
findDoctorStatistics.Price += doctorStatistics.Price;
}
else //没有找到此医生
{
DoctorStatistics currentDoctorStatistics = new DoctorStatistics();
currentDoctorStatistics.DoctorName = doctorStatistics.DoctorName;
currentDoctorStatistics.CTDiagnosisCount = doctorStatistics.CTDiagnosisCount;
currentDoctorStatistics.CTAuditCount = doctorStatistics.CTAuditCount;
currentDoctorStatistics.DRDiagnosisCount = doctorStatistics.DRDiagnosisCount;
currentDoctorStatistics.DRAuditCount = doctorStatistics.DRAuditCount;
currentDoctorStatistics.MRDiagnosisCount = doctorStatistics.MRDiagnosisCount;
currentDoctorStatistics.MRAuditCount = doctorStatistics.MRAuditCount;
currentDoctorStatistics.IsContainPrice = doctorStatistics.IsContainPrice;
currentDoctorStatistics.Price = doctorStatistics.Price;
doctorStatisticsList.Add(currentDoctorStatistics);
}
dgvRadiationStoreDoctorPrice.Rows.Add(storeStatistics.StoreName, storeStatistics.DoctorName,
storeStatistics.CTDiagnosisCount, storeStatistics.CTAuditCount,
storeStatistics.MRDiagnosisCount, storeStatistics.MRAuditCount,
storeStatistics.DRDiagnosisCount, priceStr, string.Empty);
}
}
foreach (var item in doctorStatisticsList)
{
dgvRadiationDoctorPrice.Rows.Add(item.DoctorName, item.CTDiagnosisCount, item.MRDiagnosisCount, item.CTAuditCount, item.MRAuditCount, item.IsContainPrice ? item.Price.ToString() : "没有找到此医生对应的放射价格.");
}
MessageBox.Show("生成报表成功！");
}
public DoctorPriceDetial FindDoctorPriceById(Guid guid)
{
DoctorPriceDetial doctorPriceDetial = _doctorPriceDetialRepository.FindById(guid);
return(doctorPriceDetial);
}
