protected void Page_Load(object sender, EventArgs e)
{
CheckAccount();
if (!string.IsNullOrEmpty(Request["lift"]))
{
_liftId = HttpUtility.HtmlDecode(Request["lift"]);
}
if (!string.IsNullOrEmpty(Request["ReturnUrl"]))
{
_url = HttpUtility.HtmlDecode(Request["ReturnUrl"]);
}
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
conn.Open();
SqlCommand 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);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
fam = dr[0].ToString();
}
io = dr[1].ToString();
dr.Close();
}
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
_workers = db.GetWorkers();
if (!IsPostBack)
{
List <string> ls = db.GetIdU();
IdU.DataSource = ls;
IdU.DataBind();
if (ls.Count > 0)
{
IdU.SelectedIndex = 0;
}
IdU_SelectedIndexChanged(sender, e);
string[] ss = { "1", "2" };
Category.DataSource = ss;
Category.DataBind();
Category.SelectedIndex = 0;
db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
List <string> types = db.GetWZTypes();
Type.DataSource = types;
Type.DataBind();
Type.SelectedIndex = 0;
PrimLift_TextChanged(this, EventArgs.Empty);
LiftId_SelectedIndexChanged(this, EventArgs.Empty);
To.DataSource = _workers;
To.DataBind();
To.SelectedIndex = 0;
}
List <string> typeakt = new List <string>()
{
"Акт дефектовки", "Акт повреждения оборудования"
};
List <string> chel = new List <string>()
{
"", "Да", "Нет"
};
List <string> chas = new List <string>()
{
"", "да", "Нет"
};
if (!IsPostBack)
{
TypeAkt.DataSource = typeakt;
TypeAkt.DataBind();
TypeAkt.SelectedIndex = 0;
Chel.DataSource = chel;
Chel.DataBind();
Chel.SelectedIndex = 0;
Chas.DataSource = chas;
Chas.DataBind();
Chas.SelectedIndex = 0;
}
}
