public object GetList(string tableName)
{
string sql = $"SELECT * FROM {tableName.DelSpace()} ORDER BY Sort";
var dt = XDataHelper.ExcuteReader <object>(sql);
return(new XResult()
{
data = dt
});
}
public object Get(int id)
{
var result = new XResult();
var select = $"SELECT * FROM BlogArticle WHERE ID = @id";
var one = XDataHelper.ExcuteReader <BlogArticle>(select, new { id }).SingleOrDefault();
result.Data = one;
return(result);
}
public object GetMainImage()
{
var sql = "SELECT src AS main1,msrc AS main2,CONCAT('http://img.xuxuzhaozhao.top',alt) AS logo FROM TYTFMenus WHERE id = 11";
var main = XDataHelper.ExcuteReader <object>(sql).SingleOrDefault();
return(new XResult()
{
Data = main
});
}
public object GetTablePosition()
{
string sql = "SELECT * FROM TablePosition ORDER BY Sort";
var result = XDataHelper.ExcuteReader <object>(sql);
return(new XResult()
{
data = result
});
}
public object Get()
{
var optionSql = $"SELECT id AS value,NAME AS label FROM BlogCategory ORDER BY SerialNumber";
var result = XDataHelper.ExcuteReader <Options>(optionSql).ToList();
return(new XResult()
{
Data = result
});
}
public Waiter GetWaiter(string waiterName)
{
string sql = "SELECT * FROM Waiter WHERE (WeiXinId=@waiterName OR Name=@waiterName ) AND IsUsed = 1";
var result = XDataHelper.ExcuteReader <Waiter>(sql, new { waiterName });
if (result.Count() == 0)
{
throw new Exception("非法账号！");
}
return(result.First());
}
public object GetMenuList(bool isMenu)
{
var sql = isMenu ? "SELECT Id,src,CONCAT(src,msrc) AS msrc,alt,title,w,h FROM TYTFMenus WHERE Id < 11" :
"SELECT Id,src,CONCAT(src,msrc) AS msrc,alt,title,w,h FROM TYTFMenus WHERE Id > 11";
var list = XDataHelper.ExcuteReader <object>(sql).ToList();
return(new XResult()
{
Data = list
});
}
public object GetDetail(string orderId)
{
//北京与洛杉矶的时差有这么多，SELECT DATE_ADD(NOW(), INTERVAL 12 HOUR);
var BeijinTime = XCommons.GetChineseDateTime();
string sql = "SELECT * FROM VM_DetailOrder WHERE OrderId = @orderId";
var result = XDataHelper.ExcuteReader <object>(sql, new { orderId });
return(new XResult()
{
data = result,
message = BeijinTime.ToString("yyyy年MM月dd日 HH:mm:ss")
});
}
public object GetList()
{
string sql = $@"SELECT COUNT(1) AS 订单数量,
SUM(ShouldPrice) AS 当日总销售价,
DATE_FORMAT(CreateTime,'%Y-%m-%d') AS 日期
FROM VM_Order WHERE IsBuyed = 1
GROUP BY DATE_FORMAT(CreateTime,'%Y-%m-%d')";
var result = XDataHelper.ExcuteReader <object>(sql);
return(new XResult()
{
data = result
});
}
public object GetSelectList(string tableName)
{
string extField = "";
if (tableName.ToUpper() == "MENU")
{
extField = ",Price";
}
string sql = $"SELECT Id,Name{extField} FROM {tableName.DelSpace()} ORDER BY Sort";
var result = XDataHelper.ExcuteReader <Select>(sql);
return(new XResult()
{
data = result
});
}
public object GetList([FromBody] QueryMenuPagination page)
{
var selectSql = $@"select * from VM_Menu {page.GetWhereSql()}
ORDER BY MenuTypeId,Sort
LIMIT {(page.Page - 1) * page.RowsPerPage},{page.RowsPerPage}";
var countSql = $"SELECT COUNT(1) AS count FROM VM_Menu {page.GetWhereSql()}";
var list = XDataHelper.ExcuteReader <object>(selectSql).ToList();
var count = XDataHelper.ExcuteScalar <int>(countSql);
var result = new XResult();
result.data = new
{
content = list,
count = count
};
return(result);
}
public object GetList([FromBody] XPagination page)
{
var whereSql = $"WHERE {(page.IsBackAdmin ? "" : "IsPublished = 1 AND")} IsDeleted=0 AND {page.WhereTags} AND {page.WhereCategory} AND {page.WhereTitle}";
var selectSql = $@"select * from VM_BlogArticle {whereSql}
ORDER BY Id DESC
LIMIT {(page.Page - 1) * page.RowsPerPage},{page.RowsPerPage}";
var countSql = $"SELECT COUNT(1) AS count FROM BlogArticle {whereSql}";
var list = XDataHelper.ExcuteReader <BlogArticle>(selectSql).ToList();
var count = XDataHelper.ExcuteScalar <int>(countSql);
var result = new XResult();
result.Data = new
{
Content = list,
Count = count
};
return(result);
}
public object CreateOrder([FromBody] OrderTemp order)
{
var waiter = GetWaiter(order.WaiterName);
string orderId = "";
int resultCount = 1;
while (resultCount > 0)
{
orderId = GenerateOrderId();
string sqlExists = "SELECT OrderId FROM TotalOrder WHERE OrderId = @orderId";
var result = XDataHelper.ExcuteReader <object>(sqlExists, new { orderId }).ToList();
resultCount = result.Count;
}
order.OrderId = orderId;
string sql = $@"INSERT INTO TotalOrder(OrderId,PositionId,ClientName,WaiterId,CreateTime,IsBuyed,Note)
VALUES(@OrderId,@PositionId,@ClientName,{waiter.Id},DATE_ADD(NOW(), INTERVAL 12 HOUR),0,@Note);";
foreach (var item in order.detailTemps)
{
sql += $@"INSERT INTO DetailOrder(OrderId,MenuId,SinglePrice,Weight,ShouldPrice)
VALUES(@OrderId,{item.MenuId},'{item.SinglePrice}',{item.Weight},'{item.ShouldPrice}');";
}
var xresult = new XResult();
xresult.data = orderId;
if (!XDataHelper.ExcuteNonQuery(sql, order))
{
xresult.code = 10000;
xresult.message = "操作失败！";
}
;
return(xresult);
}
public object GetList([FromBody] XPagination page)
{
var whereSql = $"WHERE IsDeleted=0 AND {page.WhereTags} AND {page.WhereCategory}";
var selectSql = $@"SELECT * FROM BlogArticle {whereSql}
ORDER BY Id DESC
LIMIT {page.Index * page.Size},{page.Size}";
var countSql = $"SELECT COUNT(1) AS count FROM BlogArticle {whereSql}";
var list = XDataHelper.ExcuteReader <BlogArticle>(selectSql).ToList();
var count = XDataHelper.ExcuteScalar <int>(countSql);
var result = new XResult();
//C#匿名对象
result.Data = new
{
Content = list,
Count = count
};
return(result);
}
