375 lines
25 KiB
C#
375 lines
25 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using SuperMap.RealEstate.ServiceModel;
|
|
using Business = SuperMap.RealEstate.ReportDataAnalysis.Business;
|
|
using GSYWApi.Helper;
|
|
|
|
namespace GSYWApi.GeneralMethod
|
|
{
|
|
/// <summary>
|
|
/// 结账表相关方法
|
|
/// </summary>
|
|
public class ENDACCOUNTHelper
|
|
{
|
|
#region 获取结账表列表
|
|
/// <summary>
|
|
/// 获取结账表列表
|
|
/// </summary>
|
|
/// <param name="transaction">事务管理器</param>
|
|
/// <param name="TotalCount">查询结果总数</param>
|
|
/// <param name="searchModel">查询条件对象</param>
|
|
public static List<Model.ENDACCOUNTModel> GetENDACCOUNTList(Transaction transaction,
|
|
ref int TotalCount, Models.SearchModel<Model.ENDACCOUNTModel> searchModel)
|
|
{
|
|
List<Model.ENDACCOUNTModel> ENDACCOUNTList = new List<Model.ENDACCOUNTModel>();
|
|
|
|
string WhereSQL = "", RowFilterSQL = "";
|
|
if (searchModel.SearchParameter != null)
|
|
{
|
|
WhereSQL = OperationDataHelper<Model.ENDACCOUNTModel>.GetWhereSQL(searchModel.SearchParameter,
|
|
searchModel.QueryType, "", "ENDACCOUNT_DATE", "STATISTICS_DATE", "ENDACCOUNT_STARTDATE");
|
|
if (WhereSQL != "")
|
|
{
|
|
WhereSQL = "WHERE " + WhereSQL;
|
|
}
|
|
//查询开始时间
|
|
if (searchModel.SearchParameter.ENDACCOUNT_STARTDATE != null)
|
|
{
|
|
WhereSQL += (WhereSQL == "" ? "WHERE " : " AND ") + "ENDACCOUNT_DATE >= TO_DATE('" +
|
|
searchModel.SearchParameter.ENDACCOUNT_STARTDATE.ToString().Split(' ')[0] + "','YYYY/MM/DD')";
|
|
}
|
|
//查询结束时间
|
|
if (searchModel.SearchParameter.ENDACCOUNT_DATE != null)
|
|
{
|
|
WhereSQL += (WhereSQL == "" ? "WHERE " : " AND ") + "ENDACCOUNT_DATE < TO_DATE('" +
|
|
searchModel.SearchParameter.ENDACCOUNT_DATE.ToString().Split(' ')[0] + "','YYYY/MM/DD') + 1";
|
|
}
|
|
}
|
|
|
|
DataTable dtENDACCOUNT = new Business.ENDACCOUNT(transaction).FillDataTable(WhereSQL);
|
|
//增加组合查询条件
|
|
if (searchModel.keyWord != null && !string.IsNullOrWhiteSpace(searchModel.keyWord.Key))
|
|
{
|
|
foreach (string KeyName in searchModel.keyWord.Key.Split(','))
|
|
{
|
|
RowFilterSQL += (RowFilterSQL == "" ? "" : " or ") +
|
|
KeyName + " like '%" + searchModel.keyWord.Value + "%'";
|
|
}
|
|
}
|
|
if (RowFilterSQL != "")
|
|
{
|
|
dtENDACCOUNT.DefaultView.RowFilter = RowFilterSQL;
|
|
}
|
|
//排序：
|
|
dtENDACCOUNT.DefaultView.Sort = searchModel.SortStr;
|
|
dtENDACCOUNT = dtENDACCOUNT.DefaultView.ToTable();
|
|
//获取查询结果总记录条数
|
|
TotalCount = dtENDACCOUNT.Rows.Count;
|
|
if (searchModel.PageSize > 0)
|
|
{
|
|
//根据传入的页码和每页显示条数返回结果
|
|
dtENDACCOUNT = CommonHelper.GetDataTableWithPageSize(dtENDACCOUNT, searchModel.PageSize, searchModel.PageIndex);
|
|
}
|
|
else
|
|
{
|
|
searchModel.PageSize = TotalCount;
|
|
if (searchModel.PageIndex == 0)
|
|
{
|
|
searchModel.PageIndex = 1;
|
|
}
|
|
}
|
|
|
|
foreach (DataRow drENDACCOUNT in dtENDACCOUNT.Rows)
|
|
{
|
|
Model.ENDACCOUNTModel endaccountModel = new Model.ENDACCOUNTModel();
|
|
|
|
endaccountModel.ENDACCOUNT_ID = drENDACCOUNT["ENDACCOUNT_ID"].TryParseToInt(); //内码
|
|
endaccountModel.SERVERPART_ID = drENDACCOUNT["SERVERPART_ID"].TryParseToInt(); //服务区内码
|
|
endaccountModel.SERVERPARTCODE = drENDACCOUNT["SERVERPARTCODE"].ToString(); //服务区号
|
|
endaccountModel.SERVERPART_NAME = drENDACCOUNT["SERVERPART_NAME"].ToString(); //服务区名称
|
|
endaccountModel.PROVINCE_CODE = drENDACCOUNT["PROVINCE_CODE"].TryParseToInt(); //省份编码
|
|
endaccountModel.ENDACCOUNT_DATE = drENDACCOUNT["ENDACCOUNT_DATE"].TryParseToDateTime(); //结账时间
|
|
endaccountModel.STATISTICS_DATE = drENDACCOUNT["STATISTICS_DATE"].TryParseToDateTime(); //结算日期
|
|
endaccountModel.ENDACCOUNT_STARTDATE = drENDACCOUNT["ENDACCOUNT_STARTDATE"].TryParseToDateTime(); //销售起始时间
|
|
endaccountModel.SHOPCODE = drENDACCOUNT["SHOPCODE"].ToString(); //店号
|
|
endaccountModel.SHOPNAME = drENDACCOUNT["SHOPNAME"].ToString(); //店名称
|
|
endaccountModel.MACHINECODE = drENDACCOUNT["MACHINECODE"].ToString(); //机号
|
|
endaccountModel.ENDPERSONCODE = drENDACCOUNT["ENDPERSONCODE"].ToString(); //结账人编号
|
|
endaccountModel.WORKER_NAME = drENDACCOUNT["WORKER_NAME"].ToString(); //结账人名称
|
|
endaccountModel.CASHIER_NAME = drENDACCOUNT["CASHIER_NAME"].ToString(); //收银员名称
|
|
endaccountModel.TICKETCOUNT = drENDACCOUNT["TICKETCOUNT"].TryParseToDouble(); //单据数
|
|
endaccountModel.TOTALCOUNT = drENDACCOUNT["TOTALCOUNT"].TryParseToDouble(); //总数量
|
|
endaccountModel.TOTALSELLAMOUNT = drENDACCOUNT["TOTALSELLAMOUNT"].TryParseToDouble(); //总销售额
|
|
endaccountModel.TOTALOFFAMOUNT = drENDACCOUNT["TOTALOFFAMOUNT"].TryParseToDouble(); //总优惠
|
|
endaccountModel.CASH = drENDACCOUNT["CASH"].TryParseToDouble(); //现金
|
|
endaccountModel.CREDITCARD = drENDACCOUNT["CREDITCARD"].TryParseToDouble(); //信用卡
|
|
endaccountModel.TICKETBILL = drENDACCOUNT["TICKETBILL"].TryParseToDouble(); //支票(微信)
|
|
endaccountModel.VIPPERSON = drENDACCOUNT["VIPPERSON"].TryParseToDouble(); //会员卡
|
|
endaccountModel.COSTBILL = drENDACCOUNT["COSTBILL"].TryParseToDouble(); //消费券
|
|
endaccountModel.OTHERPAY = drENDACCOUNT["OTHERPAY"].TryParseToDouble(); //其他支付(支付宝)
|
|
endaccountModel.CASHPAY = drENDACCOUNT["CASHPAY"].TryParseToDouble(); //缴款金额
|
|
endaccountModel.CASHPAY_DOWNLORD = drENDACCOUNT["CASHPAY_DOWNLORD"].TryParseToDouble(); //初始缴款金额
|
|
endaccountModel.DIFFERENT_PRICE = drENDACCOUNT["DIFFERENT_PRICE"].TryParseToDouble(); //长短款
|
|
endaccountModel.DIFFERENCE_REASON = drENDACCOUNT["DIFFERENCE_REASON"].ToString(); //产生原因
|
|
endaccountModel.DESCRIPTION_STAFF = drENDACCOUNT["DESCRIPTION_STAFF"].ToString(); //问题说明人
|
|
endaccountModel.DESCRIPTION_DATE = drENDACCOUNT["DESCRIPTION_DATE"].TryParseToDateTime(); //说明时间
|
|
endaccountModel.APPROVE_STAFF = drENDACCOUNT["APPROVE_STAFF"].ToString(); //审核人
|
|
endaccountModel.APPROVE_DATE = drENDACCOUNT["APPROVE_DATE"].TryParseToDateTime(); //审核时间
|
|
endaccountModel.APPROVED_INFO = drENDACCOUNT["APPROVED_INFO"].ToString(); //审核意见
|
|
endaccountModel.TREATMENT_MARK = drENDACCOUNT["TREATMENT_MARK"].TryParseToShort(); //处理标记
|
|
endaccountModel.DOWNLOAD_DATE = drENDACCOUNT["DOWNLOAD_DATE"].TryParseToDateTime(); //下载时间
|
|
endaccountModel.VALID = drENDACCOUNT["VALID"].TryParseToShort(); //是否有效
|
|
endaccountModel.ENDACCOUNT_DESC = drENDACCOUNT["ENDACCOUNT_DESC"].ToString(); //备注
|
|
endaccountModel.OPERATE_TYPE = drENDACCOUNT["OPERATE_TYPE"].TryParseToShort(); //操作类型
|
|
endaccountModel.TICKETCODE = drENDACCOUNT["TICKETCODE"].TryParseToInt(); //TICKETCODE
|
|
endaccountModel.SELLCOUNT = drENDACCOUNT["SELLCOUNT"].TryParseToDouble(); //SELLCOUNT
|
|
endaccountModel.FACTAMOUNT = drENDACCOUNT["FACTAMOUNT"].TryParseToDouble(); //FACTAMOUNT
|
|
endaccountModel.TICKET_COUNT = drENDACCOUNT["TICKET_COUNT"].TryParseToDouble(); //移动支付客单量
|
|
endaccountModel.FACT_AMOUNT = drENDACCOUNT["FACT_AMOUNT"].TryParseToDouble(); //移动支付金额
|
|
endaccountModel.TICKETCODE_SALE = drENDACCOUNT["TICKETCODE_SALE"].TryParseToInt(); //TICKETCODE_SALE
|
|
endaccountModel.SELLCOUNT_SALE = drENDACCOUNT["SELLCOUNT_SALE"].TryParseToDouble(); //SELLCOUNT_SALE
|
|
endaccountModel.FACTAMOUNT_SALE = drENDACCOUNT["FACTAMOUNT_SALE"].TryParseToDouble(); //FACTAMOUNT_SALE
|
|
endaccountModel.TICKETCODE_CIGARETTE = drENDACCOUNT["TICKETCODE_CIGARETTE"].TryParseToInt(); //TICKETCODE_CIGARETTE
|
|
endaccountModel.SELLCOUNT_CIGARETTE = drENDACCOUNT["SELLCOUNT_CIGARETTE"].TryParseToDouble(); //SELLCOUNT_CIGARETTE
|
|
endaccountModel.FACTAMOUNT_CIGARETTE = drENDACCOUNT["FACTAMOUNT_CIGARETTE"].TryParseToDouble(); //FACTAMOUNT_CIGARETTE
|
|
endaccountModel.SELLCOUNT_PROMOTION = drENDACCOUNT["SELLCOUNT_PROMOTION"].TryParseToDouble(); //促销数量
|
|
endaccountModel.FACTAMOUNT_PROMOTION = drENDACCOUNT["FACTAMOUNT_PROMOTION"].TryParseToDouble(); //促销金额
|
|
endaccountModel.XCCHECK = drENDACCOUNT["XCCHECK"].TryParseToInt(); //XCCHECK
|
|
endaccountModel.QYCHECK = drENDACCOUNT["QYCHECK"].TryParseToInt(); //QYCHECK
|
|
endaccountModel.GSCHECK = drENDACCOUNT["GSCHECK"].TryParseToInt(); //GSCHECK
|
|
endaccountModel.CHECK_COUNT = drENDACCOUNT["CHECK_COUNT"].TryParseToInt(); //CHECK_COUNT
|
|
endaccountModel.CHECK_INFO = drENDACCOUNT["CHECK_INFO"].ToString(); //CHECK_INFO
|
|
endaccountModel.CASH_CORRECT = drENDACCOUNT["CASH_CORRECT"].TryParseToDouble(); //CASH_CORRECT
|
|
endaccountModel.MOBILE_CORRECT = drENDACCOUNT["MOBILE_CORRECT"].TryParseToDouble(); //MOBILE_CORRECT
|
|
endaccountModel.SALE_CORRECT = drENDACCOUNT["SALE_CORRECT"].TryParseToDouble(); //SALE_CORRECT
|
|
endaccountModel.CORRECT_AMOUNT = drENDACCOUNT["CORRECT_AMOUNT"].TryParseToDouble(); //CORRECT_AMOUNT
|
|
endaccountModel.ONLINETICKET = drENDACCOUNT["ONLINETICKET"].TryParseToDouble(); //ONLINETICKET
|
|
endaccountModel.ONLINEAMOUNT = drENDACCOUNT["ONLINEAMOUNT"].TryParseToDouble(); //ONLINEAMOUNT
|
|
endaccountModel.REVIEW_STATE = drENDACCOUNT["REVIEW_STATE"].TryParseToShort(); //REVIEW_STATE
|
|
|
|
ENDACCOUNTList.Add(endaccountModel);
|
|
}
|
|
|
|
return ENDACCOUNTList;
|
|
}
|
|
#endregion
|
|
|
|
#region 获取结账表明细
|
|
/// <summary>
|
|
/// 获取结账表明细
|
|
/// </summary>
|
|
/// <param name="transaction">事务管理器</param>
|
|
/// <param name="ENDACCOUNTId">结账表内码</param>
|
|
public static Model.ENDACCOUNTModel GetENDACCOUNTDetail(Transaction transaction, int ENDACCOUNTId)
|
|
{
|
|
Model.ENDACCOUNTModel endaccountModel = new Model.ENDACCOUNTModel();
|
|
|
|
Business.ENDACCOUNT _ENDACCOUNT = new Business.ENDACCOUNT(transaction);
|
|
_ENDACCOUNT.ENDACCOUNT_ID = ENDACCOUNTId;
|
|
if (_ENDACCOUNT.Select())
|
|
{
|
|
endaccountModel.ENDACCOUNT_ID = _ENDACCOUNT.ENDACCOUNT_ID; //内码
|
|
endaccountModel.SERVERPART_ID = _ENDACCOUNT.SERVERPART_ID; //服务区内码
|
|
endaccountModel.SERVERPARTCODE = _ENDACCOUNT.SERVERPARTCODE; //服务区号
|
|
endaccountModel.SERVERPART_NAME = _ENDACCOUNT.SERVERPART_NAME; //服务区名称
|
|
endaccountModel.PROVINCE_CODE = _ENDACCOUNT.PROVINCE_CODE; //省份编码
|
|
endaccountModel.ENDACCOUNT_DATE = _ENDACCOUNT.ENDACCOUNT_DATE; //结账时间
|
|
endaccountModel.STATISTICS_DATE = _ENDACCOUNT.STATISTICS_DATE; //结算日期
|
|
endaccountModel.ENDACCOUNT_STARTDATE = _ENDACCOUNT.ENDACCOUNT_STARTDATE; //销售起始时间
|
|
endaccountModel.SHOPCODE = _ENDACCOUNT.SHOPCODE; //店号
|
|
endaccountModel.SHOPNAME = _ENDACCOUNT.SHOPNAME; //店名称
|
|
endaccountModel.MACHINECODE = _ENDACCOUNT.MACHINECODE; //机号
|
|
endaccountModel.ENDPERSONCODE = _ENDACCOUNT.ENDPERSONCODE; //结账人编号
|
|
endaccountModel.WORKER_NAME = _ENDACCOUNT.WORKER_NAME; //结账人名称
|
|
endaccountModel.CASHIER_NAME = _ENDACCOUNT.CASHIER_NAME; //收银员名称
|
|
endaccountModel.TICKETCOUNT = _ENDACCOUNT.TICKETCOUNT; //单据数
|
|
endaccountModel.TOTALCOUNT = _ENDACCOUNT.TOTALCOUNT; //总数量
|
|
endaccountModel.TOTALSELLAMOUNT = _ENDACCOUNT.TOTALSELLAMOUNT; //总销售额
|
|
endaccountModel.TOTALOFFAMOUNT = _ENDACCOUNT.TOTALOFFAMOUNT; //总优惠
|
|
endaccountModel.CASH = _ENDACCOUNT.CASH; //现金
|
|
endaccountModel.CREDITCARD = _ENDACCOUNT.CREDITCARD; //信用卡
|
|
endaccountModel.TICKETBILL = _ENDACCOUNT.TICKETBILL; //支票(微信)
|
|
endaccountModel.VIPPERSON = _ENDACCOUNT.VIPPERSON; //会员卡
|
|
endaccountModel.COSTBILL = _ENDACCOUNT.COSTBILL; //消费券
|
|
endaccountModel.OTHERPAY = _ENDACCOUNT.OTHERPAY; //其他支付(支付宝)
|
|
endaccountModel.CASHPAY = _ENDACCOUNT.CASHPAY; //缴款金额
|
|
endaccountModel.CASHPAY_DOWNLORD = _ENDACCOUNT.CASHPAY_DOWNLORD; //初始缴款金额
|
|
endaccountModel.DIFFERENT_PRICE = _ENDACCOUNT.DIFFERENT_PRICE; //长短款
|
|
endaccountModel.DIFFERENCE_REASON = _ENDACCOUNT.DIFFERENCE_REASON; //产生原因
|
|
endaccountModel.DESCRIPTION_STAFF = _ENDACCOUNT.DESCRIPTION_STAFF; //问题说明人
|
|
endaccountModel.DESCRIPTION_DATE = _ENDACCOUNT.DESCRIPTION_DATE; //说明时间
|
|
endaccountModel.APPROVE_STAFF = _ENDACCOUNT.APPROVE_STAFF; //审核人
|
|
endaccountModel.APPROVE_DATE = _ENDACCOUNT.APPROVE_DATE; //审核时间
|
|
endaccountModel.APPROVED_INFO = _ENDACCOUNT.APPROVED_INFO; //审核意见
|
|
endaccountModel.TREATMENT_MARK = _ENDACCOUNT.TREATMENT_MARK; //处理标记
|
|
endaccountModel.DOWNLOAD_DATE = _ENDACCOUNT.DOWNLOAD_DATE; //下载时间
|
|
endaccountModel.VALID = _ENDACCOUNT.VALID; //是否有效
|
|
endaccountModel.ENDACCOUNT_DESC = _ENDACCOUNT.ENDACCOUNT_DESC; //备注
|
|
endaccountModel.OPERATE_TYPE = _ENDACCOUNT.OPERATE_TYPE; //操作类型
|
|
endaccountModel.TICKETCODE = _ENDACCOUNT.TICKETCODE; //TICKETCODE
|
|
endaccountModel.SELLCOUNT = _ENDACCOUNT.SELLCOUNT; //SELLCOUNT
|
|
endaccountModel.FACTAMOUNT = _ENDACCOUNT.FACTAMOUNT; //FACTAMOUNT
|
|
endaccountModel.TICKET_COUNT = _ENDACCOUNT.TICKET_COUNT; //移动支付客单量
|
|
endaccountModel.FACT_AMOUNT = _ENDACCOUNT.FACT_AMOUNT; //移动支付金额
|
|
endaccountModel.TICKETCODE_SALE = _ENDACCOUNT.TICKETCODE_SALE; //TICKETCODE_SALE
|
|
endaccountModel.SELLCOUNT_SALE = _ENDACCOUNT.SELLCOUNT_SALE; //SELLCOUNT_SALE
|
|
endaccountModel.FACTAMOUNT_SALE = _ENDACCOUNT.FACTAMOUNT_SALE; //FACTAMOUNT_SALE
|
|
endaccountModel.TICKETCODE_CIGARETTE = _ENDACCOUNT.TICKETCODE_CIGARETTE; //TICKETCODE_CIGARETTE
|
|
endaccountModel.SELLCOUNT_CIGARETTE = _ENDACCOUNT.SELLCOUNT_CIGARETTE; //SELLCOUNT_CIGARETTE
|
|
endaccountModel.FACTAMOUNT_CIGARETTE = _ENDACCOUNT.FACTAMOUNT_CIGARETTE; //FACTAMOUNT_CIGARETTE
|
|
endaccountModel.SELLCOUNT_PROMOTION = _ENDACCOUNT.SELLCOUNT_PROMOTION; //促销数量
|
|
endaccountModel.FACTAMOUNT_PROMOTION = _ENDACCOUNT.FACTAMOUNT_PROMOTION; //促销金额
|
|
endaccountModel.XCCHECK = _ENDACCOUNT.XCCHECK; //XCCHECK
|
|
endaccountModel.QYCHECK = _ENDACCOUNT.QYCHECK; //QYCHECK
|
|
endaccountModel.GSCHECK = _ENDACCOUNT.GSCHECK; //GSCHECK
|
|
endaccountModel.CHECK_COUNT = _ENDACCOUNT.CHECK_COUNT; //CHECK_COUNT
|
|
endaccountModel.CHECK_INFO = _ENDACCOUNT.CHECK_INFO; //CHECK_INFO
|
|
endaccountModel.CASH_CORRECT = _ENDACCOUNT.CASH_CORRECT; //CASH_CORRECT
|
|
endaccountModel.MOBILE_CORRECT = _ENDACCOUNT.MOBILE_CORRECT; //MOBILE_CORRECT
|
|
endaccountModel.SALE_CORRECT = _ENDACCOUNT.SALE_CORRECT; //SALE_CORRECT
|
|
endaccountModel.CORRECT_AMOUNT = _ENDACCOUNT.CORRECT_AMOUNT; //CORRECT_AMOUNT
|
|
endaccountModel.ONLINETICKET = _ENDACCOUNT.ONLINETICKET; //ONLINETICKET
|
|
endaccountModel.ONLINEAMOUNT = _ENDACCOUNT.ONLINEAMOUNT; //ONLINEAMOUNT
|
|
endaccountModel.REVIEW_STATE = _ENDACCOUNT.REVIEW_STATE; //REVIEW_STATE
|
|
}
|
|
|
|
return endaccountModel;
|
|
}
|
|
#endregion
|
|
|
|
#region 同步结账表
|
|
/// <summary>
|
|
/// 赋值结账表数据对象
|
|
/// </summary>
|
|
/// <param name="transaction">事务管理器</param>
|
|
/// <param name="endaccountModel">结账表数据对象</param>
|
|
public static bool SynchroENDACCOUNT(Transaction transaction, Model.ENDACCOUNTModel endaccountModel)
|
|
{
|
|
bool SynchroFlag = true;
|
|
|
|
Business.ENDACCOUNT _ENDACCOUNT = new Business.ENDACCOUNT(transaction);
|
|
if (endaccountModel.ENDACCOUNT_ID != null)
|
|
{
|
|
_ENDACCOUNT.ENDACCOUNT_ID = endaccountModel.ENDACCOUNT_ID;
|
|
if (_ENDACCOUNT.Select())
|
|
{
|
|
SynchroModelToObject(_ENDACCOUNT, endaccountModel);
|
|
_ENDACCOUNT.Update();
|
|
}
|
|
else
|
|
{
|
|
SynchroFlag = false;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
SynchroModelToObject(_ENDACCOUNT, endaccountModel);
|
|
_ENDACCOUNT.Insert();
|
|
}
|
|
|
|
return SynchroFlag;
|
|
}
|
|
|
|
#region 赋值结账表数据对象
|
|
/// <summary>
|
|
/// 赋值结账表数据对象
|
|
/// </summary>
|
|
/// <param name="_ENDACCOUNT"></param>
|
|
/// <param name="endaccountModel"></param>
|
|
public static void SynchroModelToObject(Business.ENDACCOUNT _ENDACCOUNT, Model.ENDACCOUNTModel endaccountModel)
|
|
{
|
|
_ENDACCOUNT.SERVERPART_ID = endaccountModel.SERVERPART_ID; //服务区内码
|
|
_ENDACCOUNT.SERVERPARTCODE = endaccountModel.SERVERPARTCODE; //服务区号
|
|
_ENDACCOUNT.SERVERPART_NAME = endaccountModel.SERVERPART_NAME; //服务区名称
|
|
_ENDACCOUNT.PROVINCE_CODE = endaccountModel.PROVINCE_CODE; //省份编码
|
|
_ENDACCOUNT.ENDACCOUNT_DATE = endaccountModel.ENDACCOUNT_DATE; //结账时间
|
|
_ENDACCOUNT.STATISTICS_DATE = endaccountModel.STATISTICS_DATE; //结算日期
|
|
_ENDACCOUNT.ENDACCOUNT_STARTDATE = endaccountModel.ENDACCOUNT_STARTDATE; //销售起始时间
|
|
_ENDACCOUNT.SHOPCODE = endaccountModel.SHOPCODE; //店号
|
|
_ENDACCOUNT.SHOPNAME = endaccountModel.SHOPNAME; //店名称
|
|
_ENDACCOUNT.MACHINECODE = endaccountModel.MACHINECODE; //机号
|
|
_ENDACCOUNT.ENDPERSONCODE = endaccountModel.ENDPERSONCODE; //结账人编号
|
|
_ENDACCOUNT.WORKER_NAME = endaccountModel.WORKER_NAME; //结账人名称
|
|
_ENDACCOUNT.CASHIER_NAME = endaccountModel.CASHIER_NAME; //收银员名称
|
|
_ENDACCOUNT.TICKETCOUNT = endaccountModel.TICKETCOUNT; //单据数
|
|
_ENDACCOUNT.TOTALCOUNT = endaccountModel.TOTALCOUNT; //总数量
|
|
_ENDACCOUNT.TOTALSELLAMOUNT = endaccountModel.TOTALSELLAMOUNT; //总销售额
|
|
_ENDACCOUNT.TOTALOFFAMOUNT = endaccountModel.TOTALOFFAMOUNT; //总优惠
|
|
_ENDACCOUNT.CASH = endaccountModel.CASH; //现金
|
|
_ENDACCOUNT.CREDITCARD = endaccountModel.CREDITCARD; //信用卡
|
|
_ENDACCOUNT.TICKETBILL = endaccountModel.TICKETBILL; //支票(微信)
|
|
_ENDACCOUNT.VIPPERSON = endaccountModel.VIPPERSON; //会员卡
|
|
_ENDACCOUNT.COSTBILL = endaccountModel.COSTBILL; //消费券
|
|
_ENDACCOUNT.OTHERPAY = endaccountModel.OTHERPAY; //其他支付(支付宝)
|
|
_ENDACCOUNT.CASHPAY = endaccountModel.CASHPAY; //缴款金额
|
|
_ENDACCOUNT.CASHPAY_DOWNLORD = endaccountModel.CASHPAY_DOWNLORD; //初始缴款金额
|
|
_ENDACCOUNT.DIFFERENT_PRICE = endaccountModel.DIFFERENT_PRICE; //长短款
|
|
_ENDACCOUNT.DIFFERENCE_REASON = endaccountModel.DIFFERENCE_REASON; //产生原因
|
|
_ENDACCOUNT.DESCRIPTION_STAFF = endaccountModel.DESCRIPTION_STAFF; //问题说明人
|
|
_ENDACCOUNT.DESCRIPTION_DATE = endaccountModel.DESCRIPTION_DATE; //说明时间
|
|
_ENDACCOUNT.APPROVE_STAFF = endaccountModel.APPROVE_STAFF; //审核人
|
|
_ENDACCOUNT.APPROVE_DATE = endaccountModel.APPROVE_DATE; //审核时间
|
|
_ENDACCOUNT.APPROVED_INFO = endaccountModel.APPROVED_INFO; //审核意见
|
|
_ENDACCOUNT.TREATMENT_MARK = endaccountModel.TREATMENT_MARK; //处理标记
|
|
_ENDACCOUNT.DOWNLOAD_DATE = endaccountModel.DOWNLOAD_DATE; //下载时间
|
|
_ENDACCOUNT.VALID = endaccountModel.VALID; //是否有效
|
|
_ENDACCOUNT.ENDACCOUNT_DESC = endaccountModel.ENDACCOUNT_DESC; //备注
|
|
_ENDACCOUNT.OPERATE_TYPE = endaccountModel.OPERATE_TYPE; //操作类型
|
|
_ENDACCOUNT.TICKETCODE = endaccountModel.TICKETCODE; //TICKETCODE
|
|
_ENDACCOUNT.SELLCOUNT = endaccountModel.SELLCOUNT; //SELLCOUNT
|
|
_ENDACCOUNT.FACTAMOUNT = endaccountModel.FACTAMOUNT; //FACTAMOUNT
|
|
_ENDACCOUNT.TICKET_COUNT = endaccountModel.TICKET_COUNT; //移动支付客单量
|
|
_ENDACCOUNT.FACT_AMOUNT = endaccountModel.FACT_AMOUNT; //移动支付金额
|
|
_ENDACCOUNT.TICKETCODE_SALE = endaccountModel.TICKETCODE_SALE; //TICKETCODE_SALE
|
|
_ENDACCOUNT.SELLCOUNT_SALE = endaccountModel.SELLCOUNT_SALE; //SELLCOUNT_SALE
|
|
_ENDACCOUNT.FACTAMOUNT_SALE = endaccountModel.FACTAMOUNT_SALE; //FACTAMOUNT_SALE
|
|
_ENDACCOUNT.TICKETCODE_CIGARETTE = endaccountModel.TICKETCODE_CIGARETTE; //TICKETCODE_CIGARETTE
|
|
_ENDACCOUNT.SELLCOUNT_CIGARETTE = endaccountModel.SELLCOUNT_CIGARETTE; //SELLCOUNT_CIGARETTE
|
|
_ENDACCOUNT.FACTAMOUNT_CIGARETTE = endaccountModel.FACTAMOUNT_CIGARETTE; //FACTAMOUNT_CIGARETTE
|
|
_ENDACCOUNT.SELLCOUNT_PROMOTION = endaccountModel.SELLCOUNT_PROMOTION; //促销数量
|
|
_ENDACCOUNT.FACTAMOUNT_PROMOTION = endaccountModel.FACTAMOUNT_PROMOTION; //促销金额
|
|
_ENDACCOUNT.XCCHECK = endaccountModel.XCCHECK; //XCCHECK
|
|
_ENDACCOUNT.QYCHECK = endaccountModel.QYCHECK; //QYCHECK
|
|
_ENDACCOUNT.GSCHECK = endaccountModel.GSCHECK; //GSCHECK
|
|
_ENDACCOUNT.CHECK_COUNT = endaccountModel.CHECK_COUNT; //CHECK_COUNT
|
|
_ENDACCOUNT.CHECK_INFO = endaccountModel.CHECK_INFO; //CHECK_INFO
|
|
_ENDACCOUNT.CASH_CORRECT = endaccountModel.CASH_CORRECT; //CASH_CORRECT
|
|
_ENDACCOUNT.MOBILE_CORRECT = endaccountModel.MOBILE_CORRECT; //MOBILE_CORRECT
|
|
_ENDACCOUNT.SALE_CORRECT = endaccountModel.SALE_CORRECT; //SALE_CORRECT
|
|
_ENDACCOUNT.CORRECT_AMOUNT = endaccountModel.CORRECT_AMOUNT; //CORRECT_AMOUNT
|
|
_ENDACCOUNT.ONLINETICKET = endaccountModel.ONLINETICKET; //ONLINETICKET
|
|
_ENDACCOUNT.ONLINEAMOUNT = endaccountModel.ONLINEAMOUNT; //ONLINEAMOUNT
|
|
_ENDACCOUNT.REVIEW_STATE = endaccountModel.REVIEW_STATE; //REVIEW_STATE
|
|
}
|
|
#endregion
|
|
|
|
#endregion
|
|
|
|
#region 删除结账表
|
|
/// <summary>
|
|
/// 删除结账表
|
|
/// </summary>
|
|
/// <param name="transaction">事务管理器</param>
|
|
/// <param name="ENDACCOUNTId">结账表内码</param>
|
|
public static bool DeleteENDACCOUNT(Transaction transaction, int? ENDACCOUNTId)
|
|
{
|
|
bool DeleteFlag = false;
|
|
|
|
if (ENDACCOUNTId != null)
|
|
{
|
|
Business.ENDACCOUNT _ENDACCOUNT = new Business.ENDACCOUNT(transaction);
|
|
_ENDACCOUNT.ENDACCOUNT_ID = ENDACCOUNTId;
|
|
if (_ENDACCOUNT.Select())
|
|
{
|
|
_ENDACCOUNT.VALID = 0;
|
|
DeleteFlag = _ENDACCOUNT.Update();
|
|
}
|
|
}
|
|
|
|
return DeleteFlag;
|
|
}
|
|
#endregion
|
|
}
|
|
}
|