コード例 #1
0
        /// <summary>
        /// 插入职业病人员信息
        /// </summary>
        /// <param name="ryxx"></param>
        /// <param name="sqls"></param>
        public void InsertRyxx(TjZybRyxx ryxx, List <string> sqls)
        {
            sql = new StringBuilder("insert into TJ_ZYB_RYXX(TJBH,TJCS,XM,XB,mz,SFZH,CSNYR,csd,DW,DWDH,dwdz,gz,GH,BH,zgl,jsgl,ygzdwjgz,zybwhjcs,TBRQ,LX,dhqk,hy,jtbs,JWS,BM,ZDRQ,ZDDW,SFQY,CCNL,JQ,ZQ,TJNL,XYZN,"
                                    + "LCCS,ZCCS,SCCS,YCTC,SFXY,xysl,XYNS,SFYJ,YJSL,YJSJ,wjh,zyjcs,lcbx,xysjcjg,zdbz,zdjl,clyj,QT) values('");
            sql.Append(ryxx.Tjbh + "','");
            sql.Append(ryxx.Tjcs + "','");
            sql.Append(ryxx.Xm + "','");
            sql.Append(ryxx.Xb + "','");
            sql.Append(ryxx.Mz + "','");
            sql.Append(ryxx.Sfzh + "','");
            sql.Append(ryxx.Csnyr + "','");
            sql.Append(ryxx.Csd + "','");
            sql.Append(ryxx.Dw + "','");
            sql.Append(ryxx.Dwdh + "','");
            sql.Append(ryxx.Dwdz + "','");
            sql.Append(ryxx.Gz + "','");
            sql.Append(ryxx.Gh + "','");
            sql.Append(ryxx.Bh + "','");
            sql.Append(ryxx.Zgl + "','");
            sql.Append(ryxx.Jsgl + "','");
            sql.Append(ryxx.Ygzdwjgz + "','");
            sql.Append(ryxx.Zybwhjcs + "','");
            sql.Append(ryxx.Tbrq + "','");
            sql.Append(ryxx.Lx + "','");
            sql.Append(ryxx.Dhqk + "','");
            sql.Append(ryxx.Hy + "','");
            sql.Append(ryxx.Jtbs + "','");
            sql.Append(ryxx.Jws + "','");
            sql.Append(ryxx.Bm + "','");
            sql.Append(ryxx.Zdrq + "','");
            sql.Append(ryxx.Zddw + "','");
            sql.Append(ryxx.Sfqy + "','");
            sql.Append(ryxx.Ccnl + "','");
            sql.Append(ryxx.Jq + "','");
            sql.Append(ryxx.Zq + "','");
            sql.Append(ryxx.Tjnl + "','");
            sql.Append(ryxx.Xyzn + "','");
            sql.Append(ryxx.Lccs + "','");
            sql.Append(ryxx.Zccs + "','");
            sql.Append(ryxx.Sccs + "','");
            sql.Append(ryxx.Yctc + "','");
            sql.Append(ryxx.Sfxy + "','");
            sql.Append(ryxx.Xysl + "','");
            sql.Append(ryxx.Xyns + "','");
            sql.Append(ryxx.Sfyj + "','");
            sql.Append(ryxx.Yjsl + "','");
            sql.Append(ryxx.Yjsj + "','");
            //wjh,zyjcs,lcbx,xysjcjg,zdbz,zdjl,clyj
            sql.Append(ryxx.Wjh + "','");
            sql.Append(ryxx.Zyjcs + "','");
            sql.Append(ryxx.Lcbx + "','");
            sql.Append(ryxx.Xysjcjg + "','");
            sql.Append(ryxx.Zdbz + "','");
            sql.Append(ryxx.Zdjl + "','");
            sql.Append(ryxx.Clyj + "','");
            sql.Append(ryxx.Qt + "')");

            sqls.Add(sql.ToString());
        }
コード例 #2
0
        /// <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));
        }
コード例 #3
0
        /// <summary>
        /// 更新职业病人员信息
        /// </summary>
        /// <param name="ryxx"></param>
        /// <param name="sqls"></param>
        public void Update(TjZybRyxx ryxx, List <string> sqls)
        {
            sql = new StringBuilder("update TJ_ZYB_RYXX set xm='" + ryxx.Xm + "'");
            //TJBH,TJCS,
            //,,,,,,,,,,,,,,,,,,,

            sql.Append(",xb='" + ryxx.Xb + "'");
            sql.Append(",mz='" + ryxx.Mz + "'");
            //sql.Append(",SFZH='" + ryxx.Sfzh + "'");
            sql.Append(",CSNYR='" + ryxx.Csnyr + "'");
            sql.Append(",csd='" + ryxx.Csd + "'");
            sql.Append(",DW='" + ryxx.Dw + "'");
            sql.Append(",DWDH='" + ryxx.Dwdh + "'");
            sql.Append(",dwdz='" + ryxx.Dwdz + "'");
            sql.Append(",gz='" + ryxx.Gz + "'");
            sql.Append(",GH='" + ryxx.Gh + "'");
            sql.Append(",BH='" + ryxx.Bh + "'");
            sql.Append(",zgl='" + ryxx.Zgl + "'");
            sql.Append(",jsgl='" + ryxx.Jsgl + "'");
            sql.Append(",ygzdwjgz='" + ryxx.Ygzdwjgz + "'");
            sql.Append(",zybwhjcs='" + ryxx.Zybwhjcs + "'");
            sql.Append(",TBRQ='" + ryxx.Tbrq + "'");
            sql.Append(",LX='" + ryxx.Lx + "'");
            sql.Append(",dhqk='" + ryxx.Dhqk + "'");
            sql.Append(",jtbs='" + ryxx.Jtbs + "'");
            sql.Append(",JWS='" + ryxx.Jws + "'");
            sql.Append(",LCCS='" + ryxx.Lccs + "'");
            sql.Append(",ZCCS='" + ryxx.Zccs + "'");
            sql.Append(",SCCS='" + ryxx.Sccs + "'");
            //,,,,,,,,,,,,,,,,,,,,
            sql.Append(",YCTC='" + ryxx.Yctc + "'");
            sql.Append(",SFXY='" + ryxx.Sfxy + "'");
            sql.Append(",xysl='" + ryxx.Xysl + "'");
            sql.Append(",XYNS='" + ryxx.Xyns + "'");
            sql.Append(",SFYJ='" + ryxx.Sfyj + "'");
            sql.Append(",YJSL='" + ryxx.Yjsl + "'");
            sql.Append(",YJSJ='" + ryxx.Yjsj + "'");
            sql.Append(",QT='" + ryxx.Qt + "'");
            sql.Append(",BM='" + ryxx.Bm + "'");
            sql.Append(",ZDRQ='" + ryxx.Zdrq + "'");
            sql.Append(",ZDDW='" + ryxx.Zddw + "'");
            sql.Append(",SFQY='" + ryxx.Sfqy + "'");
            sql.Append(",CCNL='" + ryxx.Ccnl + "'");
            sql.Append(",JQ='" + ryxx.Jq + "'");
            sql.Append(",ZQ='" + ryxx.Zq + "'");
            sql.Append(",TJNL='" + ryxx.Tjnl + "'");
            sql.Append(",XYZN='" + ryxx.Xyzn + "'");
            //,,,,,,
            //sql.Append(",hy='" + ryxx.Hy + "'");
            sql.Append(",wjh='" + ryxx.Wjh + "'");
            sql.Append(",zyjcs='" + ryxx.Zyjcs + "'");
            sql.Append(",lcbx='" + ryxx.Lcbx + "'");
            sql.Append(",xysjcjg='" + ryxx.Xysjcjg + "'");
            sql.Append(",zdbz='" + ryxx.Zdbz + "'");
            sql.Append(",zdjl='" + ryxx.Zdjl + "'");
            sql.Append(",clyj='" + ryxx.Clyj + "'");

            sql.Append(" where tjbh='" + ryxx.Tjbh + "' and tjcs='" + ryxx.Tjcs + "'");

            sqls.Add(sql.ToString());
        }