void FillData()
{
bindData.DataSource = db.GetDataTable("select * from StStockCardModel order by Ref ASC");
RowCount = grdGrid.RowCount;
riLedBrand.DataSource = db.GetDataTable("select * from StStockCardBrand order by Ref asc");
}
private void FrmPrintBarcode_Load(object sender, EventArgs e)
{
ledCard.flaLookUp.Properties.ValueMember = "Ref";
ledCard.flaLookUp.Properties.DisplayMember = "code";
ledCard.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "dbNo", Visible = false
});
ledCard.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "code", Caption = "Kodu"
});
ledCard.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "name", Caption = "Adı"
});
ledCard.flaLookUp.Properties.DataSource = db.GetDataTable("select * from StStockCard");
dtList.Columns.Add("Seçim", typeof(bool));
dtList.Columns.Add("Beden");
dtList.Columns.Add("Renk");
dtList.Columns.Add("Barkod");
dgwGrid.DataSource = dtList;
grdGrid.Columns[1].OptionsColumn.AllowEdit = false;
grdGrid.Columns[2].OptionsColumn.AllowEdit = false;
grdGrid.Columns[3].OptionsColumn.AllowEdit = false;
grdGrid.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None;
grdGrid.OptionsView.ShowAutoFilterRow = false;
}
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();
}
}
bool Control()
{
stb.Clear();
#region Code Control
if (!string.IsNullOrEmpty(txtCode.GetString()))
{
dtControl.Clear();
db.AddParameterValue("@code", txtCode.GetString());
dtControl = db.GetDataTable("select code from StCustomerAccount where code=@code");
if (dtControl.Rows.Count > 0)
{
codeCount = int.Parse(dtControl.Rows[0][0].ToString());
}
}
if (codeCount > 0 && this._FormMod == Enums.enmFormMod.Yeni)
{
stb.AppendLine("Böyle bir cari kodu sistemde mevcut.");
}
if (string.IsNullOrEmpty(txtCode.GetString()))
{
stb.AppendLine("Cari kodu boş geçilemez.");
}
else
{
code = txtCode.GetString();
}
#endregion
if (ledType.GetValue() != 200)
{
if (string.IsNullOrEmpty(txtVD.GetString()))
{
stb.AppendLine("Vergi dairesi boş geçilemez.");
}
if (string.IsNullOrEmpty(txtVNo.GetString()))
{
stb.AppendLine("Vergi numarası boş geçilemez.");
}
}
if (stb.ToString().Length <= 0)
{
return(true);
}
else
{
return(false);
}
}
void FillData()
{
dgwClass.DataSource = db.GetDataTable("SELECT Ref,no as [Sıra No],name as [Sınıf Adı] FROM StStockCardClass");
grdClassValue.Columns[0].Visible = false;
grdClassValue.Columns[1].Width = 100;
grdClassValue.Columns[1].MaxWidth = 100;
grdClassValue.Columns[1].MinWidth = 100;
grdClassValue.Columns[1].OptionsColumn.AllowEdit = false;
grdClassValue.Columns[2].Width = 295;
grdClassValue.Columns[2].MaxWidth = 295;
grdClassValue.Columns[2].MinWidth = 295;
}
void FillData()
{
DataTable dt = db.GetDataTable(@"SELECT BO.Ref as Ref, BO.code AS [Kodu], BO.name AS [Adı], BO.Date AS [Veriliş Tarihi], BR.name as [Şube], WH.name as [Depo], BO.OkDate as [Onaylanma Tarihi]
FROM StBuyOrder BO with(nolock)
INNER JOIN AtlasSys.dbo.sysBranch BR ON BR.Ref = BO.branchRef
INNER JOIN AtlasSys.dbo.sysWhouse WH ON WH.Ref = BO.whouseRef
WHERE (BO.state = 0)");
gridControl1.DataSource = dt;
gridView1.Columns[0].Visible = false;
gridView1.BestFitColumns();
DataTable dtOpen = db.GetDataTable(@"SELECT BO.Ref as Ref, BO.code AS [Kodu], BO.name AS [Adı], BO.Date AS [Veriliş Tarihi], BR.name as [Şube], WH.name as [Depo]
FROM StBuyOrder BO with(nolock)
INNER JOIN AtlasSys.dbo.sysBranch BR ON BR.Ref = BO.branchRef
INNER JOIN AtlasSys.dbo.sysWhouse WH ON WH.Ref = BO.whouseRef
WHERE (BO.state = 1)");
dtBidik.Columns.Clear();
dtBidik.Columns.Add("Seçim", typeof(bool));
for (int i = 0; i < dtOpen.Columns.Count; i++)
{
dtBidik.Columns.Add(dtOpen.Columns[i].ToString());
}
for (int a = 0; a < dtOpen.Rows.Count; a++)
{
DataRow row = dtBidik.NewRow();
row[0] = false;
row[1] = dtOpen.Rows[a]["Ref"];
row[2] = dtOpen.Rows[a]["Kodu"];
row[3] = dtOpen.Rows[a]["Adı"];
row[4] = DateTime.Parse(dtOpen.Rows[a]["Veriliş Tarihi"].ToString()).ToShortDateString();
row[5] = dtOpen.Rows[a]["Şube"];
row[6] = dtOpen.Rows[a]["Depo"];
dtBidik.Rows.Add(row);
}
bindData.DataSource = dtBidik;
grdGrid.Columns[1].Visible = false;
grdGrid.BestFitColumns();
grdGrid.Columns[0].OptionsColumn.AllowEdit = true;
grdGrid.Columns[1].OptionsColumn.AllowEdit = false;
grdGrid.Columns[2].OptionsColumn.AllowEdit = false;
grdGrid.Columns[3].OptionsColumn.AllowEdit = false;
grdGrid.Columns[4].OptionsColumn.AllowEdit = false;
grdGrid.Columns[5].OptionsColumn.AllowEdit = false;
grdGrid.Columns[6].OptionsColumn.AllowEdit = false;
}
void FillData()
{
db.AddParameterValue("@ref", this._Ref);
bindData.DataSource = db.GetDataTable("select * from StStockCardSizeDetails where SizeRef=@ref order by Ref ASC");
RowCount = grdGrid.RowCount;
db.parameterDelete();
if (this._FormMod == Enums.enmFormMod.Guncelle)
{
db.AddParameterValue("@ref", this._Ref);
DataTable dt = db.GetDataTable("select * from StStockCardSize where Ref=@ref");
txtCode.SetString(dt.Rows[0][1].ToString());
txtName.SetString(dt.Rows[0][2].ToString());
}
}
void FillData()
{
string sql = @" SELECT
tbPerson.Ref,
tbPerson.name + ' ' + surname AS[Ad Soyad],
tc AS TC,
birthDate as [Doğum Tarihi],
mission as [Görev],
tbUnit.name as [Birim],
sDate as [İşe Giriş],
gsm as [GSM],
mail as [Mail],
bGroup as [Kan Grubu],
dLicence as [Ehliyet]
FROM tbPerson with(nolock)
LEFT OUTER JOIN tbUnit
ON tbPerson.unit = tbUnit.Ref
WHERE exitDate != '01.01.1900'
ORDER BY [Ad Soyad] asc";
this._Sql = sql;
dt = db.GetDataTable(this._Sql);
if (dt != null)
{
dgwList.DataSource = dt;
grdList.Columns["Ref"].Visible = false;
}
grdList.BestFitColumns();
}
private void FrmPriceList_Load(object sender, EventArgs e)
{
if (type == "Buy Order")
{
db.AddParameterValue("@barcode", barcode);
db.AddParameterValue("@branchRef", branchRef);
dt = db.GetDataTable(@"SELECT * FROM Tools_GetBuyPriceList(@branchRef,@barcode)");
}
else if (type == "Sell Order")
{
db.AddParameterValue("@barcode", barcode);
db.AddParameterValue("@branchRef", branchRef);
dt = db.GetDataTable(@"SELECT * FROM Tools_GetSellPriceList(@branchRef,@barcode)");
}
dgwGrid.DataSource = dt;
grdGrid.OptionsBehavior.Editable = false;
grdGrid.BestFitColumns();
}
private void FrmClassDetailList_Load(object sender, EventArgs e)
{
db.AddParameterValue("@ref", this._Ref);
db.AddParameterValue("@status", true);
DataTable dtDetail = db.GetDataTable("SELECT Ref, code as [Özellik Kodu],name as [Özellik Adı],status as [Özellik Durumu] FROM StStockCardClassDetail where classRef=@ref and status=@status");
dgwGrid.DataSource = dtDetail;
grdGrid.Columns[0].Visible = false;
}
public void GetCode(string tabloadi, string alan, AtlasForm form, AtlasButtonEdit btn, int start)
{
int code = 0;
System.Data.DataTable dt = db.GetDataTable("select " + alan + " from " + tabloadi);
if (dt.Rows.Count >= 1)
{
code = int.Parse(db.GetScalarValue("select MAX(" + alan + ") from " + tabloadi).ToString());
code++;
}
else
{
code = start;
code++;
}
btn.Enabled = false;
btn.SetString(code.ToString());
}
void FillData()
{
db.AddParameterValue("@ref", this._Ref);
DataTable dtPlug = db.GetDataTable("select * from StBuyServiceOrder where Ref=@ref");
if (!string.IsNullOrEmpty(dtPlug.Rows[0][1].ToString()))
{
txtCode.SetString(dtPlug.Rows[0]["code"].ToString());
txtName.SetString(dtPlug.Rows[0]["name"].ToString());
dtpPlugDate.SetDate(DateTime.Parse(dtPlug.Rows[0]["Date"].ToString()));
ledBranch.SetValue(int.Parse(dtPlug.Rows[0]["branchRef"].ToString()));
txtDesc.SetString(dtPlug.Rows[0]["Desc"].ToString());
ledCustomer.SetValue(int.Parse(dtPlug.Rows[0]["customerRef"].ToString()));
db.AddParameterValue("@ref", this._Ref);
DataTable dtPlugDetails = db.GetDataTable("select * from StBuyServiceOrderDetails 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["Hizmet Ref"] = dtPlugDetails.Rows[i]["serviceRef"];
row["Hizmet Kodu"] = dtPlugDetails.Rows[i]["serviceCode"];
db.parameterDelete();
db.AddParameterValue("@ref", dtPlugDetails.Rows[i]["serviceCode"], SqlDbType.Int);
row["Hizmet Adı"] = db.GetScalarValue("select name from StBuyServices where ref=@ref").ToString();
db.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;
grdGrid.BestFitColumns();
}
}
void FillData()
{
dt = db.GetDataTable(this._Sql);
if (dt != null)
{
dgwList.DataSource = dt;
grdList.Columns["Ref"].Visible = false;
}
grdList.BestFitColumns();
}
private void FrmServiceList_Load(object sender, EventArgs e)
{
gridControl1.DataSource = db.GetDataTable("select * from StBuyServices");
gridView1.Columns[0].Visible = false;
gridView1.Columns[0].Caption = "Ref";
gridView1.Columns[1].Caption = "Hizmet Kodu";
gridView1.Columns[2].Caption = "Hizmet Adı";
gridView1.BestFitColumns();
gridView1.OptionsBehavior.Editable = false;
}
void FillData()
{
dt = db.GetDataTable("select * from Stock_Cards");
if (dt != null)
{
dgwStock.DataSource = dt;
grdStock.Columns["Ref"].Visible = false;
grdStock.BestFitColumns();
}
}
void FillLookUp()
{
FrmErpMain main = (FrmErpMain)Application.OpenForms["FrmErpMain"];
ledCurr.flaLookUp.Properties.Columns.Clear();
ledCurr.flaLookUp.Properties.ValueMember = "Ref";
ledCurr.flaLookUp.Properties.DisplayMember = "name";
ledCurr.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "dbNo", Visible = false
});
ledCurr.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "code", Caption = "Kodu"
});
ledCurr.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "name", Caption = "Adı"
});
ledCurr.flaLookUp.Properties.DataSource = sysDb.GetDataTable("select * from sysCurrency");
sysDb.AddParameterValue("@act", true);
sysDb.AddParameterValue("@ref", Properties.Settings.Default.firmRef);
riLedBranch.DataSource = main.lstBranch.ToList();
db.AddParameterValue("@ref", this._Ref);
dgwBranch.DataSource = db.GetDataTable("select * from StSellPriceListBranch where listRef=@ref ");
}
private void FrmBarcodeList_Load(object sender, EventArgs e)
{
#region Create Table // tablonun columnları oluşturuldu.
dtList.Columns.Add("Ref");
dtList.Columns.Add("Seçim", typeof(bool));
dtList.Columns.Add("Kart Kodu");
dtList.Columns.Add("Kart Adı");
dtList.Columns.Add("Beden");
dtList.Columns.Add("Renk");
dtList.Columns.Add("Barkod");
dtList.Columns.Add("Birim Ref");
dtList.Columns.Add("Birim Kodu");
#endregion
#region FillDataToTable // aktif kartlar çekilip dinamik olan tabloya dolduruldu.
DataTable dtData = db.GetDataTable(@"SELECT * FROM Stock_GetStockWithoutBarcode()");
for (int i = 0; i < dtData.Rows.Count; i++)
{
DataRow row = dtList.NewRow();
row["Ref"] = int.Parse(dtData.Rows[i][0].ToString());
row["Seçim"] = false;
row["Kart Kodu"] = dtData.Rows[i][1].ToString();
row["Kart Adı"] = dtData.Rows[i][2].ToString();
row["Beden"] = dtData.Rows[i][3].ToString();
row["Renk"] = dtData.Rows[i][4].ToString();
row["Barkod"] = dtData.Rows[i][5].ToString();
row["Birim Ref"] = dtData.Rows[i][6].ToString();
row["Birim Kodu"] = dtData.Rows[i][7].ToString();
dtList.Rows.Add(row);
}
gridControl1.DataSource = dtList;
#endregion
#region Set Grid View // grid view ayarları
gridView1.Columns[0].Visible = false;
gridView1.Columns[7].Visible = false;
gridView1.Columns[2].OptionsColumn.AllowEdit = false;
gridView1.Columns[3].OptionsColumn.AllowEdit = false;
gridView1.Columns[4].OptionsColumn.AllowEdit = false;
gridView1.Columns[5].OptionsColumn.AllowEdit = false;
gridView1.Columns[2].Group();
gridView1.BestFitColumns();
#endregion
}
void FillLookUp()
{
FrmErpMain main = (FrmErpMain)Application.OpenForms["FrmErpMain"];
riLedBranch.DataSource = main.lstBranch.ToList();
db.AddParameterValue("@ref", this._Ref);
dgwBranch.DataSource = db.GetDataTable("select * from StSellDiscountBranch where [discountRef]=@ref ");
ledBranch.flaLookUp.Properties.ValueMember = "Key";
ledBranch.flaLookUp.Properties.DisplayMember = "Value";
ledBranch.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Key", Caption = "dbNo", Visible = false
});
ledBranch.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Value", Caption = "Adı"
});
ledBranch.flaLookUp.Properties.DataSource = main.lstBranch.ToList();
}
void FillData()
{
dt = db.GetDataTable(@"SELECT Ref, type as [Tip], code as [Kod], name as [Ad], country as [Ülke], city as [Şehir], gsm as [GSM],mail as [Mail]
FROM StCustomerAccount where active = 1");
if (dt != null)
{
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// dt.Rows[i][1].
// if (dt.Rows[i][1].ToString() == "200")
// dt.Rows[i][1] = "Alıcı";
// if (dt.Rows[i][1].ToString() == "201")
// dt.Rows[i][1] = "Satıcı";
// if (dt.Rows[i][1].ToString() == "202")
// dt.Rows[i][1] = "Alıcı + Satıcı";
//}
dgwStock.DataSource = dt;
grdStock.Columns["Ref"].Visible = false;
grdStock.Columns["Tip"].Visible = false;
}
grdStock.BestFitColumns();
}
void FillData()
{
bindData.DataSource = db.GetDataTable("select * from StBuyServices order by Ref ASC");
RowCount = grdGrid.RowCount;
}
void fillComboAndDate()
{
DateTime bDate = new DateTime(1990, 1, 1);
dtpDTarihi.SetDate(bDate);
dtpIseGiris.SetDate(DateTime.Parse(DateTime.Now.ToShortDateString().ToString()));
ledBirim.flaLookUp.Properties.ValueMember = "Ref";
ledBirim.flaLookUp.Properties.DisplayMember = "name";
ledBirim.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "dbNo", Visible = false
});
ledBirim.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "name", Caption = "Departman"
});
ledBirim.flaLookUp.Properties.DataSource = db.GetDataTable("Select * from tbUnit with(nolock)");
cmbDerece.flashCombo.Properties.Items.Add("Anne");
cmbDerece.flashCombo.Properties.Items.Add("Baba");
cmbDerece.flashCombo.Properties.Items.Add("Eş");
cmbDerece.flashCombo.Properties.Items.Add("Arkadaş");
cmbDerece.flashCombo.Properties.Items.Add("Kardeş");
cmbDerece.flashCombo.Properties.Items.Add("Çocuk");
cmbDerece.SetString("Kardeş");
cmbCinsiyet.flashCombo.Properties.Items.Add("Erkek");
cmbCinsiyet.flashCombo.Properties.Items.Add("Kadın");
cmbCinsiyet.SetString("Erkek");
cmbAskerlik.flashCombo.Properties.Items.Add("Yapıldı");
cmbAskerlik.flashCombo.Properties.Items.Add("Tecilli");
cmbAskerlik.flashCombo.Properties.Items.Add("Öğrenci");
cmbAskerlik.flashCombo.Properties.Items.Add("Muaf");
//cmbAskerlik.SetString("Yapıldı");
cmbCocuk.flashCombo.Properties.Items.Add("0");
cmbCocuk.flashCombo.Properties.Items.Add("1");
cmbCocuk.flashCombo.Properties.Items.Add("2");
cmbCocuk.flashCombo.Properties.Items.Add("3");
cmbCocuk.flashCombo.Properties.Items.Add("4");
cmbCocuk.flashCombo.Properties.Items.Add("5");
cmbCocuk.flashCombo.Properties.Items.Add("6");
//cmbCocuk.SetString("0");
cmbEhliyet.flashCombo.Properties.Items.Add("Yok");
cmbEhliyet.flashCombo.Properties.Items.Add("M");
cmbEhliyet.flashCombo.Properties.Items.Add("A");
cmbEhliyet.flashCombo.Properties.Items.Add("B");
cmbEhliyet.flashCombo.Properties.Items.Add("C");
cmbEhliyet.flashCombo.Properties.Items.Add("D");
cmbEhliyet.flashCombo.Properties.Items.Add("F");
cmbEhliyet.flashCombo.Properties.Items.Add("G");
//cmbEhliyet.SetString("B");
cmbKanGrubu.flashCombo.Properties.Items.Add("AB Rh (+)");
cmbKanGrubu.flashCombo.Properties.Items.Add("AB Rh (-)");
cmbKanGrubu.flashCombo.Properties.Items.Add("0 Rh (-)");
cmbKanGrubu.flashCombo.Properties.Items.Add("0 Rh (+)");
cmbKanGrubu.flashCombo.Properties.Items.Add("A Rh (-)");
cmbKanGrubu.flashCombo.Properties.Items.Add("A Rh (+)");
cmbKanGrubu.flashCombo.Properties.Items.Add("B Rh (-)");
cmbKanGrubu.flashCombo.Properties.Items.Add("B Rh (+)");
//cmbKanGrubu.SetString("AB Rh (+)");
cmbMedeni.flashCombo.Properties.Items.Add("Bekar");
cmbMedeni.flashCombo.Properties.Items.Add("Evli");
//cmbMedeni.SetString("Bekar");
cmbOgrenim.flashCombo.Properties.Items.Add("İlkokul");
cmbOgrenim.flashCombo.Properties.Items.Add("Ortaokul");
cmbOgrenim.flashCombo.Properties.Items.Add("Lise");
cmbOgrenim.flashCombo.Properties.Items.Add("Ön Lisans");
cmbOgrenim.flashCombo.Properties.Items.Add("Lisans");
cmbOgrenim.flashCombo.Properties.Items.Add("Yüksek Lisans");
cmbOgrenim.flashCombo.Properties.Items.Add("Doktora");
cmbOgrenim.flashCombo.Properties.Items.Add("Master");
//cmbOgrenim.SetString("Lisans");
//if (!string.IsNullOrEmpty(db.GetScalarValue("Select MAX(register) from tbPerson").ToString()))
// register = int.Parse(db.GetScalarValue("Select MAX(register) from tbPerson").ToString());
//register++;
//txtSicil.SetString(register.ToString());
cmbFirma.flashCombo.Properties.Items.Add("Badbear");
cmbFirma.flashCombo.Properties.Items.Add("Boyner");
cmbFirma.flashCombo.Properties.Items.Add("Gencallar");
//cmbFirma.SetString("Badbear");
#region Card File
dtFOlder.Columns.Add("Ref");
dtFOlder.Columns.Add("cardRef");
dtFOlder.Columns.Add("Açıklama");
dtFOlder.Columns.Add("folderName");
dtFOlder.Columns.Add("systemFolderName");
dtFOlder.Columns.Add("folderPath");
dtFOlder.Columns.Add("folderType");
dtFOlder.Columns["Ref"].ColumnName = "Ref";
dtFOlder.Columns["cardRef"].ColumnName = "cardRef";
dtFOlder.Columns["folderName"].ColumnName = "Dosya Adı";
dtFOlder.Columns["systemFolderName"].ColumnName = "Sistem Dosya Adı";
dtFOlder.Columns["folderPath"].ColumnName = "Dosya Yolu";
dtFOlder.Columns["folderType"].ColumnName = "Dosya Tipi";
//db.AddParameterValue("@ref", this._Ref);
db.AddParameterValue("@ref", this._Ref);
dtFillFolder = db.GetDataTable("select * from tbCardFiles where cardRef=@ref");
for (int t = 0; t < dtFillFolder.Rows.Count; t++)
{
DataRow row = dtFOlder.NewRow();
row["Ref"] = dtFillFolder.Rows[t][0].ToString();
row["cardRef"] = dtFillFolder.Rows[t][1].ToString();
row["Açıklama"] = dtFillFolder.Rows[t][2].ToString();
row["Dosya Adı"] = dtFillFolder.Rows[t][3].ToString();
row["Sistem Dosya Adı"] = dtFillFolder.Rows[t][4].ToString();
row["Dosya Yolu"] = dtFillFolder.Rows[t][5].ToString();
row["Dosya Tipi"] = dtFillFolder.Rows[t][6].ToString();
dtFOlder.Rows.Add(row);
grdFolder.RefreshData();
}
dgwFolder.DataSource = dtFOlder;
grdFolder.Columns[0].Visible = false;
grdFolder.Columns[1].Visible = false;
grdFolder.BestFitColumns();
grdFolder.Columns[3].OptionsColumn.AllowEdit = false;
grdFolder.Columns[4].OptionsColumn.AllowEdit = false;
grdFolder.Columns[5].OptionsColumn.AllowEdit = false;
grdFolder.Columns[6].OptionsColumn.AllowEdit = false;
#endregion
}
void FillData()
{
sql = @" SELECT
tbPerson.Ref,
tbPerson.name + ' ' + surname AS[Ad Soyad],
tc AS TC,
birthDate as [Doğum Tarihi],
birthPlace as [Doğum Yeri],
mName as [Anne Adı],
dName as [Baba Adı],
bGroup as [Kan Grubu],
mStatus as [Medeni Hal],
register as [Sicil Numarası],
firm as [Firma],
campus as [Yerleşke],
mission as [Görev],
tbUnit.name as [Birim],
sDate as [İşe Giriş],
gsm as [GSM],
mail as [Mail],
[address] as [Adres],
cName as [Yakın Adı],
cSurname as [Yakın Soyadı],
cRank as [Yakın Derecesi],
cGsm as [Yakın GSM],
dLicence as [Ehliyet],
solider as [Askerlik Durumu],
education as [Öğrenim],
children as [Çocuk Sayısı],
IBAN
FROM tbPerson with(nolock)
LEFT OUTER JOIN tbUnit
ON tbPerson.unit = tbUnit.Ref
WHERE ExitDate is null OR exitDate = '01.01.1900'
ORDER BY [Ad Soyad] asc
";
this._Sql = sql;
dt = db.GetDataTable(this._Sql);
if (dt != null)
{
dgwList.DataSource = dt;
grdList.Columns[0].Visible = false;
grdList.Columns[4].Visible = false;
grdList.Columns[5].Visible = false;
grdList.Columns[6].Visible = false;
grdList.Columns[7].Visible = false;
grdList.Columns[8].Visible = false;
grdList.Columns[9].Visible = false;
grdList.Columns[16].Visible = false;
grdList.Columns[17].Visible = false;
grdList.Columns[18].Visible = false;
grdList.Columns[19].Visible = false;
grdList.Columns[20].Visible = false;
grdList.Columns[21].Visible = false;
grdList.Columns[22].Visible = false;
grdList.Columns[23].Visible = false;
grdList.Columns[24].Visible = false;
grdList.Columns[25].Visible = false;
grdList.Columns[26].Visible = false;
}
grdList.BestFitColumns();
}
void FillData()
{
bindData.DataSource = db.GetDataTable("select * from StStockCardGroup order by Ref ASC");
RowCount = grdGrid.RowCount;
}
