protected override Boolean postValidate() { Hashtable hashDups = new Hashtable(); MEmployeeLeave mv = (MEmployeeLeave)vw; int leaveMonth = CUtil.StringToInt(mv.LeaveMonth); int leaveYear = CUtil.StringToInt(mv.LeaveYear); var items = mv.LeaveRecords; foreach (var item in items) { if (item.ExtFlag.Equals("D")) { continue; } DateTime leaveDate = item.LeaveDate; string key = CUtil.DateTimeToDateString(leaveDate); if (hashDups.ContainsKey(key)) { CHelper.ShowErorMessage(leaveDate.ToString(), "ERROR_DUPLICATE_DATE", null); return(false); } else { hashDups.Add(key, key); } if ((leaveDate.Month != leaveMonth) || (leaveDate.Year != leaveYear)) { CHelper.ShowErorMessage(leaveDate.ToString(), "ERROR_NOT_IN_SAME_MONTH", null); return(false); } double sum = CUtil.StringToDouble(item.AnnualLeave) + CUtil.StringToDouble(item.PersonalLeave) + CUtil.StringToDouble(item.ExtraLeave) + CUtil.StringToDouble(item.SickLeave); if (sum > 1) { CHelper.ShowErorMessage(leaveDate.ToString(), "ERROR_LEAVE_OVER_DAY", null); return(false); } } return(true); }
protected CPrice getTierDiscount(MIntervalConfig ivc, CBasketItem bi) { MPackage pkg = getPackage(); double qty = 0.00; if (ivc.MappingType == 0) { //Map by quantity qty = bi.Quantity; } else { //Map by amount qty = bi.GetAmount(); } foreach (MInterval iv in ivc.IntervalItems) { double from = CUtil.StringToDouble(iv.FromValue); double to = CUtil.StringToDouble(iv.ToValue); double value = CUtil.StringToDouble(iv.ConfigValue); if ((qty > from) && (qty <= to)) { CPrice p = new CPrice(); if (ivc.TierScopeType == 0) { //Fixed p.DiscountAmount = value; } else if (ivc.TierScopeType == 1) { //Per unit p.DiscountAmount = bi.Quantity * value; } else { //2 - Percent of amount p.DiscountAmount = (value * bi.GetAmount()) / 100; } return(p); } } return(null); }
bool SalveazaEtapele() { bool esteSalvat = false; foreach (DataGridViewRow rand in this.dgvListaEtape.Rows) { DateTime dataInceput = CUtil.GetAsDate(this.dgvListaEtape.Rows[rand.Index].Cells[EnumColoaneDGV.colDataInceput.ToString()].Tag); DateTime dataSfarsit = CUtil.GetAsDate(this.dgvListaEtape.Rows[rand.Index].Cells[EnumColoaneDGV.colDataSfarsit.ToString()].Tag); int idUtilizator = CUtil.GetAsInt32(this.dgvListaEtape.Rows[rand.Index].Cells[EnumColoaneDGV.colTehnician.ToString()].Tag); BClientiComenziEtape listaLucrariEtapa = this.dgvListaEtape.Rows[rand.Index].Cells[EnumColoaneDGV.colDenumireEtapa.ToString()].Tag as BClientiComenziEtape; BLucrariEtape lucrareEtapa = this.dgvListaEtape.Rows[rand.Index].Cells[EnumColoaneDGV.colDenumireEtapa.ToString()].Tag as BLucrariEtape; if (listaLucrariEtapa == null) { if (lucrareEtapa == null) { BEtape etapa = this.dgvListaEtape.Rows[rand.Index].Cells[EnumColoaneDGV.colDenumireEtapa.ToString()].Tag as BEtape; if (etapa != null && dataInceput != CConstante.DataNula && dataSfarsit != CConstante.DataNula && idUtilizator != 0) { SalveazaComandaEtape(etapa, dataInceput, dataSfarsit, idUtilizator); esteSalvat = true; } } else { if (lucrareEtapa != null && dataInceput != CConstante.DataNula && dataSfarsit != CConstante.DataNula && idUtilizator != 0) { SalveazaComandaEtape(lucrareEtapa, dataInceput, dataSfarsit, idUtilizator); esteSalvat = true; } } } else { if (listaLucrariEtapa != null && dataInceput != CConstante.DataNula && dataSfarsit != CConstante.DataNula && idUtilizator != 0) { SalveazaComandaEtape(listaLucrariEtapa, dataInceput, dataSfarsit, idUtilizator); esteSalvat = true; } } } if (esteSalvat == false) { Mesaj.Informare(this.GetFormParinte(), BMultiLingv.getElementById(BMultiLingv.EnumDictionar.InformatiiIncomplete), string.Empty); } return(esteSalvat); }
private Boolean SaveData() { if (!CHelper.VerifyAccessRight("SALE_VOID_EDIT")) { return(false); } //if (!vw.IsModified) //{ // return (true); //} Boolean result = SaveToView(); if (!result) { return(false); } CUtil.EnableForm(false, this); CTable t = OnixWebServiceAPI.ApproveVoidedDoc(vw.GetDbObject()); CUtil.EnableForm(true, this); if (t != null) { MInventoryDoc ivd = new MInventoryDoc(t); ivd.InitErrorItem(); if (ivd.ErrorItems.Count > 0) { WinErrorDetails w = new WinErrorDetails(ivd.ErrorItems, "InventoryDoc"); w.Title = CLanguage.getValue("approve_error"); w.ShowDialog(); return(false); } else { accDoc.SetDbObject(t); accDoc.NotifyAllPropertiesChanged(); return(true); } } CHelper.ShowErorMessage(OnixWebServiceAPI.GetLastErrorDescription(), "ERROR_USER_EDIT", null); CUtil.EnableForm(true, this); return(false); }
private void SaveInstrumentParams() { CUtil.TaskStart(SaveInstrumentConfig); CStocksVisual sv = new CStocksVisual { Decimals = Decimals, ConNumm = ConnId, Step = Step, Ticker = TickerName }; _kernelTerminal.UpdateStockVisualInstrumentParams(StockNum, sv); }
private void cmdSearch_Click(object sender, RoutedEventArgs e) { permissions.Clear(); CUtil.EnableForm(false, this); ArrayList arr = OnixWebServiceAPI.GetListAPI("GetGroupAccessRightList", "GROUP_ACCESS_RIGHTS", vw.GetDbObject()); CUtil.EnableForm(true, this); foreach (CTable tb in arr) { MAccessRight ar = new MAccessRight(tb); permissions.Add(ar); } }
public void QueryData(MCompanyPackage vcp) { CUtil.EnableForm(false, this); MCompanyPackage cp = CMasterReference.GetCompanyPackage(true); if (cp != null) { vcp.SetDbObject(cp.GetDbObject().Clone()); vcp.InitChildItems(); vcp.NotifyAllPropertiesChanged(); } CUtil.EnableForm(true, this); vw.IsModified = false; }
private void QRY_관로구조_LIST() { try { sqlDataQry.Fill("QRY_관로구조_LIST"); DataTable dt = CUtil.GetTable(sqlDataQry.Result["QRY_관로구조_LIST"]); gridControl3.DataSource = dt; } catch (Exception ex) { MsgCaption.Caption = ex.Message; } }
private void txtMotivInchidere_ZonaModificata(Control sender, string sNumeProprietateAtasata, object sNouaValoare) { try { if (!this.lSeIncarca) { CUtil.SetProperty(this.lDetaliiInchidere, sNumeProprietateAtasata, sNouaValoare); this.lDetaliiInchidere.UpdateAll(null); } } catch (Exception ex) { GestiuneErori.AfiseazaMesaj(this.GetFormParinte(), ex); } }
private void cmdOK_Click(object sender, RoutedEventArgs e) { Boolean r = SaveData(); if (r) { HasModified = true; vw.IsModified = false; DialogOK = true; CUtil.EnableForm(true, this); this.Close(); } }
private void loadFilterFromDB() { CUtil.EnableForm(false, this); CTable t = OnixWebServiceAPI.GetReportFilterInfo(new CTable("")); ArrayList arr = t.GetChildArray("REPORT_FILTER_ITEM"); foreach (CTable o in arr) { MReportFilter rf = new MReportFilter(o); dbReportFilter.Add(rf.Key, rf); } CUtil.EnableForm(true, this); }
private void CmdApprove_Click(object sender, RoutedEventArgs e) { Boolean r = approveData(); if (r) { //Approve cheque as well CUtil.EnableForm(false, this); //CTaxDocumentUtil.ApproveChequeFromTaxDoc(mv); CUtil.EnableForm(true, this); vw.IsModified = false; this.Close(); } }
static int LoadPrefab(IntPtr L) { try { ToLua.CheckArgsCount(L, 1); string arg0 = ToLua.CheckString(L, 1); UnityEngine.GameObject o = CUtil.LoadPrefab(arg0); ToLua.PushSealed(L, o); return(1); } catch (Exception e) { return(LuaDLL.toluaL_exception(L, e)); } }
public ActionResult UpdateInfoSave(ModUApiPowerAplictionFind mod, FormCollection form) { string id = CUtil.CStr(form["id"]); MongoCollection <ModUApiPowerAplictionFind> modUApiPowerAplictionFind = mongoh.GetCollection <ModUApiPowerAplictionFind>(); ModUApiPowerAplictionFind Model = modUApiPowerAplictionFind.Find(Query.EQ("_id", new ObjectId(id))).FirstOrDefault(); if (Model == null) { return(Content(Util.JsUrlTo(Url.Action("Index_Already"), "数据读取异常"))); } var strLocation = Query.EQ("_id", new ObjectId(id)); modUApiPowerAplictionFind.Update((strLocation), Update.Set("serviceno_uid", mod.serviceno_uid == null ? "" : mod.serviceno_uid).Set("civetno", mod.civetno == null ? "" : mod.civetno).Set("user_name", mod.user_name == null ? "" : mod.user_name).Set("mobile", mod.mobile == null ? "" : mod.mobile).Set("ext_phone", mod.ext_phone == null ? "" : mod.ext_phone).Set("bg_name", mod.bg_name == null ? "" : mod.bg_name).Set("bu_name", mod.bu_name == null ? "" : mod.bu_name).Set("dept_name", mod.dept_name == null ? "" : mod.dept_name).Set("cost_code", mod.cost_code == null ? "" : mod.cost_code).Set("apply_reason", mod.apply_reason == null ? "" : mod.apply_reason)); return(Content(Util.JsCustom("alert('修改成功');window.parent._close_dialog(); window.parent.refresh();"))); }
public WinAddEditBorrowReturnItem(CWinLoadParam param) : base(param) { accessRightName = "INVENTORY_BORROW_EDIT"; mvParent = (MInventoryDoc)loadParam.ActualParentView; dt = (InventoryDocumentType)CUtil.StringToInt(param.GenericType); InitializeComponent(); //Need to be after InitializeComponent registerValidateControls(lblCode, lkupItem, false); registerValidateControls(lblQuantity, txtQuantity, false); registerValidateControls(lblUnitPrice, txtUnitPrice, false); registerValidateControls(lblLotNo, txtLotSerial1, false); }
private GridLength stringToLength(String w) { if (w.Equals("*")) { return(new GridLength(1, GridUnitType.Star)); } else if (w.Equals("auto")) { return(new GridLength(1, GridUnitType.Auto)); } double len = CUtil.StringToDouble(w); return(new GridLength(len)); }
protected override void OnPaint(System.Windows.Forms.PaintEventArgs e) { base.OnPaint(e); Graphics g = e.Graphics; g.CompositingQuality = System.Drawing.Drawing2D.CompositingQuality.HighQuality; g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality; g.TextRenderingHint = System.Drawing.Text.TextRenderingHint.AntiAlias; Rectangle chenar = new Rectangle(0, 0, this.Width - 1, this.Height - 1); //Desenam chenarul g.DrawRectangle(Pens.DarkGray, chenar); //Desenam coloanele float latimeColoana = Convert.ToSingle(this.Width - 1) / this.lNumarColoane; float xColoana = 0; for (int i = 0; i < this.lNumarColoane - 1; i++) { xColoana = (i + 1) * latimeColoana; g.DrawLine(Pens.DarkGray, xColoana, 0, xColoana, this.Height); } //Desenam liniile if (!CUtil.EsteListaVida <float>(this.lListaInaltimiColoane)) { float yActual = 0; if (this.SensInversDimensiuneLinii) { yActual = this.Height; for (int i = 0; i < this.lListaInaltimiColoane.Count - 1; i++) { yActual -= this.lListaInaltimiColoane[i] * CDefinitiiComune._FactorMultiplicareDPI_Y; g.DrawLine(Pens.DarkGray, 0, yActual, this.Width, yActual); } } else { for (int i = 0; i < this.lListaInaltimiColoane.Count - 1; i++) { yActual += this.lListaInaltimiColoane[i] * CDefinitiiComune._FactorMultiplicareDPI_Y; g.DrawLine(Pens.DarkGray, 0, yActual, this.Width, yActual); } } } }
public CPlaza2Connector() : base("Plaza2Connector") { _componentFactory = new CComponentFactory(_logger); //note. not possible to create in base class //Messenger = new CMessenger(); StockExchId = CodesStockExch._01_MoexFORTS; UseRealServer = CUtil.GetEnvVariableBool("USE_REAL_PLAZA2_SERVER"); Sounder = new CSounder(); LogServer = new CLogServer(); // Instruments = new CListInstruments(); //TO DO read last revisions from file ReadDataFromFiles(); (new System.Threading.Thread(ThreadDumpLastDataToFiles)).Start(); (new Task(TaskRoundtripTime)).Start(); //CreateGUIEvents(); //StartGateIfNeed(); OpenCgate(); // (new System.Threading.Thread(ThreadResourcesAnalyzer)).Start(); // string tmp = CUtil.GetTemp(); IsPossibleEmptyInstrCancellOrders = true; IsPossibleNativeCancellOrdByInstr = true; }
internal bool Salveaza() { bool esteValid = BLocatii.SuntInformatiileNecesareCoerente(this.txtDenumireLocatie.Text, 1); if (this.lLocatie == null) { if (esteValid) { BLocatii.Add(this.txtDenumireLocatie.Text, BLocatii.EnumTipLocatie.Sediu, 0, 0, 0, 0, 0, this.txtTelefonMobilLocatie.Text, this.txtFaxLocatie.Text, this.txtSkypeLocatie.Text, string.Empty, this.txtMailLocatie.Text, this.txtPaginaWebLocatie.Text, string.Empty, this.picLogoLocatie.ImageLocation, 0, this.txtDenumireFiscalaLocatie.Text, getTipFiscalitate(), this.txtCodFiscalLocatie.Text, this.txtNrInregistrareLocatie.Text, this.txtIbanLocatie.Text, this.txtBancaLocatie.Text, this.txtReprezentantLegalLocatie.Text, this.txtCalitateReprezentantLocatie.Text, this.txtSerieChitanteLocatie.Text, CUtil.GetAsInt32(this.txtNrInregistrareLocatie.Text), this.txtSerieFacturiLocatie.Text, 0, this.chkTvaLocatie.Checked, string.Empty, 0, 0, null); } else { seteazaAlerta(); } } else { this.lLocatie.Denumire = this.txtDenumireLocatie.Text; this.lLocatie.AdresaMail = this.txtMailLocatie.Text; this.lLocatie.ContSkype = this.txtSkypeLocatie.Text; this.lLocatie.Fax = this.txtFaxLocatie.Text; this.lLocatie.PaginaWeb = this.txtPaginaWebLocatie.Text; this.lLocatie.TelefonMobil = this.txtTelefonMobilLocatie.Text; this.lLocatie.DenumireFiscala = this.txtDenumireFiscalaLocatie.Text; this.lLocatie.Logo = this.picLogoLocatie.ImageLocation; //this.lLocatie.TipFiscalitate = getTipFiscalitate(); this.lLocatie.PlatitorDeTVA = this.chkTvaLocatie.Checked; this.lLocatie.CodFiscal = this.txtCodFiscalLocatie.Text; this.lLocatie.NumarInregistrare = this.txtNrInregistrareLocatie.Text; this.lLocatie.ContIBAN = this.txtIbanLocatie.Text; this.lLocatie.DenumireBanca = this.txtBancaLocatie.Text; this.lLocatie.ReprezentantLegal = this.txtReprezentantLegalLocatie.Text; this.lLocatie.CalitateReprezentantLegal = this.txtCalitateReprezentantLocatie.Text; this.lLocatie.SerieChitante = this.txtSerieChitanteLocatie.Text; this.lLocatie.NumarUltimaChitanta = CUtil.GetAsInt32(this.txtNrUltimaChitantaLocatie.Text); this.lLocatie.SerieFacturi = this.txtSerieFacturiLocatie.Text; this.lLocatie.NumarUltimaFactura = CUtil.GetAsInt32(this.txtNrUltimaFacturaLocatie.Text); if (esteValid) { this.lLocatie.UpdateAll(); } else { seteazaAlerta(); } } return(esteValid); }
private void BtnAdaugaLucrareRapida_Click(object sender, EventArgs e) { if (this.lSeIncarca) { return; } try { incepeIncarcarea(); //Adaugam lucrarea //Minim clinica si lucrarea trebuie sa fie selectate if (this.ctrlADCautareClinica.AreValoare() && this.ctrlADCautareLucrare.AreValoare()) { if (this.ctrlADCautareEtapa.AreValoare() || !this.ctrlADCautaTehnician.AreValoare()) { Tuple <string, string> numePrenumePac = CUtil.GetNumePrenumeDinText(this.txtADPacient.Text); BClientiComenzi.Add(this.ctrlADCautareClinica.GetIdClient(), this.ctrlADCautareMedicClinica.GetIdMedic(), numePrenumePac.Item1, numePrenumePac.Item2, 0, 0, this.ctrlADDataOraPrimire.DataAfisata, CConstante.DataNula, string.Empty, this.ctrlADCautareCabinetClinica.GetIdCabinet(), this.ctrlADCautareLucrare.GetIdLucrare(), false, 0, 0, this.txtADNrElemente.ValoareIntreaga, this.ctrlADCautareEtapa.GetIdEtapa(), this.ctrlADCautaTehnician.GetIdTehnician(), CConstante.DataNula, false, 0, this.txtADCuloare.Text, string.Empty, false, string.Empty, null); this.ctrlADCautareLucrare.Goleste(); this.ctrlADDataOraPrimire.DataAfisata = DateTime.Now; ConstruiesteRanduriDGV(); this.dgvListaComenzi.ScrollToBottom(); } else { if (this.ctrlADCautaTehnician.AreValoare()) { this.ctrlADCautareEtapa.DeschideLista(); } } } else { Mesaj.Eroare(this.GetFormParinte(), BMultiLingv.getElementById(BMultiLingv.EnumDictionar.SelectatiCelPutinClinicaSiLucrarea)); } } catch (Exception ex) { GestiuneErori.AfiseazaMesaj(this.GetFormParinte(), ex); } finally { finalizeazaIncarcarea(); } }
private void btnAnulTrecut_Click(object sender, EventArgs e) { try { incepeIncarcarea(); bool perioadaSelectata = false; if (this.lTipPerioada != CDefinitiiComune.EnumTipPerioada.An) { if (this.datInceput.DataAfisata.Year != DateTime.Today.AddYears(this.lSpreViitor ? 1 : -1).Year) { perioadaSelectata = true; if (this.lTipPerioada == CDefinitiiComune.EnumTipPerioada.Luna) { //Ne pozitionam pe aceeasi luna dar din anul trecut/viitor seteazaPerioada(CDefinitiiComune.EnumTipPerioada.Luna, (this.datInceput.AreValoare() ? this.datInceput.DataAfisata : DateTime.Today).AddYears(this.lSpreViitor ? 1 : -1)); } else if (this.lTipPerioada == CDefinitiiComune.EnumTipPerioada.Saptamana) { //Ne pozitionam pe aceeasi saptamana dar anul trecut int nrSaptamana = CUtil.GetNumarSaptamana(this.datInceput.DataAfisata); seteazaPerioada(CDefinitiiComune.EnumTipPerioada.Saptamana, CUtil.GetZiLuniDinSaptamana((this.datInceput.AreValoare() ? this.datInceput.DataAfisata : DateTime.Today).AddYears(this.lSpreViitor ? 1 : -1), nrSaptamana)); } else if (this.lTipPerioada == CDefinitiiComune.EnumTipPerioada.Zi) { //Ne pozitionam pe aceeasi zi dar din aceeasi saptamana a anului trecut int nrSaptamana = CUtil.GetNumarSaptamana(this.datInceput.DataAfisata); seteazaPerioada(CDefinitiiComune.EnumTipPerioada.Zi, CUtil.GetDataZiSaptamana(this.datInceput.DataAfisata.DayOfWeek, CUtil.GetZiLuniDinSaptamana((this.datInceput.AreValoare() ? this.datInceput.DataAfisata : DateTime.Today).AddYears(this.lSpreViitor ? 1 : -1), nrSaptamana))); } } } if (!perioadaSelectata) { seteazaPerioada(CDefinitiiComune.EnumTipPerioada.An, this.lSpreViitor ? DateTime.Today.AddYears(1) : DateTime.Today.AddYears(-1)); } anuntaSchimbareaPerioadei(); } catch (Exception ex) { GestiuneErori.AfiseazaMesaj(this.GetFormParinte(), ex); } finally { finalizeazaIncarcarea(); } }
private void LoadData() { txtPackageCode.SetFocus(); CTable t = new CTable("PACKAGE"); vw = new MPackage(t); vw.PackageType = pg; DataContext = vw; CUtil.EnableForm(false, this); if (Mode.Equals("E") || Mode.Equals("V")) { CTable m = OnixWebServiceAPI.GetPackageInfo(actualView.GetDbObject()); if (m != null) { vw.SetDbObject(m); } //cboDiscountMappingType.SelectedIndex = CUtil.StringToInt(vw.DiscountMapType); } else if (Mode.Equals("A")) { vw.EffectiveDate = DateTime.Now; vw.ExpireDate = DateTime.Now.Add(new TimeSpan(30, 0, 0, 0)); vw.IsEnabled = true; vw.IsTimeSpecific = false; } vw.InitPeriods(); vw.InitItemsPrice(); vw.InitPackageCustomers(); vw.InitPackageDiscountFilters(); vw.InitPackageBonusFilters(); vw.InitPackageVoucherFilters(); vw.InitPackageBundles(); vw.InitPackageFinalDiscounts(); vw.InitPackageBranches(); vw.InitPackagePostFrees(); vw.InitTrayPriceItem(); vw.NotifyAllPropertiesChanged(); vw.IsModified = false; CUtil.EnableForm(true, this); }
private static void updateGui(DateTime t, UTimePicker ctrl) { if (t == null) { ctrl.txtHH.Text = ""; ctrl.txtMM.Text = ""; } else { String dtm = CUtil.DateTimeToDateStringInternal(t); //YYYY/MM/DD HH:MM:SS ctrl.txtHH.Text = dtm.Substring(11, 2); ctrl.txtMM.Text = dtm.Substring(14, 2); } }
private void cmdDelete_Click(object sender, RoutedEventArgs e) { if (!CHelper.VerifyAccessRight("INVENTORY_ITEM_DELETE")) { return; } int rCount = CHelper.DeleteSelectedItems(itemsSourceGrid, OnixWebServiceAPI.DeleteInventoryItem, rowCount.ToString()); if (rCount > 0) { rowCount = rCount; CMasterReference.Instance.LoadItemCategoriesTree(); } lblTotal.Content = CUtil.FormatInt((rowCount).ToString()); }
private void cmdNavigate_Click(object sender, RoutedEventArgs e) { int idx = cboNavigate.SelectedIndex; if (idx < 0) { return; } MChunkNavigate v = (MChunkNavigate)cboNavigate.SelectedItem; lastQuery.SetFieldValue("EXT_CHUNK_NO", v.ChunkNo); CUtil.EnableForm(false, this); QueryData(lastQuery); CUtil.EnableForm(true, this); }
private void populateTempFields(CTable o) { String name = o.GetFieldValue("EMPLOYEE_NAME"); String lastName = o.GetFieldValue("EMPLOYEE_LASTNAME"); double refund = CUtil.StringToDouble(o.GetFieldValue("RECEIVE_REFUND")); double coverage = CUtil.StringToDouble(o.GetFieldValue("DEDUCT_COVERAGE")); o.SetFieldValue("EMPLOYEE_NAME_LASTNAME", name + " " + lastName); double received = getSumArray(o, empReceives); double deduct = getSumArray(o, empDeducts); double total = received + refund - deduct - coverage; o.SetFieldValue("EMP_DEDUCT_TOTAL", deduct.ToString()); o.SetFieldValue("EMP_RECEIVED_TOTAL", received.ToString()); o.SetFieldValue("EMP_AMOUNT_TOTAL", total.ToString()); }
public static BColectieEmailuriExtrase getByListaId(List <int> pListaId, IDbTransaction pTranzactie) { BColectieEmailuriExtrase listaRetur = new BColectieEmailuriExtrase(); if (!CUtil.EsteListaIntVida(pListaId)) { using (DataSet ds = DEmailuri_Extrase.GetByListId(pListaId, pTranzactie)) { foreach (DataRow dr in ds.Tables[0].Rows) { listaRetur.Add(new BEmailuriExtrase(dr)); } } } return(listaRetur); }
public static BColectieBanci getByListaId(List <int> pListaId, IDbTransaction pTranzactie) { BColectieBanci listaRetur = new BColectieBanci(); if (!CUtil.EsteListaIntVida(pListaId)) { using (DataSet ds = DBanci.GetByListId(pListaId, pTranzactie)) { foreach (DataRow dr in ds.Tables[0].Rows) { listaRetur.Add(new BBanci(dr)); } } } return(listaRetur); }
private void rootElement_Closing(object sender, System.ComponentModel.CancelEventArgs e) { if (vw.IsModified) { Boolean result = CHelper.AskConfirmSave(); if (result) { Boolean r = SaveData(); if (r) { HasModified = true; CUtil.EnableForm(true, this); } } } }
private void CmdOK_Click(object sender, RoutedEventArgs e) { if (!isDataConsistent()) { return; } Boolean r = saveData(); if (r) { vw.IsModified = false; CUtil.EnableForm(true, this); this.Close(); } }
public void ButTurleri_xml_to_sistem() { CUtil myutil = new CUtil(); #region xmltext /* <BUT_TUR_NO>2</BUT_TUR_NO> <TUR_KODU>2</TUR_KODU> <TUR_ADI>Birinci Basamak Sağlik Kuruluşlarinda Müdahaleler</TUR_ADI> <ACIKLAMA>null</ACIKLAMA> <SBRS_REFERANS_NO>111481</SBRS_REFERANS_NO> <SURUM>1</SURUM> <AKTIF>0</AKTIF> */ #endregion XDocument doc = XDocument.Load(myutil.CalismaKlasoru() + "ButTurleri.xml"); var Kodlar = from p in doc.Elements("BUTTURKODLARI").Elements("Records") select new { BUT_TUR_NO = p.Element("BUT_TUR_NO").Value, TUR_KODU = p.Element("TUR_KODU").Value, TUR_ADI = p.Element("TUR_ADI").Value, ACIKLAMA = p.Element("ACIKLAMA").Value, SBRS_REFERANS_NO = p.Element("SBRS_REFERANS_NO").Value, SURUM = p.Element("SURUM").Value, AKTIF = p.Element("AKTIF").Value }; Transaction.Instance.ExecuteNonQuery("delete from HizmetTur"); int i = 0; string sonsatir = edtsonuc.Items[edtsonuc.Items.Count - 1].ToString(); foreach (var kod in Kodlar) { if (kod.BUT_TUR_NO == "null") continue; int kayitliasivarmi = 0; kayitliasivarmi = Transaction.Instance.ExecuteScalarI("Select count(Id) from HizmetTur where Id=@prm0 ", new object[] { kod.BUT_TUR_NO }); if (kayitliasivarmi > 0) continue; i++; HizmetTur item = new HizmetTur(); item.Adi = kod.TUR_ADI; item.Aktif = true;// kod.AKTIF == "1"; item.Id = Convert.ToInt64(kod.BUT_TUR_NO); item.Kodu = kod.TUR_KODU; item.Aciklama = kod.ACIKLAMA; item.Insert(); edtsonuc.Items[edtsonuc.Items.Count - 1] = sonsatir + " (Hizmet Tür Kodları:" + i.ToString() + ")"; Application.DoEvents(); } }
public void Klinikler_xml_to_sistem() { CUtil myutil = new CUtil(); #region xmltext /* <SBRS_KLINIK_NO>58</SBRS_KLINIK_NO> <SBRS_REFERANS_NO>111697</SBRS_REFERANS_NO> <KLINIK_ADI>Periodontoloji</KLINIK_ADI> <KLINIK_KODU>5371</KLINIK_KODU> <SURUM>1</SURUM> <AKTIF>0</AKTIF> <SBRS_UST_KLINIK_NO>0</SBRS_UST_KLINIK_NO> */ #endregion XDocument doc = XDocument.Load(myutil.CalismaKlasoru() + "Klinikler.xml"); var Kodlar = from p in doc.Elements("SEVK_KLINIK_KODLARI").Elements("Records") select new { SBRS_KLINIK_NO = p.Element("SBRS_KLINIK_NO").Value, SBRS_REFERANS_NO = p.Element("SBRS_REFERANS_NO").Value, KLINIK_ADI = p.Element("KLINIK_ADI").Value, KLINIK_KODU = p.Element("KLINIK_KODU").Value, SURUM = p.Element("SURUM").Value, AKTIF = p.Element("AKTIF").Value, SBRS_UST_KLINIK_NO = p.Element("SBRS_UST_KLINIK_NO").Value }; Transaction.Instance.ExecuteNonQuery("delete from SevkBolum"); int i = 0; string sonsatir = edtsonuc.Items[edtsonuc.Items.Count - 1].ToString(); foreach (var kod in Kodlar) { if (kod.KLINIK_KODU == "null") continue; int kayitliasivarmi = 0; kayitliasivarmi = Transaction.Instance.ExecuteScalarI("Select count(Id) from sevkbolum where kodu=@prm0 ", new object[] { kod.KLINIK_KODU }); if (kayitliasivarmi > 0) continue; i++; SevkBolum item = new SevkBolum(); item.Adi = kod.KLINIK_ADI; item.Aktif = true;// kod.AKTIF == "1"; item.Id = Convert.ToInt64(kod.SBRS_KLINIK_NO); item.Kodu = kod.KLINIK_KODU; if (kod.SBRS_UST_KLINIK_NO != "null") { SevkBolum ustitem = new SevkBolum(); ustitem.Id = Convert.ToInt64(kod.SBRS_UST_KLINIK_NO.ToString()); item.Ust_SevkBolum = ustitem; } item.Insert(); edtsonuc.Items[edtsonuc.Items.Count - 1] = sonsatir + " (Sevk Bölüm Kodları:" + i.ToString() + ")"; Application.DoEvents(); } }
public void Adresler_xml_to_sistem() { CUtil myutil = new CUtil(); #region xmltext /* <BOLUM_KODU>34153</BOLUM_KODU> <BOLUM_ADI>GÜDÜN</BOLUM_ADI> <SEVIYE>4</SEVIYE> <KARSILIK_KODU>13</KARSILIK_KODU> <UST_BOLUM_KODU>2365</UST_BOLUM_KODU> <AKTIF>0</AKTIF> */ #endregion XDocument doc = XDocument.Load(myutil.CalismaKlasoru() + "Adresler.xml"); var Kodlar = from p in doc.Elements("ADRESKODLARI").Elements("Records") select new { BOLUM_ADI = p.Element("BOLUM_ADI").Value, BOLUM_KODU = p.Element("BOLUM_KODU").Value, SEVIYE = p.Element("SEVIYE").Value, AKTIF = p.Element("AKTIF").Value, KARSILIK_KODU = p.Element("KARSILIK_KODU").Value, UST_BOLUM_KODU = p.Element("UST_BOLUM_KODU").Value }; Transaction.Instance.ExecuteNonQuery("delete from Lokasyon"); int i = 0; string sonsatir = edtsonuc.Items[edtsonuc.Items.Count - 1].ToString(); foreach (var kod in Kodlar) { if (kod.BOLUM_KODU == "null") continue; int kayitliasivarmi = 0; kayitliasivarmi = Transaction.Instance.ExecuteScalarI("Select count(Id) from Lokasyon where Id=@prm0 ", new object[] { kod.BOLUM_KODU }); if (kayitliasivarmi > 0) continue; i++; Lokasyon item = new Lokasyon(); item.Adi = kod.BOLUM_ADI; item.Aktif = true;// kod.AKTIF == "1"; item.Id = Convert.ToInt64(kod.BOLUM_KODU); item.KarsilikKodu = kod.KARSILIK_KODU; item.Seviye = Convert.ToInt32(kod.SEVIYE); if (kod.UST_BOLUM_KODU != "null") { Lokasyon ustitem = new Lokasyon(); ustitem.Id = Convert.ToInt64(kod.UST_BOLUM_KODU.ToString()); item.UstLokasyon = ustitem; } item.Insert(); edtsonuc.Items[edtsonuc.Items.Count - 1] = sonsatir + " (Lokasyon Kodları:" + i.ToString() + ")"; Application.DoEvents(); } }
public static void TumKodlariGetirXMLeYaz() { CUtil myutil = new CUtil(); Service service = new Service(); string str; str = service.SistemKodunaGoreGetir("1572FCEE-2E3D-4500-9BA4-743BE9A581A7"); myutil.LogToFile("ICD10.xml", str); str = service.SistemKodunaGoreGetir("AF7BB2C3-3AEF-433A-BD0A-EA7416D3D586"); myutil.LogToFile("IlacKodlari.xml", str); str = service.SistemKodunaGoreGetir("f85fc6de-b865-4e83-a4c0-ab1c5a07422c"); myutil.LogToFile("ButTurleri.xml", str); str = service.SistemKodunaGoreGetir("6B3CA76A-D43D-46F0-9161-E298DB78ABE1"); myutil.LogToFile("ButKodlari.xml", str); str = service.SistemKodunaGoreGetir("5EE0AB29-6B92-4356-B287-6CF93E052362"); myutil.LogToFile("TetkikKodlari.xml", str); str = service.SistemKodunaGoreGetir("60729d0d-c272-4521-8ed7-652780c1f71d"); myutil.LogToFile("KurumTurleri.xml", str); str = service.SistemKodunaGoreGetir("c9dbe1cb-57cb-48fb-bdd3-d622e0e304c6"); myutil.LogToFile("Kurumlar.xml", str); str = service.SistemKodunaGoreGetir("43B06D1E-A7D2-4920-A4E7-6534F6C1D199"); myutil.LogToFile("Klinikler.xml", str); str = service.SistemKodunaGoreGetir("B5DDD47A-A01C-4944-8117-993A97ABFE0F"); myutil.LogToFile("KlinikDokumanTipi.xml", str); str = service.SistemKodunaGoreGetir("BD8C6F17-430B-4F90-83E2-E0276052384C"); myutil.LogToFile("Asi.xml", str); str = service.SistemKodunaGoreGetir("1c1ba2a9-01e1-46c7-8b38-44"); myutil.LogToFile("TakvimBebekIzlem.xml", str); str = service.SistemKodunaGoreGetir("377153f3-8de1-4515-9833-746bf81b041b"); myutil.LogToFile("TakvimAsi.xml", str); str = service.SistemKodunaGoreGetir("4259c680-ef30-4243-ac52-019c5a7e71ed"); myutil.LogToFile("TakvimGebeIzlem.xml", str); str = service.SistemKodunaGoreGetir("9416085f-6a12-470a-bc19-66ee19293768"); myutil.LogToFile("TakvimCocukIzlem.xml", str); str = service.SistemKodunaGoreGetir("ac0eea4a-3fbb-4946-ac43-543fcff3fdd8"); myutil.LogToFile("MalzemeKodlari.xml", str); str = service.SistemKodunaGoreGetir("ED350183-F2E8-415B-BCDB-1FA10EF627D8"); myutil.LogToFile("MudahaleKodlari.xml", str); str = service.SistemKodunaGoreGetir("43B06D1E-A7D2-4920-A4E7-6534F6C1D100"); myutil.LogToFile("UyrukKodlari.xml", str); str = service.SistemKodunaGoreGetir("ISO 3166"); myutil.LogToFile("Ulkeler.xml", str); str = service.SistemKodunaGoreGetir("c5a8d278-daa8-4774-a390-ab444e02db32"); myutil.LogToFile("Ulkeler2.xml", str); str = service.SistemKodunaGoreGetir("512d0cb3-d0b3-487c-ab1e-1343fc7ff611"); myutil.LogToFile("Meslekler.xml", str); str = service.SistemKodunaGoreGetir("526CB860-9DD3-4CDC-8888-C10135AFED4F"); myutil.LogToFile("ATCKodlari.xml", str); str = service.SistemKodunaGoreGetir("94e988ab-c1c8-46ea-af0d-465699607091"); myutil.LogToFile("AtcIlaclar.xml", str); str = service.SistemKodunaGoreGetir("47BA9D19-7639-4E83-8C2B-A81ED2F0F578"); myutil.LogToFile("IlacDozBirimleri.xml", str); str = service.SistemKodunaGoreGetir("A4F5E158-866F-42B4-95B5-358BF4B26389"); myutil.LogToFile("KanGrublari.xml", str); str = service.SistemKodunaGoreGetir("701829ce-43c2-4dee-bfa7-ae2609c11d66"); myutil.LogToFile("Parametreler.xml", str); str = service.SistemKodunaGoreGetir("6500cac4-fee0-507d-e044-00144f26688f"); myutil.LogToFile("MeslekHastaUyari.xml", str); str = service.SistemKodunaGoreGetir("928d1201-5dba-4a1b-9e0b-f00653e8af4b"); myutil.LogToFile("Uzmanliklar.xml", str); str = service.SistemKodunaGoreGetir("b1c79345-d10b-4073-8ccb-9c9d3498eecc"); myutil.LogToFile("OlasiTaniKriterleri.xml", str); str = service.SistemKodunaGoreGetir("7b4af4a7-8e6b-4382-b50b-60d1a37f6812"); myutil.LogToFile("EnfeksiyonEtkenliTaniKriterleri.xml", str); str = service.SistemKodunaGoreGetir("646bff5d-73da-4349-8769-05ed48b18020"); myutil.LogToFile("TumorYerleri.xml", str); str = service.SistemKodunaGoreGetir("3A15B5BA-FD09-41EE-9396-C8C8F5F8DFCC"); myutil.LogToFile("SosyalGuvenlikKurumu.xml", str); str = service.SistemKodunaGoreGetir("2AFE8407-6DEB-4E7D-A2FB-76ECEFCDA4DF"); myutil.LogToFile("OgrenimDurumu.xml", str); str = service.SistemKodunaGoreGetir("f8f58940-1a33-480e-8e90-7eb464215166"); myutil.LogToFile("YakinlikKodlari.xml", str); str = service.SistemKodunaGoreGetir("f2176c6d-87c0-40d5-af31-a5ebda73d31d"); myutil.LogToFile("KesinTaniKriterleri.xml", str); str = service.SistemKodunaGoreGetir("3d78fed3-66ff-444e-b9eb-4ed3f05ddb06"); myutil.LogToFile("Histoloji.xml", str); str = service.SistemKodunaGoreGetir("66D5BACE-C604-42BE-BE4A-5BD61A06C574"); myutil.LogToFile("MERNIS.xml", str); str = service.SistemKodunaGoreGetir("2.16.840.1.113883.6.1"); myutil.LogToFile("LOINCKODLARI.xml", str); str = service.SistemKodunaGoreGetir("41F3264B-D590-4BA8-8B22-4F138950F467"); myutil.LogToFile("ap_Yontemleri.xml", str); str = service.SistemKodunaGoreGetir("5AF472F6-9867-4183-8151-8F14564B0D16"); myutil.LogToFile("HastaKayitTalepTuru.xml", str); str = service.SistemKodunaGoreGetir("78F2300E-B242-43E3-B124-5B9BA2FD60B2"); myutil.LogToFile("HastaKayitDonusTuru.xml", str); str = service.SistemKodunaGoreGetir("742CEA72-08B0-4D76-A2F5-979676ED924F"); myutil.LogToFile("HastaKayitdurumu.xml", str); str = service.SistemKodunaGoreGetir("E31DF2DC-7F0A-468F-BA12-FFC2719C5298"); myutil.LogToFile("IlisikKesmenedenIzamanKisitli.xml", str); str = service.SistemKodunaGoreGetir("B8E5BF84-0D3D-4C50-8C57-E269CDAA8484"); myutil.LogToFile("IlisikKesmenedenIzamanKisitsiz.xml", str); str = service.SistemKodunaGoreGetir("0D38AC2D-696A-4FD4-BEEB-D707076B4F31"); myutil.LogToFile("Cinsiyet.xml", str); str = service.SistemKodunaGoreGetir("F72C59A7-70D5-4C62-B3E8-3B426521D605"); myutil.LogToFile("PelvisDurumu.xml", str); str = service.SistemKodunaGoreGetir("2C8695F0-8F96-430B-BC98-0400E0DB4F56"); myutil.LogToFile("GizlilikDerecesi.xml", str); str = service.SistemKodunaGoreGetir("5F2DFFE8-C99A-47E4-8252-93F334C85AE8"); myutil.LogToFile("GelisBicimi.xml", str); str = service.SistemKodunaGoreGetir("F95D11EE-F985-45C2-A94C-7F632358FCCF"); myutil.LogToFile("DogumYontemi.xml", str); str = service.SistemKodunaGoreGetir("6CB236DD-52D9-4337-8756-E5631D7E9B3D"); myutil.LogToFile("GebelikSonlanmaDurumu.xml", str); str = service.SistemKodunaGoreGetir("b781820f-483a-4de4-8934-788af91fa531"); myutil.LogToFile("IlacTedarikcileri.xml", str); str = service.SistemKodunaGoreGetir("C8F78916-96CD-43B5-810A-E56302F4B6E1"); myutil.LogToFile("MedeniHali.xml", str); str = service.SistemKodunaGoreGetir("017EC9A9-DA42-44B7-957A-3404E4DD9611"); myutil.LogToFile("YakinlikDerecesi.xml", str); str = service.SistemKodunaGoreGetir("4CAE078C-E236-4CEA-8DF6-38FDD9843789"); myutil.LogToFile("RaporTuru.xml", str); str = service.SistemKodunaGoreGetir("DAEEB685-593E-4774-99DE-C69C17DA6395"); myutil.LogToFile("DogumaYardimEden.xml", str); str = service.SistemKodunaGoreGetir("317BC05E-1FB1-4346-BAD4-B44F8062A8AC"); myutil.LogToFile("DogumunYapildigiYer.xml", str); str = service.SistemKodunaGoreGetir("B2F5264B-3C1C-4729-BB18-7546B496161A"); myutil.LogToFile("IletisimTipi.xml", str); str = service.SistemKodunaGoreGetir("CF5924B0-DF84-4438-BC93-597B4E71B3B1"); myutil.LogToFile("AdresTipi.xml", str); str = service.SistemKodunaGoreGetir("B3A8369F-4AE9-4D4D-A855-E5E1ADCCB0F4"); myutil.LogToFile("UzunlukBirimi.xml", str); str = service.SistemKodunaGoreGetir("30E2300A-218B-4009-AE46-908299201F1C"); myutil.LogToFile("AgirlikBirimi.xml", str); str = service.SistemKodunaGoreGetir("B052F8A2-B5C0-4609-BE3E-A096C42DC20B"); myutil.LogToFile("AlerjiKodlari.xml", str); str = service.SistemKodunaGoreGetir("ED6657E4-2A20-4BE3-B300-2AA043F40A0B"); myutil.LogToFile("IlacKullanimSekli.xml", str); str = service.SistemKodunaGoreGetir("3763F41D-9B20-45BD-8765-E7FF1789D7F3"); myutil.LogToFile("SaglikKurumlariDurumu.xml", str); str = service.SistemKodunaGoreGetir("2.16.840.1.113883.5.25"); myutil.LogToFile("HL7ClinicalDocument.xml", str); str = service.SistemKodunaGoreGetir("e469815c-5127-4ca1-ba75-3cae424dbb9c"); myutil.LogToFile("Adresler.xml", str); str = service.SistemKodunaGoreGetir("eb72bf5a-d70e-407e-9483-c4f9922743dc"); myutil.LogToFile("Persentil2.xml", str); str = service.SistemKodunaGoreGetir("BK62FA79-04AG-2EK0-1986-SU1B9A8T4443"); myutil.LogToFile("BedenKitleEndeksi.xml", str); str = service.SistemKodunaGoreGetir("2K26SAET-1YN0-9MCK-8MAK-38AA44ELNPBN"); myutil.LogToFile("BelCevresiSiniflandirmasi.xml", str); str = service.SistemKodunaGoreGetir("S34M4NBO-1030-3353-M44A-12AB45JK67PT"); myutil.LogToFile("BelKalcaOrani.xml", str); }
public void Ulkeler_xml_to_sistem() { CUtil myutil = new CUtil(); #region xmltext /* <BOLUM_KODU>10030</BOLUM_KODU> <ULKE_ADI>Brezilya</ULKE_ADI> <ULKE_KODU>BR</ULKE_KODU> <ULKE_ADI_ING>BRAZIL</ULKE_ADI_ING> */ #endregion XDocument doc = XDocument.Load(myutil.CalismaKlasoru() + "Ulkeler.xml"); var Kodlar = from p in doc.Elements("ULKELER").Elements("Records") select new { BOLUM_KODU = p.Element("BOLUM_KODU").Value, ULKE_ADI = p.Element("ULKE_ADI").Value, ULKE_KODU = p.Element("ULKE_KODU").Value, ULKE_ADI_ING = p.Element("ULKE_ADI_ING").Value }; Transaction.Instance.ExecuteNonQuery("delete from Ulke"); int i = 0; string sonsatir = edtsonuc.Items[edtsonuc.Items.Count - 1].ToString(); foreach (var kod in Kodlar) { if (kod.BOLUM_KODU == "null") continue; int kayitliasivarmi = 0; kayitliasivarmi = Transaction.Instance.ExecuteScalarI("Select count(Id) from Ulke where Id=@prm0 ", new object[] { kod.BOLUM_KODU }); if (kayitliasivarmi > 0) continue; i++; Ulke item = new Ulke(); item.Adi = kod.ULKE_ADI; item.Id = Convert.ToInt64(kod.BOLUM_KODU); item.Kodu = kod.ULKE_KODU; item.Insert(); edtsonuc.Items[edtsonuc.Items.Count - 1] = sonsatir + " (Ulke Kodları:" + i.ToString() + ")"; Application.DoEvents(); } }
public void ICD10_xml_to_sistem() { CUtil myutil = new CUtil(); #region xmltext /* <ICD_NO>12721</ICD_NO> <SBRS_REFERANS_NO>1</SBRS_REFERANS_NO> <ICD_ADI>Kristal artropatileri diğer, tanımlanmış, omuz bölgesi</ICD_ADI> <ICD_ADI_ENG>null</ICD_ADI_ENG> <ICD_KODU>M11.81</ICD_KODU> <SEVIYE>5</SEVIYE> <SURUM>1</SURUM> <AKTIF>0</AKTIF> <BILDIRIMI_ZORUNLU>1</BILDIRIMI_ZORUNLU> <OLUM_NEDENI>1</OLUM_NEDENI> <ICD_UST_KODU>M11.8</ICD_UST_KODU> <ICD_UST_NO>12041</ICD_UST_NO> <ANNE_OLUMU>1</ANNE_OLUMU> */ #endregion XDocument doc = XDocument.Load(myutil.CalismaKlasoru() + "ICD10.xml"); var Kodlar = from p in doc.Elements("ICDKODLARI").Elements("Records") select new { ICD_No = p.Element("ICD_NO").Value, SBRS_REFERANS_NO = p.Element("SBRS_REFERANS_NO").Value, ICD_ADI = p.Element("ICD_ADI").Value, ICD_KODU = p.Element("ICD_KODU").Value, SEVIYE = p.Element("SEVIYE").Value, SURUM = p.Element("SURUM").Value, AKTIF = p.Element("AKTIF").Value, BILDIRIMI_ZORUNLU = p.Element("BILDIRIMI_ZORUNLU").Value, OLUM_NEDENI = p.Element("OLUM_NEDENI").Value, ICD_UST_KODU = p.Element("ICD_UST_KODU").Value, ICD_UST_NO = p.Element("ICD_UST_NO").Value, ANNE_OLUMU = p.Element("ANNE_OLUMU").Value }; Transaction.Instance.ExecuteNonQuery("delete from teshis"); int i = 0; string sonsatir = edtsonuc.Items[edtsonuc.Items.Count - 1].ToString(); foreach (var kod in Kodlar) { i++; int kayitliasivarmi = 0; kayitliasivarmi = Transaction.Instance.ExecuteScalarI("Select count(Id) from teshis where Id=@prm0 ", new object[] { Convert.ToInt64(kod.ICD_No) }); if (kayitliasivarmi > 0) continue; Teshis item = new Teshis(); Teshis ustts = new Teshis(); ustts.Id = Convert.ToInt64(kod.ICD_UST_NO.ToString()); item.Adi = kod.ICD_ADI; item.Aktif = true;//kod.AKTIF == "1"; item.BildirimiZorunlumu = kod.BILDIRIMI_ZORUNLU == "1"; item.Id = Convert.ToInt64(kod.ICD_No); item.UstTeshis = ustts; item.OlumNedenimi = kod.OLUM_NEDENI == "1"; item.Kodu = kod.ICD_KODU; item.Insert(); edtsonuc.Items[edtsonuc.Items.Count - 1] = sonsatir + " (Teşhis Kodları:" + i.ToString() + ")"; Application.DoEvents(); } }
public void ButKodlari_xml_to_sistem() { CUtil myutil = new CUtil(); #region xmltext /* <SBRS_BUT_NO>1868</SBRS_BUT_NO> <BUT_KODU>606330</BUT_KODU> <BUT_ADI>Ruptüre anevrizma, aksiller-brakial arter, kol insizyonu ile</BUT_ADI> <UCRETI>545</UCRETI> <PUANI>920</PUANI> <ACIKLAMA>null</ACIKLAMA> <AKTIF>0</AKTIF> <BUT_TUR_NO>2</BUT_TUR_NO> <YILI>2006</YILI> <BUT_UST_NO>1849</BUT_UST_NO> <GUNCELLEME_TARIHI>2007-12-12T00:00:00+02:00</GUNCELLEME_TARIHI> */ #endregion XDocument doc = XDocument.Load(myutil.CalismaKlasoru() + "ButKodlari.xml"); var Kodlar = from p in doc.Elements("BUTKODLARI").Elements("Records") select new { SBRS_BUT_NO = p.Element("SBRS_BUT_NO").Value, BUT_KODU = p.Element("BUT_KODU").Value, BUT_ADI = p.Element("BUT_ADI").Value, UCRETI = p.Element("UCRETI").Value, PUANI = p.Element("PUANI").Value, ACIKLAMA = p.Element("ACIKLAMA").Value, AKTIF = p.Element("AKTIF").Value, BUT_TUR_NO = p.Element("BUT_TUR_NO").Value, YILI = p.Element("YILI").Value, BUT_UST_NO = p.Element("BUT_UST_NO").Value, GUNCELLEME_TARIHI = p.Element("GUNCELLEME_TARIHI").Value }; Transaction.Instance.ExecuteNonQuery("delete from Hizmet"); int i = 0; string sonsatir = edtsonuc.Items[edtsonuc.Items.Count - 1].ToString(); foreach (var kod in Kodlar) { if (kod.SBRS_BUT_NO == "null") continue; int kayitliasivarmi = 0; kayitliasivarmi = Transaction.Instance.ExecuteScalarI("Select count(Id) from hizmet where Id=@prm0 ", new object[] { kod.SBRS_BUT_NO }); if (kayitliasivarmi > 0) continue; i++; Hizmet item = new Hizmet(); if (kod.BUT_UST_NO != "null") { Hizmet ustitem = new Hizmet(); ustitem.Id = Convert.ToInt64(kod.BUT_UST_NO.ToString()); item.UstHizmet = ustitem; } if (kod.BUT_TUR_NO != "null") { HizmetTur itemtur = new HizmetTur(); itemtur.Id = Convert.ToInt64(kod.BUT_TUR_NO.ToString()); item.HizmetTur = itemtur; } item.Adi = kod.BUT_ADI; item.Aktif = true;// kod.AKTIF == "1"; item.Id = Convert.ToInt64(kod.SBRS_BUT_NO); item.Kodu = kod.BUT_KODU; item.Puani = Convert.ToDecimal(kod.PUANI); item.Aciklama = kod.ACIKLAMA; item.Ucreti = Convert.ToDecimal(kod.UCRETI); item.Insert(); edtsonuc.Items[edtsonuc.Items.Count - 1] = sonsatir + " (Hizmet Kodları:" + i.ToString() + ")"; Application.DoEvents(); } }
public void Kurumlar_xml_to_sistem() { CUtil myutil = new CUtil(); #region xmltext /* <SBRS_KURUM_NO>7346</SBRS_KURUM_NO> <SBRS_REFERANS_NO>0</SBRS_REFERANS_NO> <KURUM_ADI>THGM DOKU, HÜCRE VE KAN HİZMETLERİ DAİRE BAŞKANLIĞI KAN HİZMETLERİ ŞUBE MÜDÜRLÜĞÜ</KURUM_ADI> <KURUM_KODU>7346</KURUM_KODU> <KURUM_ILI>MERKEZ TEŞKİLAT</KURUM_ILI> <KURUM_ILCESI>YOK</KURUM_ILCESI> <KURUM_TUR_ADI>DİĞER</KURUM_TUR_ADI> <KURUM_TIPI>DİĞER</KURUM_TIPI> <SURUM>0</SURUM> <IL_KODU>99</IL_KODU> <ILCE_KODU>null</ILCE_KODU> <KURUM_TUR_KODU>99</KURUM_TUR_KODU> <AKTIF>1</AKTIF> */ #endregion XDocument doc = XDocument.Load(myutil.CalismaKlasoru() + "Kurumlar.xml"); var Kodlar = from p in doc.Elements("KURUMLAR").Elements("Records") select new { SBRS_KURUM_NO = p.Element("SBRS_KURUM_NO").Value, SBRS_REFERANS_NO = p.Element("SBRS_REFERANS_NO").Value, KURUM_ADI = p.Element("KURUM_ADI").Value, KURUM_KODU = p.Element("KURUM_KODU").Value, KURUM_ILI = p.Element("KURUM_ILI").Value, KURUM_ILCESI = p.Element("KURUM_ILCESI").Value, KURUM_TUR_ADI = p.Element("KURUM_TUR_ADI").Value, KURUM_TIPI = p.Element("KURUM_TIPI").Value, SURUM = p.Element("SURUM").Value, IL_KODU = p.Element("IL_KODU").Value, ILCE_KODU = p.Element("ILCE_KODU").Value, KURUM_TUR_KODU = p.Element("KURUM_TUR_KODU").Value, AKTIF = p.Element("AKTIF").Value }; Transaction.Instance.ExecuteNonQuery("delete from SevkKurum"); Transaction.Instance.ExecuteNonQuery("delete from SevkKurumtip"); int i = 0; edtsonuc.Items.Add(""); string sonsatir = edtsonuc.Items[edtsonuc.Items.Count - 1].ToString(); foreach (var kod in Kodlar) { if (kod.KURUM_KODU == "null") continue; int kayitliasivarmi = 0; kayitliasivarmi = Transaction.Instance.ExecuteScalarI("Select count(Id) from SevkKurum where Id=@prm0 ", new object[] { kod.SBRS_KURUM_NO }); if (kayitliasivarmi > 0) continue; i++; SevkKurum item = new SevkKurum(); item.Adi = kod.KURUM_ADI; item.Aktif = true;// kod.AKTIF == "1"; item.Id = Convert.ToInt64(kod.SBRS_KURUM_NO); item.Kodu = kod.KURUM_KODU; item.sehir = kod.KURUM_ILI; item.ilce = kod.KURUM_ILCESI; if (kod.IL_KODU != "null") item.sehirkodu = Convert.ToInt16(kod.IL_KODU); if (kod.ILCE_KODU != "null") item.ilcekodu = Convert.ToInt16(kod.ILCE_KODU); //sevkkurumtip tablosu dolduruluyor if (kod.KURUM_TUR_KODU != "null") { SevkKurumTip itemtip = new SevkKurumTip(); itemtip.Adi = kod.KURUM_TUR_ADI; itemtip.Kodu = kod.KURUM_TUR_KODU; itemtip.Turu = kod.KURUM_TIPI; long oid = Transaction.Instance.ExecuteScalarL("Select Id from SevkKurumTip where kodu=@prm0 ", new object[] { kod.KURUM_TUR_KODU }); if (oid == 0) itemtip.Insert(); else itemtip.Id = oid; item.Tipi = itemtip; } item.Insert(); edtsonuc.Items[edtsonuc.Items.Count - 1] = sonsatir + " (Kurum Tür-Tip kodları ve il-ilçeler:" + i.ToString() + ")"; Application.DoEvents(); } }
void btnkodxmlyaz_Click(object sender, EventArgs e) { try { edtsonuc.Items.Clear(); Cursor.Current = Cursors.WaitCursor; CUtil myutil = new CUtil(); Service service = new Service(); string str; edtsonuc.Items.Add("-------------------------------------------------------"); edtsonuc.Items.Add("XML dosyaları hazırlanacak:"); edtsonuc.Items.Add("-------------------------------------------------------"); for (int k = 0; k < lbkodlar.Items.Count; k++) if (lbkodlar.Items[k].CheckState == CheckState.Checked) { edtsonuc.Items.Add(myutil.CalismaKlasoru() + lbkodlar.Items[k].Description + ".xml yazılıyor..."); str = service.SistemKodunaGoreGetir(lbkodlar.Items[k].Value.ToString()); myutil.LogToFile(lbkodlar.Items[k].Description + ".xml", str); Application.DoEvents(); } edtsonuc.Items.Add("-------------------------------------------------------"); edtsonuc.Items.Add("XML yazma işlmleri bitti."); edtsonuc.Items.Add("-------------------------------------------------------"); } finally { Cursor.Current = Cursors.Default; } }
void btnsistemekaydet_Click(object sender, EventArgs e) { try { if (Current.AktifDoktorId == 0) { MessageBox.Show("Aktif Doktor belirsiz devam edemezsiniz.", "Hata"); return; } edtsonuc.Items.Clear(); Cursor.Current = Cursors.WaitCursor; CUtil myutil = new CUtil(); Service service = new Service(); edtsonuc.Items.Add("-------------------------------------------------------"); edtsonuc.Items.Add("Kodlar bakanlıktan indirilerek sisteme yazılacak:"); edtsonuc.Items.Add("-------------------------------------------------------"); for (int k = 0; k < lbkodlar.Items.Count; k++) if (lbkodlar.Items[k].CheckState == CheckState.Checked) { edtsonuc.Items.Add(lbkodlar.Items[k].Description + " sisteme kaydediliyor..."); try { switch (lbkodlar.Items[k].Value.ToString()) { case "1572FCEE-2E3D-4500-9BA4-743BE9A581A7": ICD10_xml_to_sistem(); break; case "AF7BB2C3-3AEF-433A-BD0A-EA7416D3D586": IlacKodlari_xml_to_sistem(); break; case "6B3CA76A-D43D-46F0-9161-E298DB78ABE1": ButKodlari_xml_to_sistem(); break; case "f85fc6de-b865-4e83-a4c0-ab1c5a07422c": ButTurleri_xml_to_sistem(); break; case "c9dbe1cb-57cb-48fb-bdd3-d622e0e304c6": Kurumlar_xml_to_sistem(); break; case "c9dbe1cb-57cb-48fb-bdd3-d622e0e304xx": Kurumlarilici_xml_to_sistem(); break; case "43B06D1E-A7D2-4920-A4E7-6534F6C1D199": Klinikler_xml_to_sistem(); break; case "BD8C6F17-430B-4F90-83E2-E0276052384C": Asi_xml_to_sistem(); break; case "e469815c-5127-4ca1-ba75-3cae424dbb9c": Adresler_xml_to_sistem(); break; case "c5a8d278-daa8-4774-a390-ab444e02db32": Ulkeler_xml_to_sistem(); break; //case "5EE0AB29-6B92-4356-B287-6CF93E052362": TetkikKodlari_xml_to_sistem(); break; //TODO:gonderal:takvimler ile ilgili yapı bakanlıktan farklı bu nedenle importu ya setupda verilen db de sabit gidecek ya da bilahare düşünülecek //................................................................................. //case "1c1ba2a9-01e1-46c7-8b38-44": TakvimBebekIzlem_xml_to_sistem(); break; //case "377153f3-8de1-4515-9833-746bf81b041b": TakvimAsi_xml_to_sistem(); break; //case "4259c680-ef30-4243-ac52-019c5a7e71ed": TakvimGebeIzlem_xml_to_sistem(); break; //case "9416085f-6a12-470a-bc19-66ee19293768": TakvimCocukIzlem_xml_to_sistem(); break; //................................................................................. default: break; } } catch { } Application.DoEvents(); } edtsonuc.Items.Add("-------------------------------------------------------"); edtsonuc.Items.Add("sisteme yazma işlemleri bitti."); edtsonuc.Items.Add("-------------------------------------------------------"); } finally { Cursor.Current = Cursors.Default; } }
public void Asi_xml_to_sistem() { CUtil myutil = new CUtil(); #region xmltext /* <SBRS_ASI_NO>1</SBRS_ASI_NO> <SBRS_REFERANS_NO>15768</SBRS_REFERANS_NO> <ASI_ADI>(BCG) Tüberküloz asisi (Bacille Calmette - Guerin) </ASI_ADI> <ASI_KODU>16</ASI_KODU> <ASI_HL7_ADI>Tuberculosis Vaccine (Bacille Calmette - Guerin)</ASI_HL7_ADI> <ASI_HL7_KODU>BCG</ASI_HL7_KODU> <SURUM>1</SURUM> <AKTIF>0</AKTIF> <ZORUNLU>0</ZORUNLU> */ #endregion XDocument doc = XDocument.Load(myutil.CalismaKlasoru() + "Asi.xml"); var Kodlar = from p in doc.Elements("ASI").Elements("Records") select new { SBRS_ASI_NO = p.Element("SBRS_ASI_NO").Value, SBRS_REFERANS_NO = p.Element("SBRS_REFERANS_NO").Value, ASI_ADI = p.Element("ASI_ADI").Value, ASI_KODU = p.Element("ASI_KODU").Value, ASI_HL7_ADI = p.Element("ASI_HL7_ADI").Value, ASI_HL7_KODU = p.Element("ASI_HL7_KODU").Value, SURUM = p.Element("SURUM").Value, AKTIF = p.Element("AKTIF").Value, ZORUNLU = p.Element("ZORUNLU").Value }; Transaction.Instance.ExecuteNonQuery("delete from AsiTanim"); int i = 0; string sonsatir = edtsonuc.Items[edtsonuc.Items.Count - 1].ToString(); foreach (var kod in Kodlar) { if (kod.SBRS_ASI_NO == "null") continue; int kayitliasivarmi = 0; kayitliasivarmi = Transaction.Instance.ExecuteScalarI("Select count(Id) from AsiTanim where kodu=@prm0 ", new object[] { kod.ASI_KODU }); if (kayitliasivarmi > 0) continue; i++; AsiTanim item = new AsiTanim(); item.Adi = kod.ASI_ADI; item.Aktif = true;// kod.AKTIF == "1"; item.Id = Convert.ToInt64(kod.SBRS_ASI_NO); item.Kodu = kod.ASI_KODU; item.Zorunlumu = kod.ZORUNLU == "1"; item.HL7Adi = kod.ASI_HL7_ADI; item.HL7Kodu = kod.ASI_HL7_KODU; item.Insert(); edtsonuc.Items[edtsonuc.Items.Count - 1] = sonsatir + " (Aşı Tanım Kodları:" + i.ToString() + ")"; Application.DoEvents(); } }
public void IlacKodlari_xml_to_sistem() { CUtil myutil = new CUtil(); #region xmltext /* <SBRS_ILAC_NO>50020006</SBRS_ILAC_NO> <SBRS_REFERANS_NO>0</SBRS_REFERANS_NO> <ILAC_ADI>EQITAX 500 MG IM / IV 1 FLK</ILAC_ADI> <ILAC_ITHALATCI_NO>0</ILAC_ITHALATCI_NO> <ILAC_URETICI_NO>0</ILAC_URETICI_NO> <FIYATI>0</FIYATI> <FIYAT_BIRIMI>null</FIYAT_BIRIMI> <ILAC_FORM_NO>0</ILAC_FORM_NO> <BARKODU>8699814270260</BARKODU> <ILAC_ARAMA_ADI>EQITAX 500 MG IM / IV 1 FLK</ILAC_ARAMA_ADI> <RECETE_TURU>null</RECETE_TURU> <AZAMI_DOZAJ>null</AZAMI_DOZAJ> <DOZAJ_BIRIMI>null</DOZAJ_BIRIMI> <AKTIF>0</AKTIF> <SURUM>1</SURUM> <SIRA_NO>50020006</SIRA_NO> */ #endregion XDocument doc = XDocument.Load(myutil.CalismaKlasoru() + "IlacKodlari.xml"); var Kodlar = from p in doc.Elements("ILACKODLARI").Elements("Records") select new { SBRS_ILAC_NO = p.Element("SBRS_ILAC_NO").Value, SBRS_REFERANS_NO = p.Element("SBRS_REFERANS_NO").Value, ILAC_ADI = p.Element("ILAC_ADI").Value, ILAC_ITHALATCI_NO = p.Element("ILAC_ITHALATCI_NO").Value, ILAC_URETICI_NO = p.Element("ILAC_URETICI_NO").Value, FIYATI = p.Element("FIYATI").Value, FIYAT_BIRIMI = p.Element("FIYAT_BIRIMI").Value, ILAC_FORM_NO = p.Element("ILAC_FORM_NO").Value, BARKODU = p.Element("BARKODU").Value, ILAC_ARAMA_ADI = p.Element("ILAC_ARAMA_ADI").Value, RECETE_TURU = p.Element("RECETE_TURU").Value, AZAMI_DOZAJ = p.Element("AZAMI_DOZAJ").Value, DOZAJ_BIRIMI = p.Element("DOZAJ_BIRIMI").Value, AKTIF = p.Element("AKTIF").Value, SURUM = p.Element("SURUM").Value, SIRA_NO = p.Element("SIRA_NO").Value }; Transaction.Instance.ExecuteNonQuery("delete from ilac"); int i = 0; string sonsatir = edtsonuc.Items[edtsonuc.Items.Count - 1].ToString(); foreach (var kod in Kodlar) { i++; int kayitliasivarmi = 0; kayitliasivarmi = Transaction.Instance.ExecuteScalarI("Select count(Id) from ilac where barkod=@prm0 ", new object[] { kod.BARKODU }); if (kayitliasivarmi > 0) continue; if (kod.AKTIF == "0") continue; ilac item = new ilac(); item.Adi = kod.ILAC_ADI; item.Aktif = true;// kod.AKTIF == "1"; item.AzamiDozaj = kod.AZAMI_DOZAJ; item.Barkod = kod.BARKODU; item.Id = Convert.ToInt64(kod.SBRS_ILAC_NO); if (kod.RECETE_TURU != "null") item.Turu = (myenum.ReceteTur)Convert.ToInt32(kod.RECETE_TURU); item.Insert(); edtsonuc.Items[edtsonuc.Items.Count - 1] = sonsatir + " (İlaç Kodları:" + i.ToString() + ")"; Application.DoEvents(); } }