public void Init(string _idcard, string _illtype)
{
this.idcard = _idcard;
this.illtype = _illtype;
this.illnesshistoryinfo = new RecordsIllnessHistoryInfoBLL().GetModelList(string.Format(" IDCardNo = '{0}' AND IllnessType = '{1}' ", this.idcard, this.illtype));
if (this.illnesshistoryinfo.Count == 0)
{
this.rdWu.Checked = true;
}
else
{
this.rdYou.Checked = true;
RecordsIllnessHistoryInfoModel recordsIllnessHistoryInfoModel1 = this.illnesshistoryinfo.ElementAtOrDefault <RecordsIllnessHistoryInfoModel>(0);
RecordsIllnessHistoryInfoModel recordsIllnessHistoryInfoModel2 = this.illnesshistoryinfo.ElementAtOrDefault <RecordsIllnessHistoryInfoModel>(1);
if (recordsIllnessHistoryInfoModel1 != null)
{
this.tbName1.Text = recordsIllnessHistoryInfoModel1.IllnessNameOther;
if (recordsIllnessHistoryInfoModel1.DiagnoseTime.HasValue)
{
this.dtpTime1.Value = recordsIllnessHistoryInfoModel1.DiagnoseTime.Value;;
}
}
if (recordsIllnessHistoryInfoModel2 != null)
{
this.tbName2.Text = recordsIllnessHistoryInfoModel2.IllnessNameOther;
if (recordsIllnessHistoryInfoModel2.DiagnoseTime.HasValue)
{
this.dtpTime2.Value = recordsIllnessHistoryInfoModel2.DiagnoseTime.Value;
}
}
}
}
public void UpdateSource()
{
for (int i = 0; i < this.illItems.Count; i++)
{
this.illItems[i].UpdateInfo();
}
int num2 = this.source.Count <RecordsIllnessHistoryInfoModel>(ct => ct.IllnessName == "1");
if (this.c1.Checked)
{
if (num2 == 0)
{
RecordsIllnessHistoryInfoModel item = new RecordsIllnessHistoryInfoModel {
RecordState = RecordsStateModel.AddToDB,
IllnessType = "1",
IllnessName = "1"
};
this.source.Add(item);
}
}
else if (num2 > 0)
{
this.source.First <RecordsIllnessHistoryInfoModel>(ab => (ab.IllnessName == "1")).RecordState = RecordsStateModel.DeleteInDB;
}
}
public int Add(RecordsIllnessHistoryInfoModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("INSERT INTO ARCHIVE_ILLNESSHISTORYINFO(");
builder.Append("RecordID,IDCardNo,IllnessType,IllnessName,Therioma,IllnessOther,JobIllness,IllnessNameOther,DiagnoseTime,IllnessResult,Unite,OccurTime,EndTime,Remarks,DateSorce,Dose,IllDescription)");
builder.Append(" VALUES (");
builder.Append("@RecordID,@IDCardNo,@IllnessType,@IllnessName,@Therioma,@IllnessOther,@JobIllness,@IllnessNameOther,@DiagnoseTime,@IllnessResult,@Unite,@OccurTime,@EndTime,@Remarks,@DateSorce,@Dose,@IllDescription)");
builder.Append(";SELECT @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[]
{
new MySqlParameter("@RecordID", MySqlDbType.String, 100),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@IllnessType", MySqlDbType.String, 1),
new MySqlParameter("@IllnessName", MySqlDbType.String, 100),
new MySqlParameter("@Therioma", MySqlDbType.String, 100),
new MySqlParameter("@IllnessOther", MySqlDbType.String, 100),
new MySqlParameter("@JobIllness", MySqlDbType.String, 100),
new MySqlParameter("@IllnessNameOther", MySqlDbType.String, 100),
new MySqlParameter("@DiagnoseTime", MySqlDbType.Date),
new MySqlParameter("@IllnessResult", MySqlDbType.String, 100),
new MySqlParameter("@Unite", MySqlDbType.String, 100),
new MySqlParameter("@OccurTime", MySqlDbType.String, 100),
new MySqlParameter("@EndTime", MySqlDbType.String, 100),
new MySqlParameter("@Remarks", MySqlDbType.String, 100),
new MySqlParameter("@DateSorce", MySqlDbType.String, 100),
new MySqlParameter("@Dose", MySqlDbType.Decimal),
new MySqlParameter("@IllDescription", MySqlDbType.String, 100)
};
cmdParms[0].Value = model.RecordID;
cmdParms[1].Value = model.IDCardNo;
cmdParms[2].Value = model.IllnessType;
cmdParms[3].Value = model.IllnessName;
cmdParms[4].Value = model.Therioma;
cmdParms[5].Value = model.IllnessOther;
cmdParms[6].Value = model.JobIllness;
cmdParms[7].Value = model.IllnessNameOther;
cmdParms[8].Value = model.DiagnoseTime;
cmdParms[9].Value = model.IllnessResult;
cmdParms[10].Value = model.Unite;
cmdParms[11].Value = model.OccurTime;
cmdParms[12].Value = model.EndTime;
cmdParms[13].Value = model.Remarks;
cmdParms[14].Value = model.DateSorce;
cmdParms[15].Value = model.Dose;
cmdParms[16].Value = model.IllDescription;
object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
public RecordsIllnessHistoryInfoModel DataRowToModel(DataRow row)
{
RecordsIllnessHistoryInfoModel recordsIllnessHistoryInfoModel = new RecordsIllnessHistoryInfoModel();
if (row != null)
{
if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != ""))
{
recordsIllnessHistoryInfoModel.ID = int.Parse(row["ID"].ToString());
}
if ((row["RecordID"] != null) && (row["RecordID"] != DBNull.Value))
{
recordsIllnessHistoryInfoModel.RecordID = row["RecordID"].ToString();
}
if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value))
{
recordsIllnessHistoryInfoModel.IDCardNo = row["IDCardNo"].ToString();
}
if ((row["IllnessType"] != null) && (row["IllnessType"] != DBNull.Value))
{
recordsIllnessHistoryInfoModel.IllnessType = row["IllnessType"].ToString();
}
if ((row["IllnessName"] != null) && (row["IllnessName"] != DBNull.Value))
{
recordsIllnessHistoryInfoModel.IllnessName = row["IllnessName"].ToString();
}
if ((row["Therioma"] != null) && (row["Therioma"] != DBNull.Value))
{
recordsIllnessHistoryInfoModel.Therioma = row["Therioma"].ToString();
}
if ((row["IllnessOther"] != null) && (row["IllnessOther"] != DBNull.Value))
{
recordsIllnessHistoryInfoModel.IllnessOther = row["IllnessOther"].ToString();
}
if ((row["JobIllness"] != null) && (row["JobIllness"] != DBNull.Value))
{
recordsIllnessHistoryInfoModel.JobIllness = row["JobIllness"].ToString();
}
if ((row["IllnessNameOther"] != null) && (row["IllnessNameOther"] != DBNull.Value))
{
recordsIllnessHistoryInfoModel.IllnessNameOther = row["IllnessNameOther"].ToString();
}
if (((row["DiagnoseTime"] != null) && (row["DiagnoseTime"] != DBNull.Value)) && (row["DiagnoseTime"].ToString() != ""))
{
recordsIllnessHistoryInfoModel.DiagnoseTime = new DateTime?(DateTime.Parse(row["DiagnoseTime"].ToString()));
}
recordsIllnessHistoryInfoModel.RecordState = RecordsStateModel.Unchanged;
}
return(recordsIllnessHistoryInfoModel);
}
public List <RecordsIllnessHistoryInfoModel> DataTableToList(DataTable dt)
{
List <RecordsIllnessHistoryInfoModel> list = new List <RecordsIllnessHistoryInfoModel>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
RecordsIllnessHistoryInfoModel item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public void UpdateSource()
{
if (this.source == null)
{
RecordsIllnessHistoryInfoModel recordsIllnessHistoryInfoModel = new RecordsIllnessHistoryInfoModel
{
RecordState = RecordsStateModel.NoValue
};
this.source = recordsIllnessHistoryInfoModel;
this.source.IDCardNo = this.IDCard;
this.source.RecordID = this.RecordID;
this.source.IllnessType = this.itsType;
}
if (this.rd_y.Checked)
{
if (this.source.RecordState == RecordsStateModel.NoValue)
{
this.source.RecordState = RecordsStateModel.AddToDB;
}
if (this.source.RecordState == RecordsStateModel.Unchanged)
{
this.source.RecordState = RecordsStateModel.UpdateInDB;
}
this.source.IllnessName = "2";
this.source.IllnessNameOther = this.tb1.Text.Trim();
this.source.DiagnoseTime = new DateTime?(this.dtp1.Value.Date);
}
else if (this.rd_w.Checked)
{
this.source.IllnessName = "1";
this.source.IllnessNameOther = string.Empty;
this.source.DiagnoseTime = null;
RecordsStateModel modelState = this.source.RecordState;
if (this.source.RecordState == RecordsStateModel.Unchanged)
{
this.source.RecordState = RecordsStateModel.DeleteInDB;
}
}
}
public bool UpdateServer(RecordsIllnessHistoryInfoModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update ARCHIVE_ILLNESSHISTORYINFO set ");
builder.Append("RecordID=@RecordID,");
builder.Append("IDCardNo=@IDCardNo,");
builder.Append("IllnessType=@IllnessType,");
builder.Append("IllnessName=@IllnessName,");
builder.Append("Therioma=@Therioma,");
builder.Append("IllnessOther=@IllnessOther,");
builder.Append("JobIllness=@JobIllness,");
builder.Append("IllnessNameOther=@IllnessNameOther,");
builder.Append("DiagnoseTime=@DiagnoseTime");
builder.Append(" where IDCardNo=@IDCardNo");
MySqlParameter[] cmdParms = new MySqlParameter[]
{
new MySqlParameter("@RecordID", MySqlDbType.String, 17),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@IllnessType", MySqlDbType.String, 1),
new MySqlParameter("@IllnessName", MySqlDbType.String, 200),
new MySqlParameter("@Therioma", MySqlDbType.String, 200),
new MySqlParameter("@IllnessOther", MySqlDbType.String, 200),
new MySqlParameter("@JobIllness", MySqlDbType.String, 200),
new MySqlParameter("@IllnessNameOther", MySqlDbType.String, 200),
new MySqlParameter("@DiagnoseTime", MySqlDbType.Date)
//new MySqlParameter("@ID", MySqlDbType.Int32, 8)
};
cmdParms[0].Value = model.RecordID;
cmdParms[1].Value = model.IDCardNo;
cmdParms[2].Value = model.IllnessType;
cmdParms[3].Value = model.IllnessName;
cmdParms[4].Value = model.Therioma;
cmdParms[5].Value = model.IllnessOther;
cmdParms[6].Value = model.JobIllness;
cmdParms[7].Value = model.IllnessNameOther;
cmdParms[8].Value = model.DiagnoseTime;
// cmdParms[9].Value = model.ID;
return(MySQLHelper.ExecuteSqlServer(builder.ToString(), cmdParms) > 0);
}
public int AddServer(RecordsIllnessHistoryInfoModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into ARCHIVE_ILLNESSHISTORYINFO(");
builder.Append("RecordID,IDCardNo,IllnessType,IllnessName,Therioma,IllnessOther,JobIllness,IllnessNameOther,DiagnoseTime)");
builder.Append(" values (");
builder.Append("@RecordID,@IDCardNo,@IllnessType,@IllnessName,@Therioma,@IllnessOther,@JobIllness,@IllnessNameOther,@DiagnoseTime)");
builder.Append(";select @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[]
{
new MySqlParameter("@RecordID", MySqlDbType.String, 17),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@IllnessType", MySqlDbType.String, 1),
new MySqlParameter("@IllnessName", MySqlDbType.String, 200),
new MySqlParameter("@Therioma", MySqlDbType.String, 200),
new MySqlParameter("@IllnessOther", MySqlDbType.String, 200),
new MySqlParameter("@JobIllness", MySqlDbType.String, 200),
new MySqlParameter("@IllnessNameOther", MySqlDbType.String, 200),
new MySqlParameter("@DiagnoseTime", MySqlDbType.Date)
};
cmdParms[0].Value = model.RecordID;
cmdParms[1].Value = model.IDCardNo;
cmdParms[2].Value = model.IllnessType;
cmdParms[3].Value = model.IllnessName;
cmdParms[4].Value = model.Therioma;
cmdParms[5].Value = model.IllnessOther;
cmdParms[6].Value = model.JobIllness;
cmdParms[7].Value = model.IllnessNameOther;
cmdParms[8].Value = model.DiagnoseTime;
object single = MySQLHelper.GetSingleServer(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
public void SavetoDB()
{
RecordsIllnessHistoryInfoModel recordsIllnessHistoryInfoModel4;
if (!this.rdYou.Checked)
{
if (this.rdWu.Checked)
{
RecordsIllnessHistoryInfoModel recordsIllnessHistoryInfoModel7 = this.illnesshistoryinfo.ElementAtOrDefault <RecordsIllnessHistoryInfoModel>(0);
if (recordsIllnessHistoryInfoModel7 != null)
{
recordsIllnessHistoryInfoModel7.RecordState = RecordsStateModel.DeleteInDB;
}
RecordsIllnessHistoryInfoModel recordsIllnessHistoryInfoModel8 = this.illnesshistoryinfo.ElementAtOrDefault <RecordsIllnessHistoryInfoModel>(1);
if (recordsIllnessHistoryInfoModel8 != null)
{
recordsIllnessHistoryInfoModel8.RecordState = RecordsStateModel.DeleteInDB;
}
}
goto Label_0275;
}
RecordsIllnessHistoryInfoModel recordsIllnessHistoryInfoModel = this.illnesshistoryinfo.ElementAtOrDefault <RecordsIllnessHistoryInfoModel>(0);
if (recordsIllnessHistoryInfoModel != null)
{
if (!(recordsIllnessHistoryInfoModel.IllnessNameOther != this.tbName1.Text))
{
DateTime date = this.dtpTime1.Value.Date;
DateTime?dIAGNOSETIME = recordsIllnessHistoryInfoModel.DiagnoseTime;
if ((!dIAGNOSETIME.HasValue ? 1 : ((date != dIAGNOSETIME.GetValueOrDefault()) ? 1 : 0)) == 0)
{
goto Label_0118;
}
}
if (tbName1.Text != "")
{
recordsIllnessHistoryInfoModel.IllnessNameOther = this.tbName1.Text.Trim();
recordsIllnessHistoryInfoModel.DiagnoseTime = new DateTime?(this.dtpTime1.Value.Date);
recordsIllnessHistoryInfoModel.RecordState = RecordsStateModel.UpdateInDB;
}
else
{
recordsIllnessHistoryInfoModel.RecordState = RecordsStateModel.DeleteInDB;
}
}
else
{
RecordsIllnessHistoryInfoModel item = new RecordsIllnessHistoryInfoModel
{
RecordState = RecordsStateModel.AddToDB
};
item.IllnessType = this.illtype;
if (tbName1.Text != "")
{
item.IllnessNameOther = this.tbName1.Text.Trim();
item.DiagnoseTime = new DateTime?(this.dtpTime1.Value.Date);
this.illnesshistoryinfo.Add(item);
}
}
Label_0118:
recordsIllnessHistoryInfoModel4 = this.illnesshistoryinfo.ElementAtOrDefault <RecordsIllnessHistoryInfoModel>(1);
if (recordsIllnessHistoryInfoModel4 != null)
{
if (!(recordsIllnessHistoryInfoModel4.IllnessNameOther != this.tbName2.Text))
{
DateTime time2 = this.dtpTime2.Value.Date;
DateTime?nullable2 = recordsIllnessHistoryInfoModel4.DiagnoseTime;
if ((!nullable2.HasValue ? 1 : ((time2 != nullable2.GetValueOrDefault()) ? 1 : 0)) == 0)
{
goto Label_0275;
}
}
if (this.tbName2.Text.Trim() != "")
{
recordsIllnessHistoryInfoModel4.IllnessNameOther = this.tbName2.Text.Trim();
recordsIllnessHistoryInfoModel4.DiagnoseTime = new DateTime?(this.dtpTime2.Value.Date);
recordsIllnessHistoryInfoModel4.RecordState = RecordsStateModel.UpdateInDB;
}
else
{
recordsIllnessHistoryInfoModel4.RecordState = RecordsStateModel.DeleteInDB;
}
}
else
{
RecordsIllnessHistoryInfoModel recordsIllnessHistoryInfoModel5 = new RecordsIllnessHistoryInfoModel
{
RecordState = RecordsStateModel.AddToDB
};
recordsIllnessHistoryInfoModel5.IllnessType = this.illtype;
if (this.tbName2.Text.Trim() != "")
{
recordsIllnessHistoryInfoModel5.IllnessNameOther = this.tbName2.Text.Trim();
recordsIllnessHistoryInfoModel5.DiagnoseTime = new DateTime?(this.dtpTime2.Value.Date);
this.illnesshistoryinfo.Add(recordsIllnessHistoryInfoModel5);
}
}
Label_0275:
this.archive_illnessoper();
}
public bool Update(RecordsIllnessHistoryInfoModel model)
{
return(this.dal.Update(model));
}
public int Add(RecordsIllnessHistoryInfoModel model)
{
return(this.dal.Add(model));
}
private void UCIllnessHis_CheckedChanged(object sender, EventArgs e)
{
CheckBox box = sender as CheckBox;
if (!box.Checked)
{
for (int i = 0; i < this.source.Count; i++)
{
if (this.source[i].IllnessName == box.Tag.ToString())
{
this.source[i].RecordState = (this.source[i].RecordState != RecordsStateModel.AddToDB) ? RecordsStateModel.DeleteInDB : RecordsStateModel.NoValue;
foreach (illItem item2 in this.illItems)
{
if (item2.Info == this.source[i])
{
item2.Info = null;
}
}
}
}
if (this.illItems.Count <illItem>(h => (h.Info != null)) < 6)
{
foreach (CheckBox box3 in this.cks)
{
if (!box3.Checked && !this.c1.Checked)
{
box3.Enabled = true;
}
}
}
}
else
{
string inputString = "";
if (((box.Text == "职业病") || (box.Text == "恶性肿瘤")) || (box.Text == "其他"))
{
InputFormEx ex = new InputFormEx {
StartPosition = FormStartPosition.CenterScreen,
CanBeNull = true,
MaxBytesCount = 200,
MCaption = "输入疾病名称:"
};
if (ex.ShowDialog() == DialogResult.OK)
{
inputString = ex.InputString;
}
}
string str2 = "";
string text = box.Text;
if (text != null)
{
if (!(text == "高血压"))
{
if (text == "糖尿病")
{
str2 = "7";
}
else if (text == "冠心病")
{
str2 = "8";
}
else if (text == "脑卒中")
{
str2 = "9";
}
else if (text == "严重精神障碍")
{
str2 = "5";
}
}
else
{
str2 = "6";
}
}
string strtext = "";
strtext = box.Text;
if (box.Text == "严重精神障碍")
{
strtext = "重性精神疾病";
}
if ((!string.IsNullOrEmpty(str2) && this.baseinfo != null && !this.baseinfo.PopulationType.Contains(str2)) && (MessageBox.Show("是否将人员列入" + strtext + "人群?", "人群划分", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes))
{
this.baseinfo.PopulationType = !(this.baseinfo.PopulationType == "1") ? (this.baseinfo.PopulationType + "," + str2) : str2;
}
bool flag = false;
RecordsIllnessHistoryInfoModel recordsIllnessHistoryInfoModel = null;
for (int j = 0; j < this.source.Count; j++)
{
if (this.source[j].IllnessName == box.Tag.ToString())
{
this.source[j].RecordState = (this.source[j].RecordState != RecordsStateModel.DeleteInDB) ? RecordsStateModel.AddToDB : RecordsStateModel.UpdateInDB;
flag = true;
recordsIllnessHistoryInfoModel = this.source[j];
break;
}
}
if (!flag)
{
recordsIllnessHistoryInfoModel = new RecordsIllnessHistoryInfoModel
{
IllnessType = "1",
IllnessName = box.Tag.ToString(),
RecordState = RecordsStateModel.AddToDB
};
recordsIllnessHistoryInfoModel.RecordID = this.ArchiveID;
recordsIllnessHistoryInfoModel.IDCardNo = this.IDCard;
this.source.Add(recordsIllnessHistoryInfoModel);
}
foreach (illItem item in this.illItems)
{
if (item.Info == null)
{
if (!string.IsNullOrEmpty(inputString))
{
if (recordsIllnessHistoryInfoModel.IllnessName == "6")
{
recordsIllnessHistoryInfoModel.Therioma = inputString;
}
if (recordsIllnessHistoryInfoModel.IllnessName == "12")
{
recordsIllnessHistoryInfoModel.JobIllness = inputString;
}
if (recordsIllnessHistoryInfoModel.IllnessName == "13")
{
recordsIllnessHistoryInfoModel.IllnessOther = inputString;
}
}
item.Info = recordsIllnessHistoryInfoModel;
break;
}
}
if (this.illItems.Count <illItem>(h => (h.Info != null)) == 6)
{
foreach (CheckBox box2 in this.cks)
{
if (!box2.Checked && (box2.Name != this.c1.Name))
{
box2.Enabled = false;
}
}
}
}
}
public bool Update(RecordsIllnessHistoryInfoModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("UPDATE ARCHIVE_ILLNESSHISTORYINFO SET ");
builder.Append("RecordID=@RecordID,");
builder.Append("IDCardNo=@IDCardNo,");
builder.Append("IllnessType=@IllnessType,");
builder.Append("IllnessName=@IllnessName,");
builder.Append("Therioma=@Therioma,");
builder.Append("IllnessOther=@IllnessOther,");
builder.Append("JobIllness=@JobIllness,");
builder.Append("IllnessNameOther=@IllnessNameOther,");
builder.Append("DiagnoseTime=@DiagnoseTime");
builder.Append("IllnessResult=@IllnessResult");
builder.Append("Unite=@Unite");
builder.Append("OccurTime=@OccurTime");
builder.Append("EndTime=@EndTime");
builder.Append("Remarks=@Remarks");
builder.Append("DateSorce=@DateSorce");
builder.Append("Dose=@Dose");
builder.Append("IllDescription=@IllDescription");
builder.Append(" WHERE ID=@ID");
MySqlParameter[] cmdParms = new MySqlParameter[]
{
new MySqlParameter("@RecordID", MySqlDbType.String, 100),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@IllnessType", MySqlDbType.String, 1),
new MySqlParameter("@IllnessName", MySqlDbType.String, 100),
new MySqlParameter("@Therioma", MySqlDbType.String, 100),
new MySqlParameter("@IllnessOther", MySqlDbType.String, 100),
new MySqlParameter("@JobIllness", MySqlDbType.String, 100),
new MySqlParameter("@IllnessNameOther", MySqlDbType.String, 100),
new MySqlParameter("@DiagnoseTime", MySqlDbType.Date),
new MySqlParameter("@IllnessResult", MySqlDbType.String, 100),
new MySqlParameter("@Unite", MySqlDbType.String, 100),
new MySqlParameter("@OccurTime", MySqlDbType.String, 100),
new MySqlParameter("@EndTime", MySqlDbType.String, 100),
new MySqlParameter("@Remarks", MySqlDbType.String, 100),
new MySqlParameter("@DateSorce", MySqlDbType.String, 100),
new MySqlParameter("@Dose", MySqlDbType.Decimal),
new MySqlParameter("@IllDescription", MySqlDbType.String, 100),
new MySqlParameter("@ID", MySqlDbType.Int32, 8)
};
cmdParms[0].Value = model.RecordID;
cmdParms[1].Value = model.IDCardNo;
cmdParms[2].Value = model.IllnessType;
cmdParms[3].Value = model.IllnessName;
cmdParms[4].Value = model.Therioma;
cmdParms[5].Value = model.IllnessOther;
cmdParms[6].Value = model.JobIllness;
cmdParms[7].Value = model.IllnessNameOther;
cmdParms[8].Value = model.DiagnoseTime;
cmdParms[9].Value = model.IllnessResult;
cmdParms[10].Value = model.Unite;
cmdParms[11].Value = model.OccurTime;
cmdParms[12].Value = model.EndTime;
cmdParms[13].Value = model.Remarks;
cmdParms[14].Value = model.DateSorce;
cmdParms[15].Value = model.Dose;
cmdParms[16].Value = model.IllDescription;
cmdParms[17].Value = model.ID;
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
