string CheckAccount()
{
if (string.IsNullOrEmpty(User.Identity.Name))
{
Response.Redirect("~/Account/Login.aspx");
}
List <string> roles = new List <string>()
{
"ODS", "Cadry"
};
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
if (db.CheckAccount(User.Identity.Name, roles))
{
return("ODS");
}
roles = new List <string>()
{
"Administrator"
};
if (db.CheckAccount(User.Identity.Name, roles))
{
return("Administrator");
}
roles = new List <string>()
{
"Manager"
};
if (db.CheckAccount(User.Identity.Name, roles))
{
return("Manager");
}
roles = new List <string>()
{
"Cadry"
};
if (db.CheckAccount(User.Identity.Name, roles))
{
return("Worker");
}
Response.Redirect("~/About.aspx");
return("");
}
void CheckAccount()
{
if (string.IsNullOrEmpty(User.Identity.Name))
{
Response.Redirect("~/Account/Login.aspx?ReturnUrl=~/Enviroment.aspx");
}
List <string> roles = new List <string>()
{
"Administrator", "Manager", "Electronick", "Cadry"
};
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
if (db.CheckAccount(User.Identity.Name, roles))
{
return;
}
Response.Redirect("~/About.aspx");
}
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.GetEvent(_wz);
if (data.Rows.Count < 1)
{
Response.Redirect("~/About.aspx");
}
Id.Text = _wz.ToString();
EventId.Text = data.Rows[0]["EventId"].ToString(); ZaprosMng.Checked = Boolean.Parse(data.Rows[0]["ZaprosMng"].ToString());
DataId.Text = data.Rows[0]["DataId"].ToString(); ZaprosKP.Checked = Boolean.Parse(data.Rows[0]["ZaprosKP"].ToString());
KP.Checked = Boolean.Parse(data.Rows[0]["KP"].ToString());
Comment.Text = data.Rows[0]["Comment"].ToString(); ZapBill.Checked = Boolean.Parse(data.Rows[0]["ZapBill"].ToString());
Prim.Text = data.Rows[0]["Prim"].ToString(); Bill.Checked = Boolean.Parse(data.Rows[0]["Bill"].ToString());
Idz.Text = data.Rows[0]["ZayavId"].ToString(); Payment.Checked = Boolean.Parse(data.Rows[0]["Payment"].ToString());
Idwz.Text = data.Rows[0]["WZayavId"].ToString(); Dostavka.Checked = Boolean.Parse(data.Rows[0]["Dostavka"].ToString());
LiftId.Text = data.Rows[0]["LiftId"].ToString(); Prihod.Checked = Boolean.Parse(data.Rows[0]["Prihod"].ToString());
Sourse.Text = data.Rows[0]["Sourse"].ToString(); Peremeshenie.Checked = Boolean.Parse(data.Rows[0]["Peremeshenie"].ToString());
Family.Text = data.Rows[0]["Family"].ToString(); AktVR.Checked = Boolean.Parse(data.Rows[0]["AktVR"].ToString());
TypeId.Text = data.Rows[0]["TypeId"].ToString(); Spisanie.Checked = Boolean.Parse(data.Rows[0]["Spisanie"].ToString());
ToApp.Text = data.Rows[0]["ToApp"].ToString(); Cansel.Checked = Boolean.Parse(data.Rows[0]["Cansel"].ToString());
DateToApp.Text = data.Rows[0]["DateToApp"].ToString();
Who.Text = data.Rows[0]["Who"].ToString();
DateWho.Text = data.Rows[0]["DateWho"].ToString();
TimeSpan pr = DateTime.Now - ((DateTime)data.Rows[0]["DataId"]);
if (!(data.Rows[0]["DateWho"] is DBNull))
{
pr = ((DateTime)data.Rows[0]["DateWho"]) - ((DateTime)data.Rows[0]["DataId"]);
}
string prostoy = ((int)pr.TotalDays).ToString() + " " + pr.Hours.ToString() + ":" +
pr.Minutes.ToString();
Timing.Text = prostoy;
}
}
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["U"]))
{
idU = HttpUtility.HtmlDecode(Request["U"]);
}
if (!string.IsNullOrEmpty(Request["M"]))
{
idM = HttpUtility.HtmlDecode(Request["M"]);
}
if (!IsPostBack)
{
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
List <App_Code.Base.StoppedLift> list = db.GetStoppedLifts(idU, idM);
Stop.DataSource = list;
Stop.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request["y"]) && !string.IsNullOrEmpty(Request["m"]))
{
_year = Int32.Parse(Request["y"]);
_month = Int32.Parse(Request["m"]);
}
else
{
_year = DateTime.Now.Year;
_month = DateTime.Now.Month;
}
_role = CheckAccount();
if (!IsPostBack)
{
if (_role == "ODS")
{
Qst.Visible = false;
Out.Visible = true;
}
else
{
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
List <string> ls = db.GetIdU();
IdU.DataSource = ls;
IdU.DataBind();
if (ls.Count > 0)
{
IdU.SelectedIndex = 0;
}
IdU_SelectedIndexChanged(sender, e);
PeriodBeg.SelectedDate = DateTime.Now.AddMonths(-1);
PeriodEnd.SelectedDate = DateTime.Now;
Type.DataSource = LiftsReport._types;
Type.DataBind();
Type.SelectedIndex = 0;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(Request["day"]))
{
_date = DateTime.Now.Date;
}
else
{
_date = DateTime.Parse(HttpUtility.HtmlDecode(Request["day"]));
}
DateTime d2 = _date.AddDays(1);
_user = Page.User.Identity.Name;
if (!string.IsNullOrEmpty(Request["user"]))
{
_user = HttpUtility.HtmlDecode(Request["user"]);
}
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
_userInfo = db.GetUserInfo(_user);
_data = db.GetPlan(_user, _date, d2);
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
if (_role == "ODS" || _role == "Cadry")
{
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
List <string> lifts = db.GetODSLiftList(User.Identity.Name);
LiftsRep.Set(lifts, new DateTime(_year, _month, 1),
new DateTime(_year, _month, DateTime.DaysInMonth(_year, _month)), "Всё", _role); //"Всё"
if (_month > 1)
{
PrevMonth.Text = KOS.App_Code.Base.months[_month - 2] + " " + _year.ToString();
PrevMonth.NavigateUrl = "~/Lifts.aspx?y=" + _year.ToString() + "&m=" + (_month - 1).ToString();
}
else
{
PrevMonth.Text = KOS.App_Code.Base.months[11] + " " + (_year - 1).ToString();
PrevMonth.NavigateUrl = "~/Lifts.aspx?y=" + (_year - 1).ToString() + "&m=12";
}
if (_month < 12)
{
NextMonth.Text = KOS.App_Code.Base.months[_month] + " " + _year.ToString();
NextMonth.NavigateUrl = "~/Lifts.aspx?y=" + _year.ToString() + "&m=" + (_month + 1).ToString();
}
else
{
NextMonth.Text = KOS.App_Code.Base.months[0] + " " + (_year + 1).ToString();
NextMonth.NavigateUrl = "~/Lifts.aspx?y=" + (_year + 1).ToString() + "&m=1";
}
phGo.Visible = true;
}
else
{
List <string> lifts = GetSelectedTitles(IdL);
LiftsRep.Set(lifts, PeriodBeg.SelectedDate, PeriodEnd.SelectedDate.AddDays(1), Type.SelectedValue, _role);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (User.Identity.Name == "Миракс_Парк")
{
PinAdmin.Visible = false;
PinDisp.Visible = false;
use = "ОДС13";
}
else if (User.Identity.Name == "Корона_1")
{
PinAdmin1.Visible = false;
PinDisp1.Visible = false;
use = "ОДС14";
}
else
{
return;
}
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
DataTable data = db.GetPin(Pn.Text, use);
try
{
Text.Text = "Здравствуйте, " + data.Rows[0]["surname"].ToString() + " " + data.Rows[0]["name"].ToString() + data.Rows[0]["midlename"].ToString() + "!";
if (User.Identity.Name == "Корона_1")
{
PinAdmin.Visible = true; PinDisp.Visible = true;
}
if (User.Identity.Name == "Миракс_Парк")
{
PinAdmin1.Visible = true; PinDisp1.Visible = true;
}
Vpin.Visible = false;
}
catch { Msg.Text = "Пароль не верный, введите правильный пароль или обратитесь к аминистратору КОС!"; return; }
}
string CheckAccount()
{
if (string.IsNullOrEmpty(User.Identity.Name))
{
Response.Redirect("~/Account/Login.aspx?ReturnUrl=~/Zayavka.aspx");
}
List <string> roles = new List <string>()
{
"ODS"
};
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
if (db.CheckAccount(User.Identity.Name, roles))
{
XmlDocument doc = new XmlDocument();
if (!File.Exists(ipConfig))
{
SaveFirst(doc);
}
XmlTextReader reader = new XmlTextReader(ipConfig);
doc.Load(reader);
XmlNode ipx = doc["zayavka"][User.Identity.Name];
reader.Close();
if (ipx != null && ipx.HasChildNodes)
{
for (int i = 0; i < ipx.ChildNodes.Count; i++)
{
string ip = ipx.ChildNodes[i].InnerText;
if (ip == Request.UserHostAddress || ip == "*")
{
return("ODS");
}
}
Response.Redirect("~/About.aspx");
}
else
{
SaveNext(doc);
}
return("ODS");
}
roles = new List <string>()
{
"Administrator", "Cadry"
};
if (db.CheckAccount(User.Identity.Name, roles))
{
return("Administrator");
}
roles = new List <string>()
{
"Manager"
};
if (db.CheckAccount(User.Identity.Name, roles))
{
return("Manager");
}
roles = new List <string>()
{
"Worker"
};
if (db.CheckAccount(User.Identity.Name, roles))
{
return("Worker");
}
roles = new List <string>()
{
"Cadry "
};
if (db.CheckAccount(User.Identity.Name, roles))
{
return("Cadry");
}
Response.Redirect("~/About.aspx");
return(null);
}
string BuildWhere()
{
string s = BuildWorkerWhere();
if (s == null)
{
return(s);
}
if (_role == "Worker")
{
if (string.IsNullOrEmpty(s))
{
s = "where ";
}
else
{
s += "and ";
}
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
App_Code.Base.UserInfo ui = db.GetUserInfo(Page.User.Identity.Name);
WorkerData awd = workerData.Find(delegate(WorkerData wd)
{
return(wd.Title == ui.Family + " " + ui.IO);
});
if (awd != null)
{
s += "p.UserId='" + awd.Id + "' ";
}
else
{
return(null);
}
}
else if (!IsAllSelected(Worker) || workerData.Count == 1)
{
List <string> ls = GetSelectedTitles(Worker);
string ss = string.Empty;
foreach (string i in ls)
{
WorkerData awd = workerData.Find(delegate(WorkerData wd)
{
return(wd.Title == i);
});
if (awd != null)
{
ss += (string.IsNullOrEmpty(ss) ? "" : ",") + "'" + awd.Id + "'";
}
}
if (!string.IsNullOrEmpty(ss))
{
if (string.IsNullOrEmpty(s))
{
s = "where ";
}
else
{
s += "and ";
}
s += "p.UserId in (" + ss + ") ";
}
else
{
return(null);
}
}
if (!IsAllSelected(Done))
{
List <string> ls = GetSelectedTitles(Done);
int done = 0;
if (ls.Count > 0)
{
if (ls[0] == "выполнено")
{
done = 1;
}
}
else
{
return(null);
}
if (string.IsNullOrEmpty(s))
{
s = "where ";
}
else
{
s += "and ";
}
s += "p.[Done]=" + done.ToString() + " ";
}
if (s != null)
{
if (string.IsNullOrEmpty(s))
{
s = "where ";
}
else
{
s += "and ";
}
s += "p.[Date] between @DateStart and @DateEnd ";
}
return(s);
}
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"]);
ZayavId.Text = data.Rows[0]["ZayavId"].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();
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();
// clos = ((DateTime)data.Rows[0]["DateWho"]);
Date.Text = DateTime.Now.ToLongDateString();
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;
DocName.Text = "документ";
//Год/месяц/день
/* List<string> xx = new List<string>() { "Акт неисправности", "Акт внеплановых работ", "Платежное поручение", "Счет" };
* if (!IsPostBack)
* {
* DocName.DataSource = xx;
* DocName.DataBind();
* DocName.SelectedIndex = 0;
* } */
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand("select count(d.Id) from Documents d" +
" where d.NumEvent=@id and d.Usr=@usr", conn);
cmd.Parameters.AddWithValue("id", _wz);
cmd.Parameters.AddWithValue("usr", User.Identity.Name);
UsrDoc.Text = cmd.ExecuteScalar().ToString();
}
List <Data> datadoc = GetData();
Out.DataSource = datadoc;
Out.DataBind();
List <Data> datdoc = GetData1();
Out1.DataSource = datdoc;
Out1.DataBind();
// DocPodp.Visible = true;
}
}
void FillLabels()
{
lPrinyalDate.Text = " с " + Calendar.SelectedDate.ToLongDateString() + " по " +
CalendarEnd.SelectedDate.ToLongDateString();
if (IsAllSelected(IdU))
{
lU.Text = " любой";
}
else
{
List <string> ls = GetSelectedTitles(IdU);
for (int i = 0; i < ls.Count; i++)
{
if (i == 0)
{
lU.Text = ls[i];
}
else
{
lU.Text += ", " + ls[i];
}
}
}
if (IsAllSelected(IdM))
{
lM.Text = " любой";
}
else
{
List <string> ls = GetSelectedTitles(IdM);
for (int i = 0; i < ls.Count; i++)
{
if (i == 0)
{
lM.Text = ls[i];
}
else
{
lM.Text += ", " + ls[i];
}
}
}
if (IsAllSelected(IdL))
{
lL.Text = " любой";
}
else
{
List <string> ls = GetSelectedTitles(IdL);
for (int i = 0; i < ls.Count; i++)
{
if (i == 0)
{
lL.Text = ls[i];
}
else
{
lL.Text += ", " + ls[i];
}
}
}
if (IsAllSelected(Address))
{
if (GetSelectedTitles(IdU).Count == 1 && GetSelectedTitles(IdM).Count == 1)
{
KOS.App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
List <string> ls = db.GetAddress(GetSelectedTitles(IdU)[0], GetSelectedTitles(IdM)[0]);
lAddress.Text = string.Empty;
foreach (string s in ls)
{
if (!string.IsNullOrEmpty(lAddress.Text))
{
lAddress.Text += ", ";
}
lAddress.Text += s;
}
}
else
{
lAddress.Text = " любой";
}
}
else
{
List <string> ls = GetSelectedTitles(Address);
for (int i = 0; i < ls.Count; i++)
{
if (i == 0)
{
lAddress.Text = ls[i];
}
else
{
lAddress.Text += ", " + ls[i];
}
}
}
if (IsAllSelected(WorkType))
{
lWorkType.Text = " любой";
}
else
{
List <string> ls = GetSelectedTitles(WorkType);
for (int i = 0; i < ls.Count; i++)
{
if (i == 0)
{
lWorkType.Text = ls[i];
}
else
{
lWorkType.Text += ", " + ls[i];
}
}
}
if (_role == "Worker")
{
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
App_Code.Base.UserInfo ui = db.GetUserInfo(Page.User.Identity.Name);
lWorker.Text = ui.Family + " " + ui.IO;
}
else if (IsAllSelected(Worker))
{
lWorker.Text = " любой";
}
else
{
List <string> ls = GetSelectedTitles(Worker);
for (int i = 0; i < ls.Count; i++)
{
if (i == 0)
{
lWorker.Text = ls[i];
}
else
{
lWorker.Text += ", " + ls[i];
}
}
}
if (IsAllSelected(Done))
{
lDone.Text = " любое состояние";
}
else
{
List <string> ls = GetSelectedTitles(Done);
if (ls.Count > 0)
{
lDone.Text = ls[0];
}
}
}
void FillLabels()
{
lDate.Text = " с " + Start.SelectedDate.ToLongDateString() + " по " +
End.SelectedDate.ToLongDateString();
if (IsAllSelected(IdU))
{
lU.Text = " любой";
}
else
{
lU.Text = GetSelected(IdU);
}
if (IsAllSelected(IdM))
{
lM.Text = " любой";
}
else
{
lM.Text = GetSelected(IdM);
}
if (IsAllSelected(IdL))
{
lL.Text = " любой";
}
else
{
lL.Text = GetSelected(IdL);
}
if (IsAllSelected(Address))
{
if (GetSelectedTitles(IdU).Count == 1 && GetSelectedTitles(IdM).Count == 1)
{
KOS.App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
List <string> ls = db.GetAddress(GetSelectedTitles(IdU)[0], GetSelectedTitles(IdM)[0]);
lAddress.Text = string.Empty;
foreach (string s in ls)
{
if (!string.IsNullOrEmpty(lAddress.Text))
{
lAddress.Text += ", ";
}
lAddress.Text += s;
}
}
else
{
lAddress.Text = " любой";
}
}
else
{
lAddress.Text = GetSelected(Address);
}
if (IsAllSelected(Category))
{
lCategory.Text = " любая";
}
else
{
lCategory.Text = GetSelected(Category);
}
if (IsAllSelected(Done))
{
lDone.Text = " любые";
}
else
{
lDone.Text = GetSelected(Done);
}
}
protected void Page_Load(object sender, EventArgs e)
{
CheckAccount();
if (!string.IsNullOrEmpty(Request["id"]))
{
_id = Int32.Parse(Request["id"]);
phAddRecord.Visible = false;
phEditRecord.Visible = true;
}
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
_data = db.GetUsers();
List <string> roles = new List <string>()
{
"Administrator", "Manager", "Cadry"
};
if (!db.CheckAccount(User.Identity.Name, roles))
{
Select.SelectCommand = "select j.*, uf.Family+' '+uf.IO as FromFIO, ut.Family+' '+ut.IO as ToFIO, '~/Journal.aspx?id='+CAST(j.Id as nvarchar) as Url " +
"from [Journal] j left join UserInfo uf on uf.UserId=j.[From] left join UserInfo ut on ut.UserId=j.[To] " +
"join Users u1 on u1.UserId=j.[From] or j.[From] is null " +
"join Users u2 on u2.UserId=j.[To] or j.[To] is null " +
"where (j.[From] is not null and u1.UserName=N'" + User.Identity.Name + "') " +
"or (j.[To] is not null and u2.UserName=N'" + User.Identity.Name + "') " +
"order by j.[Begin] desc";
}
if (!IsPostBack)
{
AddTo.DataSource = _data;
AddTo.DataBind();
AddTo.SelectedIndex = 0;
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
conn.Open();
/*
* SqlCommand cmd = new SqlCommand("select * from [Journal] order by [Begin] desc", conn);
* SqlDataReader dr = cmd.ExecuteReader();
* List<Data> data = new List<Data>();
* while (dr.Read())
* {
* data.Add(new Data()
* {
* Id = dr["Id"].ToString(),
* Url = "~/Journal.aspx?id=" + dr["Id"].ToString(),
* Role = dr["Role"].ToString(),
* Page = dr["Page"].ToString(),
* Description = dr["Description"].ToString(),
* Begin = ((DateTime)dr["Begin"]).Date.ToShortDateString(),
* End = dr["End"] is DBNull ? "" : ((DateTime)dr["End"]).Date.ToShortDateString(),
* Prim = dr["Prim"] is DBNull ? "" : dr["Prim"].ToString()
* });
* }
* dr.Close();
* Table.DataSource = data;
* Table.DataBind();
*/
if (_id > 0)
{
SqlCommand cmd = new SqlCommand("select j.*, uif.Family as FromF, uif.IO as FromIO, uit.Family as ToF, uit.IO as ToIO from [Journal] j " +
"left join UserInfo uit on uit.UserId=j.[To] " +
"left join UserInfo uif on uif.UserId=j.[From] where j.Id=@id", conn);
cmd.Parameters.AddWithValue("id", _id);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
EditRole.Text = dt.Rows[0]["Role"].ToString();
EditPage.Text = dt.Rows[0]["Page"].ToString();
EditDescription.Text = dt.Rows[0]["Description"].ToString();
if (!(dt.Rows[0]["Prim"] is DBNull))
{
EditPrim.Text = dt.Rows[0]["Prim"].ToString();
}
if (!(dt.Rows[0]["FromF"] is DBNull))
{
EditFrom.Text = dt.Rows[0]["FromF"].ToString() + " " + dt.Rows[0]["FromIO"].ToString();
}
if (!(dt.Rows[0]["ToF"] is DBNull))
{
EditTo.Text = dt.Rows[0]["ToF"].ToString() + " " + dt.Rows[0]["ToIO"].ToString();
}
}
}
}
}
string BuildWhere()
{
string s = string.Empty;
s = " where wz.[Date] between @start and @end";
if (_role == "Worker")
{
if (SelectDone.Checked && SelectNotDone.Checked)
{
lType.Text = "все";
}
else if (SelectDone.Checked)
{
s += " and wz.[Done]=1";
lType.Text = "прорабу";
}
else if (SelectNotDone.Checked)
{
s += " and wz.[Done]=0";
lType.Text = "механик";
}
else
{
return(null);
}
}
else
{
if (!IsAllSelected(Type))
{
s += " and wz.[Done]=";
List <string> sel = GetSelectedTitles(Type);
if (sel.Count < 1)
{
return(null);
}
if (sel[0] == _type[0].Title)
{
s += "1";
}
else
{
s += "0";
}
lType.Text = sel[0];
}
else
{
lType.Text = "все";
}
}
if (_role == "Worker")
{
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
App_Code.Base.UserInfo ui = db.GetUserInfo(Page.User.Identity.Name);
lFrom.Text = ui.Family + " " + ui.IO;
Base.PersonData pd = workerData.Find(delegate(Base.PersonData p)
{
return(p.Title == lFrom.Text);
});
if (pd == null)
{
return(null);
}
s += " and wz.UserId='" + pd.Id + "'";
}
else if (!IsAllSelected(From))
{
string from = string.Empty;
List <string> sel = GetSelectedTitles(From);
if (sel.Count < 1)
{
return(null);
}
foreach (string f in sel)
{
Base.PersonData pd = workerData.Find(delegate(Base.PersonData p)
{
return(p.Title == f);
});
if (pd != null)
{
if (!string.IsNullOrEmpty(from))
{
from += ",";
}
from += pd.Id;
if (!string.IsNullOrEmpty(lFrom.Text))
{
lFrom.Text += ", ";
}
lFrom.Text += f;
}
}
if (!string.IsNullOrEmpty(from))
{
s += " and wz.UserId in (" + from + ")";
}
}
else
{
lFrom.Text = "от всех";
}
return(s);
}
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();
}
}
}
protected void LiftId_SelectedIndexChanged(object sender, EventArgs e)
{
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
To.SelectedValue = db.GetWorker(LiftId.SelectedValue);
}
protected void Page_Load(object sender, EventArgs e)
{
CheckAccount();
_from = DateTime.Now.AddDays(-2);
// Label1.Text = "С " + _from.ToString();
// if (!IsPostBack)
// CheckAccount();
// _from = DateTime.Now.AddDays(-2);
// Label1.Text = "С " + _from.ToString();
/* CurDate.Text = DateTime.Now.Date.ToLongDateString();
* CurHour.Text = DateTime.Now.Hour.ToString();
* CurMinute.Text = DateTime.Now.Minute.ToString(); */
if (!IsPostBack)
{
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
conn.Open();
// все события
SqlCommand cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
// Text2 = cmd.ExecuteScalar().ToString();
HyperLink2.Text = cmd.ExecuteScalar().ToString();
// срочные события - 2 дня
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Cansel=N'false' and e.DataId<=@date and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
Text2 = cmd.ExecuteScalar().ToString();
HyperLink3.Text = cmd.ExecuteScalar().ToString();
// все события без Акта
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.ZaprosMng=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
// Text4 = cmd.ExecuteScalar().ToString();
HyperLink5.Text = cmd.ExecuteScalar().ToString();
// срочные события без Акта
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.ZaprosMng=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
Text3 = cmd.ExecuteScalar().ToString();
HyperLink6.Text = cmd.ExecuteScalar().ToString();
// все события с запросом manager
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.ZaprosKp=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
// Text4 = cmd.ExecuteScalar().ToString();
HyperLink8.Text = cmd.ExecuteScalar().ToString();
// срочные события с запросом КП
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.ZaprosKp=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
Text4 = cmd.ExecuteScalar().ToString();
HyperLink9.Text = cmd.ExecuteScalar().ToString();
// все события с ответом КП
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.KP=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
// Text4 = cmd.ExecuteScalar().ToString();
HyperLink11.Text = cmd.ExecuteScalar().ToString();
// срочные события с ответом КП
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.KP=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
Text5 = cmd.ExecuteScalar().ToString();
HyperLink12.Text = cmd.ExecuteScalar().ToString();
// все события с запросом счета
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.ZapBill=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
// Text4 = cmd.ExecuteScalar().ToString();
HyperLink14.Text = cmd.ExecuteScalar().ToString();
// срочные события с запросом счета
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.ZapBill=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
// Text6 = cmd.ExecuteScalar().ToString();
HyperLink15.Text = cmd.ExecuteScalar().ToString();
// все события со счетами
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Bill=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
HyperLink17.Text = cmd.ExecuteScalar().ToString();
// срочные события со счетами
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Bill=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink18.Text = cmd.ExecuteScalar().ToString();
// все события с ожиданием оплаты
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Payment=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
HyperLink20.Text = cmd.ExecuteScalar().ToString();
// срочные события с ожиданием оплаты
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Payment=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink21.Text = cmd.ExecuteScalar().ToString();
// все события с ожиданием доставки
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Dostavka=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
HyperLink35.Text = cmd.ExecuteScalar().ToString();
// срочные события с ожиданием доставки
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Dostavka=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink36.Text = cmd.ExecuteScalar().ToString();
// все события с ожиданием прихода
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Prihod=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
HyperLink38.Text = cmd.ExecuteScalar().ToString();
// срочные события с ожиданием прихода
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Prihod=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink39.Text = cmd.ExecuteScalar().ToString();
// все события с ожиданием акта ВР
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.AktVR=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
HyperLink41.Text = cmd.ExecuteScalar().ToString();
// срочные события с ожиданием акта ВР
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.AktVR=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink42.Text = cmd.ExecuteScalar().ToString();
// все события с ожиданием списания
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Spisanie=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
HyperLink44.Text = cmd.ExecuteScalar().ToString();
// срочные события с ожиданием списания
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Spisanie=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink45.Text = cmd.ExecuteScalar().ToString();
//Блок ОДС ----------------------------------------------------------
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join Users u on z.UserId=u.UserId " +
"where z.Category=N'застревание' and z.Finish is null and u.UserName=@user", conn);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
Text2 = cmd.ExecuteScalar().ToString();
// HyperLink2.Text = cmd.ExecuteScalar().ToString();
// плановые работы
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join Users u on z.UserId=u.UserId " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='ODS' " +
"where z.Category=N'плановые работы' and z.Finish is null and u.UserName=@user", conn);
cmd.Parameters.AddWithValue("date", _from);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
Text3 = cmd.ExecuteScalar().ToString();
// HyperLink3.Text = cmd.ExecuteScalar().ToString();
// внеплановые ремонты
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join Users u on z.UserId=u.UserId " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='ODS' " +
"where z.Category=N'внеплановые ремонты' and z.Finish is null and u.UserName=@user", conn);
cmd.Parameters.AddWithValue("date", _from);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
Text8 = cmd.ExecuteScalar().ToString();
// HyperLink8.Text = cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join Users u on z.UserId=u.UserId " +
"where z.Category=N'останов' and z.Finish is null and u.UserName=@user", conn);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
Text4 = cmd.ExecuteScalar().ToString();
// HyperLink4.Text = cmd.ExecuteScalar().ToString();
//заявки от заказчика
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='ODS' " +
"join Users u on z.UserId=u.UserId " +
"where z.Finish is null and z.Category=N'заявка'and u.UserName=@user", conn);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
// HyperLink5.Text = cmd.ExecuteScalar().ToString();
//отправленные заявки
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join UserInfo ui on ui.UserId=z.UserId " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='ODS' " +
"join Users u on z.UserId=u.UserId " +
"where z.Category=N'заявка' and z.Start>@date and u.UserName=@user", conn);
cmd.Parameters.AddWithValue("date", _from);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
Text7 = cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='Cadry' " +
"join Users u on z.UserId=u.UserId " +
"where z.Category=N'заявка' and z.Finish is null and u.UserName=@user", conn);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
Text6 = cmd.ExecuteScalar().ToString();
// HyperLink6.Text = cmd.ExecuteScalar().ToString();
// подсчет активных событий
// int all = int.Parse(HyperLink2.Text) + int.Parse(HyperLink3.Text) + int.Parse(HyperLink4.Text) + int.Parse(HyperLink6.Text)+ int.Parse(HyperLink8.Text);
int all = int.Parse(Text2) + int.Parse(Text3) + int.Parse(Text4) + int.Parse(Text6) + int.Parse(Text7) + int.Parse(Text8);
HyperLink29.Text = all.ToString();
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
List <App_Code.Base.StoppedLift> list = db.GetStoppedODSLifts(User.Identity.Name);
int total = db.GetODSLifts(User.Identity.Name);
Worked.Text = (total - list.Count).ToString();
Stopped.Text = list.Count.ToString();
}
}
}
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 VseRaboty(object sender, EventArgs e)
* {
* Zayavky.Text = "Все работы на " + DateTime.Now.ToShortDateString();
* if (!IsPostBack)
* {
* List<Data> data = new List<Data>();
*
* if (User.Identity.Name == "Sargamonov")
* {
* using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
* {
* conn.Open();
* SqlCommand cmd = new SqlCommand("select z.Id, z.LiftId, z.[Text], e.Id, z.Category, z.Worker, z.Start, z.Status from Zayavky z " +
* "join [Events] e on e.ZayavId=z.Id " +
* "join WorkerLifts wl on wl.LiftId=z.LiftId " +
* "join Users u on u.UserId=wl.UserId " +
* "where u.UserName=@UserName and z.Category=N'ПНР/РЭО' and z.[Finish] is null ", conn);
* cmd.Parameters.AddWithValue("UserName", User.Identity.Name);
* SqlDataReader dr = cmd.ExecuteReader();
* while (dr.Read())
* data.Add(new Data()
* {
* Title = " №" + " " + dr[3].ToString(),
* Url = "~/ZayavkaEdit.aspx?zId=" + Int32.Parse(dr["Id"].ToString()),
* Text1 = dr["Text"].ToString(),
* Idi = dr["LiftId"].ToString()
* });
* dr.Close();
* ZayavkyList.DataSource = data;
* ZayavkyList.DataBind();
* }
* }
* else
* {
* using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
* {
* conn.Open();
* SqlCommand cmd = new SqlCommand("select z.Id, z.LiftId, z.[Text], e.Id, z.Category, z.Worker, z.Start, z.Status from Zayavky z " +
* "join [Events] e on e.ZayavId=z.Id " +
* "join WorkerLifts wl on wl.LiftId=z.LiftId " +
* "join Users u on u.UserId=wl.UserId " +
* "where u.UserName=@UserName and z.Category!=N'ПНР/РЭО' and z.[Finish] is null ", conn);
* cmd.Parameters.AddWithValue("UserName", User.Identity.Name);
* SqlDataReader dr = cmd.ExecuteReader();
* while (dr.Read())
* data.Add(new Data()
* {
* Title = " №" + " " + dr[3].ToString(),
* Url = "~/ZayavkaEdit.aspx?zId=" + Int32.Parse(dr["Id"].ToString()),
* Text1 = dr["Text"].ToString(),
* Idi = dr["LiftId"].ToString()
* });
* dr.Close();
* ZayavkyList.DataSource = data;
* ZayavkyList.DataBind();
* }
* if (User.Identity.Name == "Sargamonov")
* {
* List<Data> data1 = new List<Data>(); // неактивные
* using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
* {
* conn.Open();
* SqlCommand cmd = new SqlCommand("select z.Id, z.LiftId, z.[Text], e.Id, z.Category, z.Worker, z.Start, z.Status from Zayavky z " +
* "join [Events] e on e.ZayavId=z.Id " +
* "join WorkerLifts wl on wl.LiftId=z.LiftId " +
* "join Users u on u.UserId=wl.UserId " +
* "where u.UserName=@UserName and z.Category=N'ПНР/РЭО' and z.[Finish]=1 and z.Status=N'false'", conn);
* cmd.Parameters.AddWithValue("UserName", User.Identity.Name);
* SqlDataReader dr = cmd.ExecuteReader();
* while (dr.Read())
* data1.Add(new Data()
* {
* Title = " №" + " " + dr[3].ToString(),
* Url = "~/ZayavkaEdit.aspx?zId=" + Int32.Parse(dr["Id"].ToString()),
* Text1 = dr["Text"].ToString(),
* Idi = dr["LiftId"].ToString()
* });
* dr.Close();
* ZayavkyNA.DataSource = data1;
* ZayavkyNA.DataBind();
* }
* }
* else
* {
* List<Data> data1 = new List<Data>(); // неактивные
* using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
* {
* conn.Open();
* SqlCommand cmd = new SqlCommand("select z.Id, z.LiftId, z.[Text], e.Id, z.Category, z.Worker, z.Start, z.Status from Zayavky z " +
* "join [Events] e on e.ZayavId=z.Id " +
* "join WorkerLifts wl on wl.LiftId=z.LiftId " +
* "join Users u on u.UserId=wl.UserId " +
* "where u.UserName=@UserName and z.Category!=N'ПНР/РЭО' and z.[Finish]=1 and z.Status=N'false' ", conn);
* cmd.Parameters.AddWithValue("UserName", User.Identity.Name);
* SqlDataReader dr = cmd.ExecuteReader();
* while (dr.Read())
* data1.Add(new Data()
* {
* Title = " №" + " " + dr[3].ToString(),
* Url = "~/ZayavkaEdit.aspx?zId=" + Int32.Parse(dr["Id"].ToString()),
* Text1 = dr["Text"].ToString(),
* Idi = dr["LiftId"].ToString()
* });
* dr.Close();
* ZayavkyNA.DataSource = data1;
* ZayavkyNA.DataBind();
* }
* using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
* {
* conn.Open();
* List<Data> dat = new List<Data>();
* SqlCommand cmd = new SqlCommand("select wz.Id, wz.UserId, wz.[Date], ui.Family, ui.IO, e.Id, wz.Done, wz.[Text], wz.[LiftId], wz.Readed from WorkerZayavky wz " +
* "join UserInfo ui on ui.UserId=wz.UserId " +
* // "join WorkerLifts wl on wl.UserId=wz.UserId " +
* "join Users u on wz.UserId=u.UserId " +
* "join Events e on e.WZayavId=wz.Id " +
* "where u.UserName=@user and wz.Done=0 and wz.Readed=0", conn);
* cmd.Parameters.AddWithValue("user", User.Identity.Name);
* SqlDataReader dr = cmd.ExecuteReader();
* while (dr.Read())
* dat.Add(new Data()
* {
* Title = 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 = dat;
* List.DataBind();
* }
* using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
* {
* conn.Open();
* List<Data> dat = new List<Data>();
* SqlCommand cmd = new SqlCommand("select wz.Id, wz.UserId, wz.[Date], ui.Family, ui.IO, e.Id, wz.Done, wz.[Text], wz.[LiftId], wz.Readed from WorkerZayavky wz " +
* "join UserInfo ui on ui.UserId=wz.UserId " +
* // "join WorkerLifts wl on wl.UserId=wz.UserId " +
* "join Users u on wz.UserId=u.UserId " +
* "join Events e on e.WZayavId=wz.Id " +
* "where u.UserName=@user and wz.Done=0 and wz.Readed=1", conn);
* cmd.Parameters.AddWithValue("user", User.Identity.Name);
* SqlDataReader dr = cmd.ExecuteReader();
* while (dr.Read())
* dat.Add(new Data()
* {
* Title = 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 = dat;
* ListNA.DataBind();
* }
* }
* }
* }
* }
*/
void BindTpPlan()
{
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
DateTime date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
_monthPlan = db.GetPlan(User.Identity.Name, date, date.AddMonths(1).AddSeconds(-1));
DataTable dt = db.GetTpPlan(User.Identity.Name, IdUM.SelectedValue, date, date.AddMonths(1).AddSeconds(-1));
_ltd = new List <TpData>();
foreach (DataRow dr in dt.Rows)
{
DateTime d1 = new DateTime(), d2 = new DateTime();
if (FindLiftTp(dr["LiftId"].ToString(), dr["TpId"].ToString(), out d1, out d2))
{
date = d1;
}
else
{
date = DateTime.MinValue;
}
TpData td = new TpData()
{
Address = dr["Ttx"].ToString(),
Day = date,
IdL = dr["IdL"].ToString(),
TpId = dr["TpId"].ToString(),
LiftId = dr["LiftId"].ToString()
};
if (td.Day != DateTime.MinValue)
{
td.Date = td.Day.ToString().Substring(0, 16);
List <DayPlan> ldp = GetDayPlan(td.Day);
#region MyRegion
string tpId = GetTp(8, td.LiftId, ldp);
if (string.IsNullOrEmpty(tpId))
{
td.H08 = "";
td.H08url = "~/Planning.aspx?liftId=" + HttpUtility.HtmlEncode(td.LiftId) +
"&user="******"&tpId=" + HttpUtility.HtmlEncode(td.TpId) + "&date=" +
HttpUtility.HtmlEncode((new DateTime(td.Day.Year, td.Day.Month, td.Day.Day, 8, 0, 0).ToString()));
}
else
{
td.H08 = tpId;
}
tpId = GetTp(9, td.LiftId, ldp);
if (string.IsNullOrEmpty(tpId))
{
td.H09 = "";
td.H09url = "~/Planning.aspx?liftId=" + HttpUtility.HtmlEncode(td.LiftId) +
"&user="******"&tpId=" + HttpUtility.HtmlEncode(td.TpId) + "&date=" +
HttpUtility.HtmlEncode((new DateTime(td.Day.Year, td.Day.Month, td.Day.Day, 9, 0, 0).ToString()));
}
else
{
td.H09 = tpId;
}
tpId = GetTp(10, td.LiftId, ldp);
if (string.IsNullOrEmpty(tpId))
{
td.H10 = "";
td.H10url = "~/Planning.aspx?liftId=" + HttpUtility.HtmlEncode(td.LiftId) +
"&user="******"&tpId=" + HttpUtility.HtmlEncode(td.TpId) + "&date=" +
HttpUtility.HtmlEncode((new DateTime(td.Day.Year, td.Day.Month, td.Day.Day, 10, 0, 0).ToString()));
}
else
{
td.H10 = tpId;
}
tpId = GetTp(11, td.LiftId, ldp);
if (string.IsNullOrEmpty(tpId))
{
td.H11 = "";
td.H11url = "~/Planning.aspx?liftId=" + HttpUtility.HtmlEncode(td.LiftId) +
"&user="******"&tpId=" + HttpUtility.HtmlEncode(td.TpId) + "&date=" +
HttpUtility.HtmlEncode((new DateTime(td.Day.Year, td.Day.Month, td.Day.Day, 11, 0, 0).ToString()));
}
else
{
td.H11 = tpId;
}
tpId = GetTp(12, td.LiftId, ldp);
if (string.IsNullOrEmpty(tpId))
{
td.H12 = "";
td.H12url = "~/Planning.aspx?liftId=" + HttpUtility.HtmlEncode(td.LiftId) +
"&user="******"&tpId=" + HttpUtility.HtmlEncode(td.TpId) + "&date=" +
HttpUtility.HtmlEncode((new DateTime(td.Day.Year, td.Day.Month, td.Day.Day, 12, 0, 0).ToString()));
}
else
{
td.H12 = tpId;
}
tpId = GetTp(13, td.LiftId, ldp);
if (string.IsNullOrEmpty(tpId))
{
td.H13 = "";
td.H13url = "~/Planning.aspx?liftId=" + HttpUtility.HtmlEncode(td.LiftId) +
"&user="******"&tpId=" + HttpUtility.HtmlEncode(td.TpId) + "&date=" +
HttpUtility.HtmlEncode((new DateTime(td.Day.Year, td.Day.Month, td.Day.Day, 13, 0, 0).ToString()));
}
else
{
td.H13 = tpId;
}
tpId = GetTp(14, td.LiftId, ldp);
if (string.IsNullOrEmpty(tpId))
{
td.H14 = "";
td.H14url = "~/Planning.aspx?liftId=" + HttpUtility.HtmlEncode(td.LiftId) +
"&user="******"&tpId=" + HttpUtility.HtmlEncode(td.TpId) + "&date=" +
HttpUtility.HtmlEncode((new DateTime(td.Day.Year, td.Day.Month, td.Day.Day, 14, 0, 0).ToString()));
}
else
{
td.H14 = tpId;
}
tpId = GetTp(15, td.LiftId, ldp);
if (string.IsNullOrEmpty(tpId))
{
td.H15 = "";
td.H15url = "~/Planning.aspx?liftId=" + HttpUtility.HtmlEncode(td.LiftId) +
"&user="******"&tpId=" + HttpUtility.HtmlEncode(td.TpId) + "&date=" +
HttpUtility.HtmlEncode((new DateTime(td.Day.Year, td.Day.Month, td.Day.Day, 15, 0, 0).ToString()));
}
else
{
td.H15 = tpId;
}
tpId = GetTp(16, td.LiftId, ldp);
if (string.IsNullOrEmpty(tpId))
{
td.H16 = "";
td.H16url = "~/Planning.aspx?liftId=" + HttpUtility.HtmlEncode(td.LiftId) +
"&user="******"&tpId=" + HttpUtility.HtmlEncode(td.TpId) + "&date=" +
HttpUtility.HtmlEncode((new DateTime(td.Day.Year, td.Day.Month, td.Day.Day, 16, 0, 0).ToString()));
}
else
{
td.H16 = tpId;
}
tpId = GetTp(17, td.LiftId, ldp);
if (string.IsNullOrEmpty(tpId))
{
td.H17 = "";
td.H17url = "~/Planning.aspx?liftId=" + HttpUtility.HtmlEncode(td.LiftId) +
"&user="******"&tpId=" + HttpUtility.HtmlEncode(td.TpId) + "&date=" +
HttpUtility.HtmlEncode((new DateTime(td.Day.Year, td.Day.Month, td.Day.Day, 17, 0, 0).ToString()));
}
else
{
td.H17 = tpId;
}
tpId = GetTp(18, td.LiftId, ldp);
if (string.IsNullOrEmpty(tpId))
{
td.H18 = "";
td.H18url = "~/Planning.aspx?liftId=" + HttpUtility.HtmlEncode(td.LiftId) +
"&user="******"&tpId=" + HttpUtility.HtmlEncode(td.TpId) + "&date=" +
HttpUtility.HtmlEncode((new DateTime(td.Day.Year, td.Day.Month, td.Day.Day, 18, 0, 0).ToString()));
}
else
{
td.H18 = tpId;
}
tpId = GetTp(19, td.LiftId, ldp);
if (string.IsNullOrEmpty(tpId))
{
td.H19 = "";
td.H19url = "~/Planning.aspx?liftId=" + HttpUtility.HtmlEncode(td.LiftId) +
"&user="******"&tpId=" + HttpUtility.HtmlEncode(td.TpId) + "&date=" +
HttpUtility.HtmlEncode((new DateTime(td.Day.Year, td.Day.Month, td.Day.Day, 19, 0, 0).ToString()));
}
else
{
td.H19 = tpId;
}
tpId = GetTp(20, td.LiftId, ldp);
if (string.IsNullOrEmpty(tpId))
{
td.H20 = "";
td.H20url = "~/Planning.aspx?liftId=" + HttpUtility.HtmlEncode(td.LiftId) +
"&user="******"&tpId=" + HttpUtility.HtmlEncode(td.TpId) + "&date=" +
HttpUtility.HtmlEncode((new DateTime(td.Day.Year, td.Day.Month, td.Day.Day, 20, 0, 0).ToString()));
}
else
{
td.H20 = tpId;
}
#endregion
}
_ltd.Add(td);
}
}
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)
{
CheckAccount();
_from = DateTime.Now.AddDays(-2);
Label1.Text = "С " + _from.ToString();
// Label2.Text = "С " + _from.ToString();
if (!IsPostBack)
{
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"where z.Category=N'застревание' and z.Start>@date", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink1.Text = cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"where z.Category=N'застревание' and z.Finish is null", conn);
HyperLink2.Text = cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"where z.Category=N'останов' and z.Start>@date", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink3.Text = cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"where z.Category=N'останов' and z.Finish is null", conn);
HyperLink4.Text = cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='ODS' " +
"where z.Category=N'заявка' and z.Start>@date", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink5.Text = cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='ODS' " +
"where z.Category=N'заявка' and z.Finish is null", conn);
HyperLink6.Text = cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='Manager' " +
"where z.Category=N'заявка' and z.Start>@date", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink7.Text = cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='Manager' " +
"where z.Category=N'заявка' and z.Finish is null", conn);
HyperLink8.Text = cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("select count(wz.Id) from WorkerZayavky wz " +
"where wz.[Date]>@date", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink9.Text = cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("select count(wz.Id) from WorkerZayavky wz " +
"where wz.Done=0", conn);
HyperLink10.Text = cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='ODS' " +
"where z.Category=N'плановые работы' and z.Finish is null", conn);
HyperLink11.Text = cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='ODS' " +
"where z.Category=N'внеплановые ремонты' and z.Finish is null", conn);
HyperLink12.Text = cmd.ExecuteScalar().ToString();
// все события
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
// Text2 = cmd.ExecuteScalar().ToString();
HyperLink47.Text = cmd.ExecuteScalar().ToString();
// срочные события - 2 дня
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Cansel=N'false' and e.DataId<=@date and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
// Text2 = cmd.ExecuteScalar().ToString();
HyperLink48.Text = cmd.ExecuteScalar().ToString();
// все события без Акта
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.ZaprosMng=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
// Text4 = cmd.ExecuteScalar().ToString();
HyperLink50.Text = cmd.ExecuteScalar().ToString();
// срочные события без Акта
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.ZaprosMng=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
// Text3 = cmd.ExecuteScalar().ToString();
HyperLink51.Text = cmd.ExecuteScalar().ToString();
// все события с запросом КП
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.ZaprosKp=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
// Text4 = cmd.ExecuteScalar().ToString();
HyperLink53.Text = cmd.ExecuteScalar().ToString();
// срочные события с запросом КП
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.ZaprosKp=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
// Text4 = cmd.ExecuteScalar().ToString();
HyperLink54.Text = cmd.ExecuteScalar().ToString();
// все события с ответом КП
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.KP=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
// Text4 = cmd.ExecuteScalar().ToString();
HyperLink56.Text = cmd.ExecuteScalar().ToString();
// срочные события с ответом КП
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.KP=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
// Text5 = cmd.ExecuteScalar().ToString();
HyperLink57.Text = cmd.ExecuteScalar().ToString();
// все события с запросом счета
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.ZapBill=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
// Text4 = cmd.ExecuteScalar().ToString();
HyperLink59.Text = cmd.ExecuteScalar().ToString();
// срочные события с запросом счета
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.ZapBill=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
// Text6 = cmd.ExecuteScalar().ToString();
HyperLink60.Text = cmd.ExecuteScalar().ToString();
// все события со счетами
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Bill=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
HyperLink62.Text = cmd.ExecuteScalar().ToString();
// срочные события со счетами
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Bill=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink63.Text = cmd.ExecuteScalar().ToString();
// все события с ожиданием оплаты
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Payment=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
HyperLink20.Text = cmd.ExecuteScalar().ToString();
// срочные события с ожиданием оплаты
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Payment=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink21.Text = cmd.ExecuteScalar().ToString();
// все события с ожиданием доставки
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Dostavka=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
HyperLink35.Text = cmd.ExecuteScalar().ToString();
// срочные события с ожиданием доставки
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Dostavka=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink36.Text = cmd.ExecuteScalar().ToString();
// все события с ожиданием прихода
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Prihod=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
HyperLink38.Text = cmd.ExecuteScalar().ToString();
// срочные события с ожиданием прихода
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Prihod=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink39.Text = cmd.ExecuteScalar().ToString();
// все события с ожиданием акта ВР
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.AktVR=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
HyperLink41.Text = cmd.ExecuteScalar().ToString();
// срочные события с ожиданием акта ВР
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.AktVR=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink42.Text = cmd.ExecuteScalar().ToString();
// все события с ожиданием списания
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Spisanie=N'true' and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
HyperLink44.Text = cmd.ExecuteScalar().ToString();
// срочные события с ожиданием списания
cmd = new SqlCommand("select count(e.Id) from Events e " +
"where e.Spisanie=N'true' and e.DataId<=@date and e.Cansel=N'false' and RegistrId=N'Эксплуатация лифтов'", conn);
cmd.Parameters.AddWithValue("date", _from);
HyperLink45.Text = cmd.ExecuteScalar().ToString();
// ReadFromInternet sms = new ReadFromInternet();
// sms.MakeRequest();
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
List <App_Code.Base.UM> lifts = db.GetUM();
Lifts.DataSource = lifts;
Lifts.DataBind();
List <App_Code.Base.LiftPrim> liftPrim = db.GetLiftPrim();
List <App_Code.Base.LiftPrim> liftZPrim = db.GetLiftZPrim();
foreach (App_Code.Base.LiftPrim i in liftZPrim)
{
int n = liftPrim.FindIndex(delegate(App_Code.Base.LiftPrim lp)
{
return(lp.IdUM == i.IdUM);
});
if (n >= 0)
{
liftPrim[n].N = (int.Parse(liftPrim[n].N) + int.Parse(i.N)).ToString();
}
else
{
liftPrim.Add(i);
}
}
liftPrim.Sort(delegate(App_Code.Base.LiftPrim lp1, App_Code.Base.LiftPrim lp2)
{
return(string.Compare(lp1.IdUM, lp2.IdUM));
});
LiftPrim.DataSource = liftPrim;
LiftPrim.DataBind();
}
}
}
void FillLabels()
{
lPrinyalDate.Text = " с " + CalendarStart.SelectedDate.ToLongDateString() + " по " +
CalendarStartEnd.SelectedDate.ToLongDateString();
if (HourStart.IsAllSelected())
{
lPHours.Text = " все";
}
else
{
List <int> sel = HourStart.GetSelectedTitles();
lPHours.Text = string.Empty;
foreach (int i in sel)
{
if (string.IsNullOrEmpty(lPHours.Text))
{
lPHours.Text += i.ToString();
}
else
{
lPHours.Text += ", " + i.ToString();
}
}
}
if (MinuteStart.IsAllSelected())
{
lPMinutes.Text = " все";
}
else
{
List <int> sel = MinuteStart.GetSelectedTitles();
lPMinutes.Text = string.Empty;
foreach (int i in sel)
{
if (string.IsNullOrEmpty(lPMinutes.Text))
{
lPMinutes.Text += i.ToString();
}
else
{
lPMinutes.Text += ", " + i.ToString();
}
}
}
if (_role != "Worker")
{
lVypolnilDate.Text = " с " + CalendarFinish.SelectedDate.ToLongDateString() + " по " +
CalendarFinishEnd.SelectedDate.ToLongDateString();
}
else
{
lVypolnilDate.Text = " в любое время";
}
if (HourFinish.IsAllSelected())
{
lVHours.Text = " все";
}
else
{
List <int> sel = HourFinish.GetSelectedTitles();
lVHours.Text = string.Empty;
foreach (int i in sel)
{
if (string.IsNullOrEmpty(lVHours.Text))
{
lVHours.Text += i.ToString();
}
else
{
lVHours.Text += ", " + i.ToString();
}
}
}
if (MinuteFinish.IsAllSelected())
{
lVMinutes.Text = " все";
}
else
{
List <int> sel = MinuteFinish.GetSelectedTitles();
lVMinutes.Text = string.Empty;
foreach (int i in sel)
{
if (string.IsNullOrEmpty(lVMinutes.Text))
{
lVMinutes.Text += i.ToString();
}
else
{
lVMinutes.Text += ", " + i.ToString();
}
}
}
if (IsAllSelected(IdU))
{
lU.Text = " любой";
}
else
{
lU.Text = GetSelected(IdU);
}
if (IsAllSelected(IdM))
{
lM.Text = " любой";
}
else
{
lM.Text = GetSelected(IdM);
}
if (IsAllSelected(IdL))
{
lL.Text = " любой";
}
else
{
lL.Text = GetSelected(IdL);
}
if (IsAllSelected(Address))
{
if (GetSelectedTitles(IdU).Count == 1 && GetSelectedTitles(IdM).Count == 1)
{
KOS.App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
List <string> ls = db.GetAddress(GetSelectedTitles(IdU)[0], GetSelectedTitles(IdM)[0]);
lAddress.Text = string.Empty;
foreach (string s in ls)
{
if (!string.IsNullOrEmpty(lAddress.Text))
{
lAddress.Text += ", ";
}
lAddress.Text += s;
}
}
else
{
lAddress.Text = " любой";
}
}
else
{
lAddress.Text = GetSelected(Address);
}
if (IsAllSelected(Category))
{
lCategory.Text = " любая";
}
else
{
lCategory.Text = GetSelected(Category);
}
if (IsAllSelected(From))
{
lSource.Text = " любой";
}
else
{
lSource.Text = GetSelected(From);
}
if (IsAllSelected(Prinyal))
{
lPrinyal.Text = " любой";
}
else
{
lPrinyal.Text = GetSelected(Prinyal);
}
if (_role == "Worker")
{
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
App_Code.Base.UserInfo ui = db.GetUserInfo(Page.User.Identity.Name);
lWorker.Text = ui.Family + " " + ui.IO;
}
else if (IsAllSelected(Worker))
{
lWorker.Text = " любой";
}
else
{
lWorker.Text = GetSelected(Worker);
}
}
protected void Page_Load(object sender, EventArgs e)
{
CheckAccount();
_from = DateTime.Now.AddDays(-2);
// Label1.Text = "С " + _from.ToString();
// if (!IsPostBack)
// CheckAccount();
// _from = DateTime.Now.AddDays(-2);
// Label1.Text = "С " + _from.ToString();
/* CurDate.Text = DateTime.Now.Date.ToLongDateString();
* CurHour.Text = DateTime.Now.Hour.ToString();
* CurMinute.Text = DateTime.Now.Minute.ToString(); */
if (!IsPostBack)
{
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
conn.Open();
/*SqlCommand cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
* "join Users u on z.UserId=u.UserId " +
* "where z.Category=N'застревание' and z.Start>@date and u.UserName=@user", conn);
* cmd.Parameters.AddWithValue("date", _from);
* cmd.Parameters.AddWithValue("user", User.Identity.Name);
* HyperLink1.Text = cmd.ExecuteScalar().ToString();
*/
SqlCommand cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join Users u on z.UserId=u.UserId " +
"where z.Category=N'застревание' and z.Finish is null and u.UserName=@user", conn);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
Text2 = cmd.ExecuteScalar().ToString();
// HyperLink2.Text = cmd.ExecuteScalar().ToString();
// плановые работы
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join Users u on z.UserId=u.UserId " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='ODS' " +
"where z.Category=N'плановые работы' and z.Finish is null and u.UserName=@user", conn);
cmd.Parameters.AddWithValue("date", _from);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
Text3 = cmd.ExecuteScalar().ToString();
// HyperLink3.Text = cmd.ExecuteScalar().ToString();
// внеплановые ремонты
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join Users u on z.UserId=u.UserId " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='ODS' " +
"where z.Category=N'внеплановые ремонты' and z.Finish is null and u.UserName=@user", conn);
cmd.Parameters.AddWithValue("date", _from);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
Text8 = cmd.ExecuteScalar().ToString();
// HyperLink8.Text = cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join Users u on z.UserId=u.UserId " +
"where z.Category=N'останов' and z.Finish is null and u.UserName=@user", conn);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
Text4 = cmd.ExecuteScalar().ToString();
// HyperLink4.Text = cmd.ExecuteScalar().ToString();
//заявки от заказчика
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='ODS' " +
"join Users u on z.UserId=u.UserId " +
"where z.Finish is null and z.Category=N'заявка'and u.UserName=@user", conn);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
// HyperLink5.Text = cmd.ExecuteScalar().ToString();
//отправленные заявки
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join UserInfo ui on ui.UserId=z.UserId " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='ODS' " +
"join Users u on z.UserId=u.UserId " +
"where z.Category=N'заявка' and z.Start>@date and u.UserName=@user", conn);
cmd.Parameters.AddWithValue("date", _from);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
// HyperLink7.Text = cmd.ExecuteScalar().ToString();
cmd = new SqlCommand("select count(z.Id) from Zayavky z " +
"join UsersInRoles uir on uir.UserId=z.UserId " +
"join Roles r on r.RoleId=uir.RoleId and r.RoleName='ODS' " +
"join Users u on z.UserId=u.UserId " +
"where z.Category=N'заявка' and z.Finish is null and u.UserName=@user", conn);
cmd.Parameters.AddWithValue("user", User.Identity.Name);
Text6 = cmd.ExecuteScalar().ToString();
// HyperLink6.Text = cmd.ExecuteScalar().ToString();
// подсчет активных событий
// int all = int.Parse(HyperLink2.Text) + int.Parse(HyperLink3.Text) + int.Parse(HyperLink4.Text) + int.Parse(HyperLink6.Text)+ int.Parse(HyperLink8.Text);
int all = int.Parse(Text2) + int.Parse(Text3) + int.Parse(Text4) + int.Parse(Text6) + int.Parse(Text8);
HyperLink1.Text = all.ToString();
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
List <App_Code.Base.StoppedLift> list = db.GetStoppedODSLifts(User.Identity.Name);
int total = db.GetODSLifts(User.Identity.Name);
Worked.Text = (total - list.Count).ToString();
Stopped.Text = list.Count.ToString();
}
}
}
protected void Akt_Click(object sender, EventArgs e)
{
//блок формирования акта
if (Label1.Text == "")
{
Msg.Text = "Для формирования актов требуется ПИН-код!"; return;
}
string PodpEmic = Spec + " " + WorkPin;
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand("select t.Ttx from Ttx t " +
"join LiftsTtx l on l.TtxId=t.Id " +
// "join Ttx tt on tt.Id=t.Id " +
"where t.TtxTitleId=1 and l.LiftId=@t", conn);
cmd.Parameters.AddWithValue("t", LiftId.SelectedValue);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
adrs = dr[0].ToString();
}
dr.Close();
cmd = new SqlCommand("select PlantNum from PhisicalAddr where LiftId=@lift", conn);
cmd.Parameters.AddWithValue("lift", LiftId.Text);
SqlDataReader dn = cmd.ExecuteReader();
if (dn.Read())
{
numlift = dn[0].ToString();
}
dn.Close();
int _wz = 0;
string dat = DateTime.Now.Date.ToLongDateString();
string dd = DateTime.Now.Day.ToString();
string mm = DateTime.Now.Month.ToString();
string yy = DateTime.Now.Year.ToString();
string hh = DateTime.Now.Hour.ToString() + "час." + DateTime.Now.Minute.ToString() + "мин.";
_wz = Int32.Parse(NumEvent.Text);
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
DataTable data = db.GetEvent(_wz);
string worker = data.Rows[0]["Family"].ToString() + " " + data.Rows[0]["IO"].ToString();
BaseFont baseFont = BaseFont.CreateFont(@"C:\Windows\Fonts\Arial.ttf", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED);
if (TypeAkt.SelectedValue == "Акт дефектовки")
{
PdfReader template = new PdfReader(@"C:\temp\aktDef.pdf"); // файл шаблона
PdfStamper stamper = new PdfStamper(template, new FileStream(@"C:\temp\akt.pdf", FileMode.Create));
AcroFields fields = stamper.AcroFields;
fields.AddSubstitutionFont(baseFont);
fields.SetField("NaktDef", NumEvent.Text + "-А1.1"); //номер акта
fields.SetField("adr", adrs);
fields.SetField("Nlift", LiftId.SelectedValue + " № " + numlift);
fields.SetField("opis1", Text.Text);
fields.SetField("lift", LiftId.SelectedValue);
fields.SetField("opis1", data.Rows[0]["EventId"].ToString());
fields.SetField("fill_6", Chel.SelectedValue);
fields.SetField("fill_7", Chas.SelectedValue);
fields.SetField("dateS", dd + "." + mm + "." + yy + "г.");
fields.SetField("dateP", dd + "." + mm + "." + yy + "г.");
fields.SetField("Podt", FamZak.Text);
fields.SetField("Sost", Label1.Text);
fields.SetField("name1", Name1.Text);
if (Name1.Text != "")
{
fields.SetField("npp1", " 1.");
}
fields.SetField("name2", Name2.Text);
if (Name2.Text != "")
{
fields.SetField("npp2", " 2.");
}
fields.SetField("name3", Name3.Text);
if (Name3.Text != "")
{
fields.SetField("npp3", " 3.");
}
fields.SetField("name4", Name4.Text);
if (Name4.Text != "")
{
fields.SetField("npp4", " 4.");
}
fields.SetField("name5", Name5.Text);
if (Name5.Text != "")
{
fields.SetField("npp5", " 5.");
}
fields.SetField("obz1", Obz1.Text);
fields.SetField("obz2", Obz2.Text);
fields.SetField("obz3", Obz3.Text);
fields.SetField("obz4", Obz4.Text);
fields.SetField("obz5", Obz5.Text);
fields.SetField("ID1", ID1.Text);
fields.SetField("ID2", ID2.Text);
fields.SetField("ID3", ID3.Text);
fields.SetField("ID4", ID4.Text);
fields.SetField("ID5", ID5.Text);
fields.SetField("kol1", Kol1.Text);
fields.SetField("kol2", Kol2.Text);
fields.SetField("kol3", Kol3.Text);
fields.SetField("kol4", Kol4.Text);
fields.SetField("kol5", Kol5.Text);
stamper.FormFlattening = false;// ложь - открыт для записи, истина - закрыт
stamper.Close();
// запись в БД
FileStream fs = new FileStream(@"C:\temp\akt.pdf", FileMode.Open);
Byte[] pdf = new byte[fs.Length];
fs.Read(pdf, 0, pdf.Length);
cmd = new SqlCommand("insert into Documents (Name, NumEvent, Image, NameFile, Status, Usr) values (@name, @nev, @img, @namefile, @st, @usr )", conn);
cmd.Parameters.AddWithValue("name", "акт дефектовки");
cmd.Parameters.AddWithValue("nev", NumEvent.Text);
cmd.Parameters.AddWithValue("usr", Label1.Text);
cmd.Parameters.Add("img", SqlDbType.Image).Value = pdf;
cmd.Parameters.Add("namefile", SqlDbType.NVarChar).Value = NumEvent.Text + "-A1_1.pdf";
cmd.Parameters.AddWithValue("st", "не подписан заказчиком");
cmd.ExecuteNonQuery();
fs.Close();
/* string commandText = @"C:\temp\akt.pdf";
* var proc = new System.Diagnostics.Process();
* proc.StartInfo.FileName = commandText;
* proc.StartInfo.UseShellExecute = true;
* proc.Start();
*/
Response.ContentType = "image"; //image/Jpeg
Response.BinaryWrite(pdf);
}
else if (TypeAkt.SelectedValue == "Акт повреждения оборудования")
{
PdfReader template = new PdfReader(@"C:\temp\aktPovr.pdf"); // файл шаблона
PdfStamper stamper = new PdfStamper(template, new FileStream(@"C:\temp\akt.pdf", FileMode.Create));
AcroFields fields = stamper.AcroFields;
fields.AddSubstitutionFont(baseFont);
fields.SetField("NaktPovr", NumEvent.Text + "-А3.1"); //номер акта
fields.SetField("adr", adrs);
fields.SetField("Nlift", LiftId.SelectedValue + " № " + numlift);
fields.SetField("opis1", Text.Text);
fields.SetField("lift", LiftId.SelectedValue);
fields.SetField("opis1", data.Rows[0]["EventId"].ToString());
fields.SetField("fill_6", Chel.SelectedValue);
fields.SetField("fill_7", Chas.SelectedValue);
fields.SetField("dateS", dd + "." + mm + "." + yy + "г.");
fields.SetField("dateP", dd + "." + mm + "." + yy + "г.");
fields.SetField("Podt", FamZak.Text);
fields.SetField("Sost", Label1.Text);
fields.SetField("name1", Name1.Text);
if (Name1.Text != "")
{
fields.SetField("npp1", " 1.");
}
fields.SetField("name2", Name2.Text);
if (Name2.Text != "")
{
fields.SetField("npp2", " 2.");
}
fields.SetField("name3", Name3.Text);
if (Name3.Text != "")
{
fields.SetField("npp3", " 3.");
}
fields.SetField("name4", Name4.Text);
if (Name4.Text != "")
{
fields.SetField("npp4", " 4.");
}
fields.SetField("name5", Name5.Text);
if (Name5.Text != "")
{
fields.SetField("npp5", " 5.");
}
fields.SetField("obz1", Obz1.Text);
fields.SetField("obz2", Obz2.Text);
fields.SetField("obz3", Obz3.Text);
fields.SetField("obz4", Obz4.Text);
fields.SetField("obz5", Obz5.Text);
fields.SetField("ID1", ID1.Text);
fields.SetField("ID2", ID2.Text);
fields.SetField("ID3", ID3.Text);
fields.SetField("ID4", ID4.Text);
fields.SetField("ID5", ID5.Text);
fields.SetField("kol1", Kol1.Text);
fields.SetField("kol2", Kol2.Text);
fields.SetField("kol3", Kol3.Text);
fields.SetField("kol4", Kol4.Text);
fields.SetField("kol5", Kol5.Text);
stamper.FormFlattening = false;
stamper.Close();
// запись в БД
FileStream fs = new FileStream(@"C:\temp\akt.pdf", FileMode.Open);
Byte[] pdf = new byte[fs.Length];
fs.Read(pdf, 0, pdf.Length);
cmd = new SqlCommand("insert into Documents (Name, NumEvent, Image, NameFile, Status, Usr) values (@name, @nev, @img, @namefile, @st, @usr )", conn);
cmd.Parameters.AddWithValue("name", "акт повреждения оборудования");
cmd.Parameters.AddWithValue("nev", NumEvent.Text);
cmd.Parameters.AddWithValue("usr", Label1.Text);
cmd.Parameters.Add("img", SqlDbType.Image).Value = pdf;
cmd.Parameters.Add("namefile", SqlDbType.NVarChar).Value = NumEvent.Text + "-A3_1.pdf";
cmd.Parameters.AddWithValue("st", "не подписан заказчиком");
cmd.ExecuteNonQuery();
fs.Close();
/* string commandText = @"C:\temp\akt.pdf";
* var proc = new System.Diagnostics.Process();
* proc.StartInfo.FileName = commandText;
* proc.StartInfo.UseShellExecute = true;
* proc.Start();
*/
Response.ContentType = "image"; //image/Jpeg
Response.BinaryWrite(pdf);
}
}
}
protected void Email_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
conn.Open();
string name = "", id = "", kol = "";
string name1 = "", id1 = "", kol1 = "";
string name2 = "", id2 = "", kol2 = "";
string name3 = "", id3 = "", kol3 = "";
string name4 = "", id4 = "", kol4 = "";
string dat = DateTime.Now.Date.ToLongDateString();
string dd = DateTime.Now.Day.ToString();
string mm = DateTime.Now.Month.ToString();
string yy = DateTime.Now.Year.ToString();
string hh = DateTime.Now.Hour.ToString() + "час." + DateTime.Now.Minute.ToString() + "мин.";
// _wz = Int32.Parse(EventId.Text);
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
// DataTable data = db.GetEvent(_wz);
DataTable dt = db.GetPartsList(_wz);
try
{
name = dt.Rows[0]["Name"].ToString();
id = dt.Rows[0]["NumID"].ToString();
kol = dt.Rows[0]["Kol"].ToString();
}
catch { }
try
{
name1 = dt.Rows[1]["Name"].ToString();
id1 = dt.Rows[1]["NumID"].ToString();
kol1 = dt.Rows[1]["Kol"].ToString();
}
catch { }
try
{
name2 = dt.Rows[2]["Name"].ToString();
id2 = dt.Rows[2]["NumID"].ToString();
kol2 = dt.Rows[2]["Kol"].ToString();
}
catch { }
try
{
name3 = dt.Rows[3]["Name"].ToString();
id3 = dt.Rows[3]["NumID"].ToString();
kol3 = dt.Rows[3]["Kol"].ToString();
}
catch { }
try
{
name4 = dt.Rows[4]["Name"].ToString();
id4 = dt.Rows[4]["NumID"].ToString();
kol4 = dt.Rows[4]["Kol"].ToString();
}
catch { }
BaseFont baseFont = BaseFont.CreateFont(@"C:\Windows\Fonts\Arial.ttf", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED);
PdfReader template = new PdfReader(@"C:\temp\kp.pdf"); // файл шаблона
PdfStamper stamper = new PdfStamper(template, new FileStream(@"C:\temp\zkp.pdf", FileMode.Create));
AcroFields fields = stamper.AcroFields;
fields.AddSubstitutionFont(baseFont);
fields.SetField("dd", dd);
fields.SetField("mm", mm);
fields.SetField("yy", yy);
if (name != "")
{
fields.SetField("npp1", " 1.");
}
fields.SetField("name", name);
if (name1 != "")
{
fields.SetField("npp2", " 2.");
}
fields.SetField("name1", name1);
if (name2 != "")
{
fields.SetField("npp3", " 3.");
}
fields.SetField("name2", name2);
if (name3 != "")
{
fields.SetField("npp4", " 4.");
}
fields.SetField("name3", name3);
if (name4 != "")
{
fields.SetField("npp5", " 5.");
}
fields.SetField("name4", name4);
fields.SetField("id", id);
fields.SetField("id1", id1);
fields.SetField("id2", id2);
fields.SetField("id3", id3);
fields.SetField("id4", id4);
fields.SetField("kol", kol);
fields.SetField("kol1", kol1);
fields.SetField("kol2", kol2);
fields.SetField("kol3", kol3);
fields.SetField("kol4", kol4);
// fields.SetField("kol1", kol1);
fields.SetField("dni", "один");
stamper.FormFlattening = false; // ложь - открыт для записи, истина - закрыт
stamper.Close();
// запись в БД
FileStream fs = new FileStream(@"C:\temp\zkp.pdf", FileMode.Open);
Byte[] pdf = new byte[fs.Length];
fs.Read(pdf, 0, pdf.Length);
SqlCommand cmd = new SqlCommand("insert into Documents (Name, NumEvent, Image, NameFile, Status) values (@name, @nev, @img, @namefile, @st )", conn);
cmd.Parameters.AddWithValue("name", "запрос КП");
cmd.Parameters.AddWithValue("nev", Id.Text);
cmd.Parameters.Add("img", SqlDbType.Image).Value = pdf;
cmd.Parameters.Add("namefile", SqlDbType.NVarChar).Value = Id.Text + "/ЗКП.pdf";
cmd.Parameters.AddWithValue("st", "отправлен");
cmd.ExecuteNonQuery();
fs.Close();
// Response.ContentType = "image"; //image/Jpeg
// Response.BinaryWrite(pdf);
}
string text = "Здравствуйте! Вышлите пожалуйста коммерческое предложение на перечень запчастей во вложенном файле";
if (!IsAllSelected(Post))
{
List <string> sel = GetSelectedEmails(Post);
for (int i = 0; i < sel.Count; i++)
{
Send(sel[i], text);
}
}
Msg.Text = "Запрос нв КП разослан по выбранным адресам!";
}
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;
}
}
protected void Page_Load(object sender, EventArgs e)
{
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
_IdU = db.GetIdU();
}
protected void Parts_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into PartsList (NumEvent, Foto, namefoto, Name, NumID, Kol, Obz) values (@nev, @foto, @namefoto, @name, @numid, @kol, @obz) ", conn);
//выбор фото из устройства
string namePhoto = FileUpload.FileName;
//преобразование в двоичный код
byte[] photo = FileUpload.FileBytes;
cmd.Parameters.AddWithValue("nev", NumEvent.Text);
cmd.Parameters.Add("foto", SqlDbType.Image).Value = photo;
cmd.Parameters.Add("namefoto", SqlDbType.NVarChar).Value = namePhoto;
cmd.Parameters.AddWithValue("name", Text1.Text);
cmd.Parameters.AddWithValue("obz", TextBox1.Text);
cmd.Parameters.AddWithValue("numid", Text2.Text);
cmd.Parameters.AddWithValue("kol", Text3.Text);
cmd.ExecuteNonQuery();
int ei = int.Parse(NumEvent.Text);
App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
DataTable dt = db.GetPartsList(ei);
try
{
Name1.Text = dt.Rows[0]["Name"] is DBNull ? "" : dt.Rows[0]["Name"].ToString();
Obz1.Text = dt.Rows[0]["Obz"] is DBNull ? "" : dt.Rows[0]["Obz"].ToString();
ID1.Text = dt.Rows[0]["NumID"] is DBNull ? "" : dt.Rows[0]["NumID"].ToString();
Kol1.Text = dt.Rows[0]["Kol"] is DBNull ? "" : dt.Rows[0]["Kol"].ToString();
}
catch { }
try
{
Name2.Text = dt.Rows[1]["Name"] is DBNull ? "" : dt.Rows[1]["Name"].ToString();
Obz2.Text = dt.Rows[1]["Obz"] is DBNull ? "" : dt.Rows[1]["Obz"].ToString();
ID2.Text = dt.Rows[1]["NumID"] is DBNull ? "" : dt.Rows[1]["NumID"].ToString();
Kol2.Text = dt.Rows[1]["Kol"] is DBNull ? "" : dt.Rows[1]["Kol"].ToString();
}
catch { }
try
{
Name3.Text = dt.Rows[2]["Name"] is DBNull ? "" : dt.Rows[2]["Name"].ToString();
Obz3.Text = dt.Rows[2]["Obz"] is DBNull ? "" : dt.Rows[2]["Obz"].ToString();
ID3.Text = dt.Rows[2]["NumID"] is DBNull ? "" : dt.Rows[2]["NumID"].ToString();
Kol3.Text = dt.Rows[2]["Kol"] is DBNull ? "" : dt.Rows[2]["Kol"].ToString();
}
catch { }
try
{
Name4.Text = dt.Rows[3]["Name"] is DBNull ? "" : dt.Rows[3]["Name"].ToString();
Obz4.Text = dt.Rows[3]["Obz"] is DBNull ? "" : dt.Rows[3]["Obz"].ToString();
ID4.Text = dt.Rows[3]["NumID"] is DBNull ? "" : dt.Rows[3]["NumID"].ToString();
Kol4.Text = dt.Rows[3]["Kol"] is DBNull ? "" : dt.Rows[3]["Kol"].ToString();
}
catch { }
try
{
Name5.Text = dt.Rows[4]["Name"].ToString();
Obz5.Text = dt.Rows[4]["Obz"].ToString();
ID5.Text = dt.Rows[4]["NumID"].ToString();
Kol5.Text = dt.Rows[4]["Kol"].ToString();
}
catch { }
}
Text1.Text = ""; Text2.Text = ""; Text3.Text = ""; TextBox1.Text = "";
}