void BugununMenusunuGetir()
{
int LabelSayac = 0;
int PnSayac = 0;
DateTime dt = DateTime.Now;
for (int i = 0; i < 7; i++)
{
SqlDataReader rdYemek = islem.BugununMenusunuGetir(dt);
if (rdYemek == null)
{
return;
}
if (rdYemek.HasRows)
{
int yp = 9;
Panel pnl = new Panel();
pnl.Name = "pnl" + PnSayac.ToString();
pnl.Location = new Point(9, 65);
pnl.BorderStyle = BorderStyle.FixedSingle;
pnl.Size = new System.Drawing.Size(300, 300);
Label lblTarih = new Label();
int y = 20;
lblTarih.Name = "lbl" + LabelSayac.ToString();
lblTarih.Location = new Point(20, y);
lblTarih.AutoSize = true;
lblTarih.ForeColor = Color.Red;
lblTarih.Font = new Font("Georgia", 14, FontStyle.Bold);
lblTarih.Text = dt.ToShortDateString() + "tarihli menu";
pnl.Controls.Add(lblTarih);
int c = 0;
int y1 = 50;
while (rdYemek.Read())
{
Label lblYemek = new Label();
lblYemek.Name = "lbl" + "_" + rdYemek[4].ToString();
lblYemek.Location = new Point(10, y1);
lblYemek.AutoSize = true;
lblYemek.Font = new Font("Georgia", 10);
lblYemek.Click += lblYemek_Click;
lblYemek.Text = rdYemek[5].ToString();
pnl.Controls.Add(lblTarih);
pnl.Controls.Add(lblYemek);
y1 += 20;
}
flwAl(pnl);
}
else
{
Label lblTarih = new Label();
int y = 500;
lblTarih.Name = "lbl" + LabelSayac.ToString();
lblTarih.AutoSize = true;
lblTarih.ForeColor = Color.Red;
lblTarih.Font = new Font("Georgia", 14, FontStyle.Bold);
lblTarih.Text = dt.ToShortDateString() + "tarihli menu";
int yp = 9;
Panel pnl = new Panel();
pnl.Name = "pnl" + PnSayac.ToString();
pnl.AutoSize = true;
pnl.BorderStyle = BorderStyle.FixedSingle;
pnl.Size = new System.Drawing.Size(200, 200);
// yp += 260;
Label lblKategori = new Label();
lblKategori.Name = "lbl" + LabelSayac.ToString();
lblKategori.Location = new Point(10, 30);
lblKategori.AutoSize = true;
lblKategori.Font = new Font("Georgia", 10);
lblKategori.Text = "Bu tarihte menu oluşturulmamıştır.";
y += 20;
pnl.Controls.Add(lblTarih);
pnl.Controls.Add(lblKategori);
flwAl(pnl);
}
dt = dt.AddDays(1);
LabelSayac++;
PnSayac++;
}
}
private void btnAktar_Click(object sender, EventArgs e)
{
Excel.Application excel = new Excel.Application();
excel.Visible = true;
object Missing = Type.Missing;
Workbook workbook = excel.Workbooks.Add(Missing);
Worksheet sheet1 = (Worksheet)workbook.Sheets[1];
sheet1.PageSetup.PrintGridlines = true;
DateTime dtbas = Convert.ToDateTime(dtpBaslangic.Value);
DateTime dtbitis = Convert.ToDateTime(dtpBitis.Value);
int deger = 0;
bool durum = false;
Microsoft.Office.Interop.Excel.Range myRangex = (Range)sheet1.Cells[1, 4];
myRangex.Font.Bold = 1;
myRangex.Font.Size = 24;
myRangex.Value2 = "İnfak Yemekçilik-IESU";
myRangex.HorizontalAlignment = HorizontalAlignment.Center;
sheet1.get_Range("B1:E1", Type.Missing).Merge(Type.Missing);
excel.Cells[1, 4].ColumnWidth = 20;
Microsoft.Office.Interop.Excel.Range myRangetarih = (Range)sheet1.Cells[3, 4];
myRangetarih.Value2 = "Tarih" + ": " + DateTime.Now.ToShortDateString();
myRangetarih.Font.Bold = 0;
excel.Cells[3, 4].ColumnWidth = 20;
myRangetarih.Font.Size = 12;
int TarihSayacSatir = 5;
int TArihSayacSutun = 2;
int BaslikSayacSatir = 7;
int BaslikSayacSutun = 1;
int VeriSatir = 8;
int VeriSutun = 1;
int sayac = 1;
TArihSayacSutun = 2;
do
{
SqlDataReader rd = islem.BugununMenusunuGetir(dtbas);
if (rd.HasRows)
{
Range myRangeKalori1 = (Range)sheet1.Cells[TarihSayacSatir, TArihSayacSutun];
myRangeKalori1.Value2 = "Menu Tarihi";
excel.Cells[TarihSayacSatir, TArihSayacSutun].ColumnWidth = 20;
myRangeKalori1.Select();
TArihSayacSutun++;
Range myRangeKt = (Range)sheet1.Cells[TarihSayacSatir, TArihSayacSutun];
excel.Cells[TarihSayacSatir, TArihSayacSutun].ColumnWidth = 20;
myRangeKt.Value2 = dtbas.ToShortDateString();
myRangeKt.Select();
TArihSayacSutun = 2;
string[] baslik = { "No", "Yemek Adi", "Çeşiti", "Kalori" };
for (int x = 0; x < 4; x++)
{
Microsoft.Office.Interop.Excel.Range myRange = (Range)sheet1.Cells[BaslikSayacSatir, BaslikSayacSutun];
myRange.Value2 = baslik[x];
excel.Cells[BaslikSayacSatir, BaslikSayacSutun].ColumnWidth = 20;
myRange.Font.Size = 12;
myRange.Font.Bold = 1;
excel.Cells[BaslikSayacSatir, BaslikSayacSutun].Interior.Color = System.Drawing.Color.Yellow;
BaslikSayacSutun++;
}
BaslikSayacSutun = 1;
while (rd.Read())
{
Range myRangeid = (Range)sheet1.Cells[VeriSatir, VeriSutun];
myRangeid.Value2 = sayac.ToString();
myRangeid.Select();
VeriSutun++;
sayac++;
Range myRange1 = (Range)sheet1.Cells[VeriSatir, VeriSutun];
myRange1.Value2 = rd[5].ToString();
myRange1.Select();
VeriSutun++;
Range myRangeKategori = (Range)sheet1.Cells[VeriSatir, VeriSutun];
myRangeKategori.Value2 = rd["kategori_adi"].ToString();
myRangeKategori.Select();
VeriSutun++;
Range myRangeKalori = (Range)sheet1.Cells[VeriSatir, VeriSutun];
myRangeKalori.Value2 = rd[6].ToString();
myRangeKalori.Select();
VeriSutun = 1;
VeriSatir++;
}
TarihSayacSatir = VeriSatir + 2;
BaslikSayacSatir = VeriSatir + 4;
VeriSatir = BaslikSayacSatir + 1;
}
else
{
}
dtbas = Convert.ToDateTime(dtbas.AddDays(1).ToShortDateString());
c = DateTime.Compare(dtbas, dtbitis);
} while (c < 0);
}
