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; }