public void DataBindToGridview()
{
ZWL.BLL.ERPJuanKu MyModel = new ZWL.BLL.ERPJuanKu();
GVData.DataSource = MyModel.GetList("JuanKuName Like '%" + this.TextBox1.Text + "%' and ( ','+CanViewUserList+',' like '%," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + ",%' or UserName='******' ) 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.ERPJuanKu MyModel = new ZWL.BLL.ERPJuanKu();
GVData.DataSource = MyModel.GetList("JuanKuName Like '%" + this.TextBox1.Text + "%' and ( ','+CanViewUserList+',' like '%,"+ZWL.Common.PublicMethod.GetSessionValue("UserName")+",%' or UserName='******' ) 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()
{
GVData.PageSize = AspNetPager1.PageSize;
GVData.PageIndex = AspNetPager1.CurrentPageIndex - 1;
ZWL.BLL.ERPJuanKu MyModel = new ZWL.BLL.ERPJuanKu();
DataSet ds = MyModel.GetList("JuanKuName Like '%" + this.TextBox1.Text + "%' order by ID desc");
GVData.DataSource = ds;
GVData.DataBind();
AspNetPager1.RecordCount = ds.Tables[0].Rows.Count;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPJuanKu Model = new ZWL.BLL.ERPJuanKu();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.txtJuanKuName.Text = Model.JuanKuName.ToString();
this.txtJuanKuSerils.Text = Model.JuanKuSerils.ToString();
this.txtSuoShuBuMen.Text = Model.SuoShuBuMen.ToString();
this.txtBackInfo.Text = Model.BackInfo.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.ERPJuanKu Model = new ZWL.BLL.ERPJuanKu();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.txtJuanKuName.Text=Model.JuanKuName.ToString();
this.txtJuanKuSerils.Text=Model.JuanKuSerils.ToString();
this.txtSuoShuBuMen.Text=Model.SuoShuBuMen.ToString();
this.txtBackInfo.Text=Model.BackInfo.ToString();
this.txtUserName.Text=Model.UserName.ToString();
this.txtTimeStr.Text=Model.TimeStr.ToString();
this.TextBox1.Text = Model.CanViewUserList;
}
}
protected void ImageButton1_Click(object sender, EventArgs e)
{
ZWL.BLL.ERPJuanKu Model = new ZWL.BLL.ERPJuanKu();
Model.JuanKuName = this.txtJuanKuName.Text.ToString();
Model.JuanKuSerils = this.txtJuanKuSerils.Text.ToString();
Model.SuoShuBuMen = this.txtSuoShuBuMen.Text.ToString();
Model.BackInfo = this.txtBackInfo.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.txtJuanKuName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "卷库信息添加成功！", "JuanKu.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPJuanKu Model = new ZWL.BLL.ERPJuanKu();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.lblJuanKuName.Text = Model.JuanKuName.ToString();
this.lblJuanKuSerils.Text = Model.JuanKuSerils.ToString();
this.lblSuoShuBuMen.Text = Model.SuoShuBuMen.ToString();
this.lblBackInfo.Text = Model.BackInfo.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.lblJuanKuName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ZWL.BLL.ERPJuanKu Model = new ZWL.BLL.ERPJuanKu();
Model.JuanKuName=this.txtJuanKuName.Text.ToString();
Model.JuanKuSerils=this.txtJuanKuSerils.Text.ToString();
Model.SuoShuBuMen=this.txtSuoShuBuMen.Text.ToString();
Model.BackInfo=this.txtBackInfo.Text.ToString();
Model.UserName=ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.TimeStr=DateTime.Now;
Model.CanViewUserList = this.TextBox1.Text;
Model.Add();
//дϵͳ��־
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "�û���Ӿ����Ϣ(" + this.txtJuanKuName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "�����Ϣ��ӳɹ���", "JuanKu.aspx");
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ZWL.BLL.ERPJuanKu Model = new ZWL.BLL.ERPJuanKu();
Model.ID = int.Parse(Request.QueryString["ID"].ToString());
Model.JuanKuName = this.txtJuanKuName.Text.ToString();
Model.JuanKuSerils = this.txtJuanKuSerils.Text.ToString();
Model.SuoShuBuMen = this.txtSuoShuBuMen.Text.ToString();
Model.BackInfo = this.txtBackInfo.Text.ToString();
Model.UserName = this.txtUserName.Text.ToString();
Model.TimeStr = DateTime.Parse(this.txtTimeStr.Text);
Model.CanViewUserList = this.TextBox1.Text;
Model.Update();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户修改卷库信息(" + this.txtJuanKuName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "卷库信息修改成功！", "JuanKu.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPJuanKu Model = new ZWL.BLL.ERPJuanKu();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.lblJuanKuName.Text=Model.JuanKuName.ToString();
this.lblJuanKuSerils.Text=Model.JuanKuSerils.ToString();
this.lblSuoShuBuMen.Text=Model.SuoShuBuMen.ToString();
this.lblBackInfo.Text=Model.BackInfo.ToString();
this.lblUserName.Text=Model.UserName.ToString();
this.lblTimeStr.Text=Model.TimeStr.ToString();
this.Label1.Text = Model.CanViewUserList;
//дϵͳ��־
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "�û��鿴�����Ϣ(" + this.lblJuanKuName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
}
}