private void ReceiveTreatModify_Load(object sender, EventArgs e) { receiveMode = new ReceiveTreatBaseInfoBLL().GetModel(this.ID); if (!this.EveryThingIsOk) { InitEveryThing(); } }
public void UpdataToModel() { ClinicalModel = new ReceiveTreatBaseInfoModel(); this.ClinicalModel.IDCardNo = tbIDCARD.Text.Trim(); this.ClinicalModel.Doctor = tbDoctor.Text.Trim(); this.ClinicalModel.ReceiveDate = dtReceiveDate.Value; this.ClinicalModel.SubjectiveData = tbSubjectData.Text.Trim(); this.ClinicalModel.ObjectiveData = tbObjectiveData.Text.Trim(); this.ClinicalModel.Assessment = tbAssessment.Text.Trim(); this.ClinicalModel.ManagePlane = tbManagePlane.Text.Trim(); }
public int AddServer(ReceiveTreatBaseInfoModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into ARCHIVE_RECEPTION_RECORD("); builder.Append("IDCardNo,Doctor,SubjectiveData,ObjectiveData,Assessment,ManagePlane,ReceiveDate,UpdateUnitName,UpdatePerson,UpdateDate)"); builder.Append("values ("); builder.Append("@IDCardNo,@Doctor,@SubjectiveData,@ObjectiveData,@Assessment,@ManagePlane,@ReceiveDate,@UpdateUnitName,@UpdatePerson,@UpdateDate)"); builder.Append(";select @@IDENTITY"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@IDCardNo", MySqlDbType.String, 18), new MySqlParameter("@Doctor", MySqlDbType.String, 100), new MySqlParameter("@SubjectiveData", MySqlDbType.String, 1000), new MySqlParameter("@ObjectiveData", MySqlDbType.String, 1000), new MySqlParameter("@Assessment", MySqlDbType.String, 1000), new MySqlParameter("@ManagePlane", MySqlDbType.String, 1000), new MySqlParameter("@ReceiveDate", MySqlDbType.Date), new MySqlParameter("@ConsultationDate", MySqlDbType.Date), new MySqlParameter("@UpdateUnitName", MySqlDbType.String, 100), new MySqlParameter("@UpdatePerson", MySqlDbType.String, 100), new MySqlParameter("@UpdateDate", MySqlDbType.Date) }; cmdParms[0].Value = model.IDCardNo; cmdParms[1].Value = model.Doctor; cmdParms[2].Value = model.SubjectiveData; cmdParms[3].Value = model.ObjectiveData; cmdParms[4].Value = model.Assessment; cmdParms[5].Value = model.ManagePlane; cmdParms[6].Value = model.ReceiveDate; cmdParms[7].Value = model.UpdateUnitName; cmdParms[8].Value = model.UpdatePerson; cmdParms[9].Value = model.UpdateDate; object single = MySQLHelper.GetSingleServer(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
public bool Update(ReceiveTreatBaseInfoModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update ARCHIVE_RECEPTION_RECORD set "); builder.Append("IDCardNo=@IDCardNo,"); builder.Append("Doctor=@Doctor,"); builder.Append("SubjectiveData=@SubjectiveData,"); builder.Append("ObjectiveData=@ObjectiveData,"); builder.Append("Assessment=@Assessment,"); builder.Append("ManagePlane=@ManagePlane,"); builder.Append("ReceiveDate=@ReceiveDate,"); builder.Append("UpdateUnitName=@UpdateUnitName,"); builder.Append("UpdatePerson=@UpdatePerson,"); builder.Append("UpdateDate=@UpdateDate "); builder.Append(" where ID=@ID"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@IDCardNo", MySqlDbType.String, 18), new MySqlParameter("@Doctor", MySqlDbType.String, 100), new MySqlParameter("@SubjectiveData", MySqlDbType.String, 100), new MySqlParameter("@ObjectiveData", MySqlDbType.String, 100), new MySqlParameter("@Assessment", MySqlDbType.String, 100), new MySqlParameter("@ManagePlane", MySqlDbType.String, 100), new MySqlParameter("@ReceiveDate", MySqlDbType.Date), new MySqlParameter("@UpdateUnitName", MySqlDbType.String, 100), new MySqlParameter("@UpdatePerson", MySqlDbType.String, 100), new MySqlParameter("@UpdateDate", MySqlDbType.Date), new MySqlParameter("@ID", MySqlDbType.Int32, 8) }; cmdParms[0].Value = model.IDCardNo; cmdParms[1].Value = model.Doctor; cmdParms[2].Value = model.SubjectiveData; cmdParms[3].Value = model.ObjectiveData; cmdParms[4].Value = model.Assessment; cmdParms[5].Value = model.ManagePlane; cmdParms[6].Value = model.ReceiveDate; cmdParms[7].Value = model.UpdateUnitName; cmdParms[8].Value = model.UpdatePerson; cmdParms[9].Value = model.UpdateDate; cmdParms[10].Value = model.ID; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public bool Update(ReceiveTreatBaseInfoModel model) { return(this.dal.Update(model)); }
public int Add(ReceiveTreatBaseInfoModel model) { return(this.dal.Add(model)); }
public ReceiveTreatBaseInfoModel DataRowToModel(DataRow row) { ReceiveTreatBaseInfoModel receiveModel = new ReceiveTreatBaseInfoModel(); if (row != null) { if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != "")) { receiveModel.ID = int.Parse(row["ID"].ToString()); } if ((row["CustomerName"] != null) && (row["CustomerName"] != DBNull.Value)) { receiveModel.CustomerName = row["CustomerName"].ToString(); } if ((row["Sex"] != null) && (row["Sex"] != DBNull.Value)) { receiveModel.Sex = row["Sex"].ToString(); } if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value)) { receiveModel.IDCardNo = row["IDCardNo"].ToString(); } if ((row["Address"] != null) && (row["Address"] != DBNull.Value)) { receiveModel.Address = row["Address"].ToString(); } if ((row["CreateUnitName"] != null) && (row["CreateUnitName"] != DBNull.Value)) { receiveModel.CreateUnitName = row["CreateUnitName"].ToString(); } if ((row["Doctor"] != null) && (row["Doctor"] != DBNull.Value)) { receiveModel.Doctor = row["Doctor"].ToString(); } if ((row["SubjectiveData"] != null) && (row["SubjectiveData"] != DBNull.Value)) { receiveModel.SubjectiveData = row["SubjectiveData"].ToString(); } if ((row["ObjectiveData"] != null) && (row["ObjectiveData"] != DBNull.Value)) { receiveModel.ObjectiveData = row["ObjectiveData"].ToString(); } if ((row["Assessment"] != null) && (row["Assessment"] != DBNull.Value)) { receiveModel.Assessment = row["Assessment"].ToString(); } if ((row["ManagePlane"] != null) && (row["ManagePlane"] != DBNull.Value)) { receiveModel.ManagePlane = row["ManagePlane"].ToString(); } if ((row["CreateMenName"] != null) && (row["CreateMenName"] != DBNull.Value)) { receiveModel.CreateMenName = row["CreateMenName"].ToString(); } if (((row["ReceiveDate"] != null) && (row["ReceiveDate"] != DBNull.Value)) && (row["ReceiveDate"].ToString() != "")) { receiveModel.ReceiveDate = DateTime.Parse(row["ReceiveDate"].ToString()); } if (((row["CreateDate"] != null) && (row["CreateDate"] != DBNull.Value)) && (row["CreateDate"].ToString() != "")) { receiveModel.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } } return(receiveModel); }