protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
DataEntityDataContext context = new DataEntityDataContext();
POIXX Model = context.POIXX.SingleOrDefault(p => p.ID == int.Parse(Request.QueryString["ID"].ToString()));
var T = context.ERPCommon.Where(p => p.Code == "QDDLX").OrderBy(p => p.CSort);
foreach (var item in T)
{
this.DropDownList1.Items.Add(new ListItem(item.CName, item.CName));
}
this.TextBox1.Text = Model.MC;
this.TextBox3.Text = Model.X;
this.TextBox4.Text = Model.Y;
this.TextBox5.Text = Model.BZ2;
this.DropDownList1.SelectedValue = Model.LX;
this.TxtContent.Text = Model.DZ;
this.ZT.SelectedValue = Model.BZ1;
ReturnInput.Value = Request.UrlReferrer.ToString() == null ? "../QDGL/POI.aspx" : Request.UrlReferrer.ToString();
}
}
public void DataBindToGridview(string IDList)
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPTiKuKaoShi MyLanEmail = new ZWL.BLL.ERPTiKuKaoShi();
var T = context.ERPTiKuKaoShi.Where(p => p.ID>0).OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPNetEmail MyLanEmail = new ZWL.BLL.ERPNetEmail();
var T = context.ERPNetEmail.Where(p => p.FromUser == ZWL.Common.PublicMethod.GetSessionValue("UserName") && p.EmailState == "草稿").OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
public void DataBindToGridview(string IDList)
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPTiKuKaoShi MyLanEmail = new ZWL.BLL.ERPTiKuKaoShi();
var T = context.ERPTiKuKaoShi.Where(p => p.ID>0).OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
protected void btn_Sub_Click(object sender, EventArgs e)
{
DataEntityDataContext context = new DataEntityDataContext();
POIXX Model = new POIXX();
Model.MC = this.TextBox1.Text;
Model.WHRID = ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.X = this.TextBox3.Text;
Model.Y = this.TextBox4.Text;
Model.BZ2 = this.TextBox5.Text;
Model.LX = this.DropDownList1.SelectedValue;
Model.DZ = this.TxtContent.Text;
Model.BZ1 = this.ZT.SelectedValue;
Model.WHSJ = DateTime.Now;
Model.WHR = ZWL.Common.PublicMethod.GetSessionValue("TrueName");
context.POIXX.InsertOnSubmit(Model);
context.SubmitChanges();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户添加POI信息(" + this.TextBox1.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
Response.Write("<script>alert('POI信息添加成功！');window.location.href='POI.aspx'</script>");
}
protected void btn_Sub_Click(object sender, EventArgs e)
{
DataEntityDataContext context = new DataEntityDataContext();
var T = context.system_info.Where(p => p.LX == this.LX.SelectedValue);
if(T.Count() > 0) {
Response.Write("<script>alert('不能重复添加定位参！');</script>");
//ZWL.Common.MessageBox.Show(this, "不能重复添加定位参数！");
}
else {
system_info model = new system_info();
model.LX = this.LX.SelectedValue;
model.CJJGSJ = int.Parse(this.TextBoxname.Text);
model.WHSJ = DateTime.Now;
model.WHRID = ZWL.Common.PublicMethod.GetSessionValue("UserName");
model.WHR = ZWL.Common.PublicMethod.GetSessionValue("TrueName");
context.system_info.InsertOnSubmit(model);
context.SubmitChanges();
////写系统日志
//ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
//MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
//MyRiZhi.DoSomething = "用户添加公共信息(" + this.TextBoxname.Text + ")";
//MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
//MyRiZhi.Add();
Response.Write("<script>alert('定位参数添加成功！');window.location.href='ZXWZ.aspx';</script>");
//ZWL.Common.MessageBox.ShowAndRedirect(this, " 定位参数添加成功 ！", "ZXWZ.aspx");
}
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPPeiXunRiJi MyLanEmail = new ZWL.BLL.ERPPeiXunRiJi();
var T = context.ERPPeiXunRiJi.Where(p => p.ID > 0).OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
protected void btn_Sub_Click(object sender, EventArgs e)
{
DataEntityDataContext context = new DataEntityDataContext();
FenceXX Model = new FenceXX();
Model.MC = this.txt_MC.Text;
Model.WHRID = ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.Coords = this.txt_Coords.Text;
Model.FenceUser = this.UserName_Input.Value;
Model.BZ2 = this.txt_BZ2.Text;
Model.LX = this.ddl_LX.SelectedValue;
Model.DZ = this.txt_DZ.Text;
Model.BZ1 = this.ZT.SelectedValue;
Model.WHSJ = DateTime.Now;
Model.WHR = ZWL.Common.PublicMethod.GetSessionValue("TrueName");
context.FenceXX.InsertOnSubmit(Model);
context.SubmitChanges();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户添加电子围栏(" + this.txt_MC.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
Response.Write("<script>alert('电子围栏添加成功！');window.location.href='Fence.aspx'</script>");
//ZWL.Common.MessageBox.ShowAndRedirect(this, "电子围栏添加成功！", "Fence.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string dirid = "0";
dirid = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 DirID from ERPBuMen where ID='" + ZWL.Common.PublicMethod.GetSessionValue("DepartmentID") + "'");
//BindTree(this.ListTreeView.Nodes, 0);
ListTreeView.Attributes.Add("onclick ", "OnClientTreeNodeChecked(event) ");
string uname = Request["username"];
if ((Request["token"] ?? "") == "ajax" && !string.IsNullOrEmpty(uname))
{
DataEntityDataContext context = new DataEntityDataContext();
var T = context.WZXX.Where(p => p.ID > 0 && p.XM==uname);
T = T.OrderByDescending(p => p.RQ);
string res = "";
var item = T.First();
string Serils = ZWL.DBUtility.DbHelperSQL.GetSHSL("select [Serils] from [ERPUser] where [UserName] ='" + item.XM + "'");
string Fence= ZWL.DBUtility.DbHelperSQL.GetSHSL("select [MC] from [FenceXX] where [FenceUser] ='" + item.XM + "'");
Serils = Serils == "" ? "无" : Serils;
Fence = Fence == "" ? "无" : Fence;
res = item.X + "," + item.Y + "," + item.XM + "," + item.POI + "," + Serils + "," + Fence;
Response.Clear();
Response.Write(res);
Response.End();
}
SettingWorkTime.Visible = ZWL.Common.PublicMethod.StrIFIn("|001A|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
Notice.Visible = ZWL.Common.PublicMethod.StrIFIn("|004|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
AttendanceSel.Visible = ZWL.Common.PublicMethod.StrIFIn("|107|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
WarningSel.Visible = ZWL.Common.PublicMethod.StrIFIn("|109|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
BindTree(this.ListTreeView.Nodes, Convert.ToInt32(dirid));
}
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
foreach (var Fence in context.FenceXX.ToList())
{
string Coords = "";
string[] CoordsList = Fence.Coords.Split(';');
for (int i = 0; i < CoordsList.Length; i++)
{
if ((i + 1) % 3 == 0) //换行
{
Coords += CoordsList[i] + ";" + "<br />";
}
else
{
Coords += CoordsList[i] + ";" + " ";
}
}
Fence.Coords = Coords;
}
var T = context.FenceXX.Where(f => f.ID > 0);
if (!string.IsNullOrEmpty(this.TextBox1.Text))
{
T = T.Where(f => f.MC.Contains(this.TextBox1.Text));
}
GVData.DataSource = T.ToList();
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()
{
DataEntityDataContext context = new DataEntityDataContext();
foreach(var Fence in context.FenceXX.ToList()) {
string Coords = "";
string[] CoordsList = Fence.Coords.Split(';');
for(int i = 0; i < CoordsList.Length; i++) {
if((i + 1) % 3 == 0) { //换行
Coords += CoordsList[i] + ";" + "<br />";
}
else {
Coords += CoordsList[i] + ";" + " ";
}
}
Fence.Coords = Coords;
}
var T = context.FenceXX.Where(f => f.ID > 0);
if(!string.IsNullOrEmpty(this.TextBox1.Text)) {
T = T.Where(f => f.MC.Contains(this.TextBox1.Text));
}
GVData.DataSource = T.ToList();
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()
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPMobile MyLanEmail = new ZWL.BLL.ERPMobile();
var T = context.ERPMobile.Where(p => p.FaSongUser == ZWL.Common.PublicMethod.GetSessionValue("UserName")).OrderByDescending(p => p.ID);
MobileList = T.ToList();
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
ERPNWorkToDo MyLanEmail = new ERPNWorkToDo();
var T = context.ERPNWorkToDo.Where(p => p.StateNow == "正在办理" && p.ShenPiUserList.Contains(ZWL.Common.PublicMethod.GetSessionValue("UserName"))).OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
public void DataBindToGridview()
{
string XiaShuUser = ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 XiaShuUser from ERPUser where UserName='******'");
DataEntityDataContext context = new DataEntityDataContext();
ERPRecive Model = new ERPRecive();
var T = context.ERPRecive.Where(p => p.ID > 0 && p.NowState == "S");
if (!string.IsNullOrEmpty(this.TextBox1.Text))
{
T = T.Where(p => p.HeTongName.Contains(this.TextBox1.Text) || p.QianYueKeHu.Contains(this.TextBox1.Text) || p.SFDK.Contains(this.TextBox1.Text) || p.HTJE.Contains(this.TextBox1.Text));
}
if (!string.IsNullOrEmpty(this.TextBox3.Text))
{
T = T.Where(p => p.DaoKuanDate >= DateTime.Parse(this.TextBox3.Text) || p.TiXingDate >= DateTime.Parse(this.TextBox3.Text) || p.CreateTime >= DateTime.Parse(this.TextBox3.Text));
}
if (!string.IsNullOrEmpty(this.TextBox4.Text))
{
T = T.Where(p => p.DaoKuanDate >= DateTime.Parse(this.TextBox4.Text) || p.TiXingDate >= DateTime.Parse(this.TextBox4.Text) || p.CreateTime >= DateTime.Parse(this.TextBox4.Text));
}
GVData.DataSource = T;
GVData.DataBind();
LabPageSum.Text = Convert.ToString(GVData.PageCount);
LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1));
this.GoPage.Text = LabCurrentPage.Text.ToString();
}
protected void btn_Sub_Click(object sender, EventArgs e)
{
DataEntityDataContext context = new DataEntityDataContext();
var T = context.system_info.Where(p => p.LX == this.LX.SelectedValue);
if (T.Count() > 0)
{
Response.Write("<script>alert('不能重复添加定位参！');</script>");
//ZWL.Common.MessageBox.Show(this, "不能重复添加定位参数！");
}
else
{
system_info model = new system_info();
model.LX = this.LX.SelectedValue;
model.CJJGSJ = int.Parse(this.TextBoxname.Text);
model.WHSJ = DateTime.Now;
model.WHRID = ZWL.Common.PublicMethod.GetSessionValue("UserName");
model.WHR = ZWL.Common.PublicMethod.GetSessionValue("TrueName");
context.system_info.InsertOnSubmit(model);
context.SubmitChanges();
////写系统日志
//ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
//MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
//MyRiZhi.DoSomething = "用户添加公共信息(" + this.TextBoxname.Text + ")";
//MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
//MyRiZhi.Add();
Response.Write("<script>alert('定位参数添加成功！');window.location.href='ZXWZ.aspx';</script>");
//ZWL.Common.MessageBox.ShowAndRedirect(this, " 定位参数添加成功 ！", "ZXWZ.aspx");
}
}
protected void btn_Sub_Click(object sender, EventArgs e)
{
DataEntityDataContext context = new DataEntityDataContext();
POIXX Model = new POIXX();
Model.MC = this.TextBox1.Text;
Model.WHRID = ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.X = this.TextBox3.Text;
Model.Y = this.TextBox4.Text;
Model.BZ2 = this.TextBox5.Text;
Model.LX = this.DropDownList1.SelectedValue;
Model.DZ = this.TxtContent.Text;
Model.BZ1 = this.ZT.SelectedValue;
Model.WHSJ = DateTime.Now;
Model.WHR = ZWL.Common.PublicMethod.GetSessionValue("TrueName");
context.POIXX.InsertOnSubmit(Model);
context.SubmitChanges();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户添加POI信息(" + this.TextBox1.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
Response.Write("<script>alert('POI信息添加成功！');window.location.href='POI.aspx'</script>");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
DataEntityDataContext context = new DataEntityDataContext();
ERPRecive Model = new ERPRecive();
Model = context.ERPRecive.SingleOrDefault(p => p.ID == int.Parse(Request.QueryString["ID"].ToString()));
this.lblHeTongName.Text = Model.HeTongName.ToString();
HeTongName = Model.HeTongName.ToString();
this.lblQianYueKeHu.Text = Model.QianYueKeHu.ToString();
this.lblHeTongMiaoShu.Text = Model.HTJE.ToString();
this.lblShengXiaoDate.Text = Model.TiXingDate.ToString().Replace(" 0:00:00", "");
this.lblTiXingDate.Text = Model.DaoKuanDate.ToString().Replace(" 0:00:00", "");
this.Label1.Text = Model.SFDK;
this.lblCreateTime.Text = Model.CreateTime.ToString();
this.lblCreateUser.Text = Model.CreateUser.ToString();
this.lblBackInfo.Text = Model.BackInfo.ToString();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户查看收款计划信息(" + this.lblHeTongName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
}
}
protected void btn_Sub_Click(object sender, EventArgs e)
{
DataEntityDataContext context = new DataEntityDataContext();
FenceXX Model = context.FenceXX.SingleOrDefault(f => f.ID == int.Parse(Request.QueryString["ID"].ToString()));
Model.MC = this.txt_MC.Text;
Model.WHRID = ZWL.Common.PublicMethod.GetSessionValue("UserName");
string Coords = this.txt_Coords.Text.Replace("\r", "").Replace("\n", "");
Model.Coords = Coords.Remove(Coords.Length - 1);
Model.FenceUser = this.UserName_Input.Value;
Model.BZ2 = this.txt_BZ2.Text;
Model.LX = this.ddl_LX.SelectedValue;
Model.DZ = this.txt_DZ.Text;
Model.BZ1 = this.ZT.SelectedValue;
Model.WHSJ = DateTime.Now;
Model.WHR = ZWL.Common.PublicMethod.GetSessionValue("TrueName");
context.SubmitChanges();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户修改电子围栏信息(" + this.txt_MC.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
Response.Write("<script>alert('电子围栏信息修改成功！');window.location.href='Fence.aspx'</script>");
//ZWL.Common.MessageBox.ShowAndRedirect(this, "电子围栏信息修改成功！", "Fence.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string dirid = "0";
dirid = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 DirID from ERPBuMen where ID='" + ZWL.Common.PublicMethod.GetSessionValue("DepartmentID") + "'");
//BindTree(this.ListTreeView.Nodes, 0);
ListTreeView.Attributes.Add("onclick ", "OnClientTreeNodeChecked(event) ");
string uname = Request["username"];
if ((Request["token"] ?? "") == "ajax" && !string.IsNullOrEmpty(uname))
{
DataEntityDataContext context = new DataEntityDataContext();
var T = context.WZXX.Where(p => p.ID > 0 && p.XM == uname);
T = T.OrderByDescending(p => p.RQ);
string res = "";
var item = T.First();
string Serils = ZWL.DBUtility.DbHelperSQL.GetSHSL("select [Serils] from [ERPUser] where [UserName] ='" + item.XM + "'");
string Fence = ZWL.DBUtility.DbHelperSQL.GetSHSL("select [MC] from [FenceXX] where [FenceUser] ='" + item.XM + "'");
Serils = Serils == "" ? "无" : Serils;
Fence = Fence == "" ? "无" : Fence;
res = item.X + "," + item.Y + "," + item.XM + "," + item.POI + "," + Serils + "," + Fence;
Response.Clear();
Response.Write(res);
Response.End();
}
SettingWorkTime.Visible = ZWL.Common.PublicMethod.StrIFIn("|001A|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
Notice.Visible = ZWL.Common.PublicMethod.StrIFIn("|004|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
AttendanceSel.Visible = ZWL.Common.PublicMethod.StrIFIn("|107|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
WarningSel.Visible = ZWL.Common.PublicMethod.StrIFIn("|109|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
BindTree(this.ListTreeView.Nodes, Convert.ToInt32(dirid));
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
DataEntityDataContext context = new DataEntityDataContext();
ERPYS Model = new ERPYS();
Model.HeTongName = this.txtHeTongName.Text.ToString();
Model.QianYueKeHu = this.txtQianYueKeHu.Text.ToString();
Model.HTJE = this.txtHeTongMiaoShu.Text.ToString();
Model.TiXingDate = DateTime.Parse(this.txtShengXiaoDate.Text);
Model.DaoKuanDate = DateTime.Parse(this.txtTiXingDate.Text);
Model.CreateTime = DateTime.Now;
Model.CreateUser = ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.BackInfo = this.txtBackInfo.Text.ToString();
Model.SFDK = this.DZ.Value;
Model.NowState = "F";
context.ERPYS.InsertOnSubmit(Model);
context.SubmitChanges();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户添加应付计划信息(" + this.txtHeTongName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "应付信息添加成功！", "YF.aspx");
}
protected void btn_Sub_Click(object sender, EventArgs e)
{
DataEntityDataContext context = new DataEntityDataContext();
FenceXX Model = new FenceXX();
Model.MC = this.txt_MC.Text;
Model.WHRID = ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.Coords = this.txt_Coords.Text;
Model.FenceUser = this.UserName_Input.Value;
Model.BZ2 = this.txt_BZ2.Text;
Model.LX = this.ddl_LX.SelectedValue;
Model.DZ = this.txt_DZ.Text;
Model.BZ1 = this.ZT.SelectedValue;
Model.WHSJ = DateTime.Now;
Model.WHR = ZWL.Common.PublicMethod.GetSessionValue("TrueName");
context.FenceXX.InsertOnSubmit(Model);
context.SubmitChanges();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户添加电子围栏(" + this.txt_MC.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
Response.Write("<script>alert('电子围栏添加成功！');window.location.href='Fence.aspx'</script>");
//ZWL.Common.MessageBox.ShowAndRedirect(this, "电子围栏添加成功！", "Fence.aspx");
}
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();
}
protected override void Initialize(HttpControllerContext controllerContext)
{
base.Initialize(controllerContext);
var Header = controllerContext.Request.Headers;
if (Header.Contains("Authorization"))
{
var Token = Header.GetValues("Authorization").First();
using (DataEntityDataContext DB = new DataEntityDataContext())
{
var account = DB.Accounts.Where(u => u.AccessToken == Token).ToList();
if (account.Count > 0)
{
if (account.First().ExpireDate < DateTime.Now)
{
CreateResponseException(HttpStatusCode.Unauthorized, "Token is expire");
}
CurrentAccount = account.First();
}
else
{
CreateResponseException(HttpStatusCode.Unauthorized, "Token is invalid");
}
}
}
else
{
CreateResponseException(HttpStatusCode.Unauthorized, "Access denied");
}
}
protected void btn_Sub_Click(object sender, EventArgs e)
{
DataEntityDataContext context = new DataEntityDataContext();
FenceXX Model = context.FenceXX.SingleOrDefault(f => f.ID == int.Parse(Request.QueryString["ID"].ToString()));
Model.MC = this.txt_MC.Text;
Model.WHRID = ZWL.Common.PublicMethod.GetSessionValue("UserName");
string Coords = this.txt_Coords.Text.Replace("\r", "").Replace("\n", "");
Model.Coords = Coords.Remove(Coords.Length - 1);
Model.FenceUser = this.UserName_Input.Value;
Model.BZ2 = this.txt_BZ2.Text;
Model.LX = this.ddl_LX.SelectedValue;
Model.DZ = this.txt_DZ.Text;
Model.BZ1 = this.ZT.SelectedValue;
Model.WHSJ = DateTime.Now;
Model.WHR = ZWL.Common.PublicMethod.GetSessionValue("TrueName");
context.SubmitChanges();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户修改电子围栏信息(" + this.txt_MC.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
Response.Write("<script>alert('电子围栏信息修改成功！');window.location.href='Fence.aspx'</script>");
//ZWL.Common.MessageBox.ShowAndRedirect(this, "电子围栏信息修改成功！", "Fence.aspx");
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
ERPNWorkToDo MyLanEmail = new ERPNWorkToDo();
var T = context.ERPNWorkToDo.Where(p => p.StateNow == "正在办理" && p.ShenPiUserList.Contains(ZWL.Common.PublicMethod.GetSessionValue("UserName"))).OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPNetEmail MyLanEmail = new ZWL.BLL.ERPNetEmail();
var T = context.ERPNetEmail.Where(p => p.ToUser == ZWL.Common.PublicMethod.GetSessionValue("UserName") && (p.EmailState == "未读" || p.EmailState == "已读")).OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
public void DataBindToGridview(string IDList)
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPXueXiXinDe MyLanEmail = new ZWL.BLL.ERPXueXiXinDe();
var T = context.ERPXueXiXinDe.Where(p => p.ID > 0 && p.UserName == ZWL.Common.PublicMethod.GetSessionValue("UserName")).OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPMobile MyLanEmail = new ZWL.BLL.ERPMobile();
var T = context.ERPMobile.Where(p => p.FaSongUser == ZWL.Common.PublicMethod.GetSessionValue("UserName")).OrderByDescending(p => p.ID);
MobileList = T.ToList();
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPPeiXun MyLanEmail = new ZWL.BLL.ERPPeiXun();
var T = context.ERPPeiXun.Where(p => p.ID > 0).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();
}
protected void QD_Click(object sender, EventArgs e)
{
DataEntityDataContext context = new DataEntityDataContext();
var T = context.ERPHuiBao.SingleOrDefault(p => p.ID == int.Parse(Request.QueryString["ID"].ToString()));
//T.CanLookUser = this.TextBox2.Text;
T.CanLookUser = this.UserName_Input.Value;
context.SubmitChanges();
Response.Write("<script>alert('工作报告转发成功！');window.location.href='" + ReturnInput.Value + "'</script>");
//ZWL.Common.MessageBox.ShowAndRedirect(this, "工作报告转发成功！", "HuiBao.aspx");
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
var T = context.system_info.Where(p => p.ID > 0);
GVData.DataSource = T.ToList();
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()
{
DataEntityDataContext context = new DataEntityDataContext();
var T = context.system_info.Where(p => p.ID > 0);
GVData.DataSource = T.ToList();
GVData.DataBind();
LabPageSum.Text = Convert.ToString(GVData.PageCount);
LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1));
this.GoPage.Text = LabCurrentPage.Text.ToString();
}
protected void QD_Click(object sender, EventArgs e)
{
DataEntityDataContext context = new DataEntityDataContext();
var T = context.ERPHuiBao.SingleOrDefault(p => p.ID == int.Parse(Request.QueryString["ID"].ToString()));
//T.CanLookUser = this.TextBox2.Text;
T.CanLookUser = this.UserName_Input.Value;
context.SubmitChanges();
Response.Write("<script>alert('工作报告转发成功！');window.location.href='" + ReturnInput.Value + "'</script>");
//ZWL.Common.MessageBox.ShowAndRedirect(this, "工作报告转发成功！", "HuiBao.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPGongGao MyModel = new ZWL.BLL.ERPGongGao();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.Label1.Text = MyModel.TitleStr;
this.Label2.Text = ZWL.Common.PublicMethod.GetWenJian(MyModel.FuJian, "../UploadFile/");
this.Label4.Text = MyModel.ContentStr;
this.Label5.Text = MyModel.TimeStr;
this.Label3.Text = ZWL.DBUtility.DbHelperSQL.GetSHSL("select TrueName from ERPUser where UserName ='******'");
string UserNames = "'" + MyModel.UserBuMen.Replace(",", "','") + "'";
DataTable dt = ZWL.DBUtility.DbHelperSQL.GetDataTable("select TrueName from ERPUser where UserName in (" + UserNames + ")");
string TrueName = "";
foreach (DataRow R in dt.Rows)
{
TrueName += TrueName == "" ? R["TrueName"].ToString() : "," + R["TrueName"].ToString();
}
this.Label6.Text = TrueName;
this.Label7.Text = MyModel.Num.ToString();
this.Label8.Text = MyModel.NoticeType.ToString();
this.Label9.Text = MyModel.TypeStr.ToString();
ZWL.DBUtility.DbHelperSQL.ExecuteSQL("update ERPGongGao set num= num+1 where ID=" + Request.QueryString["ID"].ToString());
DataEntityDataContext context = new DataEntityDataContext();
ERPGongGaoYD model = context.ERPGongGaoYD.SingleOrDefault(p => p.FID == int.Parse(Request.QueryString["ID"].ToString()) && p.XM == ZWL.Common.PublicMethod.GetSessionValue("UserName"));
if (model != null)
{
model.SFYY = "是";
model.YDSJ = DateTime.Now;
context.SubmitChanges();
}
//var T = context.ERPGongGaoYD.Where(p => p.FID == int.Parse(Request.QueryString["ID"].ToString()));
DataTable Gdt = ZWL.DBUtility.DbHelperSQL.GetDataTable("SELECT G.[ID],G.[FID],G.[SSBM] ,G.[XM] ,G.[SFYY] ,G.[YDSJ],G.[BZ1],G.[BZ2],U.[TrueName] " +
"FROM [ERPGongGaoYD] as G left join [ERPUser] as U on G.XM=U.UserName " +
"where G.[FID]='" + Request.QueryString["ID"].ToString() + "'");
foreach (DataRow R in Gdt.Rows)
{
if (string.IsNullOrEmpty(R["TrueName"].ToString()))
{
R["TrueName"] = R["XM"];
}
}
this.GVData.DataSource = Gdt;
GVData.DataBind();
ReturnInput.Value = Request.UrlReferrer.ToString() == null ? "../GongGao/GongGao.aspx" : Request.UrlReferrer.ToString();
}
}
public void DataBindToGridview()
{
string XiaShuUser = ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 XiaShuUser from ERPUser where UserName='******'");
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPWorkRiZhi MyModel = new ZWL.BLL.ERPWorkRiZhi();
var T = context.ERPWorkRiZhi.Where(p => p.ID > 0);
if (XiaShuUser != "全部")
{
string[] res = XiaShuUser.Split(',');
T = T.Where(p=>res.Contains(p.UserName)).OrderByDescending(p => p.ID);
}
EmailList = T.ToList();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPGongGao MyModel = new ZWL.BLL.ERPGongGao();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.Label1.Text = MyModel.TitleStr;
this.Label2.Text = ZWL.Common.PublicMethod.GetWenJian(MyModel.FuJian, "../UploadFile/");
this.Label4.Text = MyModel.ContentStr;
this.Label5.Text = MyModel.TimeStr;
this.Label3.Text = ZWL.DBUtility.DbHelperSQL.GetSHSL("select TrueName from ERPUser where UserName ='******'");
string UserNames = "'"+MyModel.UserBuMen.Replace(",","','")+"'";
DataTable dt = ZWL.DBUtility.DbHelperSQL.GetDataTable("select TrueName from ERPUser where UserName in (" + UserNames + ")");
string TrueName = "";
foreach(DataRow R in dt.Rows)
{
TrueName += TrueName == "" ? R["TrueName"].ToString() : "," + R["TrueName"].ToString();
}
this.Label6.Text = TrueName;
this.Label7.Text = MyModel.Num.ToString();
this.Label8.Text = MyModel.NoticeType.ToString();
this.Label9.Text = MyModel.TypeStr.ToString();
ZWL.DBUtility.DbHelperSQL.ExecuteSQL("update ERPGongGao set num= num+1 where ID=" + Request.QueryString["ID"].ToString());
DataEntityDataContext context = new DataEntityDataContext();
ERPGongGaoYD model = context.ERPGongGaoYD.SingleOrDefault(p => p.FID == int.Parse(Request.QueryString["ID"].ToString()) && p.XM == ZWL.Common.PublicMethod.GetSessionValue("UserName"));
if(model!=null)
{
model.SFYY = "是";
model.YDSJ = DateTime.Now;
context.SubmitChanges();
}
//var T = context.ERPGongGaoYD.Where(p => p.FID == int.Parse(Request.QueryString["ID"].ToString()));
DataTable Gdt = ZWL.DBUtility.DbHelperSQL.GetDataTable("SELECT G.[ID],G.[FID],G.[SSBM] ,G.[XM] ,G.[SFYY] ,G.[YDSJ],G.[BZ1],G.[BZ2],U.[TrueName] "+
"FROM [ERPGongGaoYD] as G left join [ERPUser] as U on G.XM=U.UserName "+
"where G.[FID]='"+Request.QueryString["ID"].ToString()+"'");
foreach(DataRow R in Gdt.Rows){
if(string.IsNullOrEmpty(R["TrueName"].ToString())) {
R["TrueName"] = R["XM"];
}
}
this.GVData.DataSource = Gdt;
GVData.DataBind();
ReturnInput.Value = Request.UrlReferrer.ToString() == null ? "../GongGao/GongGao.aspx" : Request.UrlReferrer.ToString();
}
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
var T = context.POIXX.Where(p => p.ID > 0);
if (!string.IsNullOrEmpty(this.TextBox1.Text))
{
T = T.Where(p => p.MC.Contains(this.TextBox1.Text));
}
GVData.DataSource = T.ToList();
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='******'");
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPWorkRiZhi MyModel = new ZWL.BLL.ERPWorkRiZhi();
var T = context.ERPWorkRiZhi.Where(p => p.ID > 0);
if (XiaShuUser != "全部")
{
string[] res = XiaShuUser.Split(',');
T = T.Where(p => res.Contains(p.UserName)).OrderByDescending(p => p.ID);
}
EmailList = T.ToList();
}
public void DataBindToGridview(string IDList)
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPTaskFP MyModel = new ZWL.BLL.ERPTaskFP();
var T = context.ERPTaskFP.Where(p => p.ID > 0);
if (IDList.Trim().Length > 0)
{
T = T.Where(p => p.ToUserList.Contains(',' + ZWL.Common.PublicMethod.GetSessionValue("UserName") + ',') && IDList.Contains(p.ID.ToString())).OrderByDescending(p => p.ID);
}
else
{
T = T.Where(p => p.ToUserList.Contains(',' + ZWL.Common.PublicMethod.GetSessionValue("UserName") + ',')).OrderByDescending(p => p.ID);
}
EmailList = T.ToList();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
//绑定页面数据
DataEntityDataContext context = new DataEntityDataContext();
var T = context.system_info.SingleOrDefault(p => p.ID == int.Parse(Request.QueryString["ID"].ToString()));
this.LX.SelectedValue = T.LX;
this.TextBoxname.Text = T.CJJGSJ.ToString();
ReturnInput.Value = Request.UrlReferrer.ToString() == null ? "../QDGL/ZXWZ.aspx" : Request.UrlReferrer.ToString();
//ZWL.Common.PublicMethod.SetSessionValue("WenJianList", MyModel.FuJianStr);
//ZWL.Common.PublicMethod.BindDDL(this.CheckBoxList1, ZWL.Common.PublicMethod.GetSessionValue("WenJianList"));
}
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
var T = context.POIXX.Where(p => p.ID > 0);
if (!string.IsNullOrEmpty(this.TextBox1.Text))
{
T = T.Where(p => p.MC.Contains(this.TextBox1.Text));
}
GVData.DataSource = T.ToList();
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()
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPGongGao MyLanEmail = new ZWL.BLL.ERPGongGao();
type = Request.QueryString["Type"].ToString().Trim();
if (Request.QueryString["Type"].ToString().Trim() == "单位")
{
var T = context.ERPGongGao.Where(p => p.TypeStr == "单位").OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
else
{
var T = context.ERPGongGao.Where(p => p.TypeStr == "单位").OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
//设置上传的附件为空
DataEntityDataContext context = new DataEntityDataContext();
var T = context.ERPCommon.Where(p => p.Code == "QDDLX").OrderBy(p => p.CSort);
foreach (var item in T)
{
this.DropDownList1.Items.Add(new ListItem(item.CName, item.CName));
}
ReturnInput.Value = Request.UrlReferrer.ToString() == null ? "../QDGL/POI.aspx" : Request.UrlReferrer.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
//设置上传的附件为空
DataEntityDataContext context = new DataEntityDataContext();
var T = context.ERPCommon.Where(p => p.Code == "QDDLX").OrderBy(p => p.CSort);
foreach (var item in T)
{
this.ddl_LX.Items.Add(new ListItem(item.CName, item.CName));
}
ReturnInput.Value = Request.UrlReferrer.ToString() == null ? "../QDGL/Fence.aspx" : Request.UrlReferrer.ToString();
}
}
public void DataBindToGridview(string IDList)
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPTaskFP MyModel = new ZWL.BLL.ERPTaskFP();
var T = context.ERPTaskFP.Where(p => p.ID > 0);
if (IDList.Trim().Length > 0)
{
T = T.Where(p => p.ToUserList.Contains(',' + ZWL.Common.PublicMethod.GetSessionValue("UserName") + ',') && IDList.Contains(p.ID.ToString())).OrderByDescending(p => p.ID);
}
else
{
T = T.Where(p => p.FromUser == ZWL.Common.PublicMethod.GetSessionValue("UserName")).OrderByDescending(p => p.ID);
}
EmailList = T.ToList();
}
//protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
//{
// string FileNameStr = ZWL.Common.PublicMethod.UploadFileIntoDir(this.FileUpload1, DateTime.Now.Ticks.ToString() + System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName));
// if (ZWL.Common.PublicMethod.GetSessionValue("WenJianList").Trim() == "")
// {
// ZWL.Common.PublicMethod.SetSessionValue("WenJianList", FileNameStr);
// }
// else
// {
// ZWL.Common.PublicMethod.SetSessionValue("WenJianList", ZWL.Common.PublicMethod.GetSessionValue("WenJianList") + "|" + FileNameStr);
// }
// ZWL.Common.PublicMethod.BindDDL(this.CheckBoxList1, ZWL.Common.PublicMethod.GetSessionValue("WenJianList"));
//}
//protected void ImageButton3_Click(object sender, ImageClickEventArgs e)
//{
// try
// {
// for (int i = 0; i < this.CheckBoxList1.Items.Count; i++)
// {
// if (this.CheckBoxList1.Items[i].Selected == true)
// {
// ZWL.Common.PublicMethod.SetSessionValue("WenJianList", ZWL.Common.PublicMethod.GetSessionValue("WenJianList").Replace(this.CheckBoxList1.Items[i].Text, "").Replace("||", "|"));
// }
// }
// ZWL.Common.PublicMethod.BindDDL(this.CheckBoxList1, ZWL.Common.PublicMethod.GetSessionValue("WenJianList"));
// }
// catch
// { }
//}
//protected void ImageButton5_Click(object sender, ImageClickEventArgs e)
//{
// try
// {
// if (this.CheckBoxList1.SelectedItem.Text.Trim().Length > 0)
// {
// Response.Write("<script>window.open('../DsoFramer/ReadFile.aspx?FilePath=" + this.CheckBoxList1.SelectedItem.Text + "');</script>");
// }
// }
// catch
// { }
//}
//protected void ImageButton6_Click(object sender, ImageClickEventArgs e)
//{
// try
// {
// if (this.CheckBoxList1.SelectedItem.Text.Trim().Length > 0)
// {
// Response.Write("<script>window.open('../DsoFramer/EditFile.aspx?FilePath=" + this.CheckBoxList1.SelectedItem.Text + "');</script>");
// }
// }
// catch
// { }
//}
protected void btn_Sub_Click(object sender, EventArgs e)
{
DataEntityDataContext context = new DataEntityDataContext();
system_info model = context.system_info.SingleOrDefault(p => p.ID == int.Parse(Request.QueryString["ID"].ToString()));
model.LX = this.LX.SelectedValue;
model.CJJGSJ = int.Parse(this.TextBoxname.Text);
context.SubmitChanges();
////写系统日志
//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='ZXWZ.aspx';</script>");
//ZWL.Common.MessageBox.ShowAndRedirect(this, "定位参数修改成功！", "ZXWZ.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
DataEntityDataContext context = new DataEntityDataContext();
FenceXX Model = context.FenceXX.SingleOrDefault(f => f.ID == int.Parse(Request.QueryString["ID"].ToString()));
var T = context.ERPCommon.Where(p => p.Code == "QDDLX").OrderBy(p => p.CSort);
foreach (var item in T)
{
this.ddl_LX.Items.Add(new ListItem(item.CName, item.CName));
}
this.txt_MC.Text = Model.MC;
string Coords = "";
txt_Coords.Height = 20;
string[] CoordsList = Model.Coords.Split(';');
for (int i = 0, k = 0; i < CoordsList.Length; i++)
{
if ((i) % 2 == 0)
{
k++;
Coords += "\r\n";
txt_Coords.Height = 20 * k;
}
Coords += CoordsList[i] + ";";
}
this.txt_Coords.Text = Coords;
string FenceUsers = "'" + Model.FenceUser.Replace(",", "','") + "'";
DataTable dt = ZWL.DBUtility.DbHelperSQL.GetDataTable("select [TrueName] from ERPUser Where UserName in (" + FenceUsers + ")");
string TrueName = "";
foreach (DataRow R in dt.Rows)
{
TrueName += TrueName == "" ? R["TrueName"] : "," + R["TrueName"];
}
this.txt_FenceUser.Text = TrueName;
this.txt_BZ2.Text = Model.BZ2;
this.ddl_LX.SelectedValue = Model.LX;
this.txt_DZ.Text = Model.DZ;
this.ZT.SelectedValue = Model.BZ1;
ReturnInput.Value = Request.UrlReferrer.ToString() == null ? "../QDGL/Fence.aspx" : Request.UrlReferrer.ToString();
}
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPGongGao MyLanEmail = new ZWL.BLL.ERPGongGao();
type = Request.QueryString["Type"].ToString().Trim();
if (Request.QueryString["Type"].ToString().Trim() == "单位")
{
var T = context.ERPGongGao.Where(p => p.TypeStr == Request.QueryString["Type"].ToString().Trim()).OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
else
{
var T = context.ERPGongGao.Where(p => p.TypeStr == Request.QueryString["Type"].ToString().Trim() && p.UserBuMen == ZWL.Common.PublicMethod.GetSessionValue("Department")).OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPGongGao MyLanEmail = new ZWL.BLL.ERPGongGao();
type = Request.QueryString["Type"].ToString().Trim();
if (Request.QueryString["Type"].ToString().Trim() == "单位")
{
var T = context.ERPGongGao.Where(p => p.TypeStr == "单位").OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
else
{
var T = context.ERPGongGao.Where(p => p.TypeStr == "单位").OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
}
//protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
//{
// string FileNameStr = ZWL.Common.PublicMethod.UploadFileIntoDir(this.FileUpload1, DateTime.Now.Ticks.ToString() + System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName));
// if (ZWL.Common.PublicMethod.GetSessionValue("WenJianList").Trim() == "")
// {
// ZWL.Common.PublicMethod.SetSessionValue("WenJianList", FileNameStr);
// }
// else
// {
// ZWL.Common.PublicMethod.SetSessionValue("WenJianList", ZWL.Common.PublicMethod.GetSessionValue("WenJianList") + "|" + FileNameStr);
// }
// ZWL.Common.PublicMethod.BindDDL(this.CheckBoxList1, ZWL.Common.PublicMethod.GetSessionValue("WenJianList"));
//}
//protected void ImageButton3_Click(object sender, ImageClickEventArgs e)
//{
// try
// {
// for (int i = 0; i < this.CheckBoxList1.Items.Count; i++)
// {
// if (this.CheckBoxList1.Items[i].Selected == true)
// {
// ZWL.Common.PublicMethod.SetSessionValue("WenJianList", ZWL.Common.PublicMethod.GetSessionValue("WenJianList").Replace(this.CheckBoxList1.Items[i].Text, "").Replace("||", "|"));
// }
// }
// ZWL.Common.PublicMethod.BindDDL(this.CheckBoxList1, ZWL.Common.PublicMethod.GetSessionValue("WenJianList"));
// }
// catch
// { }
//}
//protected void ImageButton5_Click(object sender, ImageClickEventArgs e)
//{
// try
// {
// if (this.CheckBoxList1.SelectedItem.Text.Trim().Length > 0)
// {
// Response.Write("<script>window.open('../DsoFramer/ReadFile.aspx?FilePath=" + this.CheckBoxList1.SelectedItem.Text + "');</script>");
// }
// }
// catch
// { }
//}
//protected void ImageButton6_Click(object sender, ImageClickEventArgs e)
//{
// try
// {
// if (this.CheckBoxList1.SelectedItem.Text.Trim().Length > 0)
// {
// Response.Write("<script>window.open('../DsoFramer/EditFile.aspx?FilePath=" + this.CheckBoxList1.SelectedItem.Text + "');</script>");
// }
// }
// catch
// { }
//}
protected void btn_Sub_Click(object sender, EventArgs e)
{
DataEntityDataContext context = new DataEntityDataContext();
system_info model = context.system_info.SingleOrDefault(p => p.ID == int.Parse(Request.QueryString["ID"].ToString()));
model.LX = this.LX.SelectedValue;
model.CJJGSJ = int.Parse(this.TextBoxname.Text);
context.SubmitChanges();
////写系统日志
//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='ZXWZ.aspx';</script>");
//ZWL.Common.MessageBox.ShowAndRedirect(this, "定位参数修改成功！", "ZXWZ.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
DataEntityDataContext context = new DataEntityDataContext();
FenceXX Model = context.FenceXX.SingleOrDefault(f => f.ID == int.Parse(Request.QueryString["ID"].ToString()));
var T = context.ERPCommon.Where(p => p.Code == "QDDLX").OrderBy(p => p.CSort);
foreach (var item in T)
{
this.ddl_LX.Items.Add(new ListItem(item.CName, item.CName));
}
this.txt_MC.Text = Model.MC;
string Coords = "";
txt_Coords.Height=20;
string[] CoordsList= Model.Coords.Split(';');
for(int i = 0,k = 0; i < CoordsList.Length; i++) {
if((i) % 2 == 0) {
k++;
Coords += "\r\n";
txt_Coords.Height = 20*k;
}
Coords += CoordsList[i]+";";
}
this.txt_Coords.Text = Coords;
string FenceUsers ="'"+ Model.FenceUser.Replace(",","','")+"'";
DataTable dt = ZWL.DBUtility.DbHelperSQL.GetDataTable("select [TrueName] from ERPUser Where UserName in (" + FenceUsers + ")");
string TrueName = "";
foreach(DataRow R in dt.Rows) {
TrueName += TrueName == "" ? R["TrueName"] : "," + R["TrueName"];
}
this.txt_FenceUser.Text = TrueName;
this.txt_BZ2.Text = Model.BZ2;
this.ddl_LX.SelectedValue = Model.LX;
this.txt_DZ.Text = Model.DZ;
this.ZT.SelectedValue = Model.BZ1;
ReturnInput.Value = Request.UrlReferrer.ToString() == null ? "../QDGL/Fence.aspx" : Request.UrlReferrer.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
this.txtHeTongName.Attributes.Add("readonly", "true");
this.txtQianYueKeHu.Attributes.Add("readonly", "true");
DataEntityDataContext context = new DataEntityDataContext();
ERPRecive Model = new ERPRecive();
Model = context.ERPRecive.SingleOrDefault(p => p.ID == int.Parse(Request.QueryString["ID"].ToString()));
this.txtHeTongName.Text = Model.HeTongName.ToString();
this.txtQianYueKeHu.Text = Model.QianYueKeHu.ToString();
this.txtHeTongMiaoShu.Text = Model.HTJE.ToString();
this.txtShengXiaoDate.Text = Model.TiXingDate.ToString().Replace(" 0:00:00", "");
this.txtTiXingDate.Text = Model.DaoKuanDate.ToString().Replace(" 0:00:00", "");
this.DZ.Value = Model.SFDK;
this.txtBackInfo.Text = Model.BackInfo.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//BindTree(this.ListTreeView.Nodes, 0);
string dirid = "0";
dirid = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 DirID from ERPBuMen where ID='" + ZWL.Common.PublicMethod.GetSessionValue("DepartmentID") + "'");
BindTree(this.ListTreeView.Nodes, Convert.ToInt32(dirid));
//this.txtYuJiTiXing.Text = DateTime.Now.ToString("yyyy-MM-dd")+" 00:00:00";//只选当天记录;
this.TextBox1.Text = DateTime.Now.ToString();
ListTreeView.Attributes.Add("onclick ", "OnClientTreeNodeChecked(event) ");
string uname = Request["username"];
if ((Request["token"] ?? "") == "ajax" && !string.IsNullOrEmpty(uname) )
{
DataEntityDataContext context = new DataEntityDataContext();
var T = context.WZXX.Where(p => p.ID > 0 && p.XM==uname);
if (!string.IsNullOrEmpty(Request["stime"]))
{
T = T.Where(p => p.RQ >= DateTime.Parse(Request["stime"]));
}
if (!string.IsNullOrEmpty(Request["etime"]))
{
T = T.Where(p => p.RQ <= DateTime.Parse(Request["etime"]));
}
T = T.OrderByDescending(p => p.RQ);
string res = "";
foreach (var item in T)
{
res += item.X + "," + item.Y + "|";
}
Response.Write(res);
Response.End();
}
SettingWorkTime.Visible = ZWL.Common.PublicMethod.StrIFIn("|001A|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
Notice.Visible = ZWL.Common.PublicMethod.StrIFIn("|004|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
AttendanceSel.Visible = ZWL.Common.PublicMethod.StrIFIn("|107|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
WarningSel.Visible = ZWL.Common.PublicMethod.StrIFIn("|109|", ZWL.Common.PublicMethod.GetSessionValue("QuanXian"));
}
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPFileList MyLanEmail = new ZWL.BLL.ERPFileList();
string DirID = "0";
try
{
DirID = Request.QueryString["DirID"].ToString();
}
catch { }
ZWL.BLL.ERPFileList MyModel = new ZWL.BLL.ERPFileList();
if (Request.QueryString["Type"].ToString().Trim() == "个人文件")
{
var T = context.ERPFileList.Where(p => p.UserName == ZWL.Common.PublicMethod.GetSessionValue("UserName") && p.IFDel == "否" && p.TypeName==Request.QueryString["Type"].ToString().Trim() && p.FileType!="dir").OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
else if (Request.QueryString["Type"].ToString().Trim() == "单位文件")
{
var T = context.ERPFileList.Where(p => (p.UserName == ZWL.Common.PublicMethod.GetSessionValue("UserName") || p.CanView.Contains(ZWL.Common.PublicMethod.GetSessionValue("UserName"))) && p.IFDel == "否" && p.TypeName == Request.QueryString["Type"].ToString().Trim() && p.FileType != "dir").OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
else if (Request.QueryString["Type"].ToString().Trim() == "知识库")
{
var T = context.ERPFileList.Where(p => (p.UserName == ZWL.Common.PublicMethod.GetSessionValue("UserName") || p.CanView.Contains(ZWL.Common.PublicMethod.GetSessionValue("UserName"))) && p.IFDel == "否" && p.TypeName == Request.QueryString["Type"].ToString().Trim() && p.FileType != "dir").OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
else if (Request.QueryString["Type"].ToString().Trim() == "共享文件")
{
var T = context.ERPFileList.Where(p => p.IFDel == "否" && p.IfShare=="是").OrderByDescending(p => p.ID);
var TT = context.ERPFileList.Where(p=>p.FileType!="dir" && T.Where(c=>c.DirID==p.DirID).Count()>0);
EmailList = TT.ToList();
}
}
string UserName = ""; //用户名
#endregion Fields
#region Methods
protected void btn_Sub_Click(object sender, EventArgs e)
{
ZWL.BLL.ERPGongGao Model = new ZWL.BLL.ERPGongGao();
Model.TitleStr = this.TextBox1.Text;
Model.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.UserBuMen = this.Send_Person.Value;
Model.NoticeType = this.DropDownList1.SelectedValue;
Model.ZT = this.ZT.SelectedValue;
Model.FuJian = ZWL.Common.PublicMethod.GetSessionValue("WenJianList");
Model.TypeStr = this.TextBox3.Text;
Model.ContentStr = this.TxtContent.Text;
Model.Num = 0;
int id = Model.Add();
DataEntityDataContext context = new DataEntityDataContext();
if(!string.IsNullOrEmpty(this.Send_Person.Value)) {
string[] ss =this.Send_Person.Value.Split(',');
for(int i = 0; i < ss.Length; i++) {
ERPGongGaoYD model = new ERPGongGaoYD();
model.FID = id;
model.SSBM = context.ERPUser.SingleOrDefault(p => p.UserName == ZWL.Common.PublicMethod.GetSessionValue("UserName")).Department;
model.XM = ss[i];
model.SFYY = "否";
model.BZ1 = "";
model.BZ2 = "";
context.ERPGongGaoYD.InsertOnSubmit(model);
context.SubmitChanges();
}
}
//写系统日志
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='GongGao.aspx'</script>");
}
public void DataBindToGridview()
{
DataEntityDataContext context = new DataEntityDataContext();
ZWL.BLL.ERPTongXunLu MyLanEmail = new ZWL.BLL.ERPTongXunLu();
type = Request.QueryString["TypeStr"].ToString().Trim();
if (Request.QueryString["TypeStr"].ToString().Trim() == "公共通讯簿")
{
var T = context.ERPTongXunLu.Where(p => p.TypeStr == Request.QueryString["TypeStr"].ToString().Trim()).OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
else if (Request.QueryString["TypeStr"].ToString().Trim() == "个人通讯簿")
{
var T = context.ERPTongXunLu.Where(p => p.TypeStr == Request.QueryString["TypeStr"].ToString().Trim() && p.UserName == ZWL.Common.PublicMethod.GetSessionValue("UserName")).OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
else
{
//所有共享的通讯录
var T = context.ERPTongXunLu.Where(p => p.IfShare == "是").OrderByDescending(p => p.ID);
EmailList = T.ToList();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
DataEntityDataContext context = new DataEntityDataContext();
Model = context.FenceXX.SingleOrDefault(f => f.ID == int.Parse(Request.QueryString["ID"].ToString()));
var T = context.ERPCommon.Where(p => p.Code == "QDDLX").OrderBy(p => p.CSort);
this.lbl_MC.Text = Model.MC;
string Coords = "";
string[] CoordsList = Model.Coords.Split(';');
for(int i = 0; i < CoordsList.Length;i++ ) {
if((i+1)%4==0) { //换行
Coords += CoordsList[i]+ ";" +"<br />";
}
else {
Coords += CoordsList[i] + ";" + " ";
}
}
this.lbl_Coords.Text = Coords;
string FenceUsers = "'" + Model.FenceUser.Replace(",", "','") + "'";
DataTable dt = ZWL.DBUtility.DbHelperSQL.GetDataTable("select [TrueName] from ERPUser Where UserName in (" + FenceUsers + ")");
string TrueName = "";
foreach(DataRow R in dt.Rows) {
TrueName += TrueName == "" ? R["TrueName"] : "," + R["TrueName"];
}
this.lbl_FenceUser.Text = TrueName;
this.lbl_BZ2.Text = Model.BZ2;
this.lbl_LX.Text = Model.LX;
this.lbl_DZ.Text = Model.DZ;
this.lbl_ZT.Text = Model.BZ1;
ReturnInput.Value = Request.UrlReferrer.ToString() == null ? "../QDGL/Fence.aspx" : Request.UrlReferrer.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
//绑定页面数据
DataEntityDataContext context = new DataEntityDataContext();
var T = context.system_info.SingleOrDefault(p => p.ID == int.Parse(Request.QueryString["ID"].ToString()));
this.LX.SelectedValue = T.LX;
this.TextBoxname.Text = T.CJJGSJ.ToString();
ReturnInput.Value = Request.UrlReferrer.ToString() == null ? "../QDGL/ZXWZ.aspx" : Request.UrlReferrer.ToString();
//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.Common.PublicMethod.SetSessionValue("WenJianList", "");
DataEntityDataContext context = new DataEntityDataContext();
var T = context.ERPCommon.Where(p => p.Code == "TZWJLX").OrderBy(p => p.CSort);
//不是单位通知，那么不显示收阅部门信息
try {
this.Send_Person.Value = Request.QueryString["UserName"];
}
catch {
}
if(Request.UrlReferrer.ToString().IndexOf("Main.aspx") == -1) {
ReturnInput.Value = Request.UrlReferrer.ToString() == null ? "../GongGao/GongGao.aspx" : Request.UrlReferrer.ToString();
}
else {
ReturnInput.Value = "../GongGao/GongGao.aspx";
}
#region //树状图
UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
string Condition = "";
if(UserName != "") {
Condition = " where [UserName]='" + UserName + "'";
}
string Departments = "";
DataTable Udt = ZWL.DBUtility.DbHelperSQL.GetDataTable("select [Department] from [ERPUser] " + Condition);
if(Udt.Rows.Count !=0) {
Departments = Udt.Rows[0][0].ToString();
}
else {
Departments = "";
}
Departments = "'" + Departments.Replace(",", "','") + "'";//拼装IDS，用于SQL语句
//获取角色的部门
DataTable BMdt = ZWL.DBUtility.DbHelperSQL.GetDataTable("select [ID],[DirID] from ERPBuMen where [BuMenName] in (" + Departments + ")");
//foreach(DataRow BMR in BMdt.Rows) {
// QIDS += QIDS == "" ? BMR[0].ToString() : "," + BMR[0].ToString(); //获取用户拥有的权限
// DataTable Ddt = ZWL.DBUtility.DbHelperSQL.GetDataTable("select [ID] from ERPBuMen where [DirID] in (" + BMR[0].ToString() + ") or [ID] in (" + BMR[0].ToString() + ") order by [DirID]");
// //判断是否有存在下级ID，若存在，则保存在IDS
// if(Ddt.Rows.Count > 0) { //若数量大于0.则存在上级菜单
// foreach(DataRow DR in Ddt.Rows) {
// IDS += IDS == "" ? DR[0].ToString() : "," + DR[0].ToString();
// }
// }
//}
this.ListTreeView.Attributes.Add("onclick", "CheckEvent(event)");
string dirid = "0";
dirid = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 DirID from ERPBuMen where ID='" + ZWL.Common.PublicMethod.GetSessionValue("DepartmentID") + "'");
BindTree(this.ListTreeView.Nodes, Convert.ToInt32(dirid));
#endregion
}
}