protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdminManage(); if (!IsPostBack) { bTable bT = new bTable(); string Action = Request.QueryString["Action"]; if (Action == "del") { mTable mT = new mTable(); mT.Id = StringDeal.ToInt(Request.QueryString["Id"]); if (bT.GetIsSystem(mT)) { StringDeal.Alter("此模型为系统模型禁止删除!"); } mT.TableName = bT.GetTableName(mT.Id); bT.TableDel(mT); HXD.ModelField.BLL.Table bt = new HXD.ModelField.BLL.Table(); bt.DeleteXml(mT); } DBList.DataSource = bT.TableList(); DBList.DataBind(); } }
/// <summary> /// 栏目模型绑定(获取所需字段) /// </summary> protected void SetBind() { DataSet ds = bF.FieldList(mF);//获取此信息模型字段 DBList.DataSource = ds; DBList.DataBind(); }
/// <summary> /// Записываем в лог инфу о найденых карточках. Пишем ИД карточки и её рег номер /// </summary> private void WriteLogInfo(DBItemCollection items, DBList list) { Console.WriteLine($"{Environment.NewLine}Найдено карточек: {items.Count}"); this.Loger.WriteLine($"{Environment.NewLine}Дата {DateTime.Now.ToString()} найдено карточек: {items.Count}{Environment.NewLine}Информация о найденых карточках:"); if (items.Count == 0) { return; } //устанавливаем load type DBField field = list.GetField(Consts.Fields.RegNumber, true); field.ValueLoadingType = DBFieldValueIOType.Directly; //собираем всю инфу (ИД карточки и её рег номер) и потом записываем разом в лог StringBuilder itemsinfo = new StringBuilder(); foreach (DBItem item in items) { itemsinfo.AppendLine($"ItemID = '{item.ID}' Регистрационный номер: '{item.GetStringValue(Consts.Fields.RegNumber)}'"); } this.Loger.WriteLine(itemsinfo.ToString()); }
public ActionResult AddGrade() { string sql = "select distinct(u.iducznia), u.imie || ' ' || u.nazwisko from uczen u " + "join oceny o on u.iducznia = o.UCZEN_iducznia " + "join przedmiot p on p.IDPRZEDM = o.PRZEDMIOT_IDPRZEDM " + "join klasa k on k.IDKLASY = p.KLASA_IDKLASY " + "join nauczyciel n on n.idnaucz = p.NAUCZYCIEL_IDNAUCZ " + "where p.NAUCZYCIEL_IDNAUCZ =" + Convert.ToInt16(Session["IDZalogowanego"]) + "and k.nazwa = '" + PupilsController.ClassName + "' and p.nazwa = '" + PupilsController.SubjectName + "' Order by u.iducznia"; // model oceny var grade = new Oceny(); // Lista ocen DBList gradelist = new DBList(); var ocena = gradelist.GetGrade(); grade.Grades = gradelist.GetGradeList(ocena); // Lista typow DBList typelist = new DBList(); var type = typelist.GetTyp(); grade.Types = typelist.GetTypeList(type); DBList Pupile = new DBList(); grade.FullName = Pupile.GetSelectListItems(sql); return(View(grade)); }
public void GridView_SelectionChanged(object sender, SelectionChangedEventArgs e) { var gridview = sender as GridView; FlyoutBase.ShowAttachedFlyout(gridview); item = gridview.SelectedItem as DBList; }
private DBList <DBBreak> CreateBreaks(IDateTimeIterator _dtIterator, DateTime _startDate, DateTime _endDate, int _count) { var breaks = new DBList <DBBreak>(); _count = _count.Min(MAX_BREAKS); foreach (var dt in _dtIterator.GetIterator(_startDate, _endDate, 0, _count)) { //Abwesenheit in MT Auftrag evtl. verboten //ANF-06805-F1G6Z2|Lifta| if (!Data.IsAbsenceAllowed(WorkerNr, dt + Begin.TimeOfDay, mandant.MTOhneAbwesenheiten)) { continue; } foreach (var workerNr in workerNrs) { var b = MakeBreak(); b.WorkerNr = workerNr; b.Nr = Data.GetBreakSequence(); if (groupNr == 0) { groupNr = b.Nr; } b.GroupNr = groupNr; b.GroupRule = groupRule; b.Begin = dt + Begin.TimeOfDay; b.Date = dt; breaks.Add(b); EventHub.Handle(lang, EventType.WorkerBreak, DateTime.Now, this.GetType().Name, this.username, EventParams.Create("workernr", workerNr, "info", FLS.Texts.Text.Get(lang, FLS.Texts.Text.Pauseaenderung), "text", FLS.Texts.Text.Get(lang, FLS.Texts.Text.Pauseaenderung) + ":" + b.Begin, "shift", shift)); } } return(breaks); }
public ActionResult AddPresent() { string sql = "select distinct(u.iducznia), u.imie || ' ' || u.nazwisko from uczen u " + "join oceny o on u.iducznia = o.UCZEN_iducznia " + "join przedmiot p on p.IDPRZEDM = o.PRZEDMIOT_IDPRZEDM " + "join klasa k on k.IDKLASY = p.KLASA_IDKLASY " + "join nauczyciel n on n.idnaucz = p.NAUCZYCIEL_IDNAUCZ " + "where p.NAUCZYCIEL_IDNAUCZ =" + Convert.ToInt16(Session["IDZalogowanego"]) + "and k.nazwa = '" + PupilsController.ClassName + "' and p.nazwa = '" + PupilsController.SubjectName + "' Order by u.iducznia"; // model obecnosci var present = new Obecnosci(); // Lista Godzin zajęć DBList hourslist = new DBList(); var hour = hourslist.GetHour(); present.Hours = hourslist.GetHoursList(hour); // Lista obecny TAK/NIE DBList presentlist = new DBList(); var obecnosci = presentlist.GetPresent(); present.Obecny = presentlist.GetPresentsList(obecnosci); // lista uczniow DBList Pupile = new DBList(); present.FullName = Pupile.GetSelectListItems(sql); return(View(present)); }
/// <summary> /// Ищет родительские подразделения. /// </summary> /// <returns></returns> private List <DBItem> GetChildren(List <DBItem> level, DBList depList) { if (level == null) { throw new ArgumentNullException(nameof(level)); } if (depList == null) { throw new ArgumentNullException(nameof(depList)); } List <DBItem> result = new List <DBItem>(); string parentsIDs = ""; foreach (DBItem item in level) { parentsIDs += item.ID + ","; } parentsIDs = parentsIDs.TrimEnd(','); string selectCondition = $"[Родительское подразделение] IN ({parentsIDs})"; DBItemCollection collection = depList.GetItems(selectCondition); result.AddRange(collection); return(result); }
/// <summary> /// Проверяет по условию поле "Делопроизводственный индекс" /// </summary> /// <param name="departmentID"></param> /// <param name="depList"></param> /// <returns>true/false - нашло/не_нашло</returns> private bool IndexCheck(string departmentID, DBList depList) { bool b = int.TryParse(departmentID, out int id); if (!b) { throw new FormatException("Передан неверный departmentID"); } DBItem dep = depList.GetItem(id); string index = dep.GetStringValue(Consts.FieldIndex); switch (index) { case Consts.IndexCase1: Result = Consts.IndexCase1Valid; return(true); case Consts.IndexCase2: Result = Consts.IndexCase2Valid; return(true); case Consts.IndexCase3: Result = Consts.IndexCase3Valid; return(true); default: return(false); } }
public static Record[] LoadRecords(Rank Rank) { DBList <Record> List = MainClass.db.FindObjects <Record> ("Rank=%0%", (int)Rank); List.Sort("Timestamp"); return(List.ToArray()); }
/// <summary> /// 栏目模型绑定(获取栏目所需字段) /// </summary> protected void MenuSetBind() { mMF.Temp = "0"; DataSet ds = bMF.MenuFieldList(mMF);//获取此栏目的模型字段 DBList.DataSource = ds; DBList.DataBind(); }
/// <summary> /// 栏目模型绑定(获取栏目所需字段) /// </summary> protected void MenuBind() { GetFiledId(); DataSet ds = bMF.MenuFieldList(mMF);//获取此栏目的模型字段 DBList.DataSource = ds; DBList.DataBind(); }
public ActionResult EditGrade(int id) { // polaczenie OracleConnection conn = new OracleConnection(); conn.ConnectionString = "Data Source=(DESCRIPTION=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))" + "(CONNECT_DATA=(SID=xe)));" + "User Id=hr; Password=hr;"; conn.Open(); string sql = "select u.iducznia, u.imie, u.nazwisko, o.Ocena, o.TYP, o.IdOceny, p.IDPRZEDM from uczen u " + "join oceny o on u.iducznia = o.UCZEN_iducznia " + "join przedmiot p on p.IDPRZEDM = o.PRZEDMIOT_IDPRZEDM " + "join klasa k on k.IDKLASY = p.KLASA_IDKLASY " + "join nauczyciel n on n.idnaucz = p.NAUCZYCIEL_IDNAUCZ " + "where o.IDOceny = :id"; // model ocen var grade = new Oceny(); // Lista ocen DBList gradelist = new DBList(); var ocena = gradelist.GetGrade(); grade.Grades = gradelist.GetGradeList(ocena); // Lista typow DBList typelist = new DBList(); var type = typelist.GetTyp(); grade.Types = typelist.GetTypeList(type); // generowanie danych DataTable data = new DataTable(); OracleDataAdapter OracleAdapter = new OracleDataAdapter(sql, conn); // Dodaję parametry do zapytania. OracleAdapter.SelectCommand.Parameters.Add( new OracleParameter("id", id) ); OracleAdapter.Fill(data); conn.Close(); if (data.Rows.Count == 1) { // dodanie danych do modelu ocen grade.NrWDzienniku = Convert.ToInt32(data.Rows[0][0].ToString()); grade.Imie = data.Rows[0][1].ToString(); grade.Nazwisko = data.Rows[0][2].ToString(); grade.Ocena = Convert.ToDouble(data.Rows[0][3].ToString()); grade.Typ = data.Rows[0][4].ToString(); grade.IDOceny = Convert.ToInt32(data.Rows[0][5].ToString()); grade.IDPrzedmiotu = Convert.ToInt32(data.Rows[0][6].ToString()); return(View(grade)); } return(RedirectToAction("Przedmioty")); }
public ActionResult EditPresent(int id) { // polaczenie OracleConnection conn = new OracleConnection(); conn.ConnectionString = "Data Source=(DESCRIPTION=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))" + "(CONNECT_DATA=(SID=xe)));" + "User Id=hr; Password=hr;"; conn.Open(); string sql = "select u.IDUCZNIA, u.imie, u.nazwisko, o.data, g.IDGODZ, o.obecny from uczen u " + "join obecnosci o on o.UCZEN_iducznia = u.iducznia " + "join godziny g on g.IDGODZ = o.GODZINY_IDGODZ " + "join przedmiot p on p.IDPRZEDM = o.PRZEDMIOT_IDPRZEDM " + "join klasa k on k.IDKLASY = p.KLASA_IDKLASY " + "join nauczyciel n on n.idnaucz = p.NAUCZYCIEL_IDNAUCZ " + "where o.IdObec = :id"; // model obecnosci var present = new Obecnosci(); // Lista Godzin zajęć DBList hourslist = new DBList(); var hour = hourslist.GetHour(); present.Hours = hourslist.GetHoursList(hour); // Lista obecny TAK/NIE DBList presentlist = new DBList(); var obecnosci = presentlist.GetPresent(); present.Obecny = presentlist.GetPresentsList(obecnosci); DataTable data = new DataTable(); OracleDataAdapter OracleAdapter = new OracleDataAdapter(sql, conn); // Dodaję parametry do zapytania. OracleAdapter.SelectCommand.Parameters.Add( new OracleParameter("id", id) ); OracleAdapter.Fill(data); conn.Close(); // wypelnienie danych dla modelu obecnosci if (data.Rows.Count == 1) { present.IDUcznia = Convert.ToInt32(data.Rows[0][0].ToString()); present.Imie = data.Rows[0][1].ToString(); present.Nazwisko = data.Rows[0][2].ToString(); present.Date = Convert.ToDateTime(data.Rows[0][3]); present.GodzinaZajec = Convert.ToInt32(data.Rows[0][4].ToString()); present.CzyObecny = data.Rows[0][5].ToString(); present.IDObecnosci = id; return(View(present)); } return(RedirectToAction("Przedmioty")); }
/// <summary> /// Возвращает подразделение пользователя. /// </summary> /// <param name="idUser"></param> /// <returns>id подразделения</returns> private string GetDepartment() { DBList listUsers = this.Site.UsersList; DBItem user = listUsers.GetItem(this.UserID); string _department = ""; _department = user.GetValue(Consts.FieldDepartment).ToString(); return(_department); }
/// <summary> /// Возвращает должность пользователя. /// </summary> /// <param name="idUser"></param> /// <returns>id должности</returns> private string GetPosition() { DBList listUsers = this.Site.UsersList; DBItem user = listUsers.GetItem(this.UserID); string _position = ""; _position = user.GetValue(Consts.FieldPosition).ToString(); return(_position); }
public Test(int _maxServicesCount, int _operationsCount) { operationsCount = _operationsCount; maxServicesCount = _maxServicesCount; DBSite dbSite = new DBSite("http://wsstest"); DBWeb dbWeb = dbSite.GetWeb("/dms/requests"); objectList = dbWeb.GetList("AccountingObjects"); dbWeb = dbSite.GetWeb("/"); users = dbWeb.GetList("Users"); }
/// <summUry> /// 绑定用户列表 /// </summUry> protected void UserBind() { SgqPage pg = new SgqPage(); pg.PageIndex = Pages; pg.PageSize = 30; pg.dt = bU.UserList(mU).Tables[0]; DBList.DataSource = pg.DataSource(); DBList.DataBind(); this.PageView.Text = pg.PageView1(); }
private void SaveBreaks(bool _replan, DBList <DBBreak> _breaks) { foreach (var b in _breaks) { b.Save(); if (_replan) { Replan(b.Date); } } }
/// <summary> /// Возвращает строку для фильтрации, с id всех компаний до 4-ого уровня. /// </summary> /// <returns></returns> public string GetListOfDepartments() { DBWeb web = this.Site.GetWeb("/"); if (web == null) { throw new Exception("Узел не найден"); } DBList departmentsList = web.GetList(Consts.DepartmentsList); if (departmentsList == null) { throw new Exception($"Не найден список по имени '{Consts.DepartmentsList}'"); } string selectCondition = null; string result = null; List <DBItem> lvlOne = new List <DBItem>(); selectCondition = "[Название] = " + Consts.DepartmentLevelQuery; lvlOne.Add(departmentsList.GetItem(selectCondition)); foreach (DBItem item in lvlOne) { result += item.ID + ","; } List <DBItem> lvlTwo = new List <DBItem>(); lvlTwo = this.GetChildren(lvlOne, departmentsList); foreach (DBItem item in lvlTwo) { result += item.ID + ","; } List <DBItem> lvlThree = new List <DBItem>(); lvlThree = this.GetChildren(lvlTwo, departmentsList); foreach (DBItem item in lvlThree) { result += item.ID + ","; } List <DBItem> lvlFour = new List <DBItem>(); lvlFour = this.GetChildren(lvlThree, departmentsList); foreach (DBItem item in lvlFour) { result += item.ID + ","; } return(result.TrimEnd(',')); }
public void Databaseler() { string query = "SELECT * FROM DB"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader read = command.ExecuteReader(); DBList.DataSource = read; DBList.DataBind(); connection.Close(); }
/// <summary> /// 绑定管理员列表 /// </summary> protected void AdminBind() { bAdmin bA = new bAdmin(); SgqPage pg = new SgqPage(); pg.PageIndex = Pages; pg.PageSize = 30; pg.dt = bA.AdminList().Tables[0]; DBList.DataSource = pg.DataSource(); DBList.DataBind(); this.PageView.Text = pg.PageView1(); }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdminManage(null); int Id = StringDeal.ToInt(Request.QueryString["Id"]); if (Id == 0) { Id = b.GetChannelFirstParentId(Session["AdminManage"].ToString()); } Titles = b.GetChannelTitle(Id); DBList.DataSource = b.GetChannelMenu(Id, Session["AdminManage"].ToString())[0].Tables[0]; DBList.DataBind(); }
/// <param name="ShowLoginHistory">Allow user to select from list of previous usernames and databases</param> /// <param name="HistoryLength">Number of items to store in the history</param> /// <param name="SettingsDir">Settings directory (location to store list of logins)</param> /// <param name="SchemaPath">Full path to directory where XML Schemas are stored</param> /// <param name="Databases">List of databases to allow the user to choose from</param> public Login( bool ShowLoginHistory, int HistoryLength, string SettingsDir, string SchemaPath, StringCollection Servers) { // This call is required by the Windows.Forms Form Designer. InitializeComponent(); //Clears text boxes UserName = ""; Password = ""; Server = ""; //In case they didn't pass a trailing backslash if (SettingsDir[SettingsDir.Length - 1] != '\\') { SettingsDir += "\\"; } if (SchemaPath[SchemaPath.Length - 1] != '\\') { SchemaPath += "\\"; } //Create the settings directory, in case it doesn't exist if (!System.IO.Directory.Exists(SettingsDir)) { System.IO.Directory.CreateDirectory(SettingsDir); } userListXmlFile = SettingsDir + "DBLoginHistory.xml"; //Create the login history list history = new LoginHistory(SchemaPath, userListXmlFile); //Just in case the HistoryLength passed is negative history.HistoryLength = Math.Abs(HistoryLength); //safeguard against negative input //This is how you disable the Login History, if ShowLoginHistory is false userName.Properties.Buttons[0].Visible = ShowLoginHistory; //Load databases into the combo box's dropdown DBList.Clear(); foreach (string db in Servers) { DBList.Add(db); } SetWindowText(); }
public Dictionary <string, string> Databases() { Dictionary <string, string> returnValue = new Dictionary <string, string>(); DBList operation = new DBList(); ODocument document = _connection.ExecuteOperation(operation); string[] databases = document.GetField <string>("databases").Split(','); foreach (var item in databases) { string[] keyValue = item.Split(':'); returnValue.Add(keyValue[0], keyValue[1] + ":" + keyValue[2]); } return(returnValue); }
protected void Page_Load(object sender, EventArgs e) { LoginCheck.AdminManage(); TableId = StringDeal.ToInt(Request.QueryString["TableId"]); bTable bT = new bTable(); mF.TableName = bT.GetTableName(TableId); if (!IsPostBack) { Operation(); DBList.DataSource = bF.FieldList(mF); DBList.DataBind(); } }
/// <summary> /// Возвращает id компании по номеру пользователя /// </summary> /// <param name="initiatorID"></param> /// <returns></returns> public int GetCompany(int initiatorID) { int result = 0; DBList usersList = this.Context.Site.UsersList; DBItem user = usersList.GetItem(initiatorID); if (user == null) { throw new ArgumentNullException(nameof(user)); } result = user.GetLookupID(Consts.FieldCompany); return(result); }
/// <summary> /// Возвращает имя подразделения по его id /// </summary> /// <param name="departmentID"></param> /// <returns></returns> private string GetDepartmentNameByID(string departmentID) { bool b = int.TryParse(departmentID, out int id); if (!b) { throw new FormatException("Передан неверный id подразделения"); } DBWeb web = this.Site.GetWeb("/"); DBList listDeps = web.GetList("Departments"); DBItem department = listDeps.GetItem(id); return(department.GetStringValue("Название")); }
public List <CarsData> getAllCarsData() { List <CarsData> carsdata = new List <CarsData>(); try { string sql = "select * from Cars"; DataTable dt = new DataTable(); dt = _idac.GetManyRows(sql, null); carsdata = DBList.CovertDataTableToList <CarsData>(dt); } catch (Exception) { throw; } return(carsdata); }
public List <MainPhotos> getAllMainPhotos() { List <MainPhotos> mainphotos = new List <MainPhotos>(); try { string sql = "select MainPhoto from Cars"; DataTable dt = new DataTable(); dt = _idac.GetManyRows(sql, null); mainphotos = DBList.CovertDataTableToList <MainPhotos>(dt); } catch (Exception) { throw; } return(mainphotos); }
public List <CustomersList> getCustomersList() { List <CustomersList> customerlist = new List <CustomersList>(); try { string sql = "select * from CustomerContacts"; DataTable dt = new DataTable(); dt = _idac.GetManyRows(sql, null); customerlist = DBList.CovertDataTableToList <CustomersList>(dt); } catch (Exception) { throw; } return(customerlist); }
public WSSList() { dbSite = new DBSite("http://wsstest"); DBWeb dbWeb = dbSite.GetWeb("/dms/requests"); dbList = dbWeb.GetList("AccountingObjects"); }