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