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); }