public void zlzkInit() { xml = ""; TransNo = "0805"; string xqsql = " select k.FPX as 'yzy201',k.FHLRQ1 as 'yzy265',k.FHLDRUG as 'yzy266',k.FHLPROC as 'yzy267',k.FHLLXBH as 'yzy268',k.FHLLX as 'yzy269' from [TKNUBHL] k where k.FPRN = '" + bahm + "'"; string flsql = "select k.FFLFSBH as 'yzy239',k.FFLFS as 'yzy240',k.FFLCXBH as 'yzy241',k.FFLCX as 'yzy242',k.FFLZZBH as 'yzy243',k.FFLZZ as 'yzy244',k.FYJY as 'yzy245'," + "k.FYCS as 'yzy246',k.FYTS as 'yzy247',k.FYRQ1 as 'yzy248',k.FYRQ2 as 'yzy249',k.FQJY as 'yzy250',k.FQCS as 'yzy251',k.FQTS as 'yzy252'," + "k.FQRQ1 as 'yzy253',k.FQRQ2 as 'yzy254',k.FZNAME as 'yzy255',k.FZJY as 'yzy256',k.FZCS as 'yzy257',k.FZTS as 'yzy258',k.FZRQ1 as 'yzy259'," + "k.FZRQ2 as 'yzy260',k.FHLFSBH as 'yzy261',k.FHLFS as 'yzy262',k.FHLFFBH as 'yzy263',k.FHLFF as 'yzy264'" + "from[TKNUBCARD] k where k.FPRN = '" + bahm + "'"; dtcjDVG(xqsql, zldt); baDBConn con = new baDBConn(); zldt = con.GetDataSet(flsql).Tables[0]; if (zldt.Rows.Count > 0) { Button btn1 = new Button(); btn1.Location = new System.Drawing.Point(641, 503); btn1.Name = "btn1"; btn1.Size = new System.Drawing.Size(93, 40); btn1.TabIndex = 4; btn1.Text = "详情资料"; btn1.UseVisualStyleBackColor = true; btn1.Click += new EventHandler(btn1_Click); } }
public void ckfmxxInit() { xml = ""; TransNo = "0804"; baDBConn conn = new baDBConn(); string sql = " select b.FBABYNUM as 'yzy201',b.FBABYSEXBH as 'aac004',b.FBABYSEX as 'yzy230',b.FTZ as 'yzy231',b.FRESULTBH as 'yzy232',b.FRESULT as 'yzy233',b.FZGBH as 'yzy234'," + "b.FZG as 'yzy235' , isnull(b.FBABYSUC, '0') as 'yzy236',b.FHXBH as 'yzy237',b.FHX as 'yzy238'" + "from[TBABYCARD] b where b.FPRN = '" + bahm + "'"; dtcjDVG(sql, null); }
public void brxxInit() { xml = ""; TransNo = "0801"; //string sql = " select BAHM from zy_brry where ZYHM = '" + gx.akc190 + "'"; //hisDBConn hdb = new hisDBConn(); //DataTable dt = hdb.GetDataSet(sql).Tables[0]; //if (dt.Rows.Count > 0) //{ // bahm = dt.Rows[0][0].ToString(); //} bahm = gx.akc190; if (bahm == "") { return; } string sql1 = "SELECT t.FPRN as 'yzy001',t.FTIMES as 'yzy002',t.FICDVERSION as 'yzy003',t.FID as 'yzy004',t.FAGE as 'akc023',t.FNAME as 'aac003',t.FSEXBH as 'aac004',t.FSEX as 'yzy008'," + "t.FBIRTHDAY as 'aac006' ,t.FBIRTHPLACE as 'yzy010', t.FIDCARD as 'yzy011' ,t.FCOUNTRYBH as 'aac161',t.FCOUNTRY as 'yzy013',t.FNATIONALITYBH as 'aac005',t.FNATIONALITY as 'yzy015'," + "t.FJOB as 'yzy016',t.FSTATUSBH as 'aac017',t.FSTATUS as 'yzy018',t.FDWNAME as 'aab004',t.fdwaddr as 'yzy020',t.FDWTELE as 'yzy021',t.FDWPOST as 'yzy022'," + "t.fhkaddr as 'aac010',t.FHKPOST as 'yzy024',t.FLXNAME as 'aae004',t.FRELATE as 'yzy026',t.flxaddr as 'yzy027',t.FLXTELE as 'yzy028',t.FASCARD1 as 'yzy029'," + "t.FRYDATE as 'ykc701',t.FRYTYKH as 'yzy032',t.FRYDEPT as 'yzy033',t.FRYBS as 'yzy034',t.FCYDATE as 'ykc702',t.FCYTYKH as 'yzy037',t.FCYDEPT as 'yzy038'," + "t.FCYBS as 'yzy039',t.FDAYS as 'akb063',t.FMZZDBH as 'akc193',t.FMZZD as 'akc050',t.FMZDOCTBH as 'yzy043',t.FMZDOCT as 'ake022',t.FPHZD as 'yzy045'," + "t.FGMYW as 'yzy046',t.FQJTIMES as 'yzy047', isnull(t.FQJSUCTIMES, '0') as 'yzy048',t.FKZRBH as 'yzy049',t.FKZR as 'yzy050',t.FZRDOCTBH as 'yzy051'," + "t.FZRDOCTOR as 'yzy052',t.FZZDOCTBH as 'yzy053',t.FZZDOCT as 'yzy054',t.FZYDOCTBH as 'yzy055',t.FZYDOCT as 'yzy056',t.FJXDOCTBH as 'yzy057',t.FJXDOCT as 'yzy058'," + "t.FSXDOCTBH as 'yzy059',t.FSXDOCT as 'yzy060',t.FBMYBH as 'yzy061',t.FBMY as 'yzy062',t.FQUALITYBH as 'yzy063',t.FQUALITY as 'yzy064',t.FZKDOCTBH as 'yzy065'," + "t.FZKDOCT as 'yzy066',t.FZKNURSE as 'yzy067',t.FZKNURSE as 'yzy068',t.FZKRQ as 'yzy069',t.FSUM1 as 'akc264',t.FXYF as 'ake047',t.FZYF as 'yzy072'," + "t.FZCHYF as 'ake050',t.FZCYF as 'ake049',t.FQTF as 'ake044',Isnull(t.FBODYBH,'2') as 'yzy076',Isnull(t.FBODY,'否') as 'yzy077',t.FBLOODBH as 'yzy078',t.FBLOOD as 'yzy079'," + "t.FRHBH as 'yzy080',t.FRH as 'yzy081',t.FZKTYKH as 'yzy082',t.FZKDEPT as 'yzy083',t.FZKDATE as 'yzy084',t.FZKTIME as 'yzy085',t.FJBFXBH as 'yzy086'," + "t.FJBFX as 'yzy087',t.FNATIVE as 'yzy088',t.fcurraddr as 'yzy089',t.FCURRTELE as 'yzy090',t.FCURRPOST as 'yzy091',t.FJOBBH as 'aca111',t.FCSTZ as 'yzy093'," + "t.FRYTZ as 'yzy094',t.FRYTJBH as 'yzy095',t.FRYTJ as 'yzy096',Isnull( t.FYCLJBH,'-') as 'yzy097',Isnull( t.FYCLJ,'-') as 'yzy098',Isnull( t.FPHZDBH,'-') as 'yzy099',t.FPHZDNUM as 'yzy100'," + "t.FIFGMYWBH as 'yzy101',t.FIFGMYW as 'yzy102',t.FNURSEBH as 'yzy103',t.FNURSE as 'yzy104',t.FLYFSBH as 'yzy105',t.FLYFS as 'yzy106',t.FYZOUTHOSTITAL as 'yzy107'," + "t.FSQOUTHOSTITAL as 'yzy108',t.FISAGAINRYBH as 'yzy109',t.FISAGAINRY as 'yzy110',t.FISAGAINRYMD as 'yzy111',t.FRYQHMDAYS as 'yzy112',t.FRYQHMHOURS as 'yzy113'," + "t.FRYQHMMINS as 'yzy114',t.FRYQHMCOUNTS as 'yzy115',t.FRYHMDAYS as 'yzy116',t.FRYHMHOURS as 'yzy117',t.FRYHMMINS as 'yzy118',t.FRYHMCOUNTS as 'yzy119'," + "t.FFBBHNEW as 'yzy120',t.FFBNEW as 'yzy121',t.FZFJE as 'yzy122',t.FZHFWLYLF as 'yzy123',t.FZHFWLCZF as 'yzy124',t.FZHFWLHLF as 'yzy125',t.FZHFWLQTF as 'yzy126'," + "t.FZDLBLF as 'yzy127',t.FZDLSSSF as 'yzy128',t.FZDLYXF as 'yzy129',t.FZDLLCF as 'yzy130',t.FZLLFFSSF as 'yzy131',t.FZLLFWLZWLF as 'yzy132',t.FZLLFSSF as 'yzy133'," + "t.FZLLFMZF as 'yzy134',t.FZLLFSSZLF as 'yzy135',t.FKFLKFF as 'yzy136',t.FZYLZF as 'yzy137',t.FXYLGJF as 'yzy138',t.FXYLXF as 'yzy139',t.FXYLBQBF as 'yzy140'," + "t.FXYLQDBF as 'yzy141',t.FXYLYXYZF as 'yzy142',t.FXYLXBYZF as 'yzy143',t.FHCLCJF as 'yzy144',t.FHCLZLF as 'yzy145',t.FHCLSSF as 'yzy146',t.FZHFWLYLF01 as 'yzy147'," + "t.FZHFWLYLF02 as 'yzy148',t.FZYLZDF as 'yzy149',t.FZYLZLF as 'yzy150',t.FZYLZLF01 as 'yzy151',t.FZYLZLF02 as 'yzy152',t.FZYLZLF03 as 'yzy153',t.FZYLZLF04 as 'yzy154'," + "t.FZYLZLF05 as 'yzy155',t.FZYLZLF06 as 'yzy156',t.FZYLQTF as 'yzy157',t.FZYLQTF01 as 'yzy158',t.FZYLQTF02 as 'yzy159',t.FZCLJGZJF as 'yzy160',c.FZLLBBH as 'yzy161'," + "c.FZLLB as 'yzy162',c.FMZZYZDBH as 'yzy163',c.FMZZYZD as 'yzy164',c.FSSLCLJBH as 'yzy165',c.FSSLCLJ as 'yzy166',c.FSSLCLJBH as 'yzy167',c.FSYJGZJ as 'yzy168'," + "c.FSYZYSBBH as 'yzy169',c.FSYZYSB as 'yzy170',c.FSYZYJSBH as 'yzy171',c.FSYZYJS as 'yzy172',c.FBZSHBH as 'yzy173',c.FBZSH as 'yzy174'" + "FROM [TPATIENTVISIT] t join TCHADD c on t.FPRN = c.FPRN where t.FPRN = '" + bahm + "'"; baDBConn db = new baDBConn(); DataTable xxdt = db.GetDataSet(sql1).Tables[0]; if (xxdt.Rows.Count < 1) { return; } xml = "<?xml version=\"1.0\" encoding=\"GBK\"?>" + "<input>" + "<aab299>" + PublicCommon.aab299 + "</aab299>" + "<yab600>" + PublicCommon.yab600 + "</yab600>" + "<akb026>" + PublicCommon.akb026 + "</akb026>" + "<akb021>" + PublicCommon.akb021 + "</akb021>" + "<ykc700>" + gx.ykc700 + "</ykc700>" + "<aab301>" + gx.aab301 + "</aab301>" + "<yab060>" + gx.yab060 + "</yab060>" + "<aac002>" + gx.aac002 + "</aac002>" + "<aac043>" + gx.aac043 + "</aac043>" + "<aac044>" + gx.aac044 + "</aac044>"; zybrxx zb = new zybrxx(); var pros = zb.GetType().GetProperties(); foreach (var p in pros) { xml += "<" + p.Name + ">" + sjcl(xxdt.Rows[0][p.Name].ToString(), p.Name) + "</" + p.Name + ">"; p.SetValue(zb, xxdt.Rows[0][p.Name].ToString(), null); } xml += "</input>"; Addkj(zb); }
public DataTable dtcjDVG(string sql, DataTable lsdt) { DataGridView dg = new DataGridView(); dg.AllowUserToAddRows = false; dg.AllowUserToDeleteRows = false; dg.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.AllCells; dg.AutoSizeRowsMode = System.Windows.Forms.DataGridViewAutoSizeRowsMode.AllCells; dg.BackgroundColor = System.Drawing.Color.White; dg.CellBorderStyle = System.Windows.Forms.DataGridViewCellBorderStyle.None; dg.GridColor = System.Drawing.Color.White; dg.Location = new System.Drawing.Point(12, 118); dg.MultiSelect = false; dg.Name = "dataGridView1"; dg.RowTemplate.Height = 23; dg.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect; dg.Dock = System.Windows.Forms.DockStyle.Fill; dg.RowHeadersVisible = false; dg.AllowUserToResizeRows = false; dg.ReadOnly = true; baDBConn bdb = new baDBConn(); DataTable dt = bdb.GetDataSet(sql).Tables[0]; DataColumnCollection dcc = dt.Columns; Dictionary <string, string> cns = new Dictionary <string, string>(); foreach (DataColumn d in dcc) { foreach (var q in qj.zd) { if (q.Key == d.ColumnName) { cns.Add(q.Key, q.Value); } } } //病案xml 批量生成 xml = "<?xml version=\"1.0\" encoding=\"GBK\"?>" + "<input>" + "<aab299>" + PublicCommon.aab299 + "</aab299>" + "<yab600>" + PublicCommon.yab600 + "</yab600>" + "<akb026>" + PublicCommon.akb026 + "</akb026>" + "<akb021>" + PublicCommon.akb021 + "</akb021>" + "<ykc700>" + gx.ykc700 + "</ykc700>" + "<aab301>" + gx.aab301 + "</aab301>" + "<yab060>" + gx.yab060 + "</yab060>" + "<aac002>" + gx.aac002 + "</aac002>" + "<aac043>" + gx.aac043 + "</aac043>" + "<aac044>" + gx.aac044 + "</aac044>"; if (lsdt != null) { foreach (DataColumn d in lsdt.Columns) { xml += "<" + d.ColumnName + ">" + lsdt.Rows[0][d.ColumnName].ToString() + "</" + d.ColumnName + ">"; } } foreach (DataColumn d in dt.Columns) { if (d.ColumnName == "yzy003") { xml += "<" + d.ColumnName + ">" + dt.Rows[0][d.ColumnName].ToString() + "</" + d.ColumnName + ">"; } } xml += "<detail>"; foreach (DataRow d in dt.Rows) { xml += "<row>"; foreach (DataColumn dc in dt.Columns) { if (dc.ColumnName == "yzy003") { continue; } xml += "<" + dc.ColumnName + ">" + sjcl(d[dc.ColumnName].ToString(), dc.ColumnName) + "</" + dc.ColumnName + ">"; } xml += "</row>"; } xml += "</detail></input>"; foreach (var c in cns) { DataGridViewTextBoxColumn dgt = new DataGridViewTextBoxColumn(); dgt.DataPropertyName = c.Key; dgt.HeaderText = c.Value; dgt.Name = c.Key; dgt.ReadOnly = true; dgt.Width = 110; dg.Columns.Add(dgt); } dg.DataSource = dt; panel1.Controls.Clear(); panel1.Controls.Add(dg); return(dt); }