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