private void LoadBucterList()
{
List <double> outValue = new List <double>();//输出统计数
DataSet ds = new DataSet();
//PatientObject po = new PatientObject();
Maticsoft.BLL.Patient bll = new Maticsoft.BLL.Patient();
int startIndex = (pagination1.CurrentPage - 1) * pagination1.PageSize;
int endIndex = pagination1.PageSize * pagination1.CurrentPage - 1;
ds = bll.GetListByPage("", "", startIndex, endIndex);
ugGrid.DataSource = ds;
ugGrid.DataBind();
pagination1.RecordCount = bll.GetRecordCount("");
//if (outValue != null && outValue.Count != 0)
//{
// pagination1.RecordCount = Convert.ToInt32(outValue[0]);//记录数
// this.pagination1.StaticInfo = ugGrid.DisplayLayout.Bands[0].Columns["ANIMALAMOUNT"].Header.Caption + outValue[1].ToString() //检疫数
// + " " + ugGrid.DisplayLayout.Bands[0].Columns["AMOUNT"].Header.Caption + outValue[2].ToString() //进场数
// + " " + ugGrid.DisplayLayout.Bands[0].Columns["BUTCHERNUM"].Header.Caption + outValue[3].ToString() //屠宰数
// + " " + ugGrid.DisplayLayout.Bands[0].Columns["PRODUCTNUM"].Header.Caption + outValue[4].ToString(); //出厂数
//}
//else
//{
// pagination1.RecordCount = 0;
//}
}
private void BindTraceList()
{
Maticsoft.BLL.Patient bll = new Maticsoft.BLL.Patient();
DataSet dt = bll.GetTracedPatient();
this.ugBadAction_w.DataSource = dt;
this.ugBadAction_w.DataBind();
}
private void BindPatientDetail()
{
Maticsoft.BLL.Patient bll = new Maticsoft.BLL.Patient();
Maticsoft.Model.Patient p = bll.GetModel(int.Parse(PatientID));
if (p != null)
{
this.txtIDNo.Text = p.IDCode;
this.txtName.Text = p.Name;
}
}
//export data to excel
private void btnOK_Click(object sender, EventArgs e)
{
Maticsoft.BLL.Patient patientBLL = new Maticsoft.BLL.Patient();
DataSet ds = patientBLL.GetAllListWithTitle();
ds.Tables[0].TableName = "患者信息";
//人口学数据
Maticsoft.BLL.Demographic demoBLL = new Maticsoft.BLL.Demographic();
DataTable dtDemo = demoBLL.GetAllListWithTitle().Tables[0].Copy();
dtDemo.TableName = "人口学数据";
//一般情况
Maticsoft.BLL.GeneralInfo geneBLL = new Maticsoft.BLL.GeneralInfo();
DataTable dtGene = geneBLL.GetAllListWithTitle().Tables[0].Copy();
dtGene.TableName = "一般情况";
ds.Tables.Add(dtDemo);
ds.Tables.Add(dtGene);
DialogResult result = this.folderBrowserDialog1.ShowDialog();
if (result == DialogResult.OK)
{
string foldername = this.folderBrowserDialog1.SelectedPath;
try
{
if (cbTreatInfo.Checked || cbTreatInfoBadAction.Checked)
{
DataSet dsTreatInfo = GetTreatInfo();
CreateExcelFile.CreateExcelDocument(dsTreatInfo, foldername + @"\治疗情况.xlsx");
}
if (cbCOPD.Checked || cbBlood.Checked || cbLung.Checked || cbDicom.Checked || cbChartis.Checked || cbSport.Checked)
{
DataSet dsBeforeTreatInfo = GetBeforeTreatInfo();
CreateExcelFile.CreateExcelDocument(dsBeforeTreatInfo, foldername + @"\治疗前基线指标.xlsx");
}
CreateExcelFile.CreateExcelDocument(ds, foldername + @"\患者基本信息.xlsx");
MessageBox.Show("数据提取成功!");
if (File.Exists(foldername))
{
Process.Start("explorer.exe", foldername);
}
}
catch (Exception ex)
{
MessageBox.Show("Couldn't create Excel file.\r\nException: " + ex.Message);
return;
}
// the code here will be executed if the user presses Open in
// the dialog.
}
}
private void ShowPops()
{
Maticsoft.BLL.Patient bll = new Maticsoft.BLL.Patient();
DataSet ds = bll.GetTracedPatient();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
ShowPatientPop(dr["ID"].ToString(), dr["Name"].ToString(), dr["Period"].ToString(), dr["PeriodName"].ToString());
}
}
}
private bool SavePatientInfo()
{
Maticsoft.BLL.Patient bll = new Maticsoft.BLL.Patient();
bool ret = true; //标记位
if (OperatType == 0)
{
Patient patientInfo = new Patient();
patientInfo.IDCode = this.txtIDNo.Text;
patientInfo.Name = this.txtName.Text;
patientInfo.SignDate = DateTime.Now;
patientInfo.ModifyDate = DateTime.Now;
ret = bll.Add(patientInfo);// PatientObject.AddPatientInfo(patientInfo);//新增屠宰信息
}
else if (OperatType == 1)
{
Patient patientInfo = bll.GetModel(int.Parse(PatientID));
patientInfo.IDCode = this.txtIDNo.Text;
patientInfo.Name = this.txtName.Text;
patientInfo.ModifyDate = DateTime.Now;
ret = bll.Update(patientInfo);// PatientObject.EditPatientInfo(patientInfo);//编辑屠宰信息
}
return(ret);
}
public AfterTreatTrace(int patientID, int treatPeriod)
{
InitializeComponent();
pid = patientID;
period = treatPeriod;
Maticsoft.BLL.Patient patientBLL = new Maticsoft.BLL.Patient();
Patient p = patientBLL.GetModel(pid);
if (p != null)
{
patientName = p.Name;
}
switch (period)
{
case TreatPeroid.AfterTreatment.OneWeek:
periodName = "治疗后第1周";
break;
case TreatPeroid.AfterTreatment.OneMonth:
periodName = "治疗后1月";
break;
case TreatPeroid.AfterTreatment.ThreeMonth:
periodName = "治疗后3月";
break;
case TreatPeroid.AfterTreatment.SixMonth:
periodName = "治疗后6月";
break;
case TreatPeroid.AfterTreatment.OneYear:
periodName = "治疗后1年";
break;
case TreatPeroid.AfterTreatment.TwoYear:
periodName = "治疗后2年";
break;
case TreatPeroid.AfterTreatment.ThreeYear:
periodName = "治疗后3年 ";
break;
case TreatPeroid.AfterTreatment.FourYear:
periodName = "治疗后4年";
break;
case TreatPeroid.AfterTreatment.FiveYear:
periodName = "治疗后5年";
break;
}
StringBuilder sb = new StringBuilder();
sb.Append("填写");
sb.Append(periodName);
sb.Append("随访数据 - ");
sb.Append("[患者:");
sb.Append(patientName);
sb.Append("]");
this.Text = sb.ToString();
BindWeekInfo();
FreezeForm.ChangeControlEditable(this, false);
}
