/// <summary> /// 查询儿童体检信息 返回集合 /// </summary> /// <param name="sqls"></param> /// <returns></returns> public ArrayList getSetmianyiAgeList(string sqls) { DateLogic dg = new DateLogic(); SqlDataReader sdr = null; ArrayList arraylist = new ArrayList();; try { sdr = dg.executequery(sqls); if (!sdr.HasRows) { return(null); } else { while (sdr.Read()) { //sdr.Read();//读取第一行数据记录 childSetMianyiAgeObj obj = new childSetMianyiAgeObj(); obj.Id = Convert.ToInt32(sdr["id"]); //obj.ChildId = Convert.ToInt32(sdr["childId"]); obj.MianyiMonth = sdr["mianyiMonth"].ToString(); obj.MianyiContent = sdr["mianyiContent"].ToString(); obj.IsCheck = Convert.ToInt32(sdr["isCheck"]); arraylist.Add(obj); } } } catch (Exception ex) { MessageBox.Show("系统异常,请联系管理员", "软件提示"); throw ex; } return(arraylist); }
/// <summary> /// 修改 是否免疫 /// </summary> private string updateCheckAge(int _rowId, int state) { StringBuilder builder = new StringBuilder(); childSetMianyiAgeObj obj = new childSetMianyiAgeObj(); if (state == 1) { obj.MianyiContent = "免疫"; } else if (state == 2) { obj.MianyiContent = "不免疫"; } builder.Append("update tb_mianyiAge set "); builder.Append("mianyiContent='" + obj.MianyiContent + "',"); builder.Append("isCheck=" + state + ""); builder.Append(" where id=" + rowId + ""); return(builder.ToString()); }