C# (CSharp) Gridview_OAInfo示例

示例#1

    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["Time1"] == null || Request.QueryString["Time1"] == "")
        {
            Labelstart.Text = "始";
        }
        else
        {
            Labelstart.Text = Request.QueryString["Time1"];
        }
        if (Request.QueryString["Time2"] == null || Request.QueryString["Time2"] == "")
        {
            Labelend.Text = "今";
        }
        else
        {
            Labelend.Text = Request.QueryString["Time2"];
        }
        string condition = Request.QueryString["Getcondition()"];

        Gridview_OAInfo.DataSource = cd.SelectCRMCompanySampleCount(condition);
        Gridview_OAInfo.DataBind();
    }

示例#2

文件： PRMProject_IsFinishPrint.aspx.cs 项目： qimengcheng/xi

    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["ProjectPlTime1"] == null || Request.QueryString["ProjectPlTime1"] == "")
        {
            Labelstart.Text = "始";
        }
        else
        {
            Labelstart.Text = Request.QueryString["ProjectPlTime1"];
        }
        if (Request.QueryString["ProjectPlTime2"] == null || Request.QueryString["ProjectPlTime2"] == "")
        {
            Labelend.Text = "今";
        }
        else
        {
            Labelend.Text = Request.QueryString["ProjectPlTime2"];
        }
        string condition = Request.QueryString["Getcondition()"];

        Gridview_OAInfo.DataSource = pd.SelectPRMProject_IsFinish(condition);
        Gridview_OAInfo.DataBind();
        label_Title.Text = "共" + Gridview_OAInfo.Rows.Count + "个项目";
    }

示例#3

文件： PMPurchaseApplyMaterial_NumPrint.aspx.cs 项目： qimengcheng/xi

    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["PMPAM_ApplyTime1"] == null || Request.QueryString["PMPAM_ApplyTime1"] == "")
        {
            Labelstart.Text = "始";
        }
        else
        {
            Labelstart.Text = Request.QueryString["PMPAM_ApplyTime1"];
        }
        if (Request.QueryString["PMPAM_ApplyTime2"] == null || Request.QueryString["PMPAM_ApplyTime2"] == "")
        {
            Labelend.Text = "今";
        }
        else
        {
            Labelend.Text = Request.QueryString["PMPAM_ApplyTime2"];
        }
        string IMMBD_MaterialName       = Request.QueryString["IMMBD_MaterialName"];
        string PMPAM_ApplyTime1         = Request.QueryString["PMPAM_ApplyTime1"];
        string PMPAM_ApplyTime2         = Request.QueryString["PMPAM_ApplyTime2"];
        string IMMBD_SpecificationModel = Request.QueryString["IMMBD_SpecificationModel"];
        string IMMT_MaterialType        = Request.QueryString["IMMT_MaterialType"];
        string PMPAM_Department         = Request.QueryString["PMPAM_Department"];
        string condition = "";

        if (IMMBD_MaterialName != "")
        {
            condition += "and IMMaterialBasicData.IMMBD_MaterialName like'%" + IMMBD_MaterialName + "%'";
        }
        if (PMPAM_ApplyTime1 != "")
        {
            if (PMPAM_ApplyTime2 != "")
            {
                condition += "and PMPAM_ApplyTime >='" + Convert.ToDateTime(PMPAM_ApplyTime1) + "'" + "and PMPAM_ApplyTime<='" + Convert.ToDateTime(PMPAM_ApplyTime2) + "'";
            }
            else
            {
                condition += "and PMPAM_ApplyTime >='" + Convert.ToDateTime(PMPAM_ApplyTime1) + "'";
            }
        }

        if (IMMBD_SpecificationModel != "")
        {
            condition += "and IMMaterialBasicData.IMMBD_SpecificationModel='" + IMMBD_SpecificationModel + "'";
        }
        if (PMPAM_Department != "" && PMPAM_Department != null)
        {
            condition += "and PMPAM_Department='" + PMPAM_Department + "'";
        }
        if (IMMT_MaterialType != "")
        {
            condition += "and (" + IMMT_MaterialType + ")";
        }
        Gridview_OAInfo.DataSource = pd.SelectPMPurchaseApplyMaterial_Department(condition);
        Gridview_OAInfo.DataBind();
    }

示例#4

文件： SalesMonthPlanFinisihPrint.aspx.cs 项目： qimengcheng/xi

    protected void Page_Load(object sender, EventArgs e)
    {
        Labelpeople.Text = Session["UserName"].ToString();
        Labeltime.Text   = DateTime.Now.ToString("yyyy-MM-dd HH:mm");

        string year  = Request.QueryString["year"];
        string month = Request.QueryString["month"];

        Gridview_OAInfo.DataSource = sd.SelectSalesMonthPlanFinisih(year, month);
        Gridview_OAInfo.DataBind();
    }

示例#5

    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["PMPAM_ApplyTime1"] == null || Request.QueryString["PMPAM_ApplyTime1"] == "")
        {
            Labelstart.Text = "始";
        }
        else
        {
            Labelstart.Text = Request.QueryString["PMPAM_ApplyTime1"];
        }
        if (Request.QueryString["PMPAM_ApplyTime2"] == null || Request.QueryString["PMPAM_ApplyTime2"] == "")
        {
            Labelend.Text = "今";
        }
        else
        {
            Labelend.Text = Request.QueryString["PMPAM_ApplyTime2"];
        }
        string PMPAM_ApplyTime1 = Request.QueryString["PMPAM_ApplyTime1"];
        string PMPAM_ApplyTime2 = Request.QueryString["PMPAM_ApplyTime2"];
        string condition        = "";

        if (PMPAM_ApplyTime1 != "" && PMPAM_ApplyTime2 == "")
        {
            condition += "and PMPAM_ApplyTime >='" + PMPAM_ApplyTime1 + "'";
        }
        if (PMPAM_ApplyTime1 == "" && PMPAM_ApplyTime2 != "")
        {
            condition += "and PMPAM_ApplyTime <='" + PMPAM_ApplyTime2 + "'";
        }
        if (PMPAM_ApplyTime1 != "" && PMPAM_ApplyTime2 != "")
        {
            condition += "and PMPAM_ApplyTime >='" + PMPAM_ApplyTime1 + "'" + "and PMPAM_ApplyTime <='" + PMPAM_ApplyTime2 + "'";
        }
        Gridview_OAInfo.DataSource = od.SelectOfficeAppliance(condition);
        Gridview_OAInfo.DataBind();
    }

示例#6

 private void BindGridview_OAInfo(string condition)
 {
     Gridview_OAInfo.DataSource = pd.SelectPRMProject_IsFinish(condition);
     Gridview_OAInfo.DataBind();
 }

示例#7

 private void BindGridview_OAInfo(string condition)
 {
     Gridview_OAInfo.DataSource = od.SelectOfficeAppliance(condition);
     Gridview_OAInfo.DataBind();
 }

示例#8

文件： PMPurchaseApplyMaterial_Num.aspx.cs 项目： qimengcheng/xi

 private void BindGridview_OAInfo(string condition)
 {
     Gridview_OAInfo.DataSource = pd.SelectPMPurchaseApplyMaterial_Department(condition);
     Gridview_OAInfo.DataBind();
 }

示例#9

文件： CRMCompanySampleCount.aspx.cs 项目： qimengcheng/xi

 private void BindGridview_OAInfo(string condition)
 {
     Gridview_OAInfo.DataSource = cd.SelectCRMCompanySampleCount(condition);
     Gridview_OAInfo.DataBind();
 }

示例#10

 private void BindGridview_OAInfo(string year, string month)
 {
     Gridview_OAInfo.DataSource = sd.SelectSalesMonthPlanFinisih(year, month);
     Gridview_OAInfo.DataBind();
 }