void FillData() { DataTable dtGrid = new DataTable(); dtGrid.Columns.Add("Ref"); dtGrid.Columns.Add("authRef"); dtGrid.Columns.Add("Modül"); dtGrid.Columns.Add("menuRef"); dtGrid.Columns.Add("authSee", typeof(bool)); dtGrid.Columns.Add("authAdd", typeof(bool)); dtGrid.Columns.Add("authUpdate", typeof(bool)); dtGrid.Columns.Add("authShow", typeof(bool)); db.AddParameterValue("@ref", this._Ref); dgwGrid.DataSource = dtGrid; grdGrid.Columns[0].Visible = false; grdGrid.Columns[1].Visible = false; grdGrid.Columns[2].Caption = "Modül"; grdGrid.Columns[3].Caption = "Form"; grdGrid.Columns[4].Caption = "Görüntüleme Yetkisi"; grdGrid.Columns[5].Caption = "Ekleme Yetkisi"; grdGrid.Columns[6].Caption = "Güncelleme Yetkisi"; grdGrid.Columns[7].Caption = "İnceleme Yetkisi"; grdGrid.Columns[0].OptionsColumn.AllowEdit = false; grdGrid.Columns[1].OptionsColumn.AllowEdit = false; grdGrid.Columns[2].OptionsColumn.AllowEdit = false; grdGrid.Columns[3].OptionsColumn.AllowEdit = false; db.AddParameterValue("@active", true); db.AddParameterValue("@type", "Form"); DataTable dt2 = db.GetDataTable("select * from sysMenu where Active=@active and type=@type"); RepositoryItemLookUpEdit riledType; riledType = new DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit(); riledType.BeginInit(); riledType.Columns.Add(new LookUpColumnInfo() { FieldName = "Ref", Caption = "Ref", Visible = false }); riledType.Columns.Add(new LookUpColumnInfo() { FieldName = "description", Caption = "Ad" }); riledType.NullText = "Seçim Yapınız"; riledType.DisplayMember = "description"; riledType.ValueMember = "Ref"; riledType.DataSource = dt2; dgwGrid.RepositoryItems.Add(riledType); grdGrid.Columns[3].ColumnEdit = riledType; for (int i = 0; i < dt2.Rows.Count; i++) { DataRow row = dtGrid.NewRow(); row["menuRef"] = int.Parse(dt2.Rows[i]["Ref"].ToString()); db.AddParameterValue("@ref", dt2.Rows[i]["Ref"].ToString()); string code = db.GetScalarValue("select code from sysMenu where Ref=@ref").ToString(); db.AddParameterValue("@code", code); row["Modül"] = db.GetScalarValue("select [description] from sysMenu where code=@code and type='AnaMenu'").ToString(); row["authSee"] = true; row["authAdd"] = true; row["authUpdate"] = true; row["authShow"] = true; dtGrid.Rows.Add(row); } grdGrid.BestFitColumns(); grdGrid.RefreshData(); RowCount = grdGrid.RowCount; grdGrid.BestFitColumns(); if (this._FormMod == Enums.enmFormMod.Guncelle) { db.AddParameterValue("@ref", this._Ref); DataTable dt = db.GetDataTable("select * from SysAuths where Ref=@ref"); txtCode.SetString(dt.Rows[0]["code"].ToString()); txtName.SetString(dt.Rows[0]["name"].ToString()); db.AddParameterValue("@ref", this._Ref); DataTable dtData = db.GetDataTable(@"SELECT SysAuthDetails.Ref AS Ref,sysAuthDetails.authRef as authRef,sysAuthDetails.MenuRef,sysAuthDetails.authSee,sysAuthDetails.authAdd,sysAuthDetails.authUpdate,sysAuthDetails.authShow FROM SysAuths JOIN sysAuthDetails ON SysAuths.Ref = sysAuthDetails.authRef where sysAuthDetails.authRef=@ref"); dtGrid.Rows.Clear(); for (int i = 0; i < dtData.Rows.Count; i++) { DataRow row = dtGrid.NewRow(); int Ref = int.Parse(dtData.Rows[i]["menuRef"].ToString()); row["Ref"] = dtData.Rows[i]["Ref"].ToString(); row["authRef"] = this._Ref; row["menuRef"] = Ref; db.AddParameterValue("@ref", Ref); string code = db.GetScalarValue("select code from sysMenu where Ref=@ref").ToString(); db.AddParameterValue("@code", code); row["Modül"] = db.GetScalarValue("select [description] from sysMenu where code=@code and type='AnaMenu'").ToString(); row["authSee"] = bool.Parse(dtData.Rows[i]["authSee"].ToString()); row["authAdd"] = bool.Parse(dtData.Rows[i]["authAdd"].ToString()); row["authUpdate"] = bool.Parse(dtData.Rows[i]["authUpdate"].ToString()); row["authShow"] = bool.Parse(dtData.Rows[i]["authShow"].ToString()); dtGrid.Rows.Add(row); } grdGrid.BestFitColumns(); grdGrid.RefreshData(); } }
void SetForm() { chkActive.SetString("Aktif"); chkActive.SetBoolValue(true); dtBox.Columns.Clear(); dtBox.Columns.Add("İndirim Tipi", typeof(int)); dtBox.Columns.Add("Ref", typeof(int)); dtBox.Columns.Add("Liste Ref"); dtBox.Columns.Add("Kart Ref"); dtBox.Columns.Add("Kart Kodu", typeof(string)); dtBox.Columns.Add("Kart Adı", typeof(string)); dtBox.Columns.Add("Renk"); dtBox.Columns.Add("Beden"); dtBox.Columns.Add("Barkod", typeof(string)); dtBox.Columns.Add("Birim Ref"); dtBox.Columns.Add("Birim Kodu"); dtBox.Columns.Add("Eski Fiyat", typeof(decimal)); dtBox.Columns.Add("Oran", typeof(decimal)); dtBox.Columns.Add("Yeni Fiyat", typeof(decimal)); dtBox.Rows.Clear(); dgwGrid.DataSource = dtBox; RepositoryItemButtonEdit riBtnStockCode; riBtnStockCode = new RepositoryItemButtonEdit(); dgwGrid.RepositoryItems.Add(riBtnStockCode); riBtnStockCode.ButtonClick += riBtnStockCode_Click; RepositoryItemLookUpEdit riledType; riledType = new DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit(); riledType.BeginInit(); riledType.Columns.Add(new LookUpColumnInfo() { FieldName = "Key", Caption = "Ref", Visible = false }); riledType.Columns.Add(new LookUpColumnInfo() { FieldName = "Value", Caption = "Ad" }); riledType.NullText = "Seçim Yapınız"; riledType.DisplayMember = "Value"; riledType.ValueMember = "Key"; riledType.DataSource = FlashDictionary.discountType.ToList(); dgwGrid.RepositoryItems.Add(riledType); dgwGrid.DataSource = dtBox; grdGrid.Columns[1].Visible = false; grdGrid.Columns[2].Visible = false; grdGrid.Columns[3].Visible = false; grdGrid.Columns[4].ColumnEdit = riBtnStockCode; grdGrid.Columns[0].ColumnEdit = riledType; //grdGrid.Columns[8].ColumnEdit = riLedUnit; grdGrid.Columns[9].Visible = false; grdGrid.Columns[4].OptionsColumn.ReadOnly = false; grdGrid.Columns[5].OptionsColumn.AllowEdit = false; grdGrid.Columns[6].OptionsColumn.AllowEdit = false; grdGrid.Columns[7].OptionsColumn.AllowEdit = false; grdGrid.Columns[3].OptionsColumn.AllowEdit = false; grdGrid.Columns[10].OptionsColumn.AllowEdit = false; grdGrid.BestFitColumns(); grdGrid.RefreshData(); }