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