public object PrintOrder(string orderId, int printonly)
{
string sqlOrder = "SELECT * FROM VM_Order WHERE OrderId = @orderId;";
string sqlDetail = "SELECT * FROM VM_DetailOrder WHERE OrderId = @orderId;";
var result = XDataHelper.ExcuteMultipleReader <VM_Order, VM_DetailOrder>(sqlOrder + sqlDetail, new { orderId });
var xres = new XResult();
var resPrint = PrintSanLiangDan(printonly, result);
if (resPrint.ret == 0)
{
xres.message = "已将订单发送至打印机！";
}
else if (resPrint.ret == 99)
{
xres.message = resPrint.msg;
xres.code = printonly != 0 ? resPrint.ret : 20000;
}
else
{
xres.code = 10000;
xres.message = $"打印机错误码为：{resPrint.ret}，错误信息为：{resPrint.msg}";
}
return(xres);
}
public object Save([FromBody] DetailOrder detailOrder)
{
string sql = "";
if (detailOrder.Weight == 0)
{
detailOrder.Weight = 1;
}
detailOrder.ShouldPrice = detailOrder.SinglePrice * detailOrder.Weight;
if (detailOrder.Id > 0)
{
sql = $@"UPDATE DetailOrder SET
MenuId=@MenuId,
SinglePrice=@SinglePrice,
Weight=@Weight,
ShouldPrice=@ShouldPrice
WHERE Id = @Id";
}
else
{
sql = $@"INSERT INTO DetailOrder(MenuId, SinglePrice, Weight, ShouldPrice, OrderId)
VALUES(@MenuId, @SinglePrice, @Weight, @ShouldPrice, @OrderId)";
}
var xresult = new XResult();
if (!XDataHelper.ExcuteNonQuery(sql, detailOrder))
{
xresult.code = 10000;
xresult.message = "操作失败！";
}
;
return(xresult);
}
public object Save([FromBody] Menu menu)
{
string sql = "";
if (menu.Id > 0)
{
sql = $@"UPDATE Menu SET
Name=@Name,
MenuTypeId=@MenuTypeId,
IsUsed=@IsUsed,
Price=@Price,
PriceType=@PriceType,
Description=@Description,
IsUsed=@IsUsed,
Sort=@Sort
WHERE Id = @Id";
}
else
{
sql = $@"INSERT INTO Menu(MenuTypeId, NAME, IsUsed,Price,PriceType,Description,CreateTime,Sort)
VALUES(@MenuTypeId, @Name, @IsUsed,@Price,@PriceType,@Description,DATE_ADD(NOW(), INTERVAL 12 HOUR),@Sort)";
}
var xresult = new XResult();
if (!XDataHelper.ExcuteNonQuery(sql, menu))
{
xresult.code = 10000;
xresult.message = "操作失败！";
}
;
return(xresult);
}
//Delete all Database in
//Add Alias in, as a general function.
public static void DeleteTableSchedule(Database db, string alias)
{
using (Transaction tr = db.TransactionManager.StartTransaction())
{
BlockTable bt = (BlockTable)tr.GetObject(db.BlockTableId, OpenMode.ForRead);
BlockTableRecord btr = (BlockTableRecord)tr.GetObject(bt[BlockTableRecord.ModelSpace], OpenMode.ForRead);
foreach (ObjectId id in btr)
{
DBObject dbObj = tr.GetObject(id, OpenMode.ForRead);
if (dbObj is Table)
{
Table tb = (Table)dbObj;
if (XDataHelper.GetTableType(tb, tr, db) == alias)
{
tb.UpgradeOpen();
if (!tb.IsErased)
{
tb.Erase();
}
}
}
}
tr.Commit();
}
}
public object Save([FromBody] Order order)
{
if (order.Id <= 0)
{
throw new Exception("哦豁，没有获取到这个订单的Id。");
}
string sql = "";
order.ActuallyPrice = order.ShouldPrice;
order.DiscountRate = 1;
sql = $@"UPDATE TotalOrder SET
PositionId=@PositionId,
IsBuyed=@IsBuyed
WHERE Id = @Id";
var xresult = new XResult();
if (!XDataHelper.ExcuteNonQuery(sql, order))
{
xresult.code = 10000;
xresult.message = "操作失败！";
}
;
return(xresult);
}
public object InitializeData()
{
string sql = @"SELECT * FROM VM_Menu WHERE IsUsed = 1 ORDER BY Sort;
SELECT * FROM MenuType ORDER BY Sort;";
var x = XDataHelper.ExcuteMultipleReader <Vm_MenuClass, MenuTypeClass>(sql);
var goodsList = new List <Goods>();
foreach (var item in x.Item2)
{
var good = new Goods();
good.name = item.Name;
foreach (var menu in x.Item1)
{
if (menu.MenuTypeName == item.Name)
{
var food = new Food();
food.id = menu.Id;
food.icon = menu.RootUrl + menu.ICon;
food.name = menu.Name;
food.price = menu.Price;
food.pricetype = menu.PriceType;
food.description = menu.Description;
good.foods.Add(food);
}
}
goodsList.Add(good);
}
return(new XResult()
{
data = goodsList
});
}
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 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 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 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 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 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 Delete(int id)
{
var result = new XResult();
var delete = "UPDATE BlogArticle SET DELETETIME=NOW(), IsDeleted=1 WHERE ID = @id";
if (XDataHelper.ExcuteNonQuery(delete, new { id }))
{
return(result);
}
result.Code = -1;
result.Message = "操作失败";
return(result);
}
public object Add([FromBody] BlogArticle model)
{
var result = new XResult();
var insert = $@"INSERT INTO BlogArticle (Title,Category,Tag,Content,ReadCount,CreateTime,ModifiedTime)VALUES ('{model.Title}','{model.Category}','{model.Tag}','{model.Content}',0,NOW(),NOW())";
if (XDataHelper.ExcuteNonQuery(insert))
{
return(result);
}
result.Code = -1;
result.Message = "操作失败";
return(result);
}
public object Update(int id)
{
var result = new XResult();
var update = $@"UPDATE BlogArticle SET ReadCount = (ReadCount+1) WHERE ID = @id";
if (XDataHelper.ExcuteNonQuery(update, new { id }))
{
return(result);
}
result.Code = -1;
result.Message = "操作失败";
return(result);
}
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 Del(string tableName, int id)
{
string sql = $"DELETE FROM {tableName.DelSpace()} WHERE Id = @id";
var xresult = new XResult();
xresult.message = "删除成功";
if (!XDataHelper.ExcuteNonQuery(sql, new { id }))
{
xresult.code = 10000;
xresult.message = "操作失败！";
}
;
return(xresult);
}
public object Save([FromBody] Setting setting)
{
string sql = "";
sql = $"UPDATE TytfSetting SET Value=@Value WHERE Id = @Id";
var xresult = new XResult();
if (!XDataHelper.ExcuteNonQuery(sql, setting))
{
xresult.code = 10000;
xresult.message = "操作失败！";
}
;
return(xresult);
}
public object DeleteOrder(string orderId)
{
string sql = @"DELETE FROM TotalOrder WHERE OrderId=@orderId;
DELETE FROM DetailOrder WHERE OrderId=@orderId;";
var xresult = new XResult();
if (!XDataHelper.ExcuteNonQuery(sql, new { orderId }))
{
xresult.code = 10000;
xresult.message = "操作失败！";
}
;
return(xresult);
}
public object Add([FromBody] BlogArticle model)
{
var result = new XResult();
var insert = $@"INSERT INTO BlogArticle (Title,Image,Category,Tag,Content,ReadCount,CreateTime,ModifiedTime)VALUES (@Title,@Image,@Category,@Tag,@Content,0,Now(),Now())";
var whereObj = new { Category = model.Category, Image = model.Image, Tag = model.Tag, Title = model.Title, Content = model.Content };
if (XDataHelper.ExcuteNonQuery(insert, whereObj))
{
return(result);
}
result.Code = -1;
result.Message = "操作失败";
return(result);
}
public object NoBuy(string orderId)
{
string sql = $@"UPDATE TotalOrder SET
IsBuyed=0
WHERE OrderId = @OrderId";
var xresult = new XResult();
if (!XDataHelper.ExcuteNonQuery(sql, new { orderId }))
{
xresult.code = 10000;
xresult.message = "操作失败！";
}
;
return(xresult);
}
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 Update(int id, [FromBody] BlogArticle model)
{
var result = new XResult();
var update = $@"UPDATE BlogArticle SET
Title = @Title,
Category = {model.Category},
Tag = @Tag,
Content = @Content,
ModifiedTime = '{DateTime.Now}'
WHERE ID = @id";
var whereObj = new { id, Tag = model.Tag, Title = model.Title, Content = model.Content };
if (XDataHelper.ExcuteNonQuery(update, whereObj))
{
return(result);
}
result.Code = -1;
result.Message = "操作失败";
return(result);
}
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);
}
public object Save(string tableName, [FromBody] MenuType type)
{
string sql = "";
if (type.Id > 0)
{
sql = $"UPDATE {tableName.DelSpace()} SET Name=@Name,Sort=@Sort WHERE Id = @Id";
}
else
{
sql = $"INSERT INTO {tableName.DelSpace()}(Sort, NAME) VALUES(@Sort, @Name)";
}
var xresult = new XResult();
if (!XDataHelper.ExcuteNonQuery(sql, type))
{
xresult.code = 10000;
xresult.message = "操作失败！";
}
;
return(xresult);
}
