public TableControl(Cfhead dr)
{
InitializeComponent();
List <Cfhead> lst;
if (string.IsNullOrEmpty(dr.did))
{
lst = new CfheadManager().GetListByPatientAndAddress(dr.patient, dr.address);
}
else
{
lst = new CfheadManager().GetListByDid(dr.did);
}
this.gridControl1.DataSource = lst;
Cfhead first = lst.First();
txtPatient.Text = first.patient;
txtAge.Text = first.age;
txtPhone.Text = first.phone.Replace(first.phone.Substring(4, 4), "****");
txtId.Text = string.IsNullOrEmpty(first.did)? "无": first.did.Replace(first.did.Substring(first.did.Length - 4, 4), "****");
txtAddress.Text = first.address;
int tianShu = lst.Select(item => item.pid).Distinct().Count();
int ciShu = lst.Count();
double?price = lst.Select(item => item.totalprice).Sum();
lblXJ.Text = string.Format("处方数量:{0:N0}张，就诊天数:{1:N0}天，总金额:{2:N2}元", ciShu, tianShu, price);
txtAddress.Size = new Size(400, 20);
lblXJ.Size = new Size(400, 20);
this.tableLayoutPanel1.SetColumnSpan(txtAddress, 2);
this.tableLayoutPanel1.SetColumnSpan(lblXJ, 3);
this.gridView1.OptionsView.ColumnAutoWidth = true;
this.gridView1.FocusedRowChanged += ShowDetail;
int index = lst.FindIndex(item => item.opertime == dr.opertime);
System.Diagnostics.Debug.WriteLine(index.ToString());
if (index == 0)
{
LoadDetail(0);
}
else
{
gridView1.MoveBy(index);
}
}
private void IninConfig()
{
SplashScreenManager.ShowForm(typeof(SplashScreen1));
string maxTime = new CfheadManager().GetMaxTime();
SplashScreenManager.Default.SendCommand(null, string.Format("最新更新时间为{0},1", maxTime));
string maxDate = maxTime.Split(' ')[0].Replace("-", "").Trim();
new ImportData().AutoImport();
SplashScreenManager.Default.SendCommand(null, "内容面板预加载，开始,10");
UserControlFactory.CreateInstance("");
SplashScreenManager.Default.SendCommand(null, "内容面板预加载，结束,50");
SplashScreenManager.Default.SendCommand(null, "数据更新完成,100");
SplashScreenManager.CloseForm();
}
public void Query()
{
SelectRow = null;
cfhead = new CfheadManager().GetListByCondition(BeginTime, EndTime, Doctor, Patient);
if (this.IsAll)
{
cfhead = new CfheadManager().GetSame(BeginTime, EndTime, Doctor, Patient);
}
Dv = new HuiZongManager().GetListByCondition(this.BeginTime, this.EndTime, this.Patient, this.Doctor);
HzByDoctor = new HzByDoctor().GetDataTable(BeginTime, EndTime, Doctor, Patient);
if (HzByDoctor.Rows.Count == 0)
{
return;
}
HZ = new HuiZong()
{
Riqi = cfhead.Select(it => it.opertime).Min() + "至" + cfhead.Select(it => it.opertime).Max(),
MaxDate = cfhead.Select(it => it.opertime).Max().Split()[0],
TotalPrice = Convert.ToDouble(HzByDoctor.Compute("sum(金额)", "")),
MaxPrice = Convert.ToDouble(HzByDoctor.Compute("MAX(最大金额)", "")),
MinPrice = Convert.ToDouble(HzByDoctor.Compute("MIN(最小金额)", "")),
AvgPrice = Convert.ToDouble(HzByDoctor.Compute("Avg(平均金额)", "")),
CfCount = Convert.ToInt32(HzByDoctor.Compute("sum(处方数)", "")),
MzCount = Convert.ToInt32(HzByDoctor.Compute("sum(人次数)", "")),
YbCount = Convert.ToInt32(HzByDoctor.Compute("sum(医保)", "")),
ZfCount = Convert.ToInt32(HzByDoctor.Compute("sum(自费)", "")),
ZcyCount = Convert.ToInt32(HzByDoctor.Compute("sum(中成药)", "")),
JdCount = Convert.ToInt32(HzByDoctor.Compute("sum(静滴)", "")),
JeCount = Convert.ToInt32(HzByDoctor.Compute("sum(精二)", "")),
EkCount = Convert.ToInt32(HzByDoctor.Compute("sum(儿科)", "")),
JsCount = Convert.ToInt32(HzByDoctor.Compute("sum(激素)", "")),
KjyCount = Convert.ToInt32(HzByDoctor.Compute("sum(抗菌素)", "")),
JzCount = Convert.ToInt32(HzByDoctor.Compute("sum(急诊)", "")),
};
Huizong = HZ.ToString();
//JSDT = new HzByDoctor().GetDataTable02(BeginTime, EndTime, Doctor, Patient,"精二");
GetJS();
}
