//查询物流号
public information delt(string orderNum)
{
string sql = "select * from [information] where [ordID]='{0}'";
DAO.information orders = db.Database.SqlQuery <DAO.information>(string.Format(sql, orderNum)).FirstOrDefault();
return(orders);
}
/// <summary>
/// 添加一条记录
/// </summary>
/// <param name="model">物流信息</param>
/// <returns></returns>
public DAO.information Add(DAO.information model)
{
DAO.information m = db.information.Add(model);
int i = db.SaveChanges();
if (i > 0)
{
return(m);
}
else
{
return(null);
}
}
/// <summary>
/// 添加一条记录
/// </summary>
/// <param name="model">添加物流信息</param>
/// <returns></returns>
public DAO.information AddOrderNum(DAO.information model)
{
string sql = "UPDATE [Order] SET [wuliuhao]='{0}' where [orderID]='{1}'";
int date = db.Database.ExecuteSqlCommand(string.Format(sql, model.wuliuhao, model.ordID));
DAO.information m = db.information.Add(model);
int i = db.SaveChanges();
if (i > 0 && date > 0)
{
return(m);
}
else
{
return(null);
}
}
