/// <summary> /// 调用f_workflow_getsql返回工作流sql /// </summary> /// <param name="ruleId"></param> /// <param name="objType"></param> /// <param name="objId"></param> /// <returns></returns> public string GetWorkflowSql(long ruleId, long objType, long objId) { using (IDbConnection conn = DapperHelper.BuildConnection()) { var p = new DynamicParameters(); string funcName = "f_workflow_getsql"; p.Add("in_rule_id", ruleId); p.Add("in_object", objType); p.Add("in_id", objId); p.Add("@sqlrtn", 0, DbType.String, ParameterDirection.ReturnValue); var result = conn.Query(funcName, p, null, true, null, CommandType.StoredProcedure).FirstOrDefault(); return(p.Get <string>("@sqlrtn")); } }
/// <summary> /// 执行p_rpt_getsql_count,获取查询总记录数 /// </summary> /// <param name="groupId"></param> /// <param name="type"></param> /// <param name="userId"></param> /// <param name="condition"></param> /// <returns></returns> public int GetQueryCount(long groupId, long type, long userId, string condition) { using (IDbConnection conn = DapperHelper.BuildConnection()) { var p = new DynamicParameters(); string funcName = "p_rpt_getsql_count"; p.Add("in_para_group_id", groupId); p.Add("in_type_id", type); p.Add("in_user_id", userId); p.Add("in_user_condition", condition); p.Add("@out_count", 0, DbType.Int32, ParameterDirection.Output); var result = conn.Query(funcName, p, null, true, null, CommandType.StoredProcedure).FirstOrDefault(); return(p.Get <int>("@out_count")); } }
/// <summary> /// 小窗口获取获取数据sql /// </summary> /// <param name="widgetId"></param> /// <param name="type"></param> /// <param name="userId"></param> /// <param name="filter"></param> /// <returns></returns> public string GetWidgetSql(long widgetId, int type, long userId, long?filter = null) { using (IDbConnection conn = DapperHelper.BuildConnection()) { var p = new DynamicParameters(); string funcName = "p_widget_getsql"; p.Add("in_widget", widgetId); p.Add("in_type", type); p.Add("in_user", userId); p.Add("in_tab_filer_value", filter); p.Add("@out_sql", 0, DbType.String, ParameterDirection.Output); var result = conn.Query(funcName, p, null, true, null, CommandType.StoredProcedure).FirstOrDefault(); return(p.Get <string>("@out_sql")); } }
/// <summary> /// 执行f_rpt_getsql,生成查询sql语句 /// </summary> /// <param name="groupId"></param> /// <param name="type"></param> /// <param name="userId"></param> /// <param name="condition"></param> /// <param name="orderBy"></param> /// <returns></returns> public string GetQuerySql(long groupId, long type, long userId, string condition, string orderBy) { using (IDbConnection conn = DapperHelper.BuildConnection()) { var p = new DynamicParameters(); string funcName = "f_rpt_getsql"; p.Add("in_para_group_id", groupId); p.Add("in_type_id", type); p.Add("in_user_id", userId); p.Add("in_user_condition", condition); p.Add("in_user_orderby", orderBy); p.Add("@srtn", 0, DbType.String, ParameterDirection.ReturnValue); var result = conn.Query(funcName, p, null, true, null, CommandType.StoredProcedure).FirstOrDefault(); return(p.Get <string>("@srtn")); } }
/// <summary> /// 重新计算用户的假期余额 /// </summary> /// <param name="resourceId">员工id</param> /// <param name="cate">请假类型</param> /// <param name="effDate">重新计算的生效日期</param> public void ReCalcResourceTimeoffBalance(long resourceId, DTO.CostCode cate, DateTime effDate) { try { using (IDbConnection conn = DapperHelper.BuildConnection()) { var p = new DynamicParameters(); string funcName = "p_ins_timeoff_activity"; p.Add("in_resource", resourceId); p.Add("in_begin", effDate); p.Add("in_cate", (int)cate); conn.Query(funcName, p, null, true, null, CommandType.StoredProcedure); } } catch (Exception e) // 可能超时,超时返回 { return; } }
/// <summary> /// 小窗口钻取的记录数 /// </summary> /// <param name="widgetId"></param> /// <param name="userId"></param> /// <param name="filter"></param> /// <param name="orderby"></param> /// <param name="group1"></param> /// <param name="group2"></param> /// <returns></returns> public int GetWidgetDrillCount(long widgetId, long userId, long?filter, string orderby, string group1, string group2) { if (string.IsNullOrEmpty(orderby)) { orderby = null; } using (IDbConnection conn = DapperHelper.BuildConnection()) { var p = new DynamicParameters(); string funcName = "p_widget_getsql_drill_count"; p.Add("in_widget", widgetId); p.Add("in_user_id", userId); p.Add("in_tab_filer_value", filter); p.Add("in_user_orderby", orderby); p.Add("in_con1", group1); p.Add("in_con2", group2); p.Add("@out_count", 0, DbType.Int32, ParameterDirection.Output); var result = conn.Query(funcName, p, null, true, null, CommandType.StoredProcedure).FirstOrDefault(); return(p.Get <int>("@out_count")); } }
private const int _pageSize = 15; // 默认查询分页大小 public IDbConnection GetDbConn() { OrmConfiguration.DefaultDialect = SqlDialect.MySql; return(DapperHelper.BuildConnection()); }