public void DataBindToGridview() { ZWL.BLL.ERPReimburse MyModel = new ZWL.BLL.ERPReimburse(); 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 QianYueKeHu Like '%" + this.TextBox1.Text + "%' or ReimburseContent Like '%" + this.TextBox1.Text + "%' or UserName Like '%" + this.TextBox1.Text + "%')"; } if (!string.IsNullOrEmpty(this.TextBox3.Text)) { if (string.IsNullOrEmpty(sql)) { sql += " ApplyTime >='" + this.TextBox3.Text.Trim() + " 00:00:00' and ApplyTime<='" + this.TextBox4.Text.Trim() + " 23:59:59' "; } else { sql += "and ApplyTime >='" + this.TextBox3.Text.Trim() + " 00:00:00' and ApplyTime<='" + 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(); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); ZWL.BLL.ERPReimburse Model = new ZWL.BLL.ERPReimburse(); Model.GetModel(int.Parse(Request.QueryString["ID"].ToString())); this.txtHeTongName.Text = Model.HeTongName.ToString(); this.txtUserName.Text = Model.UserName.ToString(); this.txtQianYueKeHu.Text = Model.QianYueKeHu.ToString(); this.txtReimburseContent.Text = Model.ReimburseContent.ToString(); this.txtApplyTime.Text = Model.ApplyTime.ToString(); this.txtMemo.Text = Model.Memo.ToString(); } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { ZWL.BLL.ERPReimburse Model = new ZWL.BLL.ERPReimburse(); Model.UserName = this.txtUserName.Text.ToString(); Model.HeTongName = this.txtHeTongName.Text.ToString(); Model.QianYueKeHu = this.txtQianYueKeHu.Text.ToString(); Model.ReimburseContent = this.txtReimburseContent.Text.ToString(); Model.ApplyTime = this.txtApplyTime.Text.ToString(); Model.Memo = this.txtMemo.Text.ToString(); Model.Add(); //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "用户添加报销单信息(" + this.txtReimburseContent.Text + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); ZWL.Common.MessageBox.ShowAndRedirect(this, "报销单信息添加成功!", "Reimburse.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); ZWL.BLL.ERPReimburse Model = new ZWL.BLL.ERPReimburse(); Model.GetModel(int.Parse(Request.QueryString["ID"].ToString())); this.lblHeTongName.Text = Model.HeTongName.ToString(); HeTongName = Model.HeTongName.ToString(); this.lblUserName.Text = Model.UserName.ToString(); this.lblQianYueKeHu.Text = Model.QianYueKeHu.ToString(); this.lblReimburseContent.Text = Model.ReimburseContent.ToString(); this.lblApplyTime.Text = Model.ApplyTime.ToString(); this.lblMemo.Text = Model.Memo.ToString(); //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "用户查看报销单信息(" + this.lblReimburseContent.Text + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); } }