public static Decimal GetUserPayRate(UserInfo userInfo, int userId, int typeId)
{
BLL.User.usersetting _bll = new viviapi.BLL.User.usersetting();
Model.User.usersettingInfo _setting = _bll.GetModel(userId);
if (_setting != null)
{
if (_setting.special == 1)
{
string payrate = _setting.payrate;
if (!string.IsNullOrEmpty(payrate))
{
string[] arr = payrate.Split('|');
foreach (string item in arr)
{
string[] arr1 = item.Split(':');
if (arr1[0] == typeId.ToString())
{
return(Convert.ToDecimal(arr1[1]));
}
}
}
}
}
//商家费率
RateTypeEnum rateType = RateTypeEnum.Member;
if (userInfo.UserType == UserTypeEnum.代理)
{
rateType = viviapi.Model.Payment.RateTypeEnum.Agent;
}
return(BLL.Payment.PayRateFactory.GetPayRate(rateType, (int)userInfo.UserLevel, typeId));
}
/// <summary>
/// 取得
/// </summary>
/// <param name="rateType"></param>
/// <param name="lev"></param>
/// <param name="paytype"></param>
/// <returns></returns>
public static decimal GetPayRate(RateTypeEnum rateType, int lev, int paytype)
{
try
{
decimal rate = 0;
DataTable data = GetList(rateType, lev);
if (data == null && data.Rows.Count < 1)
{
return(rate);
}
DataRow[] dr = data.Select("userLevel=" + lev.ToString() + " and rateType=" + ((int)rateType).ToString());
if (dr == null || dr.Length <= 0)
{
return(0M);
}
return(Convert.ToDecimal(dr[0]["p" + paytype.ToString()]));
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(0);
}
}
/// <summary>
///
/// </summary>
/// <param name="rateType"></param>
/// <param name="lev"></param>
/// <returns></returns>
public static DataTable GetList(RateTypeEnum rateType, int lev)
{
try
{
string cacheKey = string.Format(PAYRATEFACTORY_CACHEKEY, (int)rateType, lev);
DataSet ds = new DataSet();
ds = (DataSet)viviapi.Cache.WebCache.GetCacheService().RetrieveObject(cacheKey);
if (ds == null)
{
IDictionary <string, object> sqldepparms = new Dictionary <string, object>();
sqldepparms.Add("rateType", (int)rateType);
sqldepparms.Add("userLevel", lev);
SqlDependency sqlDep = DataBase.AddSqlDependency(cacheKey, SQL_TABLE, SQL_TABLE_FIELD, "[rateType]=@rateType and userLevel=@userLevel", sqldepparms);
string sql = @"select [id],[rateType],[userLevel],[levName],[p100]
,[p101]
,[p102]
,[p103]
,[p104]
,[p105]
,[p106]
,[p107]
,[p108]
,[p109]
,[p110]
,[p111]
,[p112]
,[p113]
,[p114]
,[p115]
,[p116]
,[p117]
,[p118]
,[p119]
,[p300]
,[p200]
,[p201]
,[p202]
,[p203]
,[p204]
,[p205]
,[p206]
,[p207]
,[p208]
,[p209]
,[p210] from [payrate]";
ds = DataBase.ExecuteDataset(CommandType.Text, sql);
viviapi.Cache.WebCache.GetCacheService().AddObject(cacheKey, ds);
}
return(ds.Tables[0]);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(null);
}
}
/// <summary>
/// Initializes a new instance of the <see cref="OBWriteInternational2DataInitiationExchangeRateInformation" /> class.
/// </summary>
/// <param name="unitCurrency">Currency in which the rate of exchange is expressed in a currency exchange. In the example 1GBP = xxxCUR, the unit currency is GBP. (required).</param>
/// <param name="exchangeRate">The factor used for conversion of an amount from one currency to another. This reflects the price at which one currency was bought with another currency..</param>
/// <param name="rateType">Specifies the type used to complete the currency exchange. (required).</param>
/// <param name="contractIdentification">Unique and unambiguous reference to the foreign exchange contract agreed between the initiating party/creditor and the debtor agent..</param>
public OBWriteInternational2DataInitiationExchangeRateInformation(string unitCurrency = default(string), decimal exchangeRate = default(decimal), RateTypeEnum rateType = default(RateTypeEnum), string contractIdentification = default(string))
{
// to ensure "unitCurrency" is required (not null)
this.UnitCurrency = unitCurrency ?? throw new ArgumentNullException("unitCurrency is a required property for OBWriteInternational2DataInitiationExchangeRateInformation and cannot be null");
this.RateType = rateType;
this.ExchangeRate = exchangeRate;
this.ContractIdentification = contractIdentification;
}
public CurrencyRate GetCurrencyRate(string year, string reviewCode, RateTypeEnum rateType, string currencyCode)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.CurrencyRateSet
where a.Year == year && a.ReviewCode == reviewCode && a.RateType == rateType && a.CurrencyCode == currencyCode
select a;
return(query.FirstOrDefault());
}
}
public static DataTable GetLevName(RateTypeEnum rateType)
{
string sql = "SELECT id,userLevel,levName FROM payrate WHERE rateType = @rateType";
SqlParameter[] parameters =
{
new SqlParameter("@rateType", SqlDbType.TinyInt, 1)
};
parameters[0].Value = (int)rateType;
return(DataBase.ExecuteDataset(CommandType.Text, sql, parameters).Tables[0]);
}
public string add_Rate(string tenor, double rate, RateTypeEnum rateType = RateTypeEnum.Spot)
{
try
{
#region CheckParameter
// 이건 나중에 수정해야함. yield 음수의 경우 yieldcurve class 를 새로 만들어야함. quantlib을 사용안해야함.
if (!(rate > 0))
{
throw new Exception("rate must be positive");
}
#endregion
if (this.Excel_yieldCurveViewModel_.hasTenor(tenor))
{
return(tenor + " is aleady exist");
}
else
{
Excel_rateDataViewModel e_rdvm = new Excel_rateDataViewModel();
e_rdvm.RateType_ = rateType.ToString();
e_rdvm.Tenor_ = tenor;
e_rdvm.Value_ = rate.ToString();
this.Excel_yieldCurveViewModel_.Excel_rateDataViewModel_.Add(e_rdvm);
return("add complete");
}
}
catch (Exception e)
{
return("add fail : " + e.Message);
}
}
public IEnumerable <CurrencyRate> GetCurrencyRates(string year, string reviewCode, RateTypeEnum rateType)
{
using (BudgetContext entityContext = new BudgetContext())
{
var query = from a in entityContext.CurrencyRateSet
where a.Year == year && a.ReviewCode == reviewCode && a.RateType == rateType
select a;
return(query.ToFullyLoaded());
}
}
public string add_Rate(string tenor, double rate, RateTypeEnum rateType = RateTypeEnum.Spot)
{
try
{
#region CheckParameter
// 이건 나중에 수정해야함. yield 음수의 경우 yieldcurve class 를 새로 만들어야함. quantlib을 사용안해야함.
if ( !(rate > 0) )
throw new Exception("rate must be positive");
#endregion
if ( this.Excel_yieldCurveViewModel_.hasTenor(tenor) )
{
return tenor + " is aleady exist";
}
else
{
Excel_rateDataViewModel e_rdvm = new Excel_rateDataViewModel();
e_rdvm.RateType_ = rateType.ToString();
e_rdvm.Tenor_ = tenor;
e_rdvm.Value_ = rate.ToString();
this.Excel_yieldCurveViewModel_.Excel_rateDataViewModel_.Add(e_rdvm);
return "add complete";
}
}
catch (Exception e)
{
return "add fail : " + e.Message;
}
}
public CurrencyRate[] GetCurrencyRates(string year, string reviewCode, RateTypeEnum rateType)
{
return(Channel.GetCurrencyRates(year, reviewCode, rateType));
}
public CurrencyRate GetCurrencyRateByCode(string year, string reviewCode, RateTypeEnum rateType, string currencyCode)
{
return(Channel.GetCurrencyRateByCode(year, reviewCode, rateType, currencyCode));
}
