/// <summary>
/// 根据协议编号查询余额
/// </summary>
public decimal selectYEByXybh(string xybh)
{
try
{
return(SqlMap.QueryForObject <decimal>("selectYEByXybh", xybh));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据协议获取账户余额
/// </summary>
/// <param name="XYBH">协议编号</param>
/// <returns>账户余额</returns>
public int GetAccountMoney(string XYBH)
{
object o = SqlMap.QueryForObject("GetAccountMoney", XYBH);
return(o == null?0:(int)o);
}
/// <summary>
/// 获取协议利息总额
/// </summary>
/// <param name="protocolNo"></param>
/// <returns></returns>
public static decimal InterestInquire(string protocolNo)
{
return(decimal.Parse(SqlMap.QueryForObject("SelectInterestSum", protocolNo).ToString()));
}
/// <summary>
/// 2013-07-26
/// 查询班级实体
/// </summary>
/// <param name="calsses_id">班级编号</param>
/// <returns>班级实体</returns>
public Calsses GetClassesByid(int calsses_id)
{
return((Calsses)SqlMap.QueryForObject("SelectByClassesId", calsses_id));
}
public Person GetPerson(int Id)
{
return(SqlMap.QueryForObject <Person>("", Id));
}
public static object GetSerialNo()
{
return(SqlMap.QueryForObject("GetSerialNo", null));
}
public static string GetErrorSerialNo()
{
return(SqlMap.QueryForObject <string>("JG_GetErrorSerialNo", null));
}