public t_word_synonym getDataByCode(String code)
{
crm1Entities context = new crm1Entities();
t_word_synonym tt = context.t_word_synonym.Single(t => t.synonym_code == code);
return(tt);
}
public List <t_brand> getBrandByCondition(String[] brand, String floor, bool VipFlag)
{
crm1Entities context = new crm1Entities();
var q = from t in context.t_brand
select t;
if (null != brand && brand.Length > 0)
{
q = q.Where(p => brand.Contains(p.brand));
}
if (!String.IsNullOrWhiteSpace(floor))
{
q = q.Where(p => p.floor == floor);
}
if (VipFlag)
{
q = q.Where(p => p.vip_flag == 1);
}
List <t_brand> list = q.ToList();
return(list);
}
public List <t_word_synonym> getAllData()
{
crm1Entities context = new crm1Entities();
List <t_word_synonym> list = context.t_word_synonym.ToList();
return(list);
}
public void select()
{
crm1Entities context = new crm1Entities();
//var s = context.test_table.Where(tt => tt.name == "张三").Select(tt => tt);
//var tt = context.test_table.Find(4);
var tt = context.test_table.Single(t => t.name == "张三");
Debug.WriteLine(tt.id + tt.name + tt.date);
}
public List <t_basic_info> getAllData()
{
crm1Entities context = new crm1Entities();
var q = from t in context.t_basic_info
select t;
List <t_basic_info> list = q.ToList();
return(list);
}
public List <t_activity> getAllData()
{
crm1Entities context = new crm1Entities();
var q = from t in context.t_activity
select t;
List <t_activity> list = q.ToList();
return(list);
}
public void add(t_brand_product po)
{
crm1Entities context = new crm1Entities();
//3.将改对象放入EF容器中，默认会为该对象加一个封装类对象（代理类对象）
//用户对对象的操作，实际上是对代理类的操作
//DbEntityEntry保存着实体状态，当对象被加入时，EF默认为该对象设置State的属性为unchanged
DbEntityEntry <t_brand_product> entityEntry = context.Entry <t_brand_product>(po);
//4.设置对象的标志位Added
entityEntry.State = EntityState.Added;
//5.当调用SaveChanges()时，EF会遍历所有的代理类对象，并根据标志生成相应的sql语句
context.SaveChanges();
//Console.WriteLine("添加成功");
}
public List <t_brand> getAllData(bool VipFlag)
{
crm1Entities context = new crm1Entities();
var q = from t in context.t_brand
select t;
if (VipFlag)
{
q = q.Where(p => p.vip_flag == 1);
}
List <t_brand> list = q.ToList();
return(list);
}
public List <t_brand_product> getproductByBrandAndProduct(String brandCode, String productCode)
{
crm1Entities context = new crm1Entities();
var q = from t in context.t_brand_product
select t;
if (!String.IsNullOrWhiteSpace(brandCode))
{
q = q.Where(p => p.brand_code == brandCode);
}
if (!String.IsNullOrWhiteSpace(productCode))
{
q = q.Where(p => p.product_word_code == productCode);
}
List <t_brand_product> list = q.ToList();
return(list);
}
public void add()
{
//1.创建一个EF数据上下文对象
crm1Entities context = new crm1Entities();
//2.将要添加的数据，封装成对象
test_table tt = new test_table()
{
name = "zhang3", date = DateTime.Now
};
//3.将改对象放入EF容器中，默认会为该对象加一个封装类对象（代理类对象）
//用户对对象的操作，实际上是对代理类的操作
//DbEntityEntry保存着实体状态，当对象被加入时，EF默认为该对象设置State的属性为unchanged
DbEntityEntry <test_table> entityEntry = context.Entry <test_table>(tt);
//4.设置对象的标志位Added
entityEntry.State = EntityState.Added;
//5.当调用SaveChanges()时，EF会遍历所有的代理类对象，并根据标志生成相应的sql语句
context.SaveChanges();
//Console.WriteLine("添加成功");
}
public List <t_brand_businessformat> getBusinessformatByBrandAndBf(String brandCode, String businessformatCode)
{
crm1Entities context = new crm1Entities();
var q = from t in context.t_brand_businessformat
select t;
if (!String.IsNullOrWhiteSpace(brandCode))
{
q = q.Where(p => p.brand_code == brandCode);
}
if (!String.IsNullOrWhiteSpace(businessformatCode))
{
q = q.Where(p => p.businessformat_word_code == businessformatCode);
}
List <t_brand_businessformat> list = q.ToList();
return(list);
}
public List <t_activity> getDataByCondition(String basicInfoCode, String floor, DateTime?begin, DateTime?end)
{
crm1Entities context = new crm1Entities();
var q = from t in context.t_activity
select t;
if (!String.IsNullOrWhiteSpace(basicInfoCode))
{
q = q.Where(p => p.basic_info == basicInfoCode);
}
if (!String.IsNullOrWhiteSpace(floor))
{
q = q.Where(p => p.floor == floor);
}
if (begin.HasValue)
{
q = q.Where(p => p.begin <= end.Value);
}
if (end.HasValue)
{
q = q.Where(p => p.end >= begin.Value);
}
List <t_activity> list = q.ToList();
Debug.WriteLine(begin);
Debug.WriteLine(end);
Debug.WriteLine(q.ToString());
return(list);
}
