/// <summary>
/// Resets the activity.
/// </summary>
/// <param name="ID">The identifier.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/16
/// 描述：重置活动 开启新的抢购
public static bool ResetActivity(Guid ID)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
List <Model.OrderInfo> orderList = (from a in entitys.OrderInfoes select a).Where(a => a.ACTIVITYID == ID).ToList();
if (orderList.Count != 0)
{
foreach (Model.OrderInfo item in orderList)
{
OrderInfo order = item;
order.ISHISTORY = true;
//将实体对象加入EF对象容器中，并获取伪包装类对象
DbEntityEntry <OrderInfo> entry = entitys.Entry <OrderInfo>(order);
//将包装类对象 的状态设置为 Unchanged
entry.State = System.Data.Entity.EntityState.Modified;
entry.Property(a => a.ISHISTORY).IsModified = true;
entitys.SaveChanges();
}
}
return(true);
}
catch (DbEntityValidationException dbEx)
{
return(false);
throw;
}
}
}
public static bool UpdateActivityPro(Guid id, string buytime, string num, string imagepath, string desimgpath)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
List <ActivityPro> list = entitys.ActivityProes.Where(a => a.ID == id).ToList();
if (list.Count > 0)
{
ActivityPro att = list[0];
att.BUYTIME = buytime;
att.NUM = int.Parse(num);
att.IMAGEPATH = imagepath;
att.DESIMGPATH = desimgpath;
//将实体对象加入EF对象容器中，并获取伪包装类对象
DbEntityEntry <ActivityPro> entry = entitys.Entry <ActivityPro>(att);
entry.State = System.Data.Entity.EntityState.Modified;
entitys.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
}
/// <summary>
/// Updates the activity.
/// </summary>
/// <param name="name">The name.</param>
/// <param name="buytime">The buytime.</param>
/// <param name="num">The number.</param>
/// <param name="type">The type.</param>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：编辑活动
public static bool UpdateActivity(Guid id, string name, string type, string code)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
Activity att = new Activity();
att.NAME = name;
att.TYPE = int.Parse(type);
att.CODE = code;
att.ID = id;
//将实体对象加入EF对象容器中，并获取伪包装类对象
DbEntityEntry <Activity> entry = entitys.Entry <Activity>(att);
//将包装类对象 的状态设置为 Unchanged
entry.State = System.Data.Entity.EntityState.Modified;
entry.Property(a => a.NAME).IsModified = true;
entry.Property(a => a.TYPE).IsModified = true;
entry.Property(a => a.CODE).IsModified = true;
entitys.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
}
/// <summary>
/// Inserts the activity pro.
/// </summary>
/// <param name="activityID">The activity identifier.</param>
/// <param name="procode">The procode.</param>
/// <param name="proid">The proid.</param>
/// <param name="buytime">The buytime.</param>
/// <param name="num">The number.</param>
/// <param name="imagepath">The imagepath.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/11
/// 描述：插入活动商品
public static bool InsertActivityPro(Guid activityID, string procode, Guid proid, string buytime, string num, string imagepath, string desimgpath)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
ActivityPro att = new ActivityPro();
att.ID = Guid.NewGuid();
att.ACTIVITYID = activityID;
att.PROCODE = procode;
att.PROID = proid;
att.BUYTIME = buytime;
att.NUM = int.Parse(num);
att.IMAGEPATH = imagepath;
att.DESIMGPATH = desimgpath;
entitys.ActivityProes.Add(att);
entitys.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
}
public static bool UpdatePayOrder(bool inter, bool intersuccess, string orderid, string paydate, string usernum, string amount)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List <OrderInfo> orderInfoList = (from a in entitys.OrderInfoes select a).Where(a => a.ORDERID == orderid).ToList();
try
{
OrderInfo oi = orderInfoList[0];
oi.INTERFACE = inter;
oi.INTERSUCCES = intersuccess;
oi.PAYDATE = paydate;
oi.USERNUM = usernum;
oi.AMOUNT = int.Parse(amount);
//将实体对象加入EF对象容器中，并获取伪包装类对象
DbEntityEntry <OrderInfo> entry = entitys.Entry <OrderInfo>(oi);
//将包装类对象 的状态设置为 Unchanged
entry.State = System.Data.Entity.EntityState.Modified;
entry.Property(a => a.INTERFACE).IsModified = true;
entry.Property(a => a.INTERSUCCES).IsModified = true;
entry.Property(a => a.PAYDATE).IsModified = true;
entry.Property(a => a.USERNUM).IsModified = true;
entry.Property(a => a.AMOUNT).IsModified = true;
entitys.SaveChanges();
return(true);
}
catch (DbEntityValidationException dbEx)
{
return(false);
throw;
}
}
}
/// <summary>
/// Updates the logistics.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="logistics">The logistics.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/23
/// 描述：更新物流单号
public static bool UpdateLogistics(Guid id, string logistics)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List <OrderInfo> orderInfoList = (from a in entitys.OrderInfoes select a).Where(a => a.ID == id).ToList();
try
{
OrderInfo oi = orderInfoList[0];
oi.LOGISTICS = logistics;
oi.ISPRINTED = true;
//将实体对象加入EF对象容器中，并获取伪包装类对象
DbEntityEntry <OrderInfo> entry = entitys.Entry <OrderInfo>(oi);
//将包装类对象 的状态设置为 Unchanged
entry.State = System.Data.Entity.EntityState.Modified;
entry.Property(a => a.LOGISTICS).IsModified = true;
entry.Property(a => a.ISPRINTED).IsModified = true;
entitys.SaveChanges();
return(true);
}
catch (DbEntityValidationException dbEx)
{
return(false);
throw;
}
}
}
/// <summary>
/// Gets the activity pro.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/11
/// 描述：获取商品集合
public List <Model.ActivityProM> GetActivityPro(Guid id)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
var bcilist = (from s in entitys.BestCherryInfoes
join r
in entitys.ActivityProes on s.CODE equals r.PROCODE into g
from o in g.DefaultIfEmpty()
select new
{
o.ACTIVITYID,
o.BUYTIME,
s.CODE,
o.IMAGEPATH,
s.PRICE,
o.PROID,
s.SMALLTITLE,
s.TITLE,
o.NUM,
s.MEMBERPRICE,
s.ID,
s.POLL
}).Where(a => a.ACTIVITYID == id).ToList();
List <Model.ActivityProM> models = bcilist.Select(x => new Model.ActivityProM()
{
ACTIVITYID = x.ACTIVITYID, BUYTIME = x.BUYTIME, CODE = x.CODE, IMAGEPATH = x.IMAGEPATH, PRICE = x.PRICE, PROID = x.ID, SMALLTITLE = x.SMALLTITLE, TITLE = x.TITLE, NUM = x.NUM, MEMBERPRICE = x.MEMBERPRICE, POLL = x.POLL
}).OrderBy(a => a.PRICE).ToList();
return(models);
}
}
/// <summary>
/// Updates the type of the icbc cherry information and.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="title">The title.</param>
/// <param name="color">The color.</param>
/// <param name="price">The price.</param>
/// <param name="memberprice">The memberprice.</param>
/// <param name="imgpath">The imgpath.</param>
/// <param name="smalltitle">The smalltitle.</param>
/// <param name="code">The code.</param>
/// <param name="des">The DES.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：插入商品信息
public static bool InsertICBCCherryInfo(string title, string color, string price, string memberprice, string imgpath, string smalltitle, string code, string des)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
BestCherryInfo bci = new BestCherryInfo();
bci.ID = Guid.NewGuid();
bci.TITLE = title;
bci.COLOR = color;
bci.PRICE = int.Parse(price);
bci.MEMBERPRICE = int.Parse(memberprice);
bci.IMAGEPATH = imgpath;
bci.SMALLTITLE = smalltitle;
bci.CODE = code;
entitys.BestCherryInfoes.Add(bci);
entitys.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
}
/// <summary>
/// Gets the activity pro.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/11
/// 描述：获取商品集合
public List<Model.ActivityProM> GetActivityPro(Guid id)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
var bcilist = (from s in entitys.BestCherryInfoes
join r
in entitys.ActivityProes on s.CODE equals r.PROCODE into g
from o in g.DefaultIfEmpty()
select new
{
o.ACTIVITYID,
o.BUYTIME,
s.CODE,
o.IMAGEPATH,
s.PRICE,
o.PROID,
s.SMALLTITLE,
s.TITLE,
o.NUM,
s.MEMBERPRICE,
s.ID,
s.POLL
}).Where(a => a.ACTIVITYID == id).ToList();
List<Model.ActivityProM> models = bcilist.Select(x => new Model.ActivityProM() { ACTIVITYID = x.ACTIVITYID, BUYTIME = x.BUYTIME, CODE = x.CODE, IMAGEPATH = x.IMAGEPATH, PRICE = x.PRICE, PROID = x.ID, SMALLTITLE = x.SMALLTITLE, TITLE = x.TITLE, NUM = x.NUM, MEMBERPRICE = x.MEMBERPRICE, POLL = x.POLL }).OrderBy(a => a.PRICE).ToList();
return models;
}
}
/// <summary>
/// Gets the success order information list by code.
/// </summary>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/9
/// 描述：获取成功的订单数量（限时购）
public static int GetSuccessOrderInfoListByCode(string code)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
int count = (from u in entitys.OrderInfoes select u).Where(a => a.TYPE == 1).Where(a => a.ORDERLIST.Contains(code)).Where(a => a.ISHISTORY == false).ToList().Count;
return(count);
}
}
/// <summary>
/// Gets the activity pro.
/// </summary>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/14
/// 描述：通过CODE获取活动的商品设置信息
public static List <Model.ActivityPro> GetActivityPro(string code, Guid activityid)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
var list = (from u in entitys.ActivityProes select u).Where(a => a.PROCODE == code).Where(a => a.ACTIVITYID == activityid).ToList();
return(list);
}
}
/// <summary>
/// Gets all product.
/// </summary>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：获取所有商品
public static List <Model.BestCherryInfo> GetAllProduct()
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
var list = (from u in entitys.BestCherryInfoes select u).ToList();
return(list);
}
}
/// <summary>
/// Gets the cherry.
/// </summary>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/14
/// 描述：通过ID来获取商品信息
public static List <Model.BestCherryInfo> GetCherry(Guid ID)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
var list = (from u in entitys.BestCherryInfoes select u).Where(a => a.ID == ID).Take(1).ToList();
return(list);
}
}
/// <summary>
/// Gets the activity.
/// </summary>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：通过Code获取活动
public static List <Model.Activity> GetActivity(string code)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
var list = (from u in entitys.Activities select u).Where(a => a.CODE == code).ToList();
return(list);
}
}
/// <summary>
/// Gets the order information not pay.
/// </summary>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/17
/// 描述：未付款订单数
public static int GetOrderInfoNotPay()
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
int count = (from o in entitys.OrderInfoes select o).Where(o => o.INTERFACE == false).Where(o => o.SENDORDERTIME.Value.Day == DateTime.Now.Day).Where(o => o.SENDORDERTIME.Value.Month == DateTime.Now.Month).GroupBy(o => new { o.CONSIGNEE, o.MOBILE, o.RECEIVER_STATE, o.RECEIVER_CITY, o.RECEIVER_DISTRICT, o.ADDRESS, o.ORDERLIST }).ToList().Count;
return(count);
}
}
/// <summary>
/// Gets the activity pro.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/17
/// 描述：通过ID获取活动的商品设置信息
public static List <Model.ActivityPro> GetActivityPro(Guid id)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
var list = (from u in entitys.ActivityProes select u).Where(a => a.ID == id).ToList();
return(list);
}
}
/// <summary>
/// Gets the order information have pay.
/// </summary>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/17
/// 描述：已付款数
public static int GetOrderInfoHavePay()
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
string dt = DateTime.Now.ToString("yyyyMMdd");
int count = (from o in entitys.OrderInfoes select o).Where(o => o.PAYDATE.Contains(dt)).Where(o => o.INTERFACE == true).ToList().Count;
return(count);
}
}
/// <summary>
/// Gets the order information list by name order by have printed.
/// </summary>
/// <param name="name">The name.</param>
/// <param name="activityID">The activity identifier.</param>
/// <param name="isPay">if set to <c>true</c> [is pay].</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/23
/// 描述：通过名称和活动类型来获取订单列表(按未打印排序)
public static List <Model.OrderInfo> GetOrderInfoListByNameOrderByNotPrinted(string name, Guid activityID, bool isPay, bool isPrinted)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List <Model.OrderInfo> list;
list = (from u in entitys.OrderInfoes select u).Where(a => a.CONSIGNEE.Contains(name)).Where(a => a.ACTIVITYID == activityID).Where(a => a.INTERFACE == isPay).Where(a => a.ISPRINTED == isPrinted).OrderByDescending(a => a.ISPRINTED).OrderByDescending(a => a.SENDORDERTIME).ToList();
return(list);
}
}
/// <summary>
/// Gets the type of the activityes by.
/// </summary>
/// <param name="type">The type.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/14
/// 描述：按类型找活动
public static List <Model.Activity> GetActivityesByType(int type)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List <Model.Activity> list;
list = (from u in entitys.Activities select u).Where(a => a.TYPE == type).ToList();
return(list);
}
}
/// <summary>
/// Gets the order information list by mobile.
/// </summary>
/// <param name="mobile">The mobile.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/18
/// 描述：根据手机号查询已付款订单
public static List <Model.OrderInfo> GetOrderInfoListByMobile(string mobile)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List <Model.OrderInfo> list;
list = (from u in entitys.OrderInfoes select u).Where(a => a.MOBILE == mobile).Where(a => a.INTERFACE == true).OrderByDescending(a => a.PAYDATE).ToList();
return(list);
}
}
/// <summary>
/// Gets the cherry.
/// </summary>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：通过名称来查找商品
public static List <Model.BestCherryInfo> GetCherryByName(string name)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List <Model.BestCherryInfo> list;
list = (from u in entitys.BestCherryInfoes select u).Where(a => a.TITLE.Contains(name)).ToList();
return(list);
}
}
/// <summary>
/// Gets the name of the activity by.
/// </summary>
/// <param name="name">The name.</param>
/// <param name="type">The type.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/11
/// 描述：根据名称和类型来查找活动
public static List <Model.Activity> GetActivityByName(string name, int type)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List <Model.Activity> list;
list = (from u in entitys.Activities select u).Where(a => a.NAME.Contains(name)).Where(a => a.TYPE == type).ToList();
return(list);
}
}
/// <summary>
/// Gets the cherry.
/// </summary>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/9
/// 描述：通过手机号查询是否购买过促销商品(30分钟内)
public static int GetSuccessOrderInfoListByMobile(string mobile)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
DateTime dt = DateTime.Now.AddMinutes(-30);
int count1 = (from u in entitys.OrderInfoes select u).Where(a => a.TYPE == 1).Where(a => a.MOBILE.Contains(mobile)).Where(a => a.SENDORDERTIME >= dt).ToList().Count;
int count2 = (from u in entitys.OrderInfoes select u).Where(a => a.TYPE == 1).Where(a => a.MOBILE.Contains(mobile)).Where(a => a.INTERFACE == true).ToList().Count;
return(count1 + count2);
}
}
/// <summary>
/// Gets the normal cherry.
/// </summary>
/// <param name="activityID">The activity identifier.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/17
/// 描述：获取单个正常活动下的所有普通商品
public static List <Model.BestCherryInfo> GetNormalCherry(Guid activityID)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
var activityProList = (from u in entitys.ActivityProes select u).Where(a => a.ACTIVITYID == activityID).ToList();
List <Model.BestCherryInfo> list = new List <BestCherryInfo>();
foreach (ActivityPro item in activityProList)
{
list.Add((from u in entitys.BestCherryInfoes select u).Where(a => a.CODE == item.PROCODE).ToList()[0]);
}
return(list);
}
}
/// <summary>
/// Checks the activity.
/// </summary>
/// <param name="code">The code.</param>
/// <param name="activityid">The activityid.</param>
/// <param name="type">The type.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/16
/// 描述：检查参数
public static bool CheckActivity(string code, Guid activityid,string type)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
int typeInt = int.Parse(type);
var list = (from u in entitys.Activities select u).Where(a => a.TYPE == typeInt).Where(a => a.ID == activityid).ToList();
var listPro = (from u in entitys.ActivityProes select u).Where(a => a.PROCODE == code).Where(a => a.ACTIVITYID == activityid).ToList();
if (list.Count>0&listPro.Count>0)
{
return true;
}
else
{
return false;
}
}
}
/// <summary>
/// Checks the activity.
/// </summary>
/// <param name="code">The code.</param>
/// <param name="activityid">The activityid.</param>
/// <param name="type">The type.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/16
/// 描述：检查参数
public static bool CheckActivity(string code, Guid activityid, string type)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
int typeInt = int.Parse(type);
var list = (from u in entitys.Activities select u).Where(a => a.TYPE == typeInt).Where(a => a.ID == activityid).ToList();
var listPro = (from u in entitys.ActivityProes select u).Where(a => a.PROCODE == code).Where(a => a.ACTIVITYID == activityid).ToList();
if (list.Count > 0 & listPro.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// Inserts the activity.
/// </summary>
/// <param name="name">The name.</param>
/// <param name="buytime">The buytime.</param>
/// <param name="num">The number.</param>
/// <param name="type">The type.</param>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：新增活动
public static bool InsertActivity(string name, string type, string code)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
Activity att = new Activity();
att.ID = Guid.NewGuid();
att.NAME = name;
att.TYPE = int.Parse(type);
att.CODE = code;
entitys.Activities.Add(att);
entitys.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
}
/// <summary>
/// Deletes the activity pro.
/// </summary>
/// <param name="ID">The identifier.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/14
/// 描述：删除活动商品
public static bool DeleteActivityPro(Guid ID)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List<ActivityPro> activityProList = (from a in entitys.ActivityProes select a).Where(a => a.ID == ID).ToList();
try
{
if (activityProList.Count >= 1)
{
ActivityPro deleteActivityProes = activityProList[0];
entitys.ActivityProes.Attach(deleteActivityProes);
entitys.ActivityProes.Remove(deleteActivityProes);
entitys.SaveChanges();
}
return true;
}
catch (Exception)
{
return false;
throw;
}
}
}
/// <summary>
/// Updates the icbc cherry information.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="title">The title.</param>
/// <param name="color">The color.</param>
/// <param name="price">The price.</param>
/// <param name="memberprice">The memberprice.</param>
/// <param name="imgpath">The imgpath.</param>
/// <param name="smalltitle">The smalltitle.</param>
/// <param name="code">The code.</param>
/// <param name="des">The DES.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：更新商品信息
public static bool UpdateICBCCherryInfo(Guid id, string title, string color, string price, string memberprice, string imgpath, string smalltitle, string code, string des)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
BestCherryInfo bci = new BestCherryInfo();
bci.ID = id;
bci.TITLE = title;
bci.COLOR = color;
bci.PRICE = int.Parse(price);
bci.MEMBERPRICE = int.Parse(memberprice);
bci.IMAGEPATH = imgpath;
bci.SMALLTITLE = smalltitle;
bci.CODE = code;
//将实体对象加入EF对象容器中，并获取伪包装类对象
DbEntityEntry <BestCherryInfo> entry = entitys.Entry <BestCherryInfo>(bci);
//将包装类对象 的状态设置为 Unchanged
entry.State = System.Data.Entity.EntityState.Modified;
entry.Property(a => a.TITLE).IsModified = true;
entry.Property(a => a.CODE).IsModified = true;
entry.Property(a => a.COLOR).IsModified = true;
entry.Property(a => a.PRICE).IsModified = true;
entry.Property(a => a.MEMBERPRICE).IsModified = true;
entry.Property(a => a.IMAGEPATH).IsModified = true;
entry.Property(a => a.SMALLTITLE).IsModified = true;
entitys.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
}
/// <summary>
/// Updates the poll.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="title">The title.</param>
/// <param name="color">The color.</param>
/// <param name="price">The price.</param>
/// <param name="memberprice">The memberprice.</param>
/// <param name="imgpath">The imgpath.</param>
/// <param name="smalltitle">The smalltitle.</param>
/// <param name="code">The code.</param>
/// <param name="des">The DES.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/14
/// 描述：更新投票数
public static bool UpdatePoll(Guid ID)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
List <Model.BestCherryInfo> list = WebBLL.GetCherry(ID);
if (list.Count != 0)
{
BestCherryInfo bci = list[0];
int poll = 0;
if (list[0].POLL != null)
{
poll = (int)list[0].POLL;
}
bci.POLL = poll + 1;
//将实体对象加入EF对象容器中，并获取伪包装类对象
DbEntityEntry <BestCherryInfo> entry = entitys.Entry <BestCherryInfo>(bci);
//将包装类对象 的状态设置为 Unchanged
entry.State = System.Data.Entity.EntityState.Modified;
entry.Property(a => a.POLL).IsModified = true;
entitys.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (DbEntityValidationException dbEx)
{
return(false);
throw;
}
}
}
/// <summary>
/// Inserts the order.
/// </summary>
/// <param name="consignee">The consignee.</param>
/// <param name="membernum">The membernum.</param>
/// <param name="mobile">The mobile.</param>
/// <param name="receiver_state">The receiver_state.</param>
/// <param name="receiver_city">The receiver_city.</param>
/// <param name="receiver_district">The receiver_district.</param>
/// <param name="address">The address.</param>
/// <param name="orderlist">The orderlist.</param>
/// <param name="orderid">The orderid.</param>
/// <param name="allPrice">All price.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：提交订单信息
public static bool InsertOrder(string consignee, string membernum, string mobile, string receiver_state, string receiver_city, string receiver_district, string address, string orderlist, string orderid, string allPrice, int type, Guid activityid, string remark)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
OrderInfo oi = new OrderInfo();
oi.ID = Guid.NewGuid();
oi.SENDORDERTIME = DateTime.Now;
oi.CONSIGNEE = consignee;
oi.MOBILE = mobile;
oi.MEMBERNUM = membernum;
oi.RECEIVER_STATE = receiver_state;
oi.RECEIVER_CITY = receiver_city;
oi.RECEIVER_DISTRICT = receiver_district;
oi.ADDRESS = address;
oi.ORDERLIST = orderlist;
oi.INTERFACE = false;
oi.INTERSUCCES = false;
oi.ORDERID = orderid;
oi.ALLPRICE = int.Parse(allPrice);
oi.TYPE = type;
oi.ACTIVITYID = activityid;
oi.ISHISTORY = false;
oi.REMARK = remark;
entitys.OrderInfoes.Add(oi);
entitys.SaveChanges();
return(true);
}
catch (DbEntityValidationException dbEx)
{
return(false);
throw;
}
}
}
/// <summary>
/// Deletes the activity pro.
/// </summary>
/// <param name="ID">The identifier.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/14
/// 描述：删除活动商品
public static bool DeleteActivityPro(Guid ID)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List <ActivityPro> activityProList = (from a in entitys.ActivityProes select a).Where(a => a.ID == ID).ToList();
try
{
if (activityProList.Count >= 1)
{
ActivityPro deleteActivityProes = activityProList[0];
entitys.ActivityProes.Attach(deleteActivityProes);
entitys.ActivityProes.Remove(deleteActivityProes);
entitys.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
}
/// <summary>
/// Inserts the activity pro.
/// </summary>
/// <param name="activityID">The activity identifier.</param>
/// <param name="procode">The procode.</param>
/// <param name="proid">The proid.</param>
/// <param name="buytime">The buytime.</param>
/// <param name="num">The number.</param>
/// <param name="imagepath">The imagepath.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/11
/// 描述：插入活动商品
public static bool InsertActivityPro(Guid activityID, string procode, Guid proid, string buytime, string num, string imagepath,string desimgpath)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
ActivityPro att = new ActivityPro();
att.ID = Guid.NewGuid();
att.ACTIVITYID = activityID;
att.PROCODE = procode;
att.PROID = proid;
att.BUYTIME = buytime;
att.NUM = int.Parse(num);
att.IMAGEPATH = imagepath;
att.DESIMGPATH = desimgpath;
entitys.ActivityProes.Add(att);
entitys.SaveChanges();
return true;
}
catch (Exception)
{
return false;
throw;
}
}
}
/// <summary>
/// Gets the cherry.
/// </summary>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/9
/// 描述：通过手机号查询是否购买过促销商品(30分钟内)
public static int GetSuccessOrderInfoListByMobile(string mobile)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
DateTime dt = DateTime.Now.AddMinutes(-30);
int count1 = (from u in entitys.OrderInfoes select u).Where(a => a.TYPE == 1).Where(a => a.MOBILE.Contains(mobile)).Where(a=>a.SENDORDERTIME>=dt).ToList().Count;
int count2 = (from u in entitys.OrderInfoes select u).Where(a => a.TYPE == 1).Where(a => a.MOBILE.Contains(mobile)).Where(a =>a.INTERFACE==true).ToList().Count;
return count1+count2;
}
}
/// <summary>
/// Inserts the activity.
/// </summary>
/// <param name="name">The name.</param>
/// <param name="buytime">The buytime.</param>
/// <param name="num">The number.</param>
/// <param name="type">The type.</param>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：新增活动
public static bool InsertActivity(string name, string type, string code)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
Activity att = new Activity();
att.ID = Guid.NewGuid();
att.NAME = name;
att.TYPE = int.Parse(type);
att.CODE = code;
entitys.Activities.Add(att);
entitys.SaveChanges();
return true;
}
catch (Exception)
{
return false;
throw;
}
}
}
/// <summary>
/// Gets the order information not pay.
/// </summary>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/17
/// 描述：未付款订单数
public static int GetOrderInfoNotPay()
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
int count = (from o in entitys.OrderInfoes select o).Where(o => o.INTERFACE == false).Where(o => o.SENDORDERTIME.Value.Day == DateTime.Now.Day).Where(o => o.SENDORDERTIME.Value.Month == DateTime.Now.Month).GroupBy(o => new { o.CONSIGNEE, o.MOBILE, o.RECEIVER_STATE, o.RECEIVER_CITY, o.RECEIVER_DISTRICT, o.ADDRESS, o.ORDERLIST }).ToList().Count;
return count;
}
}
/// <summary>
/// Gets the success order information list by code.
/// </summary>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/9
/// 描述：获取成功的订单数量（限时购）
public static int GetSuccessOrderInfoListByCode(string code)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
int count = (from u in entitys.OrderInfoes select u).Where(a => a.TYPE == 1).Where(a => a.ORDERLIST.Contains(code)).Where(a=>a.ISHISTORY==false).ToList().Count;
return count;
}
}
/// <summary>
/// Gets the order information list by mobile.
/// </summary>
/// <param name="mobile">The mobile.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/18
/// 描述：根据手机号查询已付款订单
public static List<Model.OrderInfo> GetOrderInfoListByMobile(string mobile)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List<Model.OrderInfo> list;
list = (from u in entitys.OrderInfoes select u).Where(a => a.MOBILE==mobile).Where(a => a.INTERFACE == true).OrderByDescending(a => a.PAYDATE).ToList();
return list;
}
}
/// <summary>
/// Gets the order information list by name order by have printed.
/// </summary>
/// <param name="name">The name.</param>
/// <param name="activityID">The activity identifier.</param>
/// <param name="isPay">if set to <c>true</c> [is pay].</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/23
/// 描述：通过名称和活动类型来获取订单列表(按未打印排序)
public static List<Model.OrderInfo> GetOrderInfoListByNameOrderByNotPrinted(string name, Guid activityID, bool isPay,bool isPrinted)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List<Model.OrderInfo> list;
list = (from u in entitys.OrderInfoes select u).Where(a => a.CONSIGNEE.Contains(name)).Where(a => a.ACTIVITYID == activityID).Where(a => a.INTERFACE == isPay).Where(a=>a.ISPRINTED==isPrinted).OrderByDescending(a=>a.ISPRINTED).OrderByDescending(a => a.SENDORDERTIME).ToList();
return list;
}
}
/// <summary>
/// Gets the normal cherry.
/// </summary>
/// <param name="activityID">The activity identifier.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/17
/// 描述：获取单个正常活动下的所有普通商品
public static List<Model.BestCherryInfo> GetNormalCherry(Guid activityID)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
var activityProList = (from u in entitys.ActivityProes select u).Where(a => a.ACTIVITYID == activityID).ToList();
List<Model.BestCherryInfo> list = new List<BestCherryInfo>();
foreach (ActivityPro item in activityProList)
{
list.Add((from u in entitys.BestCherryInfoes select u).Where(a => a.CODE == item.PROCODE).ToList()[0]);
}
return list;
}
}
/// <summary>
/// Gets the order information have pay.
/// </summary>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/17
/// 描述：已付款数
public static int GetOrderInfoHavePay()
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
string dt = DateTime.Now.ToString("yyyyMMdd");
int count = (from o in entitys.OrderInfoes select o).Where(o => o.PAYDATE.Contains(dt)).Where(o => o.INTERFACE == true).ToList().Count;
return count;
}
}
/// <summary>
/// Gets the activity.
/// </summary>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：通过Code获取活动
public static List<Model.Activity> GetActivity(string code)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
var list = (from u in entitys.Activities select u).Where(a => a.CODE == code).ToList();
return list;
}
}
/// <summary>
/// Updates the type of the icbc cherry information and.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="title">The title.</param>
/// <param name="color">The color.</param>
/// <param name="price">The price.</param>
/// <param name="memberprice">The memberprice.</param>
/// <param name="imgpath">The imgpath.</param>
/// <param name="smalltitle">The smalltitle.</param>
/// <param name="code">The code.</param>
/// <param name="des">The DES.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：插入商品信息
public static bool InsertICBCCherryInfo(string title, string color, string price, string memberprice, string imgpath, string smalltitle, string code, string des)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
BestCherryInfo bci = new BestCherryInfo();
bci.ID = Guid.NewGuid();
bci.TITLE = title;
bci.COLOR = color;
bci.PRICE = int.Parse(price);
bci.MEMBERPRICE = int.Parse(memberprice);
bci.IMAGEPATH = imgpath;
bci.SMALLTITLE = smalltitle;
bci.CODE = code;
entitys.BestCherryInfoes.Add(bci);
entitys.SaveChanges();
return true;
}
catch (Exception)
{
return false;
throw;
}
}
}
/// <summary>
/// Resets the activity.
/// </summary>
/// <param name="ID">The identifier.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/16
/// 描述：重置活动 开启新的抢购
public static bool ResetActivity(Guid ID)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
List<Model.OrderInfo> orderList = (from a in entitys.OrderInfoes select a).Where(a => a.ACTIVITYID == ID).ToList();
if (orderList.Count != 0)
{
foreach (Model.OrderInfo item in orderList)
{
OrderInfo order = item;
order.ISHISTORY = true;
//将实体对象加入EF对象容器中，并获取伪包装类对象
DbEntityEntry<OrderInfo> entry = entitys.Entry<OrderInfo>(order);
//将包装类对象 的状态设置为 Unchanged
entry.State = System.Data.Entity.EntityState.Modified;
entry.Property(a => a.ISHISTORY).IsModified = true;
entitys.SaveChanges();
}
}
return true;
}
catch (DbEntityValidationException dbEx)
{
return false;
throw;
}
}
}
public static bool UpdateActivityPro(Guid id, string buytime, string num, string imagepath, string desimgpath)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
List<ActivityPro> list = entitys.ActivityProes.Where(a => a.ID == id).ToList();
if (list.Count>0)
{
ActivityPro att = list[0];
att.BUYTIME = buytime;
att.NUM = int.Parse(num);
att.IMAGEPATH = imagepath;
att.DESIMGPATH = desimgpath;
//将实体对象加入EF对象容器中，并获取伪包装类对象
DbEntityEntry<ActivityPro> entry = entitys.Entry<ActivityPro>(att);
entry.State = System.Data.Entity.EntityState.Modified;
entitys.SaveChanges();
}
return true;
}
catch (Exception)
{
return false;
throw;
}
}
}
/// <summary>
/// Updates the logistics.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="logistics">The logistics.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/23
/// 描述：更新物流单号
public static bool UpdateLogistics(Guid id,string logistics)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List<OrderInfo> orderInfoList = (from a in entitys.OrderInfoes select a).Where(a => a.ID == id).ToList();
try
{
OrderInfo oi = orderInfoList[0];
oi.LOGISTICS = logistics;
oi.ISPRINTED = true;
//将实体对象加入EF对象容器中，并获取伪包装类对象
DbEntityEntry<OrderInfo> entry = entitys.Entry<OrderInfo>(oi);
//将包装类对象 的状态设置为 Unchanged
entry.State = System.Data.Entity.EntityState.Modified;
entry.Property(a => a.LOGISTICS).IsModified = true;
entry.Property(a => a.ISPRINTED).IsModified = true;
entitys.SaveChanges();
return true;
}
catch (DbEntityValidationException dbEx)
{
return false;
throw;
}
}
}
/// <summary>
/// Inserts the order.
/// </summary>
/// <param name="consignee">The consignee.</param>
/// <param name="membernum">The membernum.</param>
/// <param name="mobile">The mobile.</param>
/// <param name="receiver_state">The receiver_state.</param>
/// <param name="receiver_city">The receiver_city.</param>
/// <param name="receiver_district">The receiver_district.</param>
/// <param name="address">The address.</param>
/// <param name="orderlist">The orderlist.</param>
/// <param name="orderid">The orderid.</param>
/// <param name="allPrice">All price.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：提交订单信息
public static bool InsertOrder(string consignee, string membernum, string mobile, string receiver_state, string receiver_city, string receiver_district, string address, string orderlist, string orderid, string allPrice, int type, Guid activityid,string remark)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
OrderInfo oi = new OrderInfo();
oi.ID = Guid.NewGuid();
oi.SENDORDERTIME = DateTime.Now;
oi.CONSIGNEE = consignee;
oi.MOBILE = mobile;
oi.MEMBERNUM = membernum;
oi.RECEIVER_STATE = receiver_state;
oi.RECEIVER_CITY = receiver_city;
oi.RECEIVER_DISTRICT = receiver_district;
oi.ADDRESS = address;
oi.ORDERLIST = orderlist;
oi.INTERFACE = false;
oi.INTERSUCCES = false;
oi.ORDERID = orderid;
oi.ALLPRICE = int.Parse(allPrice);
oi.TYPE = type;
oi.ACTIVITYID = activityid;
oi.ISHISTORY = false;
oi.REMARK = remark;
entitys.OrderInfoes.Add(oi);
entitys.SaveChanges();
return true;
}
catch (DbEntityValidationException dbEx)
{
return false;
throw;
}
}
}
/// <summary>
/// Gets the cherry.
/// </summary>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：通过名称来查找商品
public static List<Model.BestCherryInfo> GetCherryByName(string name)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List<Model.BestCherryInfo> list;
list = (from u in entitys.BestCherryInfoes select u).Where(a => a.TITLE.Contains(name)).ToList();
return list;
}
}
/// <summary>
/// Updates the activity.
/// </summary>
/// <param name="name">The name.</param>
/// <param name="buytime">The buytime.</param>
/// <param name="num">The number.</param>
/// <param name="type">The type.</param>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：编辑活动
public static bool UpdateActivity(Guid id, string name, string type, string code)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
Activity att = new Activity();
att.NAME = name;
att.TYPE = int.Parse(type);
att.CODE = code;
att.ID = id;
//将实体对象加入EF对象容器中，并获取伪包装类对象
DbEntityEntry<Activity> entry = entitys.Entry<Activity>(att);
//将包装类对象 的状态设置为 Unchanged
entry.State = System.Data.Entity.EntityState.Modified;
entry.Property(a => a.NAME).IsModified = true;
entry.Property(a => a.TYPE).IsModified = true;
entry.Property(a => a.CODE).IsModified = true;
entitys.SaveChanges();
return true;
}
catch (Exception)
{
return false;
throw;
}
}
}
/// <summary>
/// Gets the type of the activityes by.
/// </summary>
/// <param name="type">The type.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/14
/// 描述：按类型找活动
public static List<Model.Activity> GetActivityesByType(int type)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List<Model.Activity> list;
list = (from u in entitys.Activities select u).Where(a => a.TYPE == type).ToList();
return list;
}
}
/// <summary>
/// Updates the icbc cherry information.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="title">The title.</param>
/// <param name="color">The color.</param>
/// <param name="price">The price.</param>
/// <param name="memberprice">The memberprice.</param>
/// <param name="imgpath">The imgpath.</param>
/// <param name="smalltitle">The smalltitle.</param>
/// <param name="code">The code.</param>
/// <param name="des">The DES.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：更新商品信息
public static bool UpdateICBCCherryInfo(Guid id, string title, string color, string price, string memberprice, string imgpath, string smalltitle, string code, string des)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
BestCherryInfo bci = new BestCherryInfo();
bci.ID = id;
bci.TITLE = title;
bci.COLOR = color;
bci.PRICE = int.Parse(price);
bci.MEMBERPRICE = int.Parse(memberprice);
bci.IMAGEPATH = imgpath;
bci.SMALLTITLE = smalltitle;
bci.CODE = code;
//将实体对象加入EF对象容器中，并获取伪包装类对象
DbEntityEntry<BestCherryInfo> entry = entitys.Entry<BestCherryInfo>(bci);
//将包装类对象 的状态设置为 Unchanged
entry.State = System.Data.Entity.EntityState.Modified;
entry.Property(a => a.TITLE).IsModified = true;
entry.Property(a => a.CODE).IsModified = true;
entry.Property(a => a.COLOR).IsModified = true;
entry.Property(a => a.PRICE).IsModified = true;
entry.Property(a => a.MEMBERPRICE).IsModified = true;
entry.Property(a => a.IMAGEPATH).IsModified = true;
entry.Property(a => a.SMALLTITLE).IsModified = true;
entitys.SaveChanges();
return true;
}
catch (Exception)
{
return false;
throw;
}
}
}
/// <summary>
/// Gets the activity pro.
/// </summary>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/14
/// 描述：通过CODE获取活动的商品设置信息
public static List<Model.ActivityPro> GetActivityPro(string code, Guid activityid)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
var list = (from u in entitys.ActivityProes select u).Where(a => a.PROCODE == code).Where(a => a.ACTIVITYID == activityid).ToList();
return list;
}
}
public static bool UpdatePayOrder(bool inter, bool intersuccess, string orderid, string paydate, string usernum, string amount)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List<OrderInfo> orderInfoList = (from a in entitys.OrderInfoes select a).Where(a => a.ORDERID == orderid).ToList();
try
{
OrderInfo oi = orderInfoList[0];
oi.INTERFACE = inter;
oi.INTERSUCCES = intersuccess;
oi.PAYDATE = paydate;
oi.USERNUM = usernum;
oi.AMOUNT = int.Parse(amount);
//将实体对象加入EF对象容器中，并获取伪包装类对象
DbEntityEntry<OrderInfo> entry = entitys.Entry<OrderInfo>(oi);
//将包装类对象 的状态设置为 Unchanged
entry.State = System.Data.Entity.EntityState.Modified;
entry.Property(a => a.INTERFACE).IsModified = true;
entry.Property(a => a.INTERSUCCES).IsModified = true;
entry.Property(a => a.PAYDATE).IsModified = true;
entry.Property(a => a.USERNUM).IsModified = true;
entry.Property(a => a.AMOUNT).IsModified = true;
entitys.SaveChanges();
return true;
}
catch (DbEntityValidationException dbEx)
{
return false;
throw;
}
}
}
/// <summary>
/// Gets the activity pro.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/17
/// 描述：通过ID获取活动的商品设置信息
public static List<Model.ActivityPro> GetActivityPro(Guid id)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
var list = (from u in entitys.ActivityProes select u).Where(a => a.ID == id).ToList();
return list;
}
}
/// <summary>
/// Updates the poll.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="title">The title.</param>
/// <param name="color">The color.</param>
/// <param name="price">The price.</param>
/// <param name="memberprice">The memberprice.</param>
/// <param name="imgpath">The imgpath.</param>
/// <param name="smalltitle">The smalltitle.</param>
/// <param name="code">The code.</param>
/// <param name="des">The DES.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/14
/// 描述：更新投票数
public static bool UpdatePoll(Guid ID)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
try
{
List<Model.BestCherryInfo> list = WebBLL.GetCherry(ID);
if (list.Count != 0)
{
BestCherryInfo bci = list[0];
int poll = 0;
if (list[0].POLL != null)
{
poll = (int)list[0].POLL;
}
bci.POLL = poll + 1;
//将实体对象加入EF对象容器中，并获取伪包装类对象
DbEntityEntry<BestCherryInfo> entry = entitys.Entry<BestCherryInfo>(bci);
//将包装类对象 的状态设置为 Unchanged
entry.State = System.Data.Entity.EntityState.Modified;
entry.Property(a => a.POLL).IsModified = true;
entitys.SaveChanges();
return true;
}
else
{
return false;
}
}
catch (DbEntityValidationException dbEx)
{
return false;
throw;
}
}
}
/// <summary>
/// Gets all product.
/// </summary>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/10
/// 描述：获取所有商品
public static List<Model.BestCherryInfo> GetAllProduct()
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
var list = (from u in entitys.BestCherryInfoes select u).ToList();
return list;
}
}
/// <summary>
/// Gets the name of the activity by.
/// </summary>
/// <param name="name">The name.</param>
/// <param name="type">The type.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/11
/// 描述：根据名称和类型来查找活动
public static List<Model.Activity> GetActivityByName(string name, int type)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
List<Model.Activity> list;
list = (from u in entitys.Activities select u).Where(a => a.NAME.Contains(name)).Where(a => a.TYPE == type).ToList();
return list;
}
}
/// <summary>
/// Gets the cherry.
/// </summary>
/// <param name="code">The code.</param>
/// <returns></returns>
/// 创建人：李允智
/// 创建时间：2015/9/14
/// 描述：通过ID来获取商品信息
public static List<Model.BestCherryInfo> GetCherry(Guid ID)
{
using (Model.BestCherryEntities entitys = new Model.BestCherryEntities())
{
var list = (from u in entitys.BestCherryInfoes select u).Where(a => a.ID == ID).Take(1).ToList();
return list;
}
}
