/// <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()); }