Ay: Kasım 2020

string yol = Application.StartupPath;string fileName = yol + “\gridlayout\maliyettablo.xml”; string uygulamayolu = “DbAyar.EXE”;System.Diagnostics.Process.Start(uygulamayolu);

baglanti.Open();komut = new OleDbCommand(“Select * From Urunler Where UrunID=” + urunID, baglanti);OleDbDataReader oku = komut.ExecuteReader();while (oku.Read()){textEdit1.Text = oku[“UrunID”].ToString();textEdit2.Text = oku[“UrunAd”].ToString();textEdit3.Text = oku[“KategoriAd”].ToString();textEdit4.Text = oku[“UrunAdet”].ToString();textEdit5.Text = oku[“UrunBirim”].ToString();textEdit6.Text = oku[“UrunFiyat”].ToString();memoEdit1.Text = oku[“UrunAciklama”].ToString();}baglanti.Close();

private void gridView1_RowStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowStyleEventArgs e){GridView View = sender as GridView;if (e.RowHandle >= 0){string okunma = View.GetRowCellDisplayText(e.RowHandle, View.Columns[“AKTIF”]);if (okunma == “0”){e.Appearance.BackColor = Color.Red; private void gridView1_RowCellStyle(object sender, RowCellStyleEventArgs e){//Hücre içinGridView View = sender as GridView;// if (e.Column.FieldName == “FIRM” || e.Column.FieldName == “PROJE”)if (e.Column.FieldName == “ENVANTER_DEGERI”){string category = View.GetRowCellDisplayText(e.RowHandle, View.Columns[“ENVANTER_DEGERI”]);if (category == “0” || category…
Devamı

if (SqlClass.dsGenel.Tables.Contains(“tblMarkalar”)){SqlClass.dsGenel.Tables.Remove(“tblMarkalar”);SqlClass.dsGenel.Tables.Remove(“tblMarkalar”);}string sqlCumle = “SELECT [MARKA] FROM [Erdemler].[dbo].[Umt_055_Markalar] ORDER BY MARKA”;SqlClass.dsGenel = SqlClass.GetDataset(sqlCumle, “tblMarkalar”);

SqlCommand cmd = new SqlCommand();cmd.Connection = Mainform.baglan;if (this.useridx == 0){cmd.CommandText = “INSERT INTO TanimUser (Kullanici, Sifre, Adi, Soyadi, LogoUser, LogoPass,Plasiyer,Yonetici,PlsGrpYonetici) VALUES (@Kullanici, @Sifre, @Adi, @Soyadi, @LogoUser, @LogoPass,@Plasiyer,@Yonetici,@PlsGrpYonetici)”;}else{cmd.CommandText = “Update TanimUser SET Kullanici=@Kullanici, Sifre=@Sifre, Adi=@Adi, Soyadi=@Soyadi, LogoUser=@LogoUser, LogoPass=@LogoPass, Plasiyer=@Plasiyer,Yonetici=@Yonetici,PlsGrpYonetici=@PlsGrpYonetici WHERE Id = @Id “;}cmd.Parameters.AddWithValue(“@Id”, this.useridx);cmd.Parameters.AddWithValue(“@Kullanici”, this.txtkuladi.Text);cmd.Parameters.AddWithValue(“@Sifre”, this.txtkulsifre.Text);cmd.Parameters.AddWithValue(“@Adi”, this.txtkuladi.Text);cmd.Parameters.AddWithValue(“@Soyadi”, this.txtsoyadi.Text);cmd.Parameters.AddWithValue(“@LogoUser”, this.txtlogokuladi.Text);cmd.Parameters.AddWithValue(“@LogoPass”, this.txtlogokulsifre.Text);cmd.Parameters.AddWithValue(“@Plasiyer”, this.btnplasiyer.Text);cmd.Parameters.AddWithValue(“@Yonetici”, yoneticimi);cmd.Parameters.AddWithValue(“@PlsGrpYonetici”, PlasierGrupYoneticimi);Mainform.baglantiac();cmd.ExecuteNonQuery();DevExpress.XtraEditors.XtraMessageBox.Show(“Kullanıcı Ekleme-Güncelleme Başarılı….”,…
Devamı