mealslist.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 MealsList : System.Web.UI.Page
{
    MealsStaffTableAdapters.Tbl_MealsStaffTableAdapter msta = new MealsStaffTableAdapters.Tbl_MealsStaffTableAdapter();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["userName"] == null)
            {
                Response.Redirect("Default.aspx");
            }
            else
            {
                ProcurementTableAdapters.Tbl_ProcurementTableAdapter pta = new ProcurementTableAdapters.Tbl_ProcurementTableAdapter();
                this.repeater.DataSource = pta.GetData();
                this.repeater.DataBind();
            }
        }
    }

    /// <summary>
    /// 绑定数据时触发
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void repeater_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        ///用餐人数
        ((Label)e.Item.FindControl("labpercount")).Text = msta.ScalarQuery(Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "ProId"))).ToString();

        ///账单详细
        DataTable dt = msta.GetDataByProId(Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "ProId")));
        string labxx = "";
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            labxx = labxx + dt.Rows[i]["AName"].ToString() + "：" + Math.Round(Convert.ToDouble(dt.Rows[i]["MMoney"]), 2) + "元&nbsp;&nbsp;&nbsp;&nbsp;";
        }
        ((Label)e.Item.FindControl("labxx")).Text = labxx;
    }
}