public int ImportDrug(string filePath)
{
DataTable dtDrug = ExcelHelper.ImportExceltoDt(filePath);
List <Drug> allDrug = new DrugManager().GetAll();
List <Drug> li = DataTableToModel.ToListModel <Drug>(dtDrug).Where(item => !allDrug.Contains(item)).ToList();
PinyinHelper ph = new PinyinHelper();
li.ForEach(item => item.searchcode = ph.GetFirstLetter(item.name));
int count = new DrugManager().Insert(li);
return(count);
}
public SkyZenTask GetSkyTaskList(SkyZenTask task)
{
SkyZenTask skyZenTask = new SkyZenTask();
DataTable datatable = new DataTable();
try
{
datatable = skyZenTaskDBService.GetSkyTaskList(task);
skyZenTask = DataTableToModel.ToSingleModel <SkyZenTask>(datatable);
}
catch (Exception e)
{
throw e;
}
return(skyZenTask);
}
private static void Test01()
{
DataTable dt01 = ExcelHelper.ImportExceltoDt(@"C:\Users\Administrator\Desktop\1.xls");
DataTable dt02 = ExcelHelper.ImportExceltoDt(@"C:\Users\Administrator\Desktop\2.xls");
DateTime? maxTime01 = new FyByPatientManager().GetMaxTime();
maxTime01 = maxTime01 == null ? DateTime.MinValue : maxTime01;
DateTime?maxTime02 = new FyByDrugManager().GetMaxTime();
maxTime02 = maxTime02 == null?DateTime.Now.AddYears(-10) : maxTime02;
List <fybypatient> li01 = DataTableToModel.ToListModel <fybypatient>(dt01).Where(item => item.fytime > maxTime01).ToList();
List <fybydrug> li02 = DataTableToModel.ToListModel <fybydrug>(dt02).Where(item => item.fytime > maxTime02).ToList();
int count01 = new FyByPatientManager().Insert(li01);
int count02 = new FyByDrugManager().Insert(li02);
MessageBox.Show($"成功更新表数据为{count01},{count02}");
}
public void Init()
{
//单击查询按钮
sbQuery.Click += (s, e) =>
{
SimpleButton sb = s as SimpleButton;
DataTable dt = new DrugTJManager().Get(lueDrug.EditValue == null?"":lueDrug.Text, deBegin.Text + " 00:00:00", deEnd.Text + " 23:59:59");
gridControl1.DataSource = dt;
};
//单击更新按钮
sbRefresh.Click += (s, e) =>
{
DataTable dt01 = ExcelHelper.ImportExceltoDt(@"C:\1.xls");
DataTable dt02 = ExcelHelper.ImportExceltoDt(@"C:\2.xls");
DateTime minTime01 = Convert.ToDateTime(dt01.Compute("min([发药时间])", "true"));
DateTime minTime02 = Convert.ToDateTime(dt02.Compute("min([发/退药时间])", "true"));
DateTime?maxTime01 = new FyByPatientManager().GetMaxTime();
maxTime01 = maxTime01 == null ? DateTime.MinValue : maxTime01;
DateTime?maxTime02 = new FyByDrugManager().GetMaxTime();
maxTime02 = maxTime02 == null ? DateTime.MinValue : maxTime02;
//if (minTime01 <= maxTime01 || minTime02 <= maxTime02)
//{
// MessageBox.Show("为防止有数据遗漏,请重新导入数据");
// return;
//}
List <fybypatient> li01 = DataTableToModel.ToListModel <fybypatient>(dt01).Where(item => item.fytime > maxTime01).ToList();
List <fybydrug> li02 = DataTableToModel.ToListModel <fybydrug>(dt02).Where(item => item.fytime > maxTime02).ToList();
int count01 = new FyByPatientManager().Insert(li01);
int count02 = new FyByDrugManager().Insert(li02);
MessageBox.Show($"成功更新表数据为{count01},{count02}");
string maxT = new FyByPatientManager().GetMaxTime().ToString();
xtraTabControl2.CustomHeaderButtons[0].Caption = $"更新时间为：{maxT}";
};
xtraTabControl1.CustomHeaderButtonClick += (s, e) =>
{
if (e.Button.Caption == "导出数据")
{
//gridView1.ExportToXlsx(@"C:\Users\Administrator\Desktop\yytj.xlsx");
string filename = MySaveFileDialog.Show();
if (!string.IsNullOrEmpty(filename))
{
gridView1.ExportToXlsx(filename);
}
}
else if (e.Button.Caption == "展开")
{
gridView1.ExpandAllGroups();
e.Button.Caption = "收缩";
}
else if (e.Button.Caption == "收缩")
{
gridView1.CollapseAllGroups();
e.Button.Caption = "展开";
}
};
gridView1.RowCellClick += (s, e) =>
{
DataRow dr = gridView1.GetDataRow(e.RowHandle);
string doctor = dr["doctor"].ToString();
string code = dr["code"].ToString();
string drug = dr["name"].ToString();
string spci = dr["spci"].ToString();
string unitprice = dr["unitprice"].ToString();
string quantity = dr["quantity"].ToString();
xtraTabControl2.TabPages[0].Text = $"医生用药明细 [{code},{drug},{spci},{unitprice},{quantity}]";
gridControl2.DataSource = new FyByPatientManager().GetListByCondition(deBegin.Text + " 00:00:00", deEnd.Text + " 23:59:59", doctor, code).OrderBy(item => item.fytime);
};
DateTime?maxTime = new FyByPatientManager().GetMaxTime();
maxTime = maxTime == null ? DateTime.MinValue : maxTime;
string mt = maxTime.ToString();
xtraTabControl2.CustomHeaderButtons[0].Caption = $"更新时间为：{mt}";
deBegin.EditValue = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
deEnd.EditValue = DateTime.Now;
lueDrug.Properties.DataSource = SqlHelper.ExecuteTable("select distinct name 名称,searchcode 搜索码 from drug");
lueDrug.EditValue = "";
lueDrug.Properties.DisplayMember = "名称";
lueDrug.Properties.ValueMember = "名称";
}
protected void InitServices()
{
Sql_ = new SQL(GetSvr_MC(), GetDb_MC(), GetUsr_MC(), GetPwd_MC(), false);
DataTableToModel_ = new DataTableToModel();
}
