/// <summary>
/// 根据出生日期计算精确年龄
/// </summary>
/// <param name="dt_birth"></param>
/// <returns></returns>
public static int Calc_Age_Via_Birth(string dt_birth)
{
//出生日期
OracleParameter op_birth = new OracleParameter("ic_birth", OracleDbType.Varchar2, 10);
op_birth.Direction = ParameterDirection.Input;
op_birth.Value = dt_birth;
return(Convert.ToInt32(SqlAssist.ExecuteFunction("pkg_report.fun_Calc_Age", new OracleParameter[] { op_birth }).ToString()));
}
/// <summary>
/// 映射服务商品
/// </summary>
/// <param name="itemId"></param>
/// <returns></returns>
public static string Mapper_item(string itemId)
{
OracleParameter op_itemId = new OracleParameter("ic_itemId", OracleDbType.Varchar2, 10);
op_itemId.Direction = ParameterDirection.Input;
op_itemId.Value = itemId;
Object re = SqlAssist.ExecuteFunction("pkg_report.fun_mapper_item", new OracleParameter[] { op_itemId });
return(re.ToString());
}
/// <summary>
/// 判断火化业务是否结算 1-结算 0-未结算
/// </summary>
/// <param name="ac001"></param>
/// <returns></returns>
public static string FireIsSettled(string ac001)
{
OracleParameter op_ac001 = new OracleParameter("ic_ac001", OracleDbType.Varchar2, 10);
op_ac001.Direction = ParameterDirection.Input;
op_ac001.Value = ac001;
Object re = SqlAssist.ExecuteFunction("pkg_business.fun_FireIsSettled", new OracleParameter[] { op_ac001 });
return(re.ToString());
}
public static string Mapper_mx(string mx)
{
OracleParameter op_mx = new OracleParameter("ic_mx", OracleDbType.Varchar2, 10);
op_mx.Direction = ParameterDirection.Input;
op_mx.Value = mx;
Object re = SqlAssist.ExecuteFunction("pkg_report.fun_mapper_mx", new OracleParameter[] { op_mx });
return(re.ToString());
}
/// <summary>
/// 获取收费业务已开发票数
/// </summary>
/// <param name="fa001"></param>
/// <returns></returns>
public static int GetHaveInvoicePapers(string fa001)
{
OracleParameter op_fa001 = new OracleParameter("ic_fa001", OracleDbType.Varchar2, 10);
op_fa001.Direction = ParameterDirection.Input;
op_fa001.Value = fa001;
Object re = SqlAssist.ExecuteFunction("pkg_report.fun_getHaveInvoicePapers", new OracleParameter[] { op_fa001 });
return(Convert.ToInt32(re.ToString()));
}
/// <summary>
/// 获取墓区排数
/// </summary>
/// <param name="regionId"></param>
/// <returns></returns>
public static int GetRowerCount(string regionId)
{
OracleParameter op_regionId = new OracleParameter("ic_regionId", OracleDbType.Varchar2, 10);
op_regionId.Direction = ParameterDirection.Input;
op_regionId.Value = regionId;
Object re = SqlAssist.ExecuteFunction("pkg_report.fun_getRowerCount", new OracleParameter[] { op_regionId });
return(Convert.ToInt32(re.ToString()));
}
/// <summary>
/// 获取墓位位置
/// </summary>
/// <param name="bi001"></param>
/// <returns></returns>
public static string GetTombPosition(string bi001)
{
OracleParameter op_bi001 = new OracleParameter("ic_bi001", OracleDbType.Varchar2, 10);
op_bi001.Direction = ParameterDirection.Input;
op_bi001.Value = bi001;
Object re = SqlAssist.ExecuteFunction("pkg_business.fun_GetTombPosition", new OracleParameter[] { op_bi001 });
return(re.ToString());
}
/// <summary>
/// 获取系统参数1
/// </summary>
/// <param name="propId"></param>
/// <returns></returns>
public static decimal GetSysParaValue1(string propId)
{
OracleParameter op_propId = new OracleParameter("ic_propId", OracleDbType.Varchar2, 50);
op_propId.Direction = ParameterDirection.Input;
op_propId.Value = propId;
Object re = SqlAssist.ExecuteFunction("pkg_business.fun_GetSysParaValue1", new OracleParameter[] { op_propId });
return(Convert.ToDecimal(re.ToString()));
}
/// <summary>
/// 计算 迁出差异天数
/// </summary>
/// <param name="rc001"></param>
/// <returns></returns>
public static int CalcOutDiffDays(string rc001)
{
OracleParameter op_rc001 = new OracleParameter("ic_rc001", OracleDbType.Varchar2, 10);
op_rc001.Direction = ParameterDirection.Input;
op_rc001.Value = rc001;
Object re = SqlAssist.ExecuteFunction("pkg_business.fun_CalcOutDiffDays", new OracleParameter[] { op_rc001 });
return(Convert.ToInt32(re.ToString()));
}
/// <summary>
/// 生成 寄存证号
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public static string GenRegisterNo(string type)
{
OracleParameter op_type = new OracleParameter("ic_type", OracleDbType.Varchar2, 3);
op_type.Direction = ParameterDirection.Input;
op_type.Value = type;
Object re = SqlAssist.ExecuteFunction("pkg_business.GenRegisterNo", new OracleParameter[] { op_type });
return(re.ToString());
}
/// <summary>
/// 获取指定结算流水号的缴费打印数据
/// </summary>
/// <param name="fa001"></param>
/// <returns></returns>
public static string GetPayRecordPrintData(string fa001)
{
OracleParameter op_fa001 = new OracleParameter("ic_fa001", OracleDbType.Varchar2, 10);
op_fa001.Direction = ParameterDirection.Input;
op_fa001.Value = fa001;
Object re = SqlAssist.ExecuteFunction("pkg_report.fun_GetPayRecordPrintData", new OracleParameter[] { op_fa001 });
return(re.ToString());
}
/// <summary>
/// 生成火化序号
/// </summary>
/// <param name="hhl_type"></param>
/// <returns></returns>
public static int GenFireOrder(string hhl_type)
{
OracleParameter op_hhl = new OracleParameter("ic_hhl", OracleDbType.Varchar2, 3);
op_hhl.Direction = ParameterDirection.Input;
op_hhl.Value = hhl_type;
Object re = SqlAssist.ExecuteFunction("pkg_business.fun_GenFireOrder", new OracleParameter[] { op_hhl });
return(int.Parse(re.ToString()));
}
/// <summary>
/// 财务综合统计-金额
/// </summary>
/// <param name="sbegin"></param>
/// <param name="send"></param>
/// <returns></returns>
public static decimal FinStat_je(string sbegin, string send)
{
OracleParameter op_begin = new OracleParameter("ic_begin", OracleDbType.Varchar2, 10);
op_begin.Direction = ParameterDirection.Input;
op_begin.Value = sbegin;
OracleParameter op_end = new OracleParameter("ic_end", OracleDbType.Varchar2, 10);
op_end.Direction = ParameterDirection.Input;
op_end.Value = send;
;
Object re = SqlAssist.ExecuteFunction("pkg_report.fun_finstat_je", new OracleParameter[] { op_begin, op_end });
return(Convert.ToDecimal(re.ToString()));
}
/// <summary>
/// 获取指定顺序号的缴费打印数据
/// </summary>
/// <param name="ac001"></param>
/// <param name="iorder"></param>
/// <returns></returns>
public static string GetPayRecordPrintData(string ac001, int iorder)
{
OracleParameter op_ac001 = new OracleParameter("ic_ac001", OracleDbType.Varchar2, 10);
op_ac001.Direction = ParameterDirection.Input;
op_ac001.Value = ac001;
OracleParameter op_order = new OracleParameter("in_order", OracleDbType.Int32);
op_order.Direction = ParameterDirection.Input;
op_order.Value = iorder;
Object re = SqlAssist.ExecuteFunction("pkg_report.fun_GetPayRecordPrintData", new OracleParameter[] { op_ac001, op_order });
return(re.ToString());
}
/// <summary>
/// 根据排号和号位描述返回墓位号
/// </summary>
/// <param name="rowerId"></param>
/// <param name="bitdesc"></param>
/// <returns></returns>
public static string GetTombId(string rowerId, string bitdesc)
{
OracleParameter op_rowerId = new OracleParameter("ic_rowerId", OracleDbType.Varchar2, 10);
op_rowerId.Direction = ParameterDirection.Input;
op_rowerId.Value = rowerId;
OracleParameter op_bitdesc = new OracleParameter("ic_bitDesc", OracleDbType.Varchar2, 50);
op_bitdesc.Direction = ParameterDirection.Input;
op_bitdesc.Value = bitdesc;
Object re = SqlAssist.ExecuteFunction("pkg_business.fun_GetTombID", new OracleParameter[] { op_rowerId, op_bitdesc });
return(re.ToString());
}
/// <summary>
/// 指示逝者是否具有身份证信息
/// </summary>
/// <param name="ac001"></param>
/// <returns></returns>
public static bool HasIDC(string ac001)
{
//逝者编号
OracleParameter op_ac001 = new OracleParameter("ic_ac001", OracleDbType.Varchar2, 10);
op_ac001.Direction = ParameterDirection.Input;
op_ac001.Value = ac001;
object result = SqlAssist.ExecuteFunction("pkg_report.fun_HasIDC", new OracleParameter[] { op_ac001 });
if (Convert.ToInt32(result.ToString()) >= 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 判断工作站是否注册登记
/// </summary>
/// <param name="ws001"></param>
/// <param name="ws005"></param>
/// <param name="ws007"></param>
/// <returns></returns>
public static int WorkStationIsRegistered(string ws001, string ws005, string ws007)
{
//工作站编号
OracleParameter op_ws001 = new OracleParameter("ic_workStationId", OracleDbType.Varchar2, 10);
op_ws001.Direction = ParameterDirection.Input;
op_ws001.Value = ws001;
//工作站计算机名称
OracleParameter op_ws005 = new OracleParameter("ic_hostname", OracleDbType.Varchar2, 50);
op_ws005.Direction = ParameterDirection.Input;
op_ws005.Value = ws005;
//工作站ip地址
OracleParameter op_ws007 = new OracleParameter("ic_ipaddress", OracleDbType.Varchar2, 50);
op_ws007.Direction = ParameterDirection.Input;
op_ws007.Value = ws007;
return(Convert.ToInt32(SqlAssist.ExecuteFunction("pkg_business.fun_workStationIsRegistered", new OracleParameter[] { op_ws001, op_ws005, op_ws007 }).ToString()));
}
/// <summary>
/// 根据墓位 号位文字描述+排序号 返回墓位编号
/// </summary>
/// <param name="rg001"></param>
/// <param name="bi003"></param>
/// <param name="rowerOrder"></param>
/// <returns></returns>
public static string GetBi001ByBitdescRowOrder(string rg001, string bi003, int rowerOrder)
{
OracleParameter op_rg001 = new OracleParameter("ic_rg001", OracleDbType.Varchar2, 10);
op_rg001.Direction = ParameterDirection.Input;
op_rg001.Value = rg001;
OracleParameter op_bi003 = new OracleParameter("ic_bi003", OracleDbType.Varchar2, 50);
op_bi003.Direction = ParameterDirection.Input;
op_bi003.Value = bi003;
OracleParameter op_order = new OracleParameter("in_roworder", OracleDbType.Int32);
op_order.Direction = ParameterDirection.Input;
op_order.Value = rowerOrder;
Object re = SqlAssist.ExecuteFunction("pkg_business.fun_GetBi001ByBitdescRowOrder", new OracleParameter[] { op_rg001, op_bi003, op_order });
return(re.ToString());
}
