protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            ZWL.Common.PublicMethod.CheckSession();
            ZWL.BLL.ERPContractChanPin Model = new ZWL.BLL.ERPContractChanPin();
            Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
            this.lblHeTongName.Text  = Model.HeTongName.ToString();
            this.lblChanPinName.Text = Model.ChanPinName.ToString();
            this.lblDanJia.Text      = Model.DanJia.ToString();
            this.lblShuLiang.Text    = Model.ShuLiang.ToString();
            this.lblZongJia.Text     = Model.ZongJia.ToString();
            this.lblYiFuKuan.Text    = Model.YiFuKuan.ToString();
            this.lblQianKuanShu.Text = Model.QianKuanShu.ToString();
            this.lblIFJiaoFu.Text    = Model.IFJiaoFu.ToString();
            this.lblUserName.Text    = Model.UserName.ToString();
            this.lblTimeStr.Text     = Model.TimeStr.ToString();
            this.lblBackInfo.Text    = Model.BackInfo.ToString();

            //写系统日志
            ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
            MyRiZhi.UserName    = ZWL.Common.PublicMethod.GetSessionValue("UserName");
            MyRiZhi.DoSomething = "用户查看订单产品信息(" + this.lblHeTongName.Text + ")";
            MyRiZhi.IpStr       = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
            MyRiZhi.Add();
        }
    }
Beispiel #2
0
    public void DataBindToGridview()
    {
        ZWL.BLL.ERPContractChanPin MyModel = new ZWL.BLL.ERPContractChanPin();
        string XiaShuUser = ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 XiaShuUser from ERPUser where UserName='******'");
        string SSTempSTR  = "";

        if (XiaShuUser != "全部")
        {
            SSTempSTR = "and UserName in(" + "'" + XiaShuUser.Replace(",", "','") + "'" + ")";
        }
        string sql = "";

        if (!string.IsNullOrEmpty(this.TextBox1.Text))
        {
            sql += "(HeTongName Like '%" + this.TextBox1.Text + "%' or ChanPinName Like '%" + this.TextBox1.Text + "%' or DanJia Like '%" + this.TextBox1.Text + "%' or ShuLiang Like '%" + this.TextBox1.Text + "%' or UserName Like '%" + this.TextBox1.Text + "%' or IFJiaoFu Like '%" + this.TextBox1.Text + "%')";
        }
        if (!string.IsNullOrEmpty(this.TextBox3.Text))
        {
            if (string.IsNullOrEmpty(sql))
            {
                sql += " TimeStr >='" + this.TextBox3.Text.Trim() + " 00:00:00' and TimeStr<='" + this.TextBox4.Text.Trim() + " 23:59:59' ";
            }
            else
            {
                sql += "and TimeStr >='" + this.TextBox3.Text.Trim() + " 00:00:00' and TimeStr<='" + this.TextBox4.Text.Trim() + " 23:59:59' ";
            }
            sql += " " + SSTempSTR + "  order by ID desc";
        }
        GVData.DataSource = MyModel.GetList(sql);
        GVData.DataBind();
        LabPageSum.Text     = Convert.ToString(GVData.PageCount);
        LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1));
        this.GoPage.Text    = LabCurrentPage.Text.ToString();
    }
Beispiel #3
0
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        ZWL.BLL.ERPContractChanPin Model = new ZWL.BLL.ERPContractChanPin();

        Model.HeTongName  = this.txtHeTongName.Text.ToString();
        Model.ChanPinName = this.txtChanPinName.Text.ToString();
        Model.DanJia      = decimal.Parse(this.txtDanJia.Text);
        Model.ShuLiang    = decimal.Parse(this.txtShuLiang.Text);
        Model.ZongJia     = decimal.Parse(this.txtZongJia.Text);
        Model.YiFuKuan    = decimal.Parse(this.txtYiFuKuan.Text);
        Model.QianKuanShu = decimal.Parse(this.txtQianKuanShu.Text);
        Model.IFJiaoFu    = this.RadioButtonList1.SelectedItem.Text;
        Model.UserName    = ZWL.Common.PublicMethod.GetSessionValue("UserName");
        Model.TimeStr     = DateTime.Now;
        Model.BackInfo    = this.txtBackInfo.Text.ToString();

        if (this.RadioButtonList1.SelectedItem.Text == "已交付")
        {
            //从产品库存中减去
            string TempSqlStr = "update ERPProduct set  ChuKuSum=ChuKuSum+" + this.txtShuLiang.Text + ",NowKuCun=NowKuCun-" + this.txtShuLiang.Text + " where ProductName='" + this.txtChanPinName.Text.ToString() + "'";
            ZWL.DBUtility.DbHelperSQL.ExecuteSQL(TempSqlStr);
        }

        Model.Add();

        //写系统日志
        ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
        MyRiZhi.UserName    = ZWL.Common.PublicMethod.GetSessionValue("UserName");
        MyRiZhi.DoSomething = "用户添加合同产品信息(" + this.txtHeTongName.Text + ")";
        MyRiZhi.IpStr       = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
        MyRiZhi.Add();

        ZWL.Common.MessageBox.ShowAndRedirect(this, "合同产品信息添加成功!", "SellLog.aspx?HeTongName=" + Request.QueryString["HeTongName"].ToString());
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            ZWL.Common.PublicMethod.CheckSession();
            this.txtHeTongName.Attributes.Add("readonly", "true");
            this.txtChanPinName.Attributes.Add("readonly", "true");
            ZWL.BLL.ERPContractChanPin Model = new ZWL.BLL.ERPContractChanPin();
            Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
            this.txtHeTongName.Text             = Model.HeTongName.ToString();
            this.txtChanPinName.Text            = Model.ChanPinName.ToString();
            this.txtDanJia.Text                 = Model.DanJia.ToString();
            this.txtShuLiang.Text               = Model.ShuLiang.ToString();
            this.Label1.Text                    = Model.ShuLiang.ToString();
            this.txtZongJia.Text                = Model.ZongJia.ToString();
            this.txtYiFuKuan.Text               = Model.YiFuKuan.ToString();
            this.txtQianKuanShu.Text            = Model.QianKuanShu.ToString();
            this.RadioButtonList1.SelectedValue = Model.IFJiaoFu.ToString();
            this.Label2.Text                    = Model.UserName.ToString();
            this.Label3.Text                    = Model.TimeStr.ToString();
            this.txtBackInfo.Text               = Model.BackInfo.ToString();
            this.Label4.Text                    = Model.IFJiaoFu.ToString();

            RefreshData();
        }
    }
Beispiel #5
0
 public void DataBindToGridview()
 {
     ZWL.BLL.ERPContractChanPin MyModel = new ZWL.BLL.ERPContractChanPin();
     GVData.DataSource = MyModel.GetList("HeTongName Like '%" + this.TextBox1.Text + "%' order by ID desc");
     GVData.DataBind();
     LabPageSum.Text     = Convert.ToString(GVData.PageCount);
     LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1));
     this.GoPage.Text    = LabCurrentPage.Text.ToString();
 }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            ZWL.Common.PublicMethod.CheckSession();
            ZWL.BLL.ERPContractChanPin Model = new ZWL.BLL.ERPContractChanPin();
            Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
            this.lblHeTongName.Text  = Model.HeTongName.ToString();
            this.lblChanPinName.Text = Model.ChanPinName.ToString();
            this.lblDanJia.Text      = Model.DanJia.ToString();
            this.lblShuLiang.Text    = Model.ShuLiang.ToString();
            this.lblZongJia.Text     = Model.ZongJia.ToString();
            this.lblYiFuKuan.Text    = Model.YiFuKuan.ToString();
            this.lblQianKuanShu.Text = Model.QianKuanShu.ToString();
            this.lblIFJiaoFu.Text    = Model.IFJiaoFu.ToString();
            this.lblUserName.Text    = Model.UserName.ToString();
            this.lblTimeStr.Text     = Model.TimeStr.ToString();
            this.lblBackInfo.Text    = Model.BackInfo.ToString();

            ZWL.BLL.ERPProduct ModelProduct = new ZWL.BLL.ERPProduct();
            ModelProduct.GetModelByName(Model.ChanPinName.ToString());
            this.lblProductSize.Text          = ModelProduct.ProductSize;
            this.lblPerformance.Text          = ModelProduct.Performance;
            this.lblCoating.Text              = ModelProduct.Coating;
            this.lblSurfaceTreatment.Text     = ModelProduct.SurfaceTreatment;
            this.lblMagnetizingDirection.Text = ModelProduct.MagnetizingDirection;
            this.lblTolerance.Text            = ModelProduct.Tolerance;
            this.lblIsContainingTax.Text      = ModelProduct.IsContainingTax == 1 ? "是" : "否";

            //写系统日志
            ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
            MyRiZhi.UserName    = ZWL.Common.PublicMethod.GetSessionValue("UserName");
            MyRiZhi.DoSomething = "用户查看订单产品信息(" + this.lblHeTongName.Text + ")";
            MyRiZhi.IpStr       = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
            MyRiZhi.Add();
        }
    }