protected void IdM_SelectedIndexChanged(object sender, EventArgs e) { App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); List <string> liftId = db.GetLiftId(IdU.SelectedValue, IdM.SelectedValue); LiftId.DataSource = liftId; LiftId.DataBind(); LiftId.SelectedIndex = 0; }
protected void IdM_SelectedIndexChanged(object sender, EventArgs e) { App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); List <string> ls = db.GetLiftId(IdU.SelectedValue, IdM.SelectedValue); List <Lift> data = new List <Lift>(); foreach (string s in ls) { data.Add(new Lift() { Title = s }); } IdL.DataSource = data; IdL.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { CheckAccount(); if (!string.IsNullOrEmpty(Request["PlanId"])) { _planId = Int32.Parse(Request["PlanId"]); } if (!string.IsNullOrEmpty(Request["ret"])) { _retUrl = HttpUtility.HtmlDecode(Request["ret"]); } else { Grafik.Visible = false; } App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); _planIds = db.GetPlans(User.Identity.Name, _planId); _prim = db.GetPrim(User.Identity.Name, _planId); List <TheN> n = new List <TheN>(); foreach (DataRow dr in _prim.Rows) { n.Add(new TheN() { N = (int)dr["N"] }); } _data = db.GetReglamentWorks(_planId); _data.Columns.Add("bDone", Type.GetType("System.Boolean")); _data.Columns.Add("AddPrim", Type.GetType("System.String")); _data.Columns.Add("PrimExists", Type.GetType("System.String")); foreach (DataRow dr in _data.Rows) { if (dr["Done"] is DBNull || bool.Parse(dr["Done"].ToString()) == false) { dr["bDone"] = false; } else { dr["bDone"] = true; } // if (dr["WorksId"] is DBNull) // было закомментировано dr["AddPrim"] = "~/AddPrim.aspx?PlanId=" + _planIds + "&ReglamentId=" + dr["ReglamentId"].ToString(); // else // было закомментировано 2 стр. // dr["AddPrim"] = "~/AddPrim.aspx?WorksId=" + dr["WorksId"].ToString() + "&PlanId=" + _planId + "&ReglamentId=" + dr["ReglamentId"].ToString(); dr["PrimExists"] = ""; if (!(dr["N"] is DBNull)) { int N = (int)dr["N"]; if (n.Find(delegate(TheN i) { return(i.N == N); }) != null) { dr["PrimExists"] = "!!!"; } } } _liftsId = db.GetLiftsId(_planId); _liftId = db.GetLiftId(_planId); /* string liftsId = string.Empty;// начало коммента * foreach (string s in _liftsId) * if (string.IsNullOrEmpty(liftsId)) * liftsId = s; * else * liftsId += "," + s; */ // конец коммента List <Data> data = new List <Data>(); using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { conn.Open(); SqlCommand cmd = new SqlCommand("select TpId from [Plan] where Id=@id", conn); cmd.Parameters.AddWithValue("id", _planId); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { _TpId = dr["TpId"].ToString(); } dr.Close(); } // using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { conn.Open(); TpId.Text = _TpId; LiftsId.Text = _liftId; SqlCommand cmd = new SqlCommand("select r.[Title] from [Reglament] r " + "where r.[TpId]=@rId", conn); /* if (TpId.Text == "ТР") * cmd.Parameters.AddWithValue("rId", "ТР"); * else if (TpId.Text == "ТР1") * cmd.Parameters.AddWithValue("rId", "ТР1"); * else if (TpId.Text == "ТР2") * cmd.Parameters.AddWithValue("rId", "ТР2"); * else if (TpId.Text == "ТР3") * cmd.Parameters.AddWithValue("rId", "ТР3"); * else */ cmd.Parameters.AddWithValue("rId", TpId.Text); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { data.Add(new Data() { Title = dr["Title"].ToString() }); Out.DataSource = data; Out.DataBind(); } dr.Close(); } // if (!IsPostBack) { ReglamentWorks.DataSource = _data; ReglamentWorks.DataBind(); Msg.Text = string.Empty; List <Base.ZPrim> list = db.GetNotDonePrim(_liftId, Request.Url.ToString()); ZPrim.DataSource = list; ZPrim.DataBind(); using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { conn.Open(); SqlCommand cmd = new SqlCommand("select Done from [Plan] where Id=@id", conn); cmd.Parameters.AddWithValue("id", _planId); object o = cmd.ExecuteScalar(); if (o != null) { Done.Checked = bool.Parse(o.ToString()); } cmd = new SqlCommand("select Prn from [Plan] where Id=@id", conn); cmd.Parameters.AddWithValue("id", _planId); string op = cmd.ExecuteScalar().ToString(); if (op == "") { Prin.Checked = false; } else { Prin.Checked = bool.Parse(op.ToString()); } } if (User.Identity.Name == "Volodin" || User.Identity.Name == "Puzin" || User.Identity.Name == "manager") { Prin.Visible = true; btnPrin.Visible = true; } if (TpId.Text == "ВР" && User.Identity.Name == "manager") { AddBP.Visible = true; TextBox1.Visible = true; L1.Visible = true; } } }
protected void AllZPrim(object sender, EventArgs e) { DayPrim.Visible = true; // ReportTitle.Text = "Cобытия по закрепленным лифтам"; using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { conn.Open(); List <Data> data = new List <Data>(); App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); List <string> lift = db.GetLiftId(_user); foreach (string _lift in lift) { SqlCommand cmd = new SqlCommand(); if (_user != "Sargamonov") { s = "select wz.Id, wz.UserId, wz.[Date], ui.Family, ui.IO, e.Id, wz.Done, wz.[Text], wz.[LiftId], wz.Type, wz.Readed from WorkerZayavky wz " + "join UserInfo ui on ui.UserId=wz.UserId " + "join Events e on e.WZayavId=wz.Id " + "where wz.Done=0 and wz.Readed=0 and wz.Type!=N'ПНР/РЭО' and wz.Type=N'замечания по лифтам' and wz.LiftId=@userlift"; } else if (_user == "Sargamonov") { s = "select wz.Id, wz.UserId, wz.[Date], ui.Family, ui.IO, e.Id, wz.Done, wz.[Text], wz.[LiftId], wz.Type, wz.Readed from WorkerZayavky wz " + // "join Events e on e.ZayavId=wz.Id " + "join UserInfo ui on ui.UserId=wz.UserId " + "join Events e on e.WZayavId=wz.Id " + "where wz.Done=0 and wz.Readed=0 and wz.Type=N'ПНР/РЭО' and wz.LiftId=@userlift"; } cmd = new SqlCommand(s, conn); cmd.Parameters.AddWithValue("userlift", _lift); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { data.Add(new Data() { Title = " №" + " " + dr[5].ToString(), Url = "~/WZClose.aspx?wz=" + Int32.Parse(dr["Id"].ToString()), Text1 = dr["Text"].ToString(), Idi = dr["LiftId"].ToString() }); } dr.Close(); List.DataSource = data; List.DataBind(); } } using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { conn.Open(); List <Data> data = new List <Data>(); App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); List <string> lift = db.GetLiftId(_user); foreach (string _lift in lift) { SqlCommand cmd = new SqlCommand(); if (_user != "Sargamonov") { s = "select wz.Id, wz.UserId, wz.[Date], ui.Family, ui.IO, e.Id, wz.Done, wz.[Text], wz.[LiftId], wz.Type, wz.Readed from WorkerZayavky wz " + "join UserInfo ui on ui.UserId=wz.UserId " + "join Events e on e.WZayavId=wz.Id " + "where wz.Done=0 and wz.Readed=1 and wz.Type!=N'ПНР/РЭО' and wz.Type=N'замечания по лифтам' and wz.LiftId=@userlift"; } else if (_user == "Sargamonov") { s = "select wz.Id, wz.UserId, wz.[Date], ui.Family, ui.IO, e.Id, wz.Done, wz.[Text], wz.[LiftId], wz.Type, wz.Readed from WorkerZayavky wz " + // "join Events e on e.ZayavId=wz.Id " + "join UserInfo ui on ui.UserId=wz.UserId " + "join Events e on e.WZayavId=wz.Id " + "where wz.Done=0 and wz.Readed=1 and wz.Type=N'ПНР/РЭО' and wz.LiftId=@userlift"; } cmd = new SqlCommand(s, conn); cmd.Parameters.AddWithValue("userlift", _lift); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { data.Add(new Data() { Title = " №" + " " + dr[5].ToString(), Url = "~/WZClose.aspx?wz=" + Int32.Parse(dr["Id"].ToString()), Text1 = dr["Text"].ToString(), Idi = dr["LiftId"].ToString() }); } dr.Close(); ListNA.DataSource = data; ListNA.DataBind(); } } using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { conn.Open(); List <Data> data = new List <Data>(); App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); List <string> lift = db.GetLiftId(_user); foreach (string _lift in lift) { SqlCommand cmd = new SqlCommand(); if (_user != "Sargamonov") { s = "select wz.Id, wz.UserId, wz.[Date], ui.Family, ui.IO, e.Id, wz.Done, wz.[Text], wz.[LiftId], wz.Type, wz.Readed from WorkerZayavky wz " + "join UserInfo ui on ui.UserId=wz.UserId " + "join Events e on e.WZayavId=wz.Id " + "where wz.Done=0 and wz.Readed=0 and wz.Type!=N'ПНР/РЭО' and wz.Type=N'запчасти и расходные материалы' and wz.LiftId=@userlift"; } else if (_user == "Sargamonov") { s = "select wz.Id, wz.UserId, wz.[Date], ui.Family, ui.IO, e.Id, wz.Done, wz.[Text], wz.[LiftId], wz.Type, wz.Readed from WorkerZayavky wz " + // "join Events e on e.ZayavId=wz.Id " + "join UserInfo ui on ui.UserId=wz.UserId " + "join Events e on e.WZayavId=wz.Id " + "where wz.Done=0 and wz.Readed=0 and wz.Type=N'запчасти и расходные материалы' and ui.Family=N'Саргамонов' and wz.LiftId=@userlift"; } cmd = new SqlCommand(s, conn); cmd.Parameters.AddWithValue("userlift", _lift); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { data.Add(new Data() { Title = " №" + " " + dr[5].ToString(), Url = "~/WZClose.aspx?wz=" + Int32.Parse(dr["Id"].ToString()), Text1 = dr["Text"].ToString(), Idi = dr["LiftId"].ToString() }); } dr.Close(); ListZap.DataSource = data; ListZap.DataBind(); } } using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { conn.Open(); List <Data> data = new List <Data>(); App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); List <string> lift = db.GetLiftId(_user); foreach (string _lift in lift) { SqlCommand cmd = new SqlCommand(); if (_user != "Sargamonov") { s = "select wz.Id, wz.UserId, wz.[Date], ui.Family, ui.IO, e.Id, wz.Done, wz.[Text], wz.[LiftId], wz.Type, wz.Readed from WorkerZayavky wz " + "join UserInfo ui on ui.UserId=wz.UserId " + "join Events e on e.WZayavId=wz.Id " + "where wz.Done=0 and wz.Readed=1 and wz.Type!=N'ПНР/РЭО' and wz.Type=N'запчасти и расходные материалы' and wz.LiftId=@userlift"; } else if (_user == "Sargamonov") { s = "select wz.Id, wz.UserId, wz.[Date], ui.Family, ui.IO, e.Id, wz.Done, wz.[Text], wz.[LiftId], wz.Type, wz.Readed from WorkerZayavky wz " + // "join Events e on e.ZayavId=wz.Id " + "join UserInfo ui on ui.UserId=wz.UserId " + "join Events e on e.WZayavId=wz.Id " + "where wz.Done=0 and wz.Readed=1 and wz.Type=N'запчасти и расходные материалы' and ui.Family=N'Саргамонов' and wz.LiftId=@userlift"; } cmd = new SqlCommand(s, conn); cmd.Parameters.AddWithValue("userlift", _lift); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { data.Add(new Data() { Title = " №" + " " + dr[5].ToString(), Url = "~/WZClose.aspx?wz=" + Int32.Parse(dr["Id"].ToString()), Text1 = dr["Text"].ToString(), Idi = dr["LiftId"].ToString() }); } dr.Close(); ListZapNA.DataSource = data; ListZapNA.DataBind(); } } using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { conn.Open(); List <Data> data = new List <Data>(); App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); List <string> lift = db.GetLiftId(_user); foreach (string _lift in lift) { SqlCommand cmd = new SqlCommand(); if (_user != "Sargamonov") { s = "select wz.Id, wz.UserId, wz.[Date], ui.Family, ui.IO, e.Id, wz.Done, wz.[Text], wz.[LiftId], wz.Type, wz.Readed from WorkerZayavky wz " + "join UserInfo ui on ui.UserId=wz.UserId " + "join Events e on e.WZayavId=wz.Id " + "where wz.Done=0 and wz.Readed=0 and wz.Type!=N'ПНР/РЭО' and wz.Type=N'инструменты и оборудование' and wz.LiftId=@userlift"; } else if (_user == "Sargamonov") { s = "select wz.Id, wz.UserId, wz.[Date], ui.Family, ui.IO, e.Id, wz.Done, wz.[Text], wz.[LiftId], wz.Type, wz.Readed from WorkerZayavky wz " + "join UserInfo ui on ui.UserId=wz.UserId " + "join Events e on e.WZayavId=wz.Id " + "where wz.Done=0 and wz.Readed=0 and wz.Type=N'инструменты и оборудование' and ui.Family=N'Саргамонов' and wz.LiftId=@userlift"; } cmd = new SqlCommand(s, conn); cmd.Parameters.AddWithValue("userlift", _lift); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { data.Add(new Data() { Title = " №" + " " + dr[5].ToString(), Url = "~/WZClose.aspx?wz=" + Int32.Parse(dr["Id"].ToString()), Text1 = dr["Text"].ToString(), Idi = dr["LiftId"].ToString() }); } dr.Close(); ListInst.DataSource = data; ListInst.DataBind(); } } using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { conn.Open(); List <Data> data = new List <Data>(); App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); List <string> lift = db.GetLiftId(_user); foreach (string _lift in lift) { SqlCommand cmd = new SqlCommand(); if (_user != "Sargamonov") { s = "select wz.Id, wz.UserId, wz.[Date], ui.Family, ui.IO, e.Id, wz.Done, wz.[Text], wz.[LiftId], wz.Type, wz.Readed from WorkerZayavky wz " + "join UserInfo ui on ui.UserId=wz.UserId " + "join Events e on e.WZayavId=wz.Id " + "where wz.Done=0 and wz.Readed=1 and wz.Type!=N'ПНР/РЭО' and wz.Type=N'инструменты и оборудование' and wz.LiftId=@userlift"; } else if (_user == "Sargamonov") { s = "select wz.Id, wz.UserId, wz.[Date], ui.Family, ui.IO, e.Id, wz.Done, wz.[Text], wz.[LiftId], wz.Type, wz.Readed from WorkerZayavky wz " + // "join Events e on e.ZayavId=wz.Id " + "join UserInfo ui on ui.UserId=wz.UserId " + "join Events e on e.WZayavId=wz.Id " + "where wz.Done=0 and wz.Readed=1 and wz.Type=N'инструменты и оборудование' and ui.Family=N'Саргамонов' and wz.LiftId=@userlift"; } cmd = new SqlCommand(s, conn); cmd.Parameters.AddWithValue("userlift", _lift); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { data.Add(new Data() { Title = " №" + " " + dr[5].ToString(), Url = "~/WZClose.aspx?wz=" + Int32.Parse(dr["Id"].ToString()), Text1 = dr["Text"].ToString(), Idi = dr["LiftId"].ToString() }); } dr.Close(); ListInstNA.DataSource = data; ListInstNA.DataBind(); } } }