public string GetDataByDateTime(string dateBegin, string dateEnd)
{
string result = "";
List<Dictionary<string, string>> listDic = new List<Dictionary<string, string>>();
listDic = GetOPInfoListForSpecimenByTimeRangeAndToDicList(dateBegin, dateEnd);
List<RuRo.Model.ZSSY.OPListForSpecimen> list = new List<RuRo.Model.ZSSY.OPListForSpecimen>();
if (listDic.Count > 0)
{
//result = ConvertDicListToJsonStr(listDic);
foreach (var item in listDic)
{
RuRo.Model.ZSSY.OPListForSpecimen model = new RuRo.Model.ZSSY.OPListForSpecimen();
RuRo.Common.ObjAndDic.DicToObject(item, model);
if (model.KeepSpecimenSign=="N")
{
model.KeepSpecimenSign = "";
}
list.Add(model);
}
list = list.OrderByDescending(a => a.KeepSpecimenSign).ToList();
result = Newtonsoft.Json.JsonConvert.SerializeObject(list);
}
return result;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public RuRo.Model.ZSSY.OPListForSpecimen GetModel(int Id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 Id,PatientId,InpNO,VisitId,Name,NamePhonetic,Sex,DateOfBirth,BirthPlace,Citizenship,Nation,IDNO,Identity,ChargeType,MailingAddress,ZipCode,PhoneNumberHome,PhoneNumbeBusiness,NextOfKin,RelationShip,NextOfKinAddr,NextOfKinZipCode,NextOfKinPhome,DeptCode,BedNO,AdmissionDateTime,DoctorInCharge,ScheduleId,DiagBeforeOperation,ScheduledDateTime,KeepSpecimenSign,OperatingRoom,Surgeon,InPatPreillness,InPatPastillness,InPatFamillness,LabInfo from OPListForSpecimen ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.Int,4)
};
parameters[0].Value = Id;
RuRo.Model.ZSSY.OPListForSpecimen model=new RuRo.Model.ZSSY.OPListForSpecimen();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr="";
if(this.txtPatientId.Text.Trim().Length==0)
{
strErr+="病人唯一标识号不能为空！\\n";
}
#region 非空判断
//if(this.txtInpNO.Text.Trim().Length==0)
//{
// strErr+="住院号不能为空！\\n";
//}
//if(this.txtVisitId.Text.Trim().Length==0)
//{
// strErr+="就诊号不能为空！\\n";
//}
//if(this.txtName.Text.Trim().Length==0)
//{
// strErr+="姓名不能为空！\\n";
//}
//if(this.txtNamePhonetic.Text.Trim().Length==0)
//{
// strErr+="姓名拼音不能为空！\\n";
//}
//if(this.txtSex.Text.Trim().Length==0)
//{
// strErr+="性别不能为空！\\n";
//}
//if(this.txtDateOfBirth.Text.Trim().Length==0)
//{
// strErr+="出生日期不能为空！\\n";
//}
//if(this.txtBirthPlace.Text.Trim().Length==0)
//{
// strErr+="行政区名称不能为空！\\n";
//}
//if(this.txtCitizenship.Text.Trim().Length==0)
//{
// strErr+="国家简称不能为空！\\n";
//}
//if(this.txtNation.Text.Trim().Length==0)
//{
// strErr+="民族不能为空！\\n";
//}
//if(this.txtIDNO.Text.Trim().Length==0)
//{
// strErr+="身份证号不能为空！\\n";
//}
//if(this.txtIdentity.Text.Trim().Length==0)
//{
// strErr+="患者工作身份不能为空！\\n";
//}
//if(this.txtChargeType.Text.Trim().Length==0)
//{
// strErr+="病人收费类别不能为空！\\n";
//}
//if(this.txtMailingAddress.Text.Trim().Length==0)
//{
// strErr+="永久通信地址不能为空！\\n";
//}
//if(this.txtZipCode.Text.Trim().Length==0)
//{
// strErr+="邮政编码不能为空！\\n";
//}
//if(this.txtPhoneNumberHome.Text.Trim().Length==0)
//{
// strErr+="家庭电话号码不能为空！\\n";
//}
//if(this.txtPhoneNumbeBusiness.Text.Trim().Length==0)
//{
// strErr+="单位电话号码不能为空！\\n";
//}
//if(this.txtNextOfKin.Text.Trim().Length==0)
//{
// strErr+="亲属姓名不能为空！\\n";
//}
//if(this.txtRelationShip.Text.Trim().Length==0)
//{
// strErr+="亲属关系不能为空！\\n";
//}
//if(this.txtNextOfKinAddr.Text.Trim().Length==0)
//{
// strErr+="联系人地址不能为空！\\n";
//}
//if(this.txtNextOfKinZipCode.Text.Trim().Length==0)
//{
// strErr+="联系人邮政编码不能为空！\\n";
//}
//if(this.txtNextOfKinPhome.Text.Trim().Length==0)
//{
// strErr+="联系人电话号码不能为空！\\n";
//}
//if(this.txtDeptCode.Text.Trim().Length==0)
//{
// strErr+="当前科室代码@名称不能为空！\\n";
//}
//if(this.txtBedNO.Text.Trim().Length==0)
//{
// strErr+="病人所住床号不能为空！\\n";
//}
//if(this.txtAdmissionDateTime.Text.Trim().Length==0)
//{
// strErr+="入院日期及时间不能为空！\\n";
//}
//if(this.txtDoctorInCharge.Text.Trim().Length==0)
//{
// strErr+="主治医生工号@姓名不能为空！\\n";
//}
//if(this.txtScheduleId.Text.Trim().Length==0)
//{
// strErr+="手术id号不能为空！\\n";
//}
//if(this.txtDiagBeforeOperation.Text.Trim().Length==0)
//{
// strErr+="主要诊断不能为空！\\n";
//}
//if(this.txtScheduledDateTime.Text.Trim().Length==0)
//{
// strErr+="预约进行该次手术的日期及时间不能为空！\\n";
//}
//if(this.txtKeepSpecimenSign.Text.Trim().Length==0)
//{
// strErr+="是否留标本不能为空！\\n";
//}
//if(this.txtOperatingRoom.Text.Trim().Length==0)
//{
// strErr+="手术室代码@名称不能为空！\\n";
//}
//if(this.txtSurgeon.Text.Trim().Length==0)
//{
// strErr+="手术医师工号@姓名不能为空！\\n";
//}
//if(this.txtInPatPreillness.Text.Trim().Length==0)
//{
// strErr+="现病史不能为空！\\n";
//}
//if(this.txtInPatPastillness.Text.Trim().Length==0)
//{
// strErr+="既往史不能为空！\\n";
//}
//if(this.txtInPatFamillness.Text.Trim().Length==0)
//{
// strErr+="家族史不能为空！\\n";
//}
//if(this.txtLabInfo.Text.Trim().Length==0)
//{
// strErr+="乙肝梅毒等阳性结果不能为空！\\n";
//}
#endregion
if(strErr!="")
{
MessageBox.Show(this,strErr);
return;
}
string PatientId=this.txtPatientId.Text;
string InpNO=this.txtInpNO.Text;
string VisitId=this.txtVisitId.Text;
string Name=this.txtName.Text;
string NamePhonetic=this.txtNamePhonetic.Text;
string Sex=this.txtSex.Text;
string DateOfBirth=this.txtDateOfBirth.Text;
string BirthPlace=this.txtBirthPlace.Text;
string Citizenship=this.txtCitizenship.Text;
string Nation=this.txtNation.Text;
string IDNO=this.txtIDNO.Text;
string Identity=this.txtIdentity.Text;
string ChargeType=this.txtChargeType.Text;
string MailingAddress=this.txtMailingAddress.Text;
string ZipCode=this.txtZipCode.Text;
string PhoneNumberHome=this.txtPhoneNumberHome.Text;
string PhoneNumbeBusiness=this.txtPhoneNumbeBusiness.Text;
string NextOfKin=this.txtNextOfKin.Text;
string RelationShip=this.txtRelationShip.Text;
string NextOfKinAddr=this.txtNextOfKinAddr.Text;
string NextOfKinZipCode=this.txtNextOfKinZipCode.Text;
string NextOfKinPhome=this.txtNextOfKinPhome.Text;
string DeptCode=this.txtDeptCode.Text;
string BedNO=this.txtBedNO.Text;
string AdmissionDateTime=this.txtAdmissionDateTime.Text;
string DoctorInCharge=this.txtDoctorInCharge.Text;
string ScheduleId=this.txtScheduleId.Text;
string DiagBeforeOperation=this.txtDiagBeforeOperation.Text;
string ScheduledDateTime=this.txtScheduledDateTime.Text;
string KeepSpecimenSign=this.txtKeepSpecimenSign.Text;
string OperatingRoom=this.txtOperatingRoom.Text;
string Surgeon=this.txtSurgeon.Text;
string InPatPreillness=this.txtInPatPreillness.Text;
string InPatPastillness=this.txtInPatPastillness.Text;
string InPatFamillness=this.txtInPatFamillness.Text;
string LabInfo=this.txtLabInfo.Text;
RuRo.Model.ZSSY.OPListForSpecimen model=new RuRo.Model.ZSSY.OPListForSpecimen();
model.PatientId=PatientId;
model.InpNO=InpNO;
model.VisitId=VisitId;
model.Name=Name;
model.NamePhonetic=NamePhonetic;
model.Sex=Sex;
model.DateOfBirth=DateOfBirth;
model.BirthPlace=BirthPlace;
model.Citizenship=Citizenship;
model.Nation=Nation;
model.IDNO=IDNO;
model.Identity=Identity;
model.ChargeType=ChargeType;
model.MailingAddress=MailingAddress;
model.ZipCode=ZipCode;
model.PhoneNumberHome=PhoneNumberHome;
model.PhoneNumbeBusiness=PhoneNumbeBusiness;
model.NextOfKin=NextOfKin;
model.RelationShip=RelationShip;
model.NextOfKinAddr=NextOfKinAddr;
model.NextOfKinZipCode=NextOfKinZipCode;
model.NextOfKinPhome=NextOfKinPhome;
model.DeptCode=DeptCode;
model.BedNO=BedNO;
model.AdmissionDateTime=AdmissionDateTime;
model.DoctorInCharge=DoctorInCharge;
model.ScheduleId=ScheduleId;
model.DiagBeforeOperation=DiagBeforeOperation;
model.ScheduledDateTime=ScheduledDateTime;
model.KeepSpecimenSign=KeepSpecimenSign;
model.OperatingRoom=OperatingRoom;
model.Surgeon=Surgeon;
model.InPatPreillness=InPatPreillness;
model.InPatPastillness=InPatPastillness;
model.InPatFamillness=InPatFamillness;
model.LabInfo=LabInfo;
RuRo.BLL.ZSSY.OPListForSpecimen bll=new RuRo.BLL.ZSSY.OPListForSpecimen();
bll.Add(model);
RuRo.Common.MessageBox.ShowAndRedirect(this,"保存成功！","add.aspx");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public RuRo.Model.ZSSY.OPListForSpecimen DataRowToModel(DataRow row)
{
RuRo.Model.ZSSY.OPListForSpecimen model=new RuRo.Model.ZSSY.OPListForSpecimen();
if (row != null)
{
if(row["Id"]!=null && row["Id"].ToString()!="")
{
model.Id=int.Parse(row["Id"].ToString());
}
if(row["PatientId"]!=null)
{
model.PatientId=row["PatientId"].ToString();
}
if(row["InpNO"]!=null)
{
model.InpNO=row["InpNO"].ToString();
}
if(row["VisitId"]!=null)
{
model.VisitId=row["VisitId"].ToString();
}
if(row["Name"]!=null)
{
model.Name=row["Name"].ToString();
}
if(row["NamePhonetic"]!=null)
{
model.NamePhonetic=row["NamePhonetic"].ToString();
}
if(row["Sex"]!=null)
{
model.Sex=row["Sex"].ToString();
}
if(row["DateOfBirth"]!=null)
{
model.DateOfBirth=row["DateOfBirth"].ToString();
}
if(row["BirthPlace"]!=null)
{
model.BirthPlace=row["BirthPlace"].ToString();
}
if(row["Citizenship"]!=null)
{
model.Citizenship=row["Citizenship"].ToString();
}
if(row["Nation"]!=null)
{
model.Nation=row["Nation"].ToString();
}
if(row["IDNO"]!=null)
{
model.IDNO=row["IDNO"].ToString();
}
if(row["Identity"]!=null)
{
model.Identity=row["Identity"].ToString();
}
if(row["ChargeType"]!=null)
{
model.ChargeType=row["ChargeType"].ToString();
}
if(row["MailingAddress"]!=null)
{
model.MailingAddress=row["MailingAddress"].ToString();
}
if(row["ZipCode"]!=null)
{
model.ZipCode=row["ZipCode"].ToString();
}
if(row["PhoneNumberHome"]!=null)
{
model.PhoneNumberHome=row["PhoneNumberHome"].ToString();
}
if(row["PhoneNumbeBusiness"]!=null)
{
model.PhoneNumbeBusiness=row["PhoneNumbeBusiness"].ToString();
}
if(row["NextOfKin"]!=null)
{
model.NextOfKin=row["NextOfKin"].ToString();
}
if(row["RelationShip"]!=null)
{
model.RelationShip=row["RelationShip"].ToString();
}
if(row["NextOfKinAddr"]!=null)
{
model.NextOfKinAddr=row["NextOfKinAddr"].ToString();
}
if(row["NextOfKinZipCode"]!=null)
{
model.NextOfKinZipCode=row["NextOfKinZipCode"].ToString();
}
if(row["NextOfKinPhome"]!=null)
{
model.NextOfKinPhome=row["NextOfKinPhome"].ToString();
}
if(row["DeptCode"]!=null)
{
model.DeptCode=row["DeptCode"].ToString();
}
if(row["BedNO"]!=null)
{
model.BedNO=row["BedNO"].ToString();
}
if(row["AdmissionDateTime"]!=null)
{
model.AdmissionDateTime=row["AdmissionDateTime"].ToString();
}
if(row["DoctorInCharge"]!=null)
{
model.DoctorInCharge=row["DoctorInCharge"].ToString();
}
if(row["ScheduleId"]!=null)
{
model.ScheduleId=row["ScheduleId"].ToString();
}
if(row["DiagBeforeOperation"]!=null)
{
model.DiagBeforeOperation=row["DiagBeforeOperation"].ToString();
}
if(row["ScheduledDateTime"]!=null)
{
model.ScheduledDateTime=row["ScheduledDateTime"].ToString();
}
if(row["KeepSpecimenSign"]!=null)
{
model.KeepSpecimenSign=row["KeepSpecimenSign"].ToString();
}
if(row["OperatingRoom"]!=null)
{
model.OperatingRoom=row["OperatingRoom"].ToString();
}
if(row["Surgeon"]!=null)
{
model.Surgeon=row["Surgeon"].ToString();
}
if(row["InPatPreillness"]!=null)
{
model.InPatPreillness=row["InPatPreillness"].ToString();
}
if(row["InPatPastillness"]!=null)
{
model.InPatPastillness=row["InPatPastillness"].ToString();
}
if(row["InPatFamillness"]!=null)
{
model.InPatFamillness=row["InPatFamillness"].ToString();
}
if(row["LabInfo"]!=null)
{
model.LabInfo=row["LabInfo"].ToString();
}
}
return model;
}
