//#region Получение TipID //public static Int64? GetTipID(SqlConnection Connection, Int64 STUDYEAR_ID, Int64 TEACHERCHAIR_ID) //{ // DataTableContainer container = SqlData.GetDataSource<TIP>(Connection, null, // new SpParameter("@STUDYEAR_ID", STUDYEAR_ID), new SpParameter("@TEACHERCHAIR_ID", TEACHERCHAIR_ID)); // TIP row = container.Rows.FirstOrDefault() as TIP; // if (row != null) // return row.TIP_ID; // else // return null; //} //#endregion //public static Int64? CreateTIP(Int64 TeacherChairID, Int64 StudYearID, SqlData SqlData) //{ // var container = SqlData.GetTable<TIP>(); // var newRow = container.CreateNewRow<TIP>(); // newRow.TEACHERCHAIR_ID = TeacherChairID; // newRow.STUDYEAR_ID = StudYearID; // container.AddRow<TIP>(newRow); // SqlData.SaveAll(); // return newRow.TIP_ID; //} //public static Int64? CreateTIP(Int64 TeacherChairID, Int64 StudYearID) //{ // SqlData sqlData = new SqlData(new LocalConnection().GetConnection(), typeof(TIP)); // return CreateTIP(TeacherChairID, StudYearID, sqlData); //} #region (FillSqlData) Зполнение SqlData. Фактически получение данных с сервера public static bool FillSqlData(SqlData SqlData, Int64?WTP_ID) { //Logger.Start("FillSqlData"); foreach (var table in SqlData.GetTables()) { if (WTP_ID.HasValue) { if (table.ContainsSqlParameter(SqlCommandType.Select, "@WTP_ID")) { table.SetSqlParameterValue(SqlCommandType.Select, "@WTP_ID", WTP_ID.Value); } } } var factory = new WTPSqlDataFactory(SqlData); Type[] TableTypes = factory.Types.ToArray(); //Logger.Start("SqlData.FillTables"); bool ok = SqlData.FillTables(TableTypes); //Logger.Finish("SqlData.FillTables"); //Logger.Finish("FillSqlData"); return(ok); }