227 lines
12 KiB
C#
227 lines
12 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 MERCHANTSHelper
|
||
{
|
||
#region 获取商户信息表列表
|
||
/// <summary>
|
||
/// 获取商户信息表列表
|
||
/// </summary>
|
||
/// <param name="transaction">事务管理器</param>
|
||
/// <param name="ServerpartId">服务区内码</param>
|
||
/// <param name="Merchants_State">有效状态</param>
|
||
/// <param name="Merchants_Name">模糊查询条件：商户名称</param>
|
||
/// <param name="TotalCount">数据总数量</param>
|
||
/// <param name="PageIndex">查询页码数</param>
|
||
/// <param name="PageSize">每页显示行数</param>
|
||
/// <param name="SortStr">排序字段</param>
|
||
/// <returns></returns>
|
||
public static List<Model.MERCHANTSModel> GetMERCHANTSList(Transaction transaction, int? ServerpartId,
|
||
int? Merchants_State, string Merchants_Name, ref int TotalCount, int PageIndex = 1, int PageSize = 10, string SortStr = "")
|
||
{
|
||
List<Model.MERCHANTSModel> MERCHANTSList = new List<Model.MERCHANTSModel>();
|
||
|
||
string WhereSQL = "", RowFilterSQL = "";
|
||
//查询服务区内码
|
||
if (ServerpartId != null)
|
||
{
|
||
WhereSQL += (WhereSQL == "" ? "WHERE " : " AND ") + "SERVERPART_ID = " + ServerpartId;
|
||
}
|
||
//查询有效状态
|
||
if (Merchants_State != null)
|
||
{
|
||
WhereSQL += (WhereSQL == "" ? "WHERE " : " AND ") + "MERCHANTS_STATE = " + Merchants_State;
|
||
}
|
||
|
||
DataTable dtMERCHANTS = new Business.MERCHANTS(transaction).FillDataTable(WhereSQL);
|
||
if (!string.IsNullOrWhiteSpace(Merchants_Name))
|
||
{
|
||
RowFilterSQL = "MERCHANTS_NAME like '%" + Merchants_Name + "%'";
|
||
}
|
||
if (RowFilterSQL != "")
|
||
{
|
||
dtMERCHANTS.DefaultView.RowFilter = RowFilterSQL;
|
||
}
|
||
//排序：
|
||
dtMERCHANTS.DefaultView.Sort = SortStr;
|
||
dtMERCHANTS = dtMERCHANTS.DefaultView.ToTable();
|
||
//获取查询结果总记录条数
|
||
TotalCount = dtMERCHANTS.Rows.Count;
|
||
//根据传入的页码和每页显示条数返回结果
|
||
dtMERCHANTS = CommonHelper.GetDataTableWithPageSize(dtMERCHANTS, PageSize, PageIndex);
|
||
|
||
foreach (DataRow drMERCHANTS in dtMERCHANTS.Rows)
|
||
{
|
||
Model.MERCHANTSModel merchantsModel = new Model.MERCHANTSModel();
|
||
|
||
merchantsModel.MERCHANTS_ID = drMERCHANTS["MERCHANTS_ID"].TryParseToInt(); //商户内码
|
||
merchantsModel.SERVERPART_ID = drMERCHANTS["SERVERPART_ID"].TryParseToInt(); //服务区内码
|
||
merchantsModel.PROVINCE_CODE = drMERCHANTS["PROVINCE_CODE"].TryParseToInt(); //省份编码
|
||
merchantsModel.MERCHANTS_CATEGORY = drMERCHANTS["MERCHANTS_CATEGORY"].TryParseToInt(); //商户分类（1000：经营类）
|
||
merchantsModel.MERCHANTS_TYPE = drMERCHANTS["MERCHANTS_TYPE"].ToString(); //商户类型
|
||
merchantsModel.MERCHANTS_NATURE = drMERCHANTS["MERCHANTS_NATURE"].TryParseToInt(); //商户性质
|
||
merchantsModel.MERCHANTS_CODE = drMERCHANTS["MERCHANTS_CODE"].ToString(); //商户编码
|
||
merchantsModel.MERCHANTS_NAME = drMERCHANTS["MERCHANTS_NAME"].ToString(); //商户名称
|
||
merchantsModel.MERCHANTS_EN = drMERCHANTS["MERCHANTS_EN"].ToString(); //商户简称
|
||
merchantsModel.TAXPAYER_IDENTIFYCODE = drMERCHANTS["TAXPAYER_IDENTIFYCODE"].ToString(); //纳税人识别号
|
||
merchantsModel.MERCHANTS_DRAWER = drMERCHANTS["MERCHANTS_DRAWER"].ToString(); //商户开票人
|
||
merchantsModel.MERCHANTS_FAX = drMERCHANTS["MERCHANTS_FAX"].ToString(); //商户传真
|
||
merchantsModel.MERCHANTS_EMAIL = drMERCHANTS["MERCHANTS_EMAIL"].ToString(); //商户邮箱
|
||
merchantsModel.MERCHANTS_ADDRESS = drMERCHANTS["MERCHANTS_ADDRESS"].ToString(); //单位地址
|
||
merchantsModel.MERCHANTS_LINKMAN = drMERCHANTS["MERCHANTS_LINKMAN"].ToString(); //商户联系人
|
||
merchantsModel.MERCHANTS_TELEPHONE = drMERCHANTS["MERCHANTS_TELEPHONE"].ToString(); //联系电话
|
||
merchantsModel.MERCHANTS_MOBILEPHONE = drMERCHANTS["MERCHANTS_MOBILEPHONE"].ToString(); //手机号码
|
||
merchantsModel.BANK_ACCOUNT = drMERCHANTS["BANK_ACCOUNT"].ToString(); //银行账号
|
||
merchantsModel.BANK_NAME = drMERCHANTS["BANK_NAME"].ToString(); //开户行
|
||
merchantsModel.MERCHANTS_STATE = drMERCHANTS["MERCHANTS_STATE"].TryParseToShort(); //商户状态
|
||
merchantsModel.STAFF_ID = drMERCHANTS["STAFF_ID"].TryParseToInt(); //操作员内码
|
||
merchantsModel.STAFF_NAME = drMERCHANTS["STAFF_NAME"].ToString(); //操作人员
|
||
merchantsModel.OPERATE_DATE = drMERCHANTS["OPERATE_DATE"].TryParseToDateTime(); //操作时间
|
||
merchantsModel.MERCHANTS_DESC = drMERCHANTS["MERCHANTS_DESC"].ToString(); //备注
|
||
|
||
MERCHANTSList.Add(merchantsModel);
|
||
}
|
||
|
||
return MERCHANTSList;
|
||
}
|
||
#endregion
|
||
|
||
#region 获取商户信息详情
|
||
/// <summary>
|
||
/// 获取商户信息详情
|
||
/// </summary>
|
||
/// <param name="transaction">事务管理器</param>
|
||
/// <param name="MERCHANTSId">商户内码</param>
|
||
/// <returns></returns>
|
||
public static Model.MERCHANTSModel GetMERCHANTSDetail(Transaction transaction, int MERCHANTSId)
|
||
{
|
||
Model.MERCHANTSModel merchantsModel = new Model.MERCHANTSModel();
|
||
|
||
Business.MERCHANTS _MERCHANTS = new Business.MERCHANTS(transaction);
|
||
_MERCHANTS.MERCHANTS_ID = MERCHANTSId;
|
||
if (_MERCHANTS.Select())
|
||
{
|
||
merchantsModel.MERCHANTS_ID = _MERCHANTS.MERCHANTS_ID; //商户内码
|
||
merchantsModel.SERVERPART_ID = _MERCHANTS.SERVERPART_ID; //服务区内码
|
||
merchantsModel.PROVINCE_CODE = _MERCHANTS.PROVINCE_CODE; //省份编码
|
||
merchantsModel.MERCHANTS_CATEGORY = _MERCHANTS.MERCHANTS_CATEGORY; //商户分类（1000：经营类）
|
||
merchantsModel.MERCHANTS_TYPE = _MERCHANTS.MERCHANTS_TYPE; //商户类型
|
||
merchantsModel.MERCHANTS_NATURE = _MERCHANTS.MERCHANTS_NATURE; //商户性质
|
||
merchantsModel.MERCHANTS_CODE = _MERCHANTS.MERCHANTS_CODE; //商户编码
|
||
merchantsModel.MERCHANTS_NAME = _MERCHANTS.MERCHANTS_NAME; //商户名称
|
||
merchantsModel.MERCHANTS_EN = _MERCHANTS.MERCHANTS_EN; //商户简称
|
||
merchantsModel.TAXPAYER_IDENTIFYCODE = _MERCHANTS.TAXPAYER_IDENTIFYCODE; //纳税人识别号
|
||
merchantsModel.MERCHANTS_DRAWER = _MERCHANTS.MERCHANTS_DRAWER; //商户开票人
|
||
merchantsModel.MERCHANTS_FAX = _MERCHANTS.MERCHANTS_FAX; //商户传真
|
||
merchantsModel.MERCHANTS_EMAIL = _MERCHANTS.MERCHANTS_EMAIL; //商户邮箱
|
||
merchantsModel.MERCHANTS_ADDRESS = _MERCHANTS.MERCHANTS_ADDRESS; //单位地址
|
||
merchantsModel.MERCHANTS_LINKMAN = _MERCHANTS.MERCHANTS_LINKMAN; //商户联系人
|
||
merchantsModel.MERCHANTS_TELEPHONE = _MERCHANTS.MERCHANTS_TELEPHONE; //联系电话
|
||
merchantsModel.MERCHANTS_MOBILEPHONE = _MERCHANTS.MERCHANTS_MOBILEPHONE; //手机号码
|
||
merchantsModel.BANK_ACCOUNT = _MERCHANTS.BANK_ACCOUNT; //银行账号
|
||
merchantsModel.BANK_NAME = _MERCHANTS.BANK_NAME; //开户行
|
||
merchantsModel.MERCHANTS_STATE = _MERCHANTS.MERCHANTS_STATE; //商户状态
|
||
merchantsModel.STAFF_ID = _MERCHANTS.STAFF_ID; //操作员内码
|
||
merchantsModel.STAFF_NAME = _MERCHANTS.STAFF_NAME; //操作人员
|
||
merchantsModel.OPERATE_DATE = _MERCHANTS.OPERATE_DATE; //操作时间
|
||
merchantsModel.MERCHANTS_DESC = _MERCHANTS.MERCHANTS_DESC; //备注
|
||
}
|
||
|
||
return merchantsModel;
|
||
}
|
||
#endregion
|
||
|
||
#region 同步商户信息表
|
||
public static bool SynchroMERCHANTS(Transaction transaction, Model.MERCHANTSModel merchantsModel)
|
||
{
|
||
bool SynchroFlag = true;
|
||
|
||
Business.MERCHANTS _MERCHANTS = new Business.MERCHANTS(transaction);
|
||
if (merchantsModel.MERCHANTS_ID != null)
|
||
{
|
||
_MERCHANTS.MERCHANTS_ID = merchantsModel.MERCHANTS_ID;
|
||
if (_MERCHANTS.Select())
|
||
{
|
||
SynchroModelToObject(_MERCHANTS, merchantsModel);
|
||
_MERCHANTS.Update();
|
||
}
|
||
else
|
||
{
|
||
SynchroFlag = false;
|
||
}
|
||
}
|
||
else
|
||
{
|
||
SynchroModelToObject(_MERCHANTS, merchantsModel);
|
||
_MERCHANTS.Insert();
|
||
}
|
||
|
||
return SynchroFlag;
|
||
}
|
||
|
||
#region 赋值商户信息表数据对象
|
||
/// <summary>
|
||
/// 赋值商户信息表数据对象
|
||
/// </summary>
|
||
/// <param name="_MERCHANTS"></param>
|
||
/// <param name="merchantsModel"></param>
|
||
public static void SynchroModelToObject(Business.MERCHANTS _MERCHANTS, Model.MERCHANTSModel merchantsModel)
|
||
{
|
||
_MERCHANTS.PROVINCE_CODE = merchantsModel.PROVINCE_CODE; //省份编码
|
||
_MERCHANTS.SERVERPART_ID = merchantsModel.SERVERPART_ID; //商户分类（1000：经营类）
|
||
_MERCHANTS.MERCHANTS_CATEGORY = merchantsModel.MERCHANTS_CATEGORY; //商户分类（1000：经营类）
|
||
_MERCHANTS.MERCHANTS_TYPE = merchantsModel.MERCHANTS_TYPE; //商户类型
|
||
_MERCHANTS.MERCHANTS_NATURE = merchantsModel.MERCHANTS_NATURE; //商户性质
|
||
_MERCHANTS.MERCHANTS_CODE = merchantsModel.MERCHANTS_CODE; //商户编码
|
||
_MERCHANTS.MERCHANTS_NAME = merchantsModel.MERCHANTS_NAME; //商户名称
|
||
_MERCHANTS.MERCHANTS_EN = merchantsModel.MERCHANTS_EN; //商户简称
|
||
_MERCHANTS.TAXPAYER_IDENTIFYCODE = merchantsModel.TAXPAYER_IDENTIFYCODE; //纳税人识别号
|
||
_MERCHANTS.MERCHANTS_DRAWER = merchantsModel.MERCHANTS_DRAWER; //商户开票人
|
||
_MERCHANTS.MERCHANTS_FAX = merchantsModel.MERCHANTS_FAX; //商户传真
|
||
_MERCHANTS.MERCHANTS_EMAIL = merchantsModel.MERCHANTS_EMAIL; //商户邮箱
|
||
_MERCHANTS.MERCHANTS_ADDRESS = merchantsModel.MERCHANTS_ADDRESS; //单位地址
|
||
_MERCHANTS.MERCHANTS_STATE = merchantsModel.MERCHANTS_STATE; //商户状态
|
||
_MERCHANTS.MERCHANTS_MOBILEPHONE = merchantsModel.MERCHANTS_MOBILEPHONE; //手机号码
|
||
_MERCHANTS.MERCHANTS_LINKMAN = merchantsModel.MERCHANTS_LINKMAN; //商户联系人
|
||
_MERCHANTS.MERCHANTS_TELEPHONE = merchantsModel.MERCHANTS_TELEPHONE; //联系电话
|
||
_MERCHANTS.BANK_ACCOUNT = merchantsModel.BANK_ACCOUNT; //银行账号
|
||
_MERCHANTS.BANK_NAME = merchantsModel.BANK_NAME; //开户行
|
||
_MERCHANTS.STAFF_ID = merchantsModel.STAFF_ID; //操作员内码
|
||
_MERCHANTS.STAFF_NAME = merchantsModel.STAFF_NAME; //操作人员
|
||
_MERCHANTS.OPERATE_DATE = merchantsModel.OPERATE_DATE; //操作时间
|
||
_MERCHANTS.MERCHANTS_DESC = merchantsModel.MERCHANTS_DESC; //备注
|
||
}
|
||
#endregion
|
||
|
||
#endregion
|
||
|
||
#region 删除商户信息表
|
||
public static bool DeleteMERCHANTS(Transaction transaction, int MERCHANTSId)
|
||
{
|
||
bool DeleteFlag = false;
|
||
|
||
if (MERCHANTSId != null)
|
||
{
|
||
Business.MERCHANTS _MERCHANTS = new Business.MERCHANTS(transaction);
|
||
_MERCHANTS.MERCHANTS_ID = MERCHANTSId;
|
||
if (_MERCHANTS.Select())
|
||
{
|
||
_MERCHANTS.Delete();
|
||
DeleteFlag = true;
|
||
}
|
||
}
|
||
|
||
return DeleteFlag;
|
||
}
|
||
#endregion
|
||
}
|
||
}
|