/// <summary>
/// 插入
/// </summary>
/// <param name="zz"></param>
public void Insert(TjGyzz zz, List <string> sqls)
{
sql = new StringBuilder("insert into tj_zyb_gyzz(tjbh,tjcs,zxcns,zxcxs,jynxcxs,one,two,three,four,five,six,senven,eight,"
+ "night,ten,tenone,tentwo,tenthree,tenfour,tenfive,tensix,tensenven,teneight,tennight,twenty,twentyone,twentytwo,twentythree,"
+ "twentyfour,twentyfive,twentysix,twentysenven,twentyeight,twentynight,threeten,threeone,threetwo,threethree,threefour,threefive,"
+ "threesix,threesenven,threeeight,threenight) values('");
sql.Append(zz.tjbh + "','");
sql.Append(zz.tjcs + "','");
sql.Append(zz.zxcns + "','");
sql.Append(zz.zxcxs + "','");
sql.Append(zz.jynxcxs + "','");
sql.Append(zz.one + "','");
sql.Append(zz.two + "','");
sql.Append(zz.three + "','");
sql.Append(zz.four + "','");
sql.Append(zz.five + "','");
sql.Append(zz.six + "','");
sql.Append(zz.senven + "','");
sql.Append(zz.eight + "','");
sql.Append(zz.night + "','");
sql.Append(zz.ten + "','");
sql.Append(zz.tenone + "','");
sql.Append(zz.tentwo + "','");
sql.Append(zz.tenthree + "','");
sql.Append(zz.tenfour + "','");
sql.Append(zz.tenfive + "','");
sql.Append(zz.tensix + "','");
sql.Append(zz.tensenven + "','");
sql.Append(zz.teneight + "','");
sql.Append(zz.tennight + "','");
sql.Append(zz.twenty + "','");
sql.Append(zz.twentyone + "','");
sql.Append(zz.twentytwo + "','");
sql.Append(zz.twentythree + "','");
sql.Append(zz.twentyfour + "','");
sql.Append(zz.twentyfive + "','");
sql.Append(zz.twentysix + "','");
sql.Append(zz.twentysenven + "','");
sql.Append(zz.twentyeight + "','");
sql.Append(zz.twentynight + "','");
sql.Append(zz.threeten + "','");
sql.Append(zz.threeone + "','");
sql.Append(zz.threetwo + "','");
sql.Append(zz.threethree + "','");
sql.Append(zz.threefour + "','");
sql.Append(zz.threefive + "','");
sql.Append(zz.threesix + "','");
sql.Append(zz.threesenven + "','");
sql.Append(zz.threeeight + "','");
sql.Append(zz.threenight + "')");
sqls.Add(sql.ToString());
}
/// <summary>
/// 保存健康档案
/// </summary>
/// <param name="ryxx">人员信息</param>
/// <param name="sqls"></param>
/// <returns></returns>
public int SaveJkda(TjZybRyxx ryxx, TjZybZz zz, TjGyzz gyzz, TjZybGqf gqf)
{
List <string> sqls = sqls = new List <string>();
if (HasExist(ryxx.Tjbh, ryxx.Tjcs))
{
Update(ryxx, sqls);
}
else
{
InsertRyxx(ryxx, sqls);
}
TjZybZzBiz zzBiz = new TjZybZzBiz();
if (zzBiz.HasExist(zz.tjbh, zz.tjcs))
{
zzBiz.Update(zz, sqls);
}
else
{
zzBiz.Insert(zz, sqls);
}
TjGyzzBiz gyzzBiz = new TjGyzzBiz();
gyzzBiz.Delete(gyzz.tjbh, gyzz.tjcs, sqls);
gyzzBiz.Insert(gyzz, sqls);
TjZybGqfBiz gqfBiz = new TjZybGqfBiz();
if (gqfBiz.HasExist(gqf.tjbh))
{
gqfBiz.Update(gqf, sqls);
}
else
{
gqfBiz.Insert(gqf, sqls);
}
return(base.SqlDBAgent.sqlupdate(sqls));
}
