protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPReport Model = new ZWL.BLL.ERPReport();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.lblReportName.Text=Model.ReportName.ToString();
this.lblReportSql.Text=Model.ReportSql.ToString();
this.lblBackInfo.Text=Model.BackInfo.ToString();
this.lblTypeID.Text=Model.TypeID.ToString();
this.lblUserListOK.Text=Model.UserListOK.ToString();
this.lblDepListOK.Text=Model.DepListOK.ToString();
this.lblJiaoSeListOK.Text=Model.JiaoSeListOK.ToString();
this.lblPaiXuStr.Text=Model.PaiXuStr.ToString();
this.lblUserName.Text=Model.UserName.ToString();
this.lblTimeStr.Text=Model.TimeStr.ToString();
//дϵͳ��־
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "�û��鿴���������Ϣ(" + this.lblReportName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ZWL.BLL.ERPReport Model = new ZWL.BLL.ERPReport();
Model.ID = int.Parse(Request.QueryString["ID"].ToString());
Model.ReportName = this.txtReportName.Text.ToString();
Model.ReportSql = this.txtReportSql.Text.ToString();
Model.BackInfo = this.txtBackInfo.Text.ToString();
Model.TypeID = int.Parse(Request.QueryString["TypeID"].ToString());
Model.UserListOK = this.txtUserListOK.Text.ToString();
Model.DepListOK = this.txtDepListOK.Text.ToString();
Model.JiaoSeListOK = this.txtJiaoSeListOK.Text.ToString();
Model.PaiXuStr = this.txtPaiXuStr.Text.ToString();
Model.UserName = this.txtUserName.Text.ToString();
Model.TimeStr = DateTime.Parse(this.txtTimeStr.Text);
Model.Update();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户修改报表管理信息(" + this.txtReportName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "报表管理信息修改成功！", "Report.aspx?TypeID=" + Request.QueryString["TypeID"].ToString());
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ZWL.BLL.ERPReport Model = new ZWL.BLL.ERPReport();
Model.ReportName=this.txtReportName.Text.ToString();
Model.ReportSql=this.txtReportSql.Text.ToString();
Model.BackInfo=this.txtBackInfo.Text.ToString();
Model.TypeID=int.Parse(Request.QueryString["TypeID"].ToString());
Model.UserListOK=this.txtUserListOK.Text.ToString();
Model.DepListOK=this.txtDepListOK.Text.ToString();
Model.JiaoSeListOK=this.txtJiaoSeListOK.Text.ToString();
Model.PaiXuStr=this.txtPaiXuStr.Text.ToString();
Model.UserName=ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.TimeStr=DateTime.Now;
Model.Add();
//дϵͳ��־
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "�û���ӱ��������Ϣ(" + this.txtReportName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "���������Ϣ��ӳɹ���", "Report.aspx?TypeID=" + Request.QueryString["TypeID"].ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPReport Model = new ZWL.BLL.ERPReport();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.lblReportName.Text = Model.ReportName.ToString();
this.lblReportSql.Text = Model.ReportSql.ToString();
this.lblBackInfo.Text = Model.BackInfo.ToString();
this.lblTypeID.Text = Model.TypeID.ToString();
this.lblUserListOK.Text = Model.UserListOK.ToString();
this.lblDepListOK.Text = Model.DepListOK.ToString();
this.lblJiaoSeListOK.Text = Model.JiaoSeListOK.ToString();
this.lblPaiXuStr.Text = Model.PaiXuStr.ToString();
this.lblUserName.Text = Model.UserName.ToString();
this.lblTimeStr.Text = Model.TimeStr.ToString();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户查看报表管理信息(" + this.lblReportName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
}
}
public void DataBindToGridview()
{
ZWL.BLL.ERPReport Model = new ZWL.BLL.ERPReport();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
GVData.DataSource = ZWL.DBUtility.DbHelperSQL.GetDataSet(Model.ReportSql.ToString());
GVData.DataBind();
}
public void DataBindToGridview()
{
ZWL.BLL.ERPReport Model = new ZWL.BLL.ERPReport();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
GVData.DataSource = ZWL.DBUtility.DbHelperSQL.GetDataSet(Model.ReportSql.ToString());
GVData.DataBind();
}
public void DataBindToGridview(string IDList)
{
ZWL.BLL.ERPReport MyModel = new ZWL.BLL.ERPReport();
if (IDList.Trim().Length > 0)
{
GVData.DataSource = MyModel.GetList(" " + DropDownList2.SelectedItem.Value.ToString() + " like '%" + this.TextBox3.Text.Trim() + "%' and TypeID=" + Request.QueryString["TypeID"].ToString() + " and ID in(" + IDList + ") order by PaiXuStr asc,ID desc");
}
else
{
GVData.DataSource = MyModel.GetList(" " + DropDownList2.SelectedItem.Value.ToString() + " like '%" + this.TextBox3.Text.Trim() + "%' and TypeID=" + Request.QueryString["TypeID"].ToString() + " order by PaiXuStr asc,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(string IDList)
{
ZWL.BLL.ERPReport MyModel = new ZWL.BLL.ERPReport();
if (IDList.Trim().Length > 0)
{
GVData.DataSource = MyModel.GetList(" " + DropDownList2.SelectedItem.Value.ToString() + " like '%" + this.TextBox3.Text.Trim() + "%' and TypeID=" + Request.QueryString["TypeID"].ToString() + " and ID in(" + IDList + ") order by PaiXuStr asc,ID desc");
}
else
{
GVData.DataSource = MyModel.GetList(" " + DropDownList2.SelectedItem.Value.ToString() + " like '%" + this.TextBox3.Text.Trim() + "%' and TypeID=" + Request.QueryString["TypeID"].ToString() + " order by PaiXuStr asc,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.ERPReport Model = new ZWL.BLL.ERPReport();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.txtReportName.Text = Model.ReportName.ToString();
this.txtReportSql.Text = Model.ReportSql.ToString();
this.txtBackInfo.Text = Model.BackInfo.ToString();
//this.txtTypeID.Text=Model.TypeID.ToString();
this.txtUserListOK.Text = Model.UserListOK.ToString();
this.txtDepListOK.Text = Model.DepListOK.ToString();
this.txtJiaoSeListOK.Text = Model.JiaoSeListOK.ToString();
this.txtPaiXuStr.Text = Model.PaiXuStr.ToString();
this.txtUserName.Text = Model.UserName.ToString();
this.txtTimeStr.Text = Model.TimeStr.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPReport Model = new ZWL.BLL.ERPReport();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.txtReportName.Text=Model.ReportName.ToString();
this.txtReportSql.Text=Model.ReportSql.ToString();
this.txtBackInfo.Text=Model.BackInfo.ToString();
//this.txtTypeID.Text=Model.TypeID.ToString();
this.txtUserListOK.Text=Model.UserListOK.ToString();
this.txtDepListOK.Text=Model.DepListOK.ToString();
this.txtJiaoSeListOK.Text=Model.JiaoSeListOK.ToString();
this.txtPaiXuStr.Text=Model.PaiXuStr.ToString();
this.txtUserName.Text=Model.UserName.ToString();
this.txtTimeStr.Text=Model.TimeStr.ToString();
}
}
