protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(Request["zId"]))
{
// if (!string.IsNullOrEmpty(Request["zId"]) && !IsPostBack)
Response.Redirect("~/About.aspx");
}
_wz = Int32.Parse(Request["zId"]);
if (User.Identity.Name != "ODS14")
{
Treg.Visible = false; Tzak.Visible = false;
}
if (!IsPostBack)
{
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
DataTable data = db.GetEvent(_wz);
if (data.Rows.Count < 1)
{
Response.Redirect("~/About.aspx");
}
Id.Text = _wz.ToString();
Sourse.Text = data.Rows[0]["Sourse"].ToString();
Text1.Text = data.Rows[0]["Sourse"].ToString();
IO.Text = data.Rows[0]["IO"].ToString();
DataId.Text = data.Rows[0]["DataId"].ToString();
dateReg = ((DateTime)data.Rows[0]["DataId"]);
if (!string.IsNullOrEmpty(data.Rows[0]["DataId"].ToString()))
{
yyy = ((DateTime)data.Rows[0]["DataId"]).Year.ToString();
ddd = ((DateTime)data.Rows[0]["DataId"]).Day.ToString();
momo = ((DateTime)data.Rows[0]["DataId"]).Month.ToString();
hhh = ((DateTime)data.Rows[0]["DataId"]).Hour.ToString();
mmm = ((DateTime)data.Rows[0]["DataId"]).Minute.ToString();
}
RegistrId.Text = data.Rows[0]["RegistrId"].ToString();
LiftId.Text = data.Rows[0]["LiftId"].ToString();
TextBox4.Text = data.Rows[0]["LiftId"].ToString();
TypeId.Text = data.Rows[0]["TypeId"].ToString();
EventId.Text = data.Rows[0]["EventId"].ToString();
Text.Text = data.Rows[0]["EventId"].ToString();
ToApp.Text = data.Rows[0]["ToApp"].ToString();
Text2.Text = data.Rows[0]["ToApp"].ToString();
DateToApp.Text = data.Rows[0]["DateToApp"].ToString();
if (!string.IsNullOrEmpty(data.Rows[0]["DateToApp"].ToString()))
{
yyy1 = ((DateTime)data.Rows[0]["DateToApp"]).Year.ToString();
ddd1 = ((DateTime)data.Rows[0]["DateToApp"]).Day.ToString();
momo1 = ((DateTime)data.Rows[0]["DateToApp"]).Month.ToString();
hhh1 = ((DateTime)data.Rows[0]["DateToApp"]).Hour.ToString();
mmm1 = ((DateTime)data.Rows[0]["DateToApp"]).Minute.ToString();
}
Who.Text = data.Rows[0]["Who"].ToString();
Comment.Text = data.Rows[0]["Comment"].ToString();
Text5.Text = data.Rows[0]["Prim"].ToString();
Prim.Text = data.Rows[0]["Prim"].ToString();
DateWho.Text = data.Rows[0]["DateWho"].ToString();
// TextBox3.Text = data.Rows[0]["DateWho"].ToString();
// if (string.IsNullOrEmpty(TextBox3.Text))
// TextBox3.Text = Convert.ToString(DateTime.Now);
string d = string.Empty;
string d2 = string.Empty, t2 = string.Empty;
TimeSpan pr = DateTime.Now - ((DateTime)data.Rows[0]["DataId"]);
if (!(data.Rows[0]["DateWho"] is DBNull))
{
d2 = ((DateTime)data.Rows[0]["DateWho"]).Date.ToString();
t2 = ((DateTime)data.Rows[0]["DateWho"]).TimeOfDay.ToString();
pr = ((DateTime)data.Rows[0]["DateWho"]) - ((DateTime)data.Rows[0]["DataId"]);
}
if (!(data.Rows[0]["DateToApp"] is DBNull))
{
d = ((DateTime)data.Rows[0]["DateToApp"]).ToString();
}
string prostoy = ((int)pr.TotalDays).ToString() + " " + pr.Hours.ToString() + ":" +
pr.Minutes.ToString();
Timing.Text = prostoy;
{
yyy2 = DateTime.Now.Year.ToString();
ddd2 = DateTime.Now.Day.ToString();
momo2 = DateTime.Now.Month.ToString();
hhh2 = DateTime.Now.Hour.ToString();
mmm2 = DateTime.Now.Minute.ToString();
}
}
//Год/месяц/день
List <string> yy = new List <string>()
{
yyy, "2016", "2017", "2018", "2019", "2020"
};
if (!IsPostBack)
{
YY.DataSource = yy;
YY.DataBind();
YY.SelectedIndex = 0;
}
List <string> yy1 = new List <string>()
{
yyy1, "2016", "2017", "2018", "2019", "2020"
};
if (!IsPostBack)
{
YY1.DataSource = yy1;
YY1.DataBind();
YY1.SelectedIndex = 0;
}
List <string> yy2 = new List <string>()
{
yyy2, "2016", "2017", "2018", "2019", "2020"
};
if (!IsPostBack)
{
YY2.DataSource = yy2;
YY2.DataBind();
YY2.SelectedIndex = 0;
}
List <string> mo = new List <string>()
{
momo, "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12"
};
if (!IsPostBack)
{
MO.DataSource = mo;
MO.DataBind();
MO.SelectedIndex = 0;
}
List <string> mo1 = new List <string>()
{
momo1, "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12"
};
if (!IsPostBack)
{
MO1.DataSource = mo1;
MO1.DataBind();
MO1.SelectedIndex = 0;
}
List <string> mo2 = new List <string>()
{
momo2, "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12"
};
if (!IsPostBack)
{
MO2.DataSource = mo2;
MO2.DataBind();
MO2.SelectedIndex = 0;
}
List <string> dd = new List <string>()
{
ddd, "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31"
};
if (!IsPostBack)
{
DD.DataSource = dd;
DD.DataBind();
DD.SelectedIndex = 0;
}
List <string> dd1 = new List <string>()
{
ddd1, "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31"
};
if (!IsPostBack)
{
DD1.DataSource = dd1;
DD1.DataBind();
DD1.SelectedIndex = 0;
}
List <string> dd2 = new List <string>()
{
ddd2, "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31"
};
if (!IsPostBack)
{
DD2.DataSource = dd2;
DD2.DataBind();
DD2.SelectedIndex = 0;
}
//Часы/минуты
List <string> hh = new List <string>()
{
hhh, "0", "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23"
};
if (!IsPostBack)
{
HH.DataSource = hh;
HH.DataBind();
HH.SelectedIndex = 0;
}
List <string> hh1 = new List <string>()
{
hhh1, "0", "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23"
};
if (!IsPostBack)
{
HH1.DataSource = hh1;
HH1.DataBind();
HH1.SelectedIndex = 0;
}
List <string> hh2 = new List <string>()
{
hhh2, "0", "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23"
};
if (!IsPostBack)
{
HH2.DataSource = hh2;
HH2.DataBind();
HH2.SelectedIndex = 0;
}
List <string> mm = new List <string>()
{
mmm, "05", "10", "15", "20", "25", "30", "35", "40", "45", "50", "55", "00"
};
if (!IsPostBack)
{
MM.DataSource = mm;
MM.DataBind();
MM.SelectedIndex = 0;
}
List <string> mm1 = new List <string>()
{
mmm1, "05", "10", "15", "20", "25", "30", "35", "40", "45", "50", "55", "00"
};
if (!IsPostBack)
{
MM1.DataSource = mm1;
MM1.DataBind();
MM1.SelectedIndex = 0;
}
List <string> mm2 = new List <string>()
{
mmm2, "05", "10", "15", "20", "25", "30", "35", "40", "45", "50", "55", "00"
};
if (!IsPostBack)
{
MM2.DataSource = mm2;
MM2.DataBind();
MM2.SelectedIndex = 0;
}
//Диспетчер
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand("select p.surname, p.name, p.midlename from People p " +
"where p.comments=@user and p.specialty=N'диспетчер'", conn);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
List <string> iodisp = new List <string>()
{
IO.Text
};
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
iodisp.Add(dr[0].ToString() + " " + dr[1].ToString() + " " + dr[2].ToString());
}
dr.Close();
if (!IsPostBack)
{
FIO.DataSource = iodisp;
FIO.DataBind();
FIO.SelectedIndex = 0;
Fdr.Visible = false;
TextBox5.Text = IO.Text;
}
}
//Механик
List <string> worker = new List <string>()
{
ToApp.Text
};
if (!IsPostBack)
{
Workers.DataSource = worker;
Workers0.DataSource = worker;
Workers.DataBind();
Workers0.DataBind();
Workers.SelectedIndex = 0;
Workers0.SelectedIndex = 0;
Worker_TextChanged(this, EventArgs.Empty);
}
if (RegistrId.Text == "Эксплуатация лифтов")
{
Wrk.Visible = true;
Wrk0.Visible = true;
Text2.Visible = false;
Text3.Visible = false;
}
else
{
Wrk.Visible = false;
Wrk0.Visible = false;
Text2.Visible = true;
Text3.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
_role = "ODS_tsg";
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
conn.Open();
SqlCommand cmd;
if (_role == "ODS_tsg")
{
cmd = new SqlCommand("select tt.Ttx, tt.Id from Ttx tt " +
"join LiftsTtx lt on lt.TtxId=tt.Id " +
"join ODSLifts o on o.LiftId=lt.LiftId " +
"join Users u on u.UserId=o.UserId " +
"where tt.TtxTitleId=1 and u.UserName=@userName " +
"group by tt.Ttx, tt.Id", conn);
cmd.Parameters.AddWithValue("userName", User.Identity.Name);
}
else
{
cmd = new SqlCommand("select tt.Ttx, tt.Id from Ttx tt " +
"where tt.TtxTitleId=1 " +
"group by tt.Ttx, tt.Id", conn);
}
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
addresses.Add(new ListData()
{
Title = dr[0].ToString(), Id = Int32.Parse(dr[1].ToString())
});
}
dr.Close();
if (!IsPostBack)
{
Address.DataSource = addresses;
Address.DataBind();
Address.SelectedIndex = 0;
Address_TextChanged(this, EventArgs.Empty);
}
List <string> uslugy = new List <string>()
{
"Эксплуатация лифтов", "Эксплуатация зданий", "Электроснабжение", "Отопление", "Водоснабжение", "Водоотведение", "Охрана", "Клининг"
};
if (!IsPostBack)
{
Uslugy.DataSource = uslugy;
Uslugy.DataBind();
Uslugy.SelectedIndex = 0;
// NLift.Text = "Внести!";
Uslugy_TextChanged(this, EventArgs.Empty);
}
// диспетчеры ОДС
{
cmd = new SqlCommand("select p.surname, p.name, p.midlename from People p " +
"where p.comments=@user and p.specialty=N'диспетчер'", conn);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
}
List <string> iodisp = new List <string>()
{
" "
};
dr = cmd.ExecuteReader();
while (dr.Read())
{
iodisp.Add(dr[0].ToString() + " " + dr[1].ToString() + " " + dr[2].ToString());
}
dr.Close();
if (!IsPostBack)
{
FIO.DataSource = iodisp;
FIO.DataBind();
FIO.SelectedIndex = 0;
Fdr.Visible = true;
}
//Механик
List <string> worker = new List <string>()
{
" "
};
if (!IsPostBack)
{
Workers.DataSource = worker;
Workers.DataBind();
Workers.SelectedIndex = 0;
Worker_TextChanged(this, EventArgs.Empty);
}
//Отправил:
cmd = new SqlCommand("select ui.Family, ui.IO from UserInfo ui " +
"join Users u on u.UserId=ui.UserId where u.UserName=@userName", conn);
cmd.Parameters.AddWithValue("userName", User.Identity.Name);
dr = cmd.ExecuteReader();
if (dr.Read())
{
Disp.Text = dr[0].ToString() + " " + dr[1].ToString();
}
dr.Close();
}
}