/// <summary>
/// 电商平台选择
/// 作者:姚栋
/// 日期:20180625
/// </summary>
/// <param name="login_name">当前用户登录名</param>
/// <param name="currency_code">币种编码</param>
/// <param name="electricity_supplier_name">电商名称</param>
/// <param name="electricity_supplier_ad">电商简称</param>
/// <param name="electricity_supplier_code">电商编码</param>
/// <param name="available_balance_begin">可用余额(范围-开始)</param>
/// <param name="available_balance_end">可用余额(范围-结束)</param>
/// <param name="project_code">项目编码</param>
/// <param name="project_name">项目名称</param>
public OutOnlieModel GetOnLineMallList(string login_name, Pagination pagination, string currency_code = "CNY",
string electricity_supplier_name = null,
string electricity_supplier_ad = null,
string electricity_supplier_code = null,
decimal?available_balance_begin = 0,
decimal?available_balance_end = 0,
string project_code = null,
string project_name = null)
{
//验证登录用户是否存在
var userModel = userBll.CheckLogin(login_name);
if (userModel == null)
{
throw new Exception("当前用户信息不存在!");
}
OutOnlieModel result = new OutOnlieModel();
StringBuilder strSql = new StringBuilder();
strSql.Append(@"
select epr.EcommerceID as electricity_supplier_id,
er.EcommerceName as electricity_supplier_name,
er.EcommerceCode as electricity_supplier_code,
epr.EcommerceGroupID as electricity_supplier_ab_id,
ergroup.EcommerceGroupName as electricity_supplier_ad,
CONVERT(DECIMAL(18,2),ActualControlTotalAmount) as available_balance,
ProjectID as project_id,
ProjectID as projectid,
ProjectCode as project_code,
ProjecName as project_name,
'CNY' as currency_code
from dbo.T_EcommerceProjectRelation epr
inner join T_Ecommerce er on
epr.EcommerceID=er.EcommerceID
inner join t_ecommercegroup ergroup on
ergroup.EcommerceGroupID=epr.EcommerceGroupID
where epr.ApprovalState=@ApprovalState and epr.istrunk=1");
var parameter = new List <DbParameter>();
if (!string.IsNullOrEmpty(electricity_supplier_name))
{
strSql.AppendLine(" and er.EcommerceName like @EcommerceName ");
parameter.Add(DbParameters.CreateDbParameter("@EcommerceName", "%" + electricity_supplier_name + "%"));
}
if (!string.IsNullOrEmpty(electricity_supplier_ad))
{
strSql.AppendLine(" and ergroup.EcommerceGroupName like @EcommerceGroupName");
parameter.Add(DbParameters.CreateDbParameter("@EcommerceGroupName", "%" + electricity_supplier_ad + "%"));
}
if (!string.IsNullOrEmpty(electricity_supplier_code))
{
strSql.AppendLine(" and er.EcommerceCode like @EcommerceCode");
parameter.Add(DbParameters.CreateDbParameter("@EcommerceCode", "%" + electricity_supplier_code + "%"));
}
if (!string.IsNullOrEmpty(project_code))
{
strSql.AppendLine(" and epr.ProjectCode like @ProjectCode");
parameter.Add(DbParameters.CreateDbParameter("@ProjectCode", "%" + project_code + "%"));
}
if (!string.IsNullOrEmpty(project_name))
{
strSql.AppendLine(" and epr.ProjectName like @ProjectName");
parameter.Add(DbParameters.CreateDbParameter("@ProjectName", "%" + project_name + "%"));
}
if (available_balance_begin > 0)
{
strSql.AppendLine(" and epr.ActualControlTotalAmount >=@ActualControlTotalAmountBegin ");
parameter.Add(DbParameters.CreateDbParameter("@ActualControlTotalAmountBegin", available_balance_begin));
}
if (available_balance_end > 0)
{
strSql.AppendLine(" and epr.ActualControlTotalAmount <=@ActualControlTotalAmountEnd ");
parameter.Add(DbParameters.CreateDbParameter("@ActualControlTotalAmountEnd", available_balance_end));
}
parameter.Add(DbParameters.CreateDbParameter("@ApprovalState", (int)ApproveStatus.approved));
var plist = this.BaseRepository().FindList <OutOnineMall>(strSql.ToString(), parameter.ToArray()).ToList();
//var plist = new AuthorizeService<OutOnineMall>().FindList(strSql.ToString(), parameter.ToArray(),
// AuthorizeUserTypeEnum.LoginCode, SystemTypeEnum.WebApi, login_name, pagination);
result.datalist = plist;
result.pageInfo = new pageInfo()
{
total = pagination.total,
page = pagination.page,
records = pagination.records,
rows = pagination.rows,
};
return(result);
}
public async Task <Resp <OutOnlieModel> > GetSelect(
string login_name, string currency_code, int rows, int page)
{
string errMsg = string.Empty;
int reqState = 1;
Pagination pagination = new Pagination()
{
page = page,
rows = rows,
sidx = "project_code",
sord = "asc"
};
var electricity_supplier_name = RequestApi["electricity_supplier_name"];
var electricity_supplier_ad = RequestApi["electricity_supplier_ad"];
var electricity_supplier_code = RequestApi["electricity_supplier_code"];
var available_balance_begin = RequestApi["available_balance_begin"] == null ? 0 : Convert.ToDecimal(RequestApi["available_balance_begin"]);
var available_balance_end = RequestApi["available_balance_end"] == null ? 0 : Convert.ToDecimal(RequestApi["available_balance_end"]);
var project_code = RequestApi["project_code"];
var project_name = RequestApi["project_name"];
OutOnlieModel result = new OutOnlieModel();
try
{
if (string.IsNullOrEmpty(login_name))
{
reqState = 0;
errMsg = "登录信息缺失";
return(Resp.BusinessError <OutOnlieModel>(errMsg, result));
}
await Task.Run(() =>
{
result = ecommerceProjectBll.GetOnLineMallList(login_name, pagination, currency_code,
electricity_supplier_name,
electricity_supplier_ad,
electricity_supplier_code,
available_balance_begin,
available_balance_end,
project_code,
project_name);
});
return(Resp.Success(result));
}
catch (Exception ex)
{
return(Resp.BusinessError <OutOnlieModel>(ex.Message, result));
}
finally
{
string ResponseContent = reqState == 0 ? Resp.BusinessError <OutOnlieModel>(errMsg, result).ToJson()
: Resp.Success(result).ToJson();
LogBLL.WriteLogInterface("login_name:" + login_name
+ " currency_code:" + currency_code
+ " rows:" + rows
+ " page:" + page
+ " electricity_supplier_name:" + electricity_supplier_name
+ " electricity_supplier_ad:" + electricity_supplier_ad
+ " electricity_supplier_code:" + electricity_supplier_code
+ " available_balance_begin:" + available_balance_begin
+ " available_balance_end:" + available_balance_end
+ " project_code:" + project_code
+ " project_name:" + project_name,
ResponseContent, "电商平台选择",
reqState, "共享平台", "电商资金", errMsg);
}
}
