public static function_exists_project_authority_update Get(MAData.Connection con, string process_user_id, string project_id)
{
return(Select(
new MAData.Command(
con,
MAData.Sql.SelectData(
ViewOrFunctionName
), new MAData.Parameter("@process_user_id", process_user_id), new MAData.Parameter("@project_id", project_id)
)
).FirstOrDefault());
}
public static function_admin_user_id Get(MAData.Connection con)
{
return(Select(
new MAData.Command(
con,
MAData.Sql.SelectData(
ViewOrFunctionName
)
)
).FirstOrDefault());
}
public static function_convert_md5 Get(MAData.Connection con, string str)
{
return(Select(
new MAData.Command(
con,
MAData.Sql.SelectData(
ViewOrFunctionName
), new MAData.Parameter("@str", str)
)
).FirstOrDefault());
}
public static List <function_list_user_authorities__authorities_combine> Get(MAData.Connection con, string process_user_id, string user_id, string search_parameter, params MAData.Sql.NameAndOrder[] parameters)
{
return(Select(
new MAData.Command(
con,
MAData.Sql.Select(
ViewOrFunctionName,
MAData.Sql.AllColumns,
orderByCommand: MAData.Sql.OrderByCommand(parameters)
), new MAData.Parameter("@process_user_id", process_user_id), new MAData.Parameter("@user_id", user_id), new MAData.Parameter("@search_parameter", search_parameter)
)
));
}
public static List <function_list_string_split> Get(MAData.Connection con, string sString, string cDelimiter, params MAData.Sql.NameAndOrder[] parameters)
{
return(Select(
new MAData.Command(
con,
MAData.Sql.Select(
ViewOrFunctionName,
MAData.Sql.AllColumns,
orderByCommand: MAData.Sql.OrderByCommand(parameters)
), new MAData.Parameter("@sString", sString), new MAData.Parameter("@cDelimiter", cDelimiter)
)
));
}
public static List <function_list_projects> Get(MAData.Connection con, string process_user_id, string search_parameter, int?startRowIndex, int?endRowIndex, params MAData.Sql.NameAndOrder[] parameters)
{
return(Select(
new MAData.Command(
con,
MAData.Sql.SelectPage(
MAData.Sql.Select(
ViewOrFunctionName,
MAData.Sql.AllColumns
), MAData.Sql.OrderByCommand(parameters), startRowIndex, endRowIndex)
, new MAData.Parameter("@process_user_id", process_user_id), new MAData.Parameter("@search_parameter", search_parameter)
)
));
}
