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();
}
}
