mealsprint.aspx.cs

餐饮系统的各个功能

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class MealsPrint : System.Web.UI.Page
{
    MealsStaffTableAdapters.pro_sqlTableAdapter prosql = new MealsStaffTableAdapters.pro_sqlTableAdapter();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["userName"] == null)
            {
                Response.Redirect("Default.aspx");
            }
            else
            {
                DateTime now = DateTime.Now;
                if (DateTime.Now.Day > 10)
                {
                    this.txbdate.Text = now.Year.ToString() + "-" + now.Month.ToString() + "-10";
                }
                else
                {
                    if (now.Month != 1)
                    {
                        this.txbdate.Text = now.Year.ToString() + "-" + ((now.Month) - 1).ToString() + "-10";
                    }
                    else
                    {
                        this.txbdate.Text = ((now.Year)-1).ToString() + "-" + "12-10";
                    }
                }
                this.txbdate2.Text = now.ToString("yyyy-M-d");
                txbdate.Attributes.Add("readonly", "readonly");
                txbdate2.Attributes.Add("readonly", "readonly");
                this.BindToRepeater();
            }
        }
    }


    /// <summary>
    /// 绑定
    /// </summary>
    protected void BindToRepeater()
    {
        //string sql = "select distinct AName from view_ProMeals group by AName,ProDate having (ProDate >= '" + this.txbdate.Text + "' and ProDate <= '" + this.txbdate2.Text + "')";
        string sql = "select * from Tbl_AdminUser";
        this.repeater.DataSource = prosql.GetData(sql);
        this.repeater.DataBind();
    }


    /// <summary>
    /// 统计
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        this.BindToRepeater();
    }


    /// <summary>
    /// 绑定数据时触发
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void repeater_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        ///绑定到用餐次数
        string sql = "select count(*) from view_ProMeals where (ProDate >= '" + this.txbdate.Text + "' and ProDate <= '" + this.txbdate2.Text + "') and AName='" + DataBinder.Eval(e.Item.DataItem, "AName") + "'";
        ((Label)e.Item.FindControl("labmecounts")).Text = prosql.GetData(sql).Rows[0][0].ToString();

        ///绑定到时间
        ((Label)e.Item.FindControl("labtimes")).Text = this.txbdate.Text + "&nbsp;至&nbsp;" + this.txbdate2.Text;

        ///绑定到帐款
        if (prosql.GetData(sql).Rows[0][0].ToString() != "0")
        {
            sql = "select sum(MMoney) from view_ProMeals where (ProDate >= '" + this.txbdate.Text + "' and ProDate <= '" + this.txbdate2.Text + "') and AName='" + DataBinder.Eval(e.Item.DataItem, "AName") + "'";
            if (Convert.ToDouble(prosql.GetData(sql).Rows[0][0].ToString()) <= 0)
            {
                ((Label)e.Item.FindControl("labmoneys")).Text = (Math.Round(Convert.ToDouble(prosql.GetData(sql).Rows[0][0]), 2)).ToString();
            }
            else
            {
                ((Label)e.Item.FindControl("labmoneys")).Text = "<font color='blue'>" +  Math.Round(Convert.ToDouble(prosql.GetData(sql).Rows[0][0]), 2) + "</font>";
            }
        }
        else
        {
            ((Label)e.Item.FindControl("labmoneys")).Text = "<font color='#000000'>0</font>";
        }
    }
}