protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); ZWL.BLL.ERPContract Model = new ZWL.BLL.ERPContract(); Model.GetModel(int.Parse(Request.QueryString["ID"].ToString())); this.lblHeTongName.Text = Model.HeTongName.ToString(); HeTongName = Model.HeTongName.ToString(); this.lblHeTongSerils.Text = Model.HeTongSerils.ToString(); this.lblHeTongLeiXing.Text = Model.HeTongLeiXing.ToString(); this.lblQianYueKeHu.Text = Model.QianYueKeHu.ToString(); this.lblHeTongMiaoShu.Text = Model.HeTongMiaoShu.ToString(); this.lblHeTongTiaoKuan.Text = Model.HeTongTiaoKuan.ToString(); this.lblHeTongContent.Text = Model.HeTongContent.ToString(); this.lblShengXiaoDate.Text = Model.ShengXiaoDate.ToString().Replace(" 0:00:00", ""); this.lblZhongZhiDate.Text = Model.ZhongZhiDate.ToString().Replace(" 0:00:00", ""); this.lblTiXingDate.Text = Model.TiXingDate.ToString().Replace(" 0:00:00", ""); this.lblQianYueRenBuy.Text = Model.QianYueRenBuy.ToString(); this.lblQianYueRenSell.Text = Model.QianYueRenSell.ToString(); this.lblCreateTime.Text = Model.CreateTime.ToString(); this.lblCreateUser.Text = Model.CreateUser.ToString(); this.lblFuJianList.Text = ZWL.Common.PublicMethod.GetWenJian(Model.FuJianList.ToString(), "../UploadFile/"); this.lblBackInfo.Text = Model.BackInfo.ToString(); this.lblNowState.Text = Model.NowState.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(); } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { ZWL.BLL.ERPContract Model = new ZWL.BLL.ERPContract(); Model.HeTongName = this.txtHeTongName.Text.ToString(); Model.HeTongSerils = this.txtHeTongSerils.Text.ToString(); Model.HeTongLeiXing = this.txtHeTongLeiXing.Text.ToString(); Model.QianYueKeHu = this.txtQianYueKeHu.Text.ToString(); Model.HeTongMiaoShu = this.txtHeTongMiaoShu.Text.ToString(); Model.HeTongTiaoKuan = this.txtHeTongTiaoKuan.Text.ToString(); Model.HeTongContent = this.txtHeTongContent.Text.ToString(); Model.ShengXiaoDate = DateTime.Parse(this.txtShengXiaoDate.Text); Model.ZhongZhiDate = DateTime.Parse(this.txtZhongZhiDate.Text); Model.TiXingDate = DateTime.Parse(this.txtTiXingDate.Text); Model.QianYueRenBuy = this.txtQianYueRenBuy.Text.ToString(); Model.QianYueRenSell = this.txtQianYueRenSell.Text.ToString(); Model.CreateTime = DateTime.Now; Model.CreateUser = ZWL.Common.PublicMethod.GetSessionValue("UserName"); Model.FuJianList = ZWL.Common.PublicMethod.GetSessionValue("WenJianList"); Model.BackInfo = this.txtBackInfo.Text.ToString(); Model.NowState = "等待审核"; 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, "销售订单信息添加成功!", "ContractDengJi.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); this.txtQianYueKeHu.Attributes.Add("readonly", "true"); ZWL.BLL.ERPContract Model = new ZWL.BLL.ERPContract(); Model.GetModel(int.Parse(Request.QueryString["ID"].ToString())); this.txtHeTongName.Text = Model.HeTongName.ToString(); this.txtHeTongSerils.Text = Model.HeTongSerils.ToString(); this.txtHeTongLeiXing.Text = Model.HeTongLeiXing.ToString(); this.txtQianYueKeHu.Text = Model.QianYueKeHu.ToString(); this.txtHeTongMiaoShu.Text = Model.HeTongMiaoShu.ToString(); this.txtHeTongTiaoKuan.Text = Model.HeTongTiaoKuan.ToString(); this.txtHeTongContent.Text = Model.HeTongContent.ToString(); this.txtShengXiaoDate.Text = Model.ShengXiaoDate.ToString().Replace(" 0:00:00", ""); this.txtZhongZhiDate.Text = Model.ZhongZhiDate.ToString().Replace(" 0:00:00", ""); this.txtTiXingDate.Text = Model.TiXingDate.ToString().Replace(" 0:00:00", ""); this.txtQianYueRenBuy.Text = Model.QianYueRenBuy.ToString(); this.txtQianYueRenSell.Text = Model.QianYueRenSell.ToString(); this.Label2.Text = Model.CreateTime.ToString(); this.Label1.Text = Model.CreateUser.ToString(); ZWL.Common.PublicMethod.SetSessionValue("WenJianList", Model.FuJianList); ZWL.Common.PublicMethod.BindDDL(this.CheckBoxList1, ZWL.Common.PublicMethod.GetSessionValue("WenJianList")); this.txtBackInfo.Text = Model.BackInfo.ToString(); this.Label3.Text = Model.NowState.ToString(); } }
public void DataBindToGridview() { string XiaShuUser = ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 XiaShuUser from ERPUser where UserName='******'"); string SSTempSTR = ""; if (XiaShuUser != "全部") { SSTempSTR = "and CreateUser in(" + "'" + XiaShuUser.Replace(",", "','") + "'" + ")"; } ZWL.BLL.ERPContract MyModel = new ZWL.BLL.ERPContract(); MyModel.HZ(); string sql = ""; if (!string.IsNullOrEmpty(this.TextBox1.Text)) { sql += "(HeTongName Like '%" + this.TextBox1.Text + "%' or HeTongSerils Like '%" + this.TextBox1.Text + "%' or QianYueKeHu Like '%" + this.TextBox1.Text + "%' or HeTongLeiXing Like '%" + this.TextBox1.Text + "%' or CreateUser Like '%" + this.TextBox1.Text + "%' or SFJF Like '%" + this.TextBox1.Text + "%')"; } if (!string.IsNullOrEmpty(this.TextBox3.Text)) { if (string.IsNullOrEmpty(sql)) { sql += " (CreateTime >='" + this.TextBox3.Text.Trim() + " 00:00:00' and CreateTime<='" + this.TextBox4.Text.Trim() + " 23:59:59') or QianYueRenBuy = '" + this.TextBox3.Text + "' or QianYueRenBuy = '" + this.TextBox4.Text + "' or QianYueRenSell = '" + this.TextBox3.Text + "' or QianYueRenSell = '" + this.TextBox4.Text + "'"; } else { sql += " and CreateTime >='" + this.TextBox3.Text.Trim() + " 00:00:00' and CreateTime<='" + this.TextBox4.Text.Trim() + " 23:59:59') or QianYueRenBuy = '" + this.TextBox3.Text + "' or QianYueRenBuy = '" + this.TextBox4.Text + "' or QianYueRenSell = '" + this.TextBox3.Text + "' or QianYueRenSell = '" + this.TextBox4.Text + "' "; } 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(); }
public void DataBindToGridview() { ZWL.BLL.ERPContract MyModel = new ZWL.BLL.ERPContract(); MyModel.HZ(); string sql = " CreateUser='******'"; if (!string.IsNullOrEmpty(this.TextBox1.Text)) { sql += " and (HeTongName Like '%" + this.TextBox1.Text + "%' or HeTongSerils Like '%" + this.TextBox1.Text + "%' or QianYueKeHu Like '%" + this.TextBox1.Text + "%' or HeTongLeiXing Like '%" + this.TextBox1.Text + "%' or SFJF Like '%" + this.TextBox1.Text + "%')"; } if (!string.IsNullOrEmpty(this.TextBox3.Text)) { if (string.IsNullOrEmpty(sql)) { sql += " (CreateTime >='" + this.TextBox3.Text.Trim() + " 00:00:00' and CreateTime<='" + this.TextBox4.Text.Trim() + " 23:59:59') or QianYueRenBuy = '" + this.TextBox3.Text + "' or QianYueRenBuy = '" + this.TextBox4.Text + "' or QianYueRenSell = '" + this.TextBox3.Text + "' or QianYueRenSell = '" + this.TextBox4.Text + "'"; } else { sql += "and (CreateTime >='" + this.TextBox3.Text.Trim() + " 00:00:00' and CreateTime<='" + this.TextBox4.Text.Trim() + " 23:59:59') or QianYueRenBuy = '" + this.TextBox3.Text + "' or QianYueRenBuy = '" + this.TextBox4.Text + "' or QianYueRenSell = '" + this.TextBox3.Text + "' or QianYueRenSell = '" + this.TextBox4.Text + "'"; } sql += " 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(); }
public void DataBindToGridview() { ZWL.BLL.ERPContract MyModel = new ZWL.BLL.ERPContract(); GVData.DataSource = MyModel.GetList("HeTongName Like '%" + this.TextBox1.Text + "%' and CreateUser='******' 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(); }
public void DataBindToGridview() { ZWL.BLL.ERPContract MyModel = new ZWL.BLL.ERPContract(); 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.Common.PublicMethod.SetSessionValue("WenJianList", ""); this.txtQianYueKeHu.Attributes.Add("readonly", "true"); ZWL.BLL.ERPContract Model = new ZWL.BLL.ERPContract(); txtHeTongSerils.Text = Model.GetSerils(); } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { ZWL.BLL.ERPBuyOrder Model = new ZWL.BLL.ERPBuyOrder(); ZWL.BLL.ERPContract Model1 = new ZWL.BLL.ERPContract(); if (ZWL.Common.PublicMethod.IFExists("OrderName", "ERPBuyOrder", 0, this.txtOrderName.Text) == true) { Model.OrderName = this.txtOrderName.Text.ToString(); Model.GongYingShangName = this.txtGongYingShangName.Text.ToString(); Model.Serils = this.txtSerils.Text.ToString(); Model.DingDanLeiXing = this.txtDingDanLeiXing.Text.ToString(); Model.DingDanMiaoShu = this.txtDingDanMiaoShu.Text.ToString(); Model.CreateDate = DateTime.Parse(this.txtCreateDate.Text); Model.LaiHuoDate = DateTime.Parse(this.txtLaiHuoDate.Text); Model.TiXingDate = DateTime.Parse(this.txtTiXingDate.Text); Model.ChuangJianRen = this.txtChuangJianRen.Text.ToString(); Model.FuZeRen = this.txtFuZeRen.Text.ToString(); Model.FuJianList = ZWL.Common.PublicMethod.GetSessionValue("WenJianList"); Model.NowState = "等待审核"; Model.ShenPiTongGuoRen = ""; Model.BackInfo = this.txtBackInfo.Text.ToString(); Model.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); Model.TimeStr = DateTime.Now; Model.Add(); DataSet ds = Model1.GetList("HeTongName='" + this.txtOrderName.Text + "'"); if (ds.Tables[0].Rows.Count > 0) { string sql = "update ERPContract set NowState='正在采购' where ID=" + ds.Tables[0].Rows[0]["ID"].ToString() + ""; DbHelperSQL.ExecuteSql(sql.ToString()); } //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "用户添加采购订单信息(" + this.txtOrderName.Text + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); ZWL.Common.MessageBox.ShowAndRedirect(this, "采购订单信息添加成功!", "BuyDengJi.aspx"); } else { ZWL.Common.MessageBox.Show(this, "该订单名称已经存在,请更改其他订单名称!"); } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { ZWL.BLL.ERPContract Model = new ZWL.BLL.ERPContract(); if (ZWL.Common.PublicMethod.IFExists("HeTongName", "ERPContract", 0, this.txtHeTongName.Text) == true) { Model.ID = int.Parse(Request.QueryString["ID"].ToString()); Model.HeTongName = this.txtHeTongName.Text.ToString(); Model.HeTongSerils = this.txtHeTongSerils.Text.ToString(); Model.HeTongLeiXing = this.txtHeTongLeiXing.Text.ToString(); Model.QianYueKeHu = this.txtQianYueKeHu.Text.ToString(); Model.HeTongMiaoShu = this.txtHeTongMiaoShu.Text.ToString(); Model.HeTongTiaoKuan = this.txtHeTongTiaoKuan.Text.ToString(); Model.HeTongContent = this.txtHeTongContent.Text.ToString(); Model.ShengXiaoDate = DateTime.Parse(this.txtShengXiaoDate.Text); Model.ZhongZhiDate = DateTime.Parse(this.txtZhongZhiDate.Text); Model.TiXingDate = DateTime.Parse(this.txtTiXingDate.Text); Model.QianYueRenBuy = this.txtQianYueRenBuy.Text.ToString(); Model.QianYueRenSell = this.txtQianYueRenSell.Text.ToString(); Model.CreateTime = DateTime.Parse(this.Label2.Text); Model.CreateUser = this.Label1.Text.ToString(); Model.FuJianList = ZWL.Common.PublicMethod.GetSessionValue("WenJianList"); Model.BackInfo = this.txtBackInfo.Text.ToString(); Model.NowState = this.Label3.Text.ToString(); Model.Update(); //写系统日志 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, "销售订单信息修改成功!", "ContractDengJi.aspx"); } else { ZWL.Common.MessageBox.Show(this, "该订单名称已经存在,请更改其他订单名称!"); } }