public bool SaveModelToDB()
{
this.chronicLungerFirstVisitModel.FollowupDate = this.dtpFollowupDate.Value;
this.chronicLungerFirstVisitModel.MediclineReceiveTime = this.txtMediclineReceiveTime.Value;
this.chronicLungerFirstVisitModel.NextVisitDate = this.dtpNextVisitDate.Value;
ChronicLungerFirstVisitBLL chronicLungerFirstVisitBLL = new ChronicLungerFirstVisitBLL();
string strWhere = string.Format("IDCardNo='{0}' and FollowupDate='{1}' ", this.chronicLungerFirstVisitModel.IDCardNo, this.dtpFollowupDate.Value.Date);
ChronicLungerFirstVisitModel ChronicModel = chronicLungerFirstVisitBLL.CheckModel(strWhere);
if (ChronicModel != null)
{
if (PTBFactory.ID > 0 && this.visitdate == this.chronicLungerFirstVisitModel.FollowupDate.ToString())
{
this.chronicLungerFirstVisitModel.ID = ChronicModel.ID;
PTBFactory.ID = ChronicModel.ID;
chronicLungerFirstVisitBLL.Update(this.chronicLungerFirstVisitModel);
}
else
{
DialogResult result = DialogResult.OK;
result = MessageBox.Show("此日期下已有随访信息，是否进行修改？", "提示", MessageBoxButtons.OKCancel);
if (result == DialogResult.OK)
{
if (!PTBFactory.NewAdd)
{
chronicLungerFirstVisitBLL.Delete(this.chronicLungerFirstVisitModel.ID);
}
this.chronicLungerFirstVisitModel.ID = ChronicModel.ID;
PTBFactory.ID = ChronicModel.ID;
chronicLungerFirstVisitBLL.Update(this.chronicLungerFirstVisitModel);
}
else
{
PTBFactory.ID = -1;
return(true);
}
}
}
else
{
if (!PTBFactory.NewAdd)
{
chronicLungerFirstVisitBLL.Delete(this.chronicLungerFirstVisitModel.ID);
}
PTBFactory.ID = chronicLungerFirstVisitBLL.Add(this.chronicLungerFirstVisitModel);
}
string NewSign = string.Format("{0}{1}_{2}.png", this.SignPath, this.Model.IDCardNo, Convert.ToDateTime(this.dtpFollowupDate.Value).ToString("yyyyMMdd"));
string NewSignDoc = string.Format("{0}{1}_{2}_Doc.png", this.SignPath, this.Model.IDCardNo, Convert.ToDateTime(this.dtpFollowupDate.Value).ToString("yyyyMMdd"));
return(true);
}
public List <ChronicLungerFirstVisitModel> DataTableToList(DataTable dt)
{
List <ChronicLungerFirstVisitModel> list = new List <ChronicLungerFirstVisitModel>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
ChronicLungerFirstVisitModel item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
private void GetModel()
{
this.ptb_oper = new ChronicLungerFirstVisitBLL();
if (PTBFactory.ID == 0)
{
PTBFactory.NewAdd = true; //新增一笔数据标志
this.chronicLungerFirstVisitModel = this.ptb_oper.GetModel(this.Model.IDCardNo);
this.dtpFollowupDate.Value = DateTime.Today.Date;
}
else
{
this.chronicLungerFirstVisitModel = this.ptb_oper.GetModelByID(PTBFactory.ID);
if (this.chronicLungerFirstVisitModel.FollowupDate.HasValue)
{
this.dtpFollowupDate.Value = this.chronicLungerFirstVisitModel.FollowupDate.Value;
this.visitdate = this.chronicLungerFirstVisitModel.FollowupDate.ToString();
}
PTBFactory.NewAdd = false;
}
if (this.chronicLungerFirstVisitModel == null)
{
ChronicLungerFirstVisitModel chronicLungerFirstVisit = new ChronicLungerFirstVisitModel
{
IDCardNo = this.Model.IDCardNo,
FollowupWay = "1"
};
this.chronicLungerFirstVisitModel = chronicLungerFirstVisit;
this.chronicLungerFirstVisitModel.CreatedBy = ConfigHelper.GetNode("doctor");
this.chronicLungerFirstVisitModel.CreatedDate = new DateTime?(DateTime.Today);
}
else
{
PTBFactory.ID = this.chronicLungerFirstVisitModel.ID;
this.chronicLungerFirstVisitModel.LastUpdateBy = ConfigHelper.GetNode("doctor");
this.chronicLungerFirstVisitModel.LastUpdateDate = new DateTime?(DateTime.Today);
}
this.bindingManager = new SimpleBindingManager <ChronicLungerFirstVisitModel>(this.inputRanges, this.inputrange_str, this.chronicLungerFirstVisitModel);
}
public bool Update(ChronicLungerFirstVisitModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update CD_PTB_FIRSTVISIT set ");
builder.Append("RecordID=@RecordID,");
builder.Append("CustomerID=@CustomerID,");
builder.Append("IDCardNo=@IDCardNo,");
builder.Append("CustomerName=@CustomerName,");
builder.Append("FollowupDate=@FollowupDate,");
builder.Append("EstimateDoctor=@EstimateDoctor,");
builder.Append("FollowupWay=@FollowupWay,");
builder.Append("PatientType=@PatientType,");
builder.Append("Sputumfungs=@Sputumfungs,");
builder.Append("DrugFast=@DrugFast,");
builder.Append("Symptom=@Symptom,");
builder.Append("SymptomEx=@SymptomEx,");
builder.Append("MedicationCompliance=@MedicationCompliance,");
builder.Append("ChemotherapyScheme=@ChemotherapyScheme,");
builder.Append("DrugType=@DrugType,");
builder.Append("Supervisor=@Supervisor,");
builder.Append("StandaloneRoom=@StandaloneRoom,");
builder.Append("Ventilation=@Ventilation,");
builder.Append("SmokeDayNum=@SmokeDayNum,");
builder.Append("DayDrinkVolume=@DayDrinkVolume,");
builder.Append("MediclineReceiveTime=@MediclineReceiveTime,");
builder.Append("MediclineReceivePlace=@MediclineReceivePlace,");
builder.Append("RecordcardWrite=@RecordcardWrite,");
builder.Append("PharmacyWayDeposit=@PharmacyWayDeposit,");
builder.Append("Therapies=@Therapies,");
builder.Append("IndisciplineHarm=@IndisciplineHarm,");
builder.Append("AdrsHandle=@AdrsHandle,");
builder.Append("SubsequentVisit=@SubsequentVisit,");
builder.Append("InsistPharmacy=@InsistPharmacy,");
builder.Append("LivingHabit=@LivingHabit,");
builder.Append("ChecktouchPerson=@ChecktouchPerson,");
builder.Append("NextVisitDate=@NextVisitDate,");
builder.Append("CreatedBy=@CreatedBy,");
builder.Append("CreatedDate=@CreatedDate,");
builder.Append("LastUpdateBy=@LastUpdateBy,");
builder.Append("LastUpdateDate=@LastUpdateDate,");
builder.Append("IsDel=@IsDel,");
builder.Append("VisitDoctor = @VisitDoctor, ");
builder.Append("NextSmokeDayNum=@NextSmokeDayNum,");
builder.Append("NextDayDrinkVolume=@NextDayDrinkVolume ");
builder.Append(" where ID=@ID");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@RecordID", MySqlDbType.String, 17),
new MySqlParameter("@CustomerID", MySqlDbType.String, 32),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@CustomerName", MySqlDbType.String, 30),
new MySqlParameter("@FollowupDate", MySqlDbType.Date),
new MySqlParameter("@EstimateDoctor", MySqlDbType.String, 30),
new MySqlParameter("@FollowupWay", MySqlDbType.String, 1),
new MySqlParameter("@PatientType", MySqlDbType.String, 1),
new MySqlParameter("@Sputumfungs", MySqlDbType.String, 1),
new MySqlParameter("@DrugFast", MySqlDbType.String, 1),
new MySqlParameter("@Symptom", MySqlDbType.String, 20),
new MySqlParameter("@SymptomEx", MySqlDbType.String, 500),
new MySqlParameter("@MedicationCompliance", MySqlDbType.String, 1),
new MySqlParameter("@ChemotherapyScheme", MySqlDbType.String, 500),
new MySqlParameter("@DrugType", MySqlDbType.String, 20),
new MySqlParameter("@Supervisor", MySqlDbType.String, 1),
new MySqlParameter("@StandaloneRoom", MySqlDbType.String, 1),
new MySqlParameter("@Ventilation", MySqlDbType.String, 1),
new MySqlParameter("@SmokeDayNum", MySqlDbType.Decimal),
new MySqlParameter("@DayDrinkVolume", MySqlDbType.Decimal),
new MySqlParameter("@MediclineReceiveTime", MySqlDbType.Date),
new MySqlParameter("@MediclineReceivePlace", MySqlDbType.String, 500),
new MySqlParameter("@RecordcardWrite", MySqlDbType.String, 1),
new MySqlParameter("@PharmacyWayDeposit", MySqlDbType.String, 1),
new MySqlParameter("@Therapies", MySqlDbType.String, 1),
new MySqlParameter("@IndisciplineHarm", MySqlDbType.String, 1),
new MySqlParameter("@AdrsHandle", MySqlDbType.String, 1),
new MySqlParameter("@SubsequentVisit", MySqlDbType.String, 1),
new MySqlParameter("@InsistPharmacy", MySqlDbType.String, 1),
new MySqlParameter("@LivingHabit", MySqlDbType.String, 1),
new MySqlParameter("@ChecktouchPerson", MySqlDbType.String, 1),
new MySqlParameter("@NextVisitDate", MySqlDbType.Date),
new MySqlParameter("@CreatedBy", MySqlDbType.String, 30),
new MySqlParameter("@CreatedDate", MySqlDbType.Date),
new MySqlParameter("@LastUpdateBy", MySqlDbType.String, 30),
new MySqlParameter("@LastUpdateDate", MySqlDbType.Date),
new MySqlParameter("@IsDel", MySqlDbType.String, 1),
new MySqlParameter("@VisitDoctor", MySqlDbType.String, 100),
new MySqlParameter("@NextSmokeDayNum", MySqlDbType.Decimal),
new MySqlParameter("@NextDayDrinkVolume", MySqlDbType.Decimal),
new MySqlParameter("@ID", MySqlDbType.Int32, 8)
};
cmdParms[0].Value = model.RecordID;
cmdParms[1].Value = model.CustomerID;
cmdParms[2].Value = model.IDCardNo;
cmdParms[3].Value = model.CustomerName;
cmdParms[4].Value = model.FollowupDate;
cmdParms[5].Value = model.EstimateDoctor;
cmdParms[6].Value = model.FollowupWay;
cmdParms[7].Value = model.PatientType;
cmdParms[8].Value = model.Sputumfungs;
cmdParms[9].Value = model.DrugFast;
cmdParms[10].Value = model.Symptom;
cmdParms[11].Value = model.SymptomEx;
cmdParms[12].Value = model.MedicationCompliance;
cmdParms[13].Value = model.ChemotherapyScheme;
cmdParms[14].Value = model.DrugType;
cmdParms[15].Value = model.Supervisor;
cmdParms[16].Value = model.StandaloneRoom;
cmdParms[17].Value = model.Ventilation;
cmdParms[18].Value = model.SmokeDayNum;
cmdParms[19].Value = model.DayDrinkVolume;
cmdParms[20].Value = model.MediclineReceiveTime;
cmdParms[21].Value = model.MediclineReceivePlace;
cmdParms[22].Value = model.RecordcardWrite;
cmdParms[23].Value = model.PharmacyWayDeposit;
cmdParms[24].Value = model.Therapies;
cmdParms[25].Value = model.IndisciplineHarm;
cmdParms[26].Value = model.AdrsHandle;
cmdParms[27].Value = model.SubsequentVisit;
cmdParms[28].Value = model.InsistPharmacy;
cmdParms[29].Value = model.LivingHabit;
cmdParms[30].Value = model.ChecktouchPerson;
cmdParms[31].Value = model.NextVisitDate;
cmdParms[32].Value = model.CreatedBy;
cmdParms[33].Value = model.CreatedDate;
cmdParms[34].Value = model.LastUpdateBy;
cmdParms[35].Value = model.LastUpdateDate;
cmdParms[36].Value = model.IsDel;
cmdParms[37].Value = model.VisitDoctor;
cmdParms[38].Value = model.NextSmokeDayNum;
cmdParms[39].Value = model.NextDayDrinkVolume;
cmdParms[40].Value = model.ID;
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public ChronicLungerFirstVisitModel DataRowToModel(DataRow row)
{
ChronicLungerFirstVisitModel chronicLungerFirstVisitModel = new ChronicLungerFirstVisitModel();
if (row != null)
{
if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != ""))
{
chronicLungerFirstVisitModel.ID = int.Parse(row["ID"].ToString());
}
if ((row["RecordID"] != null) && (row["RecordID"] != DBNull.Value))
{
chronicLungerFirstVisitModel.RecordID = row["RecordID"].ToString();
}
if ((row["CustomerID"] != null) && (row["CustomerID"] != DBNull.Value))
{
chronicLungerFirstVisitModel.CustomerID = row["CustomerID"].ToString();
}
if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value))
{
chronicLungerFirstVisitModel.IDCardNo = row["IDCardNo"].ToString();
}
if ((row["CustomerName"] != null) && (row["CustomerName"] != DBNull.Value))
{
chronicLungerFirstVisitModel.CustomerName = row["CustomerName"].ToString();
}
if (((row["FollowupDate"] != null) && (row["FollowupDate"] != DBNull.Value)) && (row["FollowupDate"].ToString() != ""))
{
chronicLungerFirstVisitModel.FollowupDate = new DateTime?(DateTime.Parse(row["FollowupDate"].ToString()));
}
if ((row["EstimateDoctor"] != null) && (row["EstimateDoctor"] != DBNull.Value))
{
chronicLungerFirstVisitModel.EstimateDoctor = row["EstimateDoctor"].ToString();
}
if ((row["FollowupWay"] != null) && (row["FollowupWay"] != DBNull.Value))
{
chronicLungerFirstVisitModel.FollowupWay = row["FollowupWay"].ToString();
}
if ((row["PatientType"] != null) && (row["PatientType"] != DBNull.Value))
{
chronicLungerFirstVisitModel.PatientType = row["PatientType"].ToString();
}
if ((row["Sputumfungs"] != null) && (row["Sputumfungs"] != DBNull.Value))
{
chronicLungerFirstVisitModel.Sputumfungs = row["Sputumfungs"].ToString();
}
if ((row["DrugFast"] != null) && (row["DrugFast"] != DBNull.Value))
{
chronicLungerFirstVisitModel.DrugFast = row["DrugFast"].ToString();
}
if ((row["Symptom"] != null) && (row["Symptom"] != DBNull.Value))
{
chronicLungerFirstVisitModel.Symptom = row["Symptom"].ToString();
}
if ((row["SymptomEx"] != null) && (row["SymptomEx"] != DBNull.Value))
{
chronicLungerFirstVisitModel.SymptomEx = row["SymptomEx"].ToString();
}
if ((row["MedicationCompliance"] != null) && (row["MedicationCompliance"] != DBNull.Value))
{
chronicLungerFirstVisitModel.MedicationCompliance = row["MedicationCompliance"].ToString();
}
if ((row["ChemotherapyScheme"] != null) && (row["ChemotherapyScheme"] != DBNull.Value))
{
chronicLungerFirstVisitModel.ChemotherapyScheme = row["ChemotherapyScheme"].ToString();
}
if ((row["DrugType"] != null) && (row["DrugType"] != DBNull.Value))
{
chronicLungerFirstVisitModel.DrugType = row["DrugType"].ToString();
}
if ((row["Supervisor"] != null) && (row["Supervisor"] != DBNull.Value))
{
chronicLungerFirstVisitModel.Supervisor = row["Supervisor"].ToString();
}
if ((row["StandaloneRoom"] != null) && (row["StandaloneRoom"] != DBNull.Value))
{
chronicLungerFirstVisitModel.StandaloneRoom = row["StandaloneRoom"].ToString();
}
if ((row["Ventilation"] != null) && (row["Ventilation"] != DBNull.Value))
{
chronicLungerFirstVisitModel.Ventilation = row["Ventilation"].ToString();
}
if (((row["SmokeDayNum"] != null) && (row["SmokeDayNum"] != DBNull.Value)) && (row["SmokeDayNum"].ToString() != ""))
{
chronicLungerFirstVisitModel.SmokeDayNum = new decimal?(decimal.Parse(row["SmokeDayNum"].ToString()));
}
if (((row["NextSmokeDayNum"] != null) && (row["NextSmokeDayNum"] != DBNull.Value)) && (row["NextSmokeDayNum"].ToString() != ""))
{
chronicLungerFirstVisitModel.NextSmokeDayNum = new decimal?(decimal.Parse(row["NextSmokeDayNum"].ToString()));
}
if (((row["DayDrinkVolume"] != null) && (row["DayDrinkVolume"] != DBNull.Value)) && (row["DayDrinkVolume"].ToString() != ""))
{
chronicLungerFirstVisitModel.DayDrinkVolume = new decimal?(decimal.Parse(row["DayDrinkVolume"].ToString()));
}
if (((row["NextDayDrinkVolume"] != null) && (row["NextDayDrinkVolume"] != DBNull.Value)) && (row["NextDayDrinkVolume"].ToString() != ""))
{
chronicLungerFirstVisitModel.NextDayDrinkVolume = new decimal?(decimal.Parse(row["NextDayDrinkVolume"].ToString()));
}
if (((row["MediclineReceiveTime"] != null) && (row["MediclineReceiveTime"] != DBNull.Value)) && (row["MediclineReceiveTime"].ToString() != ""))
{
chronicLungerFirstVisitModel.MediclineReceiveTime = new DateTime?(DateTime.Parse(row["MediclineReceiveTime"].ToString()));
}
if ((row["MediclineReceivePlace"] != null) && (row["MediclineReceivePlace"] != DBNull.Value))
{
chronicLungerFirstVisitModel.MediclineReceivePlace = row["MediclineReceivePlace"].ToString();
}
if ((row["RecordcardWrite"] != null) && (row["RecordcardWrite"] != DBNull.Value))
{
chronicLungerFirstVisitModel.RecordcardWrite = row["RecordcardWrite"].ToString();
}
if ((row["PharmacyWayDeposit"] != null) && (row["PharmacyWayDeposit"] != DBNull.Value))
{
chronicLungerFirstVisitModel.PharmacyWayDeposit = row["PharmacyWayDeposit"].ToString();
}
if ((row["Therapies"] != null) && (row["Therapies"] != DBNull.Value))
{
chronicLungerFirstVisitModel.Therapies = row["Therapies"].ToString();
}
if ((row["IndisciplineHarm"] != null) && (row["IndisciplineHarm"] != DBNull.Value))
{
chronicLungerFirstVisitModel.IndisciplineHarm = row["IndisciplineHarm"].ToString();
}
if ((row["AdrsHandle"] != null) && (row["AdrsHandle"] != DBNull.Value))
{
chronicLungerFirstVisitModel.AdrsHandle = row["AdrsHandle"].ToString();
}
if ((row["SubsequentVisit"] != null) && (row["SubsequentVisit"] != DBNull.Value))
{
chronicLungerFirstVisitModel.SubsequentVisit = row["SubsequentVisit"].ToString();
}
if ((row["InsistPharmacy"] != null) && (row["InsistPharmacy"] != DBNull.Value))
{
chronicLungerFirstVisitModel.InsistPharmacy = row["InsistPharmacy"].ToString();
}
if ((row["LivingHabit"] != null) && (row["LivingHabit"] != DBNull.Value))
{
chronicLungerFirstVisitModel.LivingHabit = row["LivingHabit"].ToString();
}
if ((row["ChecktouchPerson"] != null) && (row["ChecktouchPerson"] != DBNull.Value))
{
chronicLungerFirstVisitModel.ChecktouchPerson = row["ChecktouchPerson"].ToString();
}
if (((row["NextVisitDate"] != null) && (row["NextVisitDate"] != DBNull.Value)) && (row["NextVisitDate"].ToString() != ""))
{
chronicLungerFirstVisitModel.NextVisitDate = new DateTime?(DateTime.Parse(row["NextVisitDate"].ToString()));
}
if ((row["CreatedBy"] != null) && (row["CreatedBy"] != DBNull.Value))
{
chronicLungerFirstVisitModel.CreatedBy = row["CreatedBy"].ToString();
}
if (((row["CreatedDate"] != null) && (row["CreatedDate"] != DBNull.Value)) && (row["CreatedDate"].ToString() != ""))
{
chronicLungerFirstVisitModel.CreatedDate = new DateTime?(DateTime.Parse(row["CreatedDate"].ToString()));
}
if ((row["LastUpdateBy"] != null) && (row["LastUpdateBy"] != DBNull.Value))
{
chronicLungerFirstVisitModel.LastUpdateBy = row["LastUpdateBy"].ToString();
}
if (((row["LastUpdateDate"] != null) && (row["LastUpdateDate"] != DBNull.Value)) && (row["LastUpdateDate"].ToString() != ""))
{
chronicLungerFirstVisitModel.LastUpdateDate = new DateTime?(DateTime.Parse(row["LastUpdateDate"].ToString()));
}
if ((row["IsDel"] != null) && (row["IsDel"] != DBNull.Value))
{
chronicLungerFirstVisitModel.IsDel = row["IsDel"].ToString();
}
if ((row["VisitDoctor"] != null) && (row["VisitDoctor"] != DBNull.Value))
{
chronicLungerFirstVisitModel.VisitDoctor = row["VisitDoctor"].ToString();
}
}
return(chronicLungerFirstVisitModel);
}
public int Add(ChronicLungerFirstVisitModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into CD_PTB_FIRSTVISIT(");
builder.Append("RecordID,CustomerID,IDCardNo,CustomerName,FollowupDate,EstimateDoctor,");
builder.Append("FollowupWay,PatientType,Sputumfungs,DrugFast,Symptom,SymptomEx,MedicationCompliance,");
builder.Append("ChemotherapyScheme,DrugType,Supervisor,StandaloneRoom,Ventilation,");
builder.Append("SmokeDayNum,DayDrinkVolume,MediclineReceiveTime,MediclineReceivePlace,RecordcardWrite,");
builder.Append("PharmacyWayDeposit,Therapies,IndisciplineHarm,AdrsHandle,SubsequentVisit,InsistPharmacy,LivingHabit,");
builder.Append("ChecktouchPerson,NextVisitDate,CreatedBy,CreatedDate,LastUpdateBy,LastUpdateDate,IsDel,VisitDoctor,");
builder.Append("NextSmokeDayNum,NextDayDrinkVolume)");
builder.Append(" values (");
builder.Append("@RecordID,@CustomerID,@IDCardNo,@CustomerName,@FollowupDate,@EstimateDoctor,");
builder.Append("@FollowupWay,@PatientType,@Sputumfungs,@DrugFast,@Symptom,@SymptomEx,@MedicationCompliance,");
builder.Append("@ChemotherapyScheme,@DrugType,@Supervisor,@StandaloneRoom,@Ventilation,");
builder.Append("@SmokeDayNum,@DayDrinkVolume,@MediclineReceiveTime,@MediclineReceivePlace,@RecordcardWrite,");
builder.Append("@PharmacyWayDeposit,@Therapies,@IndisciplineHarm,@AdrsHandle,@SubsequentVisit,@InsistPharmacy,@LivingHabit,");
builder.Append("@ChecktouchPerson,@NextVisitDate,@CreatedBy,@CreatedDate,@LastUpdateBy,@LastUpdateDate,@IsDel,@VisitDoctor,");
builder.Append("@NextSmokeDayNum,@NextDayDrinkVolume)");
builder.Append(";select @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@RecordID", MySqlDbType.String, 17),
new MySqlParameter("@CustomerID", MySqlDbType.String, 32),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@CustomerName", MySqlDbType.String, 30),
new MySqlParameter("@FollowupDate", MySqlDbType.Date),
new MySqlParameter("@EstimateDoctor", MySqlDbType.String, 30),
new MySqlParameter("@FollowupWay", MySqlDbType.String, 1),
new MySqlParameter("@PatientType", MySqlDbType.String, 1),
new MySqlParameter("@Sputumfungs", MySqlDbType.String, 1),
new MySqlParameter("@DrugFast", MySqlDbType.String, 1),
new MySqlParameter("@Symptom", MySqlDbType.String, 20),
new MySqlParameter("@SymptomEx", MySqlDbType.String, 500),
new MySqlParameter("@MedicationCompliance", MySqlDbType.String, 1),
new MySqlParameter("@ChemotherapyScheme", MySqlDbType.String, 500),
new MySqlParameter("@DrugType", MySqlDbType.String, 20),
new MySqlParameter("@Supervisor", MySqlDbType.String, 1),
new MySqlParameter("@StandaloneRoom", MySqlDbType.String, 1),
new MySqlParameter("@Ventilation", MySqlDbType.String, 1),
new MySqlParameter("@SmokeDayNum", MySqlDbType.Decimal),
new MySqlParameter("@DayDrinkVolume", MySqlDbType.Decimal),
new MySqlParameter("@MediclineReceiveTime", MySqlDbType.Date),
new MySqlParameter("@MediclineReceivePlace", MySqlDbType.String, 500),
new MySqlParameter("@RecordcardWrite", MySqlDbType.String, 1),
new MySqlParameter("@PharmacyWayDeposit", MySqlDbType.String, 1),
new MySqlParameter("@Therapies", MySqlDbType.String, 1),
new MySqlParameter("@IndisciplineHarm", MySqlDbType.String, 1),
new MySqlParameter("@AdrsHandle", MySqlDbType.String, 1),
new MySqlParameter("@SubsequentVisit", MySqlDbType.String, 1),
new MySqlParameter("@InsistPharmacy", MySqlDbType.String, 1),
new MySqlParameter("@LivingHabit", MySqlDbType.String, 1),
new MySqlParameter("@ChecktouchPerson", MySqlDbType.String, 1),
new MySqlParameter("@NextVisitDate", MySqlDbType.Date),
new MySqlParameter("@CreatedBy", MySqlDbType.String, 30),
new MySqlParameter("@CreatedDate", MySqlDbType.Date),
new MySqlParameter("@LastUpdateBy", MySqlDbType.String, 30),
new MySqlParameter("@LastUpdateDate", MySqlDbType.Date),
new MySqlParameter("@IsDel", MySqlDbType.String, 1),
new MySqlParameter("@VisitDoctor", MySqlDbType.String, 100),
new MySqlParameter("@NextSmokeDayNum", MySqlDbType.Decimal),
new MySqlParameter("@NextDayDrinkVolume", MySqlDbType.Decimal)
};
cmdParms[0].Value = model.RecordID;
cmdParms[1].Value = model.CustomerID;
cmdParms[2].Value = model.IDCardNo;
cmdParms[3].Value = model.CustomerName;
cmdParms[4].Value = model.FollowupDate;
cmdParms[5].Value = model.EstimateDoctor;
cmdParms[6].Value = model.FollowupWay;
cmdParms[7].Value = model.PatientType;
cmdParms[8].Value = model.Sputumfungs;
cmdParms[9].Value = model.DrugFast;
cmdParms[10].Value = model.Symptom;
cmdParms[11].Value = model.SymptomEx;
cmdParms[12].Value = model.MedicationCompliance;
cmdParms[13].Value = model.ChemotherapyScheme;
cmdParms[14].Value = model.DrugType;
cmdParms[15].Value = model.Supervisor;
cmdParms[16].Value = model.StandaloneRoom;
cmdParms[17].Value = model.Ventilation;
cmdParms[18].Value = model.SmokeDayNum;
cmdParms[19].Value = model.DayDrinkVolume;
cmdParms[20].Value = model.MediclineReceiveTime;
cmdParms[21].Value = model.MediclineReceivePlace;
cmdParms[22].Value = model.RecordcardWrite;
cmdParms[23].Value = model.PharmacyWayDeposit;
cmdParms[24].Value = model.Therapies;
cmdParms[25].Value = model.IndisciplineHarm;
cmdParms[26].Value = model.AdrsHandle;
cmdParms[27].Value = model.SubsequentVisit;
cmdParms[28].Value = model.InsistPharmacy;
cmdParms[29].Value = model.LivingHabit;
cmdParms[30].Value = model.ChecktouchPerson;
cmdParms[31].Value = model.NextVisitDate;
cmdParms[32].Value = model.CreatedBy;
cmdParms[33].Value = model.CreatedDate;
cmdParms[34].Value = model.LastUpdateBy;
cmdParms[35].Value = model.LastUpdateDate;
cmdParms[36].Value = model.IsDel;
cmdParms[37].Value = model.VisitDoctor;
cmdParms[38].Value = model.NextSmokeDayNum;
cmdParms[39].Value = model.NextDayDrinkVolume;
object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
/// <summary>
/// 肺结核
/// </summary>
/// <param name="IDCardNo"></param>
/// <param name="CheckDate"></param>
/// <param name="VersionNo"></param>
/// <param name="Model"></param>
public void SaveLunger(string IDCardNo, DateTime CheckDate, string VersionNo, RecordsBaseInfoModel Model)
{
try
{
// 取得第一次随访信息
ChronicLungerFirstVisitModel lungerFirstOldModel = LungerVisitBLL.GetFirstMaxModel(IDCardNo, VersionNo);
int outKey = 0;
if (lungerFirstOldModel == null)
{
// 新增第一次入户随访
ChronicLungerFirstVisitModel baseModel = new ChronicLungerFirstVisitModel()
{
IDCardNo = IDCardNo,
RecordID = Model.RecordID,
CustomerName = Model.CustomerName,
FollowupDate = CheckDate,
VisitDoctor = ConfigHelper.GetNode("doctorName"),
EstimateDoctor = ConfigHelper.GetNode("doctorName"),
NextVisitDate = CheckDate.AddMonths(3),
CreatedBy = ConfigHelper.GetNode("doctor"),
CreatedDate = DateTime.Now,
LastUpdateBy = ConfigHelper.GetNode("doctor"),
LastUpdateDate = DateTime.Now,
};
LungerVisitBLL.Add(baseModel, VersionNo);
}
else
{
#region 随访信息
// 获取最后一次随访数据
ChronicLungerVisitModel lungerVisitOldModel = LungerVisitBLL.GetMaxModel(IDCardNo, VersionNo);
ChronicLungerVisitModel lungerVisitNewModel = new ChronicLungerVisitModel();
if (lungerVisitOldModel == null)
{
outKey = lungerFirstOldModel.ID;
lungerVisitOldModel = new ChronicLungerVisitModel();
}
// 肺结核随访信息预设上次随访内容
lungerVisitNewModel = EntityAssignment <ChronicLungerVisitModel>(lungerVisitOldModel, lungerVisitNewModel);
lungerVisitNewModel.IDCardNo = IDCardNo;
lungerVisitNewModel.RecordID = Model.RecordID;
lungerVisitNewModel.CustomerName = StringPlus.toString(lungerVisitNewModel.CustomerName) == "" ? Model.CustomerName : lungerVisitNewModel.CustomerName;
lungerVisitNewModel.OutKey = lungerVisitNewModel.OutKey > 0 ? lungerVisitNewModel.OutKey : outKey;
lungerVisitNewModel.FollowupDate = CheckDate;
lungerVisitNewModel.VisitDoctor = ConfigHelper.GetNode("doctorName");
lungerVisitNewModel.EstimateDoctor = ConfigHelper.GetNode("doctorName");
lungerVisitNewModel.NextVisitDate = CheckDate.AddMonths(3);
lungerVisitNewModel.CreatedBy = ConfigHelper.GetNode("doctor");
lungerVisitNewModel.CreatedDate = DateTime.Now;
lungerVisitNewModel.LastUpdateBy = ConfigHelper.GetNode("doctor");
lungerVisitNewModel.LastUpdateDate = DateTime.Now;
if (VersionNo.Contains("3.0"))
{
lungerVisitNewModel.FollowupWay = lungerVisitNewModel.VisitWay;
}
LungerVisitBLL.Add(lungerVisitNewModel, VersionNo);
#endregion
}
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.ToString());
throw ex;
}
}
public int Add(ChronicLungerFirstVisitModel model)
{
return(this.dal.Add(model));
}
public bool Update(ChronicLungerFirstVisitModel model)
{
return(this.dal.Update(model));
}
public int Add(ChronicLungerFirstVisitModel model, string Version = "V2.0")
{
return(this.dal.Add(model, Version));
}
