protected void Button2_Click(object sender, EventArgs e) { App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); _workers = db.GetWorkers(); if (!IsPostBack) { DdlSklad1.DataSource = _workers; DdlSklad1.DataBind(); DdlSklad1.SelectedIndex = 0; } using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { conn.Open(); SqlCommand cmd = new SqlCommand("insert into Sklady (DataPost, NumDoc, NumSklada, Zakreplen, Name, NumID, TheNum, Price, Source, Ostatok, Obz) " + " values (@dp, @nd, @ns, @zk, @nm, @ni, @tn, @pr, @so, @os, @obz )", conn); cmd.Parameters.AddWithValue("dp", DateTime.Now); cmd.Parameters.AddWithValue("nd", TextBox1.Text); cmd.Parameters.AddWithValue("ns", SkladVvod.Text); cmd.Parameters.AddWithValue("zk", DdlSklad1.SelectedValue); cmd.Parameters.AddWithValue("nm", TextBox2.Text); cmd.Parameters.AddWithValue("ni", TextBox3.Text); cmd.Parameters.AddWithValue("tn", TextBox4.Text); cmd.Parameters.AddWithValue("pr", TextBox5.Text); cmd.Parameters.AddWithValue("so", TextBox6.Text); cmd.Parameters.AddWithValue("os", TextBox4.Text); cmd.Parameters.AddWithValue("obz", TextBox8.Text); cmd.ExecuteNonQuery(); Sklsdd_Click(sender, e); } TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; TextBox5.Text = ""; TextBox6.Text = ""; TextBox8.Text = ""; }
protected void Page_Load(object sender, EventArgs e) { CheckAccount(); App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); _workers = db.GetWorkers(); _hollidaysType = db.GetWorkTypes(); if (!IsPostBack) { SaveOrClear.DataSource = _soc; SaveOrClear.DataBind(); SaveOrClear.SelectedIndex = 0; HollidaysType.DataSource = _hollidaysType; HollidaysType.DataBind(); HollidaysType.SelectedIndex = 0; Base.UserInfo ui = db.GetUserInfo(_workers[0].UserName); From.Text = ui.HourBeg.ToString(); To.Text = ui.HourEnd.ToString(); Lunch.Text = ui.Lunch.ToString(); DataTable data = db.GetWorkTime(); List <Data> ls = new List <Data>(); foreach (DataRow dr in data.Rows) { ls.Add(new Data() { Name = dr["Family"].ToString() + " " + dr["IO"].ToString(), From = dr["HourBeg"].ToString(), To = dr["HourEnd"].ToString(), Lunch = dr["Lunch"].ToString() }); } Graf.DataSource = ls; Graf.DataBind(); WorkerName.DataSource = _workers; WorkerName.DataBind(); WorkerName.SelectedIndex = 0; List <string> s = db.GetIdU(); IdU.DataSource = s; IdU.DataBind(); if (s.Count > 0) { IdU.SelectedIndex = 0; } IdU_SelectedIndexChanged(sender, e); //Beg.SelectedDate = DateTime.Now.Date; //End.SelectedDate = DateTime.Now.Date.AddMonths(1); Calendar1.SelectedDate = DateTime.Now.Date; Calendar2.SelectedDate = DateTime.Now.Date.AddMonths(1); Calendar3.SelectedDate = DateTime.Now.Date; DHStart.SelectedDate = DateTime.Now.Date; DHEnd.SelectedDate = DateTime.Now.Date.AddMonths(1); Base.PersonData pd = _workers.Find(delegate(Base.PersonData i) { return(i.Title == WorkerName.SelectedValue); }); List <Base.UserLift> ul = db.GetUserLift(pd.Id); AllList.DataSource = ul; AllList.DataBind(); } }
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 (!IsPostBack) { App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); DataTable data = db.GetSklad(_wz); if (data.Rows.Count < 1) { Response.Redirect("~/About.aspx"); } // Id.Text = _wz.ToString(); DataPost.Text = data.Rows[0]["DataPost"].ToString(); NumDoc.Text = data.Rows[0]["NumDoc"].ToString(); NumSklada.Text = data.Rows[0]["NumSklada"].ToString(); Zakreplen.Text = data.Rows[0]["Zakreplen"].ToString(); Prinyal.Text = data.Rows[0]["Prinyal"].ToString(); Name.Text = data.Rows[0]["Name"].ToString(); Obz.Text = data.Rows[0]["Obz"].ToString(); NumID.Text = data.Rows[0]["NumID"].ToString(); TheNum.Text = data.Rows[0]["TheNum"].ToString(); Price.Text = data.Rows[0]["Price"].ToString(); Source.Text = data.Rows[0]["Source"].ToString(); DataSpisaniya.Text = data.Rows[0]["DataSpisaniya"].ToString(); NumDocSpisan.Text = data.Rows[0]["NumDocSpisan"].ToString(); TheNumSpisan.Text = data.Rows[0]["TheNumSpisan"].ToString(); PrimZ.Text = data.Rows[0]["Prim"].ToString(); Ostatok.Text = data.Rows[0]["Ostatok"].ToString(); } if (!IsPostBack) { List <string> dt = new List <string>() { "", "1/1", "1/2", "1/3", "1/4", "2/1", "2/2", "2/3", "2/4", "2/5", "4/1", "4/2" }; NumSklad.DataSource = dt; NumSklad.DataBind(); // SkladVvod.Text = DdlSklad.SelectedValue; App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); _workers = db.GetWorkers(); if (!IsPostBack) { WorkSklad.DataSource = _workers; WorkSklad.DataBind(); WorkSklad.SelectedIndex = 0; } } }
protected void LiftId_SelectedIndexChanged(object sender, EventArgs e) { try { App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); List <string> works = db.GetWorkers(LiftId.SelectedValue); To.DataSource = works; To.DataBind(); To.SelectedIndex = 0; } catch { return; } }
protected void Vvod_Click(object sender, EventArgs e) { phVvod.Visible = true; SkladVvod.Text = DdlSklad.SelectedValue; App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); _workers = db.GetWorkers(); if (!IsPostBack) { DdlSklad1.DataSource = _workers; DdlSklad1.DataBind(); DdlSklad1.SelectedIndex = 0; } }
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"]); } App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); _workers = db.GetWorkers(); if (!IsPostBack) { To.DataSource = _workers; To.DataBind(); To.SelectedIndex = 0; db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); List <string> list = db.GetIdU(); IdU.DataSource = list; IdU.DataBind(); if (!string.IsNullOrEmpty(_liftId)) { string[] s = _liftId.Split('/'); IdU.SelectedValue = s[0]; } else { IdU.SelectedIndex = 0; } IdU_SelectedIndexChanged(sender, e); if (!string.IsNullOrEmpty(_liftId)) { string[] s = _liftId.Split('/'); IdM.SelectedValue = s[1]; IdM_SelectedIndexChanged(sender, e); LiftId.SelectedValue = _liftId; LiftId_SelectedIndexChanged(sender, e); } string[] ss = { "1", "2" }; Category.DataSource = ss; Category.DataBind(); Category.SelectedIndex = 0; } }
protected void Page_Load(object sender, EventArgs e) { _role = CheckAccount(); if (_role == "Worker") { phPost.Visible = false; if (!IsPostBack) { App_Code.Base db1 = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); List <string> _wrk = new List <string>(); _wrk = db1.GetIdUMbyName(User.Identity.Name); DdlSklad.DataSource = _wrk; DdlSklad.DataBind(); } SkladVvod.Text = DdlSklad.SelectedValue; App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); _workers = db.GetWorkers(); if (!IsPostBack) { DdlSklad1.DataSource = _workers; DdlSklad1.DataBind(); DdlSklad1.SelectedIndex = 0; } } else { if (!IsPostBack) { List <string> dt = new List <string>() { "", "1/1", "1/2", "1/3", "1/4", "2/1", "2/2", "2/3", "2/4", "2/5", "4/1", "4/2", "все" }; DdlSklad.DataSource = dt; DdlSklad.DataBind(); SkladVvod.Text = DdlSklad.SelectedValue; } App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); _workers = db.GetWorkers(); if (!IsPostBack) { DdlSklad1.DataSource = _workers; DdlSklad1.DataBind(); DdlSklad1.SelectedIndex = 0; } } }
protected void Page_Load(object sender, EventArgs e) { CheckAccount(); App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); _workers = db.GetWorkers(); if (!IsPostBack) { Worker.DataSource = _workers; Worker.DataBind(); Worker.SelectedIndex = 0; List <string> ls = db.GetIdU(); IdU.DataSource = ls; IdU.DataBind(); if (ls.Count > 0) { IdU.SelectedIndex = 0; } IdU_SelectedIndexChanged(sender, e); } }
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; } }