def insert(self,drug): sql = "INSERT INTO tb_drug(name,chengfen,zhuzhi,yongliang,buliang,jingji,zhuyi,xianghu,chucang,youxiaoqi,piwen,gongsi,jb,chufang,zhongxi,yibao,changuo,img) \ VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" % \ (drug.name,drug.chengfen,drug.zhuzhi,drug.yongliang,drug.buliang ,drug.jingji,drug.zhuyi,drug.xianghu,drug.chucang,drug.youxiaoqi ,drug.piwen,drug.gongsi,drug.jb,drug.chufang,drug.zhongxi,drug.yibao,drug.changuo,drug.img) sqlbase = Sqlbase() sqlbase.execute(sql)
def insert(self, disease): sql = "INSERT INTO tb_disease(name,buwei,keshi,yongyao,question,anwser,binyin,zhengzhuang,jiancha,yufang,zhiliao,jianbie,binfazheng,img) \ VALUES ('%s', '%s','%s', '%s','%s', '%s','%s', '%s','%s', '%s','%s', '%s','%s', '%s')" % \ (disease.name,disease.buwei,disease.keshi,disease.yongyao,disease.question, disease.anwser,disease.binyin,disease.zhengzhuang,disease.jiancha, disease.yufang,disease.zhiliao,disease.jianbie,disease.binfazheng,disease.img) sqlbase = Sqlbase() sqlbase.execute(sql)
def insert(self, hospital): sql = "INSERT INTO tb_hos(hosName,isAuth,level,manage,img,tele,addr,alias,type,sorce,info,dean,year,personnum,bednum,yearoutpnum,isinsurance,keshi) \ VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s','%s','%s','%s')" % \ (hospital.hosName,hospital.isAuth,hospital.level,hospital.manage,hospital.img ,hospital.tele,hospital.addr,hospital.alias,hospital.type,hospital.sorce ,hospital.info,hospital.dean,hospital.year,hospital.personnum,hospital.bednum ,hospital.yearoutpnum,hospital.isinsurance,hospital.keshi) sqlbase = Sqlbase() sqlbase.execute(sql)
def insert(self, keshi): sql = "INSERT INTO tb_keshi(one,two) \ VALUES ('%s', '%s')" % \ (keshi.one,keshi.two) sqlbase = Sqlbase() sqlbase.execute(sql)
def insert(self,doctor): sql = "INSERT INTO tb_doctor(name,zc,hospital,ks,jxzc,xzzc,xw,sc,introduction,honor,paper,url,tel,fax,zipcode,email,addr,imgurl) \ VALUES ('%s', '%s','%s', '%s','%s', '%s','%s', '%s','%s', '%s','%s', '%s','%s', '%s','%s', '%s','%s','%s')" % \ (doctor.name,doctor.zc,doctor.hospital,doctor.ks,doctor.jxzc,doctor.xzzc,doctor.xw,doctor.sc,doctor.introduction,doctor.honor,doctor.paper,doctor.url,doctor.tel,doctor.fax,doctor.zipcode,doctor.email,doctor.addr,doctor.imgurl) sqlbase = Sqlbase() sqlbase.execute(sql)
def insert(self, addr): sql = "INSERT INTO tb_addr(provice,city,area) \ VALUES ('%s','%s','%s')" % \ (addr.provice,addr.city,addr.area) sqlbase = Sqlbase() sqlbase.execute(sql)
def insert(self, code): sql = "INSERT INTO tb_doctor_log(code) \ VALUES ('%s')" % \ (code) sqlbase = Sqlbase() sqlbase.execute(sql)