public ActionResult SearchMemberInfo(string text)
{
Response res = new Response();
res.Successed = false;
try
{
var currentUser = OperatorProvider.Provider.GetCurrent();
var verifyInfo = new VerifySourceInfoDTO();
verifyInfo.RestaruantId = currentUser.DepartmentId.ToInt();
var resultInfo = _checkOutService.VerifyOutsideInfo(verifyInfo);
if (resultInfo != null && resultInfo.Count > 0)
{
res.Successed = true;
}
else
{
res.Message = "网络故障，请稍后重新操作！";
}
res.Data = resultInfo;
return(Json(res));
}
catch (Exception ex)
{
res.Message = ex.Message;
}
return(Json(res));
}
public ActionResult VerifyByOutsideInfo(int id, string name, decimal money, CyddPayType payType)
{
Response res = new Response();
res.Successed = false;
try
{
var currentUser = OperatorProvider.Provider.GetCurrent();
var verifyInfo = new VerifySourceInfoDTO();
verifyInfo.SourceId = id;
verifyInfo.SourceName = name;
verifyInfo.RestaruantId = currentUser.DepartmentId.ToInt();
verifyInfo.PayMethod = (int)payType;
verifyInfo.OperateValue = money;
var resultInfo = _checkOutService.VerifyOutsideInfo(verifyInfo);
if (resultInfo != null && resultInfo.Count > 0)
{
res.Successed = true;
}
else
{
res.Message = "网络故障，请稍后重新操作！";
}
res.Data = resultInfo;
return(Json(res));
}
catch (Exception ex)
{
res.Message = ex.Message;
}
return(Json(res));
}
public List <string> SearchVerifyOutsideInfo(VerifySourceInfoDTO verifySource, SqlSugarClient db)
{
bool isOutside = false;
if (db == null)
{
db = new SqlSugarClient(Connection);
isOutside = true;
}
List <string> infoList = new List <string>();
if (verifySource.PayMethod == (int)CyddPayType.挂账)
{
if (verifySource.SourceId <= 0)
{
throw new Exception("请选择有效的挂账客户！");
}
string lxdmSql = string.Format("SELECT lxdmdm00 AS Code, lxdmgzxe AS LimitAmount, lxdmye00 AS RemainAmount FROM dbo.lxdm WHERE Id = {0}", verifySource.SourceId);
var info = db.SqlQuery <SearchLxdmInfo>(lxdmSql);
if (info == null || info.Count == 0)
{
throw new Exception(string.Format("无法找到此客户（{0}）,请重新确认挂账客户！", verifySource.SourceName));
}
infoList.Add(info[0].Code.Trim());
}
else if (verifySource.PayMethod == (int)CyddPayType.转客房)
{
#region 转客房验证
if (string.IsNullOrEmpty(verifySource.SourceName))
{
throw new Exception("请输入房号！");
}
string sqlRoom = string.Format("SELECT TOP 1 krzlfh00 " +
"FROM krzl WHERE krzlzt00 = 'I' AND (krzlzh00 = '{0}' or (krzlkrlx='G' and krzlth00='{0}'))", verifySource.SourceId);
var rooms = db.SqlQuery <string>(sqlRoom);
if (rooms == null || rooms.Count == 0)
{
throw new Exception(string.Format("无此在住房号（{0}）,请重新确认转客房房号！", verifySource.SourceName));
}
//取在住主结人
string customerSql = string.Format("SELECT TOP 1 krzlzh00 AS CustomerId, ISNULL(krzlgzxe, 0) AS LastAmount, isnull(krzlye00, 0) as LimitAmount, " +
"(select sum(ysq0je00) from ysq0 where ysq0zh00=k.krzlzh00) as PreAmount FROM krzl k " +
"WHERE krzlzt00 = 'I' AND (krzlzh00 = '{0}' or (krzlkrlx='G' and krzlth00='{0}')) AND krzlzh00 = krzltzxh", verifySource.SourceId);
var customers = db.SqlQuery <SearchKrzlInfo>(customerSql);
if (customers == null || customers.Count == 0)
{
throw new Exception(string.Format("此房号（{0}）无在住客人！", verifySource.SourceName));
}
if (customers[0].LastAmount != 0)
{
if (customers[0].LastAmount < verifySource.OperateValue)
{
throw new Exception(string.Format("此客户（{0}）可挂账限额（{1}）小于当前输入金额无法挂账, 请重新确认！", verifySource.SourceName, customers[0].LastAmount));
}
}
//if (customers[0].LimitAmount != 0)
//{
// if (customers[0].LimitAmount + verifySource.OperateValue>0)
// throw new Exception(string.Format("此客户（{0}）可挂账余额（{1}）小于当前输入金额无法挂账, 请重新确认！", verifySource.SourceName, customers[0].LimitAmount));
//}
var codes = db.SqlQuery <string>("select top 1 cyctzwdm from cyct where id=" + verifySource.RestaruantId);
if (codes == null || codes.Count == 0)
{
throw new Exception("当前餐厅未设置账务代码！");
}
var hasCode = db.SqlQuery <string>("select top 1 zwdmdm00 from zwdm where zwdmdm00='" + codes[0] + "'");
if (hasCode == null || hasCode.Count == 0)
{
throw new Exception("当前餐厅账务代码设置不正确，请重新确认！");
}
infoList.Add(codes[0]);
infoList.Add(customers[0].CustomerId.ToString());
#endregion
}
else if (verifySource.PayMethod == (int)CyddPayType.会员卡)
{
var member = VerifyMemberInfo(verifySource.SourceId, verifySource.OperateValue, verifySource.SourceName);
if (member != null && member.Id > 0)
{
infoList.Add(member.Id.ToString());
}
}
if (isOutside)
{
db.Dispose();
}
return(infoList);
}
public CheckOutResultDTO ReverseOrder(ReverseOrderDTO req)
{
using (var db = new SqlSugarClient(Connection))
{
CheckOutResultDTO res = null;
try
{
var dateItem = _extendItemRepository.GetModelList(req.CompanyId, 10003).FirstOrDefault();
if (dateItem == null)
{
throw new Exception("餐饮账务日期尚未初始化，请联系管理员");
}
DateTime accDate = DateTime.Today;
if (!DateTime.TryParse(dateItem.ItemValue, out accDate))
{
throw new Exception("餐饮账务日期设置错误，请联系管理员");
}
var tables = db.Queryable <R_Table>().JoinTable <R_OrderTable>
((s1, s2) => s1.Id == s2.R_Table_Id).Where <R_OrderTable>((s1, s2) =>
s2.R_OrderMainPay_Id == req.MainPayId).Select("s1.*").ToList();
var tableIds = tables.Select(p => p.Id).ToArray();
var tableOrderIngs = tables.Where(p => p.CythStatus == CythStatus.在用).ToList();
if (tableOrderIngs.Any())
{
var tableNames = string.Join(",", tableOrderIngs.Select(p => p.Name));
throw new Exception(string.Format("({0}) 正在开台状态,请结账后再执行该账单的反结操作", tableNames));
}
var reverTableNames = string.Join(",", tables.Select(p => p.Name));
var mainPayModel = db.Queryable <R_OrderMainPay>().First(p => p.Id == req.MainPayId);
if (mainPayModel.BillDate.Date != accDate.Date)
{
throw new Exception("该账单账务日期和系统当前账务日期不一致,不允许反结");
}
var orderModel = db.Queryable <R_Order>().First(p => p.Id == mainPayModel.R_Order_Id);
var orderTables = db.Queryable <R_OrderTable>()
.Where(p => p.R_OrderMainPay_Id == mainPayModel.Id).ToList();
var orderTableIds = orderTables.Select(p => p.Id).ToArray();
var orderDetails = db.Queryable <R_OrderDetail>()
.Where(p => orderTableIds.Contains(p.R_OrderTable_Id)).ToList();
var orderPayRecords = db.Queryable <R_OrderPayRecord>()
.Where(p => p.R_OrderMainPay_Id == mainPayModel.Id).ToList();
if (orderPayRecords.Any(p => p.CyddJzStatus == CyddJzStatus.已结 && p.CyddJzType != CyddJzType.定金))
{
throw new Exception(string.Format("该主结单已经做过反结操作，不能重复反结"));
}
db.BeginTran();
//db.Delete<R_OrderPayRecord>(p => p.R_OrderMainPay_Id == mainPayModel.Id);
//db.Delete<R_OrderMainPay>(p => p.Id == mainPayModel.Id);
//db.Update<R_OrderPayRecord>(new { CyddJzStatus = (int)CyddJzStatus.已付 }, p => p.R_Order_Id == orderModel.Id);
//db.Delete<R_OrderPayRecord>(p=>p.R_Order_Id == orderModel.Id && p.PayAmount<=0 && p.CyddJzType==CyddJzType.定金);
var depositReverAll = db.Queryable <R_OrderPayRecord>().Where(p => p.R_Order_Id == orderModel.Id && p.R_OrderMainPay_Id == 0 &&
p.CyddJzType == CyddJzType.定金).ToList();
var depositRePids = depositReverAll.Where(p => p.CyddJzStatus == CyddJzStatus.已退).Select(p => p.PId).ToList();
var depositReverIds = depositReverAll.Where(p => !depositRePids.Contains(p.Id) && p.CyddJzStatus == CyddJzStatus.已结)
.Select(p => p.Id).ToList();
db.Update <R_OrderPayRecord>(new { CyddJzStatus = (int)CyddJzStatus.已付 }, p => depositReverIds.Contains(p.Id));
db.Update <R_OrderPayRecord>(new { CyddJzStatus = (int)CyddJzStatus.已结 }, p => p.R_OrderMainPay_Id == mainPayModel.Id);
db.Delete <R_OrderPayRecord>(p => p.R_Order_Id == orderModel.Id && p.CyddJzType == CyddJzType.定金 &&
p.CyddJzStatus == CyddJzStatus.已结 && p.R_OrderMainPay_Id > 0);
db.Update <R_OrderDetail>(new { PayableTotalPrice = 0, DiscountRate = 1 }, p => orderTableIds.Contains(p.R_OrderTable_Id));
db.Update <R_OrderTable>(new { IsCheckOut = 0, IsOpen = 1, R_OrderMainPay_Id = 0 }, p => orderTableIds.Contains(p.Id));
db.Update <R_Order>(new { RealAmount = 0, CyddStatus = (int)CyddStatus.反结, OriginalAmount = 0, ConAmount = 0, DiscountRate = 0, DiscountAmount = 0, GiveAmount = 0, ClearAmount = 0 }, p => p.Id == orderModel.Id);
db.Update <R_Table>(new { CythStatus = (int)CythStatus.在用 }, p => tableIds.Contains(p.Id));
db.Insert <R_OrderRecord>(new R_OrderRecord()
{
CreateDate = DateTime.Now,
CreateUser = req.UserId,
CyddCzjlStatus = CyddStatus.反结,
CyddCzjlUserType = CyddCzjlUserType.员工,
Remark = string.Format("执行了反结操作,台号:({0})", reverTableNames),
R_OrderTable_Id = 0,
R_Order_Id = orderModel.Id
});
List <R_OrderPayRecord> reverseRecords = new List <R_OrderPayRecord>();
#region 反写应收账
foreach (var item in orderPayRecords)
{
if (item.CyddPayType == (int)CyddPayType.挂账 || item.CyddPayType == (int)CyddPayType.转客房 ||
item.CyddPayType == (int)CyddPayType.会员卡)
{
if (item.CyddPayType == (int)CyddPayType.会员卡)
{
if (EnabelGroupFlag)
{
try
{
var dto = AutoMapper.Mapper.Map <OrderPayRecordDTO>(item);
dto.Remark = string.Format("{0} {1}", "反结会员卡", item.Remark);
List <OrderPayRecordDTO> dtoList = new List <OrderPayRecordDTO>
{
dto
};
SaveMemberConsumeInfo(dtoList, req.UserCode, false, orderModel.R_Restaurant_Id);
//ApplyChangeMemberToDb(item.SourceId, item.SourceName, req.UserCode,
// -item.PayAmount, string.Format("{0} {1}", "反结会员卡", item.Remark), false, new SqlSugarClient(ConnentionGroup));
}
catch (Exception ex)
{
throw new Exception("反结集团库记录会员卡消费信息操作失败：" + ex.Message);
}
}
else
{
try
{
ApplyChangeMemberToDb(item.SourceId, item.SourceName, req.UserCode,
-item.PayAmount, string.Format("{0} {1}", "反结会员卡", item.Remark), false, db, orderModel.R_Restaurant_Id);
}
catch (Exception ex)
{
throw new Exception("反结本地库记录会员卡消费信息操作失败：" + ex.Message);
}
}
//if (!EnabelGroupFlag)
//{
// //若已启用集团会员库，里面则不再执行，本地库会员消费记录已在插入集团库时一并插入到本地库
//}
}
else if (item.CyddPayType == (int)CyddPayType.挂账)
{
var verifyInfo = new VerifySourceInfoDTO();
verifyInfo.SourceId = item.SourceId;
verifyInfo.SourceName = item.SourceName;
verifyInfo.RestaruantId = orderModel.R_Restaurant_Id;
verifyInfo.PayMethod = (int)CyddPayType.挂账;
verifyInfo.OperateValue = item.PayAmount;
string remark = string.Format("反结挂账客户【{0}】- 代码：({1})", item.SourceName, item.SourceId);
List <string> resultList = SearchVerifyOutsideInfo(verifyInfo, db);
try
{
var paras = SqlSugarTool.GetParameters(new
{
xh = orderModel.Id, //餐饮单序号
dh = orderModel.R_Restaurant_Id + "." + orderModel.Id, //餐厅代码+'.'+餐饮单单号
lx = resultList[0].Trim(), //协议单位代码(lxdmdm00)
je = -item.PayAmount, //金额
cz = req.UserCode, //操作员代码
ctmc = orderModel.R_Restaurant_Id, //餐厅名称
fsmc = "", //分市名称
th = orderModel.Id,
rs = orderModel.PersonNum,
bz = remark,
mz = "",
atr = 0
});
db.CommandType = System.Data.CommandType.StoredProcedure; //指定为存储过程可比上面少写EXEC和参数
db.ExecuteCommand("p_po_toys_newCY", paras);
db.CommandType = System.Data.CommandType.Text; //还原回默认
}
catch (Exception ex)
{
throw new Exception("反结挂账操作失败：" + ex.Message);
}
}
else if (item.CyddPayType == (int)CyddPayType.转客房)
{
#region 转客房处理
var verifyInfo = new VerifySourceInfoDTO();
verifyInfo.SourceId = item.SourceId;
verifyInfo.SourceName = item.SourceName;
verifyInfo.RestaruantId = orderModel.R_Restaurant_Id;
verifyInfo.PayMethod = (int)CyddPayType.转客房;
verifyInfo.OperateValue = item.PayAmount;
List <string> resultList = SearchVerifyOutsideInfo(verifyInfo, db);
try
{
var paras = SqlSugarTool.GetParameters(new
{
zh00 = Convert.ToInt32(resultList[1]), //客人账号(krzlzh00)
zwdm = resultList[0], //账项代码
hsje = -item.PayAmount, //金额
ckhm = item.SourceName, //房号(krzlfh00)
czdm = req.UserCode, //操作员代码
xfje = 1,
bz00 = "反结餐厅转客房",
bc00 = "",
});
db.CommandType = System.Data.CommandType.StoredProcedure; //指定为存储过程可比上面少写EXEC和参数
db.ExecuteCommand("p_zw_addx", paras);
db.CommandType = System.Data.CommandType.Text; //还原回默认
}
catch (Exception ex)
{
throw new Exception("反结转客房操作失败：" + ex.Message);
}
#endregion
}
}
if (item.PayAmount != 0 && (item.CyddJzStatus != CyddJzStatus.已退 || item.CyddJzStatus != CyddJzStatus.已结) && item.CyddJzType != CyddJzType.定金)
{
item.PayAmount = -item.PayAmount;
item.CreateDate = DateTime.Now;
item.BillDate = accDate;
item.R_Market_Id = req.CurrentMarketId;
item.CreateUser = req.UserId;
item.CyddJzStatus = CyddJzStatus.已结;
if (item.CyddJzType == CyddJzType.找零)
{
item.Remark = string.Format("反结找零纪录 {0}", item.SourceName);
}
else
{
item.Remark = string.Format("反结付款纪录 {0}", item.SourceName);
}
reverseRecords.Add(item);
}
//if (item.CyddJzType==CyddJzType.转结 && item.CyddJzStatus==CyddJzStatus.已结)
//{
// reverseRecords.Add(new R_OrderPayRecord()
// {
// PayAmount = -item.PayAmount,
// CreateDate = DateTime.Now,
// BillDate = accDate,
// R_Market_Id = req.CurrentMarketId,
// CreateUser = req.UserId,
// CyddJzStatus = CyddJzStatus.已付,
// CyddJzType = CyddJzType.定金,
// CyddPayType=item.CyddPayType,
// SourceId=0,
// R_OrderMainPay_Id= mainPayModel.Id,
// Remark = string.Format("反结重置定金纪录")
// });
//}
}
db.InsertRange <R_OrderPayRecord>(reverseRecords);
#endregion
db.CommitTran();
res = new CheckOutResultDTO()
{
OrderId = orderModel.Id,
OrderMainPayId = mainPayModel.Id,
OrderTables = orderTableIds.ToList(),
ReverTableNames = reverTableNames
};
}
catch (Exception ex)
{
db.RollbackTran();
throw ex;
}
return(res);
}
}
