public List <ChronicMentalDiseaseBaseInfoModel> DataTableToList(DataTable dt)
{
List <ChronicMentalDiseaseBaseInfoModel> list = new List <ChronicMentalDiseaseBaseInfoModel>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
ChronicMentalDiseaseBaseInfoModel item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
/// <summary>
/// 精神疾病
/// </summary>
/// <param name="IDCardNo"></param>
/// <param name="CheckDate"></param>
/// <param name="VersionNo"></param>
/// <param name="Model"></param>
public void SaveMental(string IDCardNo, DateTime CheckDate, string VersionNo, RecordsBaseInfoModel Model)
{
try
{
// 获取最后一次随访数据
ChronicMentalDiseaseVisitModel mentalOldModel = MentalDiseaseVisitBLL.GetMaxModel(IDCardNo, VersionNo);
if (mentalOldModel == null)
{
mentalOldModel = new ChronicMentalDiseaseVisitModel();
}
ChronicMentalDiseaseVisitModel mentalNewModel = new ChronicMentalDiseaseVisitModel();
#region 精神疾病基本信息
// 是否有基本信息
int count = MentalDiseaseBaseBLL.GetDataCount(IDCardNo);
if (count < 1)
{
// 新增精神疾病基本信息
ChronicMentalDiseaseBaseInfoModel baseModel = new ChronicMentalDiseaseBaseInfoModel()
{
IDCardNo = IDCardNo,
RecordID = Model.RecordID,
CreatedBy = ConfigHelper.GetNodeDec("doctor"),
CreatedDate = DateTime.Now,
LastUpdateBy = ConfigHelper.GetNodeDec("doctor"),
LastUpDateDate = DateTime.Now
};
MentalDiseaseBaseBLL.Add(baseModel);
}
#endregion
#region 随访信息
mentalNewModel = EntityAssignment <ChronicMentalDiseaseVisitModel>(mentalOldModel, mentalNewModel);
mentalNewModel.IDCardNo = IDCardNo;
mentalNewModel.RecordID = Model.RecordID;
mentalNewModel.FollowUpDate = CheckDate;
mentalNewModel.NextFollowUpDate = CheckDate.AddMonths(3);
mentalNewModel.FollowUpDoctor = ConfigHelper.GetNode("doctorName");
mentalNewModel.CreatedBy = ConfigHelper.GetNodeDec("doctor");
mentalNewModel.CreatedDate = DateTime.Now;
mentalNewModel.LastUpdateBy = ConfigHelper.GetNodeDec("doctor");
mentalNewModel.LastUpdateDate = DateTime.Now;
#endregion
#region 保存默认值
if (VersionNo.Contains("3.0"))
{
mentalNewModel.FollowUpType = mentalNewModel.VisitType;
}
// 随访信息存档
int id = MentalDiseaseVisitBLL.Add(mentalNewModel, VersionNo);
#endregion
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.ToString());
throw ex;
}
}
public int AddServer(ChronicMentalDiseaseBaseInfoModel model)
{
return(this.dal.AddServer(model));
}
public bool UpdateServer(ChronicMentalDiseaseBaseInfoModel model)
{
return(this.dal.UpdateServer(model));
}
public bool UpdateServer(ChronicMentalDiseaseBaseInfoModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update CD_MENTALDISEASE_BASEINFO set ");
builder.Append("CustomerID=@CustomerID,");
builder.Append("RecordID=@RecordID,");
builder.Append("IDCardNo=@IDCardNo,");
builder.Append("GuardianRecordID=@GuardianRecordID,");
builder.Append("GuardianName=@GuardianName,");
builder.Append("Ralation=@Ralation,");
builder.Append("GuradianAddr=@GuradianAddr,");
builder.Append("GuradianPhone=@GuradianPhone,");
builder.Append("FirstTime=@FirstTime,");
builder.Append("AgreeManagement=@AgreeManagement,");
builder.Append("AgreeSignature=@AgreeSignature,");
builder.Append("AgreeTime=@AgreeTime,");
builder.Append("Symptom=@Symptom,");
builder.Append("SymptomOther=@SymptomOther,");
builder.Append("OutPatien=@OutPatien,");
builder.Append("HospitalCount=@HospitalCount,");
builder.Append("DiagnosisInfo=@DiagnosisInfo,");
builder.Append("DiagnosisHospital=@DiagnosisHospital,");
builder.Append("DiagnosisTime=@DiagnosisTime,");
builder.Append("LastCure=@LastCure,");
builder.Append("VillageContacts=@VillageContacts,");
builder.Append("VillageTel=@VillageTel,");
builder.Append("LockInfo=@LockInfo,");
builder.Append("Economy=@Economy,");
builder.Append("SpecialistProposal=@SpecialistProposal,");
builder.Append("FillformTime=@FillformTime,");
builder.Append("DoctorMark=@DoctorMark,");
builder.Append("CreatedBy=@CreatedBy,");
builder.Append("CreatedDate=@CreatedDate,");
builder.Append("LastUpdateBy=@LastUpdateBy,");
builder.Append("LastUpDateDate=@LastUpDateDate,");
builder.Append("CreateUnit=@CreateUnit,");
builder.Append("CurrentUnit=@CurrentUnit,");
builder.Append("IsDel=@IsDel,");
builder.Append("FirstTreatmenTTime=@FirstTreatmenTTime,");
builder.Append("MildTroubleFrequen=@MildTroubleFrequen,");
builder.Append("CreateDistuFrequen=@CreateDistuFrequen,");
builder.Append("CauseAccidFrequen=@CauseAccidFrequen,");
builder.Append("AutolesionFrequen=@AutolesionFrequen,");
builder.Append("AttemptSuicFrequen=@AttemptSuicFrequen,");
builder.Append("AttemptSuicideNone=@AttemptSuicideNone, ");
builder.Append("Professional=@Professional,");
builder.Append("OtherDangerFrequen=@OtherDangerFrequen, ");
builder.Append("HouseType=@HouseType ");
builder.Append(" where ID=@ID");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@CustomerID", MySqlDbType.String, 32),
new MySqlParameter("@RecordID", MySqlDbType.String, 17),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@GuardianRecordID", MySqlDbType.String, 17),
new MySqlParameter("@GuardianName", MySqlDbType.String, 30),
new MySqlParameter("@Ralation", MySqlDbType.String, 1),
new MySqlParameter("@GuradianAddr", MySqlDbType.String, 200),
new MySqlParameter("@GuradianPhone", MySqlDbType.String, 15),
new MySqlParameter("@FirstTime", MySqlDbType.Date),
new MySqlParameter("@AgreeManagement", MySqlDbType.String, 1),
new MySqlParameter("@AgreeSignature", MySqlDbType.String, 30),
new MySqlParameter("@AgreeTime", MySqlDbType.Date),
new MySqlParameter("@Symptom", MySqlDbType.String, 50),
new MySqlParameter("@SymptomOther", MySqlDbType.String, 200),
new MySqlParameter("@OutPatien", MySqlDbType.String, 1),
new MySqlParameter("@HospitalCount", MySqlDbType.Int32),
new MySqlParameter("@DiagnosisInfo", MySqlDbType.String, 500),
new MySqlParameter("@DiagnosisHospital", MySqlDbType.String, 200),
new MySqlParameter("@DiagnosisTime", MySqlDbType.Date),
new MySqlParameter("@LastCure", MySqlDbType.String, 1),
new MySqlParameter("@VillageContacts", MySqlDbType.String, 30),
new MySqlParameter("@VillageTel", MySqlDbType.String, 15),
new MySqlParameter("@LockInfo", MySqlDbType.String, 1),
new MySqlParameter("@Economy", MySqlDbType.String, 1),
new MySqlParameter("@SpecialistProposal", MySqlDbType.String, 500),
new MySqlParameter("@FillformTime", MySqlDbType.Date),
new MySqlParameter("@DoctorMark", MySqlDbType.String, 30),
new MySqlParameter("@CreatedBy", MySqlDbType.Decimal),
new MySqlParameter("@CreatedDate", MySqlDbType.Date),
new MySqlParameter("@LastUpdateBy", MySqlDbType.Decimal),
new MySqlParameter("@LastUpDateDate", MySqlDbType.Date),
new MySqlParameter("@CreateUnit", MySqlDbType.Decimal),
new MySqlParameter("@CurrentUnit", MySqlDbType.Decimal),
new MySqlParameter("@IsDel", MySqlDbType.String, 1),
new MySqlParameter("@FirstTreatmenTTime", MySqlDbType.Date),
new MySqlParameter("@MildTroubleFrequen", MySqlDbType.Int32),
new MySqlParameter("@CreateDistuFrequen", MySqlDbType.Int32),
new MySqlParameter("@CauseAccidFrequen", MySqlDbType.Int32),
new MySqlParameter("@AutolesionFrequen", MySqlDbType.Int32),
new MySqlParameter("@AttemptSuicFrequen", MySqlDbType.Int32),
new MySqlParameter("@AttemptSuicideNone", MySqlDbType.String, 2),
new MySqlParameter("@Professional", MySqlDbType.String, 1),
new MySqlParameter("@OtherDangerFrequen", MySqlDbType.Decimal),
new MySqlParameter("@HouseType", MySqlDbType.String, 1),
new MySqlParameter("@ID", MySqlDbType.Int32, 8)
};
cmdParms[0].Value = model.CustomerID;
cmdParms[1].Value = model.RecordID;
cmdParms[2].Value = model.IDCardNo;
cmdParms[3].Value = model.GuardianRecordID;
cmdParms[4].Value = model.GuardianName;
cmdParms[5].Value = model.Ralation;
cmdParms[6].Value = model.GuradianAddr;
cmdParms[7].Value = model.GuradianPhone;
cmdParms[8].Value = model.FirstTime;
cmdParms[9].Value = model.AgreeManagement;
cmdParms[10].Value = model.AgreeSignature;
cmdParms[11].Value = model.AgreeTime;
cmdParms[12].Value = model.Symptom;
cmdParms[13].Value = model.SymptomOther;
cmdParms[14].Value = model.OutPatien;
cmdParms[15].Value = model.HospitalCount;
cmdParms[16].Value = model.DiagnosisInfo;
cmdParms[17].Value = model.DiagnosisHospital;
cmdParms[18].Value = model.DiagnosisTime;
cmdParms[19].Value = model.LastCure;
cmdParms[20].Value = model.VillageContacts;
cmdParms[21].Value = model.VillageTel;
cmdParms[22].Value = model.LockInfo;
cmdParms[23].Value = model.Economy;
cmdParms[24].Value = model.SpecialistProposal;
cmdParms[25].Value = model.FillformTime;
cmdParms[26].Value = model.DoctorMark;
cmdParms[27].Value = model.CreatedBy;
cmdParms[28].Value = model.CreatedDate;
cmdParms[29].Value = model.LastUpdateBy;
cmdParms[30].Value = model.LastUpDateDate;
cmdParms[31].Value = model.CreateUnit;
cmdParms[32].Value = model.CurrentUnit;
cmdParms[33].Value = model.IsDel;
cmdParms[34].Value = model.FirstTreatmenTTime;
cmdParms[35].Value = model.MildTroubleFrequen;
cmdParms[36].Value = model.CreateDistuFrequen;
cmdParms[37].Value = model.CauseAccidFrequen;
cmdParms[38].Value = model.AutolesionFrequen;
cmdParms[39].Value = model.AttemptSuicFrequen;
cmdParms[40].Value = model.AttemptSuicideNone;
cmdParms[41].Value = model.Professional;
cmdParms[42].Value = model.OtherDangerFrequen;
cmdParms[43].Value = model.HouseType;
cmdParms[44].Value = model.ID;
return(MySQLHelper.ExecuteSqlServer(builder.ToString(), cmdParms) > 0);
}
public ChronicMentalDiseaseBaseInfoModel DataRowToModel(DataRow row)
{
ChronicMentalDiseaseBaseInfoModel chronicMentalDiseaseBaseInfoModel = new ChronicMentalDiseaseBaseInfoModel();
if (row != null)
{
if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.ID = int.Parse(row["ID"].ToString());
}
if ((row["CustomerID"] != null) && (row["CustomerID"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.CustomerID = row["CustomerID"].ToString();
}
if ((row["RecordID"] != null) && (row["RecordID"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.RecordID = row["RecordID"].ToString();
}
if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.IDCardNo = row["IDCardNo"].ToString();
}
if ((row["GuardianRecordID"] != null) && (row["GuardianRecordID"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.GuardianRecordID = row["GuardianRecordID"].ToString();
}
if ((row["GuardianName"] != null) && (row["GuardianName"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.GuardianName = row["GuardianName"].ToString();
}
if ((row["Ralation"] != null) && (row["Ralation"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.Ralation = row["Ralation"].ToString();
}
if ((row["GuradianAddr"] != null) && (row["GuradianAddr"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.GuradianAddr = row["GuradianAddr"].ToString();
}
if ((row["GuradianPhone"] != null) && (row["GuradianPhone"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.GuradianPhone = row["GuradianPhone"].ToString();
}
if (((row["FirstTime"] != null) && (row["FirstTime"] != DBNull.Value)) && (row["FirstTime"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.FirstTime = new DateTime?(DateTime.Parse(row["FirstTime"].ToString()));
}
if ((row["AgreeManagement"] != null) && (row["AgreeManagement"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.AgreeManagement = row["AgreeManagement"].ToString();
}
if ((row["AgreeSignature"] != null) && (row["AgreeSignature"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.AgreeSignature = row["AgreeSignature"].ToString();
}
if (((row["AgreeTime"] != null) && (row["AgreeTime"] != DBNull.Value)) && (row["AgreeTime"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.AgreeTime = new DateTime?(DateTime.Parse(row["AgreeTime"].ToString()));
}
if ((row["Symptom"] != null) && (row["Symptom"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.Symptom = row["Symptom"].ToString();
}
if ((row["SymptomOther"] != null) && (row["SymptomOther"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.SymptomOther = row["SymptomOther"].ToString();
}
if ((row["OutPatien"] != null) && (row["OutPatien"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.OutPatien = row["OutPatien"].ToString();
}
if (((row["HospitalCount"] != null) && (row["HospitalCount"] != DBNull.Value)) && (row["HospitalCount"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.HospitalCount = int.Parse(row["HospitalCount"].ToString());
}
if ((row["DiagnosisInfo"] != null) && (row["DiagnosisInfo"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.DiagnosisInfo = row["DiagnosisInfo"].ToString();
}
if ((row["DiagnosisHospital"] != null) && (row["DiagnosisHospital"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.DiagnosisHospital = row["DiagnosisHospital"].ToString();
}
if (((row["DiagnosisTime"] != null) && (row["DiagnosisTime"] != DBNull.Value)) && (row["DiagnosisTime"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.DiagnosisTime = new DateTime?(DateTime.Parse(row["DiagnosisTime"].ToString()));
}
if ((row["LastCure"] != null) && (row["LastCure"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.LastCure = row["LastCure"].ToString();
}
if ((row["VillageContacts"] != null) && (row["VillageContacts"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.VillageContacts = row["VillageContacts"].ToString();
}
if ((row["VillageTel"] != null) && (row["VillageTel"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.VillageTel = row["VillageTel"].ToString();
}
if ((row["LockInfo"] != null) && (row["LockInfo"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.LockInfo = row["LockInfo"].ToString();
}
if ((row["Economy"] != null) && (row["Economy"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.Economy = row["Economy"].ToString();
}
if ((row["SpecialistProposal"] != null) && (row["SpecialistProposal"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.SpecialistProposal = row["SpecialistProposal"].ToString();
}
if (((row["FillformTime"] != null) && (row["FillformTime"] != DBNull.Value)) && (row["FillformTime"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.FillformTime = new DateTime?(DateTime.Parse(row["FillformTime"].ToString()));
}
if ((row["DoctorMark"] != null) && (row["DoctorMark"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.DoctorMark = row["DoctorMark"].ToString();
}
if (((row["CreatedBy"] != null) && (row["CreatedBy"] != DBNull.Value)) && (row["CreatedBy"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.CreatedBy = new decimal?(decimal.Parse(row["CreatedBy"].ToString()));
}
if (((row["CreatedDate"] != null) && (row["CreatedDate"] != DBNull.Value)) && (row["CreatedDate"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.CreatedDate = new DateTime?(DateTime.Parse(row["CreatedDate"].ToString()));
}
if (((row["LastUpdateBy"] != null) && (row["LastUpdateBy"] != DBNull.Value)) && (row["LastUpdateBy"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.LastUpdateBy = new decimal?(decimal.Parse(row["LastUpdateBy"].ToString()));
}
if (((row["LastUpDateDate"] != null) && (row["LastUpDateDate"] != DBNull.Value)) && (row["LastUpDateDate"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.LastUpDateDate = new DateTime?(DateTime.Parse(row["LastUpDateDate"].ToString()));
}
if (((row["CreateUnit"] != null) && (row["CreateUnit"] != DBNull.Value)) && (row["CreateUnit"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.CreateUnit = new decimal?(decimal.Parse(row["CreateUnit"].ToString()));
}
if (((row["CurrentUnit"] != null) && (row["CurrentUnit"] != DBNull.Value)) && (row["CurrentUnit"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.CurrentUnit = new decimal?(decimal.Parse(row["CurrentUnit"].ToString()));
}
if ((row["IsDel"] != null) && (row["IsDel"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.IsDel = row["IsDel"].ToString();
}
if (((row["FirstTreatmenTTime"] != null) && (row["FirstTreatmenTTime"] != DBNull.Value)) && (row["FirstTreatmenTTime"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.FirstTreatmenTTime = new DateTime?(DateTime.Parse(row["FirstTreatmenTTime"].ToString()));
}
if (((row["MildTroubleFrequen"] != null) && (row["MildTroubleFrequen"] != DBNull.Value)) && (row["MildTroubleFrequen"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.MildTroubleFrequen = int.Parse(row["MildTroubleFrequen"].ToString());
}
if (((row["CreateDistuFrequen"] != null) && (row["CreateDistuFrequen"] != DBNull.Value)) && (row["CreateDistuFrequen"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.CreateDistuFrequen = int.Parse(row["CreateDistuFrequen"].ToString());
}
if (((row["CauseAccidFrequen"] != null) && (row["CauseAccidFrequen"] != DBNull.Value)) && (row["CauseAccidFrequen"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.CauseAccidFrequen = int.Parse(row["CauseAccidFrequen"].ToString());
}
if (((row["AutolesionFrequen"] != null) && (row["AutolesionFrequen"] != DBNull.Value)) && (row["AutolesionFrequen"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.AutolesionFrequen = int.Parse(row["AutolesionFrequen"].ToString());
}
if (((row["AttemptSuicFrequen"] != null) && (row["AttemptSuicFrequen"] != DBNull.Value)) && (row["AttemptSuicFrequen"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.AttemptSuicFrequen = int.Parse(row["AttemptSuicFrequen"].ToString());
}
if ((row["AttemptSuicideNone"] != null) && (row["AttemptSuicideNone"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.AttemptSuicideNone = row["AttemptSuicideNone"].ToString();
}
if ((row["Professional"] != null) && (row["Professional"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.Professional = row["Professional"].ToString();
}
if ((row["HouseType"] != null) && (row["HouseType"] != DBNull.Value))
{
chronicMentalDiseaseBaseInfoModel.HouseType = row["HouseType"].ToString();
}
if (((row["OtherDangerFrequen"] != null) && (row["OtherDangerFrequen"] != DBNull.Value)) && (row["OtherDangerFrequen"].ToString() != ""))
{
chronicMentalDiseaseBaseInfoModel.OtherDangerFrequen = int.Parse(row["OtherDangerFrequen"].ToString());
}
}
return(chronicMentalDiseaseBaseInfoModel);
}
public int AddServer(ChronicMentalDiseaseBaseInfoModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into CD_MENTALDISEASE_BASEINFO(");
builder.Append("CustomerID,RecordID,IDCardNo,GuardianRecordID,GuardianName,Ralation,GuradianAddr,");
builder.Append("GuradianPhone,FirstTime,AgreeManagement,AgreeSignature,AgreeTime,Symptom,SymptomOther,OutPatien,");
builder.Append("HospitalCount,DiagnosisInfo,DiagnosisHospital,DiagnosisTime,LastCure,VillageContacts,VillageTel,");
builder.Append("LockInfo,Economy,SpecialistProposal,FillformTime,DoctorMark,CreatedBy,CreatedDate,LastUpdateBy,");
builder.Append("LastUpDateDate,CreateUnit,CurrentUnit,IsDel,FirstTreatmenTTime,MildTroubleFrequen,CreateDistuFrequen,");
builder.Append("CauseAccidFrequen,AutolesionFrequen,AttemptSuicFrequen,AttemptSuicideNone,Professional,OtherDangerFrequen,HouseType)");
builder.Append(" values (");
builder.Append("@CustomerID,@RecordID,@IDCardNo,@GuardianRecordID,@GuardianName,@Ralation,@GuradianAddr,@GuradianPhone,");
builder.Append("@FirstTime,@AgreeManagement,@AgreeSignature,@AgreeTime,@Symptom,@SymptomOther,@OutPatien,@HospitalCount,");
builder.Append("@DiagnosisInfo,@DiagnosisHospital,@DiagnosisTime,@LastCure,@VillageContacts,@VillageTel,@LockInfo,@Economy,");
builder.Append("@SpecialistProposal,@FillformTime,@DoctorMark,@CreatedBy,@CreatedDate,@LastUpdateBy,@LastUpDateDate,");
builder.Append("@CreateUnit,@CurrentUnit,@IsDel,@FirstTreatmenTTime,@MildTroubleFrequen,@CreateDistuFrequen,");
builder.Append("@CauseAccidFrequen,@AutolesionFrequen,@AttemptSuicFrequen,@AttemptSuicideNone,@Professional,@OtherDangerFrequen,@HouseType)");
builder.Append(";select @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@CustomerID", MySqlDbType.String, 32),
new MySqlParameter("@RecordID", MySqlDbType.String, 17),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@GuardianRecordID", MySqlDbType.String, 17),
new MySqlParameter("@GuardianName", MySqlDbType.String, 30),
new MySqlParameter("@Ralation", MySqlDbType.String, 1),
new MySqlParameter("@GuradianAddr", MySqlDbType.String, 200),
new MySqlParameter("@GuradianPhone", MySqlDbType.String, 15),
new MySqlParameter("@FirstTime", MySqlDbType.Date),
new MySqlParameter("@AgreeManagement", MySqlDbType.String, 1),
new MySqlParameter("@AgreeSignature", MySqlDbType.String, 30),
new MySqlParameter("@AgreeTime", MySqlDbType.Date),
new MySqlParameter("@Symptom", MySqlDbType.String, 50),
new MySqlParameter("@SymptomOther", MySqlDbType.String, 200),
new MySqlParameter("@OutPatien", MySqlDbType.String, 1),
new MySqlParameter("@HospitalCount", MySqlDbType.Int32),
new MySqlParameter("@DiagnosisInfo", MySqlDbType.String, 500),
new MySqlParameter("@DiagnosisHospital", MySqlDbType.String, 200),
new MySqlParameter("@DiagnosisTime", MySqlDbType.Date),
new MySqlParameter("@LastCure", MySqlDbType.String, 1),
new MySqlParameter("@VillageContacts", MySqlDbType.String, 30),
new MySqlParameter("@VillageTel", MySqlDbType.String, 15),
new MySqlParameter("@LockInfo", MySqlDbType.String, 1),
new MySqlParameter("@Economy", MySqlDbType.String, 1),
new MySqlParameter("@SpecialistProposal", MySqlDbType.String, 500),
new MySqlParameter("@FillformTime", MySqlDbType.Date),
new MySqlParameter("@DoctorMark", MySqlDbType.String, 30),
new MySqlParameter("@CreatedBy", MySqlDbType.Decimal),
new MySqlParameter("@CreatedDate", MySqlDbType.Date),
new MySqlParameter("@LastUpdateBy", MySqlDbType.Decimal),
new MySqlParameter("@LastUpDateDate", MySqlDbType.Date),
new MySqlParameter("@CreateUnit", MySqlDbType.Decimal),
new MySqlParameter("@CurrentUnit", MySqlDbType.Decimal),
new MySqlParameter("@IsDel", MySqlDbType.String, 1),
new MySqlParameter("@FirstTreatmenTTime", MySqlDbType.Date),
new MySqlParameter("@MildTroubleFrequen", MySqlDbType.Int32),
new MySqlParameter("@CreateDistuFrequen", MySqlDbType.Int32),
new MySqlParameter("@CauseAccidFrequen", MySqlDbType.Int32),
new MySqlParameter("@AutolesionFrequen", MySqlDbType.Int32),
new MySqlParameter("@AttemptSuicFrequen", MySqlDbType.Int32),
new MySqlParameter("@AttemptSuicideNone", MySqlDbType.String, 2),
new MySqlParameter("@Professional", MySqlDbType.String, 1),
new MySqlParameter("@OtherDangerFrequen", MySqlDbType.Decimal),
new MySqlParameter("@HouseType", MySqlDbType.String, 1)
};
cmdParms[0].Value = model.CustomerID;
cmdParms[1].Value = model.RecordID;
cmdParms[2].Value = model.IDCardNo;
cmdParms[3].Value = model.GuardianRecordID;
cmdParms[4].Value = model.GuardianName;
cmdParms[5].Value = model.Ralation;
cmdParms[6].Value = model.GuradianAddr;
cmdParms[7].Value = model.GuradianPhone;
cmdParms[8].Value = model.FirstTime;
cmdParms[9].Value = model.AgreeManagement;
cmdParms[10].Value = model.AgreeSignature;
cmdParms[11].Value = model.AgreeTime;
cmdParms[12].Value = model.Symptom;
cmdParms[13].Value = model.SymptomOther;
cmdParms[14].Value = model.OutPatien;
cmdParms[15].Value = model.HospitalCount;
cmdParms[16].Value = model.DiagnosisInfo;
cmdParms[17].Value = model.DiagnosisHospital;
cmdParms[18].Value = model.DiagnosisTime;
cmdParms[19].Value = model.LastCure;
cmdParms[20].Value = model.VillageContacts;
cmdParms[21].Value = model.VillageTel;
cmdParms[22].Value = model.LockInfo;
cmdParms[23].Value = model.Economy;
cmdParms[24].Value = model.SpecialistProposal;
cmdParms[25].Value = model.FillformTime;
cmdParms[26].Value = model.DoctorMark;
cmdParms[27].Value = model.CreatedBy;
cmdParms[28].Value = model.CreatedDate;
cmdParms[29].Value = model.LastUpdateBy;
cmdParms[30].Value = model.LastUpDateDate;
cmdParms[31].Value = model.CreateUnit;
cmdParms[32].Value = model.CurrentUnit;
cmdParms[33].Value = model.IsDel;
cmdParms[34].Value = model.FirstTreatmenTTime;
cmdParms[35].Value = model.MildTroubleFrequen;
cmdParms[36].Value = model.CreateDistuFrequen;
cmdParms[37].Value = model.CauseAccidFrequen;
cmdParms[38].Value = model.AutolesionFrequen;
cmdParms[39].Value = model.AttemptSuicFrequen;
cmdParms[40].Value = model.AttemptSuicideNone;
cmdParms[41].Value = model.Professional;
cmdParms[42].Value = model.OtherDangerFrequen;
cmdParms[43].Value = model.HouseType;
object single = MySQLHelper.GetSingleServer(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
public FixedDocumentSequence getReport()
{
List <ListValue> list = null;
if (!string.IsNullOrEmpty(this.CardID))
{
RecordsBaseInfoModel model = new RecordsBaseInfoBLL().GetModel(this.CardID);
list = new List <ListValue>
{
new ListValue
{
strMark = "$archiveid",
strVal = model.RecordID
},
new ListValue
{
strMark = "$name",
strVal = model.CustomerName
}
};
ChronicMentalDiseaseBaseInfoModel model2 = new ChronicMentalDiseaseBaseInfoModel();
model2 = new ChronicMentalDiseaseBaseInfoBLL().GetModel(this.CardID);
if (model2 != null)
{
list.Add(new ListValue
{
strMark = "#gsqk",
strVal = model2.LockInfo
});
list.Add(new ListValue
{
strMark = "%zjzl",
strVal = model2.SpecialistProposal
});
list.Add(new ListValue
{
strMark = "$tbrq",
strVal = DrawItems.strToDate(model2.FillformTime)
});
list.Add(new ListValue
{
strMark = "$sczlsj",
strVal = DrawItems.strToDate(model2.FirstTreatmenTTime)
});
list.Add(new ListValue
{
strMark = "$qdzs",
strVal = DrawItems.objToNumStr(model2.MildTroubleFrequen, 0)
});
list.Add(new ListValue
{
strMark = "$zs",
strVal = DrawItems.objToNumStr(model2.CreateDistuFrequen, 0)
});
list.Add(new ListValue
{
strMark = "$zh",
strVal = DrawItems.objToNumStr(model2.CauseAccidFrequen, 0)
});
list.Add(new ListValue
{
strMark = "$qtwx",
strVal = DrawItems.objToNumStr(model2.OtherDangerFrequen, 0)
});
list.Add(new ListValue
{
strMark = "$zsh",
strVal = DrawItems.objToNumStr(model2.AutolesionFrequen, 0)
});
list.Add(new ListValue
{
strMark = "$zsws",
strVal = DrawItems.objToNumStr(model2.AttemptSuicFrequen, 0)
});
//list.Add(new ListValue
//{
// strMark = "@hbyxw",
// strVal = (model2.AttemptSuicideNone != "有") ? "1" : ""
//});
list.Add(new ListValue
{
strMark = "$jhrxm",
strVal = model2.GuardianName
});
string strhzgx = "";
switch (Convert.ToInt32(model2.Ralation))
{
case 1:
strhzgx = "户主";
break;
case 2:
strhzgx = "配偶";
break;
case 3:
strhzgx = "父亲";
break;
case 4:
strhzgx = "母亲";
break;
case 5:
strhzgx = "兄弟";
break;
case 6:
strhzgx = "姐妹";
break;
case 7:
strhzgx = "儿子";
break;
case 8:
strhzgx = "女儿";
break;
case 9:
strhzgx = "儿媳";
break;
case 10:
strhzgx = "女婿";
break;
case 11:
strhzgx = "孙子";
break;
case 12:
strhzgx = "孙女";
break;
case 13:
strhzgx = "外孙";
break;
case 14:
strhzgx = "外孙女";
break;
case 15:
strhzgx = "其他";
break;
default: break;
}
list.Add(new ListValue
{
strMark = "$hzgx",
strVal = strhzgx
});
list.Add(new ListValue
{
strMark = "$jhzz",
strVal = model2.GuradianAddr
});
list.Add(new ListValue
{
strMark = "$jhdh",
strVal = model2.GuradianPhone
});
list.Add(new ListValue
{
strMark = "$ccfb",
strVal = DrawItems.strToDate(model2.FirstTime)
});
list.Add(new ListValue
{
strMark = "#zqty",
strVal = model2.AgreeManagement
});
list.Add(new ListValue
{
strMark = "$zqqz",
strVal = model2.AgreeSignature
});
list.Add(new ListValue
{
strMark = "$qzsj",
strVal = DrawItems.strToDate(model2.AgreeTime)
});
list.Add(new ListValue
{
strMark = "#zz",
strVal = model2.Symptom
});
list.Add(new ListValue
{
strMark = "$zzqt",
strVal = model2.SymptomOther
});
list.Add(new ListValue
{
strMark = "#jwmz",
strVal = model2.OutPatien
});
list.Add(new ListValue
{
strMark = "$zycs",
strVal = DrawItems.objToNumStr(model2.HospitalCount, 0)
});
list.Add(new ListValue
{
strMark = "$mqzd",
strVal = model2.DiagnosisInfo
});
list.Add(new ListValue
{
strMark = "$qzyy",
strVal = model2.DiagnosisHospital
});
list.Add(new ListValue
{
strMark = "$qzrq",
strVal = DrawItems.strToDate(model2.DiagnosisTime)
});
list.Add(new ListValue
{
strMark = "#zjzl",
strVal = model2.LastCure
});
list.Add(new ListValue
{
strMark = "$lxr",
strVal = model2.VillageContacts + " / " + model2.VillageTel
});
list.Add(new ListValue
{
strMark = "#jjzk",
strVal = model2.Economy
});
list.Add(new ListValue
{
strMark = "#hzzy",
strVal = model2.Professional
});
list.Add(new ListValue
{
strMark = "#hb",
strVal = model2.HouseType
});
string strwxxw = "";
if (!string.IsNullOrEmpty(model2.AttemptSuicFrequen.ToString()) && model2.MildTroubleFrequen != 0)
{
strwxxw += "1,";
}
if (!string.IsNullOrEmpty(model2.CreateDistuFrequen.ToString()) && model2.CreateDistuFrequen != 0)
{
strwxxw += "2,";
}
if (!string.IsNullOrEmpty(model2.CauseAccidFrequen.ToString()) && model2.CauseAccidFrequen != 0)
{
strwxxw += "3,";
}
if (!string.IsNullOrEmpty(model2.AttemptSuicideNone.ToString()) && model2.OtherDangerFrequen != 0)
{
strwxxw += "4,";
}
if (!string.IsNullOrEmpty(model2.AutolesionFrequen.ToString()) && model2.AutolesionFrequen != 0)
{
strwxxw += "5,";
}
if (!string.IsNullOrEmpty(model2.AttemptSuicFrequen.ToString()) && model2.AttemptSuicFrequen != 0)
{
strwxxw += "6,";
}
list.Add(new ListValue
{
strMark = "#wxxw",
strVal = string.IsNullOrEmpty(strwxxw) ? "7" : strwxxw.Substring(0, strwxxw.Length - 1)
});
list.Add(new ListValue
{
strMark = "&qm",
strVal = string.Format("{0}{1}_{2}.png", SignPath, model2.IDCardNo, "BaseInfo")
});
list.Add(new ListValue
{
strMark = "&ysqz",
strVal = string.Format("{0}{1}_{2}_Doc.png", SignPath, model2.IDCardNo, "BaseInfo")
});
//滕州无签字版
list.Add(new ListValue
{
strMark = "$qm",
strVal = model.CustomerName
});
list.Add(new ListValue
{
strMark = "$ysqz",
strVal = model2.DoctorMark
});
}
}
return(DrawItems.setPage("printXps\\07重性精神疾病患者个人信息补充表.xps", list));
}
