站内搜索：

ASP.NET票据管理中心(11)

来源：xiaoniu168.com 作者：本站原创添加时间：2011-12-12 点击数：27738

以下是引用片段：

A票据购买申请
// 购买申请
//单位名称、票据种类、购买数量等信息不能为空
        if (this.ddlGMDW.SelectedValue == "")
        {
            ResponseMessage(this, "请选择购买单位！");
            return;
        }
       ……
        int GMUNITID = int.Parse(this.ddlGMDW.SelectedValue);
        int GMITEMID = int.Parse(this.ddlSFXM.SelectedValue);
        string BILLZL = this.ddlBILLTYPE.SelectedValue;
        string GMFS = this.ddGMFS.SelectedValue;
        int GMNUM = int.Parse(this.txtGMNUM.Text);
        string GMZT = this.ddlGMZT.SelectedValue;
        T_BILL_GM model = new T_BILL_GM();
        model.GMUNITID = GMUNITID;
        model.GMITEMID = GMITEMID;
        model.BILLZL = BILLZL;
        model.GMNUM = GMNUM;
        model.GMLX = GMFS;
        model.GMZT = GMZT;
        Response.Redirect("GMGL.aspx");
B票据购买申请管理
//导入excel表格
        Response.Clear();
        Response.= "gb2312";
        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
gvData.AllowPaging = false;
        BindResult();
        gvData.htmlWrite)
        Response.
        gvData.AllowPaging = true;
        BindResult();
//申请记录查询显示
private void BindResult()
    {
   //组合查询条件
        string strSqlWhere = string.Empty;
        if (this.ddlCXLX.SelectedValue.Trim() != "全部")
        {
            if (this.txtCXNR.Text != "")
            {
                strSqlWhere += " and " + this.ddlCXLX.SelectedValue.Trim() + " like '%" + this.txtCXNR.Text.Trim() + "%'";
            }
        }
        T_BILL_GM modelList = new T_BILL_GM();
        DataTable dt = modelList.GetVList(strSqlWhere).Tables[0];
        if (dt != null)
        {
            this.gvData.DataKeyNames = new string[] { "BILLGMID", "DWCODE", "XMID" };
            this.gvData.DataSource = dt;
            this.gvData.DataBind();
            ShowStats(dt.Rows.Count.ToString());
        }