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