private void btnKaydet_ItemClick(object sender, ItemClickEventArgs e) { DevExpress.DashboardCommon.Dashboard rep = new DevExpress.DashboardCommon.Dashboard(); int iEkleyenID = 0; iEkleyenID = Genel.AktifKullaniciID; DashboardParameter prmUser = new DashboardParameter(); prmUser.Name = "EkleyenID"; prmUser.Type = typeof(System.Int32); prmUser.Value = iEkleyenID; prmUser.Description = "EkleyenID"; prmUser.Visible = false; rep.Parameters.Add(prmUser); MemoryStream stream = new MemoryStream(); rep.SaveToXml(stream); stream.Position = 0; byte[] RaporData = Genel.StreamToByteArray(stream); var IslemEkle = data.IUD_Evraklar(1, -1, RaporData, txtAdi.Text, txtAdi.Text, -1, -1, true, false, -1, -1, true, Genel.AktifKullaniciID).ToList(); if (IslemEkle != null && IslemEkle.FirstOrDefault().ID > 0) { //Ayar.InfoMesajGoster(Genel.DilGetirMesaj(1017), Ayar.MesajTipi.Bilgi, this); } }
void dasboard_DataLoading(object sender, DashboardDataLoadingEventArgs e) { if (datasourcedisardan != null) { foreach (DataTable item in datasourcedisardan.Tables) { if (e.DataSource.Name == item.TableName) { e.Data = item; } } } else { DataSet datasourcelist = Genel.DsGetir(DashboardID, true); foreach (DataTable item in datasourcelist.Tables) { if (e.DataSource.Name == item.TableName) { e.Data = item; } } } // var list = Application.OpenForms; // list[1].BeginInvoke(new Action(() => list[1].Hide())); // var asdf = ""; }
/// <summary> /// Dashboard formundaki layout ayarlarını kaydeder. /// </summary> public static byte[] DashboardLayoutToByte(int iDashboardID, DockManager dm) { System.IO.Stream str; str = new System.IO.MemoryStream(); dm.SaveLayoutToStream(str); str.Seek(0, System.IO.SeekOrigin.Begin); byte[] Layout = Genel.StreamToByteArray(str); return(Layout); //MListler.MList_S_Dashboard = Genel.PrmDb.S_Dashboard(0, Genel.DilID).ToList(); }
private void dasboard_DataLoading(object sender, DashboardDataLoadingEventArgs e) { DataSet datasourcelist = Genel.DsGetir(DashboardID, true); foreach (DataTable item in datasourcelist.Tables) { if (e.DataSource.Name == item.TableName) { e.Data = item; } } }
private void btnGiris_Click(object sender, EventArgs e) { int kullaniciid = 0; string KullaniciAyarlari = ""; if (Convert.ToBoolean(toggHatirla.EditValue)) { KullaniciAyarlari += txtKullaniciAdi.Text.Trim() + ";"; } else { KullaniciAyarlari += ";"; } KullaniciAyarlari += toggHatirla.EditValue.ToString() + ";"; Genel.TextDosyaYaz(Genel.ProgramYolu + "PrmParams.txt", KullaniciAyarlari); var list = data.S_KullaniciGirisKontrol(txtKullaniciAdi.Text, txtParola.Text).ToList(); if (Convert.ToInt32(list.FirstOrDefault().ID) > 0) { kullaniciid = Convert.ToInt32(list.FirstOrDefault().ID); Genel.AktifKullaniciID = kullaniciid; Genel.AktifKullaniciAdi = txtKullaniciAdi.Text; var ayarlar = data.S_KullaniciAyarlari(kullaniciid).ToList(); if (ayarlar.Count > 0) { Genel.AktifKullanici_DashboardID = ayarlar.FirstOrDefault().DashboardID; Genel.AktifKullanici_DashboardOtomatikYenilensinMi = ayarlar.FirstOrDefault().DashboardYenileme; Genel.AktifKullanici_DashboardYenilemeSuresi = ayarlar.FirstOrDefault().DashboardYenilemeSure; } else { Genel.AktifKullanici_DashboardID = 0; Genel.AktifKullanici_DashboardOtomatikYenilensinMi = false; Genel.AktifKullanici_DashboardYenilemeSuresi = 0; } this.Hide(); Master frm = new Master(); frm.ShowDialog(); } else { XtraMessageBox.Show("Kullanici Adı veya Parola hatalı!", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public S_Evraklar_Result Evrak = new S_Evraklar_Result(); //Model.S_Evraklar_Result Evrak = new Model.S_Evraklar_Result(); public void Datagetir() { //açınca ekran kitleniyor. incelemek lazım. //SplashScreenManager.ShowForm(this, typeof(BarduckCRM.Bekleyiniz), true, true); //SplashScreenManager.CloseForm(); Evrak = data.S_Evraklar(DashboardID, true, 1).FirstOrDefault(); //Genel.PrmDb.S_Evraklar(DashboardID, true, Genel.DilID).FirstOrDefault(); var DosyaYolu = data.S_AyarKarakter(2, 1).FirstOrDefault().Deger; //Genel.PrmDb.S_AyarKarakter(2, Genel.DilID).FirstOrDefault().Deger; DosyaYolu += Evrak.DosyaAdi + ".xml"; byte[] bytearry = data.S_DosyaGet(DosyaYolu).FirstOrDefault(); if (bytearry == null) { //Ayar.InfoMesajGoster(Genel.DilGetirMesaj(0), Ayar.MesajTipi.Hata, this); return; } Stream RepData = Genel.ByteArrayToStream(bytearry); DevExpress.DashboardCommon.Dashboard dasboard = new DevExpress.DashboardCommon.Dashboard(); dasboard.BeginUpdateLayout(); dasboard.LoadFromXml(RepData); dasboard.DataLoading += dasboard_DataLoading; dasboard.EndUpdateLayout(); // DataSet datasourcelist = Ayar.DsGetir(DashboardID, MusteriID, ProjeID, AktiviteID, Parametre4, Parametre5, Parametre6, Parametre7, Parametre8, Parametre9, Parametre10); //// dasboard.DataSources.Clear(); // foreach (DataTable item in datasourcelist.Tables) // { // dasboard.AddDataSource(item.TableName, item); // //if (dasboard.DataSources.Where(z => z.Name == item.TableName).FirstOrDefault() == null) // //{ // // dasboard.AddDataSource(item.TableName, item); // //} // } if (dasboard != null) { dashboardViewer1.Dashboard = dasboard; // dashboardViewer1.PopulateUnusedDataSources = true; // dashboardViewer1.ReloadData(); } }
private void GorunumKaydet() { try { if (Genel.AktifKullaniciID < 1) { return; } RibbonPageGroup grp = ribbonControl1.Pages[1].Groups[0]; //BenimMenum string strBenimMenum = ""; foreach (BarItemLink lnk in grp.ItemLinks) { BarItem item = lnk.Item; strBenimMenum += item.Name + ";"; } if (!bFormYuklendiMi) { return; } #region Quick Access Toolbar ayarları stream değişkene atılıyor... System.IO.Stream str; str = new System.IO.MemoryStream(); ribbonControl1.Toolbar.SaveLayoutToStream(str); str.Seek(0, System.IO.SeekOrigin.Begin); byte[] QAT = Genel.StreamToByteArray(str); #endregion //bool bSolNavigasyonAcikMi = false; //if (nbcNavigasyon.OptionsNavPane.NavPaneState == DevExpress.XtraNavBar.NavPaneState.Expanded) // bSolNavigasyonAcikMi = true; data.IUD_KullaniciAyarlari(Genel.AktifKullaniciID, DevExpress.LookAndFeel.UserLookAndFeel.Default.SkinName.ToString(), strBenimMenum, QAT, ribbonControl1.ToolbarLocation.ToString(), false, -1, -1, false, -1, 2);//bSolNavigasyonAcikMi, iSolNavigasyonGenislik } catch (Exception Hata) { //Genel.LogErrorYaz(iFormID, Hata); //XtraMessageBox.Show(Genel.DilGetirMesaj(1034) + "\n\n" + Hata.Message, Genel.DilGetirMesaj(2), MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void MasterGiris_Load(object sender, EventArgs e) { barStaticVersiyon.Caption = "Versiyon " + System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString(); txtKullaniciAdi.Focus(); if (File.Exists(Genel.ProgramYolu + "PrmParams.txt")) { string[] Ayarlar = Genel.TextDosyaOku(Genel.ProgramYolu + "PrmParams.txt").Split(';'); string KullaniciAdi = Ayarlar[0]; bool BeniHatirla = Convert.ToBoolean(Ayarlar[1]); if (BeniHatirla) { txtKullaniciAdi.Text = KullaniciAdi; } toggHatirla.EditValue = BeniHatirla; } //SirketCombosuOlustur(); }
/// <summary> /// Dashboard formundaki layout ayarlarını getirir. /// </summary> public static Stream DashboardLayoutGetir(int iDashboardID) { BarduckCRMEntities data = new BarduckCRMEntities(); try { var List = data.S_Dashboard(iDashboardID, -1).ToList(); //MListler.MList_S_Dashboard.Where(u => u.ID == iDashboardID); if (List == null) { return(null); } byte[] bLayout = null; bLayout = (byte[])List.FirstOrDefault().Layout; return(Genel.ByteArrayToStream(bLayout)); } catch (Exception exc) { return(null); } }
private void btnTasarim_ItemClick(object sender, ItemClickEventArgs e) { //DevExpress.DashboardCommon.Dashboard dasboard = new DevExpress.DashboardCommon.Dashboard(); //var DosyaYolu = data.S_AyarKarakter(2, 1).ToList().FirstOrDefault().Deger + "dash.xml";//gv.GetRowCellValue(iRowID, "DosyaAdi").ToString() + ".xml"; //if (DosyaYolu == null) // return; //byte[] bytearry = data.S_DosyaGet(DosyaYolu).FirstOrDefault(); //if (bytearry != null) //{ // Stream RepData = Genel.ByteArrayToStream(bytearry); // dasboard.LoadFromXml(RepData); //} ////DataSet datasourcelist = Ayar.DsGetir(iSelectedReportID, 1, 1, 1, 1, 1, 1, 1, 1, 1, 99, true); //////dasboard.DataSources.Clear(); ////foreach (DataTable item in datasourcelist.Tables) ////{ //// if (dasboard.DataSources.Where(z => z.Name == item.TableName).FirstOrDefault() == null) //// { //// dasboard.AddDataSource(item.TableName, item); //// } ////} ////dasboard.DataLoading += dasboard_DataLoading; //DashboardTasarim frm = new DashboardTasarim(dasboard); //frm.Show(); #region Dashboard var DosyaYolu = data.S_AyarKarakter(2, 1).FirstOrDefault().Deger + DosyaAdi + ".xml"; byte[] bytearry = data.S_DosyaGet(DosyaYolu).FirstOrDefault(); if (bytearry != null) { Stream RepData = Genel.ByteArrayToStream(bytearry); DevExpress.DashboardCommon.Dashboard dasboard = new DevExpress.DashboardCommon.Dashboard(); dasboard.LoadFromXml(RepData); DataSet datasourcelist = Genel.DsGetir(DashboardID, true); //dasboard.DataSources.Clear(); foreach (DataTable item in datasourcelist.Tables) { if (dasboard.DataSources.Where(z => z.Name == item.TableName).FirstOrDefault() == null) { dasboard.AddDataSource(item.TableName, item); } } dasboard.DataLoading += dasboard_DataLoading; DashboardTasarim rep = new DashboardTasarim(dasboard); rep.ShowDialog(); if (rep.SaveDashboard) { MemoryStream stream = new MemoryStream(); rep.Dashboard.SaveToXml(stream); stream.Position = 0; byte[] RaporData = Genel.StreamToByteArray(stream); data.IUD_Evraklar(4, DashboardID, RaporData, null, null, null, null, null, null, null, null, true, Genel.AktifKullaniciID); } } #endregion }
private void XtraForm3_Load(object sender, EventArgs e) { try { Cursor.Current = Cursors.WaitCursor; tabPane1.SelectedPageIndex = 0; //tab ların hangisi seçili geleceğini belirler. barLblKayitAktifPasif.Caption = "Pasif Kayıt"; barLblKayitAktifPasif.Glyph = BarduckCRM.Properties.Resources.Apply_16x16; barLblKayitID.Caption = "0"; barLblKayitTarihi.Caption = "0"; var list = data.S_Tip(-1).ToList(); if (list.Count > 0) { cmbMedeniHali.Properties.DataSource = list.Where(c => c.UstID == 44).ToList(); cmbMeslek.Properties.DataSource = list.Where(c => c.UstID == 2).ToList(); } tipresimli = data.S_TipResimli(52).ToList(); if (tipresimli.Count > 0) { cmbOnek.Properties.DataSource = tipresimli; } var ulkelist = data.S_Ulke(-1).ToList(); if (ulkelist.Count > 0) { cmbUlke.Properties.DataSource = ulkelist; cmbUyrugu.Properties.DataSource = ulkelist; } //var firmalist = data.S_Firma(-1).ToList(); //if(firmalist.Count>0) // cmbFirma.Properties.DataSource = firmalist; if (kayitid > 0) { DataGetir(kayitid); } //if (kayitid > 0) // KayitIzlemeModu(true); //FormYetkileri(1); var esnekozeltercihler = Data.EsnekKayitlar(1, kayitid).ToList(); if (esnekozeltercihler.Count > 0) { grdOTT.DataSource = esnekozeltercihler; } var geneltercihler = Data.EsnekKayitlar(2, kayitid).ToList(); if (geneltercihler.Count > 0) { DataTable dt = Genel.ListToDt(geneltercihler); checkedListBoxControl1.ValueMember = "ID"; checkedListBoxControl1.DisplayMember = "Aciklama"; checkedListBoxControl1.CheckMember = "Checkbox"; checkedListBoxControl1.DataSource = dt; } Cursor.Current = Cursors.Default; } catch (Exception hata) { Cursor.Current = Cursors.Default; } }