private void grdPerson_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
try
{
int Kullanilan = 0, Kullanilabilir = 0, Kazanilan = 0;
if (!string.IsNullOrEmpty(grdPerson.GetFocusedRowCellValue("Ref").ToString()))
{
int Ref = int.Parse(grdPerson.GetFocusedRowCellValue("Ref").ToString());
db.AddParameterValue("@pRef", Ref);
DataTable dt = db.GetDataTable(@"SELECT
Ref,
pRef,
tbPermission.pType AS[İzin Tipi],
tbPermission.pSDate AS[Başlangıç Tarihi],
tbPermission.pFDate AS[Bitiş Tarihi],
tbPermission.pWSDate AS[İşe Başlama Tarihi],
tbPermission.pRequest AS[Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock)
WHERE
pRef=@pRef");
gridControl2.DataSource = dt;
gridView2.Columns[0].Visible = false;
gridView2.Columns[1].Visible = false;
if (dt.Rows.Count > 0)
{
gridView2.BestFitColumns();
}
db.AddParameterValue("@ref", Ref);
Kazanilan = int.Parse(db.GetScalarValue("Select gain from tbPerson where Ref=@ref").ToString());
db.parameterDelete();
db.AddParameterValue("@pRef", Ref);
Kullanilan = int.Parse(db.GetScalarValue("select dbo.IK_GetUsedDays(@pRef)").ToString());
Kullanilabilir = Kazanilan - Kullanilan;
lblKalan.Text = Kullanilabilir.ToString() + " Gün";
lblKazanilan.Text = Kazanilan.ToString() + " Gün";
lblKullanilan.Text = Kullanilan.ToString() + " Gün";
}
}
catch (Exception ex)
{
}
}
void FillData()
{
if (!string.IsNullOrEmpty(ledFirm.GetValue().ToString()) && !string.IsNullOrEmpty(ledUser.GetValue().ToString()))
{
if (int.Parse(db.GetScalarValue("select count(*) from sysAuthUser").ToString()) > 0)
{
db.AddParameterValue("@uRef", ledUser.GetValue());
db.AddParameterValue("@firmRef", ledFirm.GetValue());
if (int.Parse(db.GetScalarValue("select count(*) from sysAuthUser where userRef=@uRef and firmRef=@firmRef").ToString()) > 0)
{
db.AddParameterValue("@uRef", ledUser.GetValue());
db.AddParameterValue("@firmRef", ledFirm.GetValue());
int authRefID = int.Parse(db.GetScalarValue("select authRef from sysAuthUser where userRef=@uRef and firmRef=@firmRef").ToString());
ledPackage.SetValue(authRefID);
db.AddParameterValue("@uRef", ledUser.GetValue());
db.AddParameterValue("@firmRef", ledFirm.GetValue());
this._Ref = int.Parse(db.GetScalarValue("select Ref from sysAuthUser where userRef=@uRef and firmRef=@firmRef").ToString());
}
}
db.AddParameterValue("@ref", ledUser.GetValue());
DataTable dtDataBranch = db.GetDataTable("select * from sysAuthUserBranch where userRef=@ref");
if (dtDataBranch.Rows.Count > 0)
{
for (int i = 0; i < dtDataBranch.Rows.Count; i++)
{
for (int a = 0; a < dtBranch.Rows.Count; a++)
{
if (dtDataBranch.Rows[i]["branchRef"].ToString() == dtBranch.Rows[a]["Ref"].ToString())
{
grdBranch.SetRowCellValue(a, "Seçim", true);
}
}
}
}
db.AddParameterValue("@ref", ledUser.GetValue());
DataTable dtDataWhouse = db.GetDataTable("select * from sysAuthUserWhouse where userRef=@ref");
if (dtDataWhouse.Rows.Count > 0)
{
for (int i = 0; i < dtDataWhouse.Rows.Count; i++)
{
for (int a = 0; a < dtWhouse.Rows.Count; a++)
{
if (dtDataWhouse.Rows[i]["whouseRef"].ToString() == dtWhouse.Rows[a]["Ref"].ToString())
{
grdDb.SetRowCellValue(a, "Seçim", true);
}
}
}
}
}
}
private void LoadPersonInfo(object sender, EventArgs e)
{
try
{
groupControl3.Enabled = true;
db.AddParameterValue("@ref", ledPersonel.GetValue());
DataTable dt = db.GetDataTable("SELECT * FROM tbPerson where Ref=@ref");
dtpIseGiris.SetDate(DateTime.Parse(dt.Rows[0]["sDate"].ToString()));
txtAdres.SetString(dt.Rows[0]["address"].ToString());
txtToplamIzin.SetString(dt.Rows[0]["gain"].ToString());
txtAdres.SetString(dt.Rows[0]["address"].ToString());
db.AddParameterValue("@pRef", ledPersonel.GetValue());
request = int.Parse(db.GetScalarValue("select dbo.IK_GetUsedDays(@pRef)").ToString());
txtKullanilanIzin.SetString(request.ToString());
txtKullanilabilir.SetString((int.Parse(txtToplamIzin.GetString()) - request).ToString());
txtOKullanilan.SetString(txtKullanilabilir.GetString());
}
catch (Exception)
{
}
}
} // this metod writed for Kübra Çifçi 02.12.2018 Sunday 00:41
private void FrmBuyList_Load(object sender, EventArgs e)
{
helper.ClearForm(this);
SetForm();
FillLookUp();
if (this._FormMod == Enums.enmFormMod.Guncelle)
{
db.AddParameterValue("@ref", this._Ref);
DataTable dt = db.GetDataTable("select * from StBuyPriceList where Ref=@ref");
chkActive.SetBoolValue(bool.Parse(dt.Rows[0][1].ToString()));
txtCode.SetString(dt.Rows[0][2].ToString());
txtName.SetString(dt.Rows[0][3].ToString());
ledCurr.SetValue(int.Parse(dt.Rows[0][4].ToString()));
dtpStart.SetDate(DateTime.Parse(dt.Rows[0][5].ToString()));
dtpFinish.SetDate(DateTime.Parse(dt.Rows[0][6].ToString()));
db.parameterDelete();
db.AddParameterValue("@ref", this._Ref);
DataTable dtDetail = db.GetDataTable("Select * from StBuyPriceListDetails where listRef=@ref");
for (int i = 0; i < dtDetail.Rows.Count; i++)
{
DataRow row = dtBox.NewRow();
row["Ref"] = int.Parse(dtDetail.Rows[i][0].ToString());
row["Liste Ref"] = int.Parse(dtDetail.Rows[i][1].ToString());
row["Kart Ref"] = int.Parse(dtDetail.Rows[i][2].ToString());
db.AddParameterValue("@ref", dtDetail.Rows[i][2].ToString());
DataTable dtStock = db.GetDataTable("select code,name from StStockCard where Ref=@ref");
row["Kart Kodu"] = (dtStock.Rows[0][0].ToString());
row["Kart Adı"] = (dtStock.Rows[0][1].ToString());
db.AddParameterValue("@barcode", dtDetail.Rows[i][4].ToString());
DataTable dtBarcode = db.GetDataTable("select color,size from StStockCardBarcodes where barcode=@barcode");
row["Renk"] = (dtBarcode.Rows[0][0].ToString());
row["Beden"] = (dtBarcode.Rows[0][1].ToString());
row["Birim Ref"] = int.Parse(dtDetail.Rows[i][3].ToString());
sysDb.AddParameterValue("@unitRef", dtDetail.Rows[i][3].ToString());
row["Birim Kodu"] = sysDb.GetScalarValue("select symbol from SysUnit where ref=@unitRef").ToString();
row["Barkod"] = (dtDetail.Rows[i][4].ToString());
row["Fiyat"] = decimal.Parse(dtDetail.Rows[i][5].ToString());
dtBox.Rows.Add(row);
}
dgwGrid.DataSource = dtBox;
grdGrid.RefreshData();
}
GridColumn colModelPrice = grdGrid.Columns["price"];
colModelPrice.DisplayFormat.FormatType = FormatType.Numeric;
colModelPrice.DisplayFormat.FormatString = "{0:n}";
c.StateStabil(this);
}
void FillData()
{
db.AddParameterValue("@ref", this._Ref);
DataTable dtPlug = db.GetDataTable("select * from StBuyOrder where Ref=@ref");
if (!string.IsNullOrEmpty(dtPlug.Rows[0][1].ToString()))
{
txtCode.SetString(dtPlug.Rows[0][1].ToString());
txtName.SetString(dtPlug.Rows[0][2].ToString());
dtpPlugDate.SetDate(DateTime.Parse(dtPlug.Rows[0][3].ToString()));
ledBranch.SetValue(int.Parse(dtPlug.Rows[0][4].ToString()));
ledWhouse.SetValue(int.Parse(dtPlug.Rows[0][5].ToString()));
txtDesc.SetString(dtPlug.Rows[0][6].ToString());
ledCustomer.SetValue(int.Parse(dtPlug.Rows[0]["customerRef"].ToString()));
db.AddParameterValue("@ref", this._Ref);
DataTable dtPlugDetails = db.GetDataTable("select * from StBuyOrderDetails where orderRef=@ref");
for (int i = 0; i < dtPlugDetails.Rows.Count; i++)
{
DataRow row = dtBox.NewRow();
row["Ref"] = dtPlugDetails.Rows[i]["Ref"];
row["Fiş Ref"] = dtPlugDetails.Rows[i]["orderRef"];
row["Kart Ref"] = dtPlugDetails.Rows[i]["cardRef"];
row["Kart Kodu"] = dtPlugDetails.Rows[i]["cardCode"];
db.parameterDelete();
db.AddParameterValue("@ref", dtPlugDetails.Rows[i]["cardRef"], SqlDbType.Int);
row["Kart Adı"] = db.GetScalarValue("select name from StStockCard where ref=@ref").ToString();
db.parameterDelete();
row["Barkod"] = dtPlugDetails.Rows[i]["barcode"];
db.AddParameterValue("@barcode", dtPlugDetails.Rows[i]["barcode"]);
row["Renk"] = db.GetScalarValue("select color from StStockCardBarcodes where barcode=@barcode");
db.AddParameterValue("@barcode", dtPlugDetails.Rows[i]["barcode"]);
row["Beden"] = db.GetScalarValue("select size from StStockCardBarcodes where barcode=@barcode");
db.parameterDelete();
row["Birim Ref"] = dtPlugDetails.Rows[i]["unitRef"];
sysDb.AddParameterValue("@ref", dtPlugDetails.Rows[i]["unitRef"], SqlDbType.Int);
row["Birim Kodu"] = sysDb.GetScalarValue("select symbol from sysUnit where Ref=@ref").ToString();
sysDb.parameterDelete();
row["Miktar"] = dtPlugDetails.Rows[i]["quantity"];
row["Birim Fiyat"] = dtPlugDetails.Rows[i]["unitPrice"];
row["Toplam Tutar"] = dtPlugDetails.Rows[i]["linePrice"];
row["Satır Açıklaması"] = dtPlugDetails.Rows[i]["lineDescription"];
dtBox.Rows.Add(row);
}
grdGrid.RefreshData();
RowCount = grdGrid.RowCount;
Calculate();
grdGrid.BestFitColumns();
}
}
public void ActivePassive(int id, string tabloadi, string alanadi, string kosulid)
{
db.AddParameterValue("@Id", id);
string status = db.GetScalarValue("select " + alanadi + " from " + tabloadi + " where " + kosulid + "=@Id").ToString();
db.AddParameterValue("@Id", id);
if (status == "False")
{
db.RunCommand("update " + tabloadi + " set " + alanadi + " = 1 where " + kosulid + "=@Id");
}
else if (status == "True")
{
db.RunCommand("update " + tabloadi + " set " + alanadi + " = 0 where " + kosulid + "=@Id");
}
DevExpress.XtraEditors.XtraMessageBox.Show("İşlem başarıyla kaydedildi.", "Başarılı İşlem!"
, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void FrmExitWork_Load(object sender, EventArgs e)
{
DateTime dateNow = DateTime.Now;
db.AddParameterValue("@ref", _Ref);
kazanilan = int.Parse(db.GetScalarValue("Select gain from tbPerson where Ref=@ref").ToString());
db.AddParameterValue("@pRef", _Ref);
if (!string.IsNullOrEmpty(db.GetScalarValue("Select SUM(pRequest) from tbPermission where pRef=@pRef").ToString()))
{
db.AddParameterValue("@pRef", _Ref);
kullanilan = int.Parse(db.GetScalarValue("Select SUM(pRequest) from tbPermission where pRef=@pRef").ToString());
}
atlasTextBox1.SetString((kazanilan - kullanilan).ToString());
atlasTextBox1.Enabled = false;
atlasDateEdit1.SetDate(dateNow);
}
private void FrmDiscount_Load(object sender, EventArgs e)
{
helper.ClearForm(this);
SetForm();
FillLookUp();
if (this._FormMod == Enums.enmFormMod.Guncelle)
{
db.AddParameterValue("@ref", this._Ref);
DataTable dt = db.GetDataTable("select * from StSellDiscount where Ref=@ref");
chkActive.SetBoolValue(bool.Parse(dt.Rows[0][1].ToString()));
txtCode.SetString(dt.Rows[0][2].ToString());
txtName.SetString(dt.Rows[0][3].ToString());
dtpStart.SetDate(DateTime.Parse(dt.Rows[0][4].ToString()));
dtpFinish.SetDate(DateTime.Parse(dt.Rows[0][5].ToString()));
db.parameterDelete();
db.AddParameterValue("@ref", this._Ref);
dtDetail = db.GetDataTable("select * from StSellDiscountDetail where discountRef=@ref");
for (int i = 0; i < dtDetail.Rows.Count; i++)
{
DataRow row = dtBox.NewRow();
row["İndirim Tipi"] = dtDetail.Rows[i]["lineType"].ToString();
row["Ref"] = dtDetail.Rows[i]["Ref"].ToString();
row["Liste Ref"] = dtDetail.Rows[i]["discountRef"].ToString();
row["Kart Ref"] = dtDetail.Rows[i]["cardRef"].ToString();
db.AddParameterValue("@ref", dtDetail.Rows[i]["cardRef"].ToString());
DataTable dtStock = db.GetDataTable("select code,name from StStockCard where Ref=@ref");
row["Kart Kodu"] = (dtStock.Rows[0][0].ToString());
row["Kart Adı"] = (dtStock.Rows[0][1].ToString());
row["Barkod"] = dtDetail.Rows[i]["barcode"].ToString();
db.AddParameterValue("@barcode", dtDetail.Rows[i]["barcode"].ToString());
DataTable dtBarcode = db.GetDataTable("select color,size from StStockCardBarcodes where barcode=@barcode");
row["Renk"] = (dtBarcode.Rows[0][0].ToString());
row["Beden"] = (dtBarcode.Rows[0][1].ToString());
row["Birim Ref"] = int.Parse(dtDetail.Rows[i]["unitRef"].ToString());
sysDb.AddParameterValue("@ref", dtDetail.Rows[i]["unitRef"].ToString());
row["Birim Kodu"] = sysDb.GetScalarValue("select symbol from SysUnit where ref=@ref").ToString();
row["Oran"] = dtDetail.Rows[i]["rate"].ToString();
row["Eski Fiyat"] = dtDetail.Rows[i]["oldPrice"].ToString();
row["Yeni Fiyat"] = dtDetail.Rows[i]["newPrice"].ToString();
dtBox.Rows.Add(row);
}
dgwGrid.DataSource = dtBox;
grdGrid.RefreshData();
}
c.StateStabil(this);
}
private void btnLogin_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(ledFirm.GetValue().ToString()))
{
if (string.IsNullOrEmpty(txtUsername.GetString()))
{
XtraMessageBox.Show("Kullanıcı adı boş geçilemez.", "HATA!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (string.IsNullOrEmpty(txtPassword.GetString()))
{
XtraMessageBox.Show("Şifre boş geçilemez.", "HATA!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
string hashedPass = helper.TextSifrele(txtPassword.GetString());
db.AddParameterValue("@param1", txtUsername.GetString());
db.AddParameterValue("@param2", hashedPass);
if (db.GetDataSet("select * from sysUser where userName=@param1 and password=@param2").Tables[0].Rows.Count > 0)
{
FrmErpMain main = (FrmErpMain)Application.OpenForms["FrmErpMain"];
db.AddParameterValue("@param1", txtUsername.GetString());
db.AddParameterValue("@param2", hashedPass);
main.userRef = int.Parse(db.GetScalarValue("select Ref from sysUser where userName=@param1 and password=@param2").ToString());
main.firmRef = ledFirm.GetValue();
this.DialogResult = DialogResult.OK;
}
else
{
Titret();
}
}
}
else
{
XtraMessageBox.Show("Firma seçmeden giriş yapamazsınız.", "HATA!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void fillPdata(object sender, EventArgs e)
{
// gridControl2.DataSource = db.GetDataTable(@"SELECT tbAuths.Ref, tbAuths.menuRef, tbMenus.Modul AS Modül, tbMenus.ScreenName AS Ekran, tbAuths.authSee AS Görme, tbAuths.authAdd AS Ekleme, tbAuths.authUpdate AS Güncelleme, tbAuths.authDelete AS Silme
//FROM tbAuths RIGHT OUTER JOIN
// tbMenus ON tbAuths.menuRef = tbMenus.Ref ");
// gridView2.Columns[0].Visible = false;
// gridView2.Columns[1].Visible = false;
// gridView2.BestFitColumns();
if (ledPersonel.GetValue() != 0 && !string.IsNullOrEmpty(ledPersonel.GetValue().ToString()))
{
db.AddParameterValue("@ref", ledPersonel.GetValue());
tc = db.GetScalarValue("select tc from tbPerson where Ref=@ref").ToString();
}
}
private void ledFirm_Validated(object sender, EventArgs e)
{
ledCity.flaLookUp.Properties.Columns.Clear();
ledCity.flaLookUp.Properties.ValueMember = "Ref";
ledCity.flaLookUp.Properties.DisplayMember = "name";
ledCity.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "No", Visible = false
});
ledCity.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "name", Caption = "Adı"
});
db.AddParameterValue("@ref1", ledFirm.GetValue());
int id = int.Parse(db.GetScalarValue("select countryRef from sysFirm where Ref=@ref1").ToString());
db.AddParameterValue("@ref", id);
ledCity.flaLookUp.Properties.DataSource = db.GetDataTable("select * from sysCity where countryRef=@ref");
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
RptYazdir Rp = new RptYazdir();
int pRef = 0, Ref = 0;
if (xtraTabControl1.SelectedTabPage.Text.ToString() == "Tüm İzinler")
{
if (!string.IsNullOrEmpty(grdAll.GetFocusedRowCellValue("Ref").ToString()))
{
Rp.Ref = int.Parse(grdAll.GetFocusedRowCellValue("Ref").ToString());
Rp.pRef = int.Parse(grdAll.GetFocusedRowCellValue("pRef").ToString());
db.AddParameterValue("@pRef", Rp.pRef);
if (int.Parse(db.GetScalarValue("Select Count(*) from tbPermission where pRef=@pRef").ToString()) > 0)
{
db.AddParameterValue("@pRef", Rp.pRef);
Rp.oncekiRef = int.Parse(db.GetScalarValue("select max(Ref) from tbPermission where pRef=@pRef").ToString());
}
}
}
if (xtraTabControl1.SelectedTabPage.Text.ToString() == "Gelecek İzinler")
{
if (!string.IsNullOrEmpty(grdNext.GetFocusedRowCellValue("Ref").ToString()))
{
Rp.Ref = int.Parse(grdNext.GetFocusedRowCellValue("Ref").ToString());
Rp.pRef = int.Parse(grdNext.GetFocusedRowCellValue("pRef").ToString());
db.AddParameterValue("@pRef", Rp.pRef);
if (int.Parse(db.GetScalarValue("Select Count(*) from tbPermission where pRef=@pRef").ToString()) > 0)
{
db.AddParameterValue("@pRef", Rp.pRef);
Rp.oncekiRef = int.Parse(db.GetScalarValue("select max(Ref) from tbPermission where pRef=@pRef").ToString());
}
}
}
if (xtraTabControl1.SelectedTabPage.Text.ToString() == "Aktif İzinler")
{
if (!string.IsNullOrEmpty(grdNow.GetFocusedRowCellValue("Ref").ToString()))
{
Rp.Ref = int.Parse(grdNow.GetFocusedRowCellValue("Ref").ToString());
Rp.pRef = int.Parse(grdNow.GetFocusedRowCellValue("pRef").ToString());
db.AddParameterValue("@pRef", Rp.pRef);
if (int.Parse(db.GetScalarValue("Select Count(*) from tbPermission where pRef=@pRef").ToString()) > 0)
{
db.AddParameterValue("@pRef", Rp.pRef);
Rp.oncekiRef = int.Parse(db.GetScalarValue("select max(Ref) from tbPermission where pRef=@pRef").ToString());
}
}
}
if (xtraTabControl1.SelectedTabPage.Text.ToString() == "Geçmiş İzinler")
{
if (!string.IsNullOrEmpty(grdPast.GetFocusedRowCellValue("Ref").ToString()))
{
Rp.Ref = int.Parse(grdPast.GetFocusedRowCellValue("Ref").ToString());
Rp.pRef = int.Parse(grdPast.GetFocusedRowCellValue("pRef").ToString());
db.AddParameterValue("@pRef", Rp.pRef);
if (int.Parse(db.GetScalarValue("Select Count(*) from tbPermission where pRef=@pRef").ToString()) > 0)
{
db.AddParameterValue("@pRef", Rp.pRef);
Rp.oncekiRef = int.Parse(db.GetScalarValue("select max(Ref) from tbPermission where pRef=@pRef").ToString());
}
}
}
Rp.CreateDocument();
ReportPrintTool printTool = new ReportPrintTool(Rp);
printTool.ShowRibbonPreviewDialog();
}
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();
}
}
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//try
//{
for (int i = 0; i < dt.Rows.Count; i++)
{
db.AddParameterValue("@tc", dt.Rows[i]["TC"].ToString());
if (int.Parse(db.GetScalarValue("select count(*) from tbPerson where TC=@tc").ToString()) > 0)
{
db.AddParameterValue("@tc", dt.Rows[i]["TC"].ToString());
_Ref = int.Parse(db.GetScalarValue("select Ref from tbPerson where TC = @tc").ToString());
}
else
{
_Ref = 0;
}
db.AddParameterValue("@ref", _Ref);
db.AddParameterValue("@name", dt.Rows[i]["Ad"].ToString());
db.AddParameterValue("@surname", dt.Rows[i]["Soyad"].ToString());
db.AddParameterValue("@tc", dt.Rows[i]["TC"].ToString());
db.AddParameterValue("@bdate", DateTime.Parse(dt.Rows[i]["Doğum Tarihi"].ToString()), SqlDbType.Date);
db.AddParameterValue("@bPlace", "");
db.AddParameterValue("@mName", "");
db.AddParameterValue("@dName", "");
db.AddParameterValue("@sex", "");
db.AddParameterValue("@bgroup", "");
db.AddParameterValue("@mStatus", "");
db.AddParameterValue("@register", dt.Rows[i]["Sicil"].ToString());
db.AddParameterValue("@mission", dt.Rows[i]["Görevi"].ToString());
db.AddParameterValue("@unit", "");
db.AddParameterValue("@sDate", DateTime.Parse(dt.Rows[i]["İşe Giriş Tarihi"].ToString()), SqlDbType.Date);
db.AddParameterValue("@gsm", dt.Rows[i]["GSM"].ToString());
db.AddParameterValue("@mail", "");
db.AddParameterValue("@address", "", SqlDbType.NVarChar);
db.AddParameterValue("@cname", "");
db.AddParameterValue("@cSurname", "");
db.AddParameterValue("@cRank", "");
db.AddParameterValue("@cGsm", "");
db.AddParameterValue("@dLicence", "");
db.AddParameterValue("@solider", "");
db.AddParameterValue("@education", "");
db.AddParameterValue("@children", "");
db.AddParameterValue("@imagePath", "");
db.AddParameterValue("@gain", "");
db.AddParameterValue("@firm", "");
db.AddParameterValue("@insurance", "");
db.AddParameterValue("@IBAN", "");
db.RunCommand("sp_Person", CommandType.StoredProcedure);
}
XtraMessageBox.Show("İşlem başarıyla tamamlandı.", "Başarılı İşlem!", MessageBoxButtons.OK, MessageBoxIcon.Information);
helper.ClearForm(this);
c.StateStabil(this);
this.DialogResult = DialogResult.OK;
this.Close();
//}
//catch (Exception ex)
//{
// helper.WriteLog(ex);
// db.parameterDelete();
//}
}
private void FrmErpMain_Load(object sender, EventArgs e)
{
FrmLogin Log = new FrmLogin();
this.Opacity = 0;
Log.ShowDialog();
if (Log.DialogResult == System.Windows.Forms.DialogResult.OK)
{
this.Opacity = 100;
//yetki işlemleri
#region Auth operations
// şubeleri doldurma.
sysDb.AddParameterValue("@ref", userRef);
dtBranch = sysDb.GetDataSet("select branchRef from sysAuthUserBranch where userRef=@ref").Tables[0];
for (int i = 0; i < dtBranch.Rows.Count; i++)
{
int branchRef = int.Parse(dtBranch.Rows[i][0].ToString());
sysDb.AddParameterValue("@ref", branchRef);
sysDb.AddParameterValue("@firmRef", firmRef);
string branchName = sysDb.GetScalarValue("select name from sysBranch where ref=@ref and firmRef=@firmRef").ToString();
lstBranch.Add(branchRef, branchName);
}
// depoaları doldurma.
sysDb.AddParameterValue("@ref", userRef);
dtWhouse = sysDb.GetDataSet("select whouseRef from sysAuthUserWhouse where userRef=@ref").Tables[0];
for (int i = 0; i < dtWhouse.Rows.Count; i++)
{
int whouseRef = int.Parse(dtWhouse.Rows[i][0].ToString());
sysDb.AddParameterValue("@ref", whouseRef);
sysDb.AddParameterValue("@branchRef", firmRef);
string whouseName = sysDb.GetScalarValue("select name from sysWhouse where ref=@ref").ToString();
lstWhouse.Add(whouseRef, whouseName);
}
#region Auths
//// yetkiler
sysDb.AddParameterValue("@firmRef", firmRef);
sysDb.AddParameterValue("@userRef", userRef);
authRef = int.Parse(sysDb.GetScalarValue("select authRef from sysAuthUser where firmRef=@firmRef and userRef=@userRef").ToString());
sysDb.AddParameterValue("@ref", authRef);
dtAuth = sysDb.GetDataSet(@"SELECT SysAuths.Ref AS authRef,sysMenu.code, sysMenu.description, sysAuthDetails.authSee, sysAuthDetails.authAdd, sysAuthDetails.authUpdate, sysAuthDetails.authShow
FROM SysAuths INNER JOIN
sysAuthDetails ON SysAuths.Ref = sysAuthDetails.authRef INNER JOIN
sysMenu ON sysAuthDetails.menuRef = sysMenu.Ref where SysAuths.Ref = @ref").Tables[0];
for (int g = 0; g < dtAuth.Rows.Count; g++)
{
if (dtAuth.Rows[g]["code"].ToString() == "10")
{
for (int i = 0; i < treeStock.Nodes.Count; i++)
{
for (int a = 0; a < treeStock.Nodes[i].Nodes.Count; a++)
{
string focusedNode = treeStock.Nodes[i].Nodes[a].GetDisplayText(cololaylar).ToString();
string listNde = dtAuth.Rows[g]["description"].ToString();
if (focusedNode == listNde)
{
treeStock.Nodes[i].Nodes[a].Visible = bool.Parse(dtAuth.Rows[g]["authSee"].ToString());
}
}
}
}
}
#endregion
#endregion
}
}
