Exemplo n.º 1
0
 /// <summary>
 /// 展示数据
 /// </summary>
 /// <param name="id">记录Id</param>
 private void ShowInfo(int id)
 {
     LCustTagBB custTagBB = new LCustTagBB();
     vLCustTagData model = new vLCustTagData();
     try
     {
         model = custTagBB.GetVModel(id);
         this.id.Text = model.id.ToString();
         this.custNo.Text = model.custNo;
         this.materialNo.Text = model.materialNo;
         this.bigTagFileId.Text = model.bigTagFileId.ToString();
         this.smallTagFileId.Text = model.smallTagFileId.ToString();
     }
     finally
     {
         custTagBB.Dispose();
     }
 }
Exemplo n.º 2
0
    /// <summary>
    /// 绑定Grid
    /// </summary>
    protected void BindGrid()
    {
        LCustTagBB custTagBB = new LCustTagBB();
        DataSet ds = new DataSet();

        try
        {
            string strwhere = this.StrWhere;
            if (!string.IsNullOrEmpty(txtMaterialNo.Text))
            {
                strwhere += "  and  materialNo like '%" + txtMaterialNo.Text + "%'";
            }
            if (!string.IsNullOrEmpty(txtMaterialNo.Text))
            {
                strwhere += "  and  materialDesc like '%" + txtMaterialNm.Text + "%'";
            }
            if (!string.IsNullOrEmpty(txtCustNo.Text))
            {
                strwhere += "  and  custNo like '%" + txtCustNo.Text + "%'";
            }
            if (!string.IsNullOrEmpty(txtCustNm.Text))
            {
                strwhere += "  and  custNm like '%" + txtCustNm.Text + "%'";
            }

            ds = custTagBB.GetVList(strwhere);
            this.grid.DataSource = ds.Tables[0];
            this.grid.DataBind();
            //赋值记录条数、页面总数
            this.Label3.Text = ds.Tables[0].Rows.Count.ToString();
            this.Label2.Text = this.grid.PageCount.ToString();
            this.currPage.Text = (this.grid.PageIndex + 1).ToString();
        }
        finally
        {
            custTagBB.Dispose();
        }
    }
Exemplo n.º 3
0
    /// <summary>
    /// 数据保存
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnSave_Click(object sender, EventArgs e)
    {
        LCustTagData model = new LCustTagData();
        LCustTagBB custTagBB = new LCustTagBB();

        try
        {
            if (this.State == "1")
            {
                this.SetModel(ref model);
                model.isrtDt = DateTime.Now.ToString();
                model.isrtEmpId = this.currentUser.empId;
                model.smallTagSql = this.smallSQL.Text.ToString();
                model.bigTagSql = this.bigSQL.Text.ToString();
                this.IdValue = custTagBB.AddRecord(model);
                this.State = "1";
            }
            else if (this.State == "2")
            {
                model = custTagBB.GetModel(this.IdValue);
                this.SetModel(ref model);
                model.updtDt = DateTime.Now.ToString();
                model.updtEmpId = this.currentUser.empId;
                model.smallTagSql = this.smallSQL.Text.ToString();
                model.bigTagSql = this.bigSQL.Text.ToString();
                custTagBB.ModifyRecord(model);
            }
        }
        catch (Exception ex)
        {
            this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true);
            return;
        }
        finally
        {
            custTagBB.Dispose();
        }

        Response.Redirect("LCustTagList.aspx?&itemno=" + this.itemNo + "&pTypeNo=main", false);
    }
Exemplo n.º 4
0
    /// <summary>
    /// 展示数据
    /// </summary>
    /// <param name="id">记录Id</param>
    private void ShowInfo(int id)
    {
        LCustTagBB custTagBB = new LCustTagBB();
        vLCustTagData model = new vLCustTagData();
        SFileBB fileBB = new SFileBB();

        try
        {
            model = custTagBB.GetVModel(id);

            this.hidCustNo.Value = model.custNo;
            this.hidMaterialNo.Value = model.materialNo;
            this.bigSQL.Text = model.bigTagSql;
            this.smallSQL.Text = model.smallTagSql;
            SFileData smdtata = fileBB.GetModel(model.smallTagFileId);

            if (smdtata != null)
            {
                this.smallfileNm.InnerHtml = "<a href='" + smdtata.absolutPath + smdtata.preFileNm + "' >" + smdtata.preFileNm + "</a>";
            }

            SFileData bgdata = fileBB.GetModel(model.bigTagFileId);

            if (bgdata != null)
            {
                this.bigfileNm.InnerHtml = "<a href='" + bgdata.absolutPath + bgdata.preFileNm + "' >" + bgdata.preFileNm + "</a>";
            }

            this.custNm.Text = model.custNm;
            this.materialNm.Text = model.materialDesc;
            this.bigTagFileId.Value = model.bigTagFileId.ToString();
            this.smallTagFileId.Value = model.smallTagFileId.ToString();
            this.tbEachPrintBigTagNum.Text = model.eachPrintBigTagNum.ToString();
            this.tbEachPrintSmallTagNum.Text = model.eachPrintSmallTagNum.ToString();
            this.tbUnit.Text = model.unit;
            this.tbUnits.Text = model.units;
        }
        finally
        {
            custTagBB.Dispose();
            fileBB.Dispose();
        }
    }
Exemplo n.º 5
0
    /// <summary>
    /// 删除
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnDel_Click(object sender, EventArgs e)
    {
        bool retChecked = false;
        LCustTagBB custTagBB = new LCustTagBB();
        try
        {
            //获取选中的数据Id
            foreach (GridViewRow gvrow in this.grid.Rows)
            {
                CheckBox chkId = (CheckBox)gvrow.FindControl("chkId");
                if (chkId.Checked == true)
                {
                    retChecked = true;
                    int id = int.Parse(chkId.ValidationGroup);
                    custTagBB.DeleteRecord(id);
                }
            }
        }
        catch (Exception ex)
        {
            this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true);
            return;
        }
        finally
        {
            custTagBB.Dispose();
        }

        if (retChecked)
        {
            this.BindGrid();
        }
    }