public UserFinanceListVo selectListUserFinanceVo(UserFinanceVo userFinanceVo)
{
UserFinanceListVo userFinanceListVo = new UserFinanceListVo();
using (FCdbFacade fcdbFacade = new FCdbFacade())
{
userFinanceListVo = fcdbFacade.selectListUserFinanceVo(userFinanceVo);
}
return(userFinanceListVo);
}
/// <summary>
/// 사용자재무ListVo조회
/// </summary>
/// <param name="userFinanceVo">사용자재무Vo</param>
/// <returns>사용자재무ListVo</returns>
public UserFinanceListVo selectListUserFinanceVo(UserFinanceVo userFinanceVo)
{
UserFinanceListVo userFinanceListVo = new UserFinanceListVo();
using (UserFinanceService userFinanceService = new UserFinanceService())
{
userFinanceListVo = userFinanceService.selectListUserFinanceVo(userFinanceVo);
}
return(userFinanceListVo);
}
/// <summary>
/// 사용자재무Vo수정
/// </summary>
/// <param name="userFamilyVo">사용자재무Vo</param>
public void updateUserFinanceVo(UserFinanceVo userFinanceVo)
{
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_FINANCE_UPDATE";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@USER_ID", userFinanceVo.userFinance.userId));
sqlParameters.Add(new SqlParameter("@USER_FINANCE_CATALOG_ID", userFinanceVo.userFinance.userFinanceCatalogId));
sqlParameters.Add(new SqlParameter("@PRICE", userFinanceVo.userFinance.price));
sqlCommon.ExecuteProcedure(procedureName, sqlParameters);
}
}
/// <summary>
/// 사용자재무ListVo조회
/// </summary>
/// <param name="userFinanceVo">사용자재무Vo</param>
/// <returns>사용자재무ListVo</returns>
public UserFinanceListVo selectListUserFinanceVo(UserFinanceVo userFinanceVo)
{
UserFinanceListVo userFinanceListVo = new UserFinanceListVo();
try
{
using (UserFinanceDao userFinanceDao = new UserFinanceDao())
{
userFinanceListVo.userFinanceVoList = userFinanceDao.selectListUserFinanceVo(userFinanceVo);
}
}
catch (Exception e)
{
userFinanceListVo.commonAttr.execSuccess = false;
userFinanceListVo.commonAttr.exceptionMessage = e.Message;
}
return(userFinanceListVo);
}
/// <summary>
/// 사용자재무VoList조회
/// </summary>
/// <param name="userFinanceVo">사용자재무Vo</param>
/// <returns>사용자재무Vo</returns>
public List <UserFinanceVo> selectListUserFinanceVo(UserFinanceVo userFinanceVo)
{
List <UserFinanceVo> userFinanceVoList = new List <UserFinanceVo>();
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_FINANCE_LIST";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@USER_ID", userFinanceVo.userFinance.userId));
DataSet ds = sqlCommon.ExecuteProcedure(procedureName, sqlParameters);
if ((ds != null) &&
(ds.Tables != null) && (ds.Tables[0] != null) &&
(ds.Tables[0].Rows.Count > 0) && (ds.Tables[0].Rows[0] != null))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
UserFinanceVo userFinanceVoResult = new UserFinanceVo();
userFinanceVoResult.userFinance.userId = dr["USER_ID"].ToString();
userFinanceVoResult.userFinance.userFinanceCatalogId = dr["USER_FINANCE_CATALOG_ID"].ToString();
userFinanceVoResult.userFinanceCatalog.userFinanceCatalogId = dr["USER_FINANCE_CATALOG_ID"].ToString();
userFinanceVoResult.userFinanceCatalog.userFinanceCatalogNm = dr["USER_FINANCE_CATALOG_NM"].ToString();
userFinanceVoResult.userFinanceCatalog.userFinanceCatalogSubgroupNo = int.Parse(dr["USER_FINANCE_CATALOG_SUBGROUP_NO"].ToString());
userFinanceVoResult.userFinance.price = int.Parse(dr["PRICE"].ToString());
userFinanceVoList.Add(userFinanceVoResult);
}
}
}
return(userFinanceVoList);
}
