public string CheckCustomerCreditInfo(int id)
{
string isSuccess = "0";
try
{
var model = _customerService.GetCustomerCreditInfo(id);
if (model != null && model.Amount.HasValue && model.Status == CustomerCreditInfo.StatusToValue(CustomerCreditInfo.StatusEnum.NoCheck))
{
var param = new CustomerAmountRecordParam()
{
Amount = model.Amount.Value,
CustomerCode = model.CustomerCode,
MoneyChangeTypeId = 1,
Remark = model.Remark,
FeeTypeId = 1,
TransactionNo = model.TransactionNo
};
if (_customerService.CreateCustomerAmountRecord(param) == 1)
{
_customerService.VerifyCustomerCreditInfo(id, CustomerCreditInfo.StatusEnum.Checked);
}
isSuccess = "1";
}
}
catch (Exception ex)
{
Log.Exception(ex);
isSuccess = ex.Message;
}
return(isSuccess);
}
public int CreateCustomerAmountRecord(CustomerAmountRecordParam param)
{
var ctx = this.UnitOfWork as LMS_DbContext;
Check.Argument.IsNotNull(ctx, "数据库对象");
int isSuccess = 0;
var CustomerCode = new SqlParameter {
ParameterName = "customerCode", Value = param.CustomerCode, DbType = DbType.String
};
var WayBillNumber = new SqlParameter {
ParameterName = "wayBillNumber", Value = param.WayBillNumber ?? "", DbType = DbType.String
};
var TransactionNo = new SqlParameter {
ParameterName = "transactionNo", Value = param.TransactionNo ?? "", DbType = DbType.String
};
var MoneyChangeTypeId = new SqlParameter {
ParameterName = "moneyChangeTypeID", Value = param.MoneyChangeTypeId, DbType = DbType.Int32
};
var FeeTypeID = new SqlParameter {
ParameterName = "feeTypeID", Value = param.FeeTypeId, DbType = DbType.Int32
};
var Amount = new SqlParameter {
ParameterName = "amount", Value = param.Amount, DbType = DbType.Decimal
};
var Remark = new SqlParameter {
ParameterName = "remark", Value = param.Remark ?? "", DbType = DbType.String
};
var CreatedBy = new SqlParameter {
ParameterName = "createdBy", Value = param.CreatedBy, DbType = DbType.String
};
var isReturn = new SqlParameter {
ParameterName = "isReturn", Value = 0, DbType = DbType.Int32, Direction = ParameterDirection.Output
};
if (ctx != null)
{
ctx.ExecuteCommand(
"Exec P_CustomerAmountRecord @customerCode,@wayBillNumber,@transactionNo,@moneyChangeTypeID,@feeTypeID,@amount,@remark,@createdBy,@isReturn output",
CustomerCode, WayBillNumber, TransactionNo, MoneyChangeTypeId, FeeTypeID, Amount, Remark, CreatedBy, isReturn);
Int32.TryParse(isReturn.Value.ToString(), out isSuccess);
}
return(isSuccess);
}
public string CreateCustomerRecharge(CustomerRechargeModel model)
{
string isSuccess = "0";
if (model != null)
{
var param = new CustomerAmountRecordParam()
{
Amount = model.Amount,
CustomerCode = model.CustomerCode,
MoneyChangeTypeId = model.MoneyChangeTypeID,
Remark = model.Remark,
FeeTypeId = model.FeeTypeID
};
switch (Customer.ParseToNumberType(model.SelectNumberTypeID))
{
case Customer.NumberTypeEnum.TransactionNo:
param.TransactionNo = model.NumberValue;
break;
case Customer.NumberTypeEnum.WayBill:
param.WayBillNumber = model.NumberValue;
break;
}
try
{
isSuccess = _customerService.CreateCustomerAmountRecord(param).ToString();
}
catch (Exception ex)
{
Log.Exception(ex);
isSuccess = ex.Message;
}
}
return(isSuccess);
}
public JsonResult SaveCheckStand(FormCollection form)
{
var param = new CustomerCreditInfo()
{
CustomerCode = form["CustomerCode"],
Amount = Convert.ToDecimal(form["Amount"]),
RechargeType = Convert.ToInt32(form["RechargeType"]),
TransactionNo = form["TransactionNo"],
Remark = form["Remark"],
VoucherPath = form["flUploadAddress"],
CreatedOn = DateTime.Now,
CreatedBy = _workContext.User.UserUame,
LastUpdatedOn = DateTime.Now,
LastUpdatedBy = _workContext.User.UserUame,
Status = 2
};
var settlementList = form["SettlementList"];
var balance = Convert.ToDecimal(form["Balance"]);
var result = "0";
try
{
using (var tran = new TransactionScope())
{
_billingService.CreateRechargeRecord(param);
var amountrecord = new CustomerAmountRecordParam()
{
Amount = param.Amount.Value,
CustomerCode = param.CustomerCode,
MoneyChangeTypeId = 1,
Remark = param.Remark,
FeeTypeId = 1,
TransactionNo = param.TransactionNo
};
if (amountrecord.Amount == 0)
{
if (!string.IsNullOrWhiteSpace(settlementList) && balance >= 0)
{
_settlementService.CheckOkSettlement(settlementList.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToList());
result = "1";
}
}
else
{
if (_customerService.CreateCustomerAmountRecord(amountrecord) == 1)
{
if (!string.IsNullOrWhiteSpace(settlementList) && balance + param.Amount >= 0)
{
_settlementService.CheckOkSettlement(
settlementList.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries)
.ToList());
}
result = "1";
}
else
{
throw new Exception("现结收款充值失败！");
}
}
tran.Complete();
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
return(Json(new { Result = result }, JsonRequestBehavior.DenyGet));
}
public int CreateCustomerAmountRecord(CustomerAmountRecordParam param)
{
param.CreatedBy = _workContext.User != null?_workContext.User.UserUame:"";
return(_customerAmountRecordRepository.CreateCustomerAmountRecord(param));
}
