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