public void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(this.txtPatientId.Text.Trim().Length==0) { strErr+="患者唯一标识号不能为空!\\n"; } if(this.txtPatientName.Text.Trim().Length==0) { strErr+="患者名称不能为空!\\n"; } if(this.txtVisitId.Text.Trim().Length==0) { strErr+="患者就诊号不能为空!\\n"; } if(this.txtSampleId.Text.Trim().Length==0) { strErr+="样本Id不能为空!\\n"; } if(this.txtSampleName.Text.Trim().Length==0) { strErr+="样本Name不能为空!\\n"; } if(this.txtOtherInfo.Text.Trim().Length==0) { strErr+="其他信息(样本类型、总管数、在不能为空!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } int Id=int.Parse(this.lblId.Text); string PatientId=this.txtPatientId.Text; string PatientName=this.txtPatientName.Text; string VisitId=this.txtVisitId.Text; string SampleId=this.txtSampleId.Text; string SampleName=this.txtSampleName.Text; string OtherInfo=this.txtOtherInfo.Text; RuRo.Model.ZSSY.SpecimenRt model=new RuRo.Model.ZSSY.SpecimenRt(); model.Id=Id; model.PatientId=PatientId; model.PatientName=PatientName; model.VisitId=VisitId; model.SampleId=SampleId; model.SampleName=SampleName; model.OtherInfo=OtherInfo; RuRo.BLL.ZSSY.SpecimenRt bll=new RuRo.BLL.ZSSY.SpecimenRt(); bll.Update(model); RuRo.Common.MessageBox.ShowAndRedirect(this,"保存成功!","list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public RuRo.Model.ZSSY.SpecimenRt DataRowToModel(DataRow row) { RuRo.Model.ZSSY.SpecimenRt model=new RuRo.Model.ZSSY.SpecimenRt(); 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["PatientName"]!=null) { model.PatientName=row["PatientName"].ToString(); } if(row["VisitId"]!=null) { model.VisitId=row["VisitId"].ToString(); } if(row["SampleId"]!=null) { model.SampleId=row["SampleId"].ToString(); } if(row["SampleName"]!=null) { model.SampleName=row["SampleName"].ToString(); } if(row["OtherInfo"]!=null) { model.OtherInfo=row["OtherInfo"].ToString(); } } return model; }
/// <summary> /// 将RuRo.BLL.WebService.SpecimenRt 对象转换成数据库SpecimenRt中保存的对象 /// </summary> /// <param name="item">RuRo.BLL.WebService.SpecimenRt</param> /// <returns>SpecimenRt</returns> private RuRo.Model.ZSSY.SpecimenRt WebSpecimenRtToDataBaseSpecimenRt(RuRo.BLL.WebService.SpecimenRt item) { //将当前需要回传的样本数据转换成数据库里保存的格式 RuRo.Model.ZSSY.SpecimenRt specimenRt = new RuRo.Model.ZSSY.SpecimenRt(); if (!string.IsNullOrEmpty(item.PatientId)) { specimenRt.PatientId = item.PatientId; specimenRt.PatientName = item.PatientName; specimenRt.SampleId = item.Specimens[0].Id; specimenRt.SampleName = item.Specimens[0].Name; specimenRt.OtherInfo = item.Specimens[0].OtherInfo; specimenRt.VisitId = item.VisitId; } return specimenRt; }
/// <summary> /// 得到一个对象实体 /// </summary> public RuRo.Model.ZSSY.SpecimenRt GetModel(int Id) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 Id,PatientId,PatientName,VisitId,SampleId,SampleName,OtherInfo from SpecimenRt "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int,4) }; parameters[0].Value = Id; RuRo.Model.ZSSY.SpecimenRt model=new RuRo.Model.ZSSY.SpecimenRt(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }