public void loadTextControl(string addEdit)
{
switch (addEdit)
{
case "Добавить":
switch (nameView)
{
case "gridView_konstr":
idForm = xlsx_.read_xlsx("save_pf");
lUp_numberForm.EditValue = _Sql.linkToDt(dtForm, idForm, "id", "name_form");
break;
case "PBView":
string nameObject = xlsx_.read_xlsx("save_obj");
lUp_object.EditValue = _Sql.linkToDt(dtObjects, nameObject, "name_object", "id_object");
break;
}
string work = xlsx_.read_xlsx("save_work_name");
lUp_work.EditValue = Convert.ToInt32(_Sql.linkToDt(dtWork, work, "Work", "id_work"));
string other = xlsx_.read_xlsx("save_other");
lUp_other.EditValue = other;
break;
case "Изменить":
switch (nameView)
{
case "gridView_konstr":
idForm = dtTotal.Rows[0]["form_id"].ToString();
lUp_numberForm.EditValue = _Sql.linkToDt(dtForm, idForm, "id", "name_form");
break;
case "PBView":
string nameObject = dtTotal.Rows[0]["id_object"].ToString();
lUp_object.EditValue = _Sql.linkToDt(dtObjects, nameObject, "name_object", "id_object");
break;
}
date_AddRecord.DateTime = Convert.ToDateTime(dtTotal.Rows[0]["date"].ToString());
tmEdt_start.TimeSpan = TimeSpan.Parse(dtTotal.Rows[0]["time_begin"].ToString());
tmEdt_end.TimeSpan = TimeSpan.Parse(dtTotal.Rows[0]["time_end"].ToString());
lUp_subunit.Text = dtTotal.Rows[0]["subunit"].ToString();
lUp_work.EditValue = Convert.ToInt32(dtTotal.Rows[0]["id_work"].ToString());
lUp_other.EditValue = dtTotal.Rows[0]["other"].ToString();
break;
}
}
public string comandSelectBOSS()
{
string comand = comand = @"SELECT* FROM[total] join work on work.id_work = total.id_work
WHERE [date]>='" + date_start + "'"
+ "AND [date]<='" + date_end + "'";;
if (cmb_subunit.Text == "Мои записи")
{
comand += " AND id_tn=" + formLogin.id_tn;
}
else if (cmb_subunit.Text == "Все")
{
for (int i = 0; i < dtCmbBoxSubunit.Rows.Count; i++)
{
string idSubunitWorker = dtCmbBoxSubunit.Rows[i]["id_subunit"].ToString();
if (!string.IsNullOrEmpty(idSubunitWorker) && idSubunitWorker != "")
{
if (i == 0)
{
comand += " AND( [id_subunit_worker]=" + idSubunitWorker;
}
else
{
comand += " OR [id_subunit_worker]=" + idSubunitWorker;
}
}
}
comand += ")";
}
else
{
string idSubunitWorker = _sql.linkToDt(dtCmbBoxSubunit, cmb_subunit.Text, "subunit", "id_subunit");
comand += " AND [id_subunit_worker]=" + idSubunitWorker;
}
return(comand);
}
