dispatchhismain.aspx.cs

asp销售管理系统

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;
using System.Data.SqlClient;

public partial class outbound_dispatchHisMain : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BeginDateTextBox.Text = DateTime.Now.AddDays(-DateTime.Now.Day + 1).ToShortDateString();
            EndDateTextBox.Text = DateTime.Now.ToShortDateString();
            Calendar2.TextBoxId = BeginDateTextBox.ClientID;
            Calendar3.TextBoxId = EndDateTextBox.ClientID;

            SqlDataSource4.SelectParameters["EndDate"].DefaultValue = EndDateTextBox.Text;
            SqlDataSource4.SelectParameters["BeginDate"].DefaultValue = BeginDateTextBox.Text;

            SqlDataSource4.FilterExpression = "";

        }
    }

    /// <summary>
    /// 设置格式
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView3_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        /*if (e.Row.RowType == DataControlRowType.Header)
        {
            for (int i = 0; i < 6; i++)
                e.Row.Cells[i].CssClass = "locked";
        }
        if (e.Row.RowType == DataControlRowType.Footer)
        {
            for (int i = 0; i < 6; i++)
                e.Row.Cells[i].CssClass = "locked";
        }*/
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            //for (int i = 0; i < 6; i++)
            //    e.Row.Cells[i].CssClass = "locked";
            e.Row.Cells[0].HorizontalAlign = HorizontalAlign.Center;
            e.Row.Cells[1].HorizontalAlign = HorizontalAlign.Center;
            e.Row.Cells[9].HorizontalAlign = HorizontalAlign.Center;
            e.Row.Cells[10].HorizontalAlign = HorizontalAlign.Center;
            e.Row.Cells[12].HorizontalAlign = HorizontalAlign.Center;
            DataRowView rowView = (DataRowView)e.Row.DataItem;
            bool state = Convert.ToBoolean(rowView["IsReviewed"]);
            ((LinkButton)e.Row.FindControl("btnUpdate")).Visible = !state;
            ((LinkButton)e.Row.FindControl("btnDelete")).Visible = !state;
            bool stateModify = Convert.ToBoolean(rowView["IsAccepted"]);
            ((LinkButton)e.Row.FindControl("btnModify")).Visible = !stateModify & state;
        }

    }

    protected void GridView3_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        SqlDataSource4.UpdateParameters["ReviewerID"].DefaultValue = this.User.Identity.Name;
    }

    protected void GridView3_RowUpdated(object sender, GridViewUpdatedEventArgs e)
    {
        RedirectDetail("window.parent.detail.location.href");
    }

    protected void GridView3_RowDeleted(object sender, GridViewDeletedEventArgs e)
    {
        RedirectDetail("'dispatchHisDetail.aspx'");
    }

    private void RedirectDetail(string href)
    {
        // Get a ClientScriptManager reference from the Page class.
        ClientScriptManager cs = Page.ClientScript;
        Type cstype = this.GetType();
        String csname = "refreshDetail";

        // Check to see if the startup script is already registered.
        if (!cs.IsStartupScriptRegistered(cstype, csname))
        {
            String cstext = "window.parent.detail.location.href=" + href +";";
            cs.RegisterStartupScript(cstype, csname, cstext, true);
        }
    }

    protected void btnRefresh_Click(object sender, EventArgs e)
    {
        SqlDataSource4.SelectParameters["EndDate"].DefaultValue = EndDateTextBox.Text;
        SqlDataSource4.SelectParameters["BeginDate"].DefaultValue = BeginDateTextBox.Text;

        if (DropDownList1.SelectedValue != "0")
        {
            SqlDataSource4.FilterParameters["WareHouseName"].DefaultValue = DropDownList1.SelectedItem.Text.Replace("|- ","");
            SqlDataSource4.FilterExpression = "WareHouseName='{0}'";
        }
        else
        {
            SqlDataSource4.FilterParameters["WareHouseName"].DefaultValue = "";
            SqlDataSource4.FilterExpression = "WareHouseName LIKE '{0}'+ '%'";
        }
    }

    protected void btnModify_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MySqlProviderConnection"].ConnectionString);
        string strQuery = "Update DeliveryMain Set IsReviewed=0,ReviewerID='' Where DeliveryID=" + GridView3.DataKeys[((GridViewRow)((LinkButton)sender).Parent.Parent).DataItemIndex].Value;

        SqlCommand command = new SqlCommand(strQuery, con);
        con.Open();
        command.ExecuteNonQuery();

        GridView3.DataBind();
        RedirectDetail("window.parent.detail.location.href");
    }
}