public void InitEveryThing()
{
ListModel = new List <ConsulationDoctorsModel>();
ConModel = new ConsulationBaseInfoModel();
ConDocModel = new ConsulationDoctorsModel();
if (!string.IsNullOrEmpty(this.IDCardNo))
{
this.Model = new RecordsBaseInfoBLL().GetModel(this.IDCardNo);
}
this.lbAddress.Text = this.Model.Address;
this.lbName.Text = this.Model.CustomerName;
this.lbIDCard.Text = this.Model.IDCardNo;
this.tbCreateMenName.Text = this.Model.CreateMenName;
this.tbCreateUnitName.Text = this.Model.CreateUnitName;
this.dtpCreatTime.Text = this.Model.CreateDate.Value.ToString();
if (this.Model.Sex == "1")
{
this.lbSex.Text = "男";
}
else if (this.Model.Sex == "2")
{
this.lbSex.Text = "女";
}
this.ConModel.IDCardNo = lbIDCard.Text;
this.EveryThingIsOk = true;
}
public ConsulationBaseInfoModel DataRowToModel(DataRow row)
{
ConsulationBaseInfoModel ConsulationModel = new ConsulationBaseInfoModel();
if (row != null)
{
if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != ""))
{
ConsulationModel.ID = int.Parse(row["ID"].ToString());
}
if ((row["Sex"] != null) && (row["Sex"] != DBNull.Value))
{
ConsulationModel.Sex = row["Sex"].ToString();
}
if (((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value)))
{
ConsulationModel.IDCardNo = row["IDCardNo"].ToString();
}
if ((row["CustomerName"] != null) && (row["CustomerName"] != DBNull.Value))
{
ConsulationModel.CustomerName = row["CustomerName"].ToString();
}
if ((row["Address"] != null) && (row["Address"] != DBNull.Value))
{
ConsulationModel.Address = row["Address"].ToString();
}
if ((row["Reason"] != null) && (row["Reason"] != DBNull.Value))
{
ConsulationModel.Reason = row["Reason"].ToString();
}
if ((row["View"] != null) && (row["View"] != DBNull.Value))
{
ConsulationModel.View = row["View"].ToString();
}
if ((row["CreateUnitName"] != null) && (row["CreateUnitName"] != DBNull.Value))
{
ConsulationModel.CreateUnitName = row["CreateUnitName"].ToString();
}
if ((row["ResponsibilityDoctor"] != null) && (row["ResponsibilityDoctor"] != DBNull.Value))
{
ConsulationModel.ResponsibilityDoctor = row["ResponsibilityDoctor"].ToString();
}
if ((row["CreateMenName"] != null) && (row["CreateMenName"] != DBNull.Value))
{
ConsulationModel.CreateMenName = row["CreateMenName"].ToString();
}
if (((row["ConsultationDate"] != null) && (row["ConsultationDate"] != DBNull.Value)) && (row["ConsultationDate"].ToString() != ""))
{
ConsulationModel.ConsultationDate = DateTime.Parse(row["ConsultationDate"].ToString());
}
if (((row["CreateDate"] != null) && (row["CreateDate"] != DBNull.Value)) && (row["CreateDate"].ToString() != ""))
{
ConsulationModel.CreateTime = DateTime.Parse(row["CreateDate"].ToString());
}
}
return(ConsulationModel);
}
private void ConsulateModify_Load(object sender, EventArgs e)
{
consulateModel = new ConsulationBaseInfoBLL().GetModel(this.ID);
string strWhere = string.Format("OutKey={0}", this.ID);
doctorSet = new ConsulationDoctorsBLL().GetList(strWhere);
if (!this.EveryThingIsOk)
{
InitEveryThing();
}
}
public int AddServer(ConsulationBaseInfoModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into ARCHIVE_CONSULTATION_RECORD(");
builder.Append("IDCardNo,Reason,View,ResponsibilityDoctor,ConsultationDate,UpdateUnitName,UpdatePerson,UpdateDate)");
builder.Append("values (");
builder.Append("@IDCardNo,@Reason,@View,@ResponsibilityDoctor,@ConsultationDate,@UpdateUnitName,@UpdatePerson,@UpdateDate)");
builder.Append(";select @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@IDCardNo", MySqlDbType.String, 18),
new MySqlParameter("@Reason", MySqlDbType.String, 100),
new MySqlParameter("@View", MySqlDbType.String, 100),
new MySqlParameter("@ResponsibilityDoctor", MySqlDbType.String, 100),
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.Reason;
cmdParms[2].Value = model.View;
cmdParms[3].Value = model.ResponsibilityDoctor;
cmdParms[4].Value = model.ConsultationDate;
cmdParms[5].Value = model.UpdateUnitName;
cmdParms[6].Value = model.UpdatePerson;
cmdParms[7].Value = model.UpdateDate;
object single = MySQLHelper.GetSingleServer(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
public bool Update(ConsulationBaseInfoModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update ARCHIVE_CONSULTATION_RECORD set ");
builder.Append("IDCardNo=@IDCardNo,");
builder.Append("Reason=@Reason,");
builder.Append("View=@View,");
builder.Append("ResponsibilityDoctor=@ResponsibilityDoctor,");
builder.Append("ConsultationDate=@ConsultationDate,");
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("@Reason", MySqlDbType.String, 1000),
new MySqlParameter("@View", MySqlDbType.String, 1000),
new MySqlParameter("@ResponsibilityDoctor", MySqlDbType.String, 100),
new MySqlParameter("@ConsultationDate", MySqlDbType.DateTime),
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.Reason;
cmdParms[2].Value = model.View;
cmdParms[3].Value = model.ResponsibilityDoctor;
cmdParms[4].Value = model.ConsultationDate;
cmdParms[5].Value = model.UpdateUnitName;
cmdParms[6].Value = model.UpdatePerson;
cmdParms[7].Value = model.UpdateDate;
cmdParms[8].Value = model.ID;
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Update(ConsulationBaseInfoModel model)
{
return(this.dal.Update(model));
}
public int Add(ConsulationBaseInfoModel model)
{
return(this.dal.Add(model));
}
