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;
}
}
