/// <summary>
/// 查询更新记录列表
/// </summary>
/// <param name="sqls"></param>
/// <returns></returns>
public ArrayList getUpdateVersionList(string sqls)
{
SqlDataReader drs = null;
ArrayList updatelist = new ArrayList();
try
{
drs = dg.executequery(sqls);
while (drs.Read())
{
UpdateVersionobj updateobj = new UpdateVersionobj();
updateobj.id = Convert.ToInt32(drs["id"]);
updateobj.version = drs["version"].ToString();
updateobj.updatetime = drs["updatetime"].ToString();
updateobj.updatecontent = drs["updatecontent"].ToString();
updateobj.isfabu = Convert.ToInt32(drs["isfabu"]);
updatelist.Add(updateobj);
}
}
catch (Exception ex)
{
MessageBox.Show("统计异常", "软件提示");
throw ex;
}
finally
{
drs.Close();
dg.con_close();
}
return(updatelist);
}
public bool ifhascount(string sqls)
{
DateLogic dg = new DateLogic();
SqlDataReader drs = null;
try
{
drs = dg.executequery(sqls);
if (drs.HasRows)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
drs.Close();
dg.con_close();
}
}
//打印获取打印坐标
public List <PointF> getchildcheckPrint(string sqls)
{
SqlDataReader sdr = null;
List <PointF> pointlist = new List <PointF>();
//pointlist.Add(new PointF(61, 815));//其实坐标
List <ChildCheckObj> checkrows = new List <ChildCheckObj>();
try
{
sdr = dg.executequery(sqls);
while (sdr.Read())
{
ChildCheckObj obj = new ChildCheckObj();
obj.Id = Convert.ToInt32(sdr["id"]);
obj.ChildId = Convert.ToInt32(sdr["childId"]);
obj.CheckHeight = sdr["checkHeight"].ToString();
obj.CheckWeight = sdr["checkWeight"].ToString();
checkrows.Add(obj);
}
if (checkrows.Count > 0)
{
//decimal weight1 = checkrows[0].CheckWeight;//孕妇的孕前体重
for (int i = 0; i < checkrows.Count; i++)
{
if (checkrows[i].CheckWeight == "" || checkrows[i].CheckHeight == "")
{
continue;
}
// decimal weight2 = checkrows[i].wm_weight;//体重
//int w = checkrows[i].CheckWeight.ToString();
//int d = Convert.ToInt32(checkrows[i].CheckHeight);
string ystr = checkrows[i].CheckWeight.ToString();
string xstr = checkrows[i].CheckHeight.ToString();
float y = 830 - (float.Parse(ystr) - 1) * 20;
float x = (float.Parse(xstr) - 45) * 10 + 65;
PointF point = new PointF(x, y);
pointlist.Add(point);
//weight1 = fucharows[i].wm_weight;
}
}
}
catch (Exception ex)
{
MessageBox.Show("统计异常", "软件提示");
throw ex;
}
finally
{
sdr.Close();
dg.con_close();
}
return(pointlist);
}
