protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
//绑定页面数据
ZWL.BLL.ERPWorkPlan MyModel = new ZWL.BLL.ERPWorkPlan();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.Label1.Text = MyModel.TitleStr;
this.Label2.Text = MyModel.CanLookUser;
this.Label6.Text = MyModel.ContentStr;
this.Label4.Text = MyModel.UserName;
this.Label5.Text = MyModel.TimeStr.ToString();
this.HyperLink1.NavigateUrl = "../LanEmail/LanEmailAdd.aspx?UserName="******"../UploadFile/");
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "查看工作计划信息(" + this.Label1.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
//绑定页面数据
ZWL.BLL.ERPWorkPlan MyModel = new ZWL.BLL.ERPWorkPlan();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
if (MyModel!=null)
{
this.Label1.Text = MyModel.TitleStr;
this.Label2.Text = MyModel.CanLookUser;
this.Label6.Text = MyModel.ContentStr;
this.Label4.Text = MyModel.UserName;
this.Label5.Text = MyModel.TimeStr.ToString();
this.HyperLink1.NavigateUrl = "../LanEmail/LanEmailAdd.aspx?UserName="******"&fanhui=0";
this.Label3.Text = ZWL.Common.PublicMethod.GetWenJian(MyModel.FuJianStr, "../UploadFile/");
}
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "查看工作计划信息(" + this.Label1.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
}
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPWorkPlan MyLanEmail = new ZWL.BLL.ERPWorkPlan();
var T = context.ERPWorkPlan.Where(p => p.UserName == ZWL.Common.PublicMethod.GetSessionValue("UserName")).OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPWorkPlan MyLanEmail = new ZWL.BLL.ERPWorkPlan();
var T = context.ERPWorkPlan.Where(p => p.UserName == ZWL.Common.PublicMethod.GetSessionValue("UserName")).OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
public void DataBindToGridview()
{
ZWL.BLL.ERPWorkPlan MyModel = new ZWL.BLL.ERPWorkPlan();
GVData.DataSource = MyModel.GetList("TitleStr Like '%" + this.TextBox1.Text + "%' and 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.ERPWorkPlan MyModel = new ZWL.BLL.ERPWorkPlan();
DataSet ds = MyModel.GetList("TitleStr Like '%" + this.TextBox1.Text + "%' and ','+CanLookUser+',' like '%," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + ",%' order by ID desc");
GVData.DataSource = ds;
GVData.DataBind();
AspNetPager1.RecordCount = ds.Tables[0].Rows.Count;
}
public void DataBindToGridview()
{
ZWL.BLL.ERPWorkPlan MyModel = new ZWL.BLL.ERPWorkPlan();
DataSet ds = MyModel.GetList("TitleStr Like '%" + this.TextBox1.Text + "%' order by ID desc");
if (ds != null)
{
GVData.DataSource = ds;
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.ERPWorkPlan MyModel = new ZWL.BLL.ERPWorkPlan();
DataSet ds = MyModel.GetList("TitleStr Like '%" + this.TextBox1.Text + "%' and ','+CanLookUser+',' like '%," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + ",%' order by ID desc");
if (ds != null)
{
GVData.DataSource = ds;
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.ERPWorkPlan MyModel = new ZWL.BLL.ERPWorkPlan();
DataSet ds = MyModel.GetList("TitleStr Like '%" + this.TextBox1.Text + "%' order by ID desc");
if (ds != null)
{
GVData.DataSource = ds;
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.ERPWorkPlan MyModel = new ZWL.BLL.ERPWorkPlan();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.TextBox1.Text = MyModel.TitleStr;
this.TextBox2.Text = MyModel.CanLookUser;
this.TxtContent.Text = MyModel.ContentStr;
ZWL.Common.PublicMethod.SetSessionValue("WenJianList", MyModel.FuJianStr);
ZWL.Common.PublicMethod.BindDDL(this.CheckBoxList1, ZWL.Common.PublicMethod.GetSessionValue("WenJianList"));
}
}
public void DataBindToGridview()
{
string XiaShuUser = ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 XiaShuUser from ERPUser where UserName='******'");
string SSTempSTR = "";
if (XiaShuUser != "全部")
{
SSTempSTR = "and UserName in(" + "'" + XiaShuUser.Replace(",", "','") + "'" + ")";
}
ZWL.BLL.ERPWorkPlan MyModel = new ZWL.BLL.ERPWorkPlan();
GVData.DataSource = MyModel.GetList("TitleStr Like '%" + this.TextBox1.Text + "%' and UserName like '%" + this.TextBox2.Text + "%' " + SSTempSTR + " 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()
{
string XiaShuUser = ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 XiaShuUser from ERPUser where UserName='******'");
string SSTempSTR = "";
if (XiaShuUser != "全部")
{
SSTempSTR = "and UserName in(" + "'" + XiaShuUser.Replace(",", "','") + "'" + ")";
}
ZWL.BLL.ERPWorkPlan MyModel = new ZWL.BLL.ERPWorkPlan();
GVData.DataSource = MyModel.GetList("TitleStr Like '%" + this.TextBox1.Text + "%' and UserName like '%" + this.TextBox2.Text + "%' " + SSTempSTR + " 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 ImageButton1_Click(object sender, EventArgs e)
{
ZWL.BLL.ERPWorkPlan Model = new ZWL.BLL.ERPWorkPlan();
Model.TitleStr = this.TextBox1.Text;
Model.ContentStr = this.TxtContent.Value;
Model.CanLookUser = this.TextBox2.Text;
Model.TimeStr = DateTime.Now;
Model.FuJianStr = ZWL.Common.PublicMethod.GetSessionValue("WenJianList");
Model.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.Add();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户添加工作计划信息(" + this.TextBox1.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "工作计划添加成功！", "MyWorkPlan.aspx");
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ZWL.BLL.ERPWorkPlan Model = new ZWL.BLL.ERPWorkPlan();
Model.ID = int.Parse(Request.QueryString["ID"].ToString());
Model.TitleStr = this.TextBox1.Text;
Model.ContentStr = this.TxtContent.Text;
Model.CanLookUser = this.TextBox2.Text;
Model.TimeStr = DateTime.Now;
Model.FuJianStr = ZWL.Common.PublicMethod.GetSessionValue("WenJianList");
Model.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.Update();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户修改工作计划信息(" + this.TextBox1.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "工作计划修改成功！", "MyWorkPlan.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
//绑定页面数据
ZWL.BLL.ERPWorkPlan MyModel = new ZWL.BLL.ERPWorkPlan();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
if (MyModel!=null)
{
this.TextBox1.Text = MyModel.TitleStr;
this.TextBox2.Text = MyModel.CanLookUser;
this.TxtContent.Text = MyModel.ContentStr;
}
ZWL.Common.PublicMethod.SetSessionValue("WenJianList", MyModel.FuJianStr);
ZWL.Common.PublicMethod.BindDDL(this.CheckBoxList1, ZWL.Common.PublicMethod.GetSessionValue("WenJianList"));
}
}
