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,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 exist_hos(self, code):
sql = "select * from tb_hos_log where code=" + code
sqlbase = Sqlbase()
flag = False
if sqlbase.select(sql) != 0:
flag = True
return flag
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)