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