2025-03-27 15:05:14 +08:00

292 lines
20 KiB
C#

using System;
using System.Collections.Generic;
using System.Data;
using SuperMap.RealEstate.ServiceModel;
using Business = SuperMap.RealEstate.BasicArchives.Storage.Business;
namespace GSYWApi.Helper
{
/// <summary>
/// 门店接收信息相关方法
/// </summary>
public class RECEIVESERVERPARTHelper
{
#region
public static List<Model.RECEIVESERVERPARTModel> GetRECEIVESERVERPARTList(Transaction transaction,
ref int TotalCount, int PageIndex = 1, int PageSize = 10, string SortStr = "")
{
List<Model.RECEIVESERVERPARTModel> RECEIVESERVERPARTList = new List<Model.RECEIVESERVERPARTModel>();
string WhereSQL = "", RowFilterSQL = "";
DataTable dtRECEIVESERVERPART = new Business.RECEIVESERVERPART(transaction).FillDataTable(WhereSQL);
if (RowFilterSQL != "")
{
dtRECEIVESERVERPART.DefaultView.RowFilter = RowFilterSQL;
}
//排序:
dtRECEIVESERVERPART.DefaultView.Sort = SortStr;
dtRECEIVESERVERPART = dtRECEIVESERVERPART.DefaultView.ToTable();
//获取查询结果总记录条数
TotalCount = dtRECEIVESERVERPART.Rows.Count;
//根据传入的页码和每页显示条数返回结果
dtRECEIVESERVERPART = CommonHelper.GetDataTableWithPageSize(dtRECEIVESERVERPART, PageSize, PageIndex);
foreach (DataRow drRECEIVESERVERPART in dtRECEIVESERVERPART.Rows)
{
Model.RECEIVESERVERPARTModel receiveserverpartModel = new Model.RECEIVESERVERPARTModel();
receiveserverpartModel.RECEIVESERVERPART_ID = drRECEIVESERVERPART["RECEIVESERVERPART_ID"].TryParseToInt(); //接收内码
receiveserverpartModel.DELIVERSERVERPART_ID = drRECEIVESERVERPART["DELIVERSERVERPART_ID"].TryParseToInt(); //配送内码
receiveserverpartModel.PURCHASE_ID = drRECEIVESERVERPART["PURCHASE_ID"].TryParseToInt(); //采购内码
receiveserverpartModel.SERVERPART_ID = drRECEIVESERVERPART["SERVERPART_ID"].TryParseToInt(); //服务区内码
receiveserverpartModel.SERVERPARTSHOP_ID = drRECEIVESERVERPART["SERVERPARTSHOP_ID"].TryParseToInt(); //门店内码
receiveserverpartModel.RECEIVECENTER_DATE = drRECEIVESERVERPART["RECEIVECENTER_DATE"].TryParseToDateTime(); //接收时间
receiveserverpartModel.RECEIVECENTER_PERSON = drRECEIVESERVERPART["RECEIVECENTER_PERSON"].ToString(); //接收人员
receiveserverpartModel.RECEIVECENTER_CODE = drRECEIVESERVERPART["RECEIVECENTER_CODE"].ToString(); //接受编号
receiveserverpartModel.RECEIVESERVERPART_DESC = drRECEIVESERVERPART["RECEIVESERVERPART_DESC"].ToString(); //备注
receiveserverpartModel.SUPPLIER_ID = drRECEIVESERVERPART["SUPPLIER_ID"].TryParseToInt(); //供应商内码
receiveserverpartModel.SUPPLIER_IDS = drRECEIVESERVERPART["SUPPLIER_IDS"].ToString(); //供应商集合
receiveserverpartModel.SUPPLIER_NAME = drRECEIVESERVERPART["SUPPLIER_NAME"].ToString(); //供应商名称
receiveserverpartModel.RECEIVECENTER_STATE = drRECEIVESERVERPART["RECEIVECENTER_STATE"].TryParseToInt(); //入库状态
receiveserverpartModel.STAFF_ID = drRECEIVESERVERPART["STAFF_ID"].TryParseToInt(); //操作员内码
receiveserverpartModel.STAFF_NAME = drRECEIVESERVERPART["STAFF_NAME"].ToString(); //操作人员
receiveserverpartModel.RECEIVE_TOTALPRICE = drRECEIVESERVERPART["RECEIVE_TOTALPRICE"].TryParseToDouble(); //入库含税金额
receiveserverpartModel.RECEIVE_TOTALAMOUNT = drRECEIVESERVERPART["RECEIVE_TOTALAMOUNT"].TryParseToDouble(); //入库除税金额
receiveserverpartModel.RECEIVE_TOTALCOUNT = drRECEIVESERVERPART["RECEIVE_TOTALCOUNT"].TryParseToDouble(); //入库数量
receiveserverpartModel.PURCHASE_CODE = drRECEIVESERVERPART["PURCHASE_CODE"].ToString(); //采购编码
receiveserverpartModel.PURCHASE_DATE = drRECEIVESERVERPART["PURCHASE_DATE"].TryParseToDateTime(); //采购时间
receiveserverpartModel.PURCHASE_TYPE = drRECEIVESERVERPART["PURCHASE_TYPE"].TryParseToInt(); //采购类型
receiveserverpartModel.DELIVER_CODE = drRECEIVESERVERPART["DELIVER_CODE"].ToString(); //配送单号
receiveserverpartModel.SERVERPART_IDS = drRECEIVESERVERPART["SERVERPART_IDS"].ToString(); //服务区集合
receiveserverpartModel.SERVERPART_NAME = drRECEIVESERVERPART["SERVERPART_NAME"].ToString(); //服务区名称
receiveserverpartModel.SERVERPARTSHOP_IDS = drRECEIVESERVERPART["SERVERPARTSHOP_IDS"].ToString(); //门店集合
receiveserverpartModel.SHOPNAME = drRECEIVESERVERPART["SHOPNAME"].ToString(); //门店名称
receiveserverpartModel.OPERATE_DATE = drRECEIVESERVERPART["OPERATE_DATE"].TryParseToDateTime(); //操作时间
RECEIVESERVERPARTList.Add(receiveserverpartModel);
}
return RECEIVESERVERPARTList;
}
#endregion
#region
/// <summary>
/// 获取门店接收信息列表
/// </summary>
/// <param name="transaction">事务管理器</param>
/// <param name="TotalCount">查询结果总数</param>
/// <param name="searchModel">查询条件对象</param>
public static List<Model.RECEIVESERVERPARTModel> GetRECEIVESERVERPARTList(Transaction transaction,
ref int TotalCount, Models.SearchModel<Model.RECEIVESERVERPARTModel> searchModel)
{
List<Model.RECEIVESERVERPARTModel> RECEIVESERVERPARTList = new List<Model.RECEIVESERVERPARTModel>();
string WhereSQL = "", RowFilterSQL = "";
if (searchModel.SearchParameter != null)
{
WhereSQL = OperationDataHelper<Model.RECEIVESERVERPARTModel>.GetWhereSQL(searchModel.SearchParameter, searchModel.QueryType);
if (WhereSQL != "")
{
WhereSQL = "WHERE " + WhereSQL;
}
}
DataTable dtRECEIVESERVERPART = new Business.RECEIVESERVERPART(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 != "")
{
dtRECEIVESERVERPART.DefaultView.RowFilter = RowFilterSQL;
}
//排序:
dtRECEIVESERVERPART.DefaultView.Sort = searchModel.SortStr;
dtRECEIVESERVERPART = dtRECEIVESERVERPART.DefaultView.ToTable();
//获取查询结果总记录条数
TotalCount = dtRECEIVESERVERPART.Rows.Count;
//根据传入的页码和每页显示条数返回结果
dtRECEIVESERVERPART = CommonHelper.GetDataTableWithPageSize(dtRECEIVESERVERPART, searchModel.PageSize, searchModel.PageIndex);
foreach (DataRow drRECEIVESERVERPART in dtRECEIVESERVERPART.Rows)
{
Model.RECEIVESERVERPARTModel receiveserverpartModel = new Model.RECEIVESERVERPARTModel();
receiveserverpartModel.RECEIVESERVERPART_ID = drRECEIVESERVERPART["RECEIVESERVERPART_ID"].TryParseToInt(); //接收内码
receiveserverpartModel.DELIVERSERVERPART_ID = drRECEIVESERVERPART["DELIVERSERVERPART_ID"].TryParseToInt(); //配送内码
receiveserverpartModel.PURCHASE_ID = drRECEIVESERVERPART["PURCHASE_ID"].TryParseToInt(); //采购内码
receiveserverpartModel.SERVERPART_ID = drRECEIVESERVERPART["SERVERPART_ID"].TryParseToInt(); //服务区内码
receiveserverpartModel.SERVERPARTSHOP_ID = drRECEIVESERVERPART["SERVERPARTSHOP_ID"].TryParseToInt(); //门店内码
receiveserverpartModel.RECEIVECENTER_DATE = drRECEIVESERVERPART["RECEIVECENTER_DATE"].TryParseToDateTime(); //接收时间
receiveserverpartModel.RECEIVECENTER_PERSON = drRECEIVESERVERPART["RECEIVECENTER_PERSON"].ToString(); //接收人员
receiveserverpartModel.RECEIVECENTER_CODE = drRECEIVESERVERPART["RECEIVECENTER_CODE"].ToString(); //接受编号
receiveserverpartModel.RECEIVESERVERPART_DESC = drRECEIVESERVERPART["RECEIVESERVERPART_DESC"].ToString(); //备注
receiveserverpartModel.SUPPLIER_ID = drRECEIVESERVERPART["SUPPLIER_ID"].TryParseToInt(); //供应商内码
receiveserverpartModel.SUPPLIER_IDS = drRECEIVESERVERPART["SUPPLIER_IDS"].ToString(); //供应商集合
receiveserverpartModel.SUPPLIER_NAME = drRECEIVESERVERPART["SUPPLIER_NAME"].ToString(); //供应商名称
receiveserverpartModel.RECEIVECENTER_STATE = drRECEIVESERVERPART["RECEIVECENTER_STATE"].TryParseToInt(); //入库状态
receiveserverpartModel.STAFF_ID = drRECEIVESERVERPART["STAFF_ID"].TryParseToInt(); //操作员内码
receiveserverpartModel.STAFF_NAME = drRECEIVESERVERPART["STAFF_NAME"].ToString(); //操作人员
receiveserverpartModel.RECEIVE_TOTALPRICE = drRECEIVESERVERPART["RECEIVE_TOTALPRICE"].TryParseToDouble(); //入库含税金额
receiveserverpartModel.RECEIVE_TOTALAMOUNT = drRECEIVESERVERPART["RECEIVE_TOTALAMOUNT"].TryParseToDouble(); //入库除税金额
receiveserverpartModel.RECEIVE_TOTALCOUNT = drRECEIVESERVERPART["RECEIVE_TOTALCOUNT"].TryParseToDouble(); //入库数量
receiveserverpartModel.PURCHASE_CODE = drRECEIVESERVERPART["PURCHASE_CODE"].ToString(); //采购编码
receiveserverpartModel.PURCHASE_DATE = drRECEIVESERVERPART["PURCHASE_DATE"].TryParseToDateTime(); //采购时间
receiveserverpartModel.PURCHASE_TYPE = drRECEIVESERVERPART["PURCHASE_TYPE"].TryParseToInt(); //采购类型
receiveserverpartModel.DELIVER_CODE = drRECEIVESERVERPART["DELIVER_CODE"].ToString(); //配送单号
receiveserverpartModel.SERVERPART_IDS = drRECEIVESERVERPART["SERVERPART_IDS"].ToString(); //服务区集合
receiveserverpartModel.SERVERPART_NAME = drRECEIVESERVERPART["SERVERPART_NAME"].ToString(); //服务区名称
receiveserverpartModel.SERVERPARTSHOP_IDS = drRECEIVESERVERPART["SERVERPARTSHOP_IDS"].ToString(); //门店集合
receiveserverpartModel.SHOPNAME = drRECEIVESERVERPART["SHOPNAME"].ToString(); //门店名称
receiveserverpartModel.OPERATE_DATE = drRECEIVESERVERPART["OPERATE_DATE"].TryParseToDateTime(); //操作时间
RECEIVESERVERPARTList.Add(receiveserverpartModel);
}
return RECEIVESERVERPARTList;
}
#endregion
#region
public static Model.RECEIVESERVERPARTModel GetRECEIVESERVERPARTDetail(Transaction transaction, int RECEIVESERVERPARTId)
{
Model.RECEIVESERVERPARTModel receiveserverpartModel = new Model.RECEIVESERVERPARTModel();
Business.RECEIVESERVERPART _RECEIVESERVERPART = new Business.RECEIVESERVERPART(transaction);
_RECEIVESERVERPART.RECEIVESERVERPART_ID = RECEIVESERVERPARTId;
if (_RECEIVESERVERPART.Select())
{
receiveserverpartModel.RECEIVESERVERPART_ID = _RECEIVESERVERPART.RECEIVESERVERPART_ID; //接收内码
receiveserverpartModel.DELIVERSERVERPART_ID = _RECEIVESERVERPART.DELIVERSERVERPART_ID; //配送内码
receiveserverpartModel.PURCHASE_ID = _RECEIVESERVERPART.PURCHASE_ID; //采购内码
receiveserverpartModel.SERVERPART_ID = _RECEIVESERVERPART.SERVERPART_ID; //服务区内码
receiveserverpartModel.SERVERPARTSHOP_ID = _RECEIVESERVERPART.SERVERPARTSHOP_ID; //门店内码
receiveserverpartModel.RECEIVECENTER_DATE = _RECEIVESERVERPART.RECEIVECENTER_DATE; //接收时间
receiveserverpartModel.RECEIVECENTER_PERSON = _RECEIVESERVERPART.RECEIVECENTER_PERSON; //接收人员
receiveserverpartModel.RECEIVECENTER_CODE = _RECEIVESERVERPART.RECEIVECENTER_CODE; //接受编号
receiveserverpartModel.RECEIVESERVERPART_DESC = _RECEIVESERVERPART.RECEIVESERVERPART_DESC; //备注
receiveserverpartModel.SUPPLIER_ID = _RECEIVESERVERPART.SUPPLIER_ID; //供应商内码
receiveserverpartModel.SUPPLIER_IDS = _RECEIVESERVERPART.SUPPLIER_IDS; //供应商集合
receiveserverpartModel.SUPPLIER_NAME = _RECEIVESERVERPART.SUPPLIER_NAME; //供应商名称
receiveserverpartModel.RECEIVECENTER_STATE = _RECEIVESERVERPART.RECEIVECENTER_STATE; //入库状态
receiveserverpartModel.STAFF_ID = _RECEIVESERVERPART.STAFF_ID; //操作员内码
receiveserverpartModel.STAFF_NAME = _RECEIVESERVERPART.STAFF_NAME; //操作人员
receiveserverpartModel.RECEIVE_TOTALPRICE = _RECEIVESERVERPART.RECEIVE_TOTALPRICE; //入库含税金额
receiveserverpartModel.RECEIVE_TOTALAMOUNT = _RECEIVESERVERPART.RECEIVE_TOTALAMOUNT; //入库除税金额
receiveserverpartModel.RECEIVE_TOTALCOUNT = _RECEIVESERVERPART.RECEIVE_TOTALCOUNT; //入库数量
receiveserverpartModel.PURCHASE_CODE = _RECEIVESERVERPART.PURCHASE_CODE; //采购编码
receiveserverpartModel.PURCHASE_DATE = _RECEIVESERVERPART.PURCHASE_DATE; //采购时间
receiveserverpartModel.PURCHASE_TYPE = _RECEIVESERVERPART.PURCHASE_TYPE; //采购类型
receiveserverpartModel.DELIVER_CODE = _RECEIVESERVERPART.DELIVER_CODE; //配送单号
receiveserverpartModel.SERVERPART_IDS = _RECEIVESERVERPART.SERVERPART_IDS; //服务区集合
receiveserverpartModel.SERVERPART_NAME = _RECEIVESERVERPART.SERVERPART_NAME; //服务区名称
receiveserverpartModel.SERVERPARTSHOP_IDS = _RECEIVESERVERPART.SERVERPARTSHOP_IDS; //门店集合
receiveserverpartModel.SHOPNAME = _RECEIVESERVERPART.SHOPNAME; //门店名称
receiveserverpartModel.OPERATE_DATE = _RECEIVESERVERPART.OPERATE_DATE; //操作时间
}
return receiveserverpartModel;
}
#endregion
#region
/// <summary>
/// 赋值门店接收信息数据对象
/// </summary>
/// <param name="transaction">事务管理器</param>
/// <param name="receiveserverpartModel">门店接收信息数据对象</param>
public static bool SynchroRECEIVESERVERPART(Transaction transaction, Model.RECEIVESERVERPARTModel receiveserverpartModel)
{
bool SynchroFlag = true;
Business.RECEIVESERVERPART _RECEIVESERVERPART = new Business.RECEIVESERVERPART(transaction);
if (receiveserverpartModel.RECEIVESERVERPART_ID != null)
{
_RECEIVESERVERPART.RECEIVESERVERPART_ID = receiveserverpartModel.RECEIVESERVERPART_ID;
if (_RECEIVESERVERPART.Select())
{
SynchroModelToObject(_RECEIVESERVERPART, receiveserverpartModel);
_RECEIVESERVERPART.Update();
}
else
{
SynchroFlag = false;
}
}
else
{
SynchroModelToObject(_RECEIVESERVERPART, receiveserverpartModel);
_RECEIVESERVERPART.Insert();
}
return SynchroFlag;
}
#region
/// <summary>
/// 赋值门店接收信息数据对象
/// </summary>
/// <param name="_RECEIVESERVERPART"></param>
/// <param name="receiveserverpartModel"></param>
public static void SynchroModelToObject(Business.RECEIVESERVERPART _RECEIVESERVERPART, Model.RECEIVESERVERPARTModel receiveserverpartModel)
{
_RECEIVESERVERPART.DELIVERSERVERPART_ID = receiveserverpartModel.DELIVERSERVERPART_ID; //配送内码
_RECEIVESERVERPART.PURCHASE_ID = receiveserverpartModel.PURCHASE_ID; //采购内码
_RECEIVESERVERPART.SERVERPART_ID = receiveserverpartModel.SERVERPART_ID; //服务区内码
_RECEIVESERVERPART.SERVERPARTSHOP_ID = receiveserverpartModel.SERVERPARTSHOP_ID; //门店内码
_RECEIVESERVERPART.RECEIVECENTER_DATE = receiveserverpartModel.RECEIVECENTER_DATE; //接收时间
_RECEIVESERVERPART.RECEIVECENTER_PERSON = receiveserverpartModel.RECEIVECENTER_PERSON; //接收人员
_RECEIVESERVERPART.RECEIVECENTER_CODE = receiveserverpartModel.RECEIVECENTER_CODE; //接受编号
_RECEIVESERVERPART.RECEIVESERVERPART_DESC = receiveserverpartModel.RECEIVESERVERPART_DESC; //备注
_RECEIVESERVERPART.SUPPLIER_ID = receiveserverpartModel.SUPPLIER_ID; //供应商内码
_RECEIVESERVERPART.SUPPLIER_IDS = receiveserverpartModel.SUPPLIER_IDS; //供应商集合
_RECEIVESERVERPART.SUPPLIER_NAME = receiveserverpartModel.SUPPLIER_NAME; //供应商名称
_RECEIVESERVERPART.RECEIVECENTER_STATE = receiveserverpartModel.RECEIVECENTER_STATE; //入库状态
_RECEIVESERVERPART.STAFF_ID = receiveserverpartModel.STAFF_ID; //操作员内码
_RECEIVESERVERPART.STAFF_NAME = receiveserverpartModel.STAFF_NAME; //操作人员
_RECEIVESERVERPART.RECEIVE_TOTALPRICE = receiveserverpartModel.RECEIVE_TOTALPRICE; //入库含税金额
_RECEIVESERVERPART.RECEIVE_TOTALAMOUNT = receiveserverpartModel.RECEIVE_TOTALAMOUNT; //入库除税金额
_RECEIVESERVERPART.RECEIVE_TOTALCOUNT = receiveserverpartModel.RECEIVE_TOTALCOUNT; //入库数量
_RECEIVESERVERPART.PURCHASE_CODE = receiveserverpartModel.PURCHASE_CODE; //采购编码
_RECEIVESERVERPART.PURCHASE_DATE = receiveserverpartModel.PURCHASE_DATE; //采购时间
_RECEIVESERVERPART.PURCHASE_TYPE = receiveserverpartModel.PURCHASE_TYPE; //采购类型
_RECEIVESERVERPART.DELIVER_CODE = receiveserverpartModel.DELIVER_CODE; //配送单号
_RECEIVESERVERPART.SERVERPART_IDS = receiveserverpartModel.SERVERPART_IDS; //服务区集合
_RECEIVESERVERPART.SERVERPART_NAME = receiveserverpartModel.SERVERPART_NAME; //服务区名称
_RECEIVESERVERPART.SERVERPARTSHOP_IDS = receiveserverpartModel.SERVERPARTSHOP_IDS; //门店集合
_RECEIVESERVERPART.SHOPNAME = receiveserverpartModel.SHOPNAME; //门店名称
_RECEIVESERVERPART.OPERATE_DATE = receiveserverpartModel.OPERATE_DATE; //操作时间
}
#endregion
#endregion
#region
public static bool DeleteRECEIVESERVERPART(Transaction transaction, int? RECEIVESERVERPARTId)
{
bool DeleteFlag = false;
if (RECEIVESERVERPARTId != null)
{
Business.RECEIVESERVERPART _RECEIVESERVERPART = new Business.RECEIVESERVERPART(transaction);
_RECEIVESERVERPART.RECEIVESERVERPART_ID = RECEIVESERVERPARTId;
if (_RECEIVESERVERPART.Select())
{
_RECEIVESERVERPART.Delete();
DeleteFlag = true;
}
}
return DeleteFlag;
}
#endregion
}
}