void ProcessData() { if (!m_dataCT.Columns.Contains("NamQT")) { m_dataCT.Columns.Add("NamQT", typeof(string), dtpToDate.Value.Year.ToString()); } if (!m_dataCT.Columns.Contains("ThangQT")) { m_dataCT.Columns.Add("ThangQT", typeof(string), dtpToDate.Value.Month.ToString()); } if (!m_dataCT.Columns.Contains("LoaiKCB")) { m_dataCT.Columns.Add("LoaiKCB", typeof(string)); } if (!m_dataCT.Columns.Contains("NoiTT")) { m_dataCT.Columns.Add("NoiTT", typeof(string)); } if (!m_dataCT.Columns.Contains("DoiTuong")) { m_dataCT.Columns.Add("DoiTuong", typeof(string)); } string sInsCityCode = globalVariables.gv_strNoicapBHYT; string sClinicCode = globalVariables.gv_strNoiDKKCBBD; foreach (DataRow row in m_dataCT.Rows) { if (Utility.DoTrim(row[KcbLuotkham.Columns.MatheBhyt].ToString()) != "") { if (row[KcbLuotkham.Columns.NoiDongtrusoKcbbd].ToString() == sInsCityCode) { if (row[KcbLuotkham.Columns.MaKcbbd].ToString() == sClinicCode) { row["DoiTuong"] = "A. BỆNH NHÂN ĐĂNG KÝ KCB BAN ĐẦU TẠI CƠ SỞ KCB"; } else { row["DoiTuong"] = "B. BỆNH NHÂN NỘI TỈNH KHÔNG KCB BAN ĐẦU TẠI CƠ SỞ KCB"; } } else { row["DoiTuong"] = "C. BỆNH NHÂN NGOẠI TỈNH ĐIỀU TRỊ TẠI CƠ SỞ KCB"; } } else { row["DoiTuong"] = "D. BỆNH NHÂN KHÁC"; } if (string.IsNullOrEmpty(Utility.DoTrim(row["ten_nhom_bhyt"].ToString()))) { row["ten_nhom_bhyt"] = "Dịch vụ"; } row["NoiTT"] = "CSKCB"; row["LoaiKCB"] = "Ngoại"; UIAction.SetValue4Prg(prgBar, 1); } m_dataCT.AcceptChanges(); }
private void cmdExportXML_Click(object sender, EventArgs e) { try { // var xmlWriterSettings = new XmlWriterSettings() // { // Indent = true, // IndentChars = "\t" // //NewLineOnAttributes = true // }; // xmlWriter = XmlWriter.Create("C:\\abc.xml", xmlWriterSettings); //// xmlWriter.WriteProcessingInstruction("xml", string.Format("version={0}1.0{0} encoding={0}UTF-8{0} standalone={0}yes{0}", ((char)34))); // xmlWriter.WriteStartElement("CHECKOUT"); // xmlWriter.WriteStartElement("CHECKOUT1"); // xmlWriter.WriteStartElement("CHECKOUT2"); // xmlWriter.WriteElementString("a", "aaa"); // xmlWriter.WriteElementString("b", "bbb"); // xmlWriter.WriteElementString("c", "ccc"); // xmlWriter.WriteElementString("d", "ddd"); // xmlWriter.WriteEndElement(); // xmlWriter.Flush(); // this.UseWaitCursor = true; int i = 0; Utility.ResetProgressBar(progressBar, grdList.RowCount, true); foreach (GridEXRow row in grdList.GetCheckedRows()) { string maluotKham = Utility.sDbnull(row.Cells["ma_luotkham"].Value); int idBenhnhan = Utility.Int32Dbnull(row.Cells["id_benhnhan"].Value); bool kt = ProcessCreateXml(maluotKham, idBenhnhan); if (kt) { new Update(KcbPhieuDct.Schema).Set(KcbPhieuDct.Columns.TrangthaiXml).EqualTo(1).Where( KcbPhieuDct.Columns.IdBenhnhan).IsEqualTo(idBenhnhan).And(KcbPhieuDct.Columns.MaLuotkham). IsEqualTo(maluotKham).Execute(); i = i + 1; } UIAction.SetValue4Prg(progressBar, 1); // row.Cells["trangthai_xml"].Value = 1; } Utility.SetMsg(lblmsg, string.Format("Tổng số File XML là {0} file", i), false); } catch (Exception ex) { Utility.ShowMsg("Lỗi:" + ex.Message); } finally { if (_xmlWriter != null) { //xmlWriter.WriteEndElement(); //xmlWriter.WriteEndDocument(); _xmlWriter.Close(); } // this.UseWaitCursor = false; } }
void ProcessData() { try { Utility.ResetProgressBar(prgBar, m_dataTH.Rows.Count, true); if (!m_dataTH.Columns.Contains("LoaiKCB")) { m_dataTH.Columns.Add("LoaiKCB", typeof(string)); } if (!m_dataTH.Columns.Contains("NoiTT")) { m_dataTH.Columns.Add("NoiTT", typeof(string)); } if (!m_dataTH.Columns.Contains("DoiTuong")) { m_dataTH.Columns.Add("DoiTuong", typeof(string)); } if (!m_dataTH.Columns.Contains("Tuyen")) { m_dataTH.Columns.Add("Tuyen", typeof(int)); } foreach (DataRow row in m_dataTH.Rows) { if (row["dung_tuyen"].ToString() == "1") { row["ten_dung_tuyen"] = "I. Đúng Tuyến"; } else if (row["dung_tuyen"].ToString() == "0") { row["ten_dung_tuyen"] = "II. Trái Tuyến"; } else { row["ten_dung_tuyen"] = "III. Dịch Vụ"; } if (row[KcbLuotkham.Columns.MaNoicapBhyt].ToString() == globalVariables.gv_strNoicapBHYT) { if (row[KcbLuotkham.Columns.MaKcbbd].ToString() == globalVariables.gv_strNoiDKKCBBD) { row["DoiTuong"] = globalVariables.GvStrTendoituongNoiTinhKcbbd; row["Tuyen"] = 1; } else { row["DoiTuong"] = globalVariables.GvStrTendoituongNoitinhKhongKcbbd; row["Tuyen"] = 2; } } else { row["DoiTuong"] = globalVariables.GvStrTendoituongNgoaitinh; row["Tuyen"] = 3; } if (string.IsNullOrEmpty(row["ten_nhombhyt"].ToString())) { row["ten_nhombhyt"] = "Dịch vụ"; row["Tuyen"] = 0; } row["NoiTT"] = "CSKCB"; row["LoaiKCB"] = "Ngoại"; UIAction.SetValue4Prg(prgBar, 1); } m_dataTH.AcceptChanges(); } catch (Exception ex) { Utility.ShowMsg("Lỗi:" + ex.Message); } }