/// <summary>
/// Вернуть внешний вид для объекта в значение по умолчанию
/// </summary>
/// <param name="form">форма</param>
/// <param name="name">имя объекта</param>
/// <param name="pc">Объект, для которого необходимо вернуть состояние</param>
/// <returns>Возвращается массив байтов</returns>
public static void SaveDefaultLayout(this Form form, string name, Control pc)
{
using (var db = new ApplicationEntitie(0))
{
if (form == null)
{
throw new ArgumentException("Форма не задана");
}
var tableName = form.Name + "." + name;
var layout = pc.GetLayoutData();
var defLayout = db.DefaultLayouts.FirstOrDefault(dl => dl.TableName == tableName);
if (defLayout == null)
{
defLayout = new DefaultLayout
{
TableName = tableName,
Layout = layout
};
db.DefaultLayouts.Add(defLayout);
}
else if (!db.DefaultLayouts.Any(dl => dl.cs_Layout == SqlFunctions.Checksum(layout)))
{
defLayout.Layout = layout;
}
db.SaveChanges();
}
}
public void test6()
{
using (var edm = new NorthwindEntities())
{
var cust1 = from e in edm.Order_Details
where SqlFunctions.Checksum(e.Discount, e.Discount) == -377487330
select e;
//WHERE -377487330 = (CHECKSUM( CAST( [Extent1].[Discount] AS float), CAST( [Extent1].[Discount] AS float)))
cust1.TraceSql();
Console.WriteLine(cust1.Count());
}
}
public void test5()
{
using (var edm = new NorthwindEntities())
{
var cust1 = from e in edm.Employees
where SqlFunctions.Checksum(e.City, e.City) == -1659895301
select e;
//WHERE -1659895301 = (CHECKSUM([Extent1].[City], [Extent1].[City]))
cust1.TraceSql();
Console.WriteLine(cust1.Count());
}
}
public void test4()
{
using (var edm = new NorthwindEntities())
{
var cust1 = from e in edm.Employees
where SqlFunctions.Checksum("zxm", "zxm", e.City) == -1555502783
select e;
//WHERE -1555502783 = (CHECKSUM(N'zxm', N'zxm', [Extent1].[City]))
cust1.TraceSql();
Console.WriteLine(cust1.Count());
}
}
public void test3()
{
var dt1 = DateTime.Now;
using (var edm = new NorthwindEntities())
{
var cust1 = from e in edm.Employees
where SqlFunctions.Checksum(dt1, dt1, e.BirthDate) <= 524209
select e;
//WHERE (CHECKSUM(@p__linq__0, @p__linq__1, [Extent1].[BirthDate])) <= 524209
cust1.TraceSql();
Console.WriteLine();
}
}
public void test2()
{
var arr1 = BitConverter.GetBytes(123);
var arr2 = arr1;
using (var edm = new NorthwindEntities())
{
var cust1 = from e in edm.Employees
where SqlFunctions.Checksum(arr1, arr2, e.Photo) > 0
select e;
//WHERE (CHECKSUM(@p__linq__0, @p__linq__1, [Extent1].[Photo])) >0
cust1.TraceSql();
Console.WriteLine();
}
}
public void test1()
{
Guid?guid1 = new Guid("4A83D44A-5612-4E78-89EE-08F894912C0A");
Guid?guid2 = new Guid("4A83D44A-5612-4E78-89EE-08F894912C0A");
Guid?guid3 = new Guid("4A83D44A-5612-4E78-89EE-08F894912C0A");
using (var edm = new NorthwindEntities())
{
var cust1 = from c in edm.Customers
where SqlFunctions.Checksum(guid1, guid2, guid3) >= -1
select c;
//WHERE (CHECKSUM(@p__linq__0, @p__linq__1, @p__linq__2)) >= -1
cust1.TraceSql();
Console.WriteLine();
}
}
public BaseController()
{
this.MainLayoutViewModel = new MainLayoutViewModel();
var db = new BlogModelContainer();
var rnd = (new Random()).NextDouble();
var artigos = db.ArtigoSet
.OrderBy(x => SqlFunctions.Checksum(x.Id * rnd))
.ToList()
.Select(x => new ArtigoViewModel(x.Titulo, x.Conteudo, x.Imagem, x.Video, x.Permalink, x.Categoria, x.Autor, x.DataDePublicacao))
.ToList();
this.MainLayoutViewModel.MateriasMaisVista = artigos;
this.ViewData["MainLayoutViewModel"] = this.MainLayoutViewModel;
}
