//发货计划表
protected void GridView_OrderDeliverPlan_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView theGrid = sender as GridView; // refer to the GridView
int newPageIndex = 0;
if (-2 == e.NewPageIndex)
{
TextBox txtNewPageIndex = null;
GridViewRow pagerRow = GridView_OrderDeliverPlan.BottomPagerRow;
if (null != pagerRow)
{
txtNewPageIndex = (TextBox)pagerRow.FindControl("textbox"); // refer to the TextBox with the NewPageIndex value
}
if (null != txtNewPageIndex && txtNewPageIndex.Text != "")
{
newPageIndex = int.Parse(txtNewPageIndex.Text) - 1; // get the NewPageIndex
}
}
else
{
newPageIndex = e.NewPageIndex;
}
BindDeliverPlan();
newPageIndex = newPageIndex < 0 ? 0 : newPageIndex;
newPageIndex = newPageIndex >= GridView_OrderDeliverPlan.PageCount ? GridView_OrderDeliverPlan.PageCount - 1 : newPageIndex;
GridView_OrderDeliverPlan.PageIndex = newPageIndex;
GridView_OrderDeliverPlan.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
if (Request.QueryString["start"] == null || Request.QueryString["start"] == "")
{
Labelstart.Text = "始";
}
else
{
Labelstart.Text = Request.QueryString["start"];
}
if (Request.QueryString["end"] == null || Request.QueryString["end"] == "")
{
Labelend.Text = "今";
}
else
{
Labelend.Text = Request.QueryString["end"];
}
//绑定
string condition = Request.QueryString["condition"];
GridView_OrderDeliverPlan.DataSource = mc.Select_MCA(condition);
GridView_OrderDeliverPlan.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//绑定
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = System.DateTime.Now.ToShortDateString();
int sort = Convert.ToInt32(Request.QueryString["sort"]);
string condition = Request.QueryString["condition"];
GridView_OrderDeliverPlan.DataSource = dp.Select_HRMan("", sort);
GridView_OrderDeliverPlan.DataBind();
}
//发货计划检索
protected void SearchDeliverPlan(object sender, EventArgs e)
{
string condition = "";
if (Label5.Text == "")
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "alert", "alert('请选择一种检索方式！')", true);
return;
}
else
{
int sort = Convert.ToInt32(Label5.Text);
GridView_OrderDeliverPlan.DataSource = dp.Select_HRMan(condition, sort);
GridView_OrderDeliverPlan.DataBind();
UpdatePanel_OrderDeliverPlan.Update();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Labelpeople.Text = Session["UserName"].ToString();
Labeltime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
if (Request.QueryString["startime"] == null || Request.QueryString["startime"] == "")
{
Labelstart.Text = "始";
}
else
{
Labelstart.Text = Request.QueryString["startime"];
}
if (Request.QueryString["endtime"] == null || Request.QueryString["endtime"] == "")
{
Labelend.Text = "今";
}
else
{
Labelend.Text = Request.QueryString["endtime"];
}
//绑定
string startime = Request.QueryString["startime"];
string endtime = Request.QueryString["endtime"];
string print = Request.QueryString["print"];
if (print == "printY")
{
GridView_OrderDeliverPlan.Columns[11].Visible = true;
}
else
{
GridView_OrderDeliverPlan.Columns[11].Visible = false;
}
Labelstart.Text = startime;
Labelend.Text = endtime;
GridView_OrderDeliverPlan.DataSource = dp.Select_DeliverPlan("and a.SMDP_Time between '" + startime + "' and '" + endtime + "'");
GridView_OrderDeliverPlan.DataBind();
}
protected void ExcelOutput(object sender, EventArgs e)
{
GridView_OrderDeliverPlan.AllowPaging = false;
GridView_OrderDeliverPlan.DataBind();
ExcelHelper.GridViewToExcel(GridView_OrderDeliverPlan, "机械维护加工申请统计表");
}
//绑定发货表
protected void BindDeliverPlan()
{
GridView_OrderDeliverPlan.DataSource = dp.Select_DeliverPlan(Label5.Text.ToString().Trim());
GridView_OrderDeliverPlan.DataBind();
UpdatePanel_OrderDeliverPlan.Update();
}
