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