public static string GetWarning() { string res = ""; ZWL.BLL.ERPHuiBao MyModel = new ZWL.BLL.ERPHuiBao(); res = MyModel.GetListByUserNameTitleStr(ZWL.Common.PublicMethod.GetSessionValue("UserName"), ""); return res; }
protected void btn_Sub_Click(object sender, EventArgs e) { ZWL.BLL.ERPHuiBao Model = new ZWL.BLL.ERPHuiBao(); Model.TitleStr = this.TextBox1.Text; Model.ContentStr = this.TxtContent.Text; Model.CanLookUser = this.UserName_Input.Value; Model.DDWL = this.TextBox3.Text; Model.TimeStr = DateTime.Now; Model.DDWL = this.ddl_WarningType.SelectedValue; Model.FuJianStr = ZWL.Common.PublicMethod.GetSessionValue("WenJianList"); Model.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); Model.SSBM = ZWL.Common.PublicMethod.GetSessionValue("Department"); if(string.IsNullOrEmpty(this.TextBox2.Text)) { Model.ZT = "信息保存"; } else { Model.ZT = "信息转发"; } 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(); Response.Write("<script>alert('工作报告添加成功!');window.location.href='"+ReturnInput.Value+"'</script>"); }
public void DataBindToGridview() { DataEntityDataContext context = new DataEntityDataContext(); ZWL.BLL.ERPHuiBao MyLanEmail = new ZWL.BLL.ERPHuiBao(); var T = context.ERPHuiBao.Where(p => p.UserName == ZWL.Common.PublicMethod.GetSessionValue("UserName")).OrderByDescending(p => p.ID); EmailList = T.ToList(); }
public static string GetWarning() { string res = ""; ZWL.BLL.ERPHuiBao MyModel = new ZWL.BLL.ERPHuiBao(); res = MyModel.GetListByDeparment(int.Parse(ZWL.Common.PublicMethod.GetSessionValue("DepartmentID"))); return res; }
public static string GetWarning(string uname, string TitleStr) { string res = ""; ZWL.BLL.ERPHuiBao MyModel = new ZWL.BLL.ERPHuiBao(); res = MyModel.GetListByUserNameTitleStr(uname, TitleStr); return res; }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); //绑定页面数据 ZWL.BLL.ERPHuiBao MyModel = new ZWL.BLL.ERPHuiBao(); 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.ERPHuiBao MyModel = new ZWL.BLL.ERPHuiBao(); MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); if (MyModel!=null) { this.Label1.Text = MyModel.TitleStr; string CanLookUser=""; foreach (string C in MyModel.CanLookUser.Split(',')) { string CTrueName=ZWL.DBUtility.DbHelperSQL.GetSHSL("select [TrueName] from ERPUser where [UserName]='"+C+"'"); if(!string.IsNullOrEmpty(CTrueName)) { CanLookUser += CanLookUser == "" ? CTrueName : "," + CTrueName; } else { CanLookUser += CanLookUser == "" ? C : "," + C; } } this.Label2.Text = CanLookUser; this.Label6.Text = MyModel.ContentStr; string TrueName = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 [TrueName] from ERPUser where [UserName]='" + MyModel.UserName + "'"); this.Label4.Text = TrueName; this.Label5.Text = MyModel.TimeStr.ToString(); this.Label8.Text = MyModel.DDWL; this.Label7.Text = MyModel.ZT; 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(); QD.Visible = ZWL.Common.PublicMethod.StrIFIn("|111M|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian")); ZT1.Visible = ZWL.Common.PublicMethod.StrIFIn("|111M|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian")); ZT3.Visible = ZWL.Common.PublicMethod.StrIFIn("|111M|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian")); ReturnInput.Value = Request.UrlReferrer.ToString() == null ? "../WorkPlan/HuiBaoM.aspx" : Request.UrlReferrer.ToString(); } }
public void DataBindToGridview() { ZWL.BLL.ERPHuiBao MyModel = new ZWL.BLL.ERPHuiBao(); ZWL.BLL.ERPBuMen BuMenModel = new ZWL.BLL.ERPBuMen(); string Department_ID = BuMenModel.GetList("BuMenName='" + ZWL.Common.PublicMethod.GetSessionValue("Department") + "'").Tables[0].Rows[0]["ID"].ToString(); DataSet ds = MyModel.GetList("TitleStr Like '%" + this.TextBox1.Text + "%' and UserName='******'%" + this.TextBox1.Text + "%' and CHARINDEX('" + Department_ID + "',p_depart_ids)>0 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() { 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.ERPHuiBao MyModel = new ZWL.BLL.ERPHuiBao(); GVData.DataSource = MyModel.GetList("TitleStr Like '%" + this.TextBox1.Text + "%' and UserName like '%" + this.TextBox2.Text + "%' " + SSTempSTR,"ID",true); 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.ERPHuiBao MyModel = new ZWL.BLL.ERPHuiBao(); DataTable dt = ZWL.DBUtility.DbHelperSQL.GetDataTable("select h.ID,h.TitleStr,h.SSBM,h.UserName,h.TimeStr,h.ZT,h.DDWL,u.TrueName as TrueName from hx_vERPHuiBao as h left join ERPUser as u on h.UserName=u.UserName where h.TitleStr Like '%" + this.TextBox1.Text + "%' and h.UserName='******' order by ID desc"); foreach(DataRow R in dt.Rows) { if(R["TrueName"] == null) { R["TrueName"] = R["UserName"]; } } if(dt != null) { GVData.DataSource = dt; 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.ERPHuiBao Model = new ZWL.BLL.ERPHuiBao(); 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, "工作汇报添加成功!", "HuiBao.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); DataBindToGridview(); //设定按钮权限 btn_Add.Visible = ZWL.Common.PublicMethod.StrIFIn("|111A|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian")); btn_Change.Visible = ZWL.Common.PublicMethod.StrIFIn("|111M|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian")); btn_Del.Visible = ZWL.Common.PublicMethod.StrIFIn("|111D|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian")); btn_Report.Visible = ZWL.Common.PublicMethod.StrIFIn("|111E|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian")); string uname = System.Web.HttpContext.Current.Session["UserName"].ToString(); if ((Request["token"] ?? "") == "ajax" && !string.IsNullOrEmpty(uname)) { string res = ""; ZWL.BLL.ERPHuiBao MyModel = new ZWL.BLL.ERPHuiBao(); res = MyModel.GetListByZT("预警取消"); Response.Clear(); Response.Write(res); Response.End(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); //绑定页面数据 ZWL.BLL.ERPHuiBao MyModel = new ZWL.BLL.ERPHuiBao(); 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")); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); //绑定页面数据 ZWL.BLL.ERPHuiBao MyModel = new ZWL.BLL.ERPHuiBao(); MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); if (MyModel!=null) { this.TextBox1.Text = MyModel.TitleStr; string CanLookUser = ""; foreach(string C in MyModel.CanLookUser.Split(',')) { string CTrueName = ZWL.DBUtility.DbHelperSQL.GetSHSL("select [TrueName] from ERPUser where [UserName]='" + C + "'"); if(!string.IsNullOrEmpty(CTrueName)) { CanLookUser += CanLookUser == "" ? CTrueName : "," + CTrueName; } else { CanLookUser += CanLookUser == "" ? C : "," + C; } } this.TextBox2.Text = CanLookUser; //显示真实姓名 this.TxtContent.Text = MyModel.ContentStr; this.TextBox3.Text = MyModel.DDWL; //Label1.Text = MyModel.ZT; } ZWL.Common.PublicMethod.SetSessionValue("WenJianList", MyModel.FuJianStr); ZWL.Common.PublicMethod.BindDDL(this.CheckBoxList1, ZWL.Common.PublicMethod.GetSessionValue("WenJianList")); ReturnInput.Value = Request.UrlReferrer.ToString() == null ? "../WorkPlan/HuiBaoM.aspx" : Request.UrlReferrer.ToString(); } }