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();
}
}
