/// <summary>
/// 查询儿童体检信息 返回集合
/// </summary>
/// <param name="sqls"></param>
/// <returns></returns>
public ArrayList getSetCheckAgeList(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();//读取第一行数据记录
childSetCheckAgeObj obj = new childSetCheckAgeObj();
obj.Id = Convert.ToInt32(sdr["id"]);
//obj.ChildId = Convert.ToInt32(sdr["childId"]);
obj.CheckMonth = sdr["checkMonth"].ToString();
obj.CheckContent = sdr["checkContent"].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();
childSetCheckAgeObj obj = new childSetCheckAgeObj();
if (state == 1)
{
obj.CheckContent = "体检";
}
else if (state == 2)
{
obj.CheckContent = "不体检";
}
builder.Append("update tb_setcheckAge set ");
builder.Append("checkContent='" + obj.CheckContent + "',");
builder.Append("isCheck=" + state + "");
builder.Append(" where id=" + rowId + "");
return(builder.ToString());
}
