private void Button_Click_9(object sender, RoutedEventArgs e)
{
//Изменить оценку по ID
string ssql = @"UPDATE Marks SET [Mark] = @Mark WHERE Id = @Id";
string connectionString = @"Data Source=DESKTOP-CDQ6MB6\SQLEXPRESS;Initial Catalog=gnevnik;Integrated Security=True"; //prak - имя базы данных(Поменять на свою)
SqlConnection conn = new SqlConnection(connectionString); // Подключение к БД
conn.Open();
SqlCommand command = new SqlCommand(ssql, conn);// Объект вывода запросов
command.Parameters.Add("@Id", SqlDbType.Int).Value = Convert.ToInt32(ID1.Text);
command.Parameters.Add("@MArk", SqlDbType.NVarChar).Value = MARK.Text;
SqlDataReader reader = command.ExecuteReader(); // Выаолнение запроса вывод информации
while (reader.Read()) //В цикле вывести всю информацию из таблици
{
InfoM.Text += reader[0] + " - Id студента " + "Дата: " + reader[1].ToString() + " Тема: " + reader[2].ToString() + " Оценка: " + reader[3].ToString() + "\n";
}
reader.Close();
MessageBox.Show("Оценка изменена");
MARK.Clear();
ID1.Clear();
InfoM.Clear();
InfoS.Clear();
}
public void CanCorrectlyBuildGraph1()
{
var builder = new ContainerBuilder();
builder.RegisterType <A1>().SingleInstance();
builder.RegisterType <CD1>().As <IC1, ID1>().SingleInstance();
builder.RegisterType <E1>().SingleInstance();
builder.Register(ctr => new B1(ctr.Resolve <A1>()));
var target = builder.Build();
E1 e = target.Resolve <E1>();
A1 a = target.Resolve <A1>();
B1 b = target.Resolve <B1>();
IC1 c = target.Resolve <IC1>();
ID1 d = target.Resolve <ID1>();
Assert.IsInstanceOf <CD1>(c);
CD1 cd = (CD1)c;
Assert.AreSame(a, b.A);
Assert.AreSame(a, cd.A);
Assert.AreNotSame(b, cd.B);
Assert.AreSame(c, e.C);
Assert.AreNotSame(b, e.B);
Assert.AreNotSame(e.B, cd.B);
}
private void CallbackMethod(IAsyncResult ar)
{
//Retrieve the invoking delegate.
ID1 dlgt = (ID1)ar.AsyncState;
//Call EndInvoke to retrieve the results.
int results = dlgt.EndInvoke(ar);
}
static void Main()
{
int ID = Thread.CurrentThread.ManagedThreadId;
MessageBox.Show("主线程ID为" + Convert.ToString(ID) + "!");
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
//MessageBox.Show("启动自检系统！", "国昂运营管理系统", MessageBoxButtons.OK, MessageBoxIcon.Warning);
Application.Run(new Form1());
//MessageBox.Show("主线程ID为"+Convert.ToString(ID)+"!");
ID1 a = new ID1(Thread1);
AsyncCallback callback = new AsyncCallback(Results);
IAsyncResult aa = a.BeginInvoke();
}
private void Button_Click_3(object sender, RoutedEventArgs e)
{
//Удалить по ID
string ssql = @"DELETE FROM Students WHERE Id = @Id";
string ssql2 = @"DELETE FROM Marks WHERE Id = @Id";
string connectionString = @"Data Source=DESKTOP-CDQ6MB6\SQLEXPRESS;Initial Catalog=gnevnik;Integrated Security=True"; //prak - имя базы данных(Поменять на свою)
SqlConnection conn = new SqlConnection(connectionString); // Подключение к БД
SqlCommand command = new SqlCommand(ssql, conn); // Объект вывода запросов
SqlCommand command2 = new SqlCommand(ssql2, conn); // Объект вывода запросов
command.Parameters.Add("@Id", SqlDbType.Int).Value = Convert.ToInt32(ID1.Text);
command2.Parameters.Add("@Id", SqlDbType.Int).Value = Convert.ToInt32(ID1.Text);
conn.Open();// Открытие Соединения
command.ExecuteNonQuery();
command2.ExecuteNonQuery();
MessageBox.Show("Данные удалены");
ID1.Clear();
InfoM.Clear();
InfoS.Clear();
}
public static bool operator ==(FullID ID1, FullID ID2)
{
if (ReferenceEquals(ID1, ID2))
{
return(true);
}
if (((object)ID1 == null) || ((object)ID2 == null))
{
return(false);
}
if (ID1.GetClientID() == ID2.GetClientID() &&
ID1.GetIDinCreator() == ID2.GetIDinCreator())
{
return(true);
}
return(false);
}
public void Can_create_from_id_string()
{
const string ID1 = "12.34.56";
const string ID2 = "AA.BB.Cc";
var id_123456 = new DeviceId(ID1);
var id_AABBCC = new DeviceId(ID2);
Assert.AreEqual(0x12, id_123456.IdHi);
Assert.AreEqual(0x34, id_123456.IdMiddle);
Assert.AreEqual(0x56, id_123456.IdLo);
Assert.AreEqual(ID1.ToUpper(), id_123456.ToString());
Assert.AreEqual(0xAA, id_AABBCC.IdHi);
Assert.AreEqual(0xBB, id_AABBCC.IdMiddle);
Assert.AreEqual(0xCC, id_AABBCC.IdLo);
Assert.AreEqual(ID2.ToUpper(), id_AABBCC.ToString());
Assert.Throws <ArgumentNullException>(() => { var id = new DeviceId((string)null); });
Assert.Throws <ArgumentOutOfRangeException>(() => { var id = new DeviceId("12;34.56"); });
Assert.Throws <ArgumentOutOfRangeException>(() => { var id = new DeviceId("12.34;56"); });
Assert.Throws <ArgumentOutOfRangeException>(() => { var id = new DeviceId("12.34.5"); });
Assert.Throws <ArgumentOutOfRangeException>(() => { var id = new DeviceId("12.34.5G"); });
}
static void MenuSelection(string selection)
{
switch (selection)
{
case "1":
{
var problem = new ID1();
problem.Start();
break;
}
case "2":
{
var problem = new ID2();
problem.Start();
break;
}
case "3":
{
var problem = new ID3();
problem.Start();
break;
}
case "4":
{
var problem = new ID4();
problem.Start();
break;
}
case "5":
{
var problem = new ID5();
problem.Start();
break;
}
case "6":
{
var problem = new ID6();
problem.Start();
break;
}
case "7":
{
var problem = new ID7();
problem.Start();
break;
}
case "8":
{
var problem = new ID8();
problem.Start();
break;
}
case "9":
{
var problem = new ID9();
problem.Start();
break;
}
case "10":
{
var problem = new ID10();
problem.Start();
break;
}
case "11":
{
var problem = new ID11();
problem.Start();
break;
}
case "12":
{
var problem = new ID12();
problem.Start();
break;
}
case "13":
{
var problem = new ID13();
problem.Start();
break;
}
case "14":
{
var problem = new ID14();
problem.Start();
break;
}
case "266":
{
var problem = new ID266();
problem.Start();
break;
}
default:
break;
}
}
