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;
}
private void openToolStripButton_Click(object sender, EventArgs e)
{
TARIFELER._TARIFE_LISTESI tmp = new TARIFELER._TARIFE_LISTESI("MASTER", "");
tmp.ShowDialog();
if (tmp._BTN_TYPE == "Tamam" && tmp._TARIFE_KODU != null)
{
MASTER_TABLE_READ(tmp._TARIFE_KODU, tmp._FILITRE_TEXT, tmp._TARIFE_ID, tmp._BASLIKLAR, tmp._MECRA_TURLERI);
}
}
private void openToolStripButton_Click(object sender, EventArgs e)
{
TARIFELER._TARIFE_LISTESI tmp = new TARIFELER._TARIFE_LISTESI("KEYWORD", "KEYWORD");
tmp.ShowDialog();
try
{
if (tmp._BTN_TYPE == "Tamam" && tmp._TARIFE_KODU != null)
{
TARIFE_KODU = tmp._TARIFE_KODU;
string TAB_VARMI = "YOK";
int TabCount = 0;
for (int i = 0; i < xtraTabControl_WORD_MNG_DETAY.TabPages.Count; i++)
{
if (xtraTabControl_WORD_MNG_DETAY.TabPages[i].Name == TARIFE_KODU)
{
TAB_VARMI = "VAR"; TabCount = i;
}
}
// TARIFE_CHANGE(TF._MECRA_TURU);
// this.ParentForm.GetType().InvokeMember("TARIFE_SELECT", System.Reflection.BindingFlags.InvokeMethod, null, this.ParentForm, new object[] { TF._MECRA_TURU });
if (TAB_VARMI == "YOK")
{
if (tmp._TARIFE_KODU != null)
{
grdCntrl_ = new DevExpress.XtraGrid.GridControl();
gridView_ = new DevExpress.XtraGrid.Views.Grid.GridView();
re_FIELD_SELECT = new DevExpress.XtraEditors.Repository.RepositoryItemCheckedComboBoxEdit();
re_WORD_MEMO = new DevExpress.XtraEditors.Repository.RepositoryItemMemoEdit();
re_FIELD_UPDATES = new DevExpress.XtraEditors.Repository.RepositoryItemComboBox();
using (SqlConnection myConnection = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
string SQL = string.Format(" SELECT ID ,ParentID, TEXT, CHILD_INDEX,GUI, CHECKS FROM dbo.ADM_RAPOR_BASLIK WHERE SIRKET_KODU='{0}' AND RAPOR_KODU='{1}' order by ParentID,CHILD_INDEX", _GLOBAL_PARAMETRELER._KULLANICI_FIRMA, _GLOBAL_PARAMETRELER._RAPOR_KODU);
SqlCommand myCommand = new SqlCommand(SQL, myConnection)
{
CommandText = SQL.ToString()
};
myConnection.Open();
SqlDataReader myReader = myCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
while (myReader.Read())
{
re_FIELD_SELECT.Items.Add(myReader["TEXT"]);
re_FIELD_UPDATES.Items.Add(myReader["TEXT"]);
}
}
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
SqlDataAdapter adapter = new SqlDataAdapter(string.Format("SELECT ID,[ALANLAR],[KEYWORDS],[ALAN],[DEGER] FROM dbo.TRF_KEYWORD WHERE TARIFE_KODU='{0}' and SIRKET_KODU='{1}'", tmp._TARIFE_KODU, _GLOBAL_PARAMETRELER._KULLANICI_FIRMA), conn);
adapter.Fill(ds, "TRF_MASTER");
DataViewManager dvManager = new DataViewManager(ds);
DataView DW_LIST_TARIFE = dvManager.CreateDataView(ds.Tables[0]);
grdCntrl_.DataSource = DW_LIST_TARIFE;
for (int i = 0; i <= 5; i++)
{
DW_LIST_TARIFE.AddNew();
}
}
}
//ToolStrip mn = new ToolStrip();
//mn.Dock = DockStyle.Top;
//mn.SendToBack();
//xtraTabControl_MASTER_MNG_DETAY.TabPages.Add("Yeni");
//xtraTabControl_MASTER_MNG_DETAY.TabPages[xtraTabControl_MASTER_MNG_DETAY.TabPages.Count - 1].Controls.Add(mn);
xtraTabControl_WORD_MNG_DETAY.TabPages.Add("");
xtraTabControl_WORD_MNG_DETAY.TabPages[xtraTabControl_WORD_MNG_DETAY.TabPages.Count - 1].Controls.Add(grdCntrl_);
xtraTabControl_WORD_MNG_DETAY.TabPages[xtraTabControl_WORD_MNG_DETAY.TabPages.Count - 1].Name = TARIFE_KODU;
xtraTabControl_WORD_MNG_DETAY.TabPages[xtraTabControl_WORD_MNG_DETAY.TabPages.Count - 1].Text = TARIFE_KODU;
xtraTabControl_WORD_MNG_DETAY.TabPages[xtraTabControl_WORD_MNG_DETAY.TabPages.Count - 1].Tag = tmp._TARIFE_ID;
xtraTabControl_WORD_MNG_DETAY.TabPages[xtraTabControl_WORD_MNG_DETAY.TabPages.Count - 1].ContextMenuStrip = CNMN_TARIFE;
//
// grdCntrl_List
//
grdCntrl_.Dock = DockStyle.Fill;
grdCntrl_.Location = new System.Drawing.Point(0, 0);
grdCntrl_.MainView = gridView_;
//grdCntrl_.MenuManager = this.barManagers;
grdCntrl_.ContextMenuStrip = CNMN_TARIFE;
grdCntrl_.Name = TARIFE_KODU;//_FIELD_NAME;
grdCntrl_.Size = new System.Drawing.Size(699, 368);
grdCntrl_.TabIndex = 1;
grdCntrl_.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] { gridView_ });
grdCntrl_.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
re_WORD_MEMO,
re_FIELD_SELECT,
re_FIELD_UPDATES
});
//
// gridView_List
//
gridView_.ColumnPanelRowHeight = 40;
gridView_.GridControl = grdCntrl_;
gridView_.Name = TARIFE_KODU;///_FIELD_NAME;
gridView_.OptionsView.ShowGroupPanel = false;
//gridView_.OptionsBehavior.Editable = false;
gridView_.OptionsView.ColumnAutoWidth = true;
gridView_.OptionsSelection.MultiSelect = true;
gridView_.RowHeight = 100;
gridView_.Columns["ALANLAR"].ColumnEdit = re_FIELD_SELECT;
gridView_.Columns["ALAN"].ColumnEdit = re_FIELD_UPDATES;
gridView_.Columns["KEYWORDS"].ColumnEdit = re_WORD_MEMO;
gridView_.Columns["ID"].Visible = false;
SECENEKLER_LIST(_GLOBAL_PARAMETRELER._RAPOR_KODU);
}
else
{
var rtb = xtraTabControl_WORD_MNG_DETAY.TabPages[TabCount].Controls[0];
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
SqlDataAdapter adapter = new SqlDataAdapter("SELECT ID,[ALANLAR] ,[KEYWORDS] ,[ALAN] ,[DEGER] FROM dbo.TRF_KEYWORD WHERE TARIFE_KODU='" + tmp._TARIFE_KODU + "' and SIRKET_KODU='" + _GLOBAL_PARAMETRELER._KULLANICI_FIRMA + "'", conn);
adapter.Fill(ds, "TRF_MASTER");
DataViewManager dvManager = new DataViewManager(ds);
DataView DW_LIST_TARIFE = dvManager.CreateDataView(ds.Tables[0]);
DevExpress.XtraGrid.GridControl grd_ = (DevExpress.XtraGrid.GridControl)rtb;
grd_.DataSource = DW_LIST_TARIFE;
for (int i = 0; i <= 5; i++)
{
DW_LIST_TARIFE.AddNew();
}
gridView_.Columns["ID"].Visible = false;
}
}
}
}
catch (Exception EX)
{ MessageBox.Show(EX.Data.ToString()); }
}
private void BTN_LISTE_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
TARIFELER._TARIFE_LISTESI TF = new TARIFELER._TARIFE_LISTESI("TARIFE", "GAZETE");
TF.ShowDialog();
lbFILE_NAME.Caption = TF._TARIFE_KODU;
lbID.Caption = TF._TARIFE_ID;
string STR_SECENEKLER_BIR = "", STR_SECENEKLER_IKI = "";
dv = null;
for (int i = 0; i <= gridView_SECENEKLER.Columns.Count - 1; i++)
{
gridView_SECENEKLER.Columns[i].Visible = false;
}
using (SqlConnection myConnection = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
string SQL = string.Format(" SELECT * FROM dbo.TRF_TARIFELER_LISTESI WHERE TARIFE_OWNER='{0}' and (SIRKET_KODU = N'{1}') AND (MECRA_TURU = N'GAZETE') and TARIFE_KODU='{2}'", _GLOBAL_PARAMETRELER._KULLANICI_MAIL, _GLOBAL_PARAMETRELER._KULLANICI_FIRMA, lbFILE_NAME.Caption);
SqlCommand myCommand = new SqlCommand(SQL, myConnection)
{
CommandText = SQL.ToString()
};
myConnection.Open();
SqlDataReader myReader = myCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
while (myReader.Read())
{
// Mecra Kodu Yayın Türü Hesap Türü BİRİM FİYAT/FAKTÖR Pzt Sal Çar Per Cum Cmt Paz +/- BAŞLANGIÇ TARİHİ BİTİŞ TARİHİ
if (myReader["GUNLUK_TARIFE"] == DBNull.Value || myReader["GUNLUK_TARIFE"].ToString() == "False")
{
STR_SECENEKLER_IKI = "BIRIM_FIYAT,";
GAZETE_TARIFE_TURU = "STANDART_TARIFE";
}
else
{
STR_SECENEKLER_IKI = "BIRIM_FIYAT,HI,";//SALI,CARSAMBA,PERSEMBE,CUMA,CUMARTESI,PAZAR, ";
GAZETE_TARIFE_TURU = "GUNLUK_TARIFE";
}
LBL_GAZETE_TARIFE_TURU.Text = myReader["SELECT_TYPE"].ToString();
if (myReader["SELECT_TYPE"].ToString() == "MECRA")
{
STR_SECENEKLER_BIR = "MECRA_KODU,HESAPLANMA_TURU,"; GAZETE_TARIFE_SECENEK = "MECRA";
}
if (myReader["SELECT_TYPE"].ToString() == "MECRA_SAYFA")
{
STR_SECENEKLER_BIR = "MECRA_KODU,SAYFA_GRUBU,HESAPLANMA_TURU,"; GAZETE_TARIFE_SECENEK = "MECRA_SAYFA";
}
if (myReader["SELECT_TYPE"].ToString() == "MECRA_SAYFA_YAYINTURU")
{
STR_SECENEKLER_BIR = "MECRA_KODU,SAYFA_GRUBU,YAYIN_TURU,HESAPLANMA_TURU,"; GAZETE_TARIFE_SECENEK = "MECRA_SAYFA_YAYINTURU";
}
}
string qury = String.Format("{0}{1}BASLANGIC_TARIHI,BITIS_TARIHI", STR_SECENEKLER_BIR, STR_SECENEKLER_IKI);
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(_GLOBAL_PARAMETRELER._CONNECTION_STRING.ToString()))
{
string querys = String.Format(" SELECT ID, {0} {1} BASLANGIC_TARIHI , BITIS_TARIHI FROM dbo.TRF_GAZETE where KULLANICI_KODU='" + _GLOBAL_PARAMETRELER._KULLANICI_MAIL + "' and SIRKET_KODU='" + _GLOBAL_PARAMETRELER._KULLANICI_FIRMA + "' and TARIFE_KODU='" + lbFILE_NAME.Caption + "'", STR_SECENEKLER_BIR, STR_SECENEKLER_IKI);
SqlDataAdapter adapter = new SqlDataAdapter()
{
SelectCommand = new SqlCommand(querys, conn)
};
adapter.Fill(ds, "TRF_GAZETE");
DataViewManager dvManager = new DataViewManager(ds);
dv = dvManager.CreateDataView(ds.Tables[0]);
}
gridControl_SECENEKLER.DataSource = dv;
gridView_SECENEKLER.RefreshData();
//string[] Onesz = qury.Split(',');
//for (int i = 0; i < Onesz.Length; i++)
//{
// gridView_SECENEKLER.Columns[Onesz[i].Trim()].VisibleIndex = i;
// gridView_SECENEKLER.Columns[Onesz[i].Trim()].Visible = true;
//}
}
}
