private void DATA_LOAD()
{
string SQL = @" select * from TIME_TABLE
";
//DateTime dtOne = Convert.ToDateTime(dtTmPckrBasTar.EditValue); Date_One = dtOne.ToString("yyyy-MM-dd 00:00:00", DateTimeFormatInfo.InvariantInfo);
//DateTime dtTwo = Convert.ToDateTime(dtTmPckrBitTar.EditValue); Date_Two = dtTwo.ToString("yyyy-MM-dd 00:00:00", DateTimeFormatInfo.InvariantInfo);
using (SqlConnection Conn = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_MDB.ToString())) // and (dbo.TODO_TIME_SHEET.MAIL_ADRESI=@MAIL_ADRESI)
{
using (SqlDataAdapter da = new SqlDataAdapter(SQL, Conn))
{
//da.SelectCommand.Parameters.AddWithValue("@SIRKET_KODU", _GLOBAL_PARAMETERS._SIRKET_KODU);
//da.SelectCommand.Parameters.AddWithValue("@MAIL_ADRESI", _GLOBAL_PARAMETERS._KULLANICI_MAIL);
//da.SelectCommand.Parameters.AddWithValue("@StartDate", Date_One);
//da.SelectCommand.Parameters.AddWithValue("@EndDate", Date_Two);
using (DataSet dtSet = new DataSet())
{
da.Fill(dtSet, "ADM_MUSTERI");
using (DataViewManager dvManager = new DataViewManager(dtSet))
{
DataView dv = dvManager.CreateDataView(dtSet.Tables[0]);
TIME_SHEET_PIVOT.DataSource = dv;
}
}
}
}
}
public MASTER_FREE_VERSIYON(string YAYIN_SINFI, string VER_QUERY)
{
InitializeComponent();
ControlBox = false;
FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
string SQL = string.Empty;
if (YAYIN_SINFI == "TELEVIZYON" || YAYIN_SINFI == "RADYO")
{
SQL = string.Format("select VERSIYON from [dbo].[_ADEX_INDEX_DATA] WHERE {0} group by VERSIYON ", VER_QUERY);
}
else
{
SQL = string.Format("select REKLAM_SLOGANI from [dbo].[_ADEX_INDEX_DATA] WHERE {0} group by REKLAM_SLOGANI ", VER_QUERY);
}
SqlConnection myConnection = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString());
SqlDataAdapter da = new SqlDataAdapter(SQL, myConnection);
DataSet ds = new DataSet();
da.Fill(ds, "stock");
DataViewManager dvManager = new DataViewManager(ds);
DW_LIST = dvManager.CreateDataView(ds.Tables[0]);
gridControl_FREE_TABLE.DataSource = DW_LIST;
}
private void DATA_LOAD_AKTARILDI()
{
BR_BUG.Caption = "";
BR_INFO.Caption = "";
BR_SELECT_ROW_FATURA_GUID.Caption = "";
BR_SELECT_ROW_FATURA_NO.Caption = "";
using (SqlConnection myConnection = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_MDB.ToString()))
{
string SlctQu = "";
if (BTN_YIL.EditValue.ToString() == "TÜMÜ")
{
SlctQu = " SELECT CASE WHEN EINVOICE = 1 THEN 'e-fatura' else 'e-arşiv' END AS FATURANIN_TURU , CASE WHEN TYPE = 8 THEN 'SATIŞ' WHEN TYPE = 3 THEN 'SATIŞ İADE' END AS TIPI ,* FROM dbo.FTR_LG_INVOICE where (SIRKET_KODU=@SIRKET_KODU) AND (TYPE = 8 or TYPE = 3) AND (AKTARIM_DURUMU ='AKTARILDI' or AKTARIM_DURUMU ='ARŞİVEATILDI')";
}
else
{
SlctQu = " SELECT CASE WHEN EINVOICE = 1 THEN 'e-fatura' else 'e-arşiv' END AS FATURANIN_TURU , CASE WHEN TYPE = 8 THEN 'SATIŞ' WHEN TYPE = 3 THEN 'SATIŞ İADE' END AS TIPI ,* FROM dbo.FTR_LG_INVOICE where (SIRKET_KODU=@SIRKET_KODU) AND (TYPE = 8 or TYPE = 3) AND (AKTARIM_DURUMU ='AKTARILDI' or AKTARIM_DURUMU ='ARŞİVEATILDI') AND (YEAR(DATE) = '" + BTN_YIL.EditValue.ToString() + "') ";
}
SqlDataAdapter da = new SqlDataAdapter(SlctQu, myConnection);
da.SelectCommand.Parameters.AddWithValue("@SIRKET_KODU", _GLOBAL_PARAMETERS._SIRKET_KODU);
da.SelectCommand.CommandTimeout = 0;
dataSet = new DataSet();
da.Fill(dataSet, "FTR_LG_INVOICE");
DataViewManager dvManager = new DataViewManager(dataSet);
DataView dv = dvManager.CreateDataView(dataSet.Tables[0]);
gridCntrl_LIST.DataSource = dv;
myConnection.Close();
}
}
public MUSTERI_DOKUMANLARI()
{
InitializeComponent();
this.Tag = "MDIFORM";
ControlBox = false;
FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
using (SqlConnection Conn = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_MDB.ToString()))
{
string Sql = " SELECT * FROM dbo.ADM_MUSTERI WHERE (SIRKET_KODU=@SIRKET_KODU) ORDER BY SIRKET_KODU,MUSTERI_KODU";
using (SqlDataAdapter da = new SqlDataAdapter(Sql, Conn))
{
da.SelectCommand.Parameters.AddWithValue("@SIRKET_KODU", _GLOBAL_PARAMETERS._SIRKET_KODU);
using (DataSet dtSet = new DataSet())
{
da.Fill(dtSet, "ADM_MUSTERI");
using (DataViewManager dvManager = new DataViewManager(dtSet))
{
DataView dv = dvManager.CreateDataView(dtSet.Tables[0]);
GRD_LISTE.DataSource = dv;
}
}
}
}
}
private void SABIT_LISTE()
{
using (SqlConnection conn = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
DataSet ds = new DataSet();
string query = " SELECT MEDYA,ILI,BOLGE FROM dbo._ADEX_INDEX_DATA GROUP BY YAYIN_SINIFI, MEDYA,ILI,BOLGE HAVING (YAYIN_SINIFI = N'SINEMA') ORDER BY MEDYA ";
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(query, conn);
adapter.Fill(ds, "dbo_ANA_YAYIN");
DataViewManager dvManager = new DataViewManager(ds);
DataView dvLIST = dvManager.CreateDataView(ds.Tables[0]);
gridControl_SABITLER.DataSource = dvLIST;
}
gridView_SABITLER.ShowFindPanel();
using (SqlConnection myConnections = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
string SQL = " SELECT top 0 * FROM dbo.TRF_SINEMA ";
SqlDataAdapter MySqlDataAdapter = new SqlDataAdapter(SQL, myConnections);
DataSet ds = new DataSet();
MySqlDataAdapter.Fill(ds, "dbo_SELECTANA_YAYIN");
DataViewManager dvManager = new DataViewManager(ds);
dv = dvManager.CreateDataView(ds.Tables[0]);
gridControl_SECENEKLER.DataSource = dv;
}
}
private void BindImg()
{
var homesTable = new DataTable("Homes");
homesTable.Columns.Add("Index", typeof(int));
homesTable.Columns.Add("Image", typeof(Image));
homesTable.Columns.Add("IsSelect", typeof(bool));
gridControl1.DataMember = null;
gridControl1.DataSource = null;
if (currentHistory.imgInfos != null)
{
currentHistory.imgInfos.ForEach(f => {
//if (f.InfoType == 0)
//{
var row = homesTable.NewRow();
row["Index"] = f.ID;
row["Image"] = new Bitmap(f.Img, new Size(351, 234));
row["IsSelect"] = 0;
homesTable.Rows.Add(row);
//}
});
DataSet ds = new DataSet();
ds.Tables.Add(homesTable);
DataViewManager dvManager = new DataViewManager(ds);
DataView dv = dvManager.CreateDataView(homesTable);
gridControl1.DataSource = dv;
}
}
/// <summary>
/// Método para llenar la cuadricula donde se visualizan los registros
/// </summary>
public void LlenarGrilla()
{
GvGeneral.Columns.Clear();
GvGeneral.OptionsView.ColumnAutoWidth = false;
DataViewManager dvm = new DataViewManager(dsGeneral);
DataView dvMain = dvm.CreateDataView(dsGeneral.Tables[0]);
GridColumn[] col = new GridColumn[PerfilShow.Visibles.Length];
int index = 0;
for (int i = 0; i < PerfilShow.Visibles.Length; i++)
{
index = Convert.ToInt32(PerfilShow.Indices[i]);
col[index] = GvGeneral.Columns.AddField(dsGeneral.Tables[0].Columns[PerfilShow.CamposId[i]].Caption);
col[index].VisibleIndex = index;
//col[index].BestFit();
col[index].Width = PerfilShow.Tamaños[i].ToInt();
col[index].Caption = PerfilShow.Cabeceras[i];
col[index].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
}
GctrlGeneral.DataSource = dvMain;
if (GvGeneral.RowCount > 0)
{
GvGeneral.Focus();
GvGeneral.SelectRow(0);
}
}
private void BTN_LISTE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
TARIFELER._TARIFE_LISTESI TF = new TARIFELER._TARIFE_LISTESI("TARIFE", "SINEMA");
TF.ShowDialog();
lbFILE_NAME.Caption = TF._TARIFE_KODU;
lbID.Caption = TF._TARIFE_ID;
dv = null;
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
string query = string.Format(" SELECT * FROM dbo.TRF_SINEMA where KULLANICI_KODU='{0}' and SIRKET_KODU='{1}' and TARIFE_KODU='{2}' ", _GLOBAL_PARAMETRELER._KULLANICI_MAIL, _GLOBAL_PARAMETRELER._KULLANICI_FIRMA, lbFILE_NAME.Caption);
SqlDataAdapter adapter = new SqlDataAdapter()
{
SelectCommand = new SqlCommand(query, conn)
};
adapter.Fill(ds, "TRF_SINEMA");
DataViewManager dvManager = new DataViewManager(ds);
dv = dvManager.CreateDataView(ds.Tables[0]);
}
gridControl_SECENEKLER.DataSource = dv;
}
public void LlenarGridConsulta()
{
DgvGeneral.Columns.Clear();
DataViewManager dvm = new DataViewManager(dsConsulta);
DataView dvMain = dvm.CreateDataView(dsConsulta.Tables[0]);
DgvGeneral.OptionsBehavior.AutoPopulateColumns = false;
GctrlGeneral.DataSource = dvMain;
string[] captions = new[] { "Id", "IdPersona", "Código", "Nombre Usuario", "Contraseña", "CodTipoUsuario", "Tipo Usuario" };
GridColumn[] col = new GridColumn[dsConsulta.Tables[0].Columns.Count];
for (int i = 0; i < dsConsulta.Tables[0].Columns.Count; i++)
{
col[i] = DgvGeneral.Columns.AddField(dsConsulta.Tables[0].Columns[i].Caption.Trim());
col[i].VisibleIndex = i;
col[i].Caption = captions[i];
col[i].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
if (i == 0 || i == 1 || i == 4 || i == 5 || i == 2)
{
col[i].Visible = false;
}
}
DgvGeneral.Columns[3].Width = 335;
DgvGeneral.Columns[6].Width = 135;
Funciones.getInstancia().Configurar_Grid(DgvGeneral);
DgvGeneral.OptionsCustomization.AllowSort = true;
DgvGeneral.OptionsView.ColumnAutoWidth = false;
DgvGeneral.OptionsFind.AlwaysVisible = true;
}
public void LlenarGridConsulta2()
{
DgvAlumnos.Columns.Clear();
DgvAlumnos.OptionsView.ColumnAutoWidth = false;
DataViewManager dvm = new DataViewManager(dsConsulta2);
DataView dvMain = dvm.CreateDataView(dsConsulta2.Tables[0]);
DgvAlumnos.OptionsBehavior.AutoPopulateColumns = false;
GctrlAlumnos.DataSource = dvMain;
string[] captions = new[] { "CodCurso", "CodigoAlum", "Alumno", "Carnet", "AñoElectivo" };
GridColumn[] col = new GridColumn[dsConsulta2.Tables[0].Columns.Count];
for (int i = 0; i < dsConsulta2.Tables[0].Columns.Count; i++)
{
col[i] = DgvAlumnos.Columns.AddField(dsConsulta2.Tables[0].Columns[i].Caption.Trim());
col[i].VisibleIndex = i;
col[i].Caption = captions[i];
col[i].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
if (i == 0 || i == 1 || i == 4)
{
col[i].Visible = false;
}
}
DgvAlumnos.Columns[2].Width = 250;
DgvAlumnos.Columns[3].Width = 100;
Funciones.getInstancia().Configurar_Grid(DgvAlumnos);
DgvAlumnos.OptionsCustomization.AllowSort = true;
//DgvMaterias.OptionsFind.AlwaysVisible = true;
DgvAlumnos.OptionsView.ColumnAutoWidth = false;
}
private void SABIT_LISTE()
{
using (SqlConnection conn = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
DataSet ds = new DataSet();
string query = "";
if (rdBtn_MIX.Checked)
{
query = " SELECT MNM, ANA_YAYIN, CAST('02:00' AS nvarchar) AS BASLANGIC_SAATI, CAST(N'18:29' AS nvarchar) AS BITIS_SAATI, CAST('-' AS nvarchar) AS OPT_PT " +
" FROM dbo._ADEX_INDEX_DATA " +
" WHERE (YAYIN_SINIFI = N'TELEVIZYON') " +
" GROUP BY MNM, ANA_YAYIN " +
" UNION " +
" SELECT MNM, ANA_YAYIN, CAST('18:30' AS nvarchar) AS BASLANGIC_SAATI, CAST(N'25:59' AS nvarchar) AS BITIS_SAATI, CAST('+' AS nvarchar) AS OPT_PT " +
" FROM dbo._ADEX_INDEX_DATA " +
" WHERE (YAYIN_SINIFI = N'TELEVIZYON') " +
" GROUP BY MNM, ANA_YAYIN " +
" ORDER BY ANA_YAYIN ";
}
if (rdBtn_OPT.Checked)
{
query = " SELECT MNM, ANA_YAYIN, CAST('02:00' AS nvarchar) AS BASLANGIC_SAATI, CAST(N'18:29' AS nvarchar) AS BITIS_SAATI, CAST('-' AS nvarchar) AS OPT_PT " +
" FROM dbo._ADEX_INDEX_DATA " +
" WHERE (YAYIN_SINIFI = N'TELEVIZYON') " +
" GROUP BY MNM, ANA_YAYIN " +
" ORDER BY ANA_YAYIN ";
}
if (rdBtn_PT.Checked)
{
query =
" SELECT MNM, ANA_YAYIN, CAST('18:30' AS nvarchar) AS BASLANGIC_SAATI, CAST(N'25:59' AS nvarchar) AS BITIS_SAATI, CAST('+' AS nvarchar) AS OPT_PT " +
" FROM dbo._ADEX_INDEX_DATA " +
" WHERE (YAYIN_SINIFI = N'TELEVIZYON') " +
" GROUP BY MNM, ANA_YAYIN " +
" ORDER BY ANA_YAYIN ";
}
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(query, conn);
adapter.Fill(ds, "dbo_ANA_YAYIN");
DataViewManager dvManager = new DataViewManager(ds);
DataView dvLIST = dvManager.CreateDataView(ds.Tables[0]);
gridControl_SABITLER.DataSource = dvLIST;
}
gridView_SABITLER.ShowFindPanel();
using (SqlConnection myConnections = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
string SQL = " SELECT top 0 * FROM dbo.TRF_TELEVIZYON_NONE_MEASURED ";
SqlDataAdapter MySqlDataAdapter = new SqlDataAdapter(SQL, myConnections);
DataSet ds = new DataSet();
MySqlDataAdapter.Fill(ds, "dbo_SELECTANA_YAYIN");
DataViewManager dvManager = new DataViewManager(ds);
dv = dvManager.CreateDataView(ds.Tables[0]);
gridControl_SECENEKLER.DataSource = dv;
}
}
private void LlenarGrid()
{
dsPerfiles = new DataSet();
dtPerfiles = new DataTable();
DataColumn DtColumn1 = new DataColumn();
DataColumn DtColumn2 = new DataColumn();
DtColumn1.ColumnName = "Id";
DtColumn2.ColumnName = "Titulo";
dtPerfiles.Columns.Add(DtColumn1);
dtPerfiles.Columns.Add(DtColumn2);
foreach (var item in Perfilador.getInstancia().ListarPerfiles())
{
dtPerfiles.Rows.Add(item);
}
dsPerfiles.Tables.Add(dtPerfiles);
DataViewManager dvm = new DataViewManager(dsPerfiles);
DataView dvMain = dvm.CreateDataView(dsPerfiles.Tables[0]);
GctrlGeneral.DataSource = dvMain;
}
private void SABIT_LISTE()
{
using (SqlConnection conn = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
DataSet ds = new DataSet();
string query = " SELECT MEDYA,ILI,UNITE,ADRES,GENISLIK,YUKSEKLIK,TOPLAM_ALAN,FREKANS,GUN_SAYISI FROM dbo.DATA_OUTDOOR_ADEX GROUP BY YAYIN_SINIFI, MEDYA,ILI,UNITE,ADRES,GENISLIK,YUKSEKLIK,TOPLAM_ALAN,FREKANS,GUN_SAYISI ORDER BY MEDYA ";
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(query, conn);
adapter.Fill(ds, "dbo_ANA_YAYIN");
DataViewManager dvManager = new DataViewManager(ds);
DataView dvLIST = dvManager.CreateDataView(ds.Tables[0]);
gridControl_SABITLER.DataSource = dvLIST;
}
gridView_SABITLER.ShowFindPanel();
using (SqlConnection myConnections = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
string SQL = " SELECT top 0 * FROM dbo.TRF_OUTDOOR ";
SqlDataAdapter MySqlDataAdapter = new SqlDataAdapter(SQL, myConnections);
DataSet ds = new DataSet();
MySqlDataAdapter.Fill(ds, "dbo_SELECTANA_YAYIN");
DataViewManager dvManager = new DataViewManager(ds);
dv = dvManager.CreateDataView(ds.Tables[0]);
gridControl_SECENEKLER.DataSource = dv;
}
}
private void RAPOR_LIST_READ()
{
//string SQL = " SELECT dbo.ADM_GRUP_DAHIL_KULLANICILAR.FIRMA, dbo.ADM_GRUP_DAHIL_KULLANICILAR.EMAIL, dbo.ADM_GRUP_HAKLARI.RAPOR_KODU, dbo.ADM_RAPOR_DESIGNE.ACIKLAMA,dbo.ADM_RAPOR_DESIGNE.MECRA_TURLERI, dbo.ADM_RAPOR_DESIGNE.DURUMU " +
//" FROM dbo.ADM_GRUP_DAHIL_KULLANICILAR INNER JOIN dbo.ADM_GRUP_HAKLARI ON dbo.ADM_GRUP_DAHIL_KULLANICILAR.GRUPLAR = dbo.ADM_GRUP_HAKLARI.GRUPLAR INNER JOIN " +
//" dbo.ADM_RAPOR_DESIGNE ON dbo.ADM_GRUP_HAKLARI.RAPOR_KODU = dbo.ADM_RAPOR_DESIGNE.RAPOR_KODU " +
//" GROUP BY dbo.ADM_GRUP_DAHIL_KULLANICILAR.FIRMA, dbo.ADM_GRUP_DAHIL_KULLANICILAR.EMAIL, dbo.ADM_GRUP_HAKLARI.RAPOR_KODU, dbo.ADM_GRUP_HAKLARI.FIRMA, " +
//" dbo.ADM_RAPOR_DESIGNE.ACIKLAMA, dbo.ADM_RAPOR_DESIGNE.SIRKET_KODU,dbo.ADM_GRUP_HAKLARI.PAYLASIM_TURU,dbo.ADM_RAPOR_DESIGNE.MECRA_TURLERI, dbo.ADM_RAPOR_DESIGNE.DURUMU" +
//" HAVING (dbo.ADM_GRUP_DAHIL_KULLANICILAR.EMAIL = N'" + _GLOBAL_PARAMETRELER._KULLANICI_MAIL + "') AND (dbo.ADM_GRUP_DAHIL_KULLANICILAR.FIRMA = N'" + _GLOBAL_PARAMETRELER._KULLANICI_FIRMA + "') AND (dbo.ADM_GRUP_HAKLARI.FIRMA = N'" + _GLOBAL_PARAMETRELER._KULLANICI_FIRMA + "') " +
//" AND (dbo.ADM_RAPOR_DESIGNE.SIRKET_KODU = N'" + _GLOBAL_PARAMETRELER._KULLANICI_FIRMA + "') AND (dbo.ADM_GRUP_HAKLARI.PAYLASIM_TURU = N'RAPOR') " +
//" UNION " +
//" SELECT dbo.ADM_KULLANICI_HAKLARI.FIRMA, dbo.ADM_KULLANICI_HAKLARI.EMAIL, dbo.ADM_RAPOR_DESIGNE.RAPOR_KODU, dbo.ADM_RAPOR_DESIGNE.ACIKLAMA,dbo.ADM_RAPOR_DESIGNE.DURUMU ,dbo.ADM_RAPOR_DESIGNE.MECRA_TURLERI " +
//" FROM dbo.ADM_RAPOR_DESIGNE INNER JOIN " +
//" dbo.ADM_KULLANICI_HAKLARI ON dbo.ADM_RAPOR_DESIGNE.RAPOR_KODU = dbo.ADM_KULLANICI_HAKLARI.RAPOR_KODU " +
//" GROUP BY dbo.ADM_RAPOR_DESIGNE.ACIKLAMA, dbo.ADM_RAPOR_DESIGNE.SIRKET_KODU, dbo.ADM_KULLANICI_HAKLARI.FIRMA, dbo.ADM_KULLANICI_HAKLARI.EMAIL, dbo.ADM_RAPOR_DESIGNE.RAPOR_KODU,dbo.ADM_KULLANICI_HAKLARI.PAYLASIM_TURU,dbo.ADM_RAPOR_DESIGNE.DURUMU,dbo.ADM_RAPOR_DESIGNE.MECRA_TURLERI " +
//" HAVING (dbo.ADM_RAPOR_DESIGNE.SIRKET_KODU = N'" + _GLOBAL_PARAMETRELER._KULLANICI_FIRMA + "') AND (dbo.ADM_KULLANICI_HAKLARI.FIRMA = N'" + _GLOBAL_PARAMETRELER._KULLANICI_FIRMA + "') AND (dbo.ADM_KULLANICI_HAKLARI.EMAIL = N'" + _GLOBAL_PARAMETRELER._KULLANICI_MAIL + "') AND (dbo.ADM_KULLANICI_HAKLARI.PAYLASIM_TURU = N'RAPOR') " +
//" UNION " +
string SQL = " SELECT SIRKET_KODU, OWNER_MAIL, RAPOR_KODU, ACIKLAMA,MECRA_TURLERI,DURUMU FROM dbo.ADM_RAPOR_DESIGNE WHERE (SIRKET_KODU = N'" + _GLOBAL_PARAMETRELER._KULLANICI_FIRMA + "') AND (OWNER_MAIL = N'" + _GLOBAL_PARAMETRELER._KULLANICI_MAIL + "') order by RAPOR_KODU ";
SqlConnection myConnection = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString());
SqlDataAdapter da = new SqlDataAdapter(SQL, myConnection);
DataSet ds = new DataSet();
da.Fill(ds, "stock");
DataViewManager dvManager = new DataViewManager(ds);
DataView dv = dvManager.CreateDataView(ds.Tables[0]);
gridControl_LISTE.DataSource = dv;
}
private void setupGrip()
{
dsMain = new DataSet();
dsMain = VM.GetVoucherStructure(VoucherMasterId);
dsMain.Tables[0].TableName = "VoucherMaster";
dsMain.Tables[1].TableName = "VoucherDetail";
dsMain.Tables[2].TableName = "FlagDC";
dsMain.Tables[3].TableName = "ChartOfAccounts";
dsMain.Tables[4].TableName = "BankVoucherDetail";
dsMain.Tables["VoucherMaster"].Columns["VoucherMasterId"].AutoIncrement = true;
dsMain.Tables["VoucherMaster"].Columns["VoucherMasterId"].AutoIncrementSeed = -1;
dsMain.Tables["VoucherMaster"].Columns["VoucherMasterId"].AutoIncrementStep = -1;
dsMain.Tables["VoucherDetail"].Columns["VoucherDetailId"].AutoIncrement = true;
dsMain.Tables["VoucherDetail"].Columns["VoucherDetailId"].AutoIncrementSeed = -1;
dsMain.Tables["VoucherDetail"].Columns["VoucherDetailId"].AutoIncrementStep = -1;
dsMain.Relations.Add("MasterRelation", dsMain.Tables["VoucherMaster"].Columns["VoucherMasterId"], dsMain.Tables["VoucherDetail"].Columns["VoucherMasterId"]);
drMaster = dsMain.Tables["VoucherMaster"].NewRow();
dsMain.Tables["VoucherMaster"].Rows.Add(drMaster);
dvm = new DataViewManager(dsMain);
dvCOA = dvm.CreateDataView(dsMain.Tables["ChartOfAccounts"]);
GCDetail.DataSource = dsMain.Tables["VoucherDetail"];
GridSetting();
}
public void LlenarGridConsulta2()
{
DgvGeneral.Columns.Clear();
DgvGeneral.OptionsView.ColumnAutoWidth = false;
DataViewManager dvm = new DataViewManager(dsConsulta2);
DataView dvMain = dvm.CreateDataView(dsConsulta2.Tables[0]);
DgvGeneral.OptionsBehavior.AutoPopulateColumns = true;
GctrlGeneral.DataSource = dvMain;
DgvGeneral.Columns[0].Visible = false;
DgvGeneral.Columns[1].BestFit();
DevExpress.XtraEditors.Repository.RepositoryItemTextEdit numerico2 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
numerico2.Mask.EditMask = "n";
numerico2.Mask.UseMaskAsDisplayFormat = true;
numerico2.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
for (int i = 2; i < DgvGeneral.Columns.Count - 1; i++)
{
DgvGeneral.Columns[i].ColumnEdit = numerico2;
DgvGeneral.Columns[i].BestFit();
}
Font fuenteNegrita = new Font("Tahoma", 8.25F, FontStyle.Bold);
DgvGeneral.Columns[1].AppearanceCell.Font = fuenteNegrita;
Funciones.getInstancia().Configurar_Grid(DgvGeneral);
DgvGeneral.OptionsBehavior.Editable = false;
DgvGeneral.OptionsCustomization.AllowSort = false;
DgvGeneral.OptionsView.ColumnAutoWidth = false;
DgvGeneral.OptionsCustomization.AllowGroup = true;
DgvGeneral.OptionsView.ShowGroupPanel = false;
}
private void DATA_LOAD()
{
string SQL = @" SELECT SIRKET_KODU, KULLANICI, ACIKLAMA, AY, SURE
FROM dbo.TODO_TIME_SHEET_FKUL WHERE (SIRKET_KODU=@SIRKET_KODU) AND (ACIKLAMA=@ACIKLAMA) AND (YIL >=@StartDate) AND (YIL <=@EndDate )
";
using (SqlConnection Conn = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_MDB.ToString())) // and (dbo.TODO_TIME_SHEET.MAIL_ADRESI=@MAIL_ADRESI)
{
using (SqlDataAdapter da = new SqlDataAdapter(SQL, Conn))
{
da.SelectCommand.Parameters.AddWithValue("@SIRKET_KODU", _GLOBAL_PARAMETERS._SIRKET_KODU);
da.SelectCommand.Parameters.AddWithValue("@ACIKLAMA", dtMusteri.EditValue.ToString());
da.SelectCommand.Parameters.AddWithValue("@StartDate", BR_YIL.EditValue.ToString());
da.SelectCommand.Parameters.AddWithValue("@EndDate", BR_YIL.EditValue.ToString());
using (DataSet dtSet = new DataSet())
{
da.Fill(dtSet, "ADM_MUSTERI");
using (DataViewManager dvManager = new DataViewManager(dtSet))
{
DataView dv = dvManager.CreateDataView(dtSet.Tables[0]);
TIME_SHEET_PIVOT.DataSource = dv;
}
}
}
}
}
private void DATA_LOAD_PIVOT()
{
using (SqlConnection connection = new SqlConnection(GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
SqlCommand command;
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet dsPLAN_ROW = new DataSet();
connection.Open();
string SQLS = @"SELECT REPORT_ITEM FROM dbo.ScoreCard GROUP BY REPORT_ITEM ORDER BY REPORT_ITEM ";
command = new SqlCommand(SQLS, connection);
command.CommandTimeout = 0;
adapter.SelectCommand = command;
adapter.Fill(dsPLAN_ROW, "LIST_TABLE");
string sql = "";
for (int i = 0; i <= dsPLAN_ROW.Tables["LIST_TABLE"].Rows.Count - 1; i++)
{
sql += " MIN( CASE SCD.REPORT_ITEM WHEN '" + dsPLAN_ROW.Tables["LIST_TABLE"].Rows[i]["REPORT_ITEM"].ToString() + "' THEN SC.SCORE END ) AS [" + dsPLAN_ROW.Tables["LIST_TABLE"].Rows[i]["REPORT_ITEM"].ToString().Replace(" ", "").Replace("&", "") + "], ";
}
sql = sql.ToString().Substring(0, sql.Length - 2).ToString();
string SQL = " SELECT dbo.SCORE_CARD_URUNLER.URUNLER, SC.COLUM_NAME, " + sql + " FROM dbo.ScoreCard AS SCD INNER JOIN dbo.SCORE_CARD_SCORE AS SC ON SCD.SETID = SC.SETID AND SCD.GUID = SC.GUID INNER JOIN dbo.SCORE_CARD_URUNLER ON SC.SETID = dbo.SCORE_CARD_URUNLER.ID GROUP BY SC.COLUM_NAME, dbo.SCORE_CARD_URUNLER.URUNLER ORDER BY dbo.SCORE_CARD_URUNLER.URUNLER";
adapter.SelectCommand.CommandText = SQL;
adapter.SelectCommand.CommandTimeout = 0;
adapter.Fill(dsPLAN_ROW, "CHART_TABLE");
DataViewManager dvManager = new DataViewManager(dsPLAN_ROW);
DataView DW_CHART = dvManager.CreateDataView(dsPLAN_ROW.Tables["CHART_TABLE"]);
GRD_RAPOR.DataSource = DW_CHART;
}
}
private void LlenarGridConsulta()
{
DgvMaterias.Columns.Clear();
DgvMaterias.OptionsView.ColumnAutoWidth = false;
DataViewManager dvm = new DataViewManager(dsConsulta);
DataView dvMain = dvm.CreateDataView(dsConsulta.Tables[0]);
DgvMaterias.OptionsBehavior.AutoPopulateColumns = false;
GctrlMaterias.DataSource = dvMain;
string[] captions = new[] { "CodigoProfesor", "Area", "CodMateria", "Materia" };
GridColumn[] col = new GridColumn[dsConsulta.Tables[0].Columns.Count];
for (int i = 0; i < dsConsulta.Tables[0].Columns.Count; i++)
{
col[i] = DgvMaterias.Columns.AddField(dsConsulta.Tables[0].Columns[i].Caption.Trim());
col[i].VisibleIndex = i;
col[i].Caption = captions[i];
col[i].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
if (i == 0 || i == 2)
{
col[i].Visible = false;
}
}
DgvMaterias.Columns[1].Width = 300;
DgvMaterias.Columns[3].Width = 255;
Funciones.getInstancia().Configurar_Grid(DgvMaterias);
DgvMaterias.OptionsCustomization.AllowSort = true;
//DgvMaterias.OptionsFind.AlwaysVisible = true;
DgvMaterias.OptionsView.ColumnAutoWidth = false;
}
private void BindingDataSource(DataTable tblParent, DataTable tblChild, string colParent, string colChild)
{
m_dsADO.Tables.Add(tblParent);
m_dsADO.Tables.Add(tblChild);
#if 관계객체없이제약조건직접걸기
ForeignKeyConstraint fk = new ForeignKeyConstraint(RELATION_BUY
, m_dsADO.Tables["tblPeople"].Columns["Name"]
, m_dsADO.Tables["tblSale"].Columns["Customer"]);
//fk.DeleteRule = Rule.Cascade;
//fk.UpdateRule = Rule.Cascade;
//fk.AcceptRejectRule = AcceptRejectRule.None;
m_dsADO.Tables["tblSale"].Constraints.Add(fk);//자식테입블의 키에 ForeignKey제약조건 걸어 자식 키가 유효한 부모키를 가리킬 것을 강제.
m_dsADO.EnforceConstraints = true;
#else
m_relationBuy = new DataRelation(RELATION_BUY
, m_dsADO.Tables[tblParent.TableName].Columns[colParent]
, m_dsADO.Tables[tblChild.TableName].Columns[colChild]);
m_dsADO.Relations.Add(m_relationBuy);
//관계의 룰 기본값을 변경할 경우, 아래 코드 실행하면 변경 가능
//ForeignKeyConstraint fk = (ForeignKeyConstraint)m_dsADO.Tables["tblSale"].Constraints[RELATION_BUY];
//fk.DeleteRule = Rule.None;
#endif
#if VIEWMANAGER
//DataViewManager : 다수의 뷰를 중앙에서 관리. 개별 뷰의 설정 상태인 DataViewSetting 을 보유.
// + 여러 테이블의 보기 상태 일괄 수정 가능
// + 컨트롤에 바인딩시 매니저를 통해 가능
// + 일부 열만 가지는 수직뷰 생성 불가
// + 테이블에 대한 동적뷰만 제공 : 조인결과 가질 수 없음
// + 레코드의 상태에 따라 필터 구성 가능
DataViewManager dvmManager = new DataViewManager(m_dsADO);
dvmManager.DataViewSettings["tblPeople"].Sort = "Name";
dvmManager.DataViewSettings["tblSale"].RowFilter = "OrderNo > 1";
DataView dvPeople = dvmManager.CreateDataView(m_tblPeople);
dvPeople.RowFilter = "Male = true";
dvPeople.Sort = "Age DESC";
foreach (DataViewSetting dvs in dvmManager.DataViewSettings)
{
lbxSale.Items.Add(String.Format("테이블: {0}, 필터: {1}, 정렬: {2}, 상태: {3}", dvs.Table, dvs.RowFilter, dvs.Sort, dvs.RowStateFilter));
}
//그리드 출력: (1)매니저 바인딩 ==> (2)뷰의 DataMember 지정
dgvPeople.DataSource = dvmManager;
dgvPeople.DataMember = "tblPeople";
dgvSale.DataSource = dvmManager;
dgvSale.DataMember = "tblSale";
#else
dgvPeople.DataSource = m_dsADO.Tables[tblParent.TableName];
dgvSale.DataSource = m_dsADO.Tables[tblChild.TableName];
#endif
}
/// <summary> LlenarGrid(DataSet d)
/// Permite llenar la grilla con un Dataset
/// </summary>
/// <param name="d">En este parametro se recibe el Dataset con que se va a llenar la grilla DgvCampos </param>
public void LlenarGridCampos(DataSet d)
{
if (d != null)
{
DgvCampos.Columns.Clear();
DataViewManager dvm = new DataViewManager(d);
DataView dvMain = dvm.CreateDataView(d.Tables[0]);
DgvCampos.OptionsBehavior.AutoPopulateColumns = false;
GcrtlCampos.DataSource = dvMain;
GridColumn[] col = new GridColumn[d.Tables[0].Columns.Count];
string[] captions = new[] { "Campo", "Agregar", "Visible" };
for (int i = 0; i < d.Tables[0].Columns.Count; i++)
{
col[i] = DgvCampos.Columns.AddField(d.Tables[0].Columns[i].Caption.Trim());
col[i].VisibleIndex = i;
col[i].Caption = captions[i];
col[i].FieldName = captions[i];
}
DgvCampos.Columns["Campo"].Width = 504;
DgvCampos.Columns["Agregar"].Width = 48;
DgvCampos.Columns["Visible"].Width = 47;
DevExpress.XtraEditors.Repository.RepositoryItemTextEdit memo = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
memo.ReadOnly = true;
DgvCampos.Columns[0].ColumnEdit = memo;
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit memo1 = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
memo1.CheckStyle = DevExpress.XtraEditors.Controls.CheckStyles.Standard;
DgvCampos.Columns[1].ColumnEdit = memo1;
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit memo2 = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
DgvCampos.Columns[2].ColumnEdit = memo2;
}
DgvCampos.OptionsBehavior.AutoPopulateColumns = false;
DgvCampos.OptionsBehavior.AllowDeleteRows = DevExpress.Utils.DefaultBoolean.False;
DgvCampos.OptionsBehavior.AllowAddRows = DevExpress.Utils.DefaultBoolean.False;
DgvCampos.OptionsView.ColumnAutoWidth = false;
DgvCampos.OptionsFilter.AllowFilterEditor = false;
DgvCampos.OptionsFilter.AllowColumnMRUFilterList = false;
DgvCampos.OptionsFilter.AllowMRUFilterList = false;
DgvCampos.OptionsFilter.MRUFilterListPopupCount = 0;
DgvCampos.OptionsFilter.MRUFilterListCount = 0;
DgvCampos.OptionsFilter.MRUColumnFilterListCount = 0;
DgvCampos.OptionsView.EnableAppearanceOddRow = true;
DgvCampos.OptionsView.ShowAutoFilterRow = false;
DgvCampos.OptionsView.ShowGroupPanel = false;
DgvCampos.OptionsHint.ShowColumnHeaderHints = false;
DgvCampos.OptionsView.ShowIndicator = true;
DgvCampos.OptionsView.ShowFilterPanelMode = DevExpress.XtraGrid.Views.Base.ShowFilterPanelMode.Default;
DgvCampos.OptionsCustomization.AllowQuickHideColumns = false;
DgvCampos.OptionsCustomization.AllowFilter = false;
DgvCampos.OptionsMenu.EnableColumnMenu = false;
DgvCampos.ScrollStyle = DevExpress.XtraGrid.Views.Grid.ScrollStyleFlags.LiveHorzScroll;
DgvCampos.HorzScrollVisibility = DevExpress.XtraGrid.Views.Base.ScrollVisibility.Always;
}
private void Liste()
{
try
{
if (_TABLE_NAME != null)
{
using (SqlConnection conn = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
DataSet ds = new DataSet();
string query = " select " + _TABLE_NAME;
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(query, conn);
adapter.Fill(ds, "dbo_" + _TABLE_NAME);
DataViewManager dvManager = new DataViewManager(ds);
DataView dvLIST = dvManager.CreateDataView(ds.Tables[0]);
grdCntrl_LIST.DataSource = dvLIST;
gridView_LIST.Columns[0].Visible = false;
gridView_LIST.Columns[1].Visible = false;
gridView_LIST.Columns[2].Visible = false;
gridView_LIST.Columns[3].Visible = false;
gridView_LIST.Columns[4].Visible = false;
gridView_LIST.Columns[5].Visible = false;
gridView_LIST.Columns[6].Width = 300;
gridView_LIST.Columns[6].OptionsColumn.AllowEdit = false;
gridView_LIST.Columns[7].Width = 30;
gridView_LIST.Columns[7].OptionsColumn.AllowEdit = true;
}
gridView_LIST.ShowFindPanel();
}
if (_TABLE_NAME != null)
{
dvSELECT = null;
using (SqlConnection myConnections = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
string SQL = " select top 0 " + _TABLE_NAME;
SqlDataAdapter MySqlDataAdapter = new SqlDataAdapter(SQL, myConnections);
DataSet ds = new DataSet();
MySqlDataAdapter.Fill(ds, "dbo_" + _TABLE_NAME);
DataViewManager dvManager = new DataViewManager(ds);
dvSELECT = dvManager.CreateDataView(ds.Tables[0]);
grdCntrl_SELECT.DataSource = dvSELECT;
gridView_SELECT.Columns[0].Visible = false;
gridView_SELECT.Columns[1].Visible = false;
gridView_SELECT.Columns[2].Visible = false;
gridView_SELECT.Columns[3].Visible = false;
gridView_SELECT.Columns[4].Visible = false;
gridView_SELECT.Columns[5].Visible = false;
gridView_SELECT.Columns[6].Width = 300;
gridView_SELECT.Columns[6].OptionsColumn.AllowEdit = false;
gridView_SELECT.Columns[7].Width = 30;
gridView_SELECT.Columns[7].OptionsColumn.AllowEdit = true;
}
}
}
catch { }
}
/// <summary>
/// 加载字典文件到数据视图(DataView)
/// </summary>
/// <param name="path">目录</param>
/// <param name="filename">字典文件名</param>
/// <returns></returns>
public static DataView getViewByFile(string path, string filename)
{
DataSet ds = new DataSet();
ds.ReadXml(path + "\\" + filename);
DataViewManager dvm = new DataViewManager(ds);
return(dvm.CreateDataView(ds.Tables["row"]));
}
public PROGRAM()
{
InitializeComponent();
using (SqlConnection conn = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(" SELECT top 0 * FROM dbo.TRF_PROGRAM_TARIFESI ", conn);
adapter.Fill(ds, "dbo_ANA_YAYIN");
DataViewManager dvManager = new DataViewManager(ds);
dvLIST = dvManager.CreateDataView(ds.Tables[0]);
gridControl_SABITLER.DataSource = dvLIST;
}
gridView_SABITLER.ShowFindPanel();
using (SqlConnection myConnections = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
SqlDataAdapter MySqlDataAdapter = new SqlDataAdapter(" SELECT top 0 * FROM dbo.TRF_PROGRAM_TARIFESI ", myConnections);
DataSet ds = new DataSet();
MySqlDataAdapter.Fill(ds, "dbo_SELECTANA_YAYIN");
DataViewManager dvManager = new DataViewManager(ds);
dv = dvManager.CreateDataView(ds.Tables[0]);
gridControl_SECENEKLER.DataSource = dv;
}
COMBO_HESAPLAMA_TURU.Properties.Items.Clear();
using (SqlConnection myConnection = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
myConnection.Open();
string SQL_TELEVIZYON = " SELECT MECRA_TURU, HESAPLAMA_TURU FROM dbo.ADM_HESAPLAMA_TURLERI WHERE (MECRA_TURU = N'TELEVIZYON')";
using (SqlCommand myCommand = new SqlCommand(SQL_TELEVIZYON, myConnection))
{
SqlDataReader myReader = myCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
while (myReader.Read())
{
COMBO_HESAPLAMA_TURU.Properties.Items.Add(myReader["HESAPLAMA_TURU"].ToString());
}
}
}
CMB_ANA_YAYIN.Properties.Items.Clear();
using (SqlConnection myConnection = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
myConnection.Open();
string SQL_ANA_YAYIN = " SELECT ANA_YAYIN FROM dbo._ADEX_INDEX_DATA WHERE (YAYIN_SINIFI = N'TELEVIZYON') group by ANA_YAYIN ORDER BY ANA_YAYIN ";
using (SqlCommand myCommand = new SqlCommand(SQL_ANA_YAYIN, myConnection))
{
SqlDataReader myReader = myCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
while (myReader.Read())
{
CMB_ANA_YAYIN.Properties.Items.Add(myReader["ANA_YAYIN"].ToString());
}
}
}
}
private void setGridSetup()
{
dset = new DataSet();
////**** FlagIO ***
//DataTable dtFlagIO = new DataTable();
//dtFlagIO.TableName = "FlagIO";
//dtFlagIO.Columns.Add(new DataColumn("FlagIO", System.Type.GetType("System.String")));
//DataRow drInn = dtFlagIO.NewRow();
//drInn["FlagIO"] = "I";
//dtFlagIO.Rows.Add(drInn);
//DataRow drOut = dtFlagIO.NewRow();
//drOut["FlagIO"] = "O";
//dtFlagIO.Rows.Add(drOut);
dset = manageProduct.GetAdjustmentStructure(StockAdjusmentId);
dset.Tables[0].TableName = "AdjustmentMaster";
dset.Tables[1].TableName = "AdjustmentDetail";
dset.Tables[2].TableName = "Product";
dset.Tables[3].TableName = "Warehouse";
dset.Tables[4].TableName = "FlagIO";
//dset.Tables.Add(dtFlagIO);
dset.Tables["AdjustmentMaster"].Columns["AdjustId"].AutoIncrement = true;
dset.Tables["AdjustmentMaster"].Columns["AdjustId"].AutoIncrementSeed = -1;
dset.Tables["AdjustmentMaster"].Columns["AdjustId"].AutoIncrementStep = -1;
dset.Tables["AdjustmentDetail"].Columns["AdjustDetailId"].AutoIncrement = true;
dset.Tables["AdjustmentDetail"].Columns["AdjustDetailId"].AutoIncrementSeed = -1;
dset.Tables["AdjustmentDetail"].Columns["AdjustDetailId"].AutoIncrementStep = -1;
dset.Relations.Add("MasterRelation", dset.Tables["AdjustmentMaster"].Columns["AdjustId"], dset.Tables["AdjustmentDetail"].Columns["AdjustId"]);
if (dset.Tables["AdjustmentMaster"].Rows.Count > 0)
{
drMaster = dset.Tables["AdjustmentMaster"].Rows[0];
}
else
{
drMaster = dset.Tables["AdjustmentMaster"].NewRow();
dset.Tables["AdjustmentMaster"].Rows.Add(drMaster);
}
dvm = new DataViewManager(dset);
dvProducts = dvm.CreateDataView(dset.Tables["Product"]);
GCDetail.DataSource = dset.Tables["AdjustmentDetail"];
GridSetting();
}
private void DATA_LOAD()
{
using (SqlConnection myConnection = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_MDB.ToString()))
{
SqlDataAdapter MySqlDataAdapter = new SqlDataAdapter("SELECT * FROM dbo.ADM_KULLANICI ", myConnection);
DataSet MyDataSet = new DataSet();
MySqlDataAdapter.Fill(MyDataSet, "dbo_USER");
DataViewManager dvManager = new DataViewManager(MyDataSet);
dv = dvManager.CreateDataView(MyDataSet.Tables[0]);
gridCntrl_LIST.DataSource = dv;
}
}
private void DATA_READ(string _TARIFE_KODU)
{
SqlConnection MySqlConnection = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString());
SqlDataAdapter MySqlDataAdapter = new SqlDataAdapter("SELECT * FROM dbo.TRF_SINEMA WHERE TARIFE_KODU='" + _TARIFE_KODU + "' and SIRKET_KODU='" + _GLOBAL_PARAMETRELER._KULLANICI_FIRMA + "'", MySqlConnection);
DataSet MyDataSet = new DataSet();
MySqlDataAdapter.Fill(MyDataSet, "dbo_TarifeDergi");
DataViewManager dvManager = new DataViewManager(MyDataSet);
dv = dvManager.CreateDataView(MyDataSet.Tables[0]);
gridControl_SECENEKLER.DataSource = dv;
}
private void BTN_ONAY_REFRESH_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
using (SqlConnection MySqlConnection = new SqlConnection(_GLOBAL_PARAMETERS._CONNECTIONSTRING_MDB)) //_GLOBAL_PARAMETERS._CONNECTIONSTRING_ERP.ToString()
{
SqlDataAdapter da = new SqlDataAdapter("SELECT AccCustomerPartyName , SIRKET_KODU FROM dbo.FTR_GELEN_FATURALAR GROUP BY AccCustomerPartyName,SIRKET_KODU ORDER BY AccCustomerPartyName", MySqlConnection);
ds = new DataSet();
da.Fill(ds, "Header");
DataViewManager dvManager = new DataViewManager(ds);
DataView dv = dvManager.CreateDataView(ds.Tables[0]);
GRD_LISTE.DataSource = dv;
}
}
private void DATA_READ(string _TARIFE_KODU)
{
SqlConnection MySqlConnection = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString());
SqlDataAdapter MySqlDataAdapter = new SqlDataAdapter(string.Format("SELECT * FROM dbo.TRF_GAZETE WHERE TARIFE_KODU='{0}' and SIRKET_KODU='{1}'", _TARIFE_KODU, _GLOBAL_PARAMETRELER._KULLANICI_FIRMA), MySqlConnection);
DataSet MyDataSet = new DataSet();
MySqlDataAdapter.Fill(MyDataSet, "TRF_GAZETE");
DataViewManager dvManager = new DataViewManager(MyDataSet);
dv = dvManager.CreateDataView(MyDataSet.Tables[0]);
gridControl_SECENEKLER.DataSource = dv;
}
private void TABLE_READ()
{
using (SqlConnection myConnection = new SqlConnection(GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
SqlDataAdapter MySqlDataAdapter = new SqlDataAdapter("select * from ADM_TABLE_LIST", myConnection);
DataSet MyDataSet = new DataSet();
MySqlDataAdapter.Fill(MyDataSet, "dbo_MecraList");
DataViewManager dvManager = new DataViewManager(MyDataSet);
DataView dv = dvManager.CreateDataView(MyDataSet.Tables[0]);
GRD_LIST.DataSource = dv;
}
}
